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