dataset_views.xsd

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

                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="ptypeid" DataSetColumn="ptypeid" />
              <Mapping SourceColumn="paytype" DataSetColumn="paytype" />
              <Mapping SourceColumn="favour" DataSetColumn="favour" />
              <Mapping SourceColumn="saleprice" DataSetColumn="saleprice" />
              <Mapping SourceColumn="qty" DataSetColumn="qty" />
              <Mapping SourceColumn="outstockid" DataSetColumn="outstockid" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="UserCode" DataSetColumn="UserCode" />
              <Mapping SourceColumn="PrePrice1" DataSetColumn="PrePrice1" />
              <Mapping SourceColumn="PrePrice5" DataSetColumn="PrePrice5" />
              <Mapping SourceColumn="RecPrice" DataSetColumn="RecPrice" />
              <Mapping SourceColumn="stockname" DataSetColumn="stockname" />
              <Mapping SourceColumn="materialsconst" DataSetColumn="materialsconst" />
              <Mapping SourceColumn="indate" DataSetColumn="indate" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairptypesumTableAdapter" GeneratorDataComponentClassName="v_repairptypesumTableAdapter" Name="v_repairptypesum" UserDataComponentName="v_repairptypesumTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairptypesum" 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 ptypeid, paytype, favour, totalprice, prerepairid, ptypeconst, rateprice, rate, custtotalprice, custfavour FROM dbo.v_repairptypesum</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ptypeid" DataSetColumn="ptypeid" />
              <Mapping SourceColumn="paytype" DataSetColumn="paytype" />
              <Mapping SourceColumn="favour" DataSetColumn="favour" />
              <Mapping SourceColumn="totalprice" DataSetColumn="totalprice" />
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="ptypeconst" DataSetColumn="ptypeconst" />
              <Mapping SourceColumn="rateprice" DataSetColumn="rateprice" />
              <Mapping SourceColumn="rate" DataSetColumn="rate" />
              <Mapping SourceColumn="custtotalprice" DataSetColumn="custtotalprice" />
              <Mapping SourceColumn="custfavour" DataSetColumn="custfavour" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairstatusTableAdapter" GeneratorDataComponentClassName="v_repairstatusTableAdapter" Name="v_repairstatus" UserDataComponentName="v_repairstatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairstatus" 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 startdate, enddate, employeeid, totalmoney, preferencemoney, prerepairid, qty, customerid, carcarck, carno, indate, outdate, opemployeeid, repairtype, billnumberid, employeename, opemployeename, customername, workid FROM dbo.v_repairstatus</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="startdate" DataSetColumn="startdate" />
              <Mapping SourceColumn="enddate" DataSetColumn="enddate" />
              <Mapping SourceColumn="employeeid" DataSetColumn="employeeid" />
              <Mapping SourceColumn="totalmoney" DataSetColumn="totalmoney" />
              <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="customername" DataSetColumn="customername" />
              <Mapping SourceColumn="workid" DataSetColumn="workid" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repairworkerTableAdapter" GeneratorDataComponentClassName="v_repairworkerTableAdapter" Name="v_repairworker" UserDataComponentName="v_repairworkerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repairworker" 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 paytype, startdate, enddate, jobemployeeid, favour, repairname, repairtime, worktype, prerepairid, jobname, constprice, const FROM dbo.v_repairworker</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="paytype" DataSetColumn="paytype" />
              <Mapping SourceColumn="startdate" DataSetColumn="startdate" />
              <Mapping SourceColumn="enddate" DataSetColumn="enddate" />
              <Mapping SourceColumn="jobemployeeid" DataSetColumn="jobemployeeid" />
              <Mapping SourceColumn="favour" DataSetColumn="favour" />
              <Mapping SourceColumn="repairname" DataSetColumn="repairname" />
              <Mapping SourceColumn="repairtime" DataSetColumn="repairtime" />
              <Mapping SourceColumn="worktype" DataSetColumn="worktype" />
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="jobname" DataSetColumn="jobname" />
              <Mapping SourceColumn="constprice" DataSetColumn="constprice" />
              <Mapping SourceColumn="const" DataSetColumn="const" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_saledpcarinfoTableAdapter" GeneratorDataComponentClassName="v_saledpcarinfoTableAdapter" Name="v_saledpcarinfo" UserDataComponentName="v_saledpcarinfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_saledpcarinfo" 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 salername, customername, Carrack, Caren, Facdate, Keyno, Passno, Carno, Carnofrom, Carnodate, Buywhere, Securitypassword, Keypassword, Buyprice, IcNo, Daymileage, Prekeep, Carmileage, recoderdate, prekeepmileage, picid, buytypename FROM dbo.v_saledpcarinfo</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="salername" DataSetColumn="salername" />
              <Mapping SourceColumn="customername" DataSetColumn="customername" />
              <Mapping SourceColumn="Carrack" DataSetColumn="Carrack" />
              <Mapping SourceColumn="Caren" DataSetColumn="Caren" />
              <Mapping SourceColumn="Facdate" DataSetColumn="Facdate" />
              <Mapping SourceColumn="Keyno" DataSetColumn="Keyno" />
              <Mapping SourceColumn="Passno" DataSetColumn="Passno" />
              <Mapping SourceColumn="Carno" DataSetColumn="Carno" />
              <Mapping SourceColumn="Carnofrom" DataSetColumn="Carnofrom" />
              <Mapping SourceColumn="Carnodate" DataSetColumn="Carnodate" />
              <Mapping SourceColumn="Buywhere" DataSetColumn="Buywhere" />
              <Mapping SourceColumn="Securitypassword" DataSetColumn="Securitypassword" />
              <Mapping SourceColumn="Keypassword" DataSetColumn="Keypassword" />
              <Mapping SourceColumn="Buyprice" DataSetColumn="Buyprice" />
              <Mapping SourceColumn="IcNo" DataSetColumn="IcNo" />
              <Mapping SourceColumn="Daymileage" DataSetColumn="Daymileage" />
              <Mapping SourceColumn="Prekeep" DataSetColumn="Prekeep" />
              <Mapping SourceColumn="Carmileage" DataSetColumn="Carmileage" />
              <Mapping SourceColumn="recoderdate" DataSetColumn="recoderdate" />
              <Mapping SourceColumn="prekeepmileage" DataSetColumn="prekeepmileage" />
              <Mapping SourceColumn="picid" DataSetColumn="picid" />
              <Mapping SourceColumn="buytypename" DataSetColumn="buytypename" />
            </Mappings>