public ActionResult Index(int id)
{
var model = new IndexVM();
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
DM_NHOMDANHMUCBusiness = Get <DM_NHOMDANHMUCBusiness>();
var searchmodel = new DM_DANHMUC_DATA_SEARCHBO();
SessionManager.SetValue("dmdanhmucdataSearchModel", null);
model.lstData = DM_DANHMUC_DATABusiness.GetDaTaByPage(id, null);
model.DanhMuc = DM_NHOMDANHMUCBusiness.Find(id);
return(View(model));
}
/// <summary>
/// id là id nhóm danh mục
/// </summary>
/// <param name="id"></param>
/// <param name="searchModel"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public PageListResultBO <DM_DANHMUC_DATA_BO> GetDaTaByPage(int idDanhMuc, DM_DANHMUC_DATA_SEARCHBO searchModel, int pageIndex = 1, int pageSize = 20)
{
var query = from tbl in this.context.DM_DANHMUC_DATA
join dept in this.context.CCTC_THANHPHAN on tbl.DEPTID equals dept.ID into g1
from group1 in g1.DefaultIfEmpty()
where tbl.DM_NHOM_ID == idDanhMuc
select new DM_DANHMUC_DATA_BO
{
ID = tbl.ID,
DM_NHOM_ID = tbl.DM_NHOM_ID,
TEXT = tbl.TEXT,
CODE = tbl.CODE,
GHICHU = tbl.GHICHU,
DATA = tbl.DATA,
TENCAP = group1.NAME
};
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
query = query.OrderBy(searchModel.sortQuery);
}
else
{
query = query.OrderByDescending(x => x.ID);
}
}
else
{
query = query.OrderByDescending(x => x.ID);
}
var resultmodel = new PageListResultBO <DM_DANHMUC_DATA_BO>();
if (pageSize == -1)
{
var dataPageList = query.ToList();
resultmodel.Count = dataPageList.Count;
resultmodel.TotalPage = 1;
resultmodel.ListItem = dataPageList;
}
else
{
var dataPageList = query.ToPagedList(pageIndex, pageSize);
resultmodel.Count = dataPageList.TotalItemCount;
resultmodel.TotalPage = dataPageList.PageCount;
resultmodel.ListItem = dataPageList.ToList();
}
return(resultmodel);
}
public JsonResult getData(int id, int indexPage, string sortQuery, int pageSize)
{
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
var searchModel = SessionManager.GetValue("dmdanhmucdataSearchModel") as DM_DANHMUC_DATA_SEARCHBO;
if (!string.IsNullOrEmpty(sortQuery))
{
if (searchModel == null)
{
searchModel = new DM_DANHMUC_DATA_SEARCHBO();
}
searchModel.sortQuery = sortQuery;
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("dmdanhmucdataSearchModel", searchModel);
}
var data = DM_DANHMUC_DATABusiness.GetDaTaByPage(id, searchModel, indexPage, pageSize);
return(Json(data));
}
