wwamds.xsd

报刊广告管理系统。CSharp编写

<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="WWAMDS" targetNamespace="http://tempuri.org/WWAMDS.xsd" elementFormDefault="qualified"
	attributeFormDefault="qualified" xmlns="http://tempuri.org/WWAMDS.xsd" xmlns:mstns="http://tempuri.org/WWAMDS.xsd"
	xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
	<xs:element name="WWAMDS" msdata:IsDataSet="true">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="iAdvModel">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="AdvModelid" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Code" type="xs:string" />
							<xs:element name="Used" type="xs:boolean" />
							<xs:element name="LastVersion" type="xs:int" />
							<xs:element name="ExtendFlag" type="xs:int" />
							<xs:element name="PaperName" type="xs:string" />
							<xs:element name="PaperSpaceNum" type="xs:string" />
							<xs:element name="PaperSpace" type="xs:string" />
							<xs:element name="AdvSpec" type="xs:string" />
							<xs:element name="Color" type="xs:string" />
							<xs:element name="PayUnit" type="xs:string" />
							<xs:element name="PayNum" type="xs:float" />
							<xs:element name="PayPrice" type="xs:float" />
							<xs:element name="PaySum" type="xs:float" />
							<xs:element name="Memo" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="lLogin">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Loginid" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="LoginTime" type="xs:dateTime" />
							<xs:element name="LastActTime" type="xs:dateTime" />
							<xs:element name="LogoutTime" type="xs:dateTime" />
							<xs:element name="UserCode" type="xs:string" />
							<xs:element name="IsValid" type="xs:boolean" />
							<xs:element name="IPAddress" type="xs:string" />
							<xs:element name="Describe" type="xs:string" />
							<xs:element name="IsAlive" type="xs:boolean" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="iClient">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Clientid" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Code" type="xs:string" />
							<xs:element name="SimpleCode" type="xs:string" />
							<xs:element name="Used" type="xs:boolean" />
							<xs:element name="LastVersion" type="xs:int" />
							<xs:element name="ExtendFlag" type="xs:int" />
							<xs:element name="ClientType" type="xs:string" />
							<xs:element name="LinkMan" type="xs:string" />
							<xs:element name="Phone" type="xs:string" />
							<xs:element name="Fax" type="xs:string" />
							<xs:element name="Address" type="xs:string" />
							<xs:element name="ZipCode" type="xs:string" />
							<xs:element name="Memo" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="bType">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Typeid" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Code" type="xs:string" />
							<xs:element name="Type" type="xs:int" />
							<xs:element name="Used" type="xs:boolean" />
							<xs:element name="LastVersion" type="xs:int" />
							<xs:element name="ExtendFlag" type="xs:int" />
							<xs:element name="Memo" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="bTypeName">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="id" type="xs:int" />
							<xs:element name="Name" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="iUser">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Userid" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Code" type="xs:string" />
							<xs:element name="Name" type="xs:string" />
							<xs:element name="SimpleCode" type="xs:string" />
							<xs:element name="Used" type="xs:boolean" />
							<xs:element name="SysKeep" type="xs:boolean" />
							<xs:element name="LastVersion" type="xs:int" />
							<xs:element name="ExtendFlag" type="xs:int" />
							<xs:element name="Password" type="xs:string" />
							<xs:element name="Duty" type="xs:string" />
							<xs:element name="Logined" type="xs:boolean" />
							<xs:element name="AdminFlag" type="xs:boolean" />
							<xs:element name="Phone" type="xs:string" />
							<xs:element name="PurviewOp" type="xs:int" />
							<xs:element name="PurviewMenu" type="xs:int" />
							<xs:element name="Memo" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="lAdv">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Advid" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Code" type="xs:string" />
							<xs:element name="Used" type="xs:boolean" />
							<xs:element name="LastVersion" type="xs:int" />
							<xs:element name="ExtendFlag" type="xs:int" />
							<xs:element name="DateIssue" type="xs:dateTime" />
							<xs:element name="PaperPerNum" type="xs:int" />
							<xs:element name="AdvContent" type="xs:string" />
							<xs:element name="PaperName" type="xs:string" />
							<xs:element name="PaperSpaceNum" type="xs:string" />
							<xs:element name="PaperSpace" type="xs:string" />
							<xs:element name="AdvSpec" type="xs:string" />
							<xs:element name="Color" type="xs:string" />
							<xs:element name="PayUnit" type="xs:string" />
							<xs:element name="PayNum" type="xs:float" />
							<xs:element name="PayPrice" type="xs:float" />
							<xs:element name="PaySum" type="xs:float" />
							<xs:element name="Author" type="xs:string" />
							<xs:element name="AuthDate" type="xs:dateTime" />
							<xs:element name="AuthContent" type="xs:string" />
							<xs:element name="IsAuth" type="xs:boolean" />
							<xs:element name="PayReal" type="xs:float" />
							<xs:element name="PayPer" type="xs:float" />
							<xs:element name="DatePay" type="xs:dateTime" />
							<xs:element name="PayType" type="xs:string" />
							<xs:element name="InvoiceNum" type="xs:string" />
							<xs:element name="IsPay" type="xs:boolean" />
							<xs:element name="OpUser" type="xs:string" />
							<xs:element name="ClientType" type="xs:string" />
							<xs:element name="ClientCode" type="xs:string" />
							<xs:element name="LinkMan" type="xs:string" />
							<xs:element name="Phone" type="xs:string" />
							<xs:element name="Fax" type="xs:string" />
							<xs:element name="Address" type="xs:string" />
							<xs:element name="ZipCode" type="xs:string" />
							<xs:element name="CreateTime" type="xs:dateTime" />
							<xs:element name="Creator" type="xs:string" />
							<xs:element name="LastEditTime" type="xs:dateTime" />
							<xs:element name="LastEditor" type="xs:string" />
							<xs:element name="Memo" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="WWAMDSKey2" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:iAdvModel" />
			<xs:field xpath="mstns:AdvModelid" />
		</xs:unique>
		<xs:unique name="WWAMDSKey3" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:lLogin" />
			<xs:field xpath="mstns:Loginid" />
		</xs:unique>
		<xs:unique name="WWAMDSKey5" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:iClient" />
			<xs:field xpath="mstns:Clientid" />
		</xs:unique>
		<xs:unique name="WWAMDSKey6" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:bType" />
			<xs:field xpath="mstns:Typeid" />
		</xs:unique>
		<xs:unique name="WWAMDSKey7" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:bTypeName" />
			<xs:field xpath="mstns:id" />
		</xs:unique>
		<xs:unique name="WWAMDSKey8" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:iUser" />
			<xs:field xpath="mstns:Userid" />
		</xs:unique>
		<xs:unique name="WWAMDSKey1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:lAdv" />
			<xs:field xpath="mstns:Advid" />
		</xs:unique>
	</xs:element>
</xs:schema>