supplycontactadmin.aspx.cs

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

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;
namespace NewGlassBook
{
	public class SupplyContactAdmin :MyPage
	{
		protected SuperDataGrid dgShow;
		protected System.Web.UI.WebControls.Label lblWarning;
		protected System.Web.UI.WebControls.LinkButton DeleteLink;
		protected NewGlassBook.MyTextBox conditionValue;
		protected System.Web.UI.WebControls.DropDownList condition;
		protected NewGlassBook.MyButton dbtn_search;
		Record r;
		string strSql;	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
				strSql="select a.id,*,b.name as sname from supplycontact a,supply b where a.supplyid=b.id and a.id<>'00000'";
				Session["strSql"]=strSql;//查询业务员信息和所属的供应商信息
				dgShowOpen();
			}
		}				
		public void dgShow_Change(Object sender, DataGridPageChangedEventArgs e) 
		{
			dgShow.CurrentPageIndex = e.NewPageIndex;		
			dgShowOpen();
		}
		private void dgShowOpen()
		{
			r=new Record();
			DataSet ds=r.GetData("a_b",Session["strSql"].ToString());			
			DataView dv=ds.Tables["a_b"].DefaultView;
			dgShow.DataSource=dv;
			dgShow.PagerStyle.Mode=PagerMode.NumericPages;
			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.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

	
		private void dbtn_search_Click(object sender, System.EventArgs e)
		{
			string strValue,strCondition;
			strValue=conditionValue.Text;
			strCondition=condition.SelectedItem.Value.ToString();
			strSql="select *,b.name as sname from supplycontact a,supply b where a.supplyid=b.id and a.supplyid<>'s0000'and "+strCondition+" like '%"+strValue+"%'";
			Session["strSql"]=strSql;			
			dgShow.CurrentPageIndex=0;
			dgShowOpen();
		}

	}
}