/// <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);
}
