/// <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);
}
