/// <summary> /// /// </summary> /// <param name="search"></param> /// <param name="status"></param> /// <param name="lstInclude"></param> /// <returns></returns> private IQueryable<ThongTinBaoModel> BuildQuery(ThongTinBaoSearchModel search, int status = 1, List<string> lstInclude = null) { string include = string.Empty; IQueryable<BThongTinBao> qThongTinBao = db.BThongTinBaos; //Neu co include thi them include vao if (lstInclude != null && lstInclude.Count > 0) foreach (string item in lstInclude) qThongTinBao = qThongTinBao.Include(item); IQueryable<ThongTinBaoModel> query = (from u in qThongTinBao.Include(a => a.DMLoaiAnPham).Include(a=>a.DMToaSoan)//.Include(a=>a.) where u.Status == status select new ThongTinBaoModel() { Id = u.Id, MaBao = u.MaBao, MaToaSoan = u.MaToaSoan, TenBao = u.TenBao, CoThue = u.CoThue, MucThue = u.MucThue.ToString(), BaoTrungUongDiaPhuong = u.BaoTrungUongDiaPhuong, BaoCongIchNgoaiCongIch = u.BaoCongIch, LoaiAnPham = u.LoaiAnPham, ParentId = u.ParentId, BaoTrongMucLuc = u.BaoTrongMucLuc, BaoNgoaiVan = u.BaoNgoaiVan, SoTrang = u.SoTrang.ToString(), KichThuoc = u.KichThuoc, TrongLuong = u.TrongLuong.ToString(), GiayPhep = u.GiayPhep, GiaVon = u.GiaVon, GiaBia = u.GiaBia.ToString(), GiaBan = u.GiaBan, Status = u.Status, GhiChu = u.GhiChu, TenLoaiAnPham = u.DMLoaiAnPham != null ? u.DMLoaiAnPham.TenLoaiAnPham : "", TenToaSoan = u.DMToaSoan != null ? u.DMToaSoan.TenToaSoan : "" }).OrderBy(a => a.TenBao); if (search != null) { if (!string.IsNullOrWhiteSpace(search.Search)) { query = query.Where(a => a.MaBao.Contains(search.Search) || a.TenBao.Contains(search.Search)); } if (!string.IsNullOrWhiteSpace(search.Id)) query = query.Where(a => a.Id.CompareTo(search.Id) == 0); if (!string.IsNullOrWhiteSpace(search.MaBao)) query = query.Where(a => a.MaBao.Contains(search.MaBao)); if (!string.IsNullOrWhiteSpace(search.MaToaSoan)) query = query.Where(a => a.MaBao.Contains(search.MaToaSoan)); if (!string.IsNullOrWhiteSpace(search.TenBao)) query = query.Where(a => a.TenBao.Contains(search.TenBao)); if (!string.IsNullOrWhiteSpace(search.GiaBia)) query = query.Where(a => a.GiaBia.Contains(search.GiaBia)); if (!string.IsNullOrWhiteSpace(search.TrongLuong)) query = query.Where(a => a.TrongLuong.Contains(search.TrongLuong)); if (!string.IsNullOrWhiteSpace(search.KichThuoc)) query = query.Where(a => a.KichThuoc.Contains(search.KichThuoc)); if (!string.IsNullOrWhiteSpace(search.GiayPhep)) query = query.Where(a => a.KichThuoc.Contains(search.GiayPhep)); } return query; }
/// <summary> /// /// </summary> /// <param name="Id"></param> /// <returns></returns> public ThongTinBaoModel getThongTinBaoById(string Id) { ThongTinBaoSearchModel search = new ThongTinBaoSearchModel() { Id = Id }; int active = (int)Enums.RecordStatusCode.active; ThongTinBaoModel item = BuildQuery(search, active, null).FirstOrDefault(); buildThongTinBao(item); return item; }
public List<ThongTinBaoModel> searchThongTinBao(ThongTinBaoSearchModel thongTinBaoSearchModel) { int active = (int)Enums.RecordStatusCode.active; return BuildQuery(thongTinBaoSearchModel, active, null).ToList(); }
public ActionResult GetMaBaoCha(string search, string pageIndex) { List<ThongTinBaoModel> value = new List<ThongTinBaoModel>(); int pageCount = 0; int totalitem = 0; if(string.IsNullOrWhiteSpace(search)) value = db.getAllModel(1, pageSizePopup, out pageCount, out totalitem); else { ThongTinBaoSearchModel searchModel = new ThongTinBaoSearchModel() { Search = search }; value = db.searchThongTinBao(searchModel); } ViewBag.Search = search; if (HttpContext.Request.IsAjaxRequest()) return PartialView("_TimKiemMaBaoCha", new PagedList<ThongTinBaoModel>(value, 1, pageSizePopup, totalitem)); return PartialView("_TimKiemMaBaoCha", new PagedList<ThongTinBaoModel>(value, 1, pageSizePopup, totalitem)); }