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;
}
