signaturelist.aspx.cs

很不错的公文流转系统

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.DocTemplate.Signature
{
	/// <summary>
	/// SignatureList 的摘要说明。
	/// </summary>
	public class SignatureList : OI.PageBase
	{
		protected System.Web.UI.WebControls.DataGrid DataGridList;
		protected DatabaseOper.DatabaseConnect conn=new OI.DatabaseOper.DatabaseConnect();
		protected ZHENGYI.DataGridNavigation DataGridNavigation1;
		public string mSubject;
		public string mStatus;
		public string mAuthor;
		public string mFileName;
		public string mFileDate;
		public string mHTMLPath;

		public string mDisabled;

		public string mHttpUrl;
		public string mScriptName;
		public string mServerName;
		public string mClientName;
		public string mServerUrl;
		public string mClientUrl;


		public string mRecordID;
		public string mTemplate;
		public string mFileType;
		public string mEditType;
		public string mUserName;
		protected System.Web.UI.WebControls.ImageButton imgfind;
		protected System.Web.UI.WebControls.TextBox TextBoxSignature;		
		public string mDrawMan;

		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 (GetSignatureList);//修改这个dataBind,让f 指向你的方法。 
			DataGridNavigation1.SetTarget(DataGridList,f,20);
			if(!Page.IsPostBack)
			{
				GetSignatureList();
			}

		
						
			mHTMLPath="";
			mDisabled="";
			mScriptName="DraftEdit.aspx";
			mServerName="webdocserver.aspx";
			mClientName="../FairyWebOfficeocx.ocx";			
			mHttpUrl="http://" + Request.ServerVariables["HTTP_HOST"] + Request.ServerVariables["SCRIPT_NAME"];
			mHttpUrl=mHttpUrl.Substring(0,mHttpUrl.Length -mScriptName.Length);
			if(System.Web.HttpRuntime.AppDomainAppVirtualPath=="")
				mServerUrl="http://"+Request.ServerVariables["HTTP_HOST"] +"/DocTemplate/" + mServerName;
			else
				mServerUrl="http://"+Request.ServerVariables["HTTP_HOST"] +System.Web.HttpRuntime.AppDomainAppVirtualPath+"/DocTemplate/" + mServerName;
			mClientUrl=mHttpUrl + mClientName;
			


		}
		private void GetSignatureList()
		{ 
			string sql="select * from Signature order by SignatureID desc";
			DataGridList.DataSource=conn.getBinding(sql,"data"); 
			DataGridList.DataBind();		
		}

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

		}
		#endregion

		private void ImageButtonAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
//			Response.Redirect("SignatureAddFrm.aspx");
		}

				 
		private void DataGridList_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="Delete")
			{
				string PkId=e.Item.Cells[0].Text;
				if(PkId=="")
					return;
				else
				{
					string sql="delete from Signature where SignatureID="+PkId;
					conn.ExecuteSQL(sql);
					GetSignatureList();
				}
			}
		}

		private void DataGridList_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void DataGridList_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			LinkButton lb=(LinkButton)e.Item .FindControl ("Linkbutton1");
			if(lb!=null)
			{
				lb.Attributes["onclick"]="return confirm('你确认删除吗？');";
			}

			if (e.Item.ItemType ==ListItemType.Item ||e.Item.ItemType ==ListItemType.AlternatingItem  ) {
				ImageButton changePersonSign=(ImageButton) e.Item.FindControl ("ImageButton1");
				if(changePersonSign !=null) {
					changePersonSign.Attributes ["onclick"]="return confirm('你是否将该密码设为初始值？');";
					changePersonSign.Click +=new ImageClickEventHandler(changePersonSign_Click);
					
				}

			}
		}

		private void imgfind_Click(object sender, System.Web.UI.ImageClickEventArgs e) {
		string Signature=TextBoxSignature.Text.Trim().Replace("'","");
			string sql="select * from Signature where MarkName like '%"+Signature+"%'";
			DataGridList.DataSource=conn.getBinding(sql,"abc");
			DataGridList.DataBind();
		}
		private void changePersonSign_Click(object sender, System.Web.UI.ImageClickEventArgs e) {
			
			ImageButton changePersonSign=(ImageButton) sender;
			DataGridItem dgitem=(DataGridItem)changePersonSign.Parent .Parent ;
	
			try { 
				int SignatureID= int.Parse (dgitem.Cells[0].Text .Trim ()); 
				string sql="update  Signature set Password=1111 where SignatureID="+SignatureID.ToString ();
				conn.ExecuteSQL(sql);
				
			}
			catch(Exception er) {
				Response.Write (er);
				Response.End ();
			}	 
		
		}
	}
}