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

痴者工良 / 学生选课管理系统

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

<xs:schema id="系部数据" targetNamespace="http://tempuri.org/系部数据.xsd" xmlns:mstns="http://tempuri.org/系部数据.xsd" xmlns="http://tempuri.org/系部数据.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="XKDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="XKDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.xk.Properties.Settings.GlobalReference.Default.XKDBConnectionString" Provider="System.Data.SqlClient" />

        </Connections>

        <Tables>

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

            <MainSource>

              <DbSource ConnectionRef="XKDBConnectionString (Settings)" DbObjectName="XKDB.dbo.Departmrnt" 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].[Departmrnt] WHERE (([Departno] = @Original_Departno) AND ([Departname] = @Original_Departname))</CommandText>

                    <Parameters>

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Departno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Departno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Departname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Departname" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </DeleteCommand>

                <InsertCommand>

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

                    <CommandText>INSERT INTO [dbo].[Departmrnt] ([Departno], [Departname]) VALUES (@Departno, @Departname);

SELECT Departno, Departname FROM Departmrnt WHERE (Departno = @Departno)</CommandText>

                    <Parameters>

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

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

                    </Parameters>

                  </DbCommand>

                </InsertCommand>

                <SelectCommand>

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

                    <CommandText>SELECT Departno, Departname FROM dbo.Departmrnt</CommandText>

                    <Parameters />

                  </DbCommand>

                </SelectCommand>

                <UpdateCommand>

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

                    <CommandText>UPDATE [dbo].[Departmrnt] SET [Departno] = @Departno, [Departname] = @Departname WHERE (([Departno] = @Original_Departno) AND ([Departname] = @Original_Departname));

SELECT Departno, Departname FROM Departmrnt WHERE (Departno = @Departno)</CommandText>

                    <Parameters>

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

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

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Departno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Departno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Departname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Departname" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </UpdateCommand>

              </DbSource>

            </MainSource>

            <Mappings>

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

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

            </Mappings>

            <Sources />

          </TableAdapter>

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

            <MainSource>

              <DbSource ConnectionRef="XKDBConnectionString (Settings)" DbObjectName="XKDB.dbo.Class" 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].[Class] WHERE (([Classno] = @Original_Classno) AND ([Departno] = @Original_Departno) AND ([Classname] = @Original_Classname))</CommandText>

                    <Parameters>

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Classno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Classno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Departno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Departno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Classname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Classname" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </DeleteCommand>

                <InsertCommand>

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

                    <CommandText>INSERT INTO [dbo].[Class] ([Classno], [Departno], [Classname]) VALUES (@Classno, @Departno, @Classname);

SELECT Classno, Departno, Classname FROM Class WHERE (Classno = @Classno)</CommandText>

                    <Parameters>

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

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

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

                    </Parameters>

                  </DbCommand>

                </InsertCommand>

                <SelectCommand>

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

                    <CommandText>SELECT Classno, Departno, Classname FROM dbo.Class</CommandText>

                    <Parameters />

                  </DbCommand>

                </SelectCommand>

                <UpdateCommand>

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

                    <CommandText>UPDATE [dbo].[Class] SET [Classno] = @Classno, [Departno] = @Departno, [Classname] = @Classname WHERE (([Classno] = @Original_Classno) AND ([Departno] = @Original_Departno) AND ([Classname] = @Original_Classname));

SELECT Classno, Departno, Classname FROM Class WHERE (Classno = @Classno)</CommandText>

                    <Parameters>

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

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

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

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Classno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Classno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Departno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Departno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Classname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Classname" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </UpdateCommand>

              </DbSource>

            </MainSource>

            <Mappings>

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

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

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

            </Mappings>

            <Sources />

          </TableAdapter>

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

            <MainSource>

              <DbSource ConnectionRef="XKDBConnectionString (Settings)" DbObjectName="XKDB.dbo.Student" 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].[Student] WHERE (([Stuno] = @Original_Stuno) AND ([Classno] = @Original_Classno) AND ([Stuname] = @Original_Stuname) AND ([Sex] = @Original_Sex) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ([Pwd] = @Original_Pwd))</CommandText>

                    <Parameters>

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Stuno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Stuno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Classno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Classno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Stuname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Stuname" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />

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

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Birthday" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pwd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pwd" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </DeleteCommand>

                <InsertCommand>

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

                    <CommandText>INSERT INTO [dbo].[Student] ([Stuno], [Classno], [Stuname], [Sex], [Birthday], [Pwd]) VALUES (@Stuno, @Classno, @Stuname, @Sex, @Birthday, @Pwd);

SELECT Stuno, Classno, Stuname, Sex, Birthday, Pwd FROM Student WHERE (Stuno = @Stuno)</CommandText>

                    <Parameters>

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

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

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

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

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

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

                    </Parameters>

                  </DbCommand>

                </InsertCommand>

                <SelectCommand>

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

                    <CommandText>SELECT Stuno, Classno, Stuname, Sex, Birthday, Pwd FROM dbo.Student</CommandText>

                    <Parameters />

                  </DbCommand>

                </SelectCommand>

                <UpdateCommand>

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

                    <CommandText>UPDATE [dbo].[Student] SET [Stuno] = @Stuno, [Classno] = @Classno, [Stuname] = @Stuname, [Sex] = @Sex, [Birthday] = @Birthday, [Pwd] = @Pwd WHERE (([Stuno] = @Original_Stuno) AND ([Classno] = @Original_Classno) AND ([Stuname] = @Original_Stuname) AND ([Sex] = @Original_Sex) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ([Pwd] = @Original_Pwd));

SELECT Stuno, Classno, Stuname, Sex, Birthday, Pwd FROM Student WHERE (Stuno = @Stuno)</CommandText>

                    <Parameters>

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

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

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

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

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

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

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Stuno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Stuno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Classno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Classno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Stuname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Stuname" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />

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

                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Birthday" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Pwd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Pwd" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </UpdateCommand>

              </DbSource>

            </MainSource>

            <Mappings>

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

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

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

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

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

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

            </Mappings>

            <Sources />

          </TableAdapter>

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

            <MainSource>

              <DbSource ConnectionRef="XKDBConnectionString (Settings)" DbObjectName="XKDB.dbo.Course" 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 [Course] WHERE (([Couno] = @Original_Couno) AND ([Couname] = @Original_Couname) AND ([Credit] = @Original_Credit) AND ([Limitnum] = @Original_Limitnum))</CommandText>

                    <Parameters>

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Couno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Couno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Couname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Couname" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Credit" Precision="3" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Limitnum" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Limitnum" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </DeleteCommand>

                <InsertCommand>

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

                    <CommandText>INSERT INTO [Course] ([Couno], [Couname], [Credit], [Limitnum]) VALUES (@Couno, @Couname, @Credit, @Limitnum);

SELECT Couno, Couname, Credit, Limitnum FROM Course WHERE (Couno = @Couno)</CommandText>

                    <Parameters>

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

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

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Credit" Precision="3" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Current" />

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

                    </Parameters>

                  </DbCommand>

                </InsertCommand>

                <SelectCommand>

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

                    <CommandText>SELECT Course.*

FROM Course</CommandText>

                    <Parameters />

                  </DbCommand>

                </SelectCommand>

                <UpdateCommand>

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

                    <CommandText>UPDATE [Course] SET [Couno] = @Couno, [Couname] = @Couname, [Credit] = @Credit, [Limitnum] = @Limitnum WHERE (([Couno] = @Original_Couno) AND ([Couname] = @Original_Couname) AND ([Credit] = @Original_Credit) AND ([Limitnum] = @Original_Limitnum));

SELECT Couno, Couname, Credit, Limitnum FROM Course WHERE (Couno = @Couno)</CommandText>

                    <Parameters>

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

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

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Credit" Precision="3" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Current" />

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

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Couno" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Couno" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Couname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Couname" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Credit" Precision="3" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Original" />

                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Limitnum" Precision="5" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Limitnum" SourceColumnNullMapping="false" SourceVersion="Original" />

                    </Parameters>

                  </DbCommand>

                </UpdateCommand>

              </DbSource>

            </MainSource>

            <Mappings>

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

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

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

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

            </Mappings>

            <Sources />

          </TableAdapter>

        </Tables>

        <Sources />

      </DataSource>

    </xs:appinfo>

  </xs:annotation>

  <xs:element name="系部数据" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="系部数据" msprop:Generator_UserDSName="系部数据">

    <xs:complexType>

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

        <xs:element name="Departmrnt" msprop:Generator_TableClassName="DepartmrntDataTable" msprop:Generator_TableVarName="tableDepartmrnt" msprop:Generator_RowChangedName="DepartmrntRowChanged" msprop:Generator_TablePropName="Departmrnt" msprop:Generator_RowDeletingName="DepartmrntRowDeleting" msprop:Generator_RowChangingName="DepartmrntRowChanging" msprop:Generator_RowEvHandlerName="DepartmrntRowChangeEventHandler" msprop:Generator_RowDeletedName="DepartmrntRowDeleted" msprop:Generator_RowClassName="DepartmrntRow" msprop:Generator_UserTableName="Departmrnt" msprop:Generator_RowEvArgName="DepartmrntRowChangeEvent">

          <xs:complexType>

            <xs:sequence>

              <xs:element name="Departno" msprop:Generator_ColumnVarNameInTable="columnDepartno" msprop:Generator_ColumnPropNameInRow="Departno" msprop:Generator_ColumnPropNameInTable="DepartnoColumn" msprop:Generator_UserColumnName="Departno">

                <xs:simpleType>

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

                    <xs:maxLength value="2" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Departname" msprop:Generator_ColumnVarNameInTable="columnDepartname" msprop:Generator_ColumnPropNameInRow="Departname" msprop:Generator_ColumnPropNameInTable="DepartnameColumn" msprop:Generator_UserColumnName="Departname">

                <xs:simpleType>

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

                    <xs:maxLength value="20" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

            </xs:sequence>

          </xs:complexType>

        </xs:element>

        <xs:element name="Class" msprop:Generator_TableClassName="ClassDataTable" msprop:Generator_TableVarName="tableClass" msprop:Generator_TablePropName="Class" msprop:Generator_RowDeletingName="ClassRowDeleting" msprop:Generator_RowChangingName="ClassRowChanging" msprop:Generator_RowEvHandlerName="ClassRowChangeEventHandler" msprop:Generator_RowDeletedName="ClassRowDeleted" msprop:Generator_UserTableName="Class" msprop:Generator_RowChangedName="ClassRowChanged" msprop:Generator_RowEvArgName="ClassRowChangeEvent" msprop:Generator_RowClassName="ClassRow">

          <xs:complexType>

            <xs:sequence>

              <xs:element name="Classno" msprop:Generator_ColumnVarNameInTable="columnClassno" msprop:Generator_ColumnPropNameInRow="Classno" msprop:Generator_ColumnPropNameInTable="ClassnoColumn" msprop:Generator_UserColumnName="Classno">

                <xs:simpleType>

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

                    <xs:maxLength value="8" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Departno" msprop:Generator_ColumnVarNameInTable="columnDepartno" msprop:Generator_ColumnPropNameInRow="Departno" msprop:Generator_ColumnPropNameInTable="DepartnoColumn" msprop:Generator_UserColumnName="Departno">

                <xs:simpleType>

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

                    <xs:maxLength value="2" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Classname" msprop:Generator_ColumnVarNameInTable="columnClassname" msprop:Generator_ColumnPropNameInRow="Classname" msprop:Generator_ColumnPropNameInTable="ClassnameColumn" msprop:Generator_UserColumnName="Classname">

                <xs:simpleType>

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

                    <xs:maxLength value="20" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

            </xs:sequence>

          </xs:complexType>

        </xs:element>

        <xs:element name="Student" msprop:Generator_TableClassName="StudentDataTable" msprop:Generator_TableVarName="tableStudent" msprop:Generator_TablePropName="Student" msprop:Generator_RowDeletingName="StudentRowDeleting" msprop:Generator_RowChangingName="StudentRowChanging" msprop:Generator_RowEvHandlerName="StudentRowChangeEventHandler" msprop:Generator_RowDeletedName="StudentRowDeleted" msprop:Generator_UserTableName="Student" msprop:Generator_RowChangedName="StudentRowChanged" msprop:Generator_RowEvArgName="StudentRowChangeEvent" msprop:Generator_RowClassName="StudentRow">

          <xs:complexType>

            <xs:sequence>

              <xs:element name="Stuno" msprop:Generator_ColumnVarNameInTable="columnStuno" msprop:Generator_ColumnPropNameInRow="Stuno" msprop:Generator_ColumnPropNameInTable="StunoColumn" msprop:Generator_UserColumnName="Stuno">

                <xs:simpleType>

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

                    <xs:maxLength value="8" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Classno" msprop:Generator_ColumnVarNameInTable="columnClassno" msprop:Generator_ColumnPropNameInRow="Classno" msprop:Generator_ColumnPropNameInTable="ClassnoColumn" msprop:Generator_UserColumnName="Classno">

                <xs:simpleType>

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

                    <xs:maxLength value="8" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Stuname" msprop:Generator_ColumnVarNameInTable="columnStuname" msprop:Generator_ColumnPropNameInRow="Stuname" msprop:Generator_ColumnPropNameInTable="StunameColumn" msprop:Generator_UserColumnName="Stuname">

                <xs:simpleType>

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

                    <xs:maxLength value="10" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnPropNameInTable="SexColumn" msprop:Generator_UserColumnName="Sex">

                <xs:simpleType>

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

                    <xs:maxLength value="1" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Birthday" msprop:Generator_ColumnVarNameInTable="columnBirthday" msprop:Generator_ColumnPropNameInRow="Birthday" msprop:Generator_ColumnPropNameInTable="BirthdayColumn" msprop:Generator_UserColumnName="Birthday" type="xs:dateTime" minOccurs="0" />

              <xs:element name="Pwd" msprop:Generator_ColumnVarNameInTable="columnPwd" msprop:Generator_ColumnPropNameInRow="Pwd" msprop:Generator_ColumnPropNameInTable="PwdColumn" msprop:Generator_UserColumnName="Pwd">

                <xs:simpleType>

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

                    <xs:maxLength value="8" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

            </xs:sequence>

          </xs:complexType>

        </xs:element>

        <xs:element name="Course" msprop:Generator_TableClassName="CourseDataTable" msprop:Generator_TableVarName="tableCourse" msprop:Generator_TablePropName="Course" msprop:Generator_RowDeletingName="CourseRowDeleting" msprop:Generator_RowChangingName="CourseRowChanging" msprop:Generator_RowEvHandlerName="CourseRowChangeEventHandler" msprop:Generator_RowDeletedName="CourseRowDeleted" msprop:Generator_UserTableName="Course" msprop:Generator_RowChangedName="CourseRowChanged" msprop:Generator_RowEvArgName="CourseRowChangeEvent" msprop:Generator_RowClassName="CourseRow">

          <xs:complexType>

            <xs:sequence>

              <xs:element name="Couno" msprop:Generator_ColumnVarNameInTable="columnCouno" msprop:Generator_ColumnPropNameInRow="Couno" msprop:Generator_ColumnPropNameInTable="CounoColumn" msprop:Generator_UserColumnName="Couno">

                <xs:simpleType>

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

                    <xs:maxLength value="3" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Couname" msprop:Generator_ColumnVarNameInTable="columnCouname" msprop:Generator_ColumnPropNameInRow="Couname" msprop:Generator_ColumnPropNameInTable="CounameColumn" msprop:Generator_UserColumnName="Couname">

                <xs:simpleType>

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

                    <xs:maxLength value="30" />

                  </xs:restriction>

                </xs:simpleType>

              </xs:element>

              <xs:element name="Credit" msprop:Generator_ColumnVarNameInTable="columnCredit" msprop:Generator_ColumnPropNameInRow="Credit" msprop:Generator_ColumnPropNameInTable="CreditColumn" msprop:Generator_UserColumnName="Credit" type="xs:decimal" />

              <xs:element name="Limitnum" msprop:Generator_ColumnVarNameInTable="columnLimitnum" msprop:Generator_ColumnPropNameInRow="Limitnum" msprop:Generator_ColumnPropNameInTable="LimitnumColumn" msprop:Generator_UserColumnName="Limitnum" type="xs:decimal" />

            </xs:sequence>

          </xs:complexType>

        </xs:element>

      </xs:choice>

    </xs:complexType>

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

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

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

    </xs:unique>

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

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

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

    </xs:unique>

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

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

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

    </xs:unique>

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

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

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

    </xs:unique>

  </xs:element>

  <xs:annotation>

    <xs:appinfo>

      <msdata:Relationship name="Departmrnt_Class" msdata:parent="Departmrnt" msdata:child="Class" msdata:parentkey="Departno" msdata:childkey="Departno" msprop:Generator_UserChildTable="Class" msprop:Generator_ChildPropName="GetClassRows" msprop:Generator_UserRelationName="Departmrnt_Class" msprop:Generator_ParentPropName="DepartmrntRow" msprop:Generator_RelationVarName="relationDepartmrnt_Class" msprop:Generator_UserParentTable="Departmrnt" />

      <msdata:Relationship name="Fk2" msdata:parent="Class" msdata:child="Student" msdata:parentkey="Classno" msdata:childkey="Classno" msprop:Generator_UserChildTable="Student" msprop:Generator_ChildPropName="GetStudentRows" msprop:Generator_UserRelationName="Fk2" msprop:Generator_ParentPropName="ClassRow" msprop:Generator_RelationVarName="relationFk2" msprop:Generator_UserParentTable="Class" />

    </xs:appinfo>

  </xs:annotation>

</xs:schema>
C#
1
https://gitee.com/whuanle/xkgl.git
git@gitee.com:whuanle/xkgl.git
whuanle
xkgl
学生选课管理系统
master
点此查找更多帮助

搜索帮助

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