clientinfo.aspx.cs

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

//				Response.End();
				Bind();
				//Response.Write(searchstring);
			}
		}

		private void Bind()
		{
			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);
			
			try
			{
				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);

				dt.DefaultView.Sort = ViewState["SortField"].ToString() + " " + ViewState["SortDirect"].ToString();

				dgrd_clientlist.DataSource = dt.DefaultView;
				dgrd_clientlist.DataBind();
			}
			catch(Exception ex)
			{
				UDS.Components.Error.Log(ex.ToString());
				Server.Transfer("../../Error.aspx");
			}

			
		}

		protected void ddl_search_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			tbx_searchvalue.Text = "";
			tbx_searchvalue.Attributes["onfocus"] = "";
			tbx_searchvalue.ReadOnly = false;

			#region 条件选择
			switch(ddl_search.SelectedItem.Value)
			{
				case "客户名称": tbx_searchvalue.Visible = true;rbl_searchvalue.Visible = false;break;
				case "客户分类": 
				{
					object[] array;
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = true;
					array = Enum.GetNames(typeof(UDS.Components.ClientType));
					for(int i=0;i<array.Length;i++)
					{
						switch(array[i].ToString())
						{
							case "terminal": 
								array[i] = "终端用户";
								break;
							case "channal":
								array[i] = "渠道商";
								break;
							case "social":
								array[i] = "社会关系";
								break;
							case "media":
								array[i] = "媒体公关";
								break;
						}
					}
					rbl_searchvalue.DataSource = array;
					rbl_searchvalue.DataBind();
					break;

				}
				case "客户编号":
					tbx_searchvalue.Visible = true;rbl_searchvalue.Visible = false;break;
				case "联系人":
					tbx_searchvalue.Visible = true;rbl_searchvalue.Visible = false;break;
				case "电话":
					tbx_searchvalue.Visible = true;rbl_searchvalue.Visible = false;break;
				case "所处行业": 
				{
					object[] array;
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = true;
					array = Enum.GetNames(typeof(UDS.Components.ClientTrade));
					for(int i=0;i<array.Length;i++)
					{
						switch(array[i].ToString())
						{
							case "realty": 
								array[i] = "房地产";
								break;
							case "IT":
								array[i] = "IT";
								break;
							case "business":
								array[i] = "商业贸易";
								break;
							case "telecom":
								array[i] = "电信";
								break;
							case "post":
								array[i] = "邮政通讯";
								break;
							case "refer":
								array[i] = "咨询服务";
								break;
							case "travel":
								array[i] = "旅游业";
								break;
							case "bus":
								array[i] = "交通运输";
								break;
							case "stock":
								array[i] = "金融证券";
								break;
							case "insurance":
								array[i] = "保险";
								break;
							case "tax":
								array[i] = "税务";
								break;
							case "make":
								array[i] = "制造业";
								break;
							case "he":
								array[i] = "家电";
								break;
							case "clothe":
								array[i] = "服装";
								break;
							case "food":
								array[i] = "食品";
								break;
							case "medicine":
								array[i] = "医药";
								break;
							case "mechanism":
								array[i] = "机械";
								break;
							case "auto":
								array[i] = "汽车制造";
								break;

						}
					}
					rbl_searchvalue.DataSource = array;
					rbl_searchvalue.DataBind();
					break;
				}
				case "企业性质":
				{
					object[] array;
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = true;
					array = Enum.GetNames(typeof(UDS.Components.EnterpriseType));
					for(int i=0;i<array.Length;i++)
					{
						switch(array[i].ToString())
						{
							case "government":
								array[i] = "政府";
								break;
							case "contry":
								array[i] = "国营";
								break;
							case "oversea":
								array[i] = "外资";
								break;
							case "stock":
								array[i] = "上市公司";
								break;
							case "privateowned":
								array[i] = "民营";
								break;
						}
					}
					rbl_searchvalue.DataSource = array;
					rbl_searchvalue.DataBind();
					break;
				}
				case "客户来源":
				{
					object[] array;
					tbx_searchvalue.Visible = false;
					rbl_searchvalue.Visible = true;
					array = Enum.GetNames(typeof(UDS.Components.ClientSource));
					for(int i=0;i<array.Length;i++)
					{
						switch(array[i].ToString())
						{
							case "sellman":
								array[i] = "销售主动联系";
								break;
							case "familiar":
								array[i] = "以前认识";
								break;
							case "introduce":
								array[i] = "熟人介绍";
								break;
							case "client":
								array[i] = "客户主动联系";
								break;
						}
					}
					rbl_searchvalue.DataSource = array;
					rbl_searchvalue.DataBind();
					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;


			}
			#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 btn_Del_Click(object sender, System.EventArgs e)
		{
			foreach(ListItem lt in lbx_search.Items)
			{
				if(lt.Selected)
				{
					lbx_search.Items.Remove(lt);
					break;
				}
			}
		}

		protected void ddl_SearchBound_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void dgrd_clientlist_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		{
			if(ViewState["SortField"].ToString() == e.SortExpression)
			{
				ViewState["SortDirect"] = (ViewState["SortDirect"].ToString()=="ASC")?"DESC":"ASC";
			}
			else
			{
				ViewState["SortField"] = e.SortExpression;
				ViewState["SortDirect"] = "ASC";

			}
			
			foreach(DataGridColumn col in  dgrd_clientlist.Columns)
			{
				if(col.SortExpression.ToString()==ViewState["SortField"].ToString())
				{
					if(ViewState["SortDirect"].ToString() == "ASC")
						col.HeaderText += "<img src='../../../images/asc.gif' border=0/>";
					else
						col.HeaderText += "<img src='../../../images/desc.gif' border=0/>";
				}
			}

			Bind();
		}

		private void dgrd_clientlist_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			dgrd_clientlist.CurrentPageIndex =e.NewPageIndex;
			Bind();
		}
	}
}