库存管理表 如何实现库存的出库
临渊慎行 2020-10-16 01:33:37 protected void Button1_Click(object sender,EventArgs e)
{
string name="select MingCheng from TB_Store";
bool iRet=false;
if(this.TextBox1.Text==name)
{
string SQL2="select Num from TB_Store";
if(this.TextBox4.Text<=SQL2) //this.TextBox4.Text 接收的是数量‘Num’
{
Response.Write("<script>alert('出库成功');document.location=document.location;</script>");
//将该试剂的出库信息插入到TB_ChuKu
string SQL3="insert into TB_ChuKu(MingCheng,No,Time,CangKu,LeiBie,Num,Accepter)Values('"+this.TextBox1.Text+"','"+this.TextBox2.Text+"','"+this.TextBox3.Text+"','"+this.DropDownList1.SelectedItem.Text+"','"+this.DropDownList2.SelectedItem+"','"+this.TextBox4.Text+"','"+this.TextBox5.Text+"')";
//更新试剂库,数量=试剂库中的数量-出库数量
string SQL4="update TB_Store set Num=num-"+this.TextBox4.Text+" where MingCheng='"+this.TextBox1.Text+"';
}
else
{
Response.Write("<script>alert('该试剂库存不足');document.location=document.location;</script>");
}
else
{
Response.Write("<script>alert('该试剂不在试剂库中');document.location=document.location;</script>");
}
========
代码运行时并没有报错,但是打断点发现:代码在if(this.TextBox1.Text == name)这行代码直接跳出了
请问上面的代码书写正确吗,感谢大佬们的指点和帮助