public ActionResult Index(int id)
{
DM_THAOTACBusiness = Get <DM_THAOTACBusiness>();
DM_CHUCNANGBusiness = Get <DM_CHUCNANGBusiness>();
var searchmodel = new DM_THAOTAC_SEARCHBO();
SessionManager.SetValue("dmthaotacSearchModel", null);
var data = new IndexVM();
data.ListThaoTac = DM_THAOTACBusiness.GetDaTaByPage(id, null);
data.ChucNang = DM_CHUCNANGBusiness.Find(id);
return(View(data));
}
public JsonResult searchData(FormCollection form)
{
DM_THAOTACBusiness = Get <DM_THAOTACBusiness>();
var searchModel = SessionManager.GetValue("dmthaotacSearchModel") as DM_THAOTAC_SEARCHBO;
if (searchModel == null)
{
searchModel = new DM_THAOTAC_SEARCHBO();
searchModel.pageSize = 20;
}
searchModel.QR_MA = form["QR_MA"];
searchModel.QR_THAOTAC = form["QR_THAOTAC"];
searchModel.QR_CHUCNANGID = form["QR_ID"].ToIntOrZero();
SessionManager.SetValue("dmthaotacSearchModel", searchModel);
var data = DM_THAOTACBusiness.GetDaTaByPage(searchModel.QR_CHUCNANGID, searchModel, 1, searchModel.pageSize);
return(Json(data));
}
public JsonResult getData(int indexPage, string sortQuery, int pageSize, int idchucnang)
{
DM_THAOTACBusiness = Get <DM_THAOTACBusiness>();
var searchModel = SessionManager.GetValue("dmthaotacSearchModel") as DM_THAOTAC_SEARCHBO;
if (!string.IsNullOrEmpty(sortQuery))
{
if (searchModel == null)
{
searchModel = new DM_THAOTAC_SEARCHBO();
}
searchModel.sortQuery = sortQuery;
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("dmthaotacSearchModel", searchModel);
}
var data = DM_THAOTACBusiness.GetDaTaByPage(idchucnang, searchModel, indexPage, pageSize);
return(Json(data));
}
public PageListResultBO <DM_THAOTAC_BO> GetDaTaByPage(int idchucnang, DM_THAOTAC_SEARCHBO searchModel, int pageIndex = 1, int pageSize = 20)
{
var query = from tbl in this.context.DM_THAOTAC.Where(x => x.DM_CHUCNANG_ID == idchucnang)
select new DM_THAOTAC_BO
{
DM_THAOTAC_ID = tbl.DM_THAOTAC_ID,
MA_THAOTAC = tbl.MA_THAOTAC,
TEN_THAOTAC = tbl.TEN_THAOTAC,
TRANGTHAI = tbl.TRANGTHAI,
NGAYTAO = tbl.NGAYTAO,
NGAYSUA = tbl.NGAYSUA,
DM_CHUCNANG_ID = tbl.DM_CHUCNANG_ID,
NGUOITAO = tbl.NGUOITAO,
NGUOISUA = tbl.NGUOISUA,
MENU_LINK = tbl.MENU_LINK,
TT_HIENTHI = tbl.TT_HIENTHI,
IS_HIENTHI = tbl.IS_HIENTHI,
ICONPATH = tbl.ICONPATH,
CSSCLASS = tbl.CSSCLASS,
};
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.QR_MA))
{
query = query.Where(x => x.MA_THAOTAC.Contains(searchModel.QR_MA));
}
if (!string.IsNullOrEmpty(searchModel.QR_THAOTAC))
{
query = query.Where(x => x.TEN_THAOTAC.Contains(searchModel.QR_THAOTAC));
}
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
query = query.OrderBy(searchModel.sortQuery);
}
else
{
query = query.OrderByDescending(x => x.DM_THAOTAC_ID);
}
}
else
{
query = query.OrderByDescending(x => x.DM_THAOTAC_ID);
}
var resultmodel = new PageListResultBO <DM_THAOTAC_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);
}
