dataset_views.xsd

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

              <Mapping SourceColumn="employeeid" DataSetColumn="employeeid" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_keepalertTableAdapter" GeneratorDataComponentClassName="v_keepalertTableAdapter" Name="v_keepalert" UserDataComponentName="v_keepalertTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_keepalert" 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 Name, Tel, Handtel, Email, Carno, Carrack, Prekeep, Daymileage, Carmileage, keepmileage, vistid, keepnums, BName FROM dbo.v_keepalert</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Tel" DataSetColumn="Tel" />
              <Mapping SourceColumn="Handtel" DataSetColumn="Handtel" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Carno" DataSetColumn="Carno" />
              <Mapping SourceColumn="Carrack" DataSetColumn="Carrack" />
              <Mapping SourceColumn="Prekeep" DataSetColumn="Prekeep" />
              <Mapping SourceColumn="Daymileage" DataSetColumn="Daymileage" />
              <Mapping SourceColumn="Carmileage" DataSetColumn="Carmileage" />
              <Mapping SourceColumn="keepmileage" DataSetColumn="keepmileage" />
              <Mapping SourceColumn="vistid" DataSetColumn="vistid" />
              <Mapping SourceColumn="keepnums" DataSetColumn="keepnums" />
              <Mapping SourceColumn="BName" DataSetColumn="BName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_prerepairTableAdapter" GeneratorDataComponentClassName="v_prerepairTableAdapter" Name="v_prerepair" UserDataComponentName="v_prerepairTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_prerepair" 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 customername, employeename, opemployeename, itemfavour, itemconstprice, itempretaxconst, itemrateconst, ptypeqty, ptyeconstprice, ptypesaleconst, prerepairid, customerid, carcarck, carno, employeeid, display, presugest, indate, outdate, opemployeeid, repairtype, billnumberid, btypeid1, btypeid2, btypeid3, redfalg, ptypeid, ptypefavour, BName FROM dbo.v_prerepair</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="customername" DataSetColumn="customername" />
              <Mapping SourceColumn="employeename" DataSetColumn="employeename" />
              <Mapping SourceColumn="opemployeename" DataSetColumn="opemployeename" />
              <Mapping SourceColumn="itemfavour" DataSetColumn="itemfavour" />
              <Mapping SourceColumn="itemconstprice" DataSetColumn="itemconstprice" />
              <Mapping SourceColumn="itempretaxconst" DataSetColumn="itempretaxconst" />
              <Mapping SourceColumn="itemrateconst" DataSetColumn="itemrateconst" />
              <Mapping SourceColumn="ptypeqty" DataSetColumn="ptypeqty" />
              <Mapping SourceColumn="ptyeconstprice" DataSetColumn="ptyeconstprice" />
              <Mapping SourceColumn="ptypesaleconst" DataSetColumn="ptypesaleconst" />
              <Mapping SourceColumn="prerepairid" DataSetColumn="prerepairid" />
              <Mapping SourceColumn="customerid" DataSetColumn="customerid" />
              <Mapping SourceColumn="carcarck" DataSetColumn="carcarck" />
              <Mapping SourceColumn="carno" DataSetColumn="carno" />
              <Mapping SourceColumn="employeeid" DataSetColumn="employeeid" />
              <Mapping SourceColumn="display" DataSetColumn="display" />
              <Mapping SourceColumn="presugest" DataSetColumn="presugest" />
              <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="btypeid1" DataSetColumn="btypeid1" />
              <Mapping SourceColumn="btypeid2" DataSetColumn="btypeid2" />
              <Mapping SourceColumn="btypeid3" DataSetColumn="btypeid3" />
              <Mapping SourceColumn="redfalg" DataSetColumn="redfalg" />
              <Mapping SourceColumn="ptypeid" DataSetColumn="ptypeid" />
              <Mapping SourceColumn="ptypefavour" DataSetColumn="ptypefavour" />
              <Mapping SourceColumn="BName" DataSetColumn="BName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_reapirmainTableAdapter" GeneratorDataComponentClassName="v_reapirmainTableAdapter" Name="v_reapirmain" UserDataComponentName="v_reapirmainTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_reapirmain" 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 timeconst, timefavour, typeconst, typefavour, customername, carno, carrack, employeename, vistname, repairdate, outdate, cid, workid, vistid, employeeid, redfalg, BName FROM dbo.v_reapirmain</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="timeconst" DataSetColumn="timeconst" />
              <Mapping SourceColumn="timefavour" DataSetColumn="timefavour" />
              <Mapping SourceColumn="typeconst" DataSetColumn="typeconst" />
              <Mapping SourceColumn="typefavour" DataSetColumn="typefavour" />
              <Mapping SourceColumn="customername" DataSetColumn="customername" />
              <Mapping SourceColumn="carno" DataSetColumn="carno" />
              <Mapping SourceColumn="carrack" DataSetColumn="carrack" />
              <Mapping SourceColumn="employeename" DataSetColumn="employeename" />
              <Mapping SourceColumn="vistname" DataSetColumn="vistname" />
              <Mapping SourceColumn="repairdate" DataSetColumn="repairdate" />
              <Mapping SourceColumn="outdate" DataSetColumn="outdate" />
              <Mapping SourceColumn="cid" DataSetColumn="cid" />
              <Mapping SourceColumn="workid" DataSetColumn="workid" />
              <Mapping SourceColumn="vistid" DataSetColumn="vistid" />
              <Mapping SourceColumn="employeeid" DataSetColumn="employeeid" />
              <Mapping SourceColumn="redfalg" DataSetColumn="redfalg" />
              <Mapping SourceColumn="BName" DataSetColumn="BName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_repair_vistTableAdapter" GeneratorDataComponentClassName="v_repair_vistTableAdapter" Name="v_repair_vist" UserDataComponentName="v_repair_vistTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_repair_vist" 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 customername, resultname, resultvalue, servicename, servicevalue, qualityname, qualityvalue, efficname, efficvalue, address, Handtel, Tel, Carno, Id, carrack, customerid, visttime, nextvisttime, resultgrade, resultcomment, servicegrade, servicecomment, Qualitygrade, Qualitycomment, Efficgrade, Efficcomment, customersugust, preid, isvisted, isfinished, BName FROM dbo.v_repair_vist</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="customername" DataSetColumn="customername" />
              <Mapping SourceColumn="resultname" DataSetColumn="resultname" />
              <Mapping SourceColumn="resultvalue" DataSetColumn="resultvalue" />
              <Mapping SourceColumn="servicename" DataSetColumn="servicename" />
              <Mapping SourceColumn="servicevalue" DataSetColumn="servicevalue" />
              <Mapping SourceColumn="qualityname" DataSetColumn="qualityname" />
              <Mapping SourceColumn="qualityvalue" DataSetColumn="qualityvalue" />
              <Mapping SourceColumn="efficname" DataSetColumn="efficname" />
              <Mapping SourceColumn="efficvalue" DataSetColumn="efficvalue" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="Handtel" DataSetColumn="Handtel" />
              <Mapping SourceColumn="Tel" DataSetColumn="Tel" />
              <Mapping SourceColumn="Carno" DataSetColumn="Carno" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="carrack" DataSetColumn="carrack" />
              <Mapping SourceColumn="customerid" DataSetColumn="customerid" />
              <Mapping SourceColumn="visttime" DataSetColumn="visttime" />
              <Mapping SourceColumn="nextvisttime" DataSetColumn="nextvisttime" />
              <Mapping SourceColumn="resultgrade" DataSetColumn="resultgrade" />
              <Mapping SourceColumn="resultcomment" DataSetColumn="resultcomment" />
              <Mapping SourceColumn="servicegrade" DataSetColumn="servicegrade" />
              <Mapping SourceColumn="servicecomment" DataSetColumn="servicecomment" />
              <Mapping SourceColumn="Qualitygrade" DataSetColumn="Qualitygrade" />
              <Mapping SourceColumn="Qualitycomment" DataSetColumn="Qualitycomment" />
              <Mapping SourceColumn="Efficgrade" DataSetColumn="Efficgrade" />
              <Mapping SourceColumn="Efficcomment" DataSetColumn="Efficcomment" />