/// <summary> /// 处理提现成功 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(SysAgentWithdrawalRecordEntity model, SysUser agentModel) { int result = 0; using (var db = GetInstance()) { try { db.Ado.BeginTran();//开启事务 result = db.Updateable <SysAgentWithdrawalRecordEntity>().SetColumns(it => new SysAgentWithdrawalRecordEntity { Status = model.Status, Feedback = model.Feedback, WithdrawalAmount = model.WithdrawalAmount, ModifiedBy = OperatorProvider.Instance.Current.Account, ModifiedTime = DateTime.Now }).Where(it => it.id == model.id).ExecuteCommand(); //更新用户余额 db.Updateable <SysUser>().SetColumns(it => new SysUser { Balance = agentModel.Balance - model.WithdrawalAmount * 10 }).Where(it => it.Id == agentModel.Id).ExecuteCommand(); db.Ado.CommitTran(); } catch (Exception ex) { db.Ado.RollbackTran(); new LogLogic().Write(Level.Error, "处理提现金额", ex.Message, ex.StackTrace); } return(result); } }
public ActionResult Handle(SysAgentWithdrawalRecordEntity model) { int row; var withModel = sysAgentWithdrawalRecordLogic.Get(model.id); if (withModel.Status != 3) { return(Error("已经处理,不可重复处理!")); } if (model.Status == 2)//驳回 { row = sysAgentWithdrawalRecordLogic.Reject(model); } else//成功 { if (model.WithdrawalAmount <= 0) { return(Error("提现金额需要大于0!")); } var agentModel = new SysUserLogic().GetUserByID(withModel.AgentID); if (agentModel == null) { return(Error("经纪人不存在!")); } if (agentModel.Balance / 10 < model.WithdrawalAmount) { return(Error("提现金额不可大于余额!可提现余额:" + agentModel.Balance / 10)); } row = sysAgentWithdrawalRecordLogic.Update(model, agentModel); } return(row > 0 ? Success() : Error()); }
public ActionResult Form(SysAgentWithdrawalRecordEntity model) { var agentModel = new SysUserLogic().GetUserByID(model.AgentID); if (agentModel == null) { return(Error("经纪人不存在!")); } if (agentModel.Balance / 10 < model.WithdrawalAmount) { return(Error("提现金额不可大于余额!可提现余额:" + agentModel.Balance / 10)); } int row = sysAgentWithdrawalRecordLogic.Insert(model); return(row > 0 ? Success() : Error()); }
/// <summary> /// 新增提现记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(SysAgentWithdrawalRecordEntity model) { try { using (var db = GetInstance()) { model.Status = 3; model.createTime = DateTime.Now; model.ModifiedTime = DateTime.Now; model.Remark = model.Remark; model.WithdrawalAmount = Math.Truncate(model.WithdrawalAmount * 100) / 100; return(db.Insertable(model).ExecuteReturnIdentity()); } } catch (Exception ex) { new LogLogic().Write(Level.Error, "新增提现记录", ex.Message, ex.StackTrace); } return(0); }
/// <summary> /// 处理提现驳回 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Reject(SysAgentWithdrawalRecordEntity model) { var result = 0; using (var db = GetInstance()) { try { result = db.Updateable <SysAgentWithdrawalRecordEntity>().SetColumns(it => new SysAgentWithdrawalRecordEntity { Status = model.Status, Feedback = model.Feedback, WithdrawalAmount = model.WithdrawalAmount, ModifiedBy = OperatorProvider.Instance.Current.Account, ModifiedTime = DateTime.Now }).Where(it => it.id == model.id).ExecuteCommand(); } catch (Exception ex) { new LogLogic().Write(Level.Error, "处理提现金额", ex.Message, ex.StackTrace); } return(result); } }
public ActionResult GetForm(long primaryKey) { SysAgentWithdrawalRecordEntity entity = sysAgentWithdrawalRecordLogic.Get(primaryKey); return(Content(entity.ToJson())); }