public ActionResult LoNhap(DateTime?startDate, DateTime?endDate, int page = 1, int pageSize = 10, string search = null)
{
if (startDate != null && endDate != null)
{
ViewBag.cultureInfo = CultureInfo;
ViewBag.startDate = startDate;
ViewBag.endDate = endDate;
List <Sach> DMSach = SachManager.getAll()
.Where(s => s.tongSoLuongNhapTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0 &&
s.tongTienNhapTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0).ToList();
if (!String.IsNullOrEmpty(search))
{
DMSach = SachManager.filter(search, DMSach);
ViewBag.SearchKey = search;
}
ViewBag.tongSoLuongNhap = DMSach.Sum(s => s.SoLuongNhapTheoThang);
ViewBag.tongTienNhap = DMSach.Sum(s => s.TongTienNhapTheoThang);
var models = DMSach.ToPagedList(page, pageSize);
setAlertMessage();
return(View(models));
}
setAlertMessage();
return(View());
}
private void LoadTT()
{
_Sach = SachManager.getAll()
.Where(s => s.tongSoLuongBanTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0 &&
s.tongTienBanTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0).ToList();
gdvDMSach.DataSource = _Sach;
lbSachBanDuoc.Text = _Sach.Sum(s => s.TongSoLuongBanTheoThang) + "";
lbTongTien.Text = _Sach.Sum(s => s.TongTienBanTheoThang) + "";
}
private void loadTT()
{
if (x == 1)
{
_DMSachNXB = SachManager.getAll()
.Where(s => s.tongSoLuongNXBNoTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0 &&
s.tongTienNXBNoTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0).ToList();
gdvDMSach.DataSource = _DMSachNXB;
lbSoLuongNo.Text = _DMSachNXB.Sum(s => s.TongSoLuongNXBNoTheoThang) + "";
lbTongTien.Text = _DMSachNXB.Sum(s => s.TongTienNXBNoTheoThang) + "";
}
if (x == 2)
{
_DMSachDLy = SachManager.getAll()
.Where(s => s.tongSoLuongDaiLyNoTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0 && s.tongTienDaiLyNoTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0).ToList();
gdvDMSach.DataSource = _DMSachDLy;
lbSoLuongNo.Text = _DMSachDLy.Sum(s => s.TongSoLuongDaiLyNoTheoThang) + "";
lbTongTien.Text = _DMSachDLy.Sum(s => s.TongTienDaiLyNoTheoTang) + "";
}
}
public FileStreamResult LoNhap(DateTime startDate, DateTime endDate)
{
List <Sach> DMSach = SachManager.getAll()
.Where(s => s.tongSoLuongNhapTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0 &&
s.tongTienNhapTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0).ToList();
var printer = new PrintHelper();
printer.FileName = "report.pdf";
printer.FolderPath = "D://";
printer.Title = "Thống kê lô nhập";
var info = new MemoryStream(printer.printLoNhap(DMSach, startDate, endDate));
return(new FileStreamResult(info, "application/pdf"));
}
public void loadSach()
{
_DMSach = SachManager.getAll();
}