customerinfo.cs

客户订单管理系统 使用环境:&#61656 读者须安装好IIS和Microsoft Visual Stutio.NET相关开发环境

using System;
using System.Data ;
using COAdmin.COMMON;
using COAdmin.DAL ;

namespace COAdmin.BLL
{
	/// <summary>
	/// Customer 的摘要说明。
	/// </summary>
	public class CustomerInfo
	{
		public CustomerInfo()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		private int _customerID ;
		private string _custName;
		private string _sex ;
		private string _email ;
		private DateTime _birthday ;
		private string _province ;
		private string _city ;
		private string _address ;
		private string _postcode ;
		private string _income ;
		private string _education ;
		private string _marriage ;
		private string _occupation ;
		private DateTime _crdt ;
		private string _crusr ;
		private DateTime _mddt ;
		private string _mdusr ;
		private string _jifen ;

		#region 公共属性
		public int CustomerID
		{
			get{ return _customerID ; }
			set{ _customerID = value ;}
		}

		public string CustName
		{
			get{ return _custName ; }
			set{ _custName = value ;}
		}

		public string Sex
		{
			get{ return _sex ; }
			set{ _sex = value ;}
		}

		public string Email
		{
			get{ return _email ; }
			set{ _email = value ;}
		}

		public DateTime Birthday
		{
			get{ return _birthday ; }
			set{ _birthday = value ;}
		}

		public string Province
		{
			get{ return _province ; }
			set{ _province = value ;}
		}

		public string City
		{
			get{ return _city ; }
			set{ _city = value ;}
		}

		public string Address
		{
			get{ return _address ; }
			set{ _address = value ;}
		}

		public string Postcode
		{
			get{ return _postcode ; }
			set{ _postcode = value ;}
		}

		public string Income
		{
			get{ return _income ; }
			set{ _income = value ;}
		}

		public string Education
		{
			get{ return _education ; }
			set{ _education = value ;}
		}

		public string Marriage
		{
			get{ return _marriage ; }
			set{ _marriage = value ;}
		}

		public string Occupation
		{
			get{ return _occupation ; }
			set{ _occupation = value ;}
		}

		public DateTime Crdt
		{
			get{ return _crdt ; }
			set{ _crdt = value ;}
		}

		public string Crusr
		{
			get{ return _crusr ; }
			set{ _crusr = value ;}
		}

		public DateTime Mddt
		{
			get{ return _mddt ; }
			set{ _mddt = value ;}
		}

		public string Mdusr
		{
			get{ return _mdusr ; }
			set{ _mdusr = value ;}
		}

		public string Jifen
		{
			get{ return _jifen ; }
			set{ _jifen = value ;}
		}
		#endregion

		#region 公共方法
		/// <summary>
		/// 根据客户ID查询客户信息
		/// </summary>
		/// <param name="customerID">客户ID</param>
		/// <returns>查询结果 0:成功 1:失败</returns>
		public int GetCustomer(int customerID)
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_Customer_Get" ;
			//存储过程参数
			object[] para = new object[] {customerID} ;

			DataTable dt = DataAccess.ExecuteDataTable(spName,para) ;
			if(dt.Rows.Count > 0)
			{
				// 查询成功
				DataRow dr = dt.Rows[0] ;
				//指定客户基本信息的各个属性
				AssignAttribute(dr) ;
				ret = 0 ;
			}
			return ret ;
		}

		/// <summary>
		/// 指定客户信息属性
		/// </summary>
		/// <param name="dr">客户信息行</param>
		private void AssignAttribute(DataRow dr)
		{
			_customerID = CommHandler.StringToInt(dr["customerID"].ToString()) ;
			_custName = dr["CustName"].ToString() ;
			_sex = dr["Sex"].ToString() ;
			_email = dr["Email"].ToString() ;
			_birthday = CommHandler.StringToDateTime(dr["Birthday"].ToString()) ;
			_province = dr["Province"].ToString() ;
			_city = dr["City"].ToString() ;
			_address = dr["Address"].ToString() ;
			_postcode = dr["PostCode"].ToString() ;
			_income = dr["Income"].ToString() ;
			_education = dr["Education"].ToString() ;
			_marriage = dr["Marriage"].ToString() ;
			_occupation = dr["Occupation"].ToString() ;
			_crdt = CommHandler.StringToDateTime(dr["Crdt"].ToString()) ;
			_crusr = dr["Crusr"].ToString() ;
			_mddt = CommHandler.StringToDateTime(dr["Mddt"].ToString()) ;
			_mdusr = dr["Mdusr"].ToString() ;
			_jifen = dr["jifen"].ToString() ;
		}

		public static int DeleteCustomer(int customerID)
		{
			//存储过程名
			string spName = "CO_Customer_Delete" ;

			//存储过程参数
			object[] para = new object[] {customerID} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;

		}

		/// <summary>
		/// 添加客户信息
		/// </summary>
		/// <returns>结果：-1:失败 >0 成功</returns>
		public int AddCustomer()
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_Customer_Add" ;
			//存储过程参数
			object[] para = new object[] {"",_custName,_sex,_email,_birthday,_province,_city,_address,_postcode
										 ,_income,_education,_marriage,_occupation,_crusr} ;

			//调用数据访问方法执行存储过程			
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		/// <summary>
		/// 修改客户信息
		/// </summary>
		/// <returns>结果：-1:失败 >0 成功</returns>
		public int ModifyCustomer()
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_Customer_Modify" ;
			//存储过程参数
			object[] para = new object[] {_customerID,_custName,_sex,_email,_birthday,_province,_city,_address,_postcode
											 ,_income,_education,_marriage,_occupation,_crusr} ;

			//调用数据访问方法执行存储过程			
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		/// <summary>
		/// 查询客户礼券
		/// </summary>
		/// <param name="customerID">客户ID</param>
		/// <returns>DataTable</returns>
		public static DataTable GetCoupon(string customerID)
		{
			//存储过程名
			string spName = "CO_COUPON_Get" ;
			//存储过程参数
			object[] para = new object[] {customerID} ;
			// 返回查询结果列表
			return DataAccess.ExecuteDataTable(spName,para) ;	
		}

		/// <summary>
		/// 查看客户会员卡
		/// </summary>
		/// <param name="customerID">客户ID</param>
		/// <returns>DataTable</returns>
		public static DataTable GetLeaguer(string customerID)
		{
			//存储过程名
			string spName = "CO_Leaguer_Get" ;
			//存储过程参数
			object[] para = new object[] {customerID} ;
			// 返回查询结果列表
			return DataAccess.ExecuteDataTable(spName,para) ;	
		}
		#endregion


	}
}