categories.xsd

classfinalcs.rar .net 压缩包解压时不能有密码。

									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertCategory" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertCategory" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>InsertCategory</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="Int32" Direction="Input" ParameterName="@ParentCategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.MoveCategory" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="MoveCategory" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>MoveCategory</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="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NewParentCategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveCategory" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemoveCategory" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
										<CommandText>RemoveCategory</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="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateCategoryName" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateCategoryName" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>UpdateCategoryName</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>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</Sources>
					</TableAdapter>
				</Tables>
				<Sources>
				</Sources>
			</DataSource>
		</xs:appinfo>
	</xs:annotation>
	<xs:element name="CategoriesDataComponent" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
		<xs:complexType>
			<xs:choice minOccurs="0" maxOccurs="unbounded">
				<xs:element name="Categories">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="ParentCategoryId" type="xs:int" minOccurs="0" />
							<xs:element name="Name">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="50" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="NumActiveAds" type="xs:int" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Categories" />
			<xs:field xpath="mstns:Id" />
		</xs:unique>
	</xs:element>
</xs:schema>