dataset_views.xsd

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

              <Mapping SourceColumn="customersugust" DataSetColumn="customersugust" />
              <Mapping SourceColumn="preid" DataSetColumn="preid" />
              <Mapping SourceColumn="isvisted" DataSetColumn="isvisted" />
              <Mapping SourceColumn="isfinished" DataSetColumn="isfinished" />
              <Mapping SourceColumn="BName" DataSetColumn="BName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairbtypeTableAdapter" GeneratorDataComponentClassName="v_repairbtypeTableAdapter" Name="v_repairbtype" UserDataComponentName="v_repairbtypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairbtype" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT qty, ptypefavour, itemconst, itemfavour, ptypeconst, bcode1, bname1, itemprice, ptypetotal, [1] FROM dbo.v_repairbtype</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="qty" DataSetColumn="qty" />
              <Mapping SourceColumn="ptypefavour" DataSetColumn="ptypefavour" />
              <Mapping SourceColumn="itemconst" DataSetColumn="itemconst" />
              <Mapping SourceColumn="itemfavour" DataSetColumn="itemfavour" />
              <Mapping SourceColumn="ptypeconst" DataSetColumn="ptypeconst" />
              <Mapping SourceColumn="bcode1" DataSetColumn="bcode1" />
              <Mapping SourceColumn="bname1" DataSetColumn="bname1" />
              <Mapping SourceColumn="itemprice" DataSetColumn="itemprice" />
              <Mapping SourceColumn="ptypetotal" DataSetColumn="ptypetotal" />
              <Mapping SourceColumn="1" DataSetColumn="1" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairconstTableAdapter" GeneratorDataComponentClassName="v_repairconstTableAdapter" Name="v_repairconst" UserDataComponentName="v_repairconstTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairconst" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT prerepairid, timeconst, timefavour, typeconst, typefavour FROM dbo.v_repairconst</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="timeconst" DataSetColumn="timeconst" />
              <Mapping SourceColumn="timefavour" DataSetColumn="timefavour" />
              <Mapping SourceColumn="typeconst" DataSetColumn="typeconst" />
              <Mapping SourceColumn="typefavour" DataSetColumn="typefavour" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairitemsumTableAdapter" GeneratorDataComponentClassName="v_repairitemsumTableAdapter" Name="v_repairitemsum" UserDataComponentName="v_repairitemsumTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairitemsum" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT prerepairid, paytype, favour, itemprice, const, redflag, rateprice, custitprice, custitfavour FROM dbo.v_repairitemsum</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="paytype" DataSetColumn="paytype" />
              <Mapping SourceColumn="favour" DataSetColumn="favour" />
              <Mapping SourceColumn="itemprice" DataSetColumn="itemprice" />
              <Mapping SourceColumn="const" DataSetColumn="const" />
              <Mapping SourceColumn="redflag" DataSetColumn="redflag" />
              <Mapping SourceColumn="rateprice" DataSetColumn="rateprice" />
              <Mapping SourceColumn="custitprice" DataSetColumn="custitprice" />
              <Mapping SourceColumn="custitfavour" DataSetColumn="custitfavour" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairmainTableAdapter" GeneratorDataComponentClassName="v_repairmainTableAdapter" Name="v_repairmain" UserDataComponentName="v_repairmainTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairmain" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT employeeid, totalmoney, repairitemtotal, repairMaterialstotal, preferencemoney, prerepairid, qty, customerid, carcarck, carno, indate, outdate, opemployeeid, repairtype, billnumberid, employeename, opemployeename, itemconst, ptypeconst, customername, display FROM dbo.v_repairmain</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="employeeid" DataSetColumn="employeeid" />
              <Mapping SourceColumn="totalmoney" DataSetColumn="totalmoney" />
              <Mapping SourceColumn="repairitemtotal" DataSetColumn="repairitemtotal" />
              <Mapping SourceColumn="repairMaterialstotal" DataSetColumn="repairMaterialstotal" />
              <Mapping SourceColumn="preferencemoney" DataSetColumn="preferencemoney" />
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="qty" DataSetColumn="qty" />
              <Mapping SourceColumn="customerid" DataSetColumn="customerid" />
              <Mapping SourceColumn="carcarck" DataSetColumn="carcarck" />
              <Mapping SourceColumn="carno" DataSetColumn="carno" />
              <Mapping SourceColumn="indate" DataSetColumn="indate" />
              <Mapping SourceColumn="outdate" DataSetColumn="outdate" />
              <Mapping SourceColumn="opemployeeid" DataSetColumn="opemployeeid" />
              <Mapping SourceColumn="repairtype" DataSetColumn="repairtype" />
              <Mapping SourceColumn="billnumberid" DataSetColumn="billnumberid" />
              <Mapping SourceColumn="employeename" DataSetColumn="employeename" />
              <Mapping SourceColumn="opemployeename" DataSetColumn="opemployeename" />
              <Mapping SourceColumn="itemconst" DataSetColumn="itemconst" />
              <Mapping SourceColumn="ptypeconst" DataSetColumn="ptypeconst" />
              <Mapping SourceColumn="customername" DataSetColumn="customername" />
              <Mapping SourceColumn="display" DataSetColumn="display" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairmaintotalTableAdapter" GeneratorDataComponentClassName="v_repairmaintotalTableAdapter" Name="v_repairmaintotal" UserDataComponentName="v_repairmaintotalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairmaintotal" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT prerepairid, favour, totalmoney, paytype, itemprice, rateprice, ptypeconst, custtotal, custfavour FROM dbo.v_repairmaintotal</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="favour" DataSetColumn="favour" />
              <Mapping SourceColumn="totalmoney" DataSetColumn="totalmoney" />
              <Mapping SourceColumn="paytype" DataSetColumn="paytype" />
              <Mapping SourceColumn="itemprice" DataSetColumn="itemprice" />
              <Mapping SourceColumn="rateprice" DataSetColumn="rateprice" />
              <Mapping SourceColumn="ptypeconst" DataSetColumn="ptypeconst" />
              <Mapping SourceColumn="custtotal" DataSetColumn="custtotal" />
              <Mapping SourceColumn="custfavour" DataSetColumn="custfavour" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairMaterialsTableAdapter" GeneratorDataComponentClassName="v_repairMaterialsTableAdapter" Name="v_repairMaterials" UserDataComponentName="v_repairMaterialsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairMaterials" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT prerepairid, ptypeid, paytype, favour, saleprice, qty, outstockid, FullName, UserCode, PrePrice1, PrePrice5, RecPrice, stockname, materialsconst, indate FROM dbo.v_repairMaterials</CommandText>