smservice.asmx.cs

一个基于b/s下的进销存管理系统.c#.net+sql_server 可作为有一定基础的人学习参考.

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 WebService4
{
	/// <summary>
	/// Service1 的摘要说明。
	/// </summary>
	 
	[WebService(Namespace="CPWS")]

	public class Service1 : System.Web.Services.WebService
	{
		public Service1()
		{
			//CODEGEN: 该调用是 ASP.NET Web 服务设计器所必需的
			InitializeComponent();
		}

		private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		private System.Data.SqlClient.SqlConnection sqlConnection1;
		private WebService4.DataSet1 dataSet11;
		private System.Data.SqlClient.SqlCommand sqlCommand1;

		#region 组件设计器生成的代码
		
		//Web 服务设计器所必需的
		private IContainer components = null;
				
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
			this.dataSet11 = new WebService4.DataSet1();
			this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
																																																			   new System.Data.Common.DataColumnMapping("Expr1", "Expr1")})});
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT 1 AS Expr1";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=YANJIANJIN;packet size=4096;user id=smsadmin;data source=\"FJCC-HP\\" +
				"SMSDBSVR\";persist security info=True;initial catalog=CoverM_V20;password=123456";
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// sqlCommand1
			// 
			this.sqlCommand1.Connection = this.sqlConnection1;
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();

		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion

		// WEB 服务示例
		// HelloWorld() 示例服务返回字符串 Hello World
		// 若要生成，请取消注释下列行，然后保存并生成项目
		// 若要测试此 Web 服务，请按 F5 键

		[WebMethod] 
		public int EasySendOneMessageEX(string OrgAddr,string DestAddr,string Msg,string ServiceCode,string FeeUserType,
			string FeeTerminal,string LinkID,string MsgSrc,string Password) 
		{
			sqlDataAdapter1.SelectCommand.CommandText = "SELECT a.FSPNumber,b.fname FROM CP_SPList a LEFT OUTER JOIN CP_SPListStatus b "
				+ "ON a.FState = b.FID where FUserID='" + MsgSrc + "'";
			sqlDataAdapter1.Fill(dataSet11);
			string FSP = dataSet11.Tables[0].Rows[0][1].ToString();
			string fname = dataSet11.Tables[0].Rows[0][2].ToString();
			if((MsgSrc=="100000")&&(Password=="100000"))
			{
				return 1;
			}
			else
			{
				sqlCommand1.CommandText = "xp_GetSPNumberFromMobile";
				sqlCommand1.CommandType = CommandType.StoredProcedure;
				//添加参数
				sqlCommand1.Parameters.Add("@Mobile",DestAddr);
				SqlParameter SPNumber = new SqlParameter("@SPNumber",SqlDbType.VarChar); 
				SPNumber.Direction = ParameterDirection.Output;
				SPNumber.Size = 10;
				sqlCommand1.Parameters.Add(SPNumber);
				//执行存储过程
				sqlCommand1.Connection.Open();
				sqlCommand1.ExecuteNonQuery();
				sqlCommand1.Connection.Close();
				string SPN = (string)(sqlCommand1.Parameters["@SPNumber"].Value);
				if(OrgAddr==SPN+FSP)
				{
					if(fname=="运营中")
					{
						int rv=100;
						int tmp=0;
						sqlCommand1.CommandText = "xp_EasySendOneMessageEX";
						sqlCommand1.CommandType = CommandType.StoredProcedure;
						//添加参数
						sqlCommand1.Parameters.Clear();
						SqlParameter ParameterResults = new SqlParameter("@ReturnValue",SqlDbType.Int); 
						ParameterResults.Direction = ParameterDirection.ReturnValue;
						sqlCommand1.Parameters.Add(ParameterResults);
						sqlCommand1.Parameters.Add("@OrgAddr",OrgAddr);
						sqlCommand1.Parameters.Add("@DestAddr",DestAddr);
						sqlCommand1.Parameters.Add("@Msg",Msg);
						sqlCommand1.Parameters.Add("@ServiceCode",ServiceCode);
						sqlCommand1.Parameters.Add("@FeeUserType",FeeUserType);
						sqlCommand1.Parameters.Add("@FeeTerminal",FeeTerminal);
						sqlCommand1.Parameters.Add("@LinkID",LinkID);
						sqlCommand1.Parameters.Add("@MoMtFlag",tmp);
						sqlCommand1.Parameters.Add("@ReportFlag",0);
						sqlCommand1.Parameters.Add("@MsgSrc",MsgSrc);
						sqlCommand1.Parameters.Add("@Password",Password);
						//执行存储过程
						sqlCommand1.Connection.Open();
						sqlCommand1.ExecuteNonQuery();
						sqlCommand1.Connection.Close();
						rv = (int)(sqlCommand1.Parameters["@ReturnValue"].Value);
						return rv;
					}
					else
					{
						return 6;
					}
				}
				else
				{
					return 4;
				}
			}
		} 

		[WebMethod]
		public int IS_DZUSER(string CPNumber,string Mobile,string ServiceCode,string MsgSrc,string Password)
		{
			if((MsgSrc=="test")&&(Password=="test123456"))
			{
				int rv = 100;
				sqlCommand1.CommandText = "XP_IS_DZUSER";
				sqlCommand1.CommandType = CommandType.StoredProcedure;
				//添加参数
				sqlCommand1.Parameters.Add("@SPNumber",CPNumber);
				sqlCommand1.Parameters.Add("@Mobile",Mobile);
				sqlCommand1.Parameters.Add("@servicecode",ServiceCode);
				SqlParameter ret = new SqlParameter("@ret",SqlDbType.Int); 
				ret.Direction = ParameterDirection.Output;
				sqlCommand1.Parameters.Add(ret);
				//执行存储过程
				sqlCommand1.Connection.Open();
				sqlCommand1.ExecuteNonQuery();
				sqlCommand1.Connection.Close();
				rv = (int)(sqlCommand1.Parameters["@ret"].Value);
				return rv;
			}
			else
			{
				return 100;
			}
		}

		[WebMethod]
		public int Rev_UserMsg(string OrgAddr,string OrgAddrType,string DestAddr,string ServiceCode,string RevMsg,string LinkID,
			int DzState,int MsgType,string ReturnMsg,string SPID,string Password)
		{
			return 100;
		}
	}
}