/// <summary> /// /// </summary> /// <param name="orderNo"></param> /// <param name="orderStatus"></param> /// <param name="isOpenTrans"></param> /// <returns></returns> public bool UpdateOutStockStatus(string orderNo, OutStockStatus orderStatus, DbTransaction isOpenTrans) { var strSql = new StringBuilder(); strSql.Append(@"UPDATE dbo.SaleOrder SET OutStockStatus = @OutStockStatus, ModifyDate = @ModifyDate WHERE OrderNo = @OrderNo"); var parameter = new List <DbParameter> { DbFactory.CreateDbParameter("@ModifyDate", DateTime.Now), DbFactory.CreateDbParameter("@OutStockStatus", (int)orderStatus), DbFactory.CreateDbParameter("@OrderNo", orderNo) }; return(Repository().ExecuteBySql(strSql, parameter.ToArray(), isOpenTrans) > 0); }
/// <summary> /// 更新订单状态 /// </summary> /// <param name="order"></param> /// <param name="currentStatus">订单当前状态</param> /// <param name="isOpenTrans"></param> /// <returns></returns> public bool UpdateStatus(SaleOrderEntity order, OutStockStatus currentStatus, DbTransaction isOpenTrans) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE dbo.SaleOrder SET OutStockStatus = @OutStockStatus, ModifyUserId = @ModifyUserId, ModifyUserName = @ModifyUserName, ModifyDate = @ModifyDate WHERE OrderId = @OrderId AND Status = @CurrentStatus"); var parameter = new List <DbParameter> { DbFactory.CreateDbParameter("@ModifyUserId", order.ModifyUserId), DbFactory.CreateDbParameter("@ModifyUserName", order.ModifyUserName), DbFactory.CreateDbParameter("@ModifyDate", order.ModifyDate), DbFactory.CreateDbParameter("@OutStockStatus", order.OutStockStatus), DbFactory.CreateDbParameter("@CurrentStatus", currentStatus), DbFactory.CreateDbParameter("@OrderId", order.OrderId) }; return(Repository().ExecuteBySql(strSql, parameter.ToArray(), isOpenTrans) > 0); }