cpinex.aspx.cs

来自「主要功能： 1、 包括顾客信息、货品信息、定单信息的管理。 2、」· CS 代码 · 共 1,483 行 · 第 1/4 页

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.OleDb;

namespace jd
{
	/// <summary>
	/// WebForm7 的摘要说明。
	/// </summary>
	public class WebForm7 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.HyperLink HyperLink6;
		protected System.Web.UI.WebControls.HyperLink HyperLink5;
		protected System.Web.UI.WebControls.HyperLink HyperLink4;
		protected System.Web.UI.WebControls.HyperLink HyperLink3;
		protected System.Web.UI.WebControls.Image Image3;
		protected System.Web.UI.WebControls.Image Image2;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Image Image4;
		protected System.Web.UI.WebControls.LinkButton LinkButton2;
		protected System.Web.UI.WebControls.Panel Panel2;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.Image Image10;
		protected System.Web.UI.WebControls.Image Image19;
		protected System.Web.UI.WebControls.Image Image20;
		protected System.Web.UI.WebControls.Image Image21;
		protected System.Web.UI.WebControls.Panel P1;
		protected System.Web.UI.WebControls.LinkButton LinkButton3;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Panel Panel3;
		protected System.Web.UI.WebControls.Image Image22;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Image Image23;
		protected System.Web.UI.WebControls.Panel Panel4;
		protected System.Web.UI.WebControls.Image Image24;
		protected System.Web.UI.WebControls.Panel Panel5;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.HyperLink HyperLink10;
		protected System.Web.UI.WebControls.HyperLink HyperLink9;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Image Image25;
		protected System.Web.UI.WebControls.Panel Panel6;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.LinkButton H1;
		protected System.Web.UI.WebControls.LinkButton H2;
		protected System.Web.UI.WebControls.LinkButton H3;
		protected System.Web.UI.WebControls.LinkButton H4;
		protected System.Web.UI.WebControls.LinkButton H6;
		protected System.Web.UI.WebControls.LinkButton H5;
		protected System.Web.UI.HtmlControls.HtmlGenericControl FONT1;
		protected System.Web.UI.WebControls.Image Image18;
		protected System.Web.UI.WebControls.LinkButton H12;
		protected System.Web.UI.WebControls.Image Image26;
		protected System.Web.UI.WebControls.LinkButton H11;
		protected System.Web.UI.WebControls.Image Image27;
		protected System.Web.UI.WebControls.LinkButton H10;
		protected System.Web.UI.WebControls.Image Image28;
		protected System.Web.UI.WebControls.LinkButton H9;
		protected System.Web.UI.WebControls.Image Image29;
		protected System.Web.UI.WebControls.LinkButton H8;
		protected System.Web.UI.WebControls.Image Image30;
		protected System.Web.UI.WebControls.LinkButton H7;
		protected System.Web.UI.WebControls.Image Image31;
		protected System.Web.UI.WebControls.LinkButton H18;
		protected System.Web.UI.WebControls.Image Image11;
		protected System.Web.UI.WebControls.LinkButton H17;
		protected System.Web.UI.WebControls.Image Image12;
		protected System.Web.UI.WebControls.LinkButton H16;
		protected System.Web.UI.WebControls.Image Image13;
		protected System.Web.UI.WebControls.LinkButton H15;
		protected System.Web.UI.WebControls.Image Image14;
		protected System.Web.UI.WebControls.LinkButton H14;
		protected System.Web.UI.WebControls.Image Image15;
		protected System.Web.UI.WebControls.LinkButton H13;
		protected System.Web.UI.WebControls.Image Image16;
		protected System.Web.UI.WebControls.Panel P2;
		protected System.Web.UI.WebControls.Panel P3;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.DataGrid DataGrid2;
		protected System.Web.UI.WebControls.DataGrid DataGrid3;
		protected System.Web.UI.WebControls.Panel Pdata1;
		protected System.Web.UI.WebControls.Panel Pdata2;
		protected System.Web.UI.WebControls.DataGrid DataGrid4;
		protected System.Web.UI.WebControls.Panel Pdata3;
		protected System.Web.UI.WebControls.DataGrid DataGrid5;
		protected System.Web.UI.WebControls.Panel Pdata4;
		protected System.Web.UI.WebControls.Panel Pdata5;
		protected System.Web.UI.WebControls.DataGrid DataGrid6;
		protected System.Web.UI.WebControls.Panel Pdata6;
		protected System.Web.UI.WebControls.DataGrid DataGrid7;
		protected System.Web.UI.WebControls.DataGrid DataGrid8;
		protected System.Web.UI.WebControls.Panel Pdata7;
		protected System.Web.UI.WebControls.DataGrid DataGrid9;
		protected System.Web.UI.WebControls.Panel Pdata8;
		protected System.Web.UI.WebControls.DataGrid DataGrid10;
		protected System.Web.UI.WebControls.Panel Pdata9;
		protected System.Web.UI.WebControls.DataGrid DataGrid11;
		protected System.Web.UI.WebControls.Panel Pdata10;
		protected System.Web.UI.WebControls.DataGrid DataGrid12;
		protected System.Web.UI.WebControls.Panel Pdata11;
		protected System.Web.UI.WebControls.DataGrid DataGrid13;
		protected System.Web.UI.WebControls.Panel Pselet;
		protected System.Web.UI.WebControls.Image Image1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			this.Panel4.Visible=false;//产品标题
			this.Label2.Visible=false;//横线
			this.Image24.Visible=true;//竖图
			this.Image25.Visible=true;//横图
			this.Panel5.Visible=true;//保养
			this.Panel6.Visible=true;//维修
			if(!IsPostBack)
			{
				string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
				OleDbConnection conn=new OleDbConnection(connstr);
				conn.Open();
				string sql1="select * from 家用电器";
				string sql2="select * from 厨房电器";
				string sql3="select * from 其它电器";
				OleDbCommand comm1=new OleDbCommand(sql1,conn);
				OleDbCommand comm2=new OleDbCommand(sql2,conn);
				OleDbCommand comm3=new OleDbCommand(sql3,conn);
				OleDbDataReader mydata1=comm1.ExecuteReader();
			
				while(mydata1.Read())//家用电器
				{
					for(int i=0;i<mydata1.FieldCount;i++)
					{
						if(mydata1.GetName(i)=="一")
							this.H1.Text=mydata1.GetValue(i).ToString();
						if(mydata1.GetName(i)=="二")
							this.H2.Text=mydata1.GetValue(i).ToString();
						if(mydata1.GetName(i)=="三")
							this.H3.Text=mydata1.GetValue(i).ToString();
						if(mydata1.GetName(i)=="四")
							this.H4.Text=mydata1.GetValue(i).ToString();
						if(mydata1.GetName(i)=="五")
							this.H5.Text=mydata1.GetValue(i).ToString();
						if(mydata1.GetName(i)=="六")
							this.H6.Text=mydata1.GetValue(i).ToString();
					
					}
				}
				mydata1.Close();
				OleDbDataReader mydata2=comm2.ExecuteReader();
				while(mydata2.Read())//厨房电器
				{
					for(int i=0;i<mydata2.FieldCount;i++)
					{
						if(mydata2.GetName(i)=="一")
							this.H7.Text=mydata2.GetValue(i).ToString();
						if(mydata2.GetName(i)=="二")
							this.H8.Text=mydata2.GetValue(i).ToString();
						if(mydata2.GetName(i)=="三")
							this.H9.Text=mydata2.GetValue(i).ToString();
						if(mydata2.GetName(i)=="四")
							this.H10.Text=mydata2.GetValue(i).ToString();
						if(mydata2.GetName(i)=="五")
							this.H11.Text=mydata2.GetValue(i).ToString();
						this.H12.Visible=false;
						this.Image26.Visible=false;
					
					
					}
				}
				mydata2.Close();
				OleDbDataReader mydata3=comm3.ExecuteReader();
				while(mydata3.Read())//其它电器
				{
					for(int i=0;i<mydata3.FieldCount;i++)
					{
						if(mydata3.GetName(i)=="一")
							this.H13.Text=mydata3.GetValue(i).ToString();
						this.H14.Visible=false;
						this.H15.Visible=false;
						this.H16.Visible=false;
						this.H17.Visible=false;
						this.H18.Visible=false;
						this.Image15.Visible=false;
						this.Image14.Visible=false;
						this.Image13.Visible=false;
						this.Image12.Visible=false;
						this.Image11.Visible=false;					
					}
				}
				mydata3.Close();
				conn.Close();
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
			this.H1.Click += new System.EventHandler(this.H1_Click);
			this.H2.Click += new System.EventHandler(this.H2_Click);
			this.H3.Click += new System.EventHandler(this.H3_Click);
			this.H4.Click += new System.EventHandler(this.H4_Click);
			this.H5.Click += new System.EventHandler(this.H5_Click);
			this.H6.Click += new System.EventHandler(this.H6_Click);
			this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
			this.H7.Click += new System.EventHandler(this.H7_Click);
			this.H8.Click += new System.EventHandler(this.H8_Click);
			this.H9.Click += new System.EventHandler(this.H9_Click);
			this.H10.Click += new System.EventHandler(this.H10_Click);
			this.H11.Click += new System.EventHandler(this.H11_Click);
			this.LinkButton3.Click += new System.EventHandler(this.LinkButton3_Click);
			this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
			this.DropDownList1.PreRender += new System.EventHandler(this.DropDownList1_PreRender);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.DataGrid12.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid12_PageIndexChanged);
			this.DataGrid11.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid11_PageIndexChanged);
			this.DataGrid10.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid10_PageIndexChanged);
			this.DataGrid9.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid9_PageIndexChanged);
			this.DataGrid8.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid8_PageIndexChanged);
			this.DataGrid2.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid2_PageIndexChanged);
			this.DataGrid3.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid3_PageIndexChanged);
			this.DataGrid4.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid4_PageIndexChanged);
			this.DataGrid5.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid5_PageIndexChanged);
			this.DataGrid6.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid6_PageIndexChanged);
			this.DataGrid7.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid7_PageIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void LinkButton1_Click(object sender, System.EventArgs e)//生活类电器
		{
			this.LinkButton1.Enabled=false;
			this.LinkButton2.Enabled=true;
			this.LinkButton3.Enabled=true;
			this.P1.Visible=true;
			this.P2.Visible=false;
			this.P3.Visible=false;
			this.Label6.Visible=false;//数据不存在激活label6
			this.Label7.Visible=false;//横线

			this.Pdata1.Visible=false;//数据表格控件
			this.Pdata2.Visible=false;
			this.Pdata3.Visible=false;
			this.Pdata4.Visible=false;
			this.Pdata5.Visible=false;
			this.Pdata6.Visible=false;
			this.Pdata7.Visible=false;
			this.Pdata8.Visible=false;
			this.Pdata9.Visible=false;
			this.Pdata10.Visible=false;
			this.Pdata11.Visible=false;
			this.Pselet.Visible=false;

			this.H1.Enabled=true;//一
			this.H2.Enabled=true;//二
			this.H3.Enabled=true;//三
			this.H4.Enabled=true;//四
			this.H5.Enabled=true;//五
			this.H6.Enabled=true;//六
			this.H7.Enabled=true;
			this.H8.Enabled=true;
			this.H9.Enabled=true;
			this.H10.Enabled=true;
			this.H11.Enabled=true;
			this.H12.Enabled=true;
			this.H13.Enabled=true;
			this.H14.Enabled=true;
			this.H15.Enabled=true;
			this.H16.Enabled=true;
			this.H17.Enabled=true;
			this.H18.Enabled=true;
			this.Panel4.Visible=false;//产品标题
			this.Label2.Visible=false;//横线
			this.Image24.Visible=true;//竖图
			this.Image25.Visible=true;//横图
			this.Panel5.Visible=true;//保养
			this.Panel6.Visible=true;//维修
		}

		private void LinkButton2_Click(object sender, System.EventArgs e)//厨房类电器
		{
			this.LinkButton1.Enabled=true;
			this.LinkButton2.Enabled=false;
			this.LinkButton3.Enabled=true;
			this.P1.Visible=false;
			this.P2.Visible=true;			
			this.P3.Visible=false;
			this.Label6.Visible=false;//数据不存在激活label6
			this.Label7.Visible=false;//横线

			this.Pdata1.Visible=false;//数据表格控件
			this.Pdata2.Visible=false;
			this.Pdata3.Visible=false;
			this.Pdata4.Visible=false;
			this.Pdata5.Visible=false;
			this.Pdata6.Visible=false;
			this.Pdata7.Visible=false;
			this.Pdata8.Visible=false;
			this.Pdata9.Visible=false;
			this.Pdata10.Visible=false;
			this.Pdata11.Visible=false;
			this.Pselet.Visible=false;

			this.H1.Enabled=true;//一
			this.H2.Enabled=true;//二
			this.H3.Enabled=true;//三
			this.H4.Enabled=true;//四
			this.H5.Enabled=true;//五
			this.H6.Enabled=true;//六
			this.H7.Enabled=true;
			this.H8.Enabled=true;
			this.H9.Enabled=true;
			this.H10.Enabled=true;
			this.H11.Enabled=true;
			this.H12.Enabled=true;
			this.H13.Enabled=true;
			this.H14.Enabled=true;
			this.H15.Enabled=true;
			this.H16.Enabled=true;
			this.H17.Enabled=true;
			this.H18.Enabled=true;
			this.Panel4.Visible=false;//产品标题
			this.Label2.Visible=false;//横线
			this.Image24.Visible=true;//竖图
			this.Image25.Visible=true;//横图
			this.Panel5.Visible=true;//保养
			this.Panel6.Visible=true;//维修
		}

		private void LinkButton3_Click(object sender, System.EventArgs e)//其它类电器
		{

			this.LinkButton1.Enabled=true;
			this.LinkButton2.Enabled=true;
			this.LinkButton3.Enabled=false;
			this.P1.Visible=false;			
			this.P2.Visible=false;
			this.P3.Visible=true;
			this.Label6.Visible=false;//数据不存在激活label6
			this.Label7.Visible=false;//横线

			this.Pdata1.Visible=false;//数据表格控件
			this.Pdata2.Visible=false;
			this.Pdata3.Visible=false;