generalsearchfieldmanage.aspx.cs

很不错的公文流转系统

/**************************************
 * 
 * 创建者：周建波
 * 
 * 创建日期：2003-12-12
 * 
 * 功能:维护通用查询看用到的字段数据。 
 * 
 * ***********************************/
using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
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 OI.Manage
{
	/// <summary>
	/// GeneralSearchFieldManage 的摘要说明。
	/// </summary>
	public class GeneralSearchFieldManage : OI.PageBase 
	{
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox TextBoxViewName;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.CheckBox CheckBoxEnable;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSave;
		protected System.Web.UI.WebControls.Label LabelMsg;
		protected System.Web.UI.WebControls.TextBox TextBoxFieldName;
		protected System.Web.UI.WebControls.DataGrid DataGridList;
		protected OI.DatabaseOper.DatabaseConnect dc;
		protected System.Web.UI.WebControls.Label LabelOperation;
		protected System.Web.UI.WebControls.Label LabelValue;
		protected ZHENGYI.DataGridNavigation DataGridNavigation1;
		protected System.Web.UI.WebControls.Label LabelTable;
		private string QueryTableID=null;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (DataGridBind);//修改这个dataBind,让f 指向你的方法。 
			DataGridNavigation1.SetTarget(DataGridList,f,10);
			dc=new OI.DatabaseOper.DatabaseConnect();
			
			LabelTable.Text=Request["ViewName"].ToString();
		    QueryTableID=Request["QueryTableID"].ToString();
			if(!Page.IsPostBack) {
				DataGridBind();			
				LabelOperation.Text="Add";//默认为添加
			}
		}

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

		}
		#endregion

		private void ImageButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
		string ViewName=OI.Modules.String.GenSafeChars(TextBoxViewName.Text.Trim());
		string FieldName=OI.Modules.String.GenSafeChars(TextBoxFieldName.Text.Trim());
		string Operation=LabelOperation.Text;
		int Enable=1;
			if(CheckBoxEnable.Checked)
			{
				Enable=1;
			}
			else
			{
				Enable=0;
			}					
		SaveToTable(QueryTableID,FieldName,ViewName,Enable,Operation);
			TextBoxFieldName.Text="";
			TextBoxViewName.Text="";
		}
		/// <summary>
		/// 添加/修改字段表。
		/// </summary>
		/// <param name="ViewName">显示名称</param>
		/// <param name="FieldName">字段名称</param>
		/// <param name="Enable">参数</param>
		private void SaveToTable(string QueryTableID,string FieldName,string ViewName,int Enable,string Operation)
		{
			try{
				string sql="";
				if(Operation=="Add") {//添加
					if(dc.IFExist("select count(*) from QueryFields where QueryFiledView='"+ViewName+"'")==0){
						sql="insert into QueryFields(QueryTableID,QueryFiledValue,QueryFiledView,IsQuery) values("+QueryTableID+",'"+FieldName+"','"+ViewName+"',"+Enable+") ";
						dc.addData(sql);
					}				
					else {
						LabelMsg.Text="保存失败，已经存在相同记录";
					}
				}
				else if(Operation=="Edit") {//修改
					sql="update QueryFields set QueryFiledValue='"+FieldName+"' ,QueryFiledView='"+ViewName+"',IsQuery="+Enable+" where QueryFieldID="+LabelValue.Text;
					dc.addData(sql);
				}
				
				LabelMsg.Text="保存成功";
			}
			catch(System.Exception err){
				LabelMsg.Text="保存失败:\r\n"+err.Message;
			}
			finally{
				DataGridBind();
			}
		}
		/// <summary>
		/// 绑定到datagrid
		/// </summary>
		private void DataGridBind()
		{
			try{
				string sql="select IsQuery,QueryFiledView,QueryFiledValue,QueryFieldID from QueryFields where QueryTableID="+QueryTableID+" order by QueryFieldID desc";
				DataGridList.DataSource=dc.getBinding(sql,"QueryFields");
				DataGridList.DataBind();
			}
			catch(System.Exception err){
				LabelMsg.Text="数据错误:"+err.Message;
			}
		}

		private void DataGridList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) {
			if(e.Item.Cells[2].Text.Trim()!="状态") {
				if(e.Item.Cells[2].Text=="True") {
					e.Item.Cells[2].Text="启用";
				}
				else {
					e.Item.Cells[2].Text="<font color=red>禁用</font>";
				}
			}
		}

		private void DataGridList_SelectedIndexChanged(object sender, System.EventArgs e) {						
			LabelOperation.Text="Edit";//修改
			LabelValue.Text=DataGridList.SelectedItem.Cells[4].Text;
			TextBoxViewName.Text=DataGridList.SelectedItem.Cells[0].Text;
			TextBoxFieldName.Text=DataGridList.SelectedItem.Cells[1].Text;			
			if(DataGridList.SelectedItem.Cells[2].Text=="<font color=red>禁用</font>") {
				CheckBoxEnable.Checked=false;
			}
			else {
				CheckBoxEnable.Checked=true;
			}				
		}
	}
}