You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
117 lines
19 KiB
XML
117 lines
19 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString2 (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ConnectionString2.ConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable1TableAdapter" GeneratorDataComponentClassName="DataTable1TableAdapter" Name="DataTable1" UserDataComponentName="DataTable1TableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="ConnectionString2 (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT
|
|
FROM ZipCode</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings />
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet1" msprop:Generator_UserDSName="DataSet1">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="Order" msprop:Generator_TableClassName="OrderDataTable" msprop:Generator_TableVarName="tableOrder" msprop:Generator_RowChangedName="OrderRowChanged" msprop:Generator_TablePropName="Order" msprop:Generator_RowDeletingName="OrderRowDeleting" msprop:Generator_RowChangingName="OrderRowChanging" msprop:Generator_RowEvHandlerName="OrderRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderRowDeleted" msprop:Generator_RowClassName="OrderRow" msprop:Generator_UserTableName="Order" msprop:Generator_RowEvArgName="OrderRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="ExpressService" msprop:Generator_ColumnVarNameInTable="columnExpressService" msprop:Generator_ColumnPropNameInRow="ExpressService" msprop:Generator_ColumnPropNameInTable="ExpressServiceColumn" msprop:Generator_UserColumnName="ExpressService" type="xs:string" minOccurs="0" />
|
|
<xs:element name="ExpressID" msprop:Generator_ColumnVarNameInTable="columnExpressID" msprop:Generator_ColumnPropNameInRow="ExpressID" msprop:Generator_ColumnPropNameInTable="ExpressIDColumn" msprop:Generator_UserColumnName="ExpressID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="ExpressType" msprop:Generator_ColumnVarNameInTable="columnExpressType" msprop:Generator_ColumnPropNameInRow="ExpressType" msprop:Generator_ColumnPropNameInTable="ExpressTypeColumn" msprop:Generator_UserColumnName="ExpressType" type="xs:int" minOccurs="0" />
|
|
<xs:element name="OrderDate" msprop:Generator_ColumnVarNameInTable="columnOrderDate" msprop:Generator_ColumnPropNameInRow="OrderDate" msprop:Generator_ColumnPropNameInTable="OrderDateColumn" msprop:Generator_UserColumnName="OrderDate" type="xs:string" minOccurs="0" />
|
|
<xs:element name="AreaSerial" msprop:Generator_ColumnVarNameInTable="columnAreaSerial" msprop:Generator_ColumnPropNameInRow="AreaSerial" msprop:Generator_ColumnPropNameInTable="AreaSerialColumn" msprop:Generator_UserColumnName="AreaSerial" type="xs:string" minOccurs="0" />
|
|
<xs:element name="AreaSerial2" msprop:Generator_ColumnVarNameInTable="columnAreaSerial2" msprop:Generator_ColumnPropNameInRow="AreaSerial2" msprop:Generator_ColumnPropNameInTable="AreaSerial2Column" msprop:Generator_UserColumnName="AreaSerial2" type="xs:string" minOccurs="0" />
|
|
<xs:element name="RevCountry" msprop:Generator_ColumnVarNameInTable="columnRevCountry" msprop:Generator_ColumnPropNameInRow="RevCountry" msprop:Generator_ColumnPropNameInTable="RevCountryColumn" msprop:Generator_UserColumnName="RevCountry" type="xs:string" minOccurs="0" />
|
|
<xs:element name="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" msprop:Generator_UserColumnName="CountryCode" type="xs:string" minOccurs="0" />
|
|
<xs:element name="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" msprop:Generator_UserColumnName="CountryName" type="xs:string" minOccurs="0" />
|
|
<xs:element name="RevPerson" msprop:Generator_ColumnVarNameInTable="columnRevPerson" msprop:Generator_ColumnPropNameInRow="RevPerson" msprop:Generator_ColumnPropNameInTable="RevPersonColumn" msprop:Generator_UserColumnName="RevPerson" type="xs:string" minOccurs="0" />
|
|
<xs:element name="RevAddress" msprop:Generator_ColumnVarNameInTable="columnRevAddress" msprop:Generator_ColumnPropNameInRow="RevAddress" msprop:Generator_ColumnPropNameInTable="RevAddressColumn" msprop:Generator_UserColumnName="RevAddress" type="xs:string" minOccurs="0" />
|
|
<xs:element name="RevPhone" msprop:Generator_ColumnVarNameInTable="columnRevPhone" msprop:Generator_ColumnPropNameInRow="RevPhone" msprop:Generator_ColumnPropNameInTable="RevPhoneColumn" msprop:Generator_UserColumnName="RevPhone" type="xs:string" minOccurs="0" />
|
|
<xs:element name="RevMobile" msprop:Generator_ColumnVarNameInTable="columnRevMobile" msprop:Generator_ColumnPropNameInRow="RevMobile" msprop:Generator_ColumnPropNameInTable="RevMobileColumn" msprop:Generator_UserColumnName="RevMobile" type="xs:string" minOccurs="0" />
|
|
<xs:element name="RevZip" msprop:Generator_ColumnVarNameInTable="columnRevZip" msprop:Generator_ColumnPropNameInRow="RevZip" msprop:Generator_ColumnPropNameInTable="RevZipColumn" msprop:Generator_UserColumnName="RevZip" type="xs:string" minOccurs="0" />
|
|
<xs:element name="RevZipBarCode" msprop:Generator_ColumnVarNameInTable="columnRevZipBarCode" msprop:Generator_ColumnPropNameInRow="RevZipBarCode" msprop:Generator_ColumnPropNameInTable="RevZipBarCodeColumn" msprop:Generator_UserColumnName="RevZipBarCode" type="xs:string" minOccurs="0" />
|
|
<xs:element name="SendPerson" msprop:Generator_ColumnVarNameInTable="columnSendPerson" msprop:Generator_ColumnPropNameInRow="SendPerson" msprop:Generator_ColumnPropNameInTable="SendPersonColumn" msprop:Generator_UserColumnName="SendPerson" type="xs:string" minOccurs="0" />
|
|
<xs:element name="SendAddress" msprop:Generator_ColumnVarNameInTable="columnSendAddress" msprop:Generator_ColumnPropNameInRow="SendAddress" msprop:Generator_ColumnPropNameInTable="SendAddressColumn" msprop:Generator_UserColumnName="SendAddress" type="xs:string" minOccurs="0" />
|
|
<xs:element name="SendPhone" msprop:Generator_ColumnVarNameInTable="columnSendPhone" msprop:Generator_ColumnPropNameInRow="SendPhone" msprop:Generator_ColumnPropNameInTable="SendPhoneColumn" msprop:Generator_UserColumnName="SendPhone" type="xs:string" minOccurs="0" />
|
|
<xs:element name="SendZip" msprop:Generator_ColumnVarNameInTable="columnSendZip" msprop:Generator_ColumnPropNameInRow="SendZip" msprop:Generator_ColumnPropNameInTable="SendZipColumn" msprop:Generator_UserColumnName="SendZip" type="xs:string" minOccurs="0" />
|
|
<xs:element name="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn" msprop:Generator_UserColumnName="BarCode" type="xs:string" minOccurs="0" />
|
|
<xs:element name="OrderCode" msprop:Generator_ColumnVarNameInTable="columnOrderCode" msprop:Generator_ColumnPropNameInRow="OrderCode" msprop:Generator_ColumnPropNameInTable="OrderCodeColumn" msprop:Generator_UserColumnName="OrderCode" type="xs:string" minOccurs="0" />
|
|
<xs:element name="CountGoodsNum" msprop:Generator_ColumnVarNameInTable="columnCountGoodsNum" msprop:Generator_ColumnPropNameInRow="CountGoodsNum" msprop:Generator_ColumnPropNameInTable="CountGoodsNumColumn" msprop:Generator_UserColumnName="CountGoodsNum" type="xs:string" minOccurs="0" />
|
|
<xs:element name="CountGoodsPrice" msprop:Generator_ColumnVarNameInTable="columnCountGoodsPrice" msprop:Generator_ColumnPropNameInRow="CountGoodsPrice" msprop:Generator_ColumnPropNameInTable="CountGoodsPriceColumn" msprop:Generator_UserColumnName="CountGoodsPrice" type="xs:string" minOccurs="0" />
|
|
<xs:element name="CountGoodsWeight" msprop:Generator_ColumnVarNameInTable="columnCountGoodsWeight" msprop:Generator_ColumnPropNameInRow="CountGoodsWeight" msprop:Generator_ColumnPropNameInTable="CountGoodsWeightColumn" msprop:Generator_UserColumnName="CountGoodsWeight" type="xs:string" minOccurs="0" />
|
|
<xs:element name="ShopName" msprop:Generator_ColumnVarNameInTable="columnShopName" msprop:Generator_ColumnPropNameInRow="ShopName" msprop:Generator_ColumnPropNameInTable="ShopNameColumn" msprop:Generator_UserColumnName="ShopName" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" type="xs:base64Binary" minOccurs="0" />
|
|
<xs:element name="OrderId" msprop:Generator_ColumnVarNameInTable="columnOrderId" msprop:Generator_ColumnPropNameInRow="OrderId" msprop:Generator_ColumnPropNameInTable="OrderIdColumn" msprop:Generator_UserColumnName="OrderId" type="xs:int" />
|
|
<xs:element name="GoodDetail" msprop:Generator_ColumnVarNameInTable="columnGoodDetail" msprop:Generator_ColumnPropNameInRow="GoodDetail" msprop:Generator_ColumnPropNameInTable="GoodDetailColumn" msprop:Generator_UserColumnName="GoodDetail" type="xs:string" minOccurs="0" />
|
|
<xs:element name="YCXX" msprop:Generator_ColumnVarNameInTable="columnYCXX" msprop:Generator_ColumnPropNameInRow="YCXX" msprop:Generator_ColumnPropNameInTable="YCXXColumn" msprop:Generator_UserColumnName="YCXX" type="xs:string" minOccurs="0" />
|
|
<xs:element name="BarOther" msprop:Generator_ColumnVarNameInTable="columnBarOther" msprop:Generator_ColumnPropNameInRow="BarOther" msprop:Generator_ColumnPropNameInTable="BarOtherColumn" msprop:Generator_UserColumnName="BarOther" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodDes" msprop:Generator_ColumnVarNameInTable="columnGoodDes" msprop:Generator_ColumnPropNameInRow="GoodDes" msprop:Generator_ColumnPropNameInTable="GoodDesColumn" msprop:Generator_UserColumnName="GoodDes" type="xs:string" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="OrderDetail" msprop:Generator_TableClassName="OrderDetailDataTable" msprop:Generator_TableVarName="tableOrderDetail" msprop:Generator_RowChangedName="OrderDetailRowChanged" msprop:Generator_TablePropName="OrderDetail" msprop:Generator_RowDeletingName="OrderDetailRowDeleting" msprop:Generator_RowChangingName="OrderDetailRowChanging" msprop:Generator_RowEvHandlerName="OrderDetailRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderDetailRowDeleted" msprop:Generator_RowClassName="OrderDetailRow" msprop:Generator_UserTableName="OrderDetail" msprop:Generator_RowEvArgName="OrderDetailRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GoodsCode" msprop:Generator_ColumnVarNameInTable="columnGoodsCode" msprop:Generator_ColumnPropNameInRow="GoodsCode" msprop:Generator_ColumnPropNameInTable="GoodsCodeColumn" msprop:Generator_UserColumnName="GoodsCode" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodsNum" msprop:Generator_ColumnVarNameInTable="columnGoodsNum" msprop:Generator_ColumnPropNameInRow="GoodsNum" msprop:Generator_ColumnPropNameInTable="GoodsNumColumn" msprop:Generator_UserColumnName="GoodsNum" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodsPrice" msprop:Generator_ColumnVarNameInTable="columnGoodsPrice" msprop:Generator_ColumnPropNameInRow="GoodsPrice" msprop:Generator_ColumnPropNameInTable="GoodsPriceColumn" msprop:Generator_UserColumnName="GoodsPrice" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodsWeight" msprop:Generator_ColumnVarNameInTable="columnGoodsWeight" msprop:Generator_ColumnPropNameInRow="GoodsWeight" msprop:Generator_ColumnPropNameInTable="GoodsWeightColumn" msprop:Generator_UserColumnName="GoodsWeight" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodsName" msprop:Generator_ColumnVarNameInTable="columnGoodsName" msprop:Generator_ColumnPropNameInRow="GoodsName" msprop:Generator_ColumnPropNameInTable="GoodsNameColumn" msprop:Generator_UserColumnName="GoodsName" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodsSimpleName" msprop:Generator_ColumnVarNameInTable="columnGoodsSimpleName" msprop:Generator_ColumnPropNameInRow="GoodsSimpleName" msprop:Generator_ColumnPropNameInTable="GoodsSimpleNameColumn" msprop:Generator_UserColumnName="GoodsSimpleName" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodsOrigin" msprop:Generator_ColumnVarNameInTable="columnGoodsOrigin" msprop:Generator_ColumnPropNameInRow="GoodsOrigin" msprop:Generator_ColumnPropNameInTable="GoodsOriginColumn" msprop:Generator_UserColumnName="GoodsOrigin" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodsSku" msprop:Generator_ColumnVarNameInTable="columnGoodsSku" msprop:Generator_ColumnPropNameInRow="GoodsSku" msprop:Generator_ColumnPropNameInTable="GoodsSkuColumn" msprop:Generator_UserColumnName="GoodsSku" type="xs:string" minOccurs="0" />
|
|
<xs:element name="TypeDesc" msprop:Generator_ColumnVarNameInTable="columnTypeDesc" msprop:Generator_ColumnPropNameInRow="TypeDesc" msprop:Generator_ColumnPropNameInTable="TypeDescColumn" msprop:Generator_UserColumnName="TypeDesc" type="xs:string" minOccurs="0" />
|
|
<xs:element name="PostionDesc" msprop:Generator_ColumnVarNameInTable="columnPostionDesc" msprop:Generator_ColumnPropNameInRow="PostionDesc" msprop:Generator_ColumnPropNameInTable="PostionDescColumn" msprop:Generator_UserColumnName="PostionDesc" type="xs:string" minOccurs="0" />
|
|
<xs:element name="OrderId" msprop:Generator_ColumnVarNameInTable="columnOrderId" msprop:Generator_ColumnPropNameInRow="OrderId" msprop:Generator_ColumnPropNameInTable="OrderIdColumn" msprop:Generator_UserColumnName="OrderId" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="DataTable1" msprop:Generator_TableClassName="DataTable1DataTable" msprop:Generator_TableVarName="tableDataTable1" msprop:Generator_RowChangedName="DataTable1RowChanged" msprop:Generator_TablePropName="DataTable1" msprop:Generator_RowDeletingName="DataTable1RowDeleting" msprop:Generator_RowChangingName="DataTable1RowChanging" msprop:Generator_RowEvHandlerName="DataTable1RowChangeEventHandler" msprop:Generator_RowDeletedName="DataTable1RowDeleted" msprop:Generator_RowClassName="DataTable1Row" msprop:Generator_UserTableName="DataTable1" msprop:Generator_RowEvArgName="DataTable1RowChangeEvent">
|
|
<xs:complexType>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="GoodWarePrint" msprop:Generator_TableClassName="GoodWarePrintDataTable" msprop:Generator_TableVarName="tableGoodWarePrint" msprop:Generator_RowChangedName="GoodWarePrintRowChanged" msprop:Generator_TablePropName="GoodWarePrint" msprop:Generator_RowDeletingName="GoodWarePrintRowDeleting" msprop:Generator_RowChangingName="GoodWarePrintRowChanging" msprop:Generator_RowEvHandlerName="GoodWarePrintRowChangeEventHandler" msprop:Generator_RowDeletedName="GoodWarePrintRowDeleted" msprop:Generator_RowClassName="GoodWarePrintRow" msprop:Generator_UserTableName="GoodWarePrint" msprop:Generator_RowEvArgName="GoodWarePrintRowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GoodNo" msprop:Generator_ColumnVarNameInTable="columnGoodNo" msprop:Generator_ColumnPropNameInRow="GoodNo" msprop:Generator_ColumnPropNameInTable="GoodNoColumn" msprop:Generator_UserColumnName="GoodNo" type="xs:string" minOccurs="0" />
|
|
<xs:element name="Descript" msprop:Generator_ColumnVarNameInTable="columnDescript" msprop:Generator_ColumnPropNameInRow="Descript" msprop:Generator_ColumnPropNameInTable="DescriptColumn" msprop:Generator_UserColumnName="Descript" type="xs:string" minOccurs="0" />
|
|
<xs:element name="WareNo" msprop:Generator_ColumnVarNameInTable="columnWareNo" msprop:Generator_ColumnPropNameInRow="WareNo" msprop:Generator_ColumnPropNameInTable="WareNoColumn" msprop:Generator_UserColumnName="WareNo" type="xs:string" minOccurs="0" />
|
|
<xs:element name="GoodBatch" msprop:Generator_ColumnVarNameInTable="columnGoodBatch" msprop:Generator_ColumnPropNameInRow="GoodBatch" msprop:Generator_ColumnPropNameInTable="GoodBatchColumn" msprop:Generator_UserColumnName="GoodBatch" type="xs:string" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Order" />
|
|
<xs:field xpath="mstns:OrderId" />
|
|
</xs:unique>
|
|
<xs:unique name="OrderDetail_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:OrderDetail" />
|
|
<xs:field xpath="mstns:OrderId" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="OrderPrcelDetail_OrderPrcel" msdata:parent="OrderDetail" msdata:child="Order" msdata:parentkey="OrderId" msdata:childkey="OrderId" msprop:Generator_UserChildTable="Order" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_UserRelationName="OrderPrcelDetail_OrderPrcel" msprop:Generator_RelationVarName="relationOrderPrcelDetail_OrderPrcel" msprop:Generator_UserParentTable="OrderDetail" msprop:Generator_ParentPropName="OrderDetailRow" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |