⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 select.aspx.cs

📁 主要功能： 1、 包括顾客信息、货品信息、定单信息的管理。 2、 按月统计销售业绩。 3、 报表设计。 4、 系统维护。
💻 CS
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
			string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
			OleDbConnection conn=new OleDbConnection(connstr);
			conn.Open();			
			string sql="update 厨房电器 set 一='"+this.T7.Text+"',二='"+this.T8.Text+"',三='"+this.T9.Text+"',四='"+this.T10.Text+"',五='"+this.T11.Text+"',六='"+this.T12.Text+"'";
			OleDbCommand comm=new OleDbCommand(sql,conn);
			comm.ExecuteNonQuery();
			Response.Write("<script>window.alert('修改成功,管理员请到数据库更改相关表格!');</script>");	
			this.Panel10.Visible=true;//登陆窗口
			this.Panel9.Visible=false;
			
		
		}

		private void Button9_Click(object sender, System.EventArgs e)
		{
			if(this.T13.Text=="")
			{
				this.T13.Text=this.H13.Text;		
			}
			if(this.T14.Text=="")
			{
				this.T14.Text=this.H14.Text;	
			}
			if(this.T15.Text=="")
			{
				this.T15.Text=this.H15.Text;		
			}
			if(this.T16.Text=="")
			{
				this.T16.Text=this.H16.Text;		
			}
			if(this.T17.Text=="")
			{
				this.T17.Text=this.H17.Text;		
			}
			if(this.T18.Text=="")
			{
				this.T18.Text=this.H18.Text;		
			}
			string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
			OleDbConnection conn=new OleDbConnection(connstr);
			conn.Open();			
			string sql="update 其它电器 set 一='"+this.T13.Text+"',二='"+this.T14.Text+"',三='"+this.T15.Text+"',四='"+this.T16.Text+"',五='"+this.T17.Text+"',六='"+this.T18.Text+"'";
			OleDbCommand comm=new OleDbCommand(sql,conn);
			comm.ExecuteNonQuery();
			Response.Write("<script>window.alert('修改成功,管理员请到数据库更改相关表格!');</script>");		
			this.Panel10.Visible=true;//登陆窗口
			this.Panel9.Visible=false;
				
		}
		
		private void DD_PreRender(object sender, System.EventArgs e)//生活类页面加载时
		{
			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 家用电器";
				OleDbCommand comm1=new OleDbCommand(sql1,conn);
				OleDbDataReader mydata1=comm1.ExecuteReader();
				while(mydata1.Read())//家用电器
				{
					for(int i=0;i<mydata1.FieldCount;i++)
					{
						this.DD.Items.Add(mydata1.GetValue(i).ToString());
					}
				}
				mydata1.Close();
				string sqlstr2="select 产品名称 from "+this.DD.SelectedItem+" where 产品名称";
				OleDbDataAdapter adapter2=new OleDbDataAdapter(sqlstr2,conn);
				DataSet da2=new DataSet();
				adapter2.Fill(da2,""+this.DD.SelectedIndex+"");
				for(int j=0;j<da2.Tables[""+this.DD.SelectedIndex+""].Rows.Count;j++)
				{
					this.DD1.Items.Add(da2.Tables[""+this.DD.SelectedIndex+""].Rows[j][0].ToString().Trim());
				}
				string sqlstr1="select * from  "+this.DD.SelectedItem+" where 产品名称='"+this.DD1.SelectedItem+"'";
				OleDbCommand comm=new OleDbCommand(sqlstr1,conn);
				OleDbDataReader mydata=comm.ExecuteReader();
				while(mydata.Read())
				{
					for(int i=1;i<mydata.FieldCount;i++)
					{
						if(mydata.GetName(i)=="产品售价")
							this.TextBox1.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品规格")
							this.TextBox2.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品备注")
							this.TextBox3.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品类别")
							this.TextBox4.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品信息")
							this.TextBox5.Text=mydata.GetValue(i).ToString();	
						if(mydata.GetName(i)=="数量")
							this.TextBox6.Text=mydata.GetValue(i).ToString();
					}
				}
				conn.Close();
				this.TB1.Text=this.DD1.SelectedItem.ToString();
				this.L1.Text=Request.QueryString["name"];//让传递来的参数执行一次
				this.L2.Text=Request.QueryString["age"];
				this.Table3.Visible=false;
			}		
		}
		private void DD_SelectedIndexChanged(object sender, System.EventArgs e)//生活类页面加载时
		{
			this.DD1.Items.Clear();//清除之前记录
			string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
			OleDbConnection conn=new OleDbConnection(connstr);
			string sqlstr2="select 产品名称 from "+this.DD.SelectedItem+" where 产品名称";
			OleDbDataAdapter adapter2=new OleDbDataAdapter(sqlstr2,conn);
			DataSet da2=new DataSet();
			adapter2.Fill(da2,""+this.DD.SelectedIndex+"");
			for(int j=0;j<da2.Tables[""+this.DD.SelectedIndex+""].Rows.Count;j++)
			{
				this.DD1.Items.Add(da2.Tables[""+this.DD.SelectedIndex+""].Rows[j][0].ToString().Trim());
			}	
			conn.Open();
			string sqlstr1="select * from "+this.DD.SelectedItem+" where 产品名称='"+this.DD1.SelectedItem+"'";
			OleDbCommand comm=new OleDbCommand(sqlstr1,conn);
			OleDbDataReader mydata=comm.ExecuteReader();
			while(mydata.Read())
			{
				for(int i=0;i<mydata.FieldCount;i++)
				{
					if(mydata.GetName(i)=="产品售价")
						this.TextBox1.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品规格")
						this.TextBox2.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品备注")
						this.TextBox3.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品类别")
						this.TextBox4.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品信息")
						this.TextBox5.Text=mydata.GetValue(i).ToString();	
					if(mydata.GetName(i)=="数量")
						this.TextBox6.Text=mydata.GetValue(i).ToString();
				}
			}
			this.TB1.Text=this.DD1.SelectedItem.ToString();
			this.Panel10.Visible=true;//登陆窗口
			this.Panel9.Visible=false;
			conn.Close();
	
		}
		private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)//生活类页面加载时
		{
			string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
			OleDbConnection conn=new OleDbConnection(connstr);
			conn.Open();
			string sqlstr1="select * from "+this.DD.SelectedItem+" where 产品名称='"+this.DD1.SelectedItem+"'";
			OleDbCommand comm=new OleDbCommand(sqlstr1,conn);
			OleDbDataReader mydata=comm.ExecuteReader();
			while(mydata.Read())
			{
				for(int i=0;i<mydata.FieldCount;i++)
				{
					if(mydata.GetName(i)=="产品售价")
						this.TextBox1.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品规格")
						this.TextBox2.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品备注")
						this.TextBox3.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品类别")
						this.TextBox4.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品信息")
						this.TextBox5.Text=mydata.GetValue(i).ToString();	
					if(mydata.GetName(i)=="数量")
						this.TextBox6.Text=mydata.GetValue(i).ToString();
				}
			}
			this.TB1.Text=this.DD1.SelectedItem.ToString();
			this.Panel10.Visible=true;//登陆窗口
			this.Panel9.Visible=false;
			conn.Close();		
		}

		private void PP_PreRender(object sender, System.EventArgs e)//厨房类加载
		{
			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 厨房电器";
				OleDbCommand comm1=new OleDbCommand(sql1,conn);
				OleDbDataReader mydata1=comm1.ExecuteReader();
				while(mydata1.Read())//厨房电器
				{
					for(int i=0;i<mydata1.FieldCount;i++)
					{
						this.PP.Items.Add(mydata1.GetValue(i).ToString());
					}
				}
				mydata1.Close();
				string sqlstr2="select 产品名称 from "+this.PP.SelectedItem+" where 产品名称";
				OleDbDataAdapter adapter2=new OleDbDataAdapter(sqlstr2,conn);
				DataSet da2=new DataSet();
				adapter2.Fill(da2,""+this.PP.SelectedIndex+"");
				for(int j=0;j<da2.Tables[""+this.PP.SelectedIndex+""].Rows.Count;j++)
				{
					this.PP1.Items.Add(da2.Tables[""+this.PP.SelectedIndex+""].Rows[j][0].ToString().Trim());
				}
				string sqlstr1="select * from  "+this.PP.SelectedItem+" where 产品名称='"+this.PP1.SelectedItem+"'";
				OleDbCommand comm=new OleDbCommand(sqlstr1,conn);
				OleDbDataReader mydata=comm.ExecuteReader();
				while(mydata.Read())
				{
					for(int i=1;i<mydata.FieldCount;i++)
					{
						if(mydata.GetName(i)=="产品售价")
							this.TextBox7.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品规格")
							this.TextBox8.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品备注")
							this.TextBox9.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品类别")
							this.TextBox10.Text=mydata.GetValue(i).ToString();
						if(mydata.GetName(i)=="产品信息")
							this.TextBox11.Text=mydata.GetValue(i).ToString();	
						if(mydata.GetName(i)=="数量")
							this.TextBox12.Text=mydata.GetValue(i).ToString();
					}
				}
				this.TB2.Text=this.PP1.SelectedItem.ToString();
				conn.Close();	
				this.Table2.Visible=false;
			}
		}

		private void PP_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.PP1.Items.Clear();//清除之前记录
			string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
			OleDbConnection conn=new OleDbConnection(connstr);
			string sqlstr2="select 产品名称 from "+this.PP.SelectedItem+" where 产品名称";
			OleDbDataAdapter adapter2=new OleDbDataAdapter(sqlstr2,conn);
			DataSet da2=new DataSet();
			adapter2.Fill(da2,""+this.PP.SelectedIndex+"");
			for(int j=0;j<da2.Tables[""+this.PP.SelectedIndex+""].Rows.Count;j++)
			{
				this.PP1.Items.Add(da2.Tables[""+this.PP.SelectedIndex+""].Rows[j][0].ToString().Trim());
			}	
			conn.Open();
			string sqlstr1="select * from "+this.PP.SelectedItem+" where 产品名称='"+this.PP1.SelectedItem+"'";
			OleDbCommand comm=new OleDbCommand(sqlstr1,conn);
			OleDbDataReader mydata=comm.ExecuteReader();
			while(mydata.Read())
			{
				for(int i=0;i<mydata.FieldCount;i++)
				{
					if(mydata.GetName(i)=="产品售价")
						this.TextBox7.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品规格")
						this.TextBox8.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品备注")
						this.TextBox9.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品类别")
						this.TextBox10.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品信息")
						this.TextBox11.Text=mydata.GetValue(i).ToString();	
					if(mydata.GetName(i)=="数量")
						this.TextBox12.Text=mydata.GetValue(i).ToString();
				}
			}
			this.TB2.Text=this.PP1.SelectedItem.ToString();
			this.Panel10.Visible=true;//登陆窗口
			this.Panel9.Visible=false;
			conn.Close();		
		}

		private void PP1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
			OleDbConnection conn=new OleDbConnection(connstr);
			conn.Open();
			string sqlstr1="select * from "+this.PP.SelectedItem+" where 产品名称='"+this.PP1.SelectedItem+"'";
			OleDbCommand comm=new OleDbCommand(sqlstr1,conn);
			OleDbDataReader mydata=comm.ExecuteReader();
			while(mydata.Read())
			{
				for(int i=0;i<mydata.FieldCount;i++)
				{
					if(mydata.GetName(i)=="产品售价")
						this.TextBox7.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品规格")
						this.TextBox8.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品备注")
						this.TextBox9.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品类别")
						this.TextBox10.Text=mydata.GetValue(i).ToString();
					if(mydata.GetName(i)=="产品信息")
						this.TextBox11.Text=mydata.GetValue(i).ToString();	
					if(mydata.GetName(i)=="数量")
						this.TextBox12.Text=mydata.GetValue(i).ToString();
				}
			}
			this.TB2.Text=this.PP1.SelectedItem.ToString();
			this.Panel10.Visible=true;//登陆窗口
			this.Panel9.Visible=false;
			conn.Close();		
		}

		private void QQ_PreRender(object sender, System.EventArgs e)//其它类电器
		{
			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 其它电器";
				OleDbCommand comm1=new OleDbCommand(sql1,conn);
				OleDbDataReader mydata1=comm1.ExecuteReader();
				while(mydata1.Read())//其它电器
				{
					for(int i=0;i<mydata1.FieldCount;i++)
					{
						this.QQ.Items.Add(mydata1.GetValue(i).ToString());
					}
				}
//				mydata1.Close();
//				string sqlstr2="select 产品名称 from "+this.QQ.SelectedItem+" where 产品名称";
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -