方法如下:
string sql = @"update Finance_RefundList set
ProductNumber=@ProductNumber,RefundMoney=@RefundMoney,
ModifyDate=@ModifyDate,Modifier=@Modifier,Enable=@Enable,DeleteBy=@DeleteBy
where Refund_Id=@Refund_Id and OitemId=@OitemId";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ProductNumber",ProductNumber),
new SqlParameter("@RefundMoney",RefundMoney),
new SqlParameter("@Refund_Id",Refund_Id),
new SqlParameter("@OitemId",OitemId),
new SqlParameter("@ModifyDate",DateTime.Now),
new SqlParameter("@Modifier",Modifier),
new SqlParameter("@Enable",0),
new SqlParameter("@DeleteBy",null)
};
return idataHelperWMSys_AfterService.ExecuteNonQuery(CommandType.Text, sql, para);
错误信息:
{"参数化查询 '(@ProductNumber nvarchar(1),@RefundMoney decimal(6,4),@Refund_Id' 需要参数 '@Enable',但未提供该参数。"}
求帮助呀~