dataset_tables.xsd

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

                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@forscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="forscript" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT id, forname, forscript
FROM vistfor
WHERE (forname LIKE @forname)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="forname" ColumnName="forname" DataSourceName="mmerp.dbo.vistfor" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@forname" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="forname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [vistfor] SET [forname] = @forname, [forscript] = @forscript 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)));
SELECT id, forname, forscript FROM vistfor WHERE (id = @id)</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>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@forscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="forscript" 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_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>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="mmerp.dbo.vistfor" 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="forname" DataSetColumn="forname" />
              <Mapping SourceColumn="forscript" DataSetColumn="forscript" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="caruseTableAdapter" GeneratorDataComponentClassName="caruseTableAdapter" Name="caruse" UserDataComponentName="caruseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.caruse" 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 [caruse] WHERE (([ID] = @Original_ID) AND ((@IsNull_usename = 1 AND [usename] IS NULL) OR ([usename] = @Original_usename)) AND ((@IsNull_script = 1 AND [script] IS NULL) OR ([script] = @Original_script)))</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_usename" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usename" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_usename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="usename" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_script" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="script" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_script" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="script" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [caruse] ([usename], [script]) VALUES (@usename, @script);
SELECT ID, usename, script FROM caruse WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@usename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="usename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@script" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="script" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ID, usename, script
FROM caruse
WHERE (usename LIKE @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="username" ColumnName="usename" DataSourceName="mmerp.dbo.caruse" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="usename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [caruse] SET [usename] = @usename, [script] = @script WHERE (([ID] = @Original_ID) AND ((@IsNull_usename = 1 AND [usename] IS NULL) OR ([usename] = @Original_usename)) AND ((@IsNull_script = 1 AND [script] IS NULL) OR ([script] = @Original_script)));
SELECT ID, usename, script FROM caruse WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@usename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="usename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@script" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="script" 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_usename" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usename" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_usename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="usename" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_script" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="script" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_script" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="script" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="ID" DataSourceName="mmerp.dbo.caruse" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>