customeradmin.aspx.cs

ASP.NET编写的眼镜行分销系统的程序.

using System;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace NewGlassBook
{
	public class CustomerAdmin :MyPage
	{
		protected SuperDataGrid dgShow;
		protected System.Web.UI.WebControls.LinkButton DeleteLink;
		protected System.Web.UI.WebControls.Label lblWarning;
		protected NewGlassBook.MyButton dbtn_search;
		protected System.Web.UI.WebControls.DropDownList condition;		
		protected System.Web.UI.WebControls.TextBox conditionValue;
		string strSql;
		Record r=new Record();//访问数据库用
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
				//取得所有客户信息
				strSql="select * from Customer  where id<>'00000000' order by id";				
				Session["strSql"]=strSql;
				dgShowOpen();
			}
		}
		//打开客户信息编辑页
		protected string OpenWin(object obj)
		{
			if (!Convert.IsDBNull(obj))
			{
				return "window.open(\"customeredit.aspx?id=" + obj.ToString() + "\", \"\",\"width=300,height=410,top=100,left=290\");return false;";
			}
			return "";
		}
		//打开客户信息浏览页
		protected string OpenWinB(object obj)
		{
			if (!Convert.IsDBNull(obj))
			{
				return "window.open(\"customerbrows.aspx?id=" + obj.ToString() + "\", \"\",\"width=300,height=410,top=100,left=290\");return false;";
			}
			return "";
		}
		public void dgShow_Change(Object sender, DataGridPageChangedEventArgs e) 
		{
			dgShow.CurrentPageIndex = e.NewPageIndex;//更改datagrid的pageindex
			dgShowOpen();
		}
		private void dgShowOpen()
		{
			DataSet ds=r.GetData("customer",Session["strSql"].ToString());						
			dgShow.DataSource=ds;
			dgShow.DataBind();			
		}
		
		
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    			
			this.dbtn_search.Click += new System.EventHandler(this.dbtn_search_Click);
			this.dgShow.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgShow_Change);
			this.dgShow.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgShow_DeleteCommand);
			this.dgShow.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgShow_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void dgShow_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.FindControl("DeleteLink")!= null)
			{ 
				//增加确认信息框
				((LinkButton) e.Item.FindControl("DeleteLink")).Attributes.Add("onClick", "return confirm('您确实要删除当前客户以及其消费信息吗?');");
			}					
		}

		private void dbtn_search_Click(object sender, System.EventArgs e)
		{
			string strValue,strCondition;
			strValue=conditionValue.Text.Trim();
			strCondition=condition.SelectedItem.Value.ToString();
			//生成查询语句
			Session["strSql"]="select customer.id,password,name,sex,address,tel,mobile,email from customer";
			Session["strSql"]=Session["strSql"]+" where  "+strCondition+" like '%"+strValue+"%' ";						
			dgShow.CurrentPageIndex=0;
			dgShowOpen();
		}		

		protected void dgShow_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			strSql="delete from customer where id='"+e.Item.Cells[0].Text.ToString()+"'";
			r.ExecuteQuery(strSql);
			dgShowOpen();
		}				
	}
}