public JsonResult BusinessRecharge(ClienterOptionLog model)
{
model.OptName = UserContext.Current.Name;
var reg = iClienterFinanceProvider.ClienterRecharge(model);
return(Json(new ResultModel(reg, reg ? "骑士余额变更成功！" : "骑士余额变更失败！"), JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 骑士 余额可提现和插入骑士余额流水
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ClienterRecharge(ClienterOptionLog model)
{
string sql = string.Format(@"
update b
set b.AccountBalance=ISNULL(b.AccountBalance, 0)+@Amount,
b.AllowWithdrawPrice=ISNULL(b.AllowWithdrawPrice,0)+@Amount
OUTPUT
Inserted.Id,
@Amount,
@Status,
Inserted.AccountBalance,
@RecordType,
@Operator,
getdate(),
'',
@Remark
INTO ClienterBalanceRecord
( [ClienterId]
,[Amount]
,[Status]
,[Balance]
,[RecordType]
,[Operator]
,[OperateTime]
,[WithwardId]
,[Remark])
from clienter b WITH ( ROWLOCK )
where b.Id=@ClienterId;");
var parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@Amount", model.RechargeAmount);
parm.AddWithValue("@Status", ClienterBalanceRecordStatus.Success);
parm.AddWithValue("@RecordType", ClienterBalanceRecordRecordType.BalanceAdjustment);
parm.AddWithValue("@Operator", model.OptName);
parm.AddWithValue("@Remark", model.Remark);
parm.AddWithValue("@ClienterId", model.ClienterId);
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0);
}
/// <summary>
/// 骑士余额调整
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ClienterRecharge(ClienterOptionLog model)
{
return(clienterFinanceDao.ClienterRecharge(model));
}
