登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 0

CSL/Genealogy_Manage_System

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
Genealogy_Management_SystemDataSet4.xsd 13.68 KB
一键复制 编辑 原始数据 按行查看 历史
CSL 提交于 2020-07-06 14:29 . Five Commit Version
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
<?xml version="1.0" encoding="utf-8"?>

<xs:schema id="Genealogy_Management_SystemDataSet4" targetNamespace="http://tempuri.org/Genealogy_Management_SystemDataSet4.xsd" xmlns:mstns="http://tempuri.org/Genealogy_Management_SystemDataSet4.xsd" xmlns="http://tempuri.org/Genealogy_Management_SystemDataSet4.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">

  <xs:annotation>

    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">

      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">

        <Connections>

          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Genealogy_Management_SystemConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Genealogy_Management_SystemConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Genealogy_Management_System.Properties.Settings.GlobalReference.Default.Genealogy_Management_SystemConnectionString" Provider="System.Data.SqlClient" />

        </Connections>

        <Tables>

          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MemberTableAdapter" GeneratorDataComponentClassName="MemberTableAdapter" Name="Member" UserDataComponentName="MemberTableAdapter">

            <MainSource>

              <DbSource ConnectionRef="Genealogy_Management_SystemConnectionString (Settings)" DbObjectName="[Genealogy Management System].dbo.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">

                <DeleteCommand>

                  <DbCommand CommandType="Text" ModifiedByUser="false">

                    <CommandText>DELETE FROM [dbo].[Member] WHERE (([M_ID] = @Original_M_ID) AND ((@IsNull_M_Name = 1 AND [M_Name] IS NULL) OR ([M_Name] = @Original_M_Name)) AND ((@IsNull_M_Sex = 1 AND [M_Sex] IS NULL) OR ([M_Sex] = @Original_M_Sex)))</CommandText>

                    <Parameters>

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_M_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_ID" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_M_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="M_Name" SourceColumnNullMapping="true" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_M_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Name" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_M_Sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="M_Sex" SourceColumnNullMapping="true" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_M_Sex" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Sex" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </DeleteCommand>

                <InsertCommand>

                  <DbCommand CommandType="Text" ModifiedByUser="false">

                    <CommandText>INSERT INTO [dbo].[Member] ([M_ID], [M_Name], [M_Sex]) VALUES (@M_ID, @M_Name, @M_Sex);

SELECT M_ID, M_Name, M_Sex FROM Member WHERE (M_ID = @M_ID)</CommandText>

                    <Parameters>

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@M_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_ID" SourceColumnNullMapping="false" SourceVersion="Current" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@M_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Name" SourceColumnNullMapping="false" SourceVersion="Current" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@M_Sex" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Sex" SourceColumnNullMapping="false" SourceVersion="Current" />

                    </Parameters>

                  </DbCommand>

                </InsertCommand>

                <SelectCommand>

                  <DbCommand CommandType="Text" ModifiedByUser="false">

                    <CommandText>SELECT M_ID, M_Name, M_Sex FROM dbo.Member</CommandText>

                    <Parameters />

                  </DbCommand>

                </SelectCommand>

                <UpdateCommand>

                  <DbCommand CommandType="Text" ModifiedByUser="false">

                    <CommandText>UPDATE [dbo].[Member] SET [M_ID] = @M_ID, [M_Name] = @M_Name, [M_Sex] = @M_Sex WHERE (([M_ID] = @Original_M_ID) AND ((@IsNull_M_Name = 1 AND [M_Name] IS NULL) OR ([M_Name] = @Original_M_Name)) AND ((@IsNull_M_Sex = 1 AND [M_Sex] IS NULL) OR ([M_Sex] = @Original_M_Sex)));

SELECT M_ID, M_Name, M_Sex FROM Member WHERE (M_ID = @M_ID)</CommandText>

                    <Parameters>

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@M_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_ID" SourceColumnNullMapping="false" SourceVersion="Current" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@M_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Name" SourceColumnNullMapping="false" SourceVersion="Current" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@M_Sex" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Sex" SourceColumnNullMapping="false" SourceVersion="Current" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_M_ID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_ID" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_M_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="M_Name" SourceColumnNullMapping="true" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_M_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Name" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_M_Sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="M_Sex" SourceColumnNullMapping="true" SourceVersion="Original" />

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_M_Sex" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="M_Sex" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </UpdateCommand>

              </DbSource>

            </MainSource>

            <Mappings>

              <Mapping SourceColumn="M_ID" DataSetColumn="M_ID" />

              <Mapping SourceColumn="M_Name" DataSetColumn="M_Name" />

              <Mapping SourceColumn="M_Sex" DataSetColumn="M_Sex" />

            </Mappings>

            <Sources>

              <DbSource ConnectionRef="Genealogy_Management_SystemConnectionString (Settings)" DbObjectName="[Genealogy Management System].dbo.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">

                <SelectCommand>

                  <DbCommand CommandType="Text" ModifiedByUser="false">

                    <CommandText>SELECT  M_ID, M_Name, M_Sex

FROM     Member

WHERE   (G_ID =

                   (SELECT  G_ID

                   FROM     Member AS Member_1

                   WHERE   (M_ID = '"+Globaldate.ID+"')))</CommandText>

                    <Parameters />

                  </DbCommand>

                </SelectCommand>

              </DbSource>

              <DbSource ConnectionRef="Genealogy_Management_SystemConnectionString (Settings)" DbObjectName="[Genealogy Management System].dbo.Member" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy1" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillBy1">

                <SelectCommand>

                  <DbCommand CommandType="Text" ModifiedByUser="false">

                    <CommandText>SELECT  M_ID, M_Name, M_Sex

FROM     Member

WHERE   (G_ID =

                   (SELECT  G_ID

                   FROM     Member AS Member_1

                   WHERE   (M_ID = '"+Globaldate.ID+"')))</CommandText>

                    <Parameters />

                  </DbCommand>

                </SelectCommand>

              </DbSource>

            </Sources>

          </TableAdapter>

        </Tables>

        <Sources />

      </DataSource>

    </xs:appinfo>

  </xs:annotation>

  <xs:element name="Genealogy_Management_SystemDataSet4" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Genealogy_Management_SystemDataSet4" msprop:Generator_UserDSName="Genealogy_Management_SystemDataSet4">

    <xs:complexType>

      <xs:choice minOccurs="0" maxOccurs="unbounded">

        <xs:element name="Member" msprop:Generator_TableClassName="MemberDataTable" msprop:Generator_TableVarName="tableMember" msprop:Generator_RowChangedName="MemberRowChanged" msprop:Generator_TablePropName="Member" msprop:Generator_RowDeletingName="MemberRowDeleting" msprop:Generator_RowChangingName="MemberRowChanging" msprop:Generator_RowEvHandlerName="MemberRowChangeEventHandler" msprop:Generator_RowDeletedName="MemberRowDeleted" msprop:Generator_RowClassName="MemberRow" msprop:Generator_UserTableName="Member" msprop:Generator_RowEvArgName="MemberRowChangeEvent">

          <xs:complexType>

            <xs:sequence>

              <xs:element name="M_ID" msprop:Generator_ColumnVarNameInTable="columnM_ID" msprop:Generator_ColumnPropNameInRow="M_ID" msprop:Generator_ColumnPropNameInTable="M_IDColumn" msprop:Generator_UserColumnName="M_ID">

                <xs:simpleType>

                  <xs:restriction base="xs:string">

                    <xs:maxLength value="15" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="M_Name" msprop:Generator_ColumnVarNameInTable="columnM_Name" msprop:Generator_ColumnPropNameInRow="M_Name" msprop:Generator_ColumnPropNameInTable="M_NameColumn" msprop:Generator_UserColumnName="M_Name" minOccurs="0">

                <xs:simpleType>

                  <xs:restriction base="xs:string">

                    <xs:maxLength value="10" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="M_Sex" msprop:Generator_ColumnVarNameInTable="columnM_Sex" msprop:Generator_ColumnPropNameInRow="M_Sex" msprop:Generator_ColumnPropNameInTable="M_SexColumn" msprop:Generator_UserColumnName="M_Sex" minOccurs="0">

                <xs:simpleType>

                  <xs:restriction base="xs:string">

                    <xs:maxLength value="2" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

            </xs:sequence>

          </xs:complexType>

        </xs:element>

      </xs:choice>

    </xs:complexType>

    <xs:unique name="Constraint1" msdata:PrimaryKey="true">

      <xs:selector xpath=".//mstns:Member" />

      <xs:field xpath="mstns:M_ID" />

    </xs:unique>

  </xs:element>

</xs:schema>
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
C#
1
https://gitee.com/cai_shuanglian/Genealogy_Manage_System.git
git@gitee.com:cai_shuanglian/Genealogy_Manage_System.git
cai_shuanglian
Genealogy_Manage_System
Genealogy_Manage_System
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部