内容发布更新时间 : 2024/12/22 18:40:52星期一 下面是文章的全部内容请认真阅读。

SqlParameter myNorm = new

SqlParameter(\ myNorm.Value = tempGoods.GoodsNorm; myCmd.Parameters.Add(myNorm);

SqlParameter myPrice = new

SqlParameter(\ myPrice.Value = tempGoods.GoodsSellPrice; myCmd.Parameters.Add(myPrice);

SqlParameter myAlarm = new SqlParameter(\ myAlarm.Value = tempGoods.AlarmNum; myCmd.Parameters.Add(myAlarm);

SqlParameter myRemark = new

SqlParameter(\ myRemark.Value = tempGoods.GoodsRemark; myCmd.Parameters.Add(myRemark); 执行存储过程 try {

msqlCon.Open();

myCmd.ExecuteNonQuery(); return true;

} catch {

return false; } finally {

msqlCon.Close(); } }

修改商品基本信息

public bool UpdateGoods(GoodsDetails tempGoods) {

this.msqlCon = new SqlConnection(mstrCon);

SqlCommand myCmd = new SqlCommand(\msqlCon);

myCmdmandType = CommandType.StoredProcedure; 给存储过程添加参数

SqlParameter myID = new SqlParameter(\SqlDbType.NVarChar, 20);

myID.Value =tempGoods.GoodsId; myCmd.Parameters.Add(myID);

SqlParameter myName=new

SqlParameter(\

myName.Value=tempGoods.GoodsName; myCmd.Parameters.Add(myName);

SqlParameter myType=new

SqlParameter(\ myType.Value=tempGoods.TypeName; myCmd.Parameters.Add(myType);

SqlParameter myUnit=new

SqlParameter(\ myUnit.Value=tempGoods.GoodsUnit; myCmd.Parameters.Add(myUnit);

SqlParameter myNorm=new

SqlParameter(\ myNorm.Value=tempGoods.GoodsNorm; myCmd.Parameters.Add(myNorm);

SqlParameter myPrice=new

SqlParameter(\ myPrice.Value=tempGoods.GoodsSellPrice; myCmd.Parameters.Add(myPrice);

SqlParameter myAlarm=new SqlParameter(\

myAlarm.Value=tempGoods.AlarmNum; myCmd.Parameters.Add(myAlarm);

SqlParameter myRemark=new

SqlParameter(\ myRemark.Value=tempGoods.GoodsRemark; myCmd.Parameters.Add(myRemark); 执行存储过程 try {

msqlCon.Open();

myCmd.ExecuteNonQuery(); return true; } catch {

return false; } finally {

msqlCon.Close(); } }

删除商品基本信息

public bool DeleteGoods(string tempGoodsID)