📄 dataset_tables.xsd

📁 以前为一家4S店开发的维修管理及客户管理的软件,C#开发!
💻 XSD
📖 第 1 页 / 共 5 页
字号:
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Statusname" DataSetColumn="Statusname" />
              <Mapping SourceColumn="Statusscript" DataSetColumn="Statusscript" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SourcescriptTableAdapter" GeneratorDataComponentClassName="SourcescriptTableAdapter" Name="Sourcescript" UserDataComponentName="SourcescriptTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.Sourcescript" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Sourcescript] WHERE (([Id] = @Original_Id) AND ((@IsNull_Sourcename = 1 AND [Sourcename] IS NULL) OR ([Sourcename] = @Original_Sourcename)) AND ((@IsNull_Sourcescript = 1 AND [Sourcescript] IS NULL) OR ([Sourcescript] = @Original_Sourcescript)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sourcename" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sourcename" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcename" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sourcescript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sourcescript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sourcescript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcescript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Sourcescript] ([Sourcename], [Sourcescript]) VALUES (@Sourcename, @Sourcescript);
SELECT Id, Sourcename, Sourcescript FROM Sourcescript WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sourcescript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcescript" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Sourcename, Sourcescript
FROM Sourcescript
WHERE (Sourcename LIKE @sourcename)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="sourcename" ColumnName="Sourcename" DataSourceName="mmerp.dbo.Sourcescript" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Sourcename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Sourcescript] SET [Sourcename] = @Sourcename, [Sourcescript] = @Sourcescript WHERE (([Id] = @Original_Id) AND ((@IsNull_Sourcename = 1 AND [Sourcename] IS NULL) OR ([Sourcename] = @Original_Sourcename)) AND ((@IsNull_Sourcescript = 1 AND [Sourcescript] IS NULL) OR ([Sourcescript] = @Original_Sourcescript)));
SELECT Id, Sourcename, Sourcescript FROM Sourcescript WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Sourcescript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcescript" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sourcename" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sourcename" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sourcename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcename" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sourcescript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sourcescript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Sourcescript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Sourcescript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="mmerp.dbo.Sourcescript" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Sourcename" DataSetColumn="Sourcename" />
              <Mapping SourceColumn="Sourcescript" DataSetColumn="Sourcescript" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vistforTableAdapter" GeneratorDataComponentClassName="vistforTableAdapter" Name="vistfor" UserDataComponentName="vistforTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.vistfor" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [vistfor] WHERE (([id] = @Original_id) AND ((@IsNull_forname = 1 AND [forname] IS NULL) OR ([forname] = @Original_forname)) AND ((@IsNull_forscript = 1 AND [forscript] IS NULL) OR ([forscript] = @Original_forscript)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_forname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="forname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_forname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="forname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_forscript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="forscript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_forscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="forscript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [vistfor] ([forname], [forscript]) VALUES (@forname, @forscript);
SELECT id, forname, forscript FROM vistfor WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@forname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="forname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -