public CustomJsonResult GetMy(RupWithdrawGetList rup)
{
var query = (from o in CurrentDb.Withdraw
where
o.ClientId == this.CurrentUserId
select new { o.Sn, o.ApplyTime, o.Amount, o.Status, o.AcName, o.AcBank, o.AcBankCardNumber, o.ApplyMethod, o.AcIdNumber, o.FailureReason });
int total = query.Count();
int pageSize = 10;
query = query.OrderByDescending(r => r.ApplyTime).Skip(pageSize * (rup.PageIndex)).Take(pageSize);
var list = query.ToList();
List <MyWithdrawModel> oList = new List <MyWithdrawModel>();
foreach (var item in list)
{
var myWithdraw = new MyWithdrawModel();
myWithdraw.Sn = item.Sn;
myWithdraw.Title = string.Format("资金提现-到{0}({1})", item.AcBank, CommonUtil.GetLastString(item.AcBankCardNumber, 4));
myWithdraw.ApplyTime = item.ApplyTime.ToString("yyyy.MM.dd HH:mm:ss");
myWithdraw.Amount = item.Amount.ToF2Price();
switch (item.Status)
{
case Enumeration.WithdrawStatus.Apply:
case Enumeration.WithdrawStatus.Handing:
myWithdraw.Remarks = "处理中";
myWithdraw.RemarksFontColor = "#000000";
break;
case Enumeration.WithdrawStatus.Success:
myWithdraw.Remarks = "成功";
myWithdraw.RemarksFontColor = "#1fc31b";
break;
case Enumeration.WithdrawStatus.Failure:
myWithdraw.Remarks = "失败";
if (!string.IsNullOrEmpty(item.FailureReason))
{
myWithdraw.Remarks += "，" + item.FailureReason;
}
myWithdraw.RemarksFontColor = "#f34754";
break;
}
oList.Add(myWithdraw);
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = oList
};
return(new CustomJsonResult(ResultType.Success, ResultCode.Success, "", pageEntity));
}
public CustomJsonResult GetListByDoTransfer(RupWithdrawGetList condition)
{
var query = (from u in CurrentDb.Withdraw
join w in CurrentDb.WxUserInfo on u.ClientId equals w.ClientId
where (condition.Name == null || u.AcName.Contains(condition.Name))
&&
u.Status == Lumos.Entity.Enumeration.WithdrawStatus.Handing
&&
(condition.Sn == null || u.Sn.Contains(condition.Sn)) &&
(condition.StartTime == null || u.ApplyTime >= condition.StartTime) &&
(condition.EndTime == null || u.ApplyTime <= condition.EndTime)
select new { u.Id, u.Sn, w.Nickname, u.AcName, u.AcIdNumber, u.Amount, u.ApplyTime });
int total = query.Count();
int pageIndex = condition.PageIndex;
int pageSize = 10;
query = query.OrderBy(r => r.ApplyTime).Skip(pageSize * (pageIndex)).Take(pageSize);
var list = query.ToList();
List <object> olist = new List <object>();
foreach (var item in list)
{
olist.Add(new
{
Id = item.Id,
Sn = item.Sn,
Nickname = item.Nickname,
AcName = item.AcName,
AcIdNumber = item.AcIdNumber,
Amount = item.Amount.ToF2Price(),
ApplyTime = item.ApplyTime,
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = olist
};
return(Json(ResultType.Success, pageEntity, ""));
}
public CustomJsonResult GetListByDetails(RupWithdrawGetList rup)
{
var query = (from u in CurrentDb.Withdraw
join w in CurrentDb.WxUserInfo on u.ClientId equals w.ClientId
where (rup.Name == null || u.AcName.Contains(rup.Name))
&&
(rup.Sn == null || u.Sn.Contains(rup.Sn)) &&
(rup.StartTime == null || u.ApplyTime >= rup.StartTime) &&
(rup.EndTime == null || u.ApplyTime <= rup.EndTime)
select new { u.Id, u.Sn, w.Nickname, u.AcName, u.AcIdNumber, u.Amount, u.ApplyTime, u.Status });
int total = query.Count();
int pageIndex = rup.PageIndex;
int pageSize = 10;
query = query.OrderBy(r => r.ApplyTime).Skip(pageSize * (pageIndex)).Take(pageSize);
var list = query.ToList();
List <object> olist = new List <object>();
foreach (var item in list)
{
string statusName = "";
switch (item.Status)
{
case Enumeration.WithdrawStatus.Apply:
statusName = "待审核";
break;
case Enumeration.WithdrawStatus.Handing:
statusName = "待转账";
break;
case Enumeration.WithdrawStatus.Success:
statusName = "成功";
break;
case Enumeration.WithdrawStatus.Failure:
statusName = "失败";
break;
}
olist.Add(new
{
Id = item.Id,
Sn = item.Sn,
Nickname = item.Nickname,
AcName = item.AcName,
AcIdNumber = item.AcIdNumber,
Amount = item.Amount.ToF2Price(),
ApplyTime = item.ApplyTime,
StatusName = statusName
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = olist
};
return(Json(ResultType.Success, pageEntity, ""));
}
