📄 select.aspx.cs
字号:
// OleDbDataAdapter adapter2=new OleDbDataAdapter(sqlstr2,conn);
// DataSet da2=new DataSet();
// adapter2.Fill(da2,""+this.QQ.SelectedIndex+"");
// for(int j=0;j<da2.Tables[""+this.QQ.SelectedIndex+""].Rows.Count;j++)
// {
// this.QQ1.Items.Add(da2.Tables[""+this.QQ.SelectedIndex+""].Rows[j][0].ToString().Trim());
// }
// string sqlstr1="select * from "+this.QQ.SelectedItem+" where 产品名称='"+this.QQ1.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();
// }
// }
// conn.Close();
this.Table4.Visible=false;
}
}
private void QQ_SelectedIndexChanged(object sender, System.EventArgs e)
{
// this.QQ1.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.QQ.SelectedItem+" where 产品名称";
// OleDbDataAdapter adapter2=new OleDbDataAdapter(sqlstr2,conn);
// DataSet da2=new DataSet();
// adapter2.Fill(da2,""+this.QQ.SelectedIndex+"");
// for(int j=0;j<da2.Tables[""+this.QQ.SelectedIndex+""].Rows.Count;j++)
// {
// this.QQ1.Items.Add(da2.Tables[""+this.QQ.SelectedIndex+""].Rows[j][0].ToString().Trim());
// }
// conn.Open();
// string sqlstr1="select * from "+this.QQ.SelectedItem+" where 产品名称='"+this.QQ1.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.TextBox13.Text=mydata.GetValue(i).ToString();
// if(mydata.GetName(i)=="产品规格")
// this.TextBox14.Text=mydata.GetValue(i).ToString();
// if(mydata.GetName(i)=="产品备注")
// this.TextBox15.Text=mydata.GetValue(i).ToString();
// if(mydata.GetName(i)=="产品类别")
// this.TextBox16.Text=mydata.GetValue(i).ToString();
// if(mydata.GetName(i)=="产品信息")
// this.TextBox17.Text=mydata.GetValue(i).ToString();
// if(mydata.GetName(i)=="数量")
// this.TextBox18.Text=mydata.GetValue(i).ToString();
// }
// }
// conn.Close();
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void QQ1_SelectedIndexChanged(object sender, System.EventArgs e)
{
// this.QQ1.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.QQ.SelectedItem+" where 产品名称";
// OleDbDataAdapter adapter2=new OleDbDataAdapter(sqlstr2,conn);
// DataSet da2=new DataSet();
// adapter2.Fill(da2,""+this.QQ.SelectedIndex+"");
// for(int j=0;j<da2.Tables[""+this.QQ.SelectedIndex+""].Rows.Count;j++)
// {
// this.QQ1.Items.Add(da2.Tables[""+this.QQ.SelectedIndex+""].Rows[j][0].ToString().Trim());
// }
// conn.Open();
// string sqlstr1="select * from "+this.QQ.SelectedItem+" where 产品名称='"+this.QQ1.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();
// }
// }
// conn.Close();
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void butt1_Click(object sender, System.EventArgs e)//添加
{
if(this.TB1.Text=="")
{
Response.Write("<script>window.alert('请填写产品名称!');</script>");
}
else if(this.TB1.Text==this.DD1.SelectedItem.ToString())
{
Response.Write("<script>window.alert('产品有重复! 请检查...');</script>");
}
else
{
string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
OleDbConnection conn=new OleDbConnection(connstr);
conn.Open();
OleDbCommand comm=new OleDbCommand();
comm.Connection=conn;
comm.CommandText="insert into "+this.DD.SelectedItem+"(产品名称,产品售价,产品规格,产品备注,产品类别,产品信息,数量) values ('"+this.TB1.Text+"','"+this.TextBox1.Text+"','"+this.TextBox2.Text+"','"+this.TextBox3.Text+"','"+this.TextBox4.Text+"','"+this.TextBox5.Text+"','"+this.TextBox6.Text+"')";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('添加成功!请单击刷新');</script>");
conn.Close();
this.TB1.Enabled=true;
this.TextBox1.Enabled=false;
this.TextBox2.Enabled=false;
this.TextBox3.Enabled=false;
this.TextBox4.Enabled=false;
this.TextBox5.Enabled=false;
this.TextBox6.Enabled=false;
this.seve1.Visible=true;//激活按钮
this.clear1.Enabled=false;
this.butt1.Enabled=false;
this.butt2.Enabled=false;
this.butt3.Enabled=false;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
}
private void butt2_Click(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();
OleDbCommand comm=new OleDbCommand();
comm.Connection=conn;
comm.CommandText="delete from "+this.DD.SelectedItem+" where 产品名称='"+this.DD1.SelectedItem+"'";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('删除成功!请单击刷新');</script>");
conn.Close();
this.TB1.Enabled=true;
this.TextBox1.Enabled=false;
this.TextBox2.Enabled=false;
this.TextBox3.Enabled=false;
this.TextBox4.Enabled=false;
this.TextBox5.Enabled=false;
this.TextBox6.Enabled=false;
this.seve1.Visible=true;//激活按钮
this.clear1.Enabled=false;
this.butt1.Enabled=false;
this.butt2.Enabled=false;
this.butt3.Enabled=false;
this.Table3.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void butt3_Click(object sender, System.EventArgs e)//修改
{
if(this.TB1.Text=="")
{
Response.Write("<script>window.alert('请填写产品名称!');</script>");
}
else if(this.TB1.Text==this.DD1.SelectedItem.ToString())
{
Response.Write("<script>window.alert('产品有重复! 请检查...');</script>");
}
else
{
string connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(@".\databast.mdb");
OleDbConnection conn=new OleDbConnection(connstr);
conn.Open();
OleDbCommand comm=new OleDbCommand();
comm.Connection=conn;
comm.CommandText="update "+this.DD.SelectedItem+" set 产品名称='"+this.TB1.Text+"',产品售价='"+this.TextBox1.Text+"',产品规格='"+this.TextBox2.Text+"',产品备注='"+this.TextBox3.Text+"',产品类别='"+this.TextBox4.Text+"',产品信息='"+this.TextBox5.Text+"',数量='"+this.TextBox6.Text+"' where 产品名称='"+this.DD1.SelectedItem+"'";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('修改成功!请单击刷新');</script>");
conn.Close();
this.TB1.Enabled=true;
this.TextBox1.Enabled=false;
this.TextBox2.Enabled=false;
this.TextBox3.Enabled=false;
this.TextBox4.Enabled=false;
this.TextBox5.Enabled=false;
this.TextBox6.Enabled=false;
this.seve1.Visible=true;//激活按钮
this.clear1.Enabled=false;
this.butt1.Enabled=false;
this.butt2.Enabled=false;
this.butt3.Enabled=false;
this.Table3.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
}
private void butt4_Click(object sender, System.EventArgs e)//返回
{
Response.Redirect("cpinex.aspx");
}
private void seve1_Click(object sender, System.EventArgs e)//激活
{
this.TB1.Enabled=true;
this.TextBox1.Enabled=true;
this.TextBox2.Enabled=true;
this.TextBox3.Enabled=true;
this.TextBox4.Enabled=true;
this.TextBox5.Enabled=true;
this.TextBox6.Enabled=true;
this.seve1.Visible=false;//激活按钮
this.clear1.Enabled=true;
this.butt1.Enabled=true;
this.butt2.Enabled=true;
this.butt3.Enabled=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void clear1_Click(object sender, System.EventArgs e)
{
this.TB1.Text="";
this.TextBox1.Text="";
this.TextBox2.Text="";
this.TextBox3.Text="";
this.TextBox4.Text="";
this.TextBox5.Text="";
this.TextBox6.Text="";
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void LinkButton4_Click(object sender, System.EventArgs e)//生活商品
{
if(this.L2.Text=="会员")
{
this.Table1.Visible=false;
this.Table3.Visible=true;
this.Panel9.Visible=false;//登陆对话框
this.Panel10.Visible=true;
}
else if(this.L2.Text=="管理员")
{
this.Table1.Visible=false;
this.Table3.Visible=true;
this.Panel9.Visible=false;//登陆对话框
this.Panel10.Visible=true;
}
else
{
Response.Write("<script>window.alert('您还未登陆？');</script>");
this.Panel9.Visible=true;//登陆对话框
this.Panel10.Visible=false;
}
}
private void LinkButton5_Click(object sender, System.EventArgs e)//厨房商品
{
if(this.L2.Text=="会员")
{
this.Table1.Visible=false;
this.Table2.Visible=true;
this.Panel9.Visible=false;//登陆对话框
this.Panel10.Visible=true;
}
else if(this.L2.Text=="管理员")
{
this.Table1.Visible=false;
this.Table2.Visible=true;
this.Panel9.Visible=false;//登陆对话框
this.Panel10.Visible=true;
}
else
{
Response.Write("<script>window.alert('您还未登陆？');</script>");
this.Panel9.Visible=true;//登陆对话框
this.Panel10.Visible=false;
}
}
private void LinkButton6_Click(object sender, System.EventArgs e)//其它商品
{
if(this.L2.Text=="会员")
{
this.Table1.Visible=false;
this.Table4.Visible=true;
this.Panel9.Visible=false;//登陆对话框
this.Panel10.Visible=true;
}
else if(this.L2.Text=="管理员")
{
this.Table1.Visible=false;
this.Table2.Visible=true;
this.Panel9.Visible=false;//登陆对话框
this.Panel10.Visible=true;
}
else
{
Response.Write("<script>window.alert('您还未登陆？');</script>");
this.Panel9.Visible=true;//登陆对话框
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -