private void button1_Click(object sender, EventArgs e)
{
String c_no = cno.Text.Trim();
String o_ono = ono.Text.Trim();
String o_khxm = khxm.Text.Trim();
String o_khsj = khsj.Text.Trim();
String o_khdz = khdz.Text.Trim();
String o_yb = yb.Text.Trim();
String o_dgsj = dgsj.Value.ToString("yyyy-MM-dd HH:mm:ss");
String o_dgsl = dgsl.Text.Trim();
String o_dj = dj.Text.Trim();
String o_dgzje = dgzje.Text.Trim();
String sql = string.Format("update [order] set ono='{0}',cno='{1}',khxm='{2}',khsj='{3}',khdz='{4}',yb='{5}',dgsj='{6}',dgsl='{7}',dj='{8}',dgzje='{9}' where ono='{10}'", o_ono, c_no, o_khxm, o_khsj, o_khdz, o_yb, o_dgsj, o_dgsl, o_dj, o_dgzje, oid);
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)
{
conn.Open();
String sql = "insert into [order](ono,cno,khxm,khsj,khdz,yb,dgsj,dgsl,dj,dgzje) values (@ono,@cno,@khxm,@khsj,@khdz,@yb,@dgsj,@dgsl,@dj,@dgzje)";
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@ono", int.Parse(ono.Text)));
cmd.Parameters.Add(new SqlParameter("@cno", int.Parse(cno.Text)));
cmd.Parameters.Add(new SqlParameter("@khxm", khxm.Text));
cmd.Parameters.Add(new SqlParameter("@khsj", khsj.Text));
cmd.Parameters.Add(new SqlParameter("@khdz", khdz.Text));
cmd.Parameters.Add(new SqlParameter("@yb", yb.Text));
cmd.Parameters.Add(new SqlParameter("@dgsj", DateTime.Parse(dgsj.Text)));
cmd.Parameters.Add(new SqlParameter("@dgsl", dgsl.Text));
cmd.Parameters.Add(new SqlParameter("@dj", dj.Text));
cmd.Parameters.Add(new SqlParameter("@dgzje", dgzje.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)
{
conn.Open();
String sql = "insert into Supplier(sname,contacts,phone,synopsis) values (@sname,@contacts,@phone,@synopsis)";
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@sname", sname.Text));
cmd.Parameters.Add(new SqlParameter("@contacts", contacts.Text));
cmd.Parameters.Add(new SqlParameter("@phone", phone.Text));
cmd.Parameters.Add(new SqlParameter("@synopsis", synopsis.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 t_name = tname.Text.Trim();
String t_picture = tpicture.Text.Trim();
String sql = string.Format("update type set tname='{0}',tpicture='{1}' where tname='{2}'", t_name, t_picture, name);
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)
{
conn.Open();
String sql = "insert into type(tname,tpicture) values (@tname,@tpicture)";
try
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@tname", tname.Text));
cmd.Parameters.Add(new SqlParameter("@tpicture", tpicture.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 s_name = sname.Text.Trim();
String s_contacts = contacts.Text.Trim();
String s_phone = phone.Text.Trim();
String s_synopsis = synopsis.Text.Trim();
String sql = string.Format("update Supplier set sname='{0}',contacts='{1}',phone='{2}',synopsis='{3}' where sname='{4}'", s_name, s_contacts, s_phone, s_synopsis, name);
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() + "请检查数据合法性！");
}
}
