dataset_views.xsd

来自「以前为一家4S店开发的维修管理及客户管理的软件,C#开发!」· XSD 代码 · 共 768 行 · 第 1/5 页

              <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" />