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;
}
