private IQueryable<UnitModel2> BuildQuery(UnitModel2Search search, List<string> lstInclude = null) { string include = string.Empty; IQueryable<Unit> qUnit = db.Units; //Neu co include thi them include vao if (lstInclude != null && lstInclude.Count > 0) foreach (string item in lstInclude) qUnit = qUnit.Include(item); IQueryable<UnitModel2> query = (from u in qUnit select new UnitModel2() { UnitCode = u.UnitCode, UnitName = u.UnitName, ParentUnitCode = u.ParentUnitCode, CommuneCode = u.CommuneCode, UnitTypeCode = u.UnitTypeCode, Commune = u.Commune, POS = u.POS, Unit1 = u.Unit1, Unit2 = u.Unit2, UnitType = u.UnitType, UserInfoes = u.UserInfoes, BDiemTiepNhans = u.BDiemTiepNhans, BPhanHuongNhuCaus = u.BPhanHuongNhuCaus, BThongTinBaos = u.BThongTinBaos, BDieuChinhPhanHuongUnits = u.BDieuChinhPhanHuongUnits }); if (search != null) { if (!string.IsNullOrWhiteSpace(search.UnitCode)) query = query.Where(a => a.UnitCode.Contains(search.UnitCode)); if (!string.IsNullOrWhiteSpace(search.UnitName)) query = query.Where(a => a.UnitName.Contains(search.UnitName)); } return query; }
public List<UnitModel2> getUnitModelSearchPager(UnitModel2Search objSearch, int page, int pageSize, out int pageCount) { return objUnitBussiness.getSearchPager(objSearch, page, pageSize,out pageCount); }
public List<UnitModel2> getUnitModelSearch(UnitModel2Search objSearch) { return objUnitBussiness.getSearch(objSearch); }
public List<UnitModel2> getSearchPager(UnitModel2Search objSearch, int page, int pageSize, out int pageCount) { return Utils.buildPage(BuildQuery(objSearch), page, ref pageSize, out pageCount); }
public List<UnitModel2> getSearch(UnitModel2Search objSearch) { List<UnitModel2> lst = new List<UnitModel2>(); lst = BuildQuery(objSearch).ToList(); return lst; }