| | |
| | | /// 修改打印状态 |
| | | /// </summary> |
| | | /// <param name="orderId"></param> |
| | | public bool Updatejinedanjia(int orderId, decimal SumPrice, decimal UnitPrice) |
| | | public bool Updatejinedanjia(int orderId, decimal SumPrice, decimal UnitPrice,int num) |
| | | { |
| | | try |
| | | { |
| | | string sqlStr = string.Empty; |
| | | sqlStr = "UPDATE EC_OrderBasic SET SumPrice="+ SumPrice + " ,UnitPrice="+ UnitPrice + " WHERE Keyid=@orderId"; |
| | | sqlStr = "UPDATE EC_OrderBasic SET SumPrice="+ SumPrice + " ,UnitPrice="+ UnitPrice + " WHERE Keyid=@orderId;UPDATE [EC_OrderExtend] SET [PrintNum]=" + num + " WHERE Keyid="+ orderId ; |
| | | SqlParameter par = new SqlParameter("@orderId", orderId); |
| | | _dataBase.ExecuteSql(sqlStr, par); |
| | | } |