public ActionResult List(int?Page)
{
int pageSize = 10;
int currenPage = (Page == null || Page < 1) ? 1 : Page.Value;
var result = _AccountBookSvc.Lookup(User.Identity.Name).OrderByDescending(x => x.Date).ToPagedList(currenPage, pageSize);
return(View(result));
}
public ActionResult Details(int?page)
{
var details = _accountBookSvc.Lookup().OrderByDescending(x => x.DataDate);
int currentPage = (page.HasValue ? (page.Value < 1 ? 1 : page.Value) : 1);
return(View(details.ToPagedList(currentPage, defaultPageSize)));
}
// GET: backend/Admin
public ActionResult Index(int?page, string q, string column = "Date", EnumSort order = EnumSort.Ascending)
{
//分頁套件： Install-Package PagedList.Mvc
var pageIndex = page.HasValue ? page.Value < 1 ? 1 : page.Value : 1;
var pageSize = 10;
//為了範例最簡化，因此直接在 Controller 操作 DB ，實務上請盡量避免
var source = _AccountBookSvc.Lookup().AsQueryable();//_dbContext.AccountBook.AsQueryable();
if (string.IsNullOrWhiteSpace(q) == false)
{
// 只是單純示範搜尋條件應該如何累加
var category = Convert.ToInt32(q);
source = source.Where(d => d.Category == category);
}
var result = new QueryOption <AccountBook.Models.AccountBook>
{
Order = order,
Column = column,
Page = pageIndex,
PageSize = pageSize,
Keyword = q
};
//利用 SetSource 將資料塞入（塞進去之前不能將資料讀出來）
result.SetSource(source);
ViewData.Model = result;
return(View());
//return View(_AccountBookSvc.Lookup());
}
public ActionResult AccountBookChildAction(int?year, int?month, int?page)
{
ViewBag.year = year.HasValue ? year : null;
ViewBag.month = month.HasValue ? month : null;
IEnumerable <AccountBookViewModels> accountBookViewModels = Enumerable.Empty <AccountBookViewModels>();
if (year.HasValue && month.HasValue)
{
accountBookViewModels = _accountBookSvc.LookupByYearMonth(year, month);
}
else if (year.HasValue && !month.HasValue)
{
accountBookViewModels = _accountBookSvc.LookupByYear(year);
}
else
{
accountBookViewModels = _accountBookSvc.Lookup();
}
var pageIndex = page.HasValue ? page.Value < 1 ? 1 : page.Value : 1;
var pageSize = 10;
return(View(accountBookViewModels.OrderByDescending(x => x.Date).ToPagedList(pageIndex, pageSize)));
//var source = _accountBookSvc.Lookup();
//return View(source.OrderByDescending(x => x.Date).ToList());
//return View(db.AccountBook.Take(10).OrderByDescending(x => x.Date).ToList());
}
public ActionResult List(int?page)
{
var query = _accountBookService.Lookup();
var pageIndex = page == null || page == 0 ? 0 : (int)page - 1;
var result = query.OrderByDescending(o => o.AccountingDate).ToPagedList(pageIndex, PageSize);
return(PartialView("_List", result));
}
public ActionResult List(int page = 1, int pageCount = 20)
{
//int page = 1;
//int pageCount = 100;
var skipCount = ((page - 1) * pageCount);
ViewData["pageItemIndex"] = skipCount + 1;
var expenseIncomeList = _accountBookService.Lookup()
.OrderByDescending(c => c.CreateTime);
//.Skip(skipCount)
//.Take(pageCount);
return(View(expenseIncomeList.ToPagedList(page, pageCount)));
}
private List <MoneyModel> GetAllAccountBook()
{
var accountBooks = _accountBookService.Lookup();
var result = new List <MoneyModel>();
foreach (var accountBook in accountBooks)
{
result.Add(new MoneyModel()
{
Type = accountBook.Categoryyy == 1 ? "支出" : "收入",
Date = accountBook.Dateee,
Money = accountBook.Amounttt,
Remark = accountBook.Remarkkk
});
}
return(result);
}
public ActionResult RecordList()
{
return(View(_accountBookService.Lookup().OrderBy(a => a.Date)));
}
public ActionResult ResultList()
{
var result = _accountBookSvc.Lookup();
return(View(result));
}
public ActionResult Index()
{
var model = _accountBookService.Lookup();
return(View(model));
}
public ActionResult ListMyMoney()
{
var result = _accountBookService.Lookup().OrderByDescending(x => x.Date).Take(50);
return(View(result));
}
// GET: Admin/AccountBook
public ActionResult Index()
{
var source = _accountBookSvc.Lookup();
return(View(source.OrderByDescending(x => x.Date).ToList()));
}
public ActionResult Index()
{
return(View(_accountBookService.Lookup()));
}
