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);
						}
						
						/// 
						/// Required method for Designer support - do not modify
						/// the contents of this method with the code editor.
						/// 
						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();
						}
				
					}
				}