private PagedList<ProjectPlanCollection> QueryListData(ProjectPlanCollectionSearch searchModel)
{
int recordCount = 0;
int pageSize = ConstantManager.PageSize;
ProjectPlanCollectionService service = new ProjectPlanCollectionService();
string Group = searchModel.IsAsc ? searchModel.SortBy : searchModel.SortBy + " Descending";
IList<ProjectPlanCollection> allEntities = service.QueryByPage(this.GetSearchFilter(searchModel), Group, pageSize, searchModel.PageIndex + 1, out recordCount);
var formCondition = "var condition=" + JsonConvert.SerializeObject(searchModel);
return new PagedList<ProjectPlanCollection>(allEntities, searchModel.PageIndex, pageSize, recordCount, "Id", "Id", formCondition);
}
private void LoadSearchViewBag(ProjectPlanCollectionSearch searchModel)
{
#region sort
ViewBag.IsAsc = !searchModel.IsAsc;
ViewBag.SortBy = searchModel.SortBy;
#endregion
var projectplanService = new ProjectPlanService();
if (!searchModel.ProjectPlanId.HasValue)
{
ViewBag.ProjectPlanId = new SelectList(projectplanService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ProjectPlanId = new SelectList(projectplanService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ProjectPlanId);
}
var contractService = new ContractService();
if (!searchModel.ContractId.HasValue)
{
ViewBag.ContractId = new SelectList(contractService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ContractId = new SelectList(contractService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ContractId);
}
var orgchartService = new OrgChartService();
if (!searchModel.OrgChartId.HasValue)
{
ViewBag.OrgChartId = new SelectList(orgchartService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.OrgChartId = new SelectList(orgchartService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.OrgChartId);
}
var datadictionaryService = new DataDictionaryService();
if (!searchModel.BidTypeId.HasValue)
{
ViewBag.BidTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.BidTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.BidTypeId);
}
var departmentService = new DepartmentService();
if (!searchModel.DepartmentId.HasValue)
{
ViewBag.DepartmentId = new SelectList(departmentService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.DepartmentId = new SelectList(departmentService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.DepartmentId);
}
var employeeService = new EmployeeService();
if (!searchModel.ResearchOwnerEmployeeId.HasValue)
{
ViewBag.ResearchOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ResearchOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ResearchOwnerEmployeeId);
}
if (!searchModel.EngeerEmployeeId.HasValue)
{
ViewBag.EngeerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.EngeerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.EngeerEmployeeId);
}
if (!searchModel.CostOwnerEmployeeId.HasValue)
{
ViewBag.CostOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.CostOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.CostOwnerEmployeeId);
}
if (!searchModel.AuthorEmployeeId.HasValue)
{
ViewBag.AuthorEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.AuthorEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.AuthorEmployeeId);
}
if (!searchModel.OrganizerEmployeeId.HasValue)
{
ViewBag.OrganizerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.OrganizerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.OrganizerEmployeeId);
}
}
public ActionResult SearchListPartialView(ProjectPlanCollectionSearch searchModel)
{
#region sort
ViewBag.IsAsc = !searchModel.IsAsc;
ViewBag.SortBy = searchModel.SortBy;
#endregion
return PartialView("SearchListPartialView",this.QueryListData(searchModel));
}
private Expression<Func<ProjectPlanCollection, bool>> GetSearchFilter(ProjectPlanCollectionSearch searchModel)
{
Expression<Func<ProjectPlanCollection, bool>> filter = p => p.IsActive=="1" ;
if (searchModel.ProjectPlanId.HasValue)
{
filter = filter.And(q => q.ProjectPlanId == searchModel.ProjectPlanId.Value);
}
if (searchModel.ContractId.HasValue)
{
filter = filter.And(q => q.ContractId == searchModel.ContractId.Value);
}
if (searchModel.OrgChartId.HasValue)
{
filter = filter.And(q => q.OrgChartId == searchModel.OrgChartId.Value);
}
if (searchModel.BidTypeId.HasValue)
{
filter = filter.And(q => q.BidTypeId == searchModel.BidTypeId.Value);
}
if (searchModel.DepartmentId.HasValue)
{
filter = filter.And(q => q.DepartmentId == searchModel.DepartmentId.Value);
}
if (searchModel.ResearchOwnerEmployeeId.HasValue)
{
filter = filter.And(q => q.ResearchOwnerEmployeeId == searchModel.ResearchOwnerEmployeeId.Value);
}
if (searchModel.EngeerEmployeeId.HasValue)
{
filter = filter.And(q => q.EngeerEmployeeId == searchModel.EngeerEmployeeId.Value);
}
if (searchModel.CostOwnerEmployeeId.HasValue)
{
filter = filter.And(q => q.CostOwnerEmployeeId == searchModel.CostOwnerEmployeeId.Value);
}
if (searchModel.AuthorEmployeeId.HasValue)
{
filter = filter.And(q => q.AuthorEmployeeId == searchModel.AuthorEmployeeId.Value);
}
if (searchModel.OrganizerEmployeeId.HasValue)
{
filter = filter.And(q => q.OrganizerEmployeeId == searchModel.OrganizerEmployeeId.Value);
}
return filter;
}
//
// GET: /ProjectPlanCollection/
//[PermissionFilter]
public ViewResult Index(ProjectPlanCollectionSearch searchModel)
{
this.LoadSearchViewBag(searchModel);
return View(this.QueryListData(searchModel));
}
