templatelist.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 ZHENGYI;
using System.Data .SqlClient ;
namespace OI.DocTemplate.Template
{
	/// <summary>
	/// TemplateList 的摘要说明。
	/// </summary>
	public class TemplateList : OI.PageBase
	{
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Data .DataSet ds;
		protected OI.DatabaseOper.DatabaseConnect oConn=new OI.DatabaseOper.DatabaseConnect ();
		protected System.Web.UI.WebControls.DropDownList DropDownListPrimay;
		protected System.Web.UI.WebControls.DropDownList DropDownListChild;
		protected System.Web.UI.WebControls.TextBox TextBoxTemplateName;
		protected System.Web.UI.WebControls.TextBox TextBoxDescript;
		protected System.Web.UI.WebControls.ImageButton ImageButtonNext;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected DataGridNavigation  divepage ;
        public string manageid="";
		public int departmentid ;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
              
			try {
				ViewState["type"]=Request.Params ["type"].ToString (); 
			}
			catch{
				ViewState["type"]="";
			}
			JuadgeDepartment();


			SetDivePage();
			if (!Page.IsPostBack )
			{　
				dataBind();
			}
			
			manageid=Session["manageid"].ToString ();//????
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			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.AlternatingItem ||e.Item .ItemType ==ListItemType.Item )
			{
				e.Item .Cells[4].Text="<a href=TemplateList2.aspx?RecordId="+e.Item .Cells[0].Text + "&FileType="+e.Item.Cells[2].Text+"&departmentid="+departmentid+"><img border=0 src=../../images/edit.gif   alt='修改'></a>";
				e.Item .Cells[5].Text="<a href=\"TemplateDel.aspx?RecordId="+e.Item .Cells[0].Text + "\"><img border=0 src=../../images/delete.gif   alt='删除' onclick=\" if (!confirm('你是否确定要删除?')) return false; \"></a>";
			}
		}
		/// <summary>
		/// 取得文档所属部门。
		/// </summary>
		private void JuadgeDepartment() {			
			if (ViewState["type"].ToString ()=="admin") {
				departmentid=0;
			}
			else {
				departmentid=Convert.ToInt32(Session["departmentid"]) ;
			}
		}
		/// <summary>
		/// 
		/// </summary>
		private void CreateDataSource()
		{
			string szSql;
			int manageid=Convert.ToInt32(Request.Params ["manageid"]);
			if(ViewState["type"].ToString () !="")
			{
				szSql = " Select t.RecordID,t.FileType,t.FileName,v.DocumentTypeName,v.DocumentTypeDescription From ";
					szSql= szSql+" Template  t inner join  VIEW_DocumentType v  on v.DocumentTypeID=t.DocumentTypeID  ";
					szSql=szSql+"  order by t.TemplateID desc ";
                Session["manageid"]=1;
			}
			else
			{
				szSql = " Select t.RecordID,t.FileType,t.FileName,v.DocumentTypeName,v.DocumentTypeDescription From Template t inner join  VIEW_DocumentType v  ";
				szSql=szSql+" on v.DocumentTypeID=t.DocumentTypeID where departmentid="+Session["departmentid"]+" order by TemplateID desc ";
			    Session["manageid"]=0;
			}
			ds=new DataSet ();
			ds=oConn.getBinding(szSql,"t");　
		}
		private void SetDivePage()
		{
			dg.AllowPaging =true; 
			dg.PageSize =15; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (dataBind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(dg,f,15);
		}
		private void dataBind()
		{
			CreateDataSource();
			dg.DataSource =ds.Tables[0];
			dg.DataBind ();
		}
	}
	}