contactinfo.aspx.cs

除了具有传统OA的邮件、工作流、文档等功能外

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.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace UDS.SubModule.CM.Stat
{
	/// <summary>
	/// ContactInfo 的摘要说明。
	/// </summary>
	public partial class ContactInfo : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			ltl_Client.Text = "0";
		}

		#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()
		{    

		}
		#endregion

		protected void btn_addsearch_Click(object sender, System.EventArgs e)
		{
			ListItem lt = new ListItem();
			lt.Text = ddl_search.SelectedItem.Text + ":";
			if(tbx_searchvalue.Visible==true)
				lt.Text += tbx_searchvalue.Text;
			else if(rbl_searchvalue.Visible==true)
				lt.Text += rbl_searchvalue.SelectedItem.Text;

			lt.Value = lt.Text;
			lbx_search.Items.Add(lt);
		}

		protected void ddl_search_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			tbx_searchvalue.Text = "";
			tbx_searchvalue.Attributes["onfocus"] = "";
			tbx_searchvalue.ReadOnly = false;
			object[] array;
			switch(ddl_search.SelectedItem.Value)
			{
				case "销售阶段":
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = true;
					array = Enum.GetNames(typeof(UDS.Components.ContactStat));
					for(int i=0;i<array.Length;i++)
					{
						switch(array[i].ToString())
						{
							case "trace": 
								array[i] = "跟踪";
								break;
							case "boot":
								array[i] = "启动";
								break;
							case "commend":
								array[i] = "产品推荐";
								break;
							case "requirement":
								array[i] = "需求定义";
								break;
							case "submit":
								array[i] = "方案提交";
								break;
							case "negotiate":
								array[i] = "商务谈判";
								break;
							case "actualize":
								array[i] = "项目实施";
								break;
							case "traceservice":
								array[i] = "跟踪服务";
								break;
							case "last":
								array[i] = "收尾款";
								break;
						}
					}
					rbl_searchvalue.DataSource = array;
					rbl_searchvalue.DataBind();
					break;
				case "成交预估":
					array = new string[]{"*","**","***","****","*****",}; 
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = true;
					rbl_searchvalue.DataSource = array;
					rbl_searchvalue.DataBind();
					break;
				case "首次接洽时间":
					tbx_searchvalue.ReadOnly = true;
					tbx_searchvalue.Attributes["onfocus"] = "setday(this)";
					break;
				case "最后一次接洽时间":
					tbx_searchvalue.Visible = true;
					rbl_searchvalue.Visible = false;
					tbx_searchvalue.ReadOnly = true;
					tbx_searchvalue.Attributes["onfocus"] = "setday(this)";
					break;
				case "下次约见时间":
					tbx_searchvalue.Visible = true;
					rbl_searchvalue.Visible = false;
					tbx_searchvalue.ReadOnly = true;
					tbx_searchvalue.Attributes["onfocus"] = "setday(this)";
					break;
				case "本周新增记录":
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = false;
					break;
				case "本月新增记录":
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = false;
					break;
				default:
					tbx_searchvalue.Visible = true;
					rbl_searchvalue.Visible = false;
					break;
			}
		}

		protected void btn_OK_Click(object sender, System.EventArgs e)
		{
			if(lbx_search.Items.Count>0)
			{
				string searchstring = "";
				string tmp = "";
				DateTime begintime = new DateTime();
				DateTime endtime = DateTime.Now;
				foreach(ListItem lt in lbx_search.Items)
				{
					string [] searcharr = new string[2];
					searcharr = lt.Value.Split(':');
					switch(searcharr[0].Trim())
					{
						case "销售人员姓名":
							UDS.Components.Staff staff = new UDS.Components.Staff();
							SqlDataReader dr_staffid = staff.GetStaffIDByRealName(searcharr[1]);
							tmp = "UDS_CM_ClientContact.MarketmanID='";
							while(dr_staffid.Read())
							{
								tmp +=  dr_staffid["staff_id"] + "' or UDS_CM_ClientContact.MarketmanID='";
							}
							dr_staffid.Close();
							if(tmp=="UDS_CM_ContactInfo.MarketmanID='")
								searchstring = "1=2";
							else
							{
								tmp = tmp.Substring(0,tmp.Length-37);
								searchstring += "(" + tmp + ") and ";
							}
							break;

						case "客户名称":
							UDS.Components.CM cm = new UDS.Components.CM();
							SqlDataReader dr_clientid = cm.GetClientIDByName(searcharr[1]);
							tmp = "UDS_CM_ClientContact.ClientID='";
							while(dr_clientid.Read())
							{
								tmp +=  dr_clientid["ID"] + "' or UDS_CM_ClientContact.ClientID='";
							}
							dr_clientid.Close();
							if(tmp=="UDS_CM_ClientContact.ClientID='")
								searchstring = "1=2";
							else
							{
								tmp = tmp.Substring(0,tmp.Length-34);
								searchstring += "(" + tmp + ") and ";
							}
							break;
						case "客户编号":
							searchstring += "UDS_CM_ClientContact.ClientID=" + searcharr[1] + " and ";
							break;
						case "销售阶段":
						switch(searcharr[1])
						{
							case "跟踪":
								searchstring += "patindex('%trace%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "启动":
								searchstring += "patindex('%boot%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "产品推荐":
								searchstring += "patindex('%commend%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "需求定义":
								searchstring += "patindex('%requirement%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "方案提交":
								searchstring += "patindex('%submit%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "商务谈判":
								searchstring += "patindex('%negotiate%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "项目实施":
								searchstring += "patindex('%actualize%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "跟踪服务":
								searchstring += "patindex('%traceservice%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
							case "收尾款":
								searchstring += "patindex('%last%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
								break;
						}
							break;
						case "成交预估":
							searchstring += "UDS_CM_ClientContact.BargainPrognosis='" + searcharr[1] + "' and ";
							break;
						case "已接洽次数":
							searchstring += "UDS_CM_ClientContact.ContactTimes=" + searcharr[1] + " and ";
							break;
						case "接洽对象职务":
							searchstring += "UDS_CM_Linkman.[Position]='" + searcharr[1] + "' and ";
							break;
						case "首次接洽时间":
							searchstring += "UDS_CM_ClientInfo.FirstContactTime='" + searcharr[1] + "' and ";
							break;
						case "最后一次接洽时间":
							searchstring += "UDS_CM_ClientInfo.ContactTime='" + searcharr[1] + "' and ";
							break;
						case "下次约见时间":
							searchstring += "UDS_CM_ClientInfo.NextContactTime='" + searcharr[1] + "' and ";
							break;
						case "本周新增记录":
							//得到本周起始日(周一 -- 周日)
							begintime = DateTime.Now;
						switch((int)DateTime.Now.DayOfWeek)
						{
							case 0:
								begintime = begintime.AddDays(-6);
								break;
							default:
								begintime = begintime.AddDays(1-(int)DateTime.Now.DayOfWeek);
								break;
						}
							searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
							break;
						case "本月新增记录":
							//得到本月起始日
							begintime = DateTime.Now;
							begintime = begintime.AddDays(1-DateTime.Now.Day);
							searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
							break;

					}
				}

				searchstring = "select * from UDS_CM_ClientInfo where ID IN (select UDS_CM_ClientInfo.ID from UDS_CM_ClientContact left join UDS_CM_ClientContact_Linkman ON UDS_CM_ClientContact.ID=UDS_CM_ClientContact_Linkman.ContactID left join UDS_CM_Linkman ON UDS_CM_ClientContact_Linkman.LinkmanID=UDS_CM_ClientContact_Linkman.id,UDS_CM_ClientInfo where UDS_CM_ClientContact.clientid=UDS_CM_ClientInfo.id and " + searchstring;
				if(searchstring.EndsWith("and "))
				{
					searchstring = searchstring.Substring(0,searchstring.Length-4);
				}
				searchstring += " group by UDS_CM_ClientInfo.ID)";
				
				DataSet ds = new DataSet();
				UDS.Components.Staff staff1 = new UDS.Components.Staff();
				SqlDataReader dr_Staff = staff1.GetAllStaffs();
				DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff);
				dt_Staff.TableName = "Staff";
				ds.Tables.Add(dt_Staff);

				UDS.Components.Database db = new UDS.Components.Database();
				SqlParameter[] prams = {
										   db.MakeInParam("@SQL",SqlDbType.NText,5000,searchstring)
									   };
				SqlDataReader dr = null;
				db.RunProc("sp_RunSql",prams,out dr);
				DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
				dt.TableName = "Client";
				ds.Tables.Add(dt);

				ltl_Client.Text = dt.Rows.Count.ToString();

				ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false);

				dgrd_ContactList.DataSource = dt.DefaultView;
				dgrd_ContactList.DataBind();
				
			}
		}

		protected void btn_Del_Click(object sender, System.EventArgs e)
		{
			foreach(ListItem lt in lbx_search.Items)
			{
				if(lt.Selected)
				{
					lbx_search.Items.Remove(lt);
					break;
				}
			}
		}
	}
}