更新部分的代码不执行
//根据出库量更新库存public static void UpdateMedicineSumByOut(int MedicineID,int MedicineSum)
{
DbCommand comm = GenericDataAccess.CreateCommand(CommandType.StoredProcedure);
comm.CommandText = "UpdateMedicineSum";
DbParameter parm;
parm = comm.CreateParameter();
parm.ParameterName = "@MedicineID";
parm.DbType = DbType.Int32;
parm.Value = MedicineID;
comm.Parameters.Add(parm);
parm = comm.CreateParameter();
parm.ParameterName = "@MedicineSum";
parm.DbType = DbType.Int32;
parm.Value = MedicineSum;
comm.Parameters.Add(parm);
}
存储过程名为UpdateMedicineSum
这是后台执行代码:
protected void Btn_Submit_Click(object sender, EventArgs e)
{
DataTable dt = CatalogAccess.GetMedicineInfoByDrugname(txtdrugname.Text);
int MedicineID = Convert.ToInt32(dt.Rows[0]["MedicineID"]);
int MedicineSumNow = Convert.ToInt32(dt.Rows[0]["MedicineSum"]);
int MedicineSumUpdate = MedicineSumNow - Convert.ToInt32(txtsum.Text);
CatalogAccess.UpdateMedicineSumByOut(MedicineID, MedicineSumUpdate);
if (CatalogAccess.AddGiveOutRecord(txtdepartment.Text,MedicineID,Int32.Parse(txtsum.Text),Convert.ToDouble(txtindprice.Text),Convert.ToDateTime(DateTime.Now)))
{
ltScript.Text = "<script type='text/javascript'>alert('添加成功');</script>";
return;
}
}
更新那句代码没有执行。。。
--------------------编程问答--------------------
protected void Btn_Submit_Click(object sender, EventArgs e)
{
DataTable dt = CatalogAccess.GetMedicineInfoByDrugname(txtdrugname.Text);
int MedicineID = Convert.ToInt32(dt.Rows[0]["MedicineID"]);
int MedicineSumNow = Convert.ToInt32(dt.Rows[0]["MedicineSum"]);
int MedicineSumUpdate = MedicineSumNow - Convert.ToInt32(txtsum.Text);
//这里不执行么 ?
CatalogAccess.UpdateMedicineSumByOut(MedicineID, MedicineSumUpdate);
if (CatalogAccess.AddGiveOutRecord(txtdepartment.Text,MedicineID,Int32.Parse(txtsum.Text),Convert.ToDouble(txtindprice.Text),Convert.ToDateTime(DateTime.Now)))
{
ltScript.Text = "<script type='text/javascript'>alert('添加成功');</script>";
return;
}
}
是它不执行么 ?
CatalogAccess.UpdateMedicineSumByOut(MedicineID, MedicineSumUpdate); --------------------编程问答-------------------- 是的,就是这句更新不执行。。 --------------------编程问答-------------------- CatalogAccess.UpdateMedicineSumByOut(MedicineID, MedicineSumUpdate); 这句更新不执行 --------------------编程问答-------------------- public static void UpdateMedicineSumByOut(int MedicineID,int MedicineSum)
{
SqlConnection sqlCon = new SqlConnection("server=.;uid=ds;pwd=ds;database=库名");
DbCommand comm = GenericDataAccess.CreateCommand(CommandType.StoredProcedure);
comm.CommandText = "UpdateMedicineSum";
DbParameter parm;
parm = comm.CreateParameter();
parm.ParameterName = "@MedicineID";
parm.DbType = DbType.Int32;
parm.Value = MedicineID;
comm.Parameters.Add(parm);
parm = comm.CreateParameter();
parm.ParameterName = "@MedicineSum";
parm.DbType = DbType.Int32;
parm.Value = MedicineSum;
comm.Parameters.Add(parm);
sqlCon.Open();
comm.ExecuteNonQuery(); //主要少了这句话
sqlCon.Close();
}
--------------------编程问答-------------------- 你确定断点都进不去...? --------------------编程问答-------------------- 还是说,执行没结果..? --------------------编程问答--------------------
断点进不去。。。 --------------------编程问答--------------------
数据库里没有任何反应。。。 --------------------编程问答-------------------- 试试版主的回答吧...
补充:.NET技术 , ASP.NET