public ActionResult Index()
{
DM_NHOMDANHMUCBusiness = Get <DM_NHOMDANHMUCBusiness>();
var searchmodel = new DM_NHOMDANHMUC_SEARCHBO();
SessionManager.SetValue("dmnhomdanhmucSearchModel", null);
var data = DM_NHOMDANHMUCBusiness.GetDaTaByPage(null);
return(View(data));
}
public PageListResultBO <DM_NHOMDANHMUC_BO> GetDaTaByPage(DM_NHOMDANHMUC_SEARCHBO searchModel, int pageIndex = 1, int pageSize = 20)
{
var query = from tbl in this.context.DM_NHOMDANHMUC
select new DM_NHOMDANHMUC_BO
{
ID = tbl.ID,
GROUP_CODE = tbl.GROUP_CODE,
GROUP_NAME = tbl.GROUP_NAME,
TYPE = tbl.TYPE,
};
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.QR_CODE))
{
query = query.Where(x => x.GROUP_CODE.Contains(searchModel.QR_CODE));
}
if (!string.IsNullOrEmpty(searchModel.QR_NAME))
{
query = query.Where(x => x.GROUP_NAME.Contains(searchModel.QR_NAME));
}
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_NHOMDANHMUC_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 searchData(FormCollection form)
{
DM_NHOMDANHMUCBusiness = Get <DM_NHOMDANHMUCBusiness>();
var searchModel = SessionManager.GetValue("dmnhomdanhmucSearchModel") as DM_NHOMDANHMUC_SEARCHBO;
if (searchModel == null)
{
searchModel = new DM_NHOMDANHMUC_SEARCHBO();
searchModel.pageSize = 20;
}
searchModel.QR_CODE = form["QR_CODE"];
searchModel.QR_NAME = form["QR_NAME"];
SessionManager.SetValue("dmnhomdanhmucSearchModel", searchModel);
var data = DM_NHOMDANHMUCBusiness.GetDaTaByPage(searchModel, 1, searchModel.pageSize);
return(Json(data));
}
public JsonResult getData(int indexPage, string sortQuery, int pageSize)
{
DM_NHOMDANHMUCBusiness = Get <DM_NHOMDANHMUCBusiness>();
var searchModel = SessionManager.GetValue("dmnhomdanhmucSearchModel") as DM_NHOMDANHMUC_SEARCHBO;
if (!string.IsNullOrEmpty(sortQuery))
{
if (searchModel == null)
{
searchModel = new DM_NHOMDANHMUC_SEARCHBO();
}
searchModel.sortQuery = sortQuery;
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("dmnhomdanhmucSearchModel", searchModel);
}
var data = DM_NHOMDANHMUCBusiness.GetDaTaByPage(searchModel, indexPage, pageSize);
return(Json(data));
}