示例#1
0
        public List <m_donvi_phongban> GetListCongTruong(SearchCongTruongModel model)
        {
            CheckDbConnect();
            IQueryable <m_donvi_phongban> query = Context.m_donvi_phongban.Where(x => x.phongban_congtruong == 1);

            if (!string.IsNullOrEmpty(model.CongTruong))
            {
                query = query.Where(x => x.maphongban == model.CongTruong || x.sodienthoai.Trim().ToLower() == model.EmailThuKy.ToLower());
            }
            if (model.GiamDoc.HasValue)
            {
                int a = query.Count();

                var kq = query.ToList();

                query = query.Where(x => x.thuocquanly == model.GiamDoc.Value || x.thuocquanly1 == model.GiamDoc.Value || x.thuocquanly2 == model.GiamDoc.Value);
            }
            var result = query.ToList();

            return(result);
        }
        public ActionResult GetListCongTruong(SearchCongTruongModel model)
        {
            var result = _dataService.GetListCongTruong(model);

            return(Json(result, JsonRequestBehavior.AllowGet));
        }