private void button1_Click(object sender, EventArgs e)
{
shangping s = new shangping();
s.Show();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
String sql = "insert into commodity(cno,bname,tname,cname,gg,xh,jldw,scj,xsj,cbj,slt,js,kc) values (@cno,@bname,@tname,@cname,@gg,@xh,@jldw,@scj,@xsj,@cbj,@slt,@js,@kc)";
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@cno", int.Parse(cno.Text)));
cmd.Parameters.Add(new SqlParameter("@bname", comboBox1.Text));
cmd.Parameters.Add(new SqlParameter("@tname", comboBox2.Text));
cmd.Parameters.Add(new SqlParameter("@cname", cname.Text));
cmd.Parameters.Add(new SqlParameter("@gg", gg.Text));
cmd.Parameters.Add(new SqlParameter("@xh", xh.Text));
cmd.Parameters.Add(new SqlParameter("@jldw", jldw.Text));
cmd.Parameters.Add(new SqlParameter("@scj", scj.Text));
cmd.Parameters.Add(new SqlParameter("@xsj", xsj.Text));
cmd.Parameters.Add(new SqlParameter("@cbj", cbj.Text));
cmd.Parameters.Add(new SqlParameter("@slt", slt.Text));
cmd.Parameters.Add(new SqlParameter("@js", js.Text));
cmd.Parameters.Add(new SqlParameter("@kc", kc.Text));
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("信息录入成功");
shangping sp = new shangping();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString() + "请检查数据合法性！");
}
}
private void button1_Click(object sender, EventArgs e)
{
String c_no = cno.Text.Trim();
String b_name = bname.Text.Trim();
String t_name = tname.Text.Trim();
String c_name = cname.Text.Trim();
String c_js = js.Text.Trim();
String c_slt = slt.Text.Trim();
String c_gg = gg.Text.Trim();
String c_xh = xh.Text.Trim();
String c_jldw = jldw.Text.Trim();
String c_scj = scj.Text.Trim();
String c_xsj = xsj.Text.Trim();
String c_cbj = cbj.Text.Trim();
String c_kc = kc.Text.Trim();
String sql = string.Format("update commodity set bname='{0}',tname='{1}',cname='{2}',gg='{3}',xh='{4}',jldw='{5}',scj='{6}',xsj='{7}',cbj='{8}',slt='{9}',js='{10}',kc='{11}' where cno='{12}'", b_name, t_name, c_name, c_gg, c_xh, c_jldw, c_scj, c_xsj, c_cbj, c_slt, c_js, c_kc, c_no);
try
{
cmd = new SqlCommand(sql, conn);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
MessageBox.Show("信息修改成功");
shangping sp = new shangping();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString() + "请检查数据合法性！");
}
}
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
//打开数据库的连接
String sql = "select * from users where user_id = @user_id and user_psw = @user_psw ";
//创建数据库的操作字符串
SqlCommand cmd = new SqlCommand(sql, conn);
//对指定的对象，操作字符串内容
cmd.Parameters.Add(new SqlParameter("@user_id", textBox1.Text));
//用参数代替占位符，线性更安全
cmd.Parameters.Add(new SqlParameter("@user_psw", textBox2.Text));
SqlDataReader reader = cmd.ExecuteReader();//操作
if (reader.Read())
{
//如果查询到内容，跳转到Information界面，同时关闭当前界面
shangping sp = new shangping();
sp.Show();
this.Hide();
}
else
{
//MessageBox.Show("请输入正确信息！");
//textBox1.Text = "";
//textBox2.Text = "";
main m = new main();
m.Show();
this.Hide();
}
}
}
