📄 select.aspx.cs
字号:
this.Panel10.Visible=false;
}
}
private void seve3_Click(object sender, System.EventArgs e)//激活
{
this.TB3.Enabled=true;
this.TextBox13.Enabled=true;
this.TextBox14.Enabled=true;
this.TextBox15.Enabled=true;
this.TextBox16.Enabled=true;
this.TextBox17.Enabled=true;
this.TextBox18.Enabled=true;
this.seve3.Visible=false;//激活按钮
this.clear3.Enabled=true;
this.butt9.Enabled=true;
this.butt10.Enabled=true;
this.butt11.Enabled=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void Button10_Click(object sender, System.EventArgs e)//清空
{
this.TB3.Text="";
this.TextBox13.Text="";
this.TextBox14.Text="";
this.TextBox15.Text="";
this.TextBox16.Text="";
this.TextBox17.Text="";
this.TextBox18.Text="";
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void butt9_Click(object sender, System.EventArgs e)//添加
{
if(this.TB3.Text=="")
{
Response.Write("<script>window.alert('请填写产品名称!');</script>");
}
else if(this.TB3.Text==this.QQ1.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.QQ.SelectedItem+"(产品名称,产品售价,产品规格,产品备注,产品类别,产品信息,数量) values ('"+this.TB3.Text+"','"+this.TextBox13.Text+"','"+this.TextBox14.Text+"','"+this.TextBox15.Text+"','"+this.TextBox16.Text+"','"+this.TextBox17.Text+"','"+this.TextBox18.Text+"')";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('添加成功!请单击刷新');</script>");
conn.Close();
this.TB3.Enabled=false;
this.TextBox13.Enabled=false;
this.TextBox14.Enabled=false;
this.TextBox15.Enabled=false;
this.TextBox16.Enabled=false;
this.TextBox17.Enabled=false;
this.TextBox18.Enabled=false;
this.seve3.Visible=true;//激活按钮
this.clear3.Enabled=false;
this.butt9.Enabled=false;
this.butt10.Enabled=false;
this.butt11.Enabled=false;
this.Table2.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
}
private void butt10_Click(object sender, System.EventArgs e)
{
if(this.TB3.Text=="")
{
Response.Write("<script>window.alert('请填写产品名称!');</script>");
}
else if(this.TB3.Text==this.QQ1.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.QQ.SelectedItem+" set 产品名称='"+this.TB3.Text+"',产品售价='"+this.TextBox13.Text+"',产品规格='"+this.TextBox14.Text+"',产品备注='"+this.TextBox15.Text+"',产品类别='"+this.TextBox16.Text+"',产品信息='"+this.TextBox17.Text+"',数量='"+this.TextBox18.Text+"' where 产品名称='"+this.QQ1.SelectedItem+"'";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('修改成功!请单击刷新');</script>");
conn.Close();
this.TB3.Enabled=false;
this.TextBox13.Enabled=false;
this.TextBox14.Enabled=false;
this.TextBox15.Enabled=false;
this.TextBox16.Enabled=false;
this.TextBox17.Enabled=false;
this.TextBox18.Enabled=false;
this.seve3.Visible=true;//激活按钮
this.clear3.Enabled=false;
this.butt9.Enabled=false;
this.butt10.Enabled=false;
this.butt11.Enabled=false;
this.Table2.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
}
private void butt11_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.QQ.SelectedItem+" where 产品名称='"+this.QQ1.SelectedItem+"'";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('删除成功!请单击刷新');</script>");
conn.Close();
this.TB3.Enabled=false;
this.TextBox13.Enabled=false;
this.TextBox14.Enabled=false;
this.TextBox15.Enabled=false;
this.TextBox16.Enabled=false;
this.TextBox17.Enabled=false;
this.TextBox18.Enabled=false;
this.seve3.Visible=true;//激活按钮
this.clear3.Enabled=false;
this.butt9.Enabled=false;
this.butt10.Enabled=false;
this.butt11.Enabled=false;
this.Table2.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void butt12_Click(object sender, System.EventArgs e)//返回
{
Response.Redirect("cpinex.aspx");
}
private void seve2_Click(object sender, System.EventArgs e)///////////激活
{
this.TB2.Enabled=true;
this.TextBox7.Enabled=true;
this.TextBox8.Enabled=true;
this.TextBox9.Enabled=true;
this.TextBox10.Enabled=true;
this.TextBox11.Enabled=true;
this.TextBox12.Enabled=true;
this.seve2.Visible=false;//激活按钮
this.clear2.Enabled=true;
this.butt5.Enabled=true;
this.butt6.Enabled=true;
this.butt7.Enabled=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void clear2_Click(object sender, System.EventArgs e)//清空
{
this.TB2.Text="";
this.TextBox7.Text="";
this.TextBox8.Text="";
this.TextBox9.Text="";
this.TextBox10.Text="";
this.TextBox11.Text="";
this.TextBox12.Text="";
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void butt5_Click(object sender, System.EventArgs e)//添加
{
if(this.TB2.Text=="")
{
Response.Write("<script>window.alert('请填写产品名称!');</script>");
}
else if(this.TB2.Text==this.PP1.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.PP.SelectedItem+"(产品名称,产品售价,产品规格,产品备注,产品类别,产品信息,数量) values ('"+this.TB2.Text+"','"+this.TextBox7.Text+"','"+this.TextBox8.Text+"','"+this.TextBox9.Text+"','"+this.TextBox10.Text+"','"+this.TextBox11.Text+"','"+this.TextBox12.Text+"')";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('添加成功!请单击刷新');</script>");
conn.Close();
this.TB2.Enabled=false;
this.TextBox7.Enabled=false;
this.TextBox8.Enabled=false;
this.TextBox9.Enabled=false;
this.TextBox10.Enabled=false;
this.TextBox11.Enabled=false;
this.TextBox12.Enabled=false;
this.seve2.Visible=true;//激活按钮
this.clear2.Enabled=false;
this.butt5.Enabled=false;
this.butt6.Enabled=false;
this.butt7.Enabled=false;
this.Table4.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
}
private void butt6_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.PP.SelectedItem+" where 产品名称='"+this.PP1.SelectedItem+"'";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('删除成功!请单击刷新');</script>");
conn.Close();
this.TB2.Enabled=false;
this.TextBox7.Enabled=false;
this.TextBox8.Enabled=false;
this.TextBox9.Enabled=false;
this.TextBox10.Enabled=false;
this.TextBox11.Enabled=false;
this.TextBox12.Enabled=false;
this.seve2.Visible=true;//激活按钮
this.clear2.Enabled=false;
this.butt5.Enabled=false;
this.butt6.Enabled=false;
this.butt7.Enabled=false;
this.Table4.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void butt7_Click(object sender, System.EventArgs e)//修改
{
if(this.TB2.Text=="")
{
Response.Write("<script>window.alert('请填写产品名称!');</script>");
}
else if(this.TB2.Text==this.PP1.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.PP.SelectedItem+" set 产品名称='"+this.TB2.Text+"',产品售价='"+this.TextBox7.Text+"',产品规格='"+this.TextBox8.Text+"',产品备注='"+this.TextBox9.Text+"',产品类别='"+this.TextBox10.Text+"',产品信息='"+this.TextBox11.Text+"',数量='"+this.TextBox12.Text+"' where 产品名称='"+this.PP1.SelectedItem+"'";
comm.ExecuteNonQuery();
Response.Write("<script>window.alert('修改成功!请单击刷新');</script>");
conn.Close();
}
this.TB2.Enabled=false;
this.TextBox7.Enabled=false;
this.TextBox8.Enabled=false;
this.TextBox9.Enabled=false;
this.TextBox10.Enabled=false;
this.TextBox11.Enabled=false;
this.TextBox12.Enabled=false;
this.seve2.Visible=true;//激活按钮
this.clear2.Enabled=false;
this.butt5.Enabled=false;
this.butt6.Enabled=false;
this.butt7.Enabled=false;
this.Table4.Visible=true;
this.Panel10.Visible=true;//登陆窗口
this.Panel9.Visible=false;
}
private void butt8_Click(object sender, System.EventArgs e)//返回
{
Response.Redirect("cpinex.aspx");
}
private void LinkButton7_Click(object sender, System.EventArgs e)//信息管理
{
if(this.L2.Text=="会员")
{
this.Table5.Visible=true;
this.Table1.Visible=false;
this.Panel9.Visible=false;//登陆对话框
this.Panel10.Visible=true;
}
if(this.L2.Text=="管理员")
{
this.Table5.Visible=true;
this.Table1.Visible=false;
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 DropDownList1_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();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -