ads.xsd

来自「classfinalcs.rar .net 压缩包解压时不能有密码。」· XSD 代码 · 共 678 行 · 第 1/5 页

								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>RemovePhoto</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemovePhotosByAdStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemovePhotosByAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>RemovePhotosByAdStatus</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.SetAdPreviewPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="SetAdPreviewPhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>SetAdPreviewPhoto</CommandText>
										<Parameters>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</Sources>
					</TableAdapter>
				</Tables>
				<Sources>
				</Sources>
			</DataSource>
		</xs:appinfo>
	</xs:annotation>
	<xs:element name="AdsDataComponent" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
		<xs:complexType>
			<xs:choice minOccurs="0" maxOccurs="unbounded">
				<xs:element name="Ads">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="MemberId" type="xs:int" />
							<xs:element name="CategoryId" type="xs:int" />
							<xs:element name="Title">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="100" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="Description">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="1073741823" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="URL">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="500" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="Price" type="xs:decimal" />
							<xs:element name="Location">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="50" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="ExpirationDate" type="xs:dateTime" minOccurs="0" />
							<xs:element name="DateCreated" type="xs:dateTime" />
							<xs:element name="DateApproved" type="xs:dateTime" minOccurs="0" />
							<xs:element name="NumViews" type="xs:int" />
							<xs:element name="NumResponses" type="xs:int" />
							<xs:element name="AdLevel" type="xs:int" />
							<xs:element name="AdStatus" type="xs:int" />
							<xs:element name="AdType" type="xs:int" />
							<xs:element name="PreviewImageId" type="xs:int" minOccurs="0" />
							<xs:element name="MemberName">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="256" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="CategoryName">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="50" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Photos">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="AdId" type="xs:int" />
							<xs:element name="IsMainPreview" type="xs:boolean" />
							<xs:element name="DateCreated" type="xs:dateTime" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Ads" />
			<xs:field xpath="mstns:Id" />
		</xs:unique>
		<xs:unique name="Photos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Photos" />
			<xs:field xpath="mstns:Id" />
		</xs:unique>
	</xs:element>
</xs:schema>