customer.aspx.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Xml ;
using COAdmin.COMMON ;
using COAdmin.BLL ;

namespace COAdmin.USL
{
	/// <summary>
	/// Customer 的摘要说明。
	/// </summary>
	public class Customer : System.Web.UI.Page
	{
		#region 控件和变量
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.RequiredFieldValidator R1;
		protected System.Web.UI.WebControls.Button b_Search;
		protected System.Web.UI.WebControls.Button b_Save;
		protected System.Web.UI.WebControls.Button b_Clear;
		protected System.Web.UI.WebControls.TextBox tb_Name;
		protected System.Web.UI.WebControls.Button b_Coupon;
		protected System.Web.UI.WebControls.Button b_Leaguer;
		protected System.Web.UI.HtmlControls.HtmlSelect CITY;
		protected System.Web.UI.WebControls.TextBox tb_Birthday;
		protected System.Web.UI.WebControls.TextBox tb_Jifen;
		protected System.Web.UI.HtmlControls.HtmlSelect PROVINCE;
		protected System.Web.UI.HtmlControls.HtmlImage Img3;
		protected System.Web.UI.WebControls.DropDownList ddl_Income;
		protected System.Web.UI.WebControls.DropDownList ddl_Merriage;
		protected System.Web.UI.WebControls.DropDownList ddl_Education;
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Web.UI.WebControls.Button b_AddTel;
		protected System.Web.UI.WebControls.Button b_ModTel;
		protected System.Web.UI.WebControls.Button b_DelTel;
		protected System.Web.UI.WebControls.TextBox tb_CrUsr;
		protected System.Web.UI.WebControls.TextBox tb_CrDT;
		protected System.Web.UI.WebControls.TextBox tb_MdUsr;
		protected System.Web.UI.WebControls.TextBox tb_MDDT;
		protected System.Web.UI.WebControls.DropDownList ddl_Occupation;
		protected System.Web.UI.WebControls.TextBox tb_Address;
		protected System.Web.UI.WebControls.TextBox tb_PostCode;
		protected System.Web.UI.WebControls.TextBox tb_Email;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator1;
		protected System.Web.UI.HtmlControls.HtmlInputHidden hProviceNo;
		protected System.Web.UI.HtmlControls.HtmlInputHidden hCityNo;
		protected System.Web.UI.HtmlControls.HtmlInputHidden hProvice;
		protected System.Web.UI.HtmlControls.HtmlInputHidden hCity;
		protected System.Web.UI.HtmlControls.HtmlInputHidden hID;
		protected System.Web.UI.WebControls.DropDownList ddl_Sex;
		Usr usr = null ;
		protected System.Web.UI.WebControls.DropDownList ddl_TelType;
		protected System.Web.UI.WebControls.TextBox tb_Area;
		protected System.Web.UI.WebControls.TextBox tb_Phone;
		protected System.Web.UI.WebControls.TextBox tb_Ext;
		protected System.Web.UI.WebControls.CheckBox cb_Priority;
		protected System.Web.UI.HtmlControls.HtmlInputHidden hTELID;
		DataTable dtTel = null ;
		#endregion
	
		#region Page_Load
		private void Page_Load(object sender, System.EventArgs e)
		{
			usr = COAdminGlobals.LoginUsr ;

			if(usr == null)
			{
				//重定义到登录页面
				CommHandler.ReDirURL(Page) ;
			}

			dtTel = (DataTable)Session["dtTel"] ;
			if(dtTel==null)
			{
				dtTel = new DataTable() ;
			}

			if(!IsPostBack)
			{
				//初始化下拉框
				InitDDL() ;
				int id = CommHandler.StringToInt(CommHandler.GetRequest(Page,"CID")) ;
				if(id > 0)
				{
					GetCust(id) ;
				}
			}

			CommHandler.BindGrid(dg,dtTel) ;
		}

		/// <summary>
		/// 初始化下拉框
		/// </summary>
		private void InitDDL()
		{
			//职业
			CommHandler.DDL_Init(this.ddl_Occupation,"OCCUPATION",true) ;
			//教育
			CommHandler.DDL_Init(this.ddl_Education,"EDUCATION",true) ;
			//收入
			CommHandler.DDL_Init(this.ddl_Income,"INCOME",true) ;
			//电话类型
			CommHandler.DDL_Init(this.ddl_TelType,"TELTYPE",false) ;
		}

		/// <summary>
		/// 按ID获取客户信息
		/// </summary>
		/// <param name="id">客户ID</param>
		private void GetCust(int id)
		{
			// 实例客户基本信息对象
			CustomerInfo ci = new CustomerInfo() ;

			//查询客户信息
			if(ci.GetCustomer(id)==0)
			{
				//将客户信息显示在界面
				ShowInfo(ci) ;
			}
		}

		/// <summary>
		/// 将客户信息显示在界面
		/// </summary>
		/// <param name="ci">客户基本信息对象</param>
		private void ShowInfo(CustomerInfo ci)
		{
			//显示客户信息前，先将以前的Session清空
			ClearCust() ;

			//将各信息显示在界面
			this.tb_Address.Text = ci.Address ;
			 this.tb_Birthday.Text = CommHandler.DateTimeToString(ci.Birthday)  ;
			this.tb_CrDT.Text = CommHandler.DateTimeToString(ci.Crdt) ;
			this.tb_CrUsr.Text = ci.Crusr ;
			this.tb_MDDT.Text = CommHandler.DateTimeToString(ci.Mddt) ; 
			this.tb_Name.Text = ci.CustName ;
			this.tb_Jifen.Text = ci.Jifen ;
			CommHandler.DDL_ShowItem(ddl_Education,ci.Education) ;
			this.tb_Email.Text = ci.Email ;
			CommHandler.DDL_ShowItem(this.ddl_Income,ci.Income )  ;
			CommHandler.DDL_ShowItem(ddl_Merriage,ci.Marriage) ;
			CommHandler.DDL_ShowItem(ddl_Occupation,ci.Occupation) ;
			CommHandler.DDL_ShowItem(ddl_Sex,ci.Sex ) ;
			this.tb_PostCode.Text = ci.Postcode ;
			this.hID.Value = ci.CustomerID.ToString() ;

			//将相关信息存入Seesion备用
			COAdminGlobals.CustomerID = ci.CustomerID ;
			COAdminGlobals.CustomerName = ci.CustName ;
			COAdminGlobals.Address = ci.Address ;

			//显示省份和城市信息
			ShowPROVICE(ci.Province,ci.City) ;		
	
			//显示电话信息
			this.InitTel(hID.Value) ;
		}

		//读取ProviceCity.xml查询初始化时用
		private void ShowPROVICE(string PROVICE,string CITY)
		{
			string path = COAdminGlobals.ConfigFilePath + "ProviceCity.xml" ;
			System.Xml.XmlDocument  addrXML=new XmlDocument ();
			addrXML.Load(path) ; 

			XmlNode nR = addrXML.SelectSingleNode("//ROOT");
			for(int i=0;i<nR.ChildNodes.Count;i++)
			{
				// 显示省份下拉框
				XmlNode nP = nR.ChildNodes[i];
				if(nP.Attributes["ID"].InnerText.Trim() == PROVICE.Trim())
				{
					hProviceNo.Value= i.ToString();
					ShowCITY(CITY,nP);
					break ;
				}
			}
		}

		/// <summary>
		/// 根据省份节点和城市的选中项显示城市下拉框
		/// </summary>
		/// <param name="CITY">城市下拉框的选中项</param>
		/// <param name="nP">省份节点</param>
		private void ShowCITY(string CITY,XmlNode nP)
		{
			//逐个获取省份节点的子节点，匹配城市下拉框的选中项
			for(int i=0;i<nP.ChildNodes.Count;i++)
			{
				XmlNode nCi = nP.ChildNodes[i];
				//如果ID与要显示的项相当，显示此项
				if(nCi.Attributes["ID"].InnerText.Trim() == CITY.Trim())
				{
					hCityNo.Value= i.ToString();
					break ;
				}
			}
		}

		/// <summary>
		/// 清空客户信息
		/// </summary>
		private void ClearCust()
		{
			Session["dtLeaguer"] = null ;
			Session["dtTel"] = null ;
			Session["dtCoupon"] = null ;
			COAdminGlobals.CustomerID = 0 ;
		}
		#endregion

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.b_Search.Click += new System.EventHandler(this.b_Search_Click);
			this.b_Save.Click += new System.EventHandler(this.b_Save_Click);
			this.b_Clear.Click += new System.EventHandler(this.b_Clear_Click);
			this.b_Coupon.Click += new System.EventHandler(this.b_Coupon_Click);
			this.b_Leaguer.Click += new System.EventHandler(this.b_Leaguer_Click);
			this.dg.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dg_ItemCommand);
			this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);
			this.b_AddTel.Click += new System.EventHandler(this.b_AddTel_Click);
			this.b_ModTel.Click += new System.EventHandler(this.b_ModTel_Click);
			this.b_DelTel.Click += new System.EventHandler(this.b_DelTel_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		#region 查询客户
		private void b_Search_Click(object sender, System.EventArgs e)
		{
			//先检查用户角色
			if(!usr.HasRole("SrchCust"))
			{
				CommHandler.Alert(Page,"对不起，您不具备查询客户角色！") ;
				return ;
			}
			//弹出页面查询客户
			string url = "Cust_Search.aspx" ;

			CommHandler.IFrame_PopUp(Page,url,"600","500") ;
		}
		#endregion

		#region 保存客户
		private void b_Save_Click(object sender, System.EventArgs e)
		{
			int id =  CommHandler.StringToInt(hID.Value) ;
			//实例一个客户信息对象
			CustomerInfo ci = new CustomerInfo() ;