public ActionResult RechargeList(string usercode, string truename, DateTime?start, DateTime?end, int type = 0, int style = 0, int pageIndex = 1)
{
RechargeListModel model = new RechargeListModel();
//查询数据
RechargePageResult rechargeModel = new RechargePageResult();
rechargeModel = rechargeService.GetPageList(0, usercode, truename, type, style, start, end, pageIndex, PageSize);
model.rechargeList = rechargeModel.Recharges;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = PageSize;
pager.TotalCount = rechargeModel.TotalCount;
if (rechargeModel.TotalCount <= PageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(Json(new AjaxResult {
Status = "1", Data = model
}));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="UserID"></param>
/// <param name="UserCode"></param>
/// <param name="TrueName"></param>
/// <param name="RechargeType">币种</param>
/// <param name="RechargeStyle">充值类型</param>
/// <param name="StartTime"></param>
/// <param name="EndTime"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public RechargePageResult GetPageList(long UserID, string UserCode, string TrueName, int RechargeType, int RechargeStyle, DateTime?StartTime, DateTime?EndTime, int PageIndex, int PageSize)
{
using (MyDbContext dbcontext = new MyDbContext())
{
CommonService <RechargeEntity> csr = new CommonService <RechargeEntity>(dbcontext);
RechargePageResult PageResult = new RechargePageResult();
var RechargeQuery = csr.GetAll();
if (UserID > 0)
{
RechargeQuery = RechargeQuery.Where(p => p.UserID == UserID);
}
if (!string.IsNullOrEmpty(UserCode))
{
RechargeQuery = RechargeQuery.Where(p => p.Users.UserCode.Contains(UserCode));
}
if (!string.IsNullOrEmpty(TrueName))
{
RechargeQuery = RechargeQuery.Where(p => p.Users.TrueName.Contains(TrueName));
}
if (RechargeType > 0)//币种
{
RechargeQuery = RechargeQuery.Where(p => p.RechargeType == RechargeType);
}
if (RechargeStyle > 0)//充值类型
{
RechargeQuery = RechargeQuery.Where(p => p.RechargeStyle == RechargeStyle);
}
if (StartTime != null)
{
RechargeQuery = RechargeQuery.Where(p => p.RechargeDate >= StartTime);
}
if (EndTime != null)
{
RechargeQuery = RechargeQuery.Where(p => p.RechargeDate <= EndTime);
}
PageResult.Recharges = RechargeQuery.OrderByDescending(p => p.CreateTime).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList().Select(p => ToDTO(p)).ToArray();
PageResult.TotalCount = RechargeQuery.LongCount();
return(PageResult);
}
}
/// <summary>
/// 后台充值列表
/// </summary>
/// <returns></returns>
public ActionResult RechargeList()
{
RechargeListModel model = new RechargeListModel();
//查询数据
RechargePageResult rechargeModel = new RechargePageResult();
rechargeModel = rechargeService.GetPageList(0, "", "", 0, 0, null, null, 1, PageSize);
model.rechargeList = rechargeModel.Recharges;
//分页
Pagination pager = new Pagination();
pager.PageIndex = 1;
pager.PageSize = PageSize;
pager.TotalCount = rechargeModel.TotalCount;
if (rechargeModel.TotalCount <= PageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
//币种
model.currencyList = currencynameService.GetList();
var selectItemList = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "0", Text = "请选择", Selected = true
}
};
var selectList = new SelectList(model.currencyList, "ID", "CurrencyName");
selectItemList.AddRange(selectList);
ViewBag.currency = selectItemList;
return(View(model));
}