opthandler.cs

人力资源管理系统 读者须安装好IIS和Microsoft Visual Stutio.NET相关开发环境

using System;
using System.Web.SessionState;
using System.Text.RegularExpressions;
using System.Web;
using System.Data;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace DataAccess
{
	/// <summary>
	/// OptHandler 的摘要说明。
	/// </summary>
	public class OptHandler
	{
		private System.Web.UI.Page Page;
		public OptHandler(System.Web.UI.Page mPage)
		{
			Page=mPage;
		}

		public string FormatNullStr(string s)
		{
			s=s.Replace("&nbsp;"," ");
			return s.Trim();
		}

		public string CreateSql(DropDownList ddl,string field,string asField)
		{
			string s="";
			for(int i=0;i<ddl.Items.Count;i++)
			{
				ListItem li=ddl.Items[i];
				s +=" when '" + li.Value.Trim()  + "' then '" + li.Text.Trim() + "' " ;
			}
			if (s!="")
			{
				s="case " + field + s ;
				s+= " else '' end ";
			}
			else
				s=" '' ";	
			s+=" as " + asField ;
			return s;
		}

		//Remove Session中的内容
		public void RemoveSession()
		{
			HttpSessionState sess=HttpContext.Current.Session;
			string[] name=new string[]
				{"dtServiceStation","dtCommunity","dtTower","dtProduct","dtPart","dtTask"};
			
			for(int i=0;i<name.Length ;i++)
			{
				try
				{
					sess.Remove(name[i]);
				}
				catch{}
			}
		}

		//设置控件的可用与否
		public void SetCtrlEnabled(Button btn,bool b)
		{
			btn.Enabled=b;
		}

		//dlb:2004-08-06修改－添加了控件checkbox的定义
		public void SetCtrlEnabled(CheckBox cb,bool b)
		{
			cb.Enabled=b;
		}

		public void SetCtrlEnabled(TextBox txt,bool b)
		{
			txt.ReadOnly = (!b);
			if (b)
				txt.CssClass="txt_css";
			else
				txt.CssClass="txt_disa_css";
		}
		 
		public void SetCtrlEnabled(DropDownList ddl,bool b)
		{
			ddl.Enabled =b;
			if (b)
				ddl.CssClass="txt_css";
			else
				ddl.CssClass="txt_disa_css";
		}

		public void SetCtrlEnabled(HtmlInputText txt,bool b)
		{
			txt.Disabled = !b;
			if (b)
				txt.Attributes["class"]="txt_css";
			else
				txt.Attributes["class"]="txt_disa_css";
		}

		//在ddl中显示指定值
		public void ShowDDLItem(DropDownList ddl,string type,string str)
		{
			ListItem li=null;
			if (type =="value")
			{
				//li=ddl.Items.FindByValue(str);
				for(int i=0;i<ddl.Items.Count;i++)
				{
					if (ddl.Items[i].Value.Trim() == str.Trim())
					{
						li=ddl.Items[i];
						break;
					}
				}
			}
			else
			{
				//li=ddl.Items.FindByText(str);
				for(int i=0;i<ddl.Items.Count;i++)
				{
					if (ddl.Items[i].Text.Trim() == str.Trim())
					{
						li=ddl.Items[i];
						break;
					}
				}
			}

			if(li !=null)
			{
				ddl.SelectedIndex=-1;
				li.Selected=true;
			}
			else
				ddl.SelectedIndex=0;
		}
			
		//在DDL中显示字段
		public DataTable ShowDDl(DropDownList ddl,OLEDB od,string sql,bool emptyLine,string textfield,string valuefield)
		{
			try
			{
				ddl.Items.Clear();
			
				DataTable dt=new DataTable();
				od.FillTable(dt,sql);

				if (emptyLine == true)
				{
					DataRow dr=dt.NewRow();
					dr[textfield]="";
					dr[valuefield]="";
					dt.Rows.InsertAt(dr,0);
				}

				if (dt !=null)
				{
					ddl.DataTextField=textfield;
					ddl.DataValueField=valuefield;
					ddl.DataSource=dt;
					ddl.DataBind();
				}

				return dt;
			}
			catch(Exception ee)
			{
				string m=ee.Message;
				return null;
			}
		}

		public DataTable ShowGrid(OLEDB od,string sql,DataGrid dg)
		{
			if (od !=null)
			{
				DataTable dt=new DataTable();
				od.FillTable(dt,sql);
				dg.CurrentPageIndex =0;
				dg.DataSource=dt;
				dg.DataBind();

				return dt;
			}
			else
				return null;
		}

		//根据不同属性显示数据
		public void ShowData(DataTable dt,int row)
		{
			try
			{
				if (dt.Rows.Count >row)
				{
					for(int i=0;i<dt.Columns.Count;i++)
					{
						Control c=Page.FindControl(dt.Columns[i].Caption);
					
						if (c!=null)
						{
							MatchField(c,dt,i,row);
						}
					}
				}
			}
			catch{}
		}

		public void ShowData(DataTable dt,int row,string prefix)
		{
			try
			{
				if (dt.Rows.Count >row)
				{
					for(int i=0;i<dt.Columns.Count;i++)
					{
						Control c=Page.FindControl(dt.Columns[i].Caption);
					
						if (c!=null)
						{
							MatchField(c,dt,i,row);
						}
						else
						{
							c=Page.FindControl(prefix+dt.Columns[i].Caption);
							if (c!=null)
							{
								MatchField(c,dt,i,row);
							}
						}
					}
				}
			}
			catch{}
		}

		private void MatchField(Control c,DataTable dt,int col,int row)
		{
			string type=c.GetType().ToString();

			try
			{
				if (type == "System.Web.UI.WebControls.TextBox")
				{
					TextBox tb=(TextBox) c;
					tb.Text=dt.Rows[row][col].ToString();
				}
				else if (type =="System.Web.UI.WebControls.CheckBox")
				{
					CheckBox cb=(CheckBox) c;
					if (row ==-1)
					{
						cb.Checked=false;
					}
					else
					{
						string check=dt.Rows[row][col].ToString();
						if ((check == "1") ||(check.ToLower() == "true"))
							cb.Checked=true;
						else
							cb.Checked=false;
					}
				}			
				else if (type =="System.Web.UI.HtmlControls.HtmlInputText")
				{
					HtmlInputText inout=(HtmlInputText) c;
					if (row ==-1)
					{
						inout.Value ="";
					}
					else
					{
						inout.Value =dt.Rows[row][col].ToString();
					}
				}							
				else if (type =="System.Web.UI.WebControls.Label")
				{
					Label tl=(Label) c;
					if (row ==-1)
					{
						tl.Text ="";
					}
					else
					{
						tl.Text=dt.Rows[row][col].ToString();
					}
				}
				else if (type =="System.Web.UI.WebControls.DropDownList")
				{
					DropDownList tl=(DropDownList) c;				
					if (row ==-1)
					{
						tl.SelectedIndex =-1;
					}
					else
					{
						System.Web.UI.WebControls.ListItem li=null;
						li=tl.Items.FindByValue(dt.Rows[row][col].ToString().Trim());
						if(li !=null)
						{
							tl.SelectedIndex=-1;
							li.Selected=true;
						}
					}
				}
			}
			catch{}
		}
		public void MessageBox(string msg)
		{

			string p=@"(\\)";
			Regex r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\\\");

			p=@"(\n)";
			r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\n");

			p=@"(\t)";
			r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\t");

			p=@"(\r)";
			r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\r");


			msg=msg.Replace("'","\\[");
			msg=msg.Replace("\"","\\\"");
			string o="<script language=javascript for=document event=onreadystatechange>"
				+"alert('"
				+msg+"');"
				+"</script>";
			Page.Response.Write(o);
		}

		public void MessageBox_NoEvent(string msg)
		{

			string p=@"(\\)";
			Regex r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\\\");

			p=@"(\n)";
			r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\n");

			p=@"(\t)";
			r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\t");

			p=@"(\r)";
			r=new Regex(p,RegexOptions.IgnoreCase|RegexOptions.Singleline|RegexOptions.RightToLeft);
			msg=r.Replace(msg,"\\r");


			msg=msg.Replace("'","\\[");
			msg=msg.Replace("\"","\\\"");
			string o="<script language=javascript>"
				+"alert('"
				+msg+"');"
				+"</script>";
			Page.Response.Write(o);
		}

		public void RemoveConfirm(Button btn)
		{
			btn.Attributes.Remove("confirm");
			btn.Attributes.Remove("cancel");
		}

		public void AddConfirm(Button btn,string msg)
		{
			btn.Attributes.Add("confirm",msg);
		}

		public void RemoveFile(HtmlInputButton btn)
		{
			btn.Attributes.Remove("download");
		}

		public void AddFile(HtmlInputButton btn,string file)
		{
			btn.Attributes.Add("download",file);
		}

		public static void IFrame_PopUp(System.Web.UI.Page Page,string cmdline)
		{
			//				var ret=window.showModalDialog(
			//					'Frame.aspx','" + cmdline + 
			//				@"',style);
			string	o=@"<script language=javascript for=window event=onload>
				var w=screen.width;
				var h=screen.height;
				var iw=parseInt(w*0.7);
				var ih=parseInt(h*0.5);
				
				var style='dialogWidth:' + iw + 'px;dialogHeight:' +ih +'px;center:yes;scroll:no;status:no;help:no' ;
					
				var ret=window.showModalDialog(
					'Frame.aspx?url=" +  Page.Server.UrlEncode(cmdline) + 
				@"',window,style);
				if((ret)&&(ret!=''))
				{
					window.location=ret;
				}</script>";
			Page.Response.Write(o);
			
		}

		public static void IFrame_PopUp(System.Web.UI.Page Page,string cmdline, string width,string height)
		{
			string	o=@"<script language=javascript for=window event=onload>
				var iw=" + width + @";
				var ih="+ height +@";
				
				var style='dialogWidth:' + iw + 'px;dialogHeight:' +ih +'px;center:yes;scroll:no;status:no;help:no' ;
					
				var ret=window.showModalDialog(
					'Frame.aspx?url=" +  Page.Server.UrlEncode(cmdline) + 
				@"',window,style);
				
				if((ret)&&(ret!=''))
				{
					window.location=ret;
				}</script>";
			Page.Response.Write(o);
		}

		#region 需要返回值的提示
		public void ConfirmRt(string mess,string CtlID)
		{
			string cmd = "var val=confirm('" + mess + "');" 
				+ "var txt=document.getElementById('" + CtlID + "');" 
				+ "txt.value=val;" 
				+ "__doPostBack('" + CtlID + "','')" ;
			//Response.Write("<script>" + cmd + "</script>") ;	
			cmd = "<script>" + cmd + "</script>" ;
			Page.RegisterStartupScript("con",cmd) ;				
		}
		#endregion

	}
}