/// <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);
}
