/// <summary> /// /// </summary> /// <param name="id">id luồng xử lý</param> /// <returns></returns> public ActionResult Index(int id) { var model = new IndexVM(); WF_STATEBusiness = Get <WF_STATEBusiness>(); var WF_STREAMBusiness = Get <WF_STREAMBusiness>(); var searchmodel = new WF_STATE_SEARCHBO(); SessionManager.SetValue("wfstateSearchModel", null); model.LuongXuLy = WF_STREAMBusiness.GetDaTaByID(id); model.LstState = WF_STATEBusiness.GetDaTaByPage(id, null); return(View(model)); }
public JsonResult searchData(FormCollection form) { WF_STATEBusiness = Get <WF_STATEBusiness>(); var searchModel = SessionManager.GetValue("wfstateSearchModel") as WF_STATE_SEARCHBO; if (searchModel == null) { searchModel = new WF_STATE_SEARCHBO(); searchModel.pageSize = 20; } var idStream = form["QR_WF_ID"].ToIntOrZero(); searchModel.QR_STATE_NAME = form["QR_STATE_NAME"].ToString(); searchModel.QR_GHICHU = form["QR_GHICHU"].ToString(); SessionManager.SetValue("wfstateSearchModel", searchModel); var data = WF_STATEBusiness.GetDaTaByPage(idStream, searchModel, 1, searchModel.pageSize); return(Json(data)); }
public JsonResult getData(int idStream, int indexPage, string sortQuery, int pageSize) { WF_STATEBusiness = Get <WF_STATEBusiness>(); var searchModel = SessionManager.GetValue("wfstateSearchModel") as WF_STATE_SEARCHBO; if (!string.IsNullOrEmpty(sortQuery)) { if (searchModel == null) { searchModel = new WF_STATE_SEARCHBO(); } searchModel.sortQuery = sortQuery; if (pageSize > 0) { searchModel.pageSize = pageSize; } SessionManager.SetValue("wfstateSearchModel", searchModel); } var data = WF_STATEBusiness.GetDaTaByPage(idStream, searchModel, indexPage, pageSize); return(Json(data)); }
public PageListResultBO <WF_STATE_BO> GetDaTaByPage(int idStream, WF_STATE_SEARCHBO searchModel, int pageIndex = 1, int pageSize = 20) { var query = from tbl in this.context.WF_STATE where tbl.WF_ID == idStream join tblFunction in this.context.WF_STATE_FUNCTION on tbl.ID equals tblFunction.WF_STATE_ID into jstatefunction from statefunction in jstatefunction.DefaultIfEmpty() join tblChucVu in this.context.DM_DANHMUC_DATA on tbl.CHUCVU_ID equals tblChucVu.ID into jChucVu from chucVu in jChucVu.DefaultIfEmpty() join tblVaiTro in this.context.DM_VAITRO on tbl.VAITRO_ID equals tblVaiTro.DM_VAITRO_ID into jVaiTro from vaiTro in jVaiTro.DefaultIfEmpty() select new WF_STATE_BO { ID = tbl.ID, WF_ID = tbl.WF_ID, STATE_NAME = tbl.STATE_NAME, GHICHU = tbl.GHICHU, IS_KETTHUC = tbl.IS_KETTHUC, create_at = tbl.create_at, create_by = tbl.create_by, edit_at = tbl.edit_at, edit_by = tbl.edit_by, FunctionID = statefunction.ACTION, FunctionName = statefunction != null?this.context.WF_FUNCTION.Where(x => x.ID == statefunction.ACTION).Select(x => x.FUNTION_TITLE).FirstOrDefault() : "", IS_START = tbl.IS_START, ChucVu = chucVu != null ? chucVu.TEXT : "", VaiTro = vaiTro != null ? vaiTro.TEN_VAITRO : "" }; if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.QR_STATE_NAME)) { query = query.Where(x => x.STATE_NAME.Contains(searchModel.QR_STATE_NAME)); } if (!string.IsNullOrEmpty(searchModel.QR_GHICHU)) { query = query.Where(x => x.GHICHU.Contains(searchModel.QR_GHICHU)); } 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 <WF_STATE_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); }