outdonefile.aspx.cs

很不错的公文流转系统

/***********************************************
 * Author:吴高发
 * Date:04-2-6
 * ********************************************/
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.PersonSend
{
	/// <summary>
	/// OutDoneFile 的摘要说明。
	/// </summary>
	public class OutDoneFile : OI.PageBase 
	{
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Web.UI.WebControls.ImageButton ImageButtonDel;
		private OI.DatabaseOper .DatabaseConnect dc;
		protected System.Web.UI.WebControls.ImageButton ImageButtonSelectAll;
		protected ZHENGYI.DataGridNavigation divepage;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			this.SetDivePage ();
			if(!this.IsPostBack )
			{
				this.BindDataNew ();
			}
		}
		private void BindDataNew()
		{
							
			string sql="SELECT datumPersonAccept.ID,datumPersonAccept.DatumID,dbo.datumPersonSend.Title, dbo.datumPersonSend.SendDate, "+
				"dbo.Accounts_Users.UserName, dbo.ExigenceDegree.ExigenceDegreeName "+
				"FROM dbo.datumPersonAccept,dbo.datumPersonSend,dbo.Accounts_Users,dbo.ExigenceDegree  "+
				"WHERE dbo.datumPersonAccept.DatumID = dbo.datumPersonSend.DatumID and "+
				"dbo.datumPersonAccept.disalow !=1 and "+
				"dbo.datumPersonSend.UserID = dbo.Accounts_Users.UserID and "+
				"dbo.datumPersonSend.ExigenceDegreeID = dbo.ExigenceDegree.ExigenceDegreeID and "+	
				"dbo.datumPersonAccept.isAccept=1 and  datumPersonAccept.isdel=0 and "+	
				"dbo.datumPersonAccept.UserID='"+Session["userid"].ToString ()+"' "+
				"ORDER BY dbo.datumPersonSend.SendDate DESC";
			dc=new OI.DatabaseOper.DatabaseConnect ();
			DataSet ds=dc.getBinding (sql,"t1");
			dg.DataSource =ds.Tables ["t1"].DefaultView ;
			dg.DataBind ();
		}
		private void SetDivePage()
		{
			dg.AllowPaging =true; 
			dg.PageSize =15; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (BindDataNew);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(dg,f,15);
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);
			this.ImageButtonDel.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonDel_Click);
			this.Load += new System.EventHandler(this.Page_Load);

			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ImageButtonSelectAll.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonSelectAll_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item .ItemType !=ListItemType.Footer &&e.Item .ItemType !=ListItemType.Header )
				e.Item .Cells [5].Text ="<a href=\"addEdit.aspx?id="+e.Item .Cells [7].Text +"\"><img src=\"../images/zhuanfa.gif\" border=\"0\"></a>";
			
		}

		private void ImageButtonDO_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{			
			ArrayList alWhere=new ArrayList ();
			foreach(DataGridItem  li in this.dg.Items) 
			{				
				if(((CheckBox)li.FindControl("CheckBoxId")).Checked) 
				{
					alWhere.Add (li.Cells[0].Text.ToString());									
				}
			}
			string []sql=new string [alWhere.Count];
			for(int i=0;i<alWhere.Count ;i++)
			{
				sql[i]="update datumPersonAccept set isaccept=1,acceptdate='"+System.DateTime .Now +"' where id="+alWhere[i].ToString ().Trim ();
			}
			dc=new OI.DatabaseOper.DatabaseConnect ();
			dc.ExcuteSqls (sql);
			this.BindDataNew ();
		}

		private void ImageButtonDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			//ArrayList alSql=new ArrayList ();
			delDatum del=new delDatum ();
			foreach(DataGridItem  li in this.dg.Items) 
			{				
				if(((CheckBox)li.FindControl("CheckBoxId")).Checked) 
				{
					try
					{
						del.acceptDatumDel (int.Parse (li.Cells[0].Text)); 
					}
					catch (Exception er )
					{
						Response.Write (er.Message +"<br/>");
					}							
				}
			}
		//	dc=new OI.DatabaseOper.DatabaseConnect ();
		//	dc.ExecuteTransaction (alSql);
			this.BindDataNew ();
		}

		private void ImageButtonSelectAll_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			foreach (TableRow tr in dg.Items )
			{
				CheckBox CheckBoxId=(CheckBox)tr.FindControl ("CheckBoxId");
				if (CheckBoxId !=null)
				{
					CheckBoxId.Checked =true;
				}
			}
		}
	}
}