/// <summary>
/// 订单支付
/// </summary>
/// <param name="OrdersId"></param>
/// <returns></returns>
public bool OrdersPay(string OrdersId, string PayOrdersNum, string UserName, int OrdersState)
{
const string Orders =
@"UPDATE Orders SET OrdersState=2,PayTime=getdate(),profit=SellingPrice-CostPrice,PayOrdersNum=@PayOrdersNum WHERE OrderId=@OrdersId";
Factory.DBHelper.ExecSQL(SQLConString, Orders.ToString(), new DynamicParameters(new
{
OrdersId,
PayOrdersNum
}));
const string OrdersDetails =
@"UPDATE OrdersDetails SET profit=SellingPrice-CostPrice WHERE OrderId=@OrdersId";
Factory.DBHelper.ExecSQL(SQLConString, OrdersDetails.ToString(), new DynamicParameters(new
{
OrdersId,
}));
const string OrdersLog =
@"insert into OrdersLog(OrdersId,UserName,OrdersState)
values(@OrdersId,@UserName,@OrdersState)";
Factory.DBHelper.ExecSQL(SQLConString, OrdersLog.ToString(), new DynamicParameters(new
{
OrdersId,
UserName,
OrdersState
}));
//int OrdersInfoSum = GetPayOrdersSum(OrdersId);
//string sql = @"UPDATE Flower set FlowerStock=FlowerStock-" + OrdersInfoSum + " WHERE OrderId=@OrdersId ";
//Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
//{
// OrdersId,
//}));
#region 修改花卉数量
IList <Model.OrdersDetails> ordersDetailList = GetPayOrdersSum(OrdersId);
foreach (Model.OrdersDetails item in ordersDetailList)
{
string sql = @"UPDATE Flower set FlowerStock=FlowerStock-@SellingNum WHERE FlowerNumber=@FlowerNumber ";
Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
item.FlowerNumber,
item.SellingNum,
}));
}
#endregion
return(true);
}
