public virtual IActionResult DepartmentList(DepartmentSearchModel searchModel) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageServices)) { return(AccessDeniedKendoGridJson()); } //prepare model var model = _departmentModelFactory.PrepareListModel(searchModel); return(Json(model)); }
public ActionResult Index(int?page) { int pageIndex = PagingHelper.GetPageIndex(page); DepartmentSearchModel q = new DepartmentSearchModel(); IPagedList <Department> departments = departmentService.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; SetCompanyList(null); return(View(departments)); }
public IActionResult List() { if (!_permissionService.Authorize(EmployeePermissionProvider.ManageDepartments)) { return(AccessDeniedView()); } var model = new DepartmentSearchModel(); model.SetGridPageSize(); return(View($"{Route}{nameof(List)}.cshtml", model)); }
public virtual DepartmentSearchModel PrepareSearchModel(DepartmentSearchModel searchModel) { if (searchModel == null) { throw new ArgumentNullException(nameof(searchModel)); } //prepare page parameters searchModel.SetGridPageSize(); return(searchModel); }
public async Task <DepartmentListModel> GetByPaging(DepartmentSearchModel request) { try { var start = 1; if (request != null) { start = request.Start / request.Length + 1; } var columnOrder = "name"; var sortDir = "ASC"; var url = string.Format(ApiUrl.DEPARTMENT_GET_BY_PAGING, request.Name, request.ColumnOrder, start, request?.Length ?? 10, columnOrder, sortDir); var response = await HttpService.Send <PageResult <GetDepartmentPagingResponse> >(url, null, HttpMethod.Get, true); if (response.IsSuccess) { return new DepartmentListModel { Draw = request.Draw, RecordsFiltered = response.Data.TotalCount, Total = response.Data.TotalCount, RecordsTotal = response.Data.TotalCount, Data = response.Data.Data.Select(c => new DepartmentModel { Id = c.Id, Name = c.Name, PageSize = request.PageSize, PageSizeOptions = request.AvailablePageSizes }) } } ; throw new PeloException(response.Message); } catch (Exception exception) { throw new PeloException(exception.Message); } }
public virtual DepartmentListModel PrepareListModel(DepartmentSearchModel searchModel) { if (searchModel == null) { throw new ArgumentNullException(nameof(searchModel)); } var entities = _departmentService.GetAll(name: searchModel.SearchName, pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize, showHidden: true); //Get follow Path foreach (var template in entities) { var templateName = ""; if (template.Path != string.Empty) { var listPath = template.Path.Split(",").ToList(); List <int> listPathInt = listPath.Select(s => int.Parse(s)).ToList(); foreach (var listPathItem in listPathInt) { foreach (var templateItem in entities) { if (listPathItem == templateItem.Id) { templateName += templateItem.Name + " >> "; } } } } if (templateName != string.Empty) { templateName = templateName + template.Name; } else { templateName = template.Name; } template.PathName = templateName; } //prepare list model var model = new DepartmentListModel { //fill in model values from the entity Data = entities.Select(x => x.ToModel <DepartmentModel>()), Total = entities.Count }; return(model); }
public IQueryable <Department> Search(DepartmentSearchModel searchModel) { IQueryable <Department> departments = this.context.Department; if (!string.IsNullOrEmpty(searchModel.Name)) { departments = departments.Where(c => c.name.Contains(searchModel.Name.Trim())); } if (searchModel.CompanyId.HasValue) { departments = departments.Where(c => c.companyId.Equals(searchModel.CompanyId)); } return(departments); }
public IHttpActionResult QueryDepartment(DepartmentSearchModel search) { try { if (search == null) { return(BadRequest()); } if (search.PageIndex == 0) { search.PageIndex = 1; } if (search.PageSize == 0) { search.PageSize = 20; } if (!UserController.LoginDictionary.ContainsKey(GetCookie("token"))) { return(Logout()); } UserInfo userCookie = UserController.LoginDictionary[GetCookie("token")]; if (userCookie == null) { return(Logout()); } List <Department> departList = Department.GetAllChildren(userCookie.DepartmentID); if (!string.IsNullOrEmpty(search.DepartmentName)) { departList.FindAll(m => m.Name.Contains(search.DepartmentName)); } var result = Department.GetDepartment(search, departList.Select(m => m.ID).ToList()); if (result.Items.Count > 0) { var list = Department.GetAll(result.Items.ToList().Select(m => m.ID).ToList()); result.Items.ForEach(item => { item.ParentName = list.Find(m => m.ID == item.ParentID)?.Name; }); } return(Success(result)); } catch (Exception ex) { logger.Error(ex); return(Failure("查询失败")); } }
public ActionResult Search([Bind(Include = "Name, CompanyId")] DepartmentSearchModel q) { int pageIndex = 0; int.TryParse(Request.QueryString.Get("page"), out pageIndex); pageIndex = PagingHelper.GetPageIndex(pageIndex); IDepartmentService ds = new DepartmentService(Settings.Default.db); IPagedList <Department> departments = ds.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; SetCompanyList(q.CompanyId); return(View("Index", departments)); }
public static Page <DepartmentA> GetDepartment(DepartmentSearchModel search, List <int> depart) { var sql = "select * from Department where ID in @ID "; List <int> IDList = new List <int>(); if ((search.ParentID ?? 0) != 0) { IDList = GetChildrenID(new List <int> { search.ParentID.Value }); sql += " and ParentID in @IDs"; } using (var cn = Database.GetDbConnection()) { return(cn.PagedQuery <DepartmentA>(search.PageIndex, search.PageSize, sql, new { IDs = IDList, ID = depart })); } }
public IActionResult ListData(DepartmentSearchModel searchModel) { if (!_permissionService.Authorize(EmployeePermissionProvider.ManageDepartments)) { return(AccessDeniedView()); } var departments = _employeeService.GetOrderedDepartments(showUnpublished: true, searchModel.Page - 1, searchModel.PageSize); var model = new DepartmentListModel().PrepareToGrid(searchModel, departments, () => { return(departments.Select(department => { var d = department.ToModel(); return d; })); }); return(Json(model)); }
public IActionResult ListData(DepartmentSearchModel searchModel) { if (!_permissionService.Authorize(EmployeePermissionProvider.ManageEmployees)) { return(AccessDeniedView()); } var departmentDict = _employeeService.GetOrderedDepartments(showUnpublished: true).ToDictionary(x => x.Id, x => x); var employees = _employeeService.GetOrderedEmployees(showUnpublished: true, searchModel.Page - 1, searchModel.PageSize); var model = new EmployeeListModel().PrepareToGrid(searchModel, employees, () => { return(employees.Select(employee => { var e = employee.ToModel(); e.DepartmentName = departmentDict[e.DepartmentId].Name; e.DepartmentPublished = departmentDict[e.DepartmentId].Published; return e; })); }); return(Json(model)); }
public IQueryable <Department> Search(DepartmentSearchModel searchModel) { return(depRep.Search(searchModel)); }