public ActionResult JournalList(string usercode, string truename, DateTime?start, DateTime?end, int type = 0, int pageIndex = 1)
{
JournalListModel model = new JournalListModel();
//账户明细列表
JournalPageResult journalModel = new JournalPageResult();
journalModel = journalService.GetPageList(0, usercode, truename, type, start, end, pageIndex, PageSize);
model.journalList = journalModel.Journals;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = PageSize;
pager.TotalCount = journalModel.TotalCount;
if (journalModel.TotalCount <= PageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(Json(new AjaxResult {
Status = "1", Data = model
}));
}
public PartialViewResult TakeCashJournalGetPage(string name, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
TakeCashJournalModel model = new TakeCashJournalModel();
long journalTypeId = journalTypeService.GetByDecription("提现").First().Id;
JournalPageResult result = journalService.GetPageList(null, mobile, name, null, journalTypeId, startTime, endTime, pageIndex, pageSize);
model.Journals = result.Journals;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(PartialView("TakeCashJournalPaging", model));
}
public PartialViewResult BonusJournalGetPage(string name, string mobile, long?journalTypeId, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
if (journalTypeId == 0)
{
journalTypeId = null;
}
BonusJournalViewModel model = new BonusJournalViewModel();
JournalPageResult result = journalService.GetPageList(null, mobile, name, "分红", journalTypeId, startTime, endTime, pageIndex, pageSize);
model.Journals = result.Journals;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(PartialView("BonusJournalPaging", model));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="holderId"></param>
/// <param name="mobile"></param>
/// <param name="name"></param>
/// <param name="journalTypeId"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public JournalPageResult GetPageList(long?holderId, string mobile, string name, string remark, long?journalTypeId, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbcontext = new MyDbContext())
{
CommonService <JournalEntity> csr = new CommonService <JournalEntity>(dbcontext);
JournalPageResult PageResult = new JournalPageResult();
var JournalQuery = csr.GetAll();
if (holderId != null)
{
JournalQuery = JournalQuery.Where(p => p.HolderId == holderId);
}
if (!string.IsNullOrEmpty(mobile))
{
JournalQuery = JournalQuery.Where(p => p.Holder.Mobile.Contains(mobile));
}
if (!string.IsNullOrEmpty(name))
{
JournalQuery = JournalQuery.Where(p => p.Holder.Name.Contains(name));
}
if (!string.IsNullOrEmpty(remark))
{
JournalQuery = JournalQuery.Where(p => p.Remark.Contains(remark));
}
if (journalTypeId != null)
{
JournalQuery = JournalQuery.Where(p => p.JournalTypeId == journalTypeId);
}
if (startTime != null)
{
JournalQuery = JournalQuery.Where(p => p.CreateTime >= startTime);
}
if (endTime != null)
{
JournalQuery = JournalQuery.Where(p => p.CreateTime <= endTime);
}
PageResult.TotalCount = JournalQuery.LongCount();
PageResult.Journals = JournalQuery.OrderByDescending(j => j.CreateTime).OrderByDescending(j => j.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(p => ToDTO(p)).ToArray();
return(PageResult);
}
}
/// <summary>
/// 账户明细列表
/// </summary>
/// <returns></returns>
public ActionResult JournalList()
{
JournalListModel model = new JournalListModel();
//查询数据
JournalPageResult journalModel = new JournalPageResult();
journalModel = journalService.GetPageList(0, "", "", 0, null, null, 1, PageSize);
model.journalList = journalModel.Journals;
//分页
Pagination pager = new Pagination();
pager.PageIndex = 1;
pager.PageSize = PageSize;
pager.TotalCount = journalModel.TotalCount;
if (journalModel.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));
}
public JournalPageResult GetPageList(long UserID, string UserCode, string TrueName, int JournalType, DateTime?StartTime, DateTime?EndTime, int PageIndex, int PageSize)
{
using (MyDbContext dbcontext = new MyDbContext())
{
CommonService <JournalEntity> csr = new CommonService <JournalEntity>(dbcontext);
JournalPageResult PageResult = new JournalPageResult();
var JournalQuery = csr.GetAll();
if (UserID > 0)
{
JournalQuery = JournalQuery.Where(p => p.UserID == UserID);
}
if (!string.IsNullOrEmpty(UserCode))
{
JournalQuery = JournalQuery.Where(p => p.Users.UserCode.Contains(UserCode));
}
if (!string.IsNullOrEmpty(TrueName))
{
JournalQuery = JournalQuery.Where(p => p.Users.TrueName.Contains(TrueName));
}
if (JournalType > 0)
{
JournalQuery = JournalQuery.Where(p => p.JournalType == JournalType);
}
if (StartTime != null)
{
JournalQuery = JournalQuery.Where(p => p.CreateTime >= StartTime);
}
if (EndTime != null)
{
JournalQuery = JournalQuery.Where(p => p.CreateTime <= EndTime);
}
PageResult.Journals = JournalQuery.OrderByDescending(p => p.CreateTime).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList().Select(p => ToDTO(p)).ToArray();
PageResult.TotalCount = JournalQuery.LongCount();
return(PageResult);
}
}
