/// <summary> /// 更新充值记录状态 /// </summary> /// <param name="ID"></param> /// <param name="State"></param> /// <returns></returns> public int UpdateState(long ID, int State) { using (MyDbContext dbcontext = new MyDbContext()) { CommonService <RemitEntity> csr = new CommonService <RemitEntity>(dbcontext); RemitEntity remitModel = csr.GetById(ID); if (remitModel == null) { return(2);//已删除 } if (remitModel.State == 1) { return(3);//已确认 } remitModel.State = State; remitModel.RechargeableDate = DateTime.Now; int num = dbcontext.SaveChanges(); if (num > 0) { return(0);//确认成功 } else { return(1);//确认失败 } } }
/// <summary> /// 删除 /// </summary> /// <param name="ID"></param> /// <returns></returns> public int Del(long ID) { using (MyDbContext dbcontext = new MyDbContext()) { CommonService <RemitEntity> csr = new CommonService <RemitEntity>(dbcontext); RemitEntity re = csr.GetById(ID); if (re != null) { re.IsDeleted = true; int num = dbcontext.SaveChanges(); if (num > 0) { return(0);//删除成功 } else { return(1);//删除失败 } } else { return(2);//已删除 } } }
/// <summary> /// 根据ID查询 /// </summary> /// <param name="ID"></param> /// <returns></returns> public RemitDTO GetModelByID(long ID) { using (MyDbContext dbcontext = new MyDbContext()) { CommonService <RemitEntity> csr = new CommonService <RemitEntity>(dbcontext); RemitEntity re = csr.GetById(ID); RemitDTO model = null; if (re != null) { model = ToDTO(re); } return(model); } }
/// <summary> /// 添加充值记录 /// </summary> /// <param name="UserID"></param> /// <param name="Amount"></param> /// <param name="BankName"></param> /// <param name="BankAccount"></param> /// <param name="BankAccountUser"></param> /// <returns></returns> public long Add(RemitDTO dto) { using (MyDbContext dbcontext = new MyDbContext()) { RemitEntity remitModel = new RemitEntity(); remitModel.UserID = dto.UserID; remitModel.RemitMoney = dto.RemitMoney; remitModel.BankName = dto.BankName; remitModel.BankAccount = dto.BankAccount; remitModel.BankAccountUser = dto.BankAccountUser; remitModel.RechargeableDate = dto.RechargeableDate; remitModel.OutBankName = dto.OutBankName; remitModel.OutBankAccount = dto.OutBankAccount; remitModel.OutBankAccountUser = dto.OutBankAccountUser; remitModel.Remark = dto.Remark; remitModel.AddDate = DateTime.Now; remitModel.State = dto.State; dbcontext.Remit.Add(remitModel); dbcontext.SaveChanges(); return(remitModel.ID); } }
public RemitDTO ToDTO(RemitEntity remit) { RemitDTO Rdto = new RemitDTO(); Rdto.ID = remit.ID; Rdto.RemitMoney = remit.RemitMoney; Rdto.State = remit.State; Rdto.UserID = remit.UserID; Rdto.RechargeableDate = remit.RechargeableDate; Rdto.BankAccount = remit.BankAccount; Rdto.BankName = remit.BankName; Rdto.BankAccountUser = remit.BankAccountUser; Rdto.AddDate = remit.AddDate; Rdto.Remark = remit.Remark; Rdto.OutBankAccount = remit.OutBankAccount; Rdto.OutBankName = remit.OutBankName; Rdto.OutBankAccountUser = remit.OutBankAccountUser; Rdto.UserCode = remit.Users.UserCode; Rdto.TrueName = remit.Users.TrueName; Rdto.StateName = remit.State == 0 ? "等待审核" : "已确认"; return(Rdto); }