public List<BPhanHuongNhuCauModel> searchModel(DMToaSoanSearchModel obj) { throw new NotImplementedException(); }
public List<BPhanHuongNhuCauModel> searchModel(DMToaSoanSearchModel obj, int page, int pageSize, out int pageCount, out int totalitem) { throw new NotImplementedException(); }
/*** * function: SearchModel() * param : string MaDiemIn, int page, int pageSize, out int pageCount * result: List<DMDiemIn> * author: vietvb * Tìm kiếm theo mã điểm in, tên điểm in và phân trang * */ public List<DMToaSoanModel> searchModel(DMToaSoanSearchModel obj, int page, int pageSize, out int pageCount, out int totalitem) { List<DMToaSoanModel> result = new List<DMToaSoanModel>(); IEnumerable<DMToaSoanModel> query = null; query = (from t in db.DMToaSoans where t.Status == (int)Enums.RecordStatusCode.active select new DMToaSoanModel() { Id = t.Id, MaToaSoan = t.MaToaSoan, TenToaSoan = t.TenToaSoan, DiaChi = t.DiaChi, SoDienThoai = t.SoDienThoai, Email = t.Email, Web = t.Web, MaSoThue = t.MaSoThue, TaiKhoan = t.TaiKhoan, TongBienTap = t.TongBienTap, NguoiDaiDien = t.NguoiDaiDien, CoQuanChuQuan = t.CoQuanChuQuan, Status = t.Status, KieuToaSoan = t.KieuToaSoan, NganHang = t.NganHang }); if (!String.IsNullOrEmpty(obj.MaToaSoan)) { query = query.Where(r => r.MaToaSoan.ToLower().Contains(obj.MaToaSoan.ToLower())); } if (!String.IsNullOrEmpty(obj.TenToaSoan)) { query = query.Where(r => r.TenToaSoan.ToLower().Contains(obj.TenToaSoan.ToLower())); } if (!String.IsNullOrEmpty(obj.SoDienThoai)) { query = query.Where(r => r.SoDienThoai.ToLower().Contains(obj.SoDienThoai.ToLower())); } if (query != null) { int count = query.Count(); totalitem = count; //neu khong co du lieu thi return if (count == 0) { pageCount = 0; return result; } //pageSize nho hon 10 thi dat bang 10 if (pageSize < 10) pageSize = 2; //tinh pagecount pageCount = count / pageSize; //Neu so luong con du thi tang pagecount len 1 if (count % pageSize > 0) pageCount++; //Neu trang hien tai lon hon pagecount thi thiet lap bang pageCount-1 if (page >= pageCount) page = pageCount - 1; else page = page - 1;//So trang bat dau tu 0 result = query.OrderBy(i => i.MaToaSoan).Skip(page * pageSize).Take(pageSize).ToList(); return result; } else { totalitem = 0; pageCount = 0; return result; } }
/*** * function: Search() * param : DMToaSoanSearchModel * result: List<DMDiemIn> * author: vietvb * Tìm kiếm theo mã điểm in, tên điểm in và phân trang * */ public List<DMToaSoanModel> searchModel(DMToaSoanSearchModel obj) { List<DMToaSoanModel> result = new List<DMToaSoanModel>(); IEnumerable<DMToaSoanModel> query = null; query = (from t in db.DMToaSoans where t.Status == 1 select new DMToaSoanModel() { Id = t.Id, MaToaSoan = t.MaToaSoan, TenToaSoan = t.TenToaSoan, DiaChi = t.DiaChi, SoDienThoai = t.SoDienThoai, Email = t.Email, Web = t.Web, MaSoThue = t.MaSoThue, TaiKhoan = t.TaiKhoan, TongBienTap = t.TongBienTap, NguoiDaiDien = t.NguoiDaiDien, CoQuanChuQuan = t.CoQuanChuQuan, Status = t.Status, KieuToaSoan = t.KieuToaSoan, NganHang = t.NganHang }); if (!String.IsNullOrEmpty(obj.MaToaSoan)) { query = query.Where(r => r.MaToaSoan.Contains(obj.MaToaSoan)); } if (!String.IsNullOrEmpty(obj.TenToaSoan)) { query = query.Where(r => r.TenToaSoan.Contains(obj.TenToaSoan)); } if (!String.IsNullOrEmpty(obj.SoDienThoai)) { query = query.Where(r => r.SoDienThoai.Contains(obj.SoDienThoai)); } if (query != null) { int count = query.Count(); //neu khong co du lieu thi return result = query.ToList(); return result; } else { return result; } }
public List<BDieuChinhPhanHuongUnitModel> searchModel(DMToaSoanSearchModel obj) { throw new NotImplementedException(); }