TuiHuBill(销售单号,汽车名称,仓库名称,销售单价,数量,日期,经手人,备注) values({0},'{1}','{2}',{3},{4},'{5}','{6}','{7}')\
int.Parse(txtXID.Text.Trim()), txtXName.Text.Trim(), cmbXCKName.Text.Trim(), int.Parse(mskXDanJia.Text.Trim()),
SqlCommand DAHelper.connetion);
DAHelper.connetion.Open();
int RowCount1 = cmd.ExecuteNonQuery(); if (RowCount1 > 0) {
MessageBox.Show(\退货成功！\ DAHelper.connetion.Close(); Date(); } else {
MessageBox.Show(\退货失败!\ } } else {
DAHelper.connetion.Close(); //下面是将下面的数据添加到数据库中 //向数据库中添加语句 string
sql
=
string.Format(\
into
TuiHuBill(销售单号,汽车名称,仓库名称,销售单价,数量,日期,经手人,备注) values({0},'{1}','{2}',{3},{4},'{5}','{6}','{7}')\
int.Parse(txtXID.Text.Trim()), txtXName.Text.Trim(), cmbXCKName.Text.Trim(), int.Parse(mskXDanJia.Text.Trim()),
SqlCommand DAHelper.connetion);
DAHelper.connetion.Open();
int RowCount1 = cmd.ExecuteNonQuery();
33
int.Parse(nuXShuLiang.Text.Trim()), cmd
=
new
SqlCommand(sql,
dateXTimeR.Text.Trim(), txtXJinShouRen.Text.Trim(), txtXBZ1.Text.Trim());
int.Parse(nuXShuLiang.Text.Trim()), cmd
=
new
SqlCommand(sql,
dateXTimeR.Text.Trim(), txtXJinShouRen.Text.Trim(), txtXBZ1.Text.Trim());
if (RowCount1 > 0) {
MessageBox.Show(\退货成功，但在仓库中没有相关的车辆信息！\
DAHelper.connetion.Close(); Date(); } else {
MessageBox.Show(\退货成功，但在仓库中没有相关的车辆信息！\
}
DAHelper.connetion.Close(); } } } }
确认删除部分代码：
private void butdeleq_Click(object sender, EventArgs e) {
butend.Enabled = true;//退货可用
DialogResult res = MessageBox.Show(\你确定要删除吗？\删除项目\
if (res == DialogResult.OK) {
string sql = string.Format(\from XiaoShouBill where 销售单号={0}\
SqlCommand cmd = new SqlCommand(sql, DAHelper.connetion); DAHelper.connetion.Open();
int RowCount = cmd.ExecuteNonQuery(); if (RowCount > 0) {
MessageBox.Show(\删除成功！\ DAHelper.connetion.Close(); DateDaoRu();//销售表中的数据
34
} else {
MessageBox.Show(\删除失败!\ } } } 库存修改界面：
在该页面中主要update密令来实现修改功能。
图4-5库存修改界面设计
库存修改界面部分代码：
private void button2_Click(object sender, EventArgs e) {
butedit.Enabled = true; DAHelper.connetion.Close();
string sql1 = \仓库名称 ='\cmbCKName.Text.Trim() + \
SqlCommand cmd1 = new SqlCommand(sql1, DAHelper.connetion); DAHelper.connetion.Open();
SqlDataReader reader1 = cmd1.ExecuteReader(); if (reader1.Read()) {
MessageBox.Show(\仓库中已经有该入仓库号！请您重新命名。
35
\温馨提示：\
button2.Enabled = false; cmbCKName.Enabled = false; nuShuLiang.Enabled = true; DAHelper.connetion.Close(); } else {
DAHelper.connetion.Close();//关闭数据源
//首先要查询一下在仓库表中有没有相同名称和相同仓库的汽车，如果有就只改变它的数量，如果没有就添加一条新的记录
string sql4 = \汽车名称='\+ txtCarName1.Text + \仓库名称='\
SqlCommand DAHelper.connetion);
DAHelper.connetion.Open();
SqlDataReader reader4 = cmd1.ExecuteReader(); if (reader4.Read()) {
int s = int.Parse(reader1[\数量\获取数据库原来的数量
DAHelper.connetion.Close();//关闭数据源
//如果记录中存在有相同名称的汽车，那么就在它的的数量上进行相应的增加
int r = int.Parse(nuShuLiang.Text);//现在要添加的数量
int sum = s + r;
string sql2 = string.Format(\数量={0} where 汽车名称='{1}'and 仓库名称='{2}'\sum, txtCarName1.Text.ToString().Trim(), cmbCKName.Text.Trim());
SqlCommand DAHelper.connetion);
//如果修改成功了，就把当前的记录删除
string sql3 = string.Format(\from KuCunBill where 入库单号='{0}'\
36
cmd4 = new SqlCommand(sql4,
cmd2 = new SqlCommand(sql2,
SqlCommand DAHelper.connetion);
cmd3 = new SqlCommand(sql3,
DAHelper.connetion.Open();
int RowCount1 = cmd3.ExecuteNonQuery(); int RowCount = cmd2.ExecuteNonQuery(); if (RowCount > 0) {
MessageBox.Show(\仓库中还有该汽车，已修改成功！\
nuShuLiang.Enabled = true; DAHelper.connetion.Close();
Date();//将数据库中内容显示在dataGridView1中 DAHelper.connetion.Close(); } else {
MessageBox.Show(\仓库中还有该汽车，修改失败！\ nuShuLiang.Enabled = true; }
DAHelper.connetion.Close();//关闭数据源 } else {
DAHelper.connetion.Close();//关闭数据源 //修改语句
string sql = string.Format(\入库单号='{0}',仓库名称='{1}',汽车名称='{2}',数量={3},保修期='{4}',供应商名称='{5}',备注='{6}'where 入库单号='{7}'\txtID.Text.Trim(), cmbCKName.Text.Trim(),
int.Parse(nuShuLiang.Text.Trim()),
SqlCommand DAHelper.connetion);
DAHelper.connetion.Open();
int RowCount = cmd.ExecuteNonQuery();
37
txtCarName1.Text.Trim(), txtBaoXiu.Text.Trim(),
cmd
=
new
SqlCommand(sql,
txtGongYing.Text.Trim(), txtBZ1.Text.Trim(), txtID.Text.Trim());