generalsearchmanage.aspx.cs

很不错的公文流转系统

/**************************************
 * 
 * 创建者：周建波
 * 
 * 创建日期：2003-12-12
 * 
 * 功能:维护通用查询看用到的表数据。 
 * 
 * ***********************************/

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 OI.Manage
{
	/// <summary>
	/// GeneralSearchManage 的摘要说明。
	/// </summary>
	public class GeneralSearchManage : OI.PageBase 
	{
		protected System.Web.UI.WebControls.TextBox TextBoxTableName;
		protected System.Web.UI.WebControls.TextBox TextBoxViewName;
		protected System.Web.UI.WebControls.CheckBox CheckBoxEnable;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSave;
		protected System.Web.UI.WebControls.DataGrid DataGridList;
		protected System.Web.UI.WebControls.Label LabelMsg;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		private OI.DatabaseOper .DatabaseConnect dc=new OI.DatabaseOper.DatabaseConnect ();
		protected System.Web.UI.WebControls.Label LabelOperation;
		protected System.Web.UI.WebControls.Label LabelValue;
		 protected ZHENGYI.DataGridNavigation DataGridNavigation1;

		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 (DataBindToDataGrid);//修改这个dataBind,让f 指向你的方法。 
			DataGridNavigation1.SetTarget(DataGridList,f,10);

			if(!Page.IsPostBack)
			{
				//绑定到DataGrid
				LabelOperation.Text="Add";
				 DataBindToDataGrid();
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			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 TableName=OI.Modules.String.GenSafeChars(TextBoxTableName.Text.Trim());
			string ViewName=OI.Modules.String.GenSafeChars(TextBoxViewName.Text.Trim());
			int Enable=1;
			if(CheckBoxEnable.Checked)
			{
				Enable=1;
			}
			else{
				Enable=0;
			}

			SaveToTable(TableName,ViewName,Enable);
			TextBoxTableName.Text="";
			TextBoxViewName.Text="";
		}
/// <summary>
/// 添加数据到QueryTables
/// </summary>
/// <param name="TableName">物理表名</param>
/// <param name="ViewName">看到的表名</param>
/// <param name="Enable">是否可用</param>
		private void SaveToTable(string TableName,string ViewName,int Enable)
		{
			try{
				if(LabelOperation.Text=="Add"){
					if(dc.IFExist("select count(ViewName) from QueryTables where ViewName='"+ViewName+"'")==0) {		
						string sql="insert into QueryTables(ViewName,TableName,IsQuery) values('"+ViewName+"','"+TableName+"',"+Enable+")";
						dc.ExecuteSQL(sql);
						LabelMsg.Text="保存成功";					
					}
					else {
						LabelMsg.Text="保存失败,该表名已经存在";
					}
				}
				else {
					string sql="update QueryTables set ViewName='"+ViewName+"',TableName='"+TableName+"',IsQuery="+Enable+" where QueryTableID="+LabelValue.Text;
					dc.ExecuteSQL(sql);
					LabelMsg.Text="保存成功";					
				}
			}
			catch
			{
				LabelMsg.Text="保存失败";
			}
			finally
			{
				DataBindToDataGrid();
			}		 
		}
		/// <summary>
		/// 从QueryTables读取数据并绑定DataGrid
		/// </summary>
		private void  DataBindToDataGrid()
		{
			string sql="select * from QueryTables order by QueryTableID desc";
			DataGridList.DataSource=dc.getBinding(sql,"QueryTables");
			DataGridList.DataBind();
		}

		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>";
				}
			}
			if(e.Item.ItemType !=ListItemType.Footer &&e.Item.ItemType !=ListItemType.Header) {
				e.Item.Cells [0].Text ="<a href=GeneralSearchFieldManage.aspx?QueryTableID="+ e.Item.Cells[4].Text +"&ViewName="+e.Item .Cells[0].Text +">"+e.Item .Cells[0].Text +"</a>"  ;
				
			}
		}

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

		　
	}
}