📄 dataset_tables.xsd

📁 以前为一家4S店开发的维修管理及客户管理的软件,C#开发!
💻 XSD
📖 第 1 页 / 共 5 页
字号:
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ID, Ctypename, TypeDescript
FROM customertype
WHERE (Ctypename LIKE @ctypename)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="ctypename" ColumnName="Ctypename" DataSourceName="mmerp.dbo.customertype" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@ctypename" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Ctypename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [customertype] SET [Ctypename] = @Ctypename, [TypeDescript] = @TypeDescript WHERE (([ID] = @Original_ID) AND ((@IsNull_Ctypename = 1 AND [Ctypename] IS NULL) OR ([Ctypename] = @Original_Ctypename)) AND ((@IsNull_TypeDescript = 1 AND [TypeDescript] IS NULL) OR ([TypeDescript] = @Original_TypeDescript)));
SELECT ID, Ctypename, TypeDescript FROM customertype WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ctypename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ctypename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TypeDescript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TypeDescript" 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_Ctypename" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ctypename" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ctypename" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ctypename" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypeDescript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeDescript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TypeDescript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TypeDescript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="ID" DataSourceName="mmerp.dbo.customertype" 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="Ctypename" DataSetColumn="Ctypename" />
              <Mapping SourceColumn="TypeDescript" DataSetColumn="TypeDescript" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="salestatusTableAdapter" GeneratorDataComponentClassName="salestatusTableAdapter" Name="salestatus" UserDataComponentName="salestatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.salestatus" 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 [salestatus] WHERE (([Id] = @Original_Id) AND ((@IsNull_Statusname = 1 AND [Statusname] IS NULL) OR ([Statusname] = @Original_Statusname)) AND ((@IsNull_Statusscript = 1 AND [Statusscript] IS NULL) OR ([Statusscript] = @Original_Statusscript)))</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_Statusname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Statusname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Statusname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Statusscript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Statusscript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Statusscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusscript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [salestatus] ([Statusname], [Statusscript]) VALUES (@Statusname, @Statusscript);
SELECT Id, Statusname, Statusscript FROM salestatus WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Statusname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Statusscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusscript" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Statusname, Statusscript
FROM salestatus
WHERE (Statusname LIKE @statusname)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="statusname" ColumnName="Statusname" DataSourceName="mmerp.dbo.salestatus" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@statusname" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Statusname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [salestatus] SET [Statusname] = @Statusname, [Statusscript] = @Statusscript WHERE (([Id] = @Original_Id) AND ((@IsNull_Statusname = 1 AND [Statusname] IS NULL) OR ([Statusname] = @Original_Statusname)) AND ((@IsNull_Statusscript = 1 AND [Statusscript] IS NULL) OR ([Statusscript] = @Original_Statusscript)));
SELECT Id, Statusname, Statusscript FROM salestatus WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Statusname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Statusscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusscript" 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_Statusname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Statusname" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Statusname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusname" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Statusscript" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Statusscript" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Statusscript" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Statusscript" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="mmerp.dbo.salestatus" 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>
⌨️ 快捷键说明

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