dataset_tables.xsd

以前为一家4S店开发的维修管理及客户管理的软件,C#开发!

                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="usename" DataSetColumn="usename" />
              <Mapping SourceColumn="script" DataSetColumn="script" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="visttypeTableAdapter" GeneratorDataComponentClassName="visttypeTableAdapter" Name="visttype" UserDataComponentName="visttypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.visttype" 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 [visttype] WHERE (([id] = @Original_id) AND ((@IsNull_vistname = 1 AND [vistname] IS NULL) OR ([vistname] = @Original_vistname)) AND ((@IsNull_vistscript = 1 AND [vistscript] IS NULL) OR ([vistscript] = @Original_vistscript)))</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_vistname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vistname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vistname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vistscript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vistscript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vistscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistscript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [visttype] ([vistname], [vistscript]) VALUES (@vistname, @vistscript);
SELECT id, vistname, vistscript FROM visttype WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vistname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vistscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistscript" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT id, vistname, vistscript
FROM visttype
WHERE (vistname LIKE @vistname)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="vistname" ColumnName="vistname" DataSourceName="mmerp.dbo.visttype" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@vistname" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="vistname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [visttype] SET [vistname] = @vistname, [vistscript] = @vistscript WHERE (([id] = @Original_id) AND ((@IsNull_vistname = 1 AND [vistname] IS NULL) OR ([vistname] = @Original_vistname)) AND ((@IsNull_vistscript = 1 AND [vistscript] IS NULL) OR ([vistscript] = @Original_vistscript)));
SELECT id, vistname, vistscript FROM visttype WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vistname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@vistscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistscript" 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_vistname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vistname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vistname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vistscript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vistscript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_vistscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="vistscript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="mmerp.dbo.visttype" 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="vistname" DataSetColumn="vistname" />
              <Mapping SourceColumn="vistscript" DataSetColumn="vistscript" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="gradeTableAdapter" GeneratorDataComponentClassName="gradeTableAdapter" Name="grade" UserDataComponentName="gradeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.grade" 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 [grade] WHERE (([Id] = @Original_Id) AND ([gradename] = @Original_gradename) AND ([gardevalue] = @Original_gardevalue))</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="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_gradename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gradename" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_gardevalue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gardevalue" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [grade] ([gradename], [gardevalue]) VALUES (@gradename, @gardevalue);
SELECT Id, gradename, gardevalue FROM grade WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@gradename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="gradename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@gardevalue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gardevalue" SourceColumnNullMapping="False" SourceVersion