private IQueryable<ThongTinGiaBaoModel> BuildQuery(ThongTinGiaBaoSearchModel search, string idBao, int status = 1, List<string> lstInclude = null) { string include = string.Empty; IQueryable<BThongTinGiaBao> qThongTinGiaBao = db.BThongTinGiaBaos; if (lstInclude != null && lstInclude.Count > 0) foreach (string item in lstInclude) qThongTinGiaBao = qThongTinGiaBao.Include(item); IQueryable<ThongTinGiaBaoModel> query = (from u in qThongTinGiaBao//.Include(a=>a.) where u.Status == status && u.ThongTinBaoId == idBao select new ThongTinGiaBaoModel() { Id = u.Id, ThongTinBaoId = u.ThongTinBaoId, NgayHieuLuc = u.NgayHieuLuc, NgayHetHieuLuc = u.NgayHetHieuLuc, ProvinceCode = u.ProvinceCode, QuyetDinh = u.QuyetDinh, ValueType = u.ValueType, Value = u.Value.ToString(), MaBao = u.BThongTinBao != null ? u.BThongTinBao.MaBao : "", TenBao = u.BThongTinBao != null ? u.BThongTinBao.TenBao : "", BaoTrungUongDiaPhuong = u.BThongTinBao.BaoTrungUongDiaPhuong, BaoTrongMucLuc = u.BThongTinBao.BaoTrongMucLuc }).OrderBy(a => a.Id); //Neu co include thi them include vao if (lstInclude != null && lstInclude.Count > 0) foreach (string item in lstInclude) qThongTinGiaBao = qThongTinGiaBao.Include(item); if (search != null) { if (!string.IsNullOrWhiteSpace(search.Search)) { //string giaFrom = search.Search.Trim().Split(',')[0]; //string giaTo = search.Search.Trim().Split(',')[1]; //query = query.Where(a => Convert.ToDecimal(a.Value) >= Convert.ToDecimal(giaFrom) && Convert.ToDecimal(a.Value) <= Convert.ToDecimal(giaTo)); query = query.Where(a => a.MaBao.Contains(search.Search) || a.TenBao.Contains(search.Search)); } if (!string.IsNullOrWhiteSpace(search.Value)) query = query.Where(a=>a.Value.CompareTo(search.Value)==0); if (!string.IsNullOrWhiteSpace(search.Id)) query = query.Where(a => a.Id.CompareTo(search.Id) == 0); if (!string.IsNullOrWhiteSpace(search.ThongTinBaoId)) query = query.Where(a => a.ThongTinBaoId.Contains(search.ThongTinBaoId)); } return query; }
private IQueryable<BThongTinGiaBaoModel> BuildQuery(ThongTinGiaBaoSearchModel search, int status = 1, List<string> lstInclude = null) { string include = string.Empty; IQueryable<BThongTinGiaBao> qThongTinGiaBao = db.BThongTinGiaBaos; if (lstInclude != null && lstInclude.Count > 0) foreach (string item in lstInclude) qThongTinGiaBao = qThongTinGiaBao.Include(item); IQueryable<BThongTinGiaBaoModel> query = (from u in qThongTinGiaBao//.Include(a=>a.) where u.Status == status select new BThongTinGiaBaoModel() { Id = u.Id, ThongTinBaoId = u.ThongTinBaoId, NgayHieuLuc = u.NgayHieuLuc, NgayHetHieuLuc = u.NgayHetHieuLuc, ProvinceCode = u.ProvinceCode, QuyetDinh = u.QuyetDinh, ValueType = u.ValueType, Value = u.Value, MaBao = u.BThongTinBao != null ? u.BThongTinBao.MaBao : "", TenBao = u.BThongTinBao != null ? u.BThongTinBao.TenBao : "" }).OrderBy(a => a.ThongTinBaoId); //Neu co include thi them include vao if (lstInclude != null && lstInclude.Count > 0) foreach (string item in lstInclude) qThongTinGiaBao = qThongTinGiaBao.Include(item); if (search != null) { if (!string.IsNullOrWhiteSpace(search.Id)) query = query.Where(a => a.Id.CompareTo(search.Id) == 0); if (!string.IsNullOrWhiteSpace(search.ThongTinBaoId)) query = query.Where(a => a.ThongTinBaoId.Contains(search.ThongTinBaoId)); } return query; }
public List<ThongTinGiaBaoModel> searchThongTinGiaBao(ThongTinGiaBaoSearchModel thongTinGiaBaoSearchModel) { int active = (int)Enums.RecordStatusCode.active; return BuildQuery(thongTinGiaBaoSearchModel, null, active, null).ToList(); }
public List<BThongTinGiaBaoModel> searchThongTinGiaBao(ThongTinGiaBaoSearchModel thongTinGiaBaoSearchModel) { int active = (int)Enums.RecordStatusCode.active; return BuildQuery(thongTinGiaBaoSearchModel, active, null).ToList(); // throw new NotImplementedException(); }