public void xg(DataGridView dg, spxx l, int row) { bool t = true; DataTable dt = new DataTable(); dt = sjk.Select("SELECT xh FROM sp where zt=1"); sjk.AddParameters("@yxh", SqlDbType.VarChar, dt.Rows[row][0]); sjk.AddParameters("@spm", SqlDbType.VarChar, l.spm); DataTable dt2 = new DataTable(); dt2 = sjk.Select("SELECT sl FROM sp where zt=1 and spm=@spm and xh=@yxh"); if (int.Parse(dt2.Rows[0][0].ToString()) > 0) { MessageBox.Show("此型号商品还有库存,不能删除!"); return; } DataTable dt3 = new DataTable(); sjk.AddParameters("@spm", SqlDbType.VarChar, l.spm); sjk.AddParameters("@xh", SqlDbType.VarChar, l.xh); dt3 = sjk.Select("SELECT * FROM sp where xh=@xh and spm=@spm"); if (dt3.Rows.Count > 0) { if (dt3.Rows[0]["zt"].ToString() == "0") { if (MessageBox.Show("数据库中已有该型号但被注销\n需要还原该型号吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { sjk.AddParameters("@yxh", SqlDbType.VarChar, dt.Rows[row][0]); sjk.AddParameters("@spm", SqlDbType.VarChar, l.spm); sjk.AddParameters("@xh", SqlDbType.VarChar, l.xh); sjk.Up("update sp set zt=1 where xh=@xh and spm=@spm"); sjk.Delete("delete from sp where xh=@yxh and spm=@spm"); MessageBox.Show("用户修改成功!"); return; } else { return; } } else { MessageBox.Show("该商品已有该型号,不能进行修改!"); return; } } sjk.AddParameters("@yxh", SqlDbType.VarChar, dt.Rows[row][0]); sjk.AddParameters("@spm", SqlDbType.VarChar, l.spm); sjk.AddParameters("@xh", SqlDbType.VarChar, l.xh); sjk.Up("update sp set xh=@xh where xh=@yxh and spm=@spm"); sjk.clear(); MessageBox.Show("用户修改成功!"); DataTable dt4 = new DataTable(); dt4 = sjk.Select("select spm,xh from sp where zt=1"); dg.DataSource = dt4; }
public int lr(spxx l, DataGridView dg, int row) { DataTable tcdx = new DataTable(); DataTable tcdx2 = new DataTable(); DataTable tcdx3 = new DataTable(); tcdx = sjk.Select("select*from spb"); tcdx2 = sjk.Select("select*from spxxb"); for (int i = 0; i < tcdx.Rows.Count; i++) { if (tcdx.Rows[i]["spm"].ToString() == l.spm) { for (int j = 0; j < tcdx2.Rows.Count; j++) { l.spbh = int.Parse(tcdx.Rows[i]["spbh"].ToString()); if (l.spbh == int.Parse(tcdx2.Rows[j]["spbh"].ToString()) && tcdx2.Rows[j]["xh"].ToString() == l.xh) { MessageBox.Show("已经有此型号无需输入!"); dg.Rows.Add(); dg.Rows[row].Cells[0].Value = l.spm; dg.Rows[row].Cells[1].Value = l.xh; dg.Rows[row].Cells[2].Value = "失败"; row++; return(row); } } l.spbh = int.Parse(tcdx.Rows[i]["spbh"].ToString()); sjk.AddParameters("@spbh", SqlDbType.Int, l.spbh); sjk.AddParameters("@xh", SqlDbType.VarChar, l.xh); sjk.Insert("insert into spxxb(spbh,xh,sl,zt) values(@spbh,@xh,0,1)"); MessageBox.Show("插入成功!"); dg.Rows.Add(); dg.Rows[row].Cells[0].Value = l.spm; dg.Rows[row].Cells[1].Value = l.xh; dg.Rows[row].Cells[2].Value = "成功"; row++; return(row); } } sjk.AddParameters("@spm", SqlDbType.NChar, l.spm); sjk.Insert("insert into spb(spm,zt) values(@spm,1)"); tcdx3 = sjk.Select("select*from spb"); l.spbh = int.Parse(tcdx3.Rows[tcdx.Rows.Count]["spbh"].ToString()); sjk.AddParameters("@spbh", SqlDbType.Int, l.spbh); sjk.AddParameters("@xh", SqlDbType.VarChar, l.xh); sjk.Insert("insert into spxxb(spbh,xh,sl,zt) values(@spbh,@xh,0,1)"); MessageBox.Show("插入成功!"); dg.Rows.Add(); dg.Rows[row].Cells[0].Value = l.spm; dg.Rows[row].Cells[1].Value = l.xh; dg.Rows[row].Cells[2].Value = "成功"; row++; return(row); }
public void xg2(DataGridView dg, spxx l, int row) { bool t; DataTable dt = new DataTable(); sjk.AddParameters("@spm", SqlDbType.NVarChar, l.spm); dt = sjk.Select("select xh from sp where spm=@spm and zt=1"); if (dt.Rows.Count > 0) { MessageBox.Show("此商品还有商品型号,不能进行修改!"); return; } DataTable dt2 = new DataTable(); dt2 = sjk.Select("SELECT spm FROM spb where zt=1"); DataTable dt3 = new DataTable(); sjk.AddParameters("@spm", SqlDbType.VarChar, l.spm); dt3 = sjk.Select("SELECT * FROM sp where spm=@spm"); if (dt3.Rows.Count > 0) { if (dt3.Rows[0]["zt"].ToString() == "0") { if (MessageBox.Show("数据库中已有该型号但被注销\n需要还原该型号吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { sjk.AddParameters("@yspm", SqlDbType.VarChar, dt2.Rows[row][0]); sjk.AddParameters("@spm", SqlDbType.VarChar, l.spm); sjk.Up("update sp set zt=1 where spm=@spm"); sjk.Delete("delete from sp where and spm=@yspm"); MessageBox.Show("用户修改成功!"); return; } else { return; } } else { MessageBox.Show("已有该商品名,不能进行修改!"); return; } } sjk.AddParameters("@yspm", SqlDbType.VarChar, dt2.Rows[row][0]); sjk.AddParameters("@spm", SqlDbType.VarChar, l.spm); sjk.Up("update spb set spm=@spm where spm=@yspm "); sjk.clear(); MessageBox.Show("用户修改成功!"); DataTable dt4 = new DataTable(); dt4 = sjk.Select("select spm from spb where zt=1"); dg.DataSource = dt4; return; }