service1.asmx.cs

专业实例开发

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient ;

namespace DTWebService
{
	/// <summary>
	/// Summary description for Service1.
	/// </summary>
	[WebService (Namespace="http://LocalHost/DTWebService/", Description="A service displaying catalogs of Deepthoughts Publications")]
	public class Service1 : System.Web.Services.WebService
	{
		public Service1()
		{
			//CODEGEN: This call is required by the ASP.NET Web Services Designer
			InitializeComponent();
		}

		

		private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		private System.Data.SqlClient.SqlConnection sqlConnection1;
		private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		private DTWebService.dsDetails dsDetails1;
		
		#region Component Designer generated code
		
		//Required by the Web Services Designer 
		private IContainer components = null;
				
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
			this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.dsDetails1 = new DTWebService.dsDetails();
			((System.ComponentModel.ISupportInitialize)(this.dsDetails1)).BeginInit();
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT ISBNNo, OrderNo, DateofOrder, CustomerName, CustomerAddress1, CustomerAddr" +
				"ess2, CustomerCity, CustomerState, OrderedBy, Status FROM DTOrders";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO DTOrders(ISBNNo, OrderNo, DateofOrder, CustomerName, CustomerAddress1, CustomerAddress2, CustomerCity, CustomerState, OrderedBy, Status) VALUES (@ISBNNo, @OrderNo, @DateofOrder, @CustomerName, @CustomerAddress1, @CustomerAddress2, @CustomerCity, @CustomerState, @OrderedBy, @Status); SELECT ISBNNo, OrderNo, DateofOrder, CustomerName, CustomerAddress1, CustomerAddress2, CustomerCity, CustomerState, OrderedBy, Status FROM DTOrders WHERE (ISBNNo = @ISBNNo) AND (OrderNo = @OrderNo)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ISBNNo", System.Data.SqlDbType.VarChar, 10, "ISBNNo"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrderNo", System.Data.SqlDbType.VarChar, 10, "OrderNo"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateofOrder", System.Data.SqlDbType.DateTime, 8, "DateofOrder"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerName", System.Data.SqlDbType.VarChar, 50, "CustomerName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerAddress1", System.Data.SqlDbType.VarChar, 50, "CustomerAddress1"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerAddress2", System.Data.SqlDbType.VarChar, 50, "CustomerAddress2"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerCity", System.Data.SqlDbType.VarChar, 20, "CustomerCity"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerState", System.Data.SqlDbType.VarChar, 10, "CustomerState"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrderedBy", System.Data.SqlDbType.VarChar, 50, "OrderedBy"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Status", System.Data.SqlDbType.VarChar, 20, "Status"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE DTOrders SET ISBNNo = @ISBNNo, OrderNo = @OrderNo, DateofOrder = @DateofOrder, CustomerName = @CustomerName, CustomerAddress1 = @CustomerAddress1, CustomerAddress2 = @CustomerAddress2, CustomerCity = @CustomerCity, CustomerState = @CustomerState, OrderedBy = @OrderedBy, Status = @Status WHERE (ISBNNo = @Original_ISBNNo) AND (OrderNo = @Original_OrderNo) AND (CustomerAddress1 = @Original_CustomerAddress1) AND (CustomerAddress2 = @Original_CustomerAddress2 OR @Original_CustomerAddress2 IS NULL AND CustomerAddress2 IS NULL) AND (CustomerCity = @Original_CustomerCity) AND (CustomerName = @Original_CustomerName) AND (CustomerState = @Original_CustomerState) AND (DateofOrder = @Original_DateofOrder) AND (OrderedBy = @Original_OrderedBy) AND (Status = @Original_Status); SELECT ISBNNo, OrderNo, DateofOrder, CustomerName, CustomerAddress1, CustomerAddress2, CustomerCity, CustomerState, OrderedBy, Status FROM DTOrders WHERE (ISBNNo = @ISBNNo) AND (OrderNo = @OrderNo)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ISBNNo", System.Data.SqlDbType.VarChar, 10, "ISBNNo"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrderNo", System.Data.SqlDbType.VarChar, 10, "OrderNo"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateofOrder", System.Data.SqlDbType.DateTime, 8, "DateofOrder"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerName", System.Data.SqlDbType.VarChar, 50, "CustomerName"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerAddress1", System.Data.SqlDbType.VarChar, 50, "CustomerAddress1"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerAddress2", System.Data.SqlDbType.VarChar, 50, "CustomerAddress2"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerCity", System.Data.SqlDbType.VarChar, 20, "CustomerCity"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerState", System.Data.SqlDbType.VarChar, 10, "CustomerState"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrderedBy", System.Data.SqlDbType.VarChar, 50, "OrderedBy"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Status", System.Data.SqlDbType.VarChar, 20, "Status"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ISBNNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ISBNNo", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_OrderNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OrderNo", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerAddress1", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerAddress1", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerAddress2", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerAddress2", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerCity", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerCity", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerName", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerState", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerState", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_DateofOrder", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateofOrder", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_OrderedBy", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OrderedBy", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Status", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Status", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM DTOrders WHERE (ISBNNo = @Original_ISBNNo) AND (OrderNo = @Original_OrderNo) AND (CustomerAddress1 = @Original_CustomerAddress1) AND (CustomerAddress2 = @Original_CustomerAddress2 OR @Original_CustomerAddress2 IS NULL AND CustomerAddress2 IS NULL) AND (CustomerCity = @Original_CustomerCity) AND (CustomerName = @Original_CustomerName) AND (CustomerState = @Original_CustomerState) AND (DateofOrder = @Original_DateofOrder) AND (OrderedBy = @Original_OrderedBy) AND (Status = @Original_Status)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ISBNNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ISBNNo", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_OrderNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OrderNo", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerAddress1", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerAddress1", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerAddress2", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerAddress2", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerCity", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerCity", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerState", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerState", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_DateofOrder", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateofOrder", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_OrderedBy", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OrderedBy", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Status", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Status", System.Data.DataRowVersion.Original, null));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "data source=YS-D185;initial catalog=DTDB;integrated security=SSPI;persist securit" +
				"y info=True;workstation id=YS-D185;packet size=4096";
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "DTOrders", new System.Data.Common.DataColumnMapping[] {
																																																				  new System.Data.Common.DataColumnMapping("ISBNNo", "ISBNNo"),
																																																				  new System.Data.Common.DataColumnMapping("OrderNo", "OrderNo"),
																																																				  new System.Data.Common.DataColumnMapping("DateofOrder", "DateofOrder"),
																																																				  new System.Data.Common.DataColumnMapping("CustomerName", "CustomerName"),
																																																				  new System.Data.Common.DataColumnMapping("CustomerAddress1", "CustomerAddress1"),
																																																				  new System.Data.Common.DataColumnMapping("CustomerAddress2", "CustomerAddress2"),
																																																				  new System.Data.Common.DataColumnMapping("CustomerCity", "CustomerCity"),
																																																				  new System.Data.Common.DataColumnMapping("CustomerState", "CustomerState"),
																																																				  new System.Data.Common.DataColumnMapping("OrderedBy", "OrderedBy"),
																																																				  new System.Data.Common.DataColumnMapping("Status", "Status")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// dsDetails1
			// 
			this.dsDetails1.DataSetName = "dsDetails";
			this.dsDetails1.Locale = new System.Globalization.CultureInfo("en-US");
			this.dsDetails1.Namespace = "http://www.tempuri.org/dsDetails.xsd";
			((System.ComponentModel.ISupportInitialize)(this.dsDetails1)).EndInit();

		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion

		// WEB SERVICE EXAMPLE
		// The HelloWorld() example service returns the string Hello World
		// To build, uncomment the following lines then save and build the project
		// To test this web service, press F5

//		[WebMethod]
//		public string HelloWorld()
//		{
//			return "Hello World";
//		}

		[WebMethod(Description="This method accepts the details of Customer who opt " +
			 " for a book published by Deepthoughts Publications")]
		public string AcceptDetails(string ISBN, string DateOrder, string CustName, string CustAddr1, string CustAddr2, string CustCity, string CustState, string OrdBy, string OrdStat, string CardType, string CardNum)