dispatchmanmodule.ascx.cs

这是企业客户服务系统 老师给的光盘里带的 看着不错

namespace KhfwWeb.Modules
{
	using System;
	using System.Data;
	using System.Data.SqlClient;
	using System.Configuration;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;

	/// <summary>
	///		DispatchManModule 的摘要说明。
	/// </summary>
	public class DispatchManModule : ModuleBase
	{
		protected System.Web.UI.WebControls.Label TitleLabel;
		protected System.Web.UI.WebControls.TextBox ClientNameTextBox;
		protected System.Web.UI.WebControls.Button search;
		protected System.Web.UI.WebControls.Button ShowAll;
		protected System.Web.UI.WebControls.Repeater rp_RecordDispatch;

		protected static string status;
		protected string RDetailsLink;
       
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				//获取功能列表链接传递来的记录状态信息
				status=Request.QueryString["RStatus"].ToString();
				if(status=="1")
				{
					TitleLabel.Text="待分配的客户记录";
					RDetailsLink=PathPrefix+"/ReDispatchMan.aspx?RStatus=1";
				}
				else if(status=="2")
				{
					TitleLabel.Text="已分配的客户记录";
					RDetailsLink=PathPrefix+"/ReDispatchMan.aspx?RStatus=2";
				}
				else if(status=="3")
				{
					TitleLabel.Text="已解决的客户记录";
					RDetailsLink=PathPrefix+"/ReDispatchMan.aspx?RStatus=3";
				}
				//完成rp_RecordDispatch的数据绑定
				Show_RecordDispatch();
			}
		}
        
		protected void Show_RecordDispatch()
		{	
			//从文件Web.config中读取连接字符串
			string sqldb= ConfigurationSettings.AppSettings["ConnectionString"];
			//连接JdglSys数据库
			SqlConnection Conn= new SqlConnection (sqldb);
			string selsql="select RecordId,RDetails,RLevel,CreateDate from records where RStatus='"+status+"'";
			//创建SqlDataAdapter对象,调用selsql
			SqlDataAdapter myadapter=new SqlDataAdapter (selsql,Conn);
			//创建并填充DataSet
			DataSet ds = new DataSet ();
			myadapter.Fill (ds);
			rp_RecordDispatch.DataSource =ds;
			rp_RecordDispatch.DataBind ();
			//实现“状态”和“任务处理”列的显示
			for(int i=0;i<rp_RecordDispatch.Items.Count;i++)
			{
				DataRow dr=ds.Tables[0].Rows[i];
                
				 //根据RLevel来显示LevelLabel的Text值
				if(dr["RLevel"].ToString()=="1")
				{ 
					((Label)rp_RecordDispatch.Items[i].FindControl("LevelLabel")).Text="级别一";
				}
				else if(dr["RLevel"].ToString()=="2")
				{
					((Label)rp_RecordDispatch.Items[i].FindControl("LevelLabel")).Text="级别二";
				}
				else if(dr["RLevel"].ToString()=="3")
				{
					((Label)rp_RecordDispatch.Items[i].FindControl("LevelLabel")).Text="级别三";
				}
               
				if(status=="1")  //当状态为”未处理”时
				{   
					// HyperLink控件DispatchLink可见,用于显示”记录分配”链接
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("DispatchLink")).Visible=true;
				}
				else if(status=="2")
				{
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("DispDetailsLink")).Visible=true;
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("ReDispatchlink")).Visible=true;
				}
				else if(status=="3")
				{
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("WorkLogLink")).Visible=true;
				}
			}
			Conn.Close ();
		}



		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		///		设计器支持所需的方法 - 不要使用代码编辑器
		///		修改此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.search.Click += new System.EventHandler(this.search_Click);
			this.ShowAll.Click += new System.EventHandler(this.ShowAll_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void search_Click(object sender, System.EventArgs e)
		{
			//从文件Web.config中读取连接字符串
			string sqldb = ConfigurationSettings.AppSettings["ConnectionString"];
			//连接JdglSys数据库
			SqlConnection Conn = new SqlConnection (sqldb);
			string selsql=" select RecordId,RDetails,RLevel,RStatus,ClientName,CreateDate,FinishDate "+
                       " from  Records where ClientName='"+ClientNameTextBox.Text.Trim()+"'and RStatus='"+status+"'";
			//创建SqlDataAdapter对象,调用selsql
			SqlDataAdapter myadapter = new SqlDataAdapter (selsql,Conn);
			//创建并填充DataSet
			DataSet ds = new DataSet ();
			myadapter.Fill (ds);

			rp_RecordDispatch.DataSource =ds;
			rp_RecordDispatch.DataBind ();
			//实现“状态”和“任务处理”列的显示
			for(int i=0;i<rp_RecordDispatch.Items.Count;i++)
			{
				DataRow dr=ds.Tables[0].Rows[i];
                
				if(dr["RLevel"].ToString()=="1")
				{ 
					((Label)rp_RecordDispatch.Items[i].FindControl("LevelLabel")).Text="级别一";
				}
				else if(dr["RLevel"].ToString()=="2")
				{
					((Label)rp_RecordDispatch.Items[i].FindControl("LevelLabel")).Text="级别二";
				}
				else if(dr["RLevel"].ToString()=="3")
				{
					((Label)rp_RecordDispatch.Items[i].FindControl("LevelLabel")).Text="级别三";
				}

				if(status=="1")
				{ 
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("DispatchLink")).Visible=true;
				}
				else if(status=="2")
				{
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("DispDetailsLink")).Visible=true;
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("ReDispatchlink")).Visible=true;
				}
				else if(status=="3")
				{
					((HyperLink)rp_RecordDispatch.Items[i].FindControl("DetailsLink")).Visible=true;
				}
			}

			Conn.Close ();
		}

		private void ShowAll_Click(object sender, System.EventArgs e)
		{
			//完成rp_RecordDispatch的数据绑定
			Show_RecordDispatch();
		}
	}
}