public JsonResult GetData(int pageIndex, string sortQuery, int pageSize) { AssignUserInfo(); bool canReceiveRegistration = currentUser.ListThaoTac .Where(x => x.MA_THAOTAC == CONFIRM_CAR_REGISTRATION).FirstOrDefault() != null; qlDangKyXeBusiness = Get <QL_DANGKY_XEBusiness>(); DangKyXeSearchBO searchModel = (DangKyXeSearchBO)SessionManager.GetValue("SearchDangKyXeBenhVien"); if (searchModel == null) { searchModel = new DangKyXeSearchBO(); } if (canReceiveRegistration) { searchModel.TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_ID; searchModel.USER_ID = currentUser.ID; searchModel.HAS_ROLE_CONFIRM = true; } searchModel.sortQuery = sortQuery; searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault(); PageListResultBO <DangKyXeBO> data = qlDangKyXeBusiness.GetDataByPage(searchModel); return(Json(data)); }
public ActionResult Index() { AssignUserInfo(); bool canReceiveRegistration = currentUser.ListThaoTac .Where(x => x.MA_THAOTAC == CONFIRM_CAR_REGISTRATION).FirstOrDefault() != null; qlDangKyXeBusiness = Get <QL_DANGKY_XEBusiness>(); DangKyXeIndexViewModel viewModel = new DangKyXeIndexViewModel(); DangKyXeSearchBO searchModel = new DangKyXeSearchBO(); searchModel.CCTC_THANHPHAN_ID = currentUser.DeptParentID.GetValueOrDefault(); if (canReceiveRegistration) { searchModel.TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_ID; searchModel.USER_ID = currentUser.ID; searchModel.HAS_ROLE_CONFIRM = true; viewModel.canReceiveRegistration = canReceiveRegistration; } viewModel.currentUserId = currentUser.ID; viewModel.listDangKyXeBenhViens = qlDangKyXeBusiness.GetDataByPage(searchModel); SessionManager.SetValue("SearchDangKyXeBenhVien", searchModel); return(View(viewModel)); }
/// <summary> /// @author: duynn /// @description: lấy danh sách đăng ký xe /// </summary> /// <param name="searchModel"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public PageListResultBO <DangKyXeBO> GetDataByPage(DangKyXeSearchBO searchModel, int pageIndex = 1, int pageSize = 20) { IQueryable <DangKyXeBO> queryResult = (from register in this.context.QL_DANGKY_XE.Where(x => x.IS_DELETE != true) join user in this.context.DM_NGUOIDUNG on register.NGUOITAO equals user.ID into group1 from g1 in group1.DefaultIfEmpty() select new DangKyXeBO() { ID = register.ID, SONGUOI = register.SONGUOI, MUCDICH = register.MUCDICH, NGAY_XUATPHAT = register.NGAY_XUATPHAT, GIO_XUATPHAT = register.GIO_XUATPHAT, PHUT_XUATPHAT = register.PHUT_XUATPHAT, NGAYSUA = register.NGAYSUA, TRANGTHAI = register.TRANGTHAI ?? 0, NGUOITAO = register.NGUOITAO, NGUOIDANGKY = g1.HOTEN, CCTC_THANHPHAN_ID = register.CCTC_THANHPHAN_ID }); if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.MUCDICH)) { searchModel.MUCDICH = searchModel.MUCDICH.Trim().ToLower(); queryResult = queryResult.Where(x => !string.IsNullOrEmpty(x.MUCDICH) && x.MUCDICH.Trim().ToLower().Contains(searchModel.MUCDICH)); } if (searchModel.queryThoiGianXuatPhatStart != null) { queryResult = queryResult.Where(x => x.NGAY_XUATPHAT >= searchModel.queryThoiGianXuatPhatStart); } if (searchModel.queryThoiGianXuatPhatEnd != null) { queryResult = queryResult.Where(x => x.NGAY_XUATPHAT <= searchModel.queryThoiGianXuatPhatEnd); } if (searchModel.querySoNguoiStart != null) { queryResult = queryResult.Where(x => x.SONGUOI >= searchModel.querySoNguoiStart); } if (searchModel.querySoNguoiEnd != null) { queryResult = queryResult.Where(x => x.SONGUOI <= searchModel.querySoNguoiEnd); } if (searchModel.CCTC_THANHPHAN_ID != null) { queryResult = queryResult.Where(x => x.CCTC_THANHPHAN_ID == searchModel.CCTC_THANHPHAN_ID.Value); } if (searchModel.HAS_ROLE_CONFIRM) { if (searchModel.TRANGTHAI != null && searchModel.USER_ID != null) { queryResult = queryResult.Where(x => x.TRANGTHAI != searchModel.TRANGTHAI || x.NGUOITAO == searchModel.USER_ID); } } if (!string.IsNullOrEmpty(searchModel.sortQuery)) { queryResult = queryResult.OrderBy(searchModel.sortQuery); } else { queryResult = queryResult.OrderByDescending(x => x.ID).ThenByDescending(x => x.NGAYSUA); } } PageListResultBO <DangKyXeBO> result = new PageListResultBO <DangKyXeBO>(); IPagedList <DangKyXeBO> pagedList = queryResult.ToPagedList(pageIndex, pageSize); result.Count = pagedList.TotalItemCount; result.TotalPage = pagedList.PageCount; result.ListItem = pagedList.ToList(); result.ListItem.ForEach(x => { if (x.NGAY_XUATPHAT != null) { x.THOIGIAN_XUATPHAT = string.Format("{0:dd/MM/yyyy}", x.NGAY_XUATPHAT); if (x.GIO_XUATPHAT != null) { x.THOIGIAN_XUATPHAT += " " + x.GIO_XUATPHAT.Value.ToString("D2") + "h"; if (x.PHUT_XUATPHAT != null) { x.THOIGIAN_XUATPHAT += x.PHUT_XUATPHAT.Value.ToString("D2"); } } } switch (x.TRANGTHAI.Value) { case TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_ID: x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_TEXT; x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.MOITAO_COLOR; break; case TRANGTHAI_DANGKY_XE_CONSTANT.DAGUI_ID: x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DAGUI_TEXT; x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DAGUI_COLOR; break; case TRANGTHAI_DANGKY_XE_CONSTANT.DA_HUY_ID: x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HUY_TEXT; x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HUY_COLOR; break; case TRANGTHAI_DANGKY_XE_CONSTANT.DANG_THUCHIEN_ID: x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DANG_THUCHIEN_TEXT; x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DANG_THUCHIEN_COLOR; break; case TRANGTHAI_DANGKY_XE_CONSTANT.DA_TIEPNHAN_ID: x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_TIEPNHAN_TEXT; x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_TIEPNHAN_COLOR; break; case TRANGTHAI_DANGKY_XE_CONSTANT.DA_HOANTHANH_ID: x.TEN_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HOANTHANH_TEXT; x.MAU_TRANGTHAI = TRANGTHAI_DANGKY_XE_CONSTANT.DA_HOANTHANH_COLOR; break; default: break; } }); return(result); }