client.aspx.cs

一套OA系统,使用SQL Server为后台数据库ASP.NET C#语言开发

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.IO;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using UDS.Components;

namespace UDS.SubModule.CM
{
	/// <summary>
	/// Clinet 的摘要说明。
	/// </summary>
	public class Client : System.Web.UI.Page
	{
		#region 声明
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.TextBox tbx_introduce;
		protected System.Web.UI.WebControls.Panel pnl_Client;
		protected System.Web.UI.HtmlControls.HtmlInputFile File1;
		protected System.Web.UI.WebControls.Repeater rpt_Attachment;
		protected System.Web.UI.WebControls.Literal ltl_ID;
		protected System.Web.UI.WebControls.TextBox tbx_Birthday;
		protected System.Web.UI.WebControls.TextBox tbx_ShortName;
		protected System.Web.UI.WebControls.TextBox tbx_Name;
		protected System.Web.UI.WebControls.CheckBox cbx_zhongduan;
		protected System.Web.UI.WebControls.CheckBox cbx_qudao;
		protected System.Web.UI.WebControls.CheckBox cbx_shehui;
		protected System.Web.UI.WebControls.CheckBox cbx_meiti;
		protected System.Web.UI.WebControls.Label lbl_position;
		protected System.Web.UI.WebControls.Label lbl_chieftel;
		protected System.Web.UI.WebControls.TextBox tbx_UpdateTime;
		protected System.Web.UI.WebControls.Literal ltl_AddManName;
		protected System.Web.UI.WebControls.Literal ltl_addmantel;
		protected System.Web.UI.WebControls.TextBox tbx_affiliatedarea;
		protected System.Web.UI.WebControls.TextBox tbx_URL;
		protected System.Web.UI.WebControls.TextBox tbx_zip;
		protected System.Web.UI.WebControls.TextBox tbx_address;
		protected System.Web.UI.WebControls.CheckBox cbx_realestate;
		protected System.Web.UI.WebControls.CheckBox cbx_IT;
		protected System.Web.UI.WebControls.CheckBox cbx_business;
		protected System.Web.UI.WebControls.CheckBox cbx_telecom;
		protected System.Web.UI.WebControls.CheckBox cbx_post;
		protected System.Web.UI.WebControls.CheckBox cbx_consultation;
		protected System.Web.UI.WebControls.CheckBox cbx_travel;
		protected System.Web.UI.WebControls.CheckBox cbx_bus;
		protected System.Web.UI.WebControls.CheckBox cbx_stock;
		protected System.Web.UI.WebControls.CheckBox cbx_insurance;
		protected System.Web.UI.WebControls.CheckBox cbx_tax;
		protected System.Web.UI.WebControls.CheckBox cbx_make;
		protected System.Web.UI.WebControls.CheckBox cbx_electric;
		protected System.Web.UI.WebControls.CheckBox cbx_clothe;
		protected System.Web.UI.WebControls.CheckBox cbx_food;
		protected System.Web.UI.WebControls.CheckBox cbx_medicine;
		protected System.Web.UI.WebControls.CheckBox cbx_mechanism;
		protected System.Web.UI.WebControls.CheckBox cbx_auto;
		protected System.Web.UI.WebControls.TextBox tbx_staffnumber;
		protected System.Web.UI.WebControls.TextBox tbx_money;
		protected System.Web.UI.WebControls.TextBox tbx_operation;
		protected System.Web.UI.WebControls.TextBox tbx_IT;
		protected System.Web.UI.WebControls.TextBox tbx_pcnumber;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.CheckBox cbx_LAN;
		protected System.Web.UI.WebControls.CheckBox cbx_WAN;
		protected System.Web.UI.WebControls.CheckBox cbx_internet;
		protected System.Web.UI.WebControls.TextBox tbx_ITStaffs;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox tbx_ITdepartment;
		protected System.Web.UI.WebControls.TextBox tbx_principal;
		protected System.Web.UI.WebControls.TextBox tbx_system;
		protected System.Web.UI.WebControls.CheckBox cbx_sellman;
		protected System.Web.UI.WebControls.CheckBox cbx_just;
		protected System.Web.UI.WebControls.CheckBox cbx_introduce;
		protected System.Web.UI.WebControls.CheckBox cbx_customer;
		protected System.Web.UI.WebControls.CheckBox cbx_Email;
		protected System.Web.UI.WebControls.CheckBox cbx_media;
		protected System.Web.UI.WebControls.CheckBox cbx_Web;
		protected System.Web.UI.WebControls.CheckBox cbx_proseminar;
		protected System.Web.UI.WebControls.CheckBox cbx_exhibition;
		protected System.Web.UI.WebControls.CheckBox cbx_EMS;
		protected System.Web.UI.WebControls.Panel penal;
		protected System.Web.UI.WebControls.Button btn_OK;
		protected System.Web.UI.WebControls.CustomValidator CustomValidator1;
		protected System.Web.UI.WebControls.CheckBox cbx_market;
		protected System.Web.UI.WebControls.CheckBox cbx_foreign;
		protected System.Web.UI.WebControls.CheckBox cbx_private;
		protected System.Web.UI.WebControls.CheckBox cbx_stateowned;
		protected System.Web.UI.WebControls.CheckBox cbx_government;
		protected System.Web.UI.WebControls.Button btn_AddContact;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.DropDownList ddl_AddMan;
		protected System.Web.UI.WebControls.Panel pnl_Leader;
		protected System.Web.UI.WebControls.Button btn_LookTel;
		protected System.Web.UI.WebControls.Button btn_ChangeAddMan;
		protected System.Web.UI.WebControls.Panel pnl_MyCustom;
		protected System.Web.UI.WebControls.Panel pnl_Leader1;
		protected System.Web.UI.WebControls.Button btn_LookContact;
		protected System.Web.UI.WebControls.Label lbl_Message;
		#endregion
		protected System.Web.UI.WebControls.HyperLink hlk_Chiefman;

		protected int clientid;

		private void Page_Load(object sender, System.EventArgs e)
		{
			UDS.Components.CM cm = new UDS.Components.CM();

			if(!Page.IsPostBack)
			{
				tbx_UpdateTime.Text = DateTime.Now.ToShortDateString();
				//得到添加人的信息
                UDS.Components.Staff staff = new UDS.Components.Staff();

				#region 显示客户原有信息
				UDS.Components.ClientInfo client = cm.GetClientAllInfo((Request.QueryString["ClientID"]==null)?0:Int32.Parse(Request.QueryString["ClientID"].ToString()));
				ViewState["ClientID"] = client.ID;
				clientid = client.ID;

				/* 权限判断
				 * 如果是上级则出现下拉菜单，并可重新指定客户经理
				 * 其它则无下拉菜单
				 */
				if(Session["cm_permission"].ToString()=="leader")
				{
					//绑定下拉列表
					pnl_Leader.Visible = true;
					ltl_AddManName.Visible = ltl_addmantel.Visible = false;
					//不出现修改按钮
					pnl_MyCustom.Visible = false;
					pnl_Leader1.Visible = true;

					BindAddManList();
					//添加人默认选中
					ddl_AddMan.Items.FindByValue(client.AddManID.ToString()).Selected = true;
				}
				else
				{
					pnl_Leader.Visible = false;
					ltl_AddManName.Visible = ltl_addmantel.Visible = true;
					SqlDataReader dr_staff = null;

					if(client.ID!=0)
					{
						dr_staff = staff.GetStaffInfo(client.AddManID);
						while(dr_staff.Read())
						{
							ltl_AddManName.Text = dr_staff["realname"].ToString();
							ltl_addmantel.Text = dr_staff["Mobile"].ToString();
						}
					}
					else
					{
						dr_staff = staff.GetStaffInfo(Int32.Parse(Request.Cookies["UserID"].Value));
						while(dr_staff.Read())
						{
							ltl_AddManName.Text = dr_staff["realname"].ToString();
							ltl_addmantel.Text = dr_staff["Mobile"].ToString();
						}
					}
					dr_staff.Close();
				}
				

				ltl_ID.Text = (client.ID.ToString()=="0")?"":client.ID.ToString();
				tbx_ShortName.Text = client.ClientShortName;
				tbx_Name.Text = client.ClientName;
				if(clientid!=0)
					tbx_Birthday.Text = client.Birthday.ToShortDateString();
				else
					tbx_Birthday.Text = DateTime.Now.ToShortDateString();

				if(client.ClientType.IndexOf(ClientType.terminal.ToString())>=0) cbx_zhongduan.Checked = true;
				if(client.ClientType.IndexOf(ClientType.channal.ToString())>=0) cbx_qudao.Checked = true;
				if(client.ClientType.IndexOf(ClientType.social.ToString())>=0) cbx_shehui.Checked = true;
				if(client.ClientType.IndexOf(ClientType.media.ToString())>=0) cbx_meiti.Checked = true;
				//得到主要联系人的信息
				SqlDataReader dr_chief = cm.GetLinkmanByID(client.ChiefLinkmanID.ToString());
				while(dr_chief.Read())
				{
					
					if(Session["cm_permission"].ToString()=="administrator")
					{
						hlk_Chiefman.Text = dr_chief["name"].ToString();
						hlk_Chiefman.NavigateUrl = "Linkman.aspx?LinkmanID=" + dr_chief["id"].ToString();
						hlk_Chiefman.Target = "_blank";
					}
					else
					{
						hlk_Chiefman.Text = dr_chief["name"].ToString();
					}
				
					lbl_position.Text = dr_chief["position"].ToString();
					lbl_chieftel.Text = dr_chief["telephone"].ToString();
				}
				dr_chief.Close();
				tbx_affiliatedarea.Text = client.Affiliatedarea;
				tbx_URL.Text = client.URL;
				tbx_zip.Text = client.ZIP;
				tbx_address.Text = client.Address;

				if(client.CompanyProperty.IndexOf(EnterpriseType.government.ToString())>=0) cbx_government.Checked = true;
				if(client.CompanyProperty.IndexOf(EnterpriseType.contry.ToString())>=0) cbx_stateowned.Checked = true;
				if(client.CompanyProperty.IndexOf(EnterpriseType.privateowned.ToString())>=0) cbx_private.Checked = true;
				if(client.CompanyProperty.IndexOf(EnterpriseType.oversea.ToString())>=0) cbx_foreign.Checked = true;
				if(client.CompanyProperty.IndexOf(EnterpriseType.stock.ToString())>=0) cbx_market.Checked = true;

				if(client.ClientTrade.IndexOf(ClientTrade.realty.ToString())>=0) cbx_realestate.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.IT.ToString())>=0) cbx_IT.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.business.ToString())>=0) cbx_business.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.telecom.ToString())>=0) cbx_telecom.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.post.ToString())>=0) cbx_post.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.refer.ToString())>=0) cbx_consultation.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.travel.ToString())>=0) cbx_travel.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.bus.ToString())>=0) cbx_bus.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.stock.ToString())>=0) cbx_stock.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.insurance.ToString())>=0) cbx_insurance.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.tax.ToString())>=0) cbx_tax.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.make.ToString())>=0) cbx_make.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.he.ToString())>=0) cbx_electric.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.clothe.ToString())>=0) cbx_clothe.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.food.ToString())>=0) cbx_food.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.medicine.ToString())>=0) cbx_medicine.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.mechanism.ToString())>=0) cbx_mechanism.Checked = true;
				if(client.ClientTrade.IndexOf(ClientTrade.auto.ToString())>=0) cbx_auto.Checked = true;

				tbx_staffnumber.Text = client.CompanySize;
				tbx_money.Text = client.Money;
				tbx_operation.Text = client.Operation;
				tbx_introduce.Text = client.Introduce;
				tbx_IT.Text = client.ITGrade;
				tbx_pcnumber.Text = client.PCNumber.ToString();
				
				if(client.Net.IndexOf(ClientNet.LAN.ToString())>=0) cbx_LAN.Checked = true;
				if(client.Net.IndexOf(ClientNet.WAN.ToString())>=0) cbx_WAN.Checked = true;
				if(client.Net.IndexOf(ClientNet.INTERNET.ToString())>=0) cbx_internet.Checked = true;

				tbx_ITStaffs.Text = client.ITStaffs.ToString();
				tbx_ITdepartment.Text = client.ITDepartment;
				tbx_principal.Text = client.Principal;
				tbx_system.Text = client.System;

				if(client.ClientSource.IndexOf(ClientSource.sellman.ToString())>=0) cbx_sellman.Checked = true;
				if(client.ClientSource.IndexOf(ClientSource.familiar.ToString())>=0) cbx_just.Checked = true;
				if(client.ClientSource.IndexOf(ClientSource.introduce.ToString())>=0) cbx_introduce.Checked = true;
				if(client.ClientSource.IndexOf(ClientSource.client.ToString())>=0) cbx_customer.Checked = true;

				if(client.ClientInitiative.IndexOf(ClientInitiative.media.ToString())>=0) cbx_media.Checked = true;
				if(client.ClientInitiative.IndexOf(ClientInitiative.searchweb.ToString())>=0) cbx_Web.Checked = true;
				if(client.ClientInitiative.IndexOf(ClientInitiative.proseminar.ToString())>=0) cbx_proseminar.Checked = true;
				if(client.ClientInitiative.IndexOf(ClientInitiative.exhibition.ToString())>=0) cbx_exhibition.Checked = true;
				if(client.ClientInitiative.IndexOf(ClientInitiative.post.ToString())>=0) cbx_EMS.Checked = true;
				if(client.ClientInitiative.IndexOf(ClientInitiative.email.ToString())>=0) cbx_Email.Checked = true;
				#endregion

				if(clientid==0)
				{
					btn_OK.Text = "添加";
					CustomValidator1.Enabled = true;
				}
				else
				{
					btn_OK.Text = "修改";
					CustomValidator1.Enabled = false;
				}

				penal.Visible = cbx_customer.Checked;
			}
			else
			{
				clientid = Int32.Parse(ViewState["ClientID"].ToString());

				//显示联系人
				string tmplinkmanid1 = (Session["tmplinkmanid"]==null)?"":Session["tmplinkmanid"].ToString();
				foreach(string linkmanid in tmplinkmanid1.Split(','))
				{
					if(linkmanid.Trim()!="")
					{
						UDS.Components.Linkman linkman = new UDS.Components.Linkman();
						UDS.Components.CM cm1 = new UDS.Components.CM();
						linkman = cm1.GetLinkmanStructByID(linkmanid);
						
						if(Session["cm_permission"].ToString()=="administrator")
						{
							hlk_Chiefman.Text = linkman.Name;
							hlk_Chiefman.NavigateUrl = "Linkman.aspx?LinkmanID=" + linkman.ID;
							hlk_Chiefman.Target = "_blank";
						}
						else
						{
							hlk_Chiefman.Text = linkman.Name;;
						}
						
						lbl_position.Text = linkman.Position;
						lbl_chieftel.Text = linkman.Telephone;
					}
				}
			}

			if(clientid!=0)
			{
				rpt_Attachment.DataSource = cm.GetAttachmentByClientID(clientid);
				rpt_Attachment.DataBind();
			}

			if(clientid==0) 
				btn_AddContact.Visible = false;
			else
				btn_AddContact.Visible = true;
			
		}

		
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.CustomValidator1.ServerValidate += new System.Web.UI.WebControls.ServerValidateEventHandler(this.CustomValidator1_ServerValidate);
			this.tbx_ShortName.TextChanged += new System.EventHandler(this.tbx_ShortName_TextChanged);
			this.btn_LookTel.Click += new System.EventHandler(this.btn_LookTel_Click);
			this.btn_ChangeAddMan.Click += new System.EventHandler(this.btn_ChangeAddMan_Click);
			this.cbx_customer.CheckedChanged += new System.EventHandler(this.cbx_customer_CheckedChanged);
			this.cbx_customer.PreRender += new System.EventHandler(this.cbx_customer_PreRender);
			this.btn_OK.Click += new System.EventHandler(this.btn_OK_Click);
			this.btn_AddContact.Click += new System.EventHandler(this.btn_AddContact_Click);
			this.btn_LookContact.Click += new System.EventHandler(this.btn_LookContact_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion