public async Task <ApiResult <string> > ModifyAmountAsync(CmsBalance_Chi parm)
{
var res = new ApiResult <string>()
{
statusCode = (int)ApiEnum.Error
};
try
{
using var tran = new TransactionScope();
var chi = await Db.Queryable <CmsBalance_Chi>().Where(t => t.BillID == parm.BillID &&
t.out_sub_mch_id == parm.out_sub_mch_id &&
t.sub_pay_platform == parm.sub_pay_platform).SingleAsync();
var fath = await Db.Queryable <CmsBalance>().Where(t => t.BillID == parm.BillID).SingleAsync();
parm.rebate_amount_rel = chi.rebate_amount_rel - chi.modify_amount + parm.modify_amount;
await Db.Updateable(parm).UpdateColumns(p => new { p.modify_amount, p.rebate_amount_rel }).ExecuteCommandAsync();
await Db.Updateable(new CmsBalance
{
BillID = fath.BillID,
modify_amount = fath.modify_amount - chi.modify_amount + parm.modify_amount,
rebate_amount_rel = fath.rebate_amount_rel - chi.modify_amount + parm.modify_amount,
moditime = DateTime.Now
}).UpdateColumns(t => new { t.modify_amount, t.rebate_amount_rel, t.moditime }).ExecuteCommandAsync();
tran.Complete();
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
res.statusCode = (int)ApiEnum.Status;
res.message = "调整金额成功";
return(res);
}
public Task <ApiResult <string> > Modify([FromBody] CmsBalance_Chi parm) => balanceService.ModifyAmountAsync(parm);
