public JsonResult BusinessRecharge(BusinessOptionLog model) { model.OptName = UserContext.Current.Name; var reg = iBusinessFinanceProvider.BusinessRecharge(model); return(Json(new ResultModel(reg, reg ? "充值成功!" : "充值失败!"), JsonRequestBehavior.DenyGet)); }
/// <summary> /// 商户充值增加商家余额可提现和插入商家余额流水 /// danny-20150526 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool BusinessRecharge(BusinessOptionLog model) { string sql = string.Format(@" update b set b.BalancePrice=ISNULL(b.BalancePrice, 0)+@Amount, b.AllowWithdrawPrice=ISNULL(b.AllowWithdrawPrice,0)+@Amount OUTPUT Inserted.Id, @Amount, @Status, Inserted.BalancePrice, @RecordType, @Operator, getdate(), @Remark INTO BusinessBalanceRecord ( [BusinessId] ,[Amount] ,[Status] ,[Balance] ,[RecordType] ,[Operator] ,[OperateTime] ,[Remark]) from business b WITH ( ROWLOCK ) where b.Id=@BusinessId;"); var parm = DbHelper.CreateDbParameters(); parm.AddWithValue("@Amount", model.RechargeAmount); parm.AddWithValue("@Status", BusinessBalanceRecordStatus.Success); parm.AddWithValue("@RecordType", BusinessBalanceRecordRecordType.Recharge); parm.AddWithValue("@Operator", model.OptName); parm.AddWithValue("@Remark", model.Remark); parm.AddWithValue("@BusinessId", model.BusinessId); return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0); }
/// <summary> /// 商户充值增加商家余额可提现和插入商家余额流水 /// danny-20150526 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool BusinessRecharge(BusinessOptionLog model) { return(businessFinanceDao.BusinessRecharge(model)); }