backagree.aspx.cs

很不错的公文流转系统

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 System.Data .SqlClient ;
using ZHENGYI;
namespace OI.ReFileOperate
{
	/// <summary>
	/// backagree 的摘要说明。
	/// </summary>
	public class backagree : OI.PageBase 
	{
		protected System.Web.UI.WebControls.DataGrid dg;
	
		protected  DataGridNavigation divage ;
		DataSet ds;
		
		protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			SetDivePage();
			if (!Page.IsPostBack )
			{
				dataBind();
			}
			
		}
		private void SetDivePage()
		{
			dg.AllowPaging =true; 
			dg.PageSize =15; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (dataBind);//修改这个dataBind,让f 指向你的方法。 
			divage.SetTarget(dg,f,15);
		}
		private void dataBind()
		{
			CreateDataSource();
			dg.DataSource = ds.Tables[0];
			dg.DataBind ();
			
		}
		private void CreateDataSource()
		{
			string sql="select * from view_document where currentstepid=0 and   documentid  in  (select dt.documentid from documenttransact dt)";
			sql += " and  userid="+Session["userid"].ToString ();
			sql +=" order by filedate desc ";
			ds=new DataSet ();
			ds=Dbc.getBinding (sql,"t");
			DataColumn op=new DataColumn ("oprater",typeof(String));
			op.DefaultValue ="";
			ds.Tables[0].Columns .Add (op); 

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.dg.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemCreated);
			this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);
			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.Item  ||e.Item.ItemType ==ListItemType.AlternatingItem )
			{
				//处理标题列
				if(e.Item .Cells[1].Text.Length  >20 )
				{
					e.Item .Cells[1].Text="<a href=\"../archives/ArchiveDetail.aspx?documentid="+e.Item.Cells[0].Text +"\" title=\""+e.Item .Cells[1].Text +"\">" + e.Item .Cells[1].Text .Substring (0,20)+"...</a>";
				
				}
				else //标题长度不超过10
				{
					e.Item .Cells[1].Text="<a href=\"../archives/ArchiveDetail.aspx?documentid="+e.Item.Cells[0].Text +"\" >" + e.Item .Cells[1].Text +"</a>";
				}
				e.Item.Cells[5].Text =" <a href=\"../draftout/draftstart.aspx?documentid="+e.Item.Cells[0].Text+"&edittype=3\"><IMG src=\"../images/edit.gif\" "+
				"border=\"0\" alt=\"修改\"></a>";
				//end
				//处理增加的操作列
			}
			
		}

		private void dg_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			//imgbtnDel
			if(e.Item.ItemType ==ListItemType.Item  ||e.Item.ItemType ==ListItemType.AlternatingItem )
			{
				ImageButton imgDel=(ImageButton)e.Item .FindControl ("imgbtnDel");
				imgDel.Attributes["onclick"] ="javascript:return confirm('你确定要删除?');";
				imgDel.Click +=new ImageClickEventHandler(imgDel_Click);
			}
		}

		
		private void imgDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			ImageButton imgdel=(ImageButton) sender;
			TableRow tr=(TableRow)imgdel.Parent.Parent;
			string documentid =tr.Cells[0].Text ;
			string []dels=new string [4];
			dels[0]=" delete from TransactUsers where documentid="+documentid;
			dels[1]=" delete from DocumentTransact where documentid="+documentid;
			dels[2]=" delete from document_file where recordid=(select recordid from document where  documentid="+documentid +")";
			dels[3]=" delete from document where  documentid="+documentid;
			cs.Message message =new OI.cs.Message ();
			message.finishOprate (int.Parse (Session["userid"].ToString ()),int.Parse (documentid),"回退公文");
			try
			{
				Dbc.ExcuteSqls(dels) ;
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			dataBind();
		}
		
	}

		
}