personplan.aspx.cs

很不错的公文流转系统

/*
 *作者：吴高发
 *日期：2003-11-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;
using OI.DatabaseOper ;

namespace OI.IndividualArrange
{
	/// <summary>
	/// personPlan 的摘要说明。
	/// </summary>			 OI.PageBase
	public class personPlan : OI.PageBase
	{
		protected System.Web.UI.WebControls.DataGrid DataGridDisp;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected System.Web.UI.WebControls.ImageButton ImageButton2;
		private DatabaseConnect  dc;
		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 ;
			}
			ImageButton2.Attributes["onclick"]= "return confirm('是否要删除？')";
			dc=new DatabaseConnect ();
			SetDivePage();
			if(!this.IsPostBack )
			{
				this.PlanBind ();
			}
		}

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

		}
		#endregion

		private void ButtonAdd_Click(object sender, System.EventArgs e)
		{
			
		}
		private void SetDivePage()
		{
			DataGridDisp.AllowPaging =true; 
			DataGridDisp.PageSize =10; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (PlanBind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(DataGridDisp,f,20);
		}

		private void ButtonDel_Click(object sender, System.EventArgs e)
		{			
			
		}
		private void PlanBind()
		{
			if(Session["userid"]==null||Session["userid"].ToString ()=="")
			{
				Page.RegisterStartupScript ("","<script>alert(\"操作时间过长，请重新登录\")</script>");
				return;
			}
			string sql="SELECT PlanID,Title,BeginDate,EndDate FROM SelfPlan WHERE UserID='"+Session["userID"]+"' ORDER BY BeginDate DESC";//UserID=Session["userID"]
			DataSet ds=dc.getBinding (sql,"SelfPlan");
			DataGridDisp.DataSource =ds.Tables ["SelfPlan"].DefaultView ;
			DataGridDisp.DataBind ();
		}

		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e) {
			Response.Redirect ("PersonAddModi.aspx?id=-1");
		}

		private void ImageButton2_Click(object sender, System.Web.UI.ImageClickEventArgs e) {
			string id="";
			int i=0;
			foreach(DataGridItem  li in this.DataGridDisp.Items) {				
				if(((CheckBox)li.FindControl("CheckBoxId")).Checked) {
					i++;
					if(i==1)
						id+=" planid="+li.Cells[0].Text.ToString();//
					if(i>1)
						id+=" OR planid="+li.Cells[0].Text.ToString();
				}
			}
			if(i==0)
				return;
			else {				
				string sql="DELETE FROM SelfPlan WHERE "+id;
				dc.deleteData (sql);
				DataGridDisp.CurrentPageIndex =0;
				this.PlanBind ();
			}
			
		}

		private void DataGridDisp_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			Response.Redirect ("PersonAddModi.aspx?id="+e.Item .Cells [0].Text );
		}

		private void DataGridDisp_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			Response.Redirect ("PersonAddModi.aspx?id="+e.Item .Cells [0].Text );
		}
	}
}