dataset_views.xsd

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

            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_topdefendTableAdapter" GeneratorDataComponentClassName="v_topdefendTableAdapter" Name="v_topdefend" UserDataComponentName="v_topdefendTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_topdefend" 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 Id, Carno, Defendid, Safeitem, Safestartdate, Safeenddate, Safeprice, Preid, rate, safeno FROM dbo.v_topdefend</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Carno" DataSetColumn="Carno" />
              <Mapping SourceColumn="Defendid" DataSetColumn="Defendid" />
              <Mapping SourceColumn="Safeitem" DataSetColumn="Safeitem" />
              <Mapping SourceColumn="Safestartdate" DataSetColumn="Safestartdate" />
              <Mapping SourceColumn="Safeenddate" DataSetColumn="Safeenddate" />
              <Mapping SourceColumn="Safeprice" DataSetColumn="Safeprice" />
              <Mapping SourceColumn="Preid" DataSetColumn="Preid" />
              <Mapping SourceColumn="rate" DataSetColumn="rate" />
              <Mapping SourceColumn="safeno" DataSetColumn="safeno" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_toprepairmainTableAdapter" GeneratorDataComponentClassName="v_toprepairmainTableAdapter" Name="v_toprepairmain" UserDataComponentName="v_toprepairmainTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_toprepairmain" 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, customerid, carcarck, carno, employeeid, display, presugest, indate, outdate, opemployeeid, repairtype FROM dbo.v_toprepairmain</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <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" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_vipdiscountTableAdapter" GeneratorDataComponentClassName="v_vipdiscountTableAdapter" Name="v_vipdiscount" UserDataComponentName="v_vipdiscountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.v_vipdiscount" 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 SignDate, VipCardNo, StartDate, vipenddate, viprang, VipCardKL, VipCardAutoZK, EndDate, Id, BName FROM dbo.v_vipdiscount</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SignDate" DataSetColumn="SignDate" />
              <Mapping SourceColumn="VipCardNo" DataSetColumn="VipCardNo" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="vipenddate" DataSetColumn="vipenddate" />
              <Mapping SourceColumn="viprang" DataSetColumn="viprang" />
              <Mapping SourceColumn="VipCardKL" DataSetColumn="VipCardKL" />
              <Mapping SourceColumn="VipCardAutoZK" DataSetColumn="VipCardAutoZK" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="BName" DataSetColumn="BName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet_Views" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet_Views" msprop:Generator_DataSetName="DataSet_Views">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="v_customerdeail" msprop:Generator_UserTableName="v_customerdeail" msprop:Generator_RowDeletedName="v_customerdeailRowDeleted" msprop:Generator_TableClassName="v_customerdeailDataTable" msprop:Generator_RowChangedName="v_customerdeailRowChanged" msprop:Generator_RowClassName="v_customerdeailRow" msprop:Generator_RowChangingName="v_customerdeailRowChanging" msprop:Generator_RowEvArgName="v_customerdeailRowChangeEvent" msprop:Generator_RowEvHandlerName="v_customerdeailRowChangeEventHandler" msprop:Generator_TablePropName="v_customerdeail" msprop:Generator_TableVarName="tablev_customerdeail" msprop:Generator_RowDeletingName="v_customerdeailRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Ctypename" msprop:Generator_UserColumnName="Ctypename" msprop:Generator_ColumnPropNameInRow="Ctypename" msprop:Generator_ColumnVarNameInTable="columnCtypename" msprop:Generator_ColumnPropNameInTable="CtypenameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Caren" msprop:Generator_UserColumnName="Caren" msprop:Generator_ColumnPropNameInRow="Caren" msprop:Generator_ColumnVarNameInTable="columnCaren" msprop:Generator_ColumnPropNameInTable="CarenColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Facdate" msprop:Generator_UserColumnName="Facdate" msprop:Generator_ColumnPropNameInRow="Facdate" msprop:Generator_ColumnVarNameInTable="columnFacdate" msprop:Generator_ColumnPropNameInTable="FacdateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Keyno" msprop:Generator_UserColumnName="Keyno" msprop:Generator_ColumnPropNameInRow="Keyno" msprop:Generator_ColumnVarNameInTable="columnKeyno" msprop:Generator_ColumnPropNameInTable="KeynoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Passno" msprop:Generator_UserColumnName="Passno" msprop:Generator_ColumnPropNameInRow="Passno" msprop:Generator_ColumnVarNameInTable="columnPassno" msprop:Generator_ColumnPropNameInTable="PassnoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Carno" msprop:Generator_UserColumnName="Carno" msprop:Generator_ColumnPropNameInRow="Carno" msprop:Generator_ColumnVarNameInTable="columnCarno" msprop:Generator_ColumnPropNameInTable="CarnoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Carnofrom" msprop:Generator_UserColumnName="Carnofrom" msprop:Generator_ColumnPropNameInRow="Carnofrom" msprop:Generator_ColumnVarNameInTable="columnCarnofrom" msprop:Generator_ColumnPropNameInTable="CarnofromColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Carnodate" msprop:Generator_UserColumnName="Carnodate" msprop:Generator_ColumnPropNameInRow="Carnodate" msprop:Generator_ColumnVarNameInTable="columnCarnodate" msprop:Generator_ColumnPropNameInTable="CarnodateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Buywhere" msprop:Generator_UserColumnName="Buywhere" msprop:Generator_ColumnPropNameInRow="Buywhere" msprop:Generator_ColumnVarNameInTable="columnBuywhere" msprop:Generator_ColumnPropNameInTable="BuywhereColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Buyuse" msprop:Generator_UserColumnName="Buyuse" msprop:Generator_ColumnPropNameInRow="Buyuse" msprop:Generator_ColumnVarNameInTable="columnBuyuse" msprop:Generator_ColumnPropNameInTable="BuyuseColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Securitypassword" msprop:Generator_UserColumnName="Securitypassword" msprop:Generator_ColumnPropNameInRow="Securitypassword" msprop:Generator_ColumnVarNameInTable="columnSecuritypassword" msprop:Generator_ColumnPropNameInTable="SecuritypasswordColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:res