clientcontact.aspx.cs

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

		{    
			this.ddl_ClientName.SelectedIndexChanged += new System.EventHandler(this.ddl_ClientName_SelectedIndexChanged);
			this.btn_in.Click += new System.EventHandler(this.btn_in_Click);
			this.btn_out.Click += new System.EventHandler(this.btn_out_Click);
			this.btn_inlinkman.Click += new System.EventHandler(this.btn_inlinkman_Click);
			this.btn_outlinkman.Click += new System.EventHandler(this.btn_outlinkman_Click);
			this.btn_OK.Click += new System.EventHandler(this.btn_OK_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion


		private void btn_OK_Click(object sender, System.EventArgs e)
		{
			UDS.Components.CM cm = new UDS.Components.CM();
			UDS.Components.Contact contact = new UDS.Components.Contact();
			UDS.Components.ClientInfo client = cm.GetClientAllInfo(clientid);
			//添加协同人员
			foreach(ListItem lt in lbx_Cooperater.Items)
			{
				UDS.Components.Cooperater cooperater = new UDS.Components.Cooperater();
				cooperater.StaffID = Int32.Parse(lt.Value);
				contact.AddCooperater(cooperater);
			}
			//添加联系人员
			foreach(ListItem lt in lbx_Linkman.Items)
			{
				UDS.Components.Linkman linkman = new UDS.Components.Linkman();
				linkman.ID = Int32.Parse(lt.Value);
				contact.AddLinkman(linkman);
			}

			contact.ID = contactid;

			#region 填充contact
			contact.UpdateTime = DateTime.Now;
			contact.ContactTimes = Int32.Parse(ltl_ContactTimes.Text);
			contact.StaffID = client.AddManID;
			contact.ContactTime = DateTime.Parse(tbx_contacttime.Text);
			contact.ClientID = clientid;
			contact.ContactAim = tbx_contactaim.Text;
			contact.SellMoney = tbx_sellmoney.Text;
			contact.BargainPrognosis = ddl_bargainprognosis.SelectedItem.Value;
			if(cbx_telephone.Checked) contact.ContactType += ContactType.telephone.ToString() + ",";
			if(cbx_fax.Checked) contact.ContactType += ContactType.fax.ToString() + ",";
			if(cbx_email.Checked) contact.ContactType += ContactType.email.ToString() + ",";
			if(cbx_mail.Checked) contact.ContactType += ContactType.mail.ToString() + ",";
			if(cbx_sms.Checked) contact.ContactType += ContactType.sms.ToString() + ",";
			if(cbx_callin.Checked) contact.ContactType += ContactType.interview.ToString() + ",";
			if(cbx_meeting.Checked) contact.ContactType += ContactType.meeting.ToString() + ",";

			if(rbtn_trace.Checked) contact.ContactStatus += ContactStat.trace.ToString() + ",";
			if(rbtn_boot.Checked) contact.ContactStatus += ContactStat.boot.ToString() + ",";
			if(rbtn_commend.Checked) contact.ContactStatus += ContactStat.commend.ToString() + ",";
			if(rbtn_requirement.Checked) contact.ContactStatus += ContactStat.requirement.ToString() + ",";
			if(rbtn_submit.Checked) contact.ContactStatus += ContactStat.submit.ToString() + ",";
			if(rbtn_negotiate.Checked) contact.ContactStatus += ContactStat.negotiate.ToString() + ",";
			if(rbtn_actualize.Checked) contact.ContactStatus += ContactStat.actualize.ToString() + ",";
			if(rbtn_traceservice.Checked) contact.ContactStatus += ContactStat.traceservice.ToString() + ",";
			if(rbtn_last.Checked) contact.ContactStatus += ContactStat.last.ToString() + ",";

			contact.ThisFee = float.Parse(tbx_thisfee.Text);
			if(cbx_travel.Checked) contact.FeeUsed += ContactFeeUsed.travel.ToString() + ",";
			if(cbx_food.Checked)  contact.FeeUsed += ContactFeeUsed.food.ToString() + ",";
			if(cbx_gift.Checked) contact.FeeUsed += ContactFeeUsed.gift.ToString() + ",";
			if(cbx_out.Checked) contact.FeeUsed += ContactFeeUsed.outer.ToString() + ",";
			contact.ContactContent = tbx_contactcontent.Text;
			contact.NextContactAim = tbx_nextcontactaim.Text;
			contact.NextContactTime = DateTime.Parse(tbx_nextcontacttime.Text);
			#endregion

			//如果contactid==0则插入操作，否则修改
			if(contactid==0)
			{
				contact.ContactTimes++;
				contact.ID = cm.AddContact(contact);
				contactid = contact.ID;
				ViewState["ContactID"] = contact.ID.ToString();
				Response.Write("<script>alert('添加成功！');close();opener.document.location.href=opener.document.location.href</script>");
			}
			else
			{
				cm.UpdateContact(contact);
				Response.Write("<script>alert('修改成功！');close();</script>");
			}
			
			//修改client信息
			
			client.BargainPrognosis = contact.BargainPrognosis;
			client.ContactTimes = contact.ContactTimes;
			client.CurStatus = contact.ContactStatus;
			client.SellPhase = contact.ContactStatus;
			client.Fee += contact.ThisFee;
			client.UpdateTime = contact.UpdateTime;
			client.ContactTime = contact.ContactTime;
			client.NextContactTime = DateTime.Parse(tbx_nextcontacttime.Text);
			if(client.FirstContactTime==DateTime.Parse("1900-1-1")) client.FirstContactTime = contact.ContactTime; 
			cm.UpdateClient(client);
			DisplayClientInfo();

			//上传附件
			UploadAtt();

			ControlClientContactHistory1.ClientID = clientid;
			ControlClientContactHistory1.BindData();
		}

	

		private void btn_search_Click(object sender, System.EventArgs e)
		{
			string sqlstr = "";
			string id = "";
			UDS.Components.Database db = new UDS.Components.Database();
			SqlDataReader dr = null;

			sqlstr = "select top 1 id from UDS_CM_ClientInfo WHERE name like '%" + tbx_quicksearch.Text.Replace("'","''") + "%' and AddmanID="+Request.Cookies["UserID"].Value;
			SqlParameter[] prams = {
										db.MakeInParam("@SQL",SqlDbType.NText,5000,sqlstr)    
			};
			db.RunProc("sp_RunSQL",prams,out dr);
			while(dr.Read())
			{
				id = dr["id"].ToString();
			}
			dr.Close();
			if(id!="")
			{
				foreach(ListItem lt in ddl_ClientName.Items)
				{
					if(lt.Value==id)
					{
						lt.Selected = true;
					}
					else
					{
						lt.Selected = false;
					}
				}
				clientid = Int32.Parse(id);
				DisplayClientInfo();
				BindData();
			}
			

		}

		private void ddl_ClientName_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			clientid = Int32.Parse(ddl_ClientName.SelectedItem.Value);
			ViewState["ClientID"] = clientid;
			lbx_Cooperater.Items.Clear();
			lbx_Linkman.Items.Clear();
			DisplayClientInfo();
			BindData();

		}
		/// <summary>
		/// 上载文件
		/// </summary>
		private void UploadAtt()
		{
			HtmlForm FrmCompose   = (HtmlForm)this.Page.FindControl("ClientContact");
			UDS.Components.CM cm = new UDS.Components.CM();
			
			string FileName = "";
			string Extension = "";
			string SavedName = "";
			try
			{
				if(Directory.Exists(Server.MapPath(".")+"\\Attachment"))
				{
					for (int i=0;i<FrmCompose.Controls.Count;i++)
					{
						if(FrmCompose.Controls [i].GetType().ToString()=="System.Web.UI.HtmlControls.HtmlInputFile")
						{
							HtmlInputFile hif = ((HtmlInputFile)(FrmCompose.Controls[i]));
							if(hif.PostedFile.FileName.Trim()!="")
							{	
								FileName = System.IO .Path.GetFileName(hif.PostedFile.FileName);
								Extension = System.IO.Path.GetExtension(hif.PostedFile.FileName);

								SavedName = cm.InsertFile(FileName,"contact",contactid,Extension).ToString();
								
								hif.PostedFile.SaveAs(Server.MapPath(".")+"\\Attachment\\"+SavedName+Extension );
							}
							hif=null;
						}
					}
				}
				else
				{   
					Directory.CreateDirectory(Server.MapPath(".")+"\\Attachment");
					UploadAtt();
				}
			}
			catch(Exception ioex)
			{	
				UDS.Components.Error.Log(ioex.ToString());
				Server.Transfer("../Error.aspx");
			}

		}

		private void rbtn_trace_CheckedChanged(object sender, System.EventArgs e)
		{
		
		}

		private void btn_in_Click(object sender, System.EventArgs e)
		{
			ArrayList selecteditem = new ArrayList();
			foreach(ListItem lt in lbx_Staff.Items)
			{
				if(lt.Selected)
				{
					lbx_Cooperater.Items.Add(lt);
					selecteditem.Add(lt);
				}
			}
			for(int i=0;i<selecteditem.Count;i++)
			{
				lbx_Staff.Items.Remove((ListItem)selecteditem[i]);
			}
			BindData();
		}

		private void btn_out_Click(object sender, System.EventArgs e)
		{
			ArrayList selecteditem = new ArrayList();
			foreach(ListItem lt in lbx_Cooperater.Items)
			{
				if(lt.Selected)
				{
					lbx_Staff.Items.Add(lt);
					selecteditem.Add(lt);
				}
			}
			for(int i=0;i<selecteditem.Count;i++)
			{
				lbx_Cooperater.Items.Remove((ListItem)selecteditem[i]);
			}
			BindData();
		}

		private void btn_inlinkman_Click(object sender, System.EventArgs e)
		{
			ArrayList selecteditem = new ArrayList();
			foreach(ListItem lt in lbx_ClientLinkman.Items)
			{
				if(lt.Selected)
				{
					lbx_Linkman.Items.Add(lt);
					selecteditem.Add(lt);
				}
			}
			for(int i=0;i<selecteditem.Count;i++)
			{
				lbx_ClientLinkman.Items.Remove((ListItem)selecteditem[i]);
			}
			//BindData();
		}

		private void btn_outlinkman_Click(object sender, System.EventArgs e)
		{
			ArrayList selecteditem = new ArrayList();
			foreach(ListItem lt in lbx_Linkman.Items)
			{
				if(lt.Selected)
				{
					lbx_ClientLinkman.Items.Add(lt);
					selecteditem.Add(lt);
				}
			}
			for(int i=0;i<selecteditem.Count;i++)
			{
				lbx_Linkman.Items.Remove((ListItem)selecteditem[i]);
			}
			//BindData();
		}


	}
}