dataset_stores.xsd

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

            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.sp_decrypt" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="sp_decrypt" MethodsParameterType="CLR" Modifier="Public" Name="sp_decrypt" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy8" UserSourceName="sp_decrypt">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                <CommandText>dbo.sp_decrypt</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@objectName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="mmerpConnectionString (Settings)" DbObjectName="mmerp.dbo.sp_repairinsertvist" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="sp_repairinsertvist" MethodsParameterType="CLR" Modifier="Public" Name="sp_repairinsertvist" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy9" UserSourceName="sp_repairinsertvist">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                <CommandText>dbo.sp_repairinsertvist</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@carrack" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@employeeid" Precision="0" ProviderType="VarChar" Scale="0" Size="25" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@customerid" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@vistdate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet_Stores" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet_Stores" msprop:Generator_DataSetName="DataSet_Stores">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="gp_getoldinstockdeal" msprop:Generator_UserTableName="gp_getoldinstockdeal" msprop:Generator_RowDeletedName="gp_getoldinstockdealRowDeleted" msprop:Generator_TableClassName="gp_getoldinstockdealDataTable" msprop:Generator_RowChangedName="gp_getoldinstockdealRowChanged" msprop:Generator_RowClassName="gp_getoldinstockdealRow" msprop:Generator_RowChangingName="gp_getoldinstockdealRowChanging" msprop:Generator_RowEvArgName="gp_getoldinstockdealRowChangeEvent" msprop:Generator_RowEvHandlerName="gp_getoldinstockdealRowChangeEventHandler" msprop:Generator_TablePropName="gp_getoldinstockdeal" msprop:Generator_TableVarName="tablegp_getoldinstockdeal" msprop:Generator_RowDeletingName="gp_getoldinstockdealRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="qty" msprop:Generator_UserColumnName="qty" msprop:Generator_ColumnPropNameInRow="qty" msprop:Generator_ColumnVarNameInTable="columnqty" msprop:Generator_ColumnPropNameInTable="qtyColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="billnumberid" msprop:Generator_UserColumnName="billnumberid" msprop:Generator_ColumnPropNameInRow="billnumberid" msprop:Generator_ColumnVarNameInTable="columnbillnumberid" msprop:Generator_ColumnPropNameInTable="billnumberidColumn" type="xs:long" minOccurs="0" />
              <xs:element name="ptypeid" msprop:Generator_UserColumnName="ptypeid" msprop:Generator_ColumnPropNameInRow="ptypeid" msprop:Generator_ColumnVarNameInTable="columnptypeid" msprop:Generator_ColumnPropNameInTable="ptypeidColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="price" msprop:Generator_UserColumnName="price" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInTable="priceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="total" msprop:Generator_UserColumnName="total" msprop:Generator_ColumnPropNameInRow="total" msprop:Generator_ColumnVarNameInTable="columntotal" msprop:Generator_ColumnPropNameInTable="totalColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="pname" msprop:Generator_UserColumnName="pname" msprop:Generator_ColumnPropNameInRow="pname" msprop:Generator_ColumnVarNameInTable="columnpname" msprop:Generator_ColumnPropNameInTable="pnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="usercode" msprop:Generator_UserColumnName="usercode" msprop:Generator_ColumnPropNameInRow="usercode" msprop:Generator_ColumnVarNameInTable="columnusercode" msprop:Generator_ColumnPropNameInTable="usercodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="gp_getoldinstockmain" msprop:Generator_UserTableName="gp_getoldinstockmain" msprop:Generator_RowDeletedName="gp_getoldinstockmainRowDeleted" msprop:Generator_TableClassName="gp_getoldinstockmainDataTable" msprop:Generator_RowChangedName="gp_getoldinstockmainRowChanged" msprop:Generator_RowClassName="gp_getoldinstockmainRow" msprop:Generator_RowChangingName="gp_getoldinstockmainRowChanging" msprop:Generator_RowEvArgName="gp_getoldinstockmainRowChangeEvent" msprop:Generator_RowEvHandlerName="gp_getoldinstockmainRowChangeEventHandler" msprop:Generator_TablePropName="gp_getoldinstockmain" msprop:Generator_TableVarName="tablegp_getoldinstockmain" msprop:Generator_RowDeletingName="gp_getoldinstockmainRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillNumberID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="BillNumberID" msprop:Generator_ColumnPropNameInRow="BillNumberID" msprop:Generator_ColumnVarNameInTable="columnBillNumberID" msprop:Generator_ColumnPropNameInTable="BillNumberIDColumn" type="xs:decimal" />
              <xs:element name="BillDate" msprop:Generator_UserColumnName="BillDate" msprop:Generator_ColumnPropNameInRow="BillDate" msprop:Generator_ColumnVarNameInTable="columnBillDate" msprop:Generator_ColumnPropNameInTable="BillDateColumn" type="xs:dateTime" />
              <xs:element name="BillCode" msprop:Generator_UserColumnName="BillCode" msprop:Generator_ColumnPropNameInRow="BillCode" msprop:Generator_ColumnVarNameInTable="columnBillCode" msprop:Generator_ColumnPropNameInTable="BillCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ifcheck" msprop:Generator_UserColumnName="ifcheck" msprop:Generator_ColumnPropNameInRow="ifcheck" msprop:Generator_ColumnVarNameInTable="columnifcheck" msprop:Generator_ColumnPropNameInTable="ifcheckColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bname" msprop:Generator_UserColumnName="bname" msprop:Generator_ColumnPropNameInRow="bname" msprop:Generator_ColumnVarNameInTable="columnbname" msprop:Generator_ColumnPropNameInTable="bnameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="66" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="stockname" msprop:Generator_UserColumnName="stockname" msprop:Generator_ColumnPropNameInRow="stockname" msprop:Generator_ColumnVarNameInTable="columnstockname" msprop:Generator_ColumnPropNameInTable="stocknameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="66" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="employeename" msprop:Generator_UserColumnName="employeename" msprop:Generator_ColumnPropNameInRow="employeename" msprop:Generator_ColumnVarNameInTable="columnemployeename" msprop:Generator_ColumnPropNameInTable="employeenameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="66" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="checkname" msprop:Generator_UserColumnName="checkname" msprop:Generator_ColumnPropNameInRow="checkname" msprop:Generator_ColumnVarNameInTable="columncheckname" msprop:Generator_ColumnPropNameInTable="checknameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="66" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>