archiveitem.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 OI.DatabaseOper;

namespace OI.Archives
{
	/// <summary>
	/// ArchiveItem 的摘要说明。
	/// </summary>
	public class ArchiveItem : OI.PageBase
	{
		protected System.Web.UI.WebControls.DropDownList DropDownListSelect;
		protected System.Web.UI.WebControls.TextBox TextBoxSelect;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected ZHENGYI.DataGridNavigation divepage;
		protected System.Web.UI.WebControls.DataGrid DataGridItem;
		protected  DatabaseConnect dc=new 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)
			{
				Bind();
			}// 在此处放置用户代码以初始化页面
		}
		
		/// <summary>
		/// 设置分页
		/// </summary>
		private void SetDivePage()
		{
			//			DataGridItem.AllowPaging =true; 
			//			DataGridItem.PageSize =10; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (Bind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(DataGridItem,f,15);
		}
		
		
		/// <summary>
		/// 绑定
		/// </summary>
		private void  Bind()
		{
			//判断查询条件
			string conn=null;
			if(DropDownListSelect.SelectedValue .Trim ()=="请选择")
				conn=null;
			else if(DropDownListSelect.SelectedValue .Trim ()=="标题")
				conn=" where Title LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			else if(DropDownListSelect.SelectedValue .Trim ()=="发文单位")
				conn=" where SendComp LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			else if(DropDownListSelect.SelectedValue .Trim ()=="主题词")
				conn=" where TopicWord LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
			
			
			string sql1="select RecordFileID,Title,SendComp,MainSendComp,RecordDate,  "+
				"case when "+
				"len(Convert(nchar(15),TopicWord))>10 "+
				"then SUBSTRING(TopicWord,0,11)+'...' "+
				"else TopicWord "+
				"end "+
				"AS TopicWord "+
				"FROM RecordFile "+conn+"ORDER BY RecordFileID DESC";
			DataSet ds=dc.getBinding(sql1,"RecordFile");
			DataGridItem.DataSource =ds.Tables ["RecordFile"].DefaultView ;
			DataGridItem.DataBind();
		}
	

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

		}
		#endregion

		/// <summary>
		/// 查询
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void ButtonSelect_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if (DropDownListSelect.SelectedValue.Trim()=="请选择" )
			{
				Page.RegisterStartupScript("","<script>alert('请选择查询项');</script>"); 
				return;
			}
			
			this.Bind();
		
		}

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