addresslist.aspx.cs

很不错的公文流转系统

/**************************************************************************************
作者：蒲丰. 
创建日期：2003-11-24
修改者：
修改日期：
修改部分：
类功能： 通讯录的显示,查寻功能.
****************************/
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;
namespace OI.AddressList
{
	/// <summary>
	/// AddressList 的摘要说明。
	/// </summary>
	public class AddressList : OI.PageBase
	{
		protected System.Web.UI.WebControls.DataGrid dg;
		protected System.Web.UI.WebControls.ImageButton ImageButtonadd;
		protected System.Web.UI.WebControls.TextBox TextBoxUsername;
		protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		protected DataGridNavigation  divepage ;
		protected System.Web.UI.HtmlControls.HtmlInputHidden delid;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected DataSet ds;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			SetDivePage();
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			if (!Page.IsPostBack )
			{

				dataBind();
			}
			else
			{
                del();
			}
		}
		private void del()
		{
			if  (delid.Value.Trim () =="")
			{
			}
			else
			{
				string sql="delete  from addresslist where ListID="+delid.Value.Trim ();
				Dbc.ExecuteSQL (sql);
				Page.RegisterStartupScript ("","<script>window.location.href='AddressList.aspx';</script>");
			
			}

          
		}
		private void CreateDataSource()
		{
			string str=" select * from AddressList where Reletioner like '%"+ TextBoxUsername.Text +"%'  and  userid="+Session["userid"].ToString () ;
			ds=new DataSet ();
			ds=Dbc.getBinding(str,"t");
			DataColumn dc=new DataColumn ("modify",typeof(String));
			dc.Expression ="'<a href=\"AddressListModify.aspx?id='+ListID+'\"><img src=../images/edit.gif border=0></a>'";
			ds.Tables[0].Columns .Add (dc);
			//del
			DataColumn del=new DataColumn ("del",typeof(String));
			del.Expression ="'<a href=#  onclick=\"del('+ListID+')\"><img src=../images/delete.gif border=0></a>'";
			ds.Tables[0].Columns .Add (del);

			
		}
		private void SetDivePage()
		{
			dg.AllowPaging =true; 
			dg.PageSize =10; 
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (dataBind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(dg,f,20);
		}
		private void dataBind()
		{
			CreateDataSource();
			dg.DataSource =ds.Tables[0];
			dg.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.ImageButton1_Click);
			this.dg.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dg_ItemDataBound);
			this.ImageButtonadd.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonadd_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

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

		private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item .ItemType ==ListItemType. Item ||e.Item .ItemType ==ListItemType.AlternatingItem )
			{
				e.Item.Cells[1].Text ="<A href=AddressListView.aspx?id="+e.Item .Cells[0].Text +">"+e.Item .Cells [1].Text + "</a>";
				
				 
					e.Item .Cells [4].Text ="<a title=\""+e.Item .Cells[4].Text +"\">"+e.Item.Cells [4].Text.ToString() +"</a>";
				 
				 
					e.Item .Cells [5].Text ="<a title=\""+e.Item .Cells[5].Text +"\">"+e.Item.Cells [5].Text.ToString() +"</a>";
				 
				if (e.Item .Cells [2].Text =="True")
				{
					e.Item .Cells [2].Text ="男";
					
				}
				else
				{
					e.Item .Cells [2].Text ="女";
				}
			}
		}

		private void ImageButtonadd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Response.Redirect ("AddressListAdd.aspx");
		}

		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			dataBind();
		}
	}
}