ads.xsd

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

XSD
678
字号
										<CommandText>UpdateAdCategory</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="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdLevel" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdLevel" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>UpdateAdLevel</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="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdStats" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdStats" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>UpdateAdStats</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="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToViews" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToResponses" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>UpdateAdStatus</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="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</Sources>
					</TableAdapter>
					<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PhotosDataAdapter" Name="Photos">
						<MainSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotosByAdId" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetPhotosByAdId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>GetPhotosByAdId</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="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</MainSource>
						<Mappings>
							<Mapping SourceColumn="Id" DataSetColumn="Id" />
							<Mapping SourceColumn="AdId" DataSetColumn="AdId" />
							<Mapping SourceColumn="IsMainPreview" DataSetColumn="IsMainPreview" />
							<Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
						</Mappings>
						<Sources>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotoBytesById" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="GetPhotoBytesById" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>GetPhotoBytesById</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="Int32" Direction="Input" ParameterName="@Size" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotosByAdStatus" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetPhotosByAdStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
										<CommandText>GetPhotosByAdStatus</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.InsertPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertPhoto" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
										<CommandText>InsertPhoto</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="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesFull" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesMedium" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesSmall" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsMainPreview" Precision="1" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
											<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
											</Parameter>
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemovePhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemovePhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?