private void SearchOrders(WorkStationSearchViewModel model)
{
IList <SelectListItem> selList = new List <SelectListItem>();
selList.Add(new SelectListItem {
Text = "全部", Value = "00000000-0000-0000-0000-000000000000", Selected = true
});
IList <MSDS_WorkShop> shops = _workshopService.GetAll(WorkContext.CurrentMembershipUser.Company.Id);
foreach (var item in shops)
{
selList.Add(new SelectListItem {
Text = item.WorkShop_Name, Value = item.Id.ToString(), Selected = false
});
}
model.WorkShops = selList;
Guid workshop_id = Guid.Parse(model.WorkShop_Id);
var searchModel = new WorkStationSearchModel
{
PageIndex = model.PageIndex,
PageSize = model.PageSize,
KeyWord = model.KeyWord,
WorkShop_Id = workshop_id
};
model.ViewList = _workstationService.Search(searchModel);
}
public IPagedList <MSDS_WorkStation> Search(WorkStationSearchModel searchModel)
{
var query = _context.MSDS_WorkStation.Where(x => (string.IsNullOrEmpty(searchModel.KeyWord) ||
x.WorkStation_Name.ToLower().Contains(searchModel.KeyWord.ToLower())) &&
(searchModel.WorkShop_Id == new Guid("00000000-0000-0000-0000-000000000000") || x.WorkShop.Id == searchModel.WorkShop_Id)
)
.OrderBy(x => x.WorkStation_Name);
var count = query.Count();
var result = query.Skip((searchModel.PageIndex - 1) * searchModel.PageSize).Take(searchModel.PageSize).ToList();
return(new PagedList <MSDS_WorkStation>(result, searchModel.PageIndex, searchModel.PageSize, count));
}
public IPagedList <MSDS_WorkStation> Search(WorkStationSearchModel searchModel)
{
return(_repository.Search(searchModel));
}