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, "")); }