/// <summary> /// 新增主播提现记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(SysAnchorInfoEntity agentModel, SysAnchorWithdrawalRecordEntity model) { var result = 0; using (var db = GetInstance()) { try { db.Ado.BeginTran(); //更新主播余额 db.Updateable <SysAnchorInfoEntity>().SetColumns(it => new SysAnchorInfoEntity { agentGold = agentModel.agentGold - model.WithdrawalAmount * 10 }).Where(it => it.aid == agentModel.aid).ExecuteCommand(); model.Status = 3; model.createTime = DateTime.Now; model.ModifiedTime = DateTime.Now; model.Remark = model.Remark; model.WithdrawalAmount = Math.Truncate(model.WithdrawalAmount * 100) / 100; result = db.Insertable(model).ExecuteCommand(); db.Ado.CommitTran(); } catch (Exception ex) { db.Ado.RollbackTran(); new LogLogic().Write(Level.Error, "新增主播提现记录", ex.Message, ex.StackTrace); } } return(result); }
/// <summary> /// 处理主播提现驳回 把钱返回 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Reject(SysAnchorWithdrawalRecordEntity model, SysAnchorInfoEntity sysAnchorInfoModel) { var result = 0; using (var db = GetInstance()) { try { db.Ado.BeginTran();//事务 //更新主播余额 db.Updateable <SysAnchorInfoEntity>().SetColumns(it => new SysAnchorInfoEntity { agentGold = sysAnchorInfoModel.agentGold + model.WithdrawalAmount * 10 }).Where(it => it.aid == sysAnchorInfoModel.aid).ExecuteCommand(); result = db.Updateable <SysAnchorWithdrawalRecordEntity>().SetColumns(it => new SysAnchorWithdrawalRecordEntity { Status = 2, Feedback = model.Feedback, ModifiedBy = OperatorProvider.Instance.Current.Account, ModifiedTime = DateTime.Now }).Where(it => it.id == model.id).ExecuteCommand(); db.Ado.CommitTran(); } catch (Exception ex) { db.Ado.RollbackTran(); new LogLogic().Write(Level.Error, "处理主播提现驳回", ex.Message, ex.StackTrace); } return(result); } }