Ejemplo n.º 1
0
        public PG <Conf> GetQueryPaging(Conf_filter paging = null, Expression <Func <VD.Data.Entity.Conf, bool> > where = null)
        {
            IQueryable <Conf> query;

            //PHÂN QUYỀN ĐỒ
            query = GetList(where);


            //SORTING
            query = query.OrderByField(paging.tentruongsort, paging.giatrisort == "asc");

            //FILTERING
            if (paging.bolocs != null)
            {
                foreach (var loc in paging.bolocs)
                {
                    if (loc.tentruongloc.Equals("full_text_search"))
                    {
                        boloc loc1 = loc;
                        query = query.FullTextSearch(loc1.giatriloc, true);
                    }
                    else
                    {
                        if (loc.tentruongloc.Equals("Key"))
                        {
                            boloc loc1 = loc;
                            query = query.Where(q => q.Key.Contains(loc1.giatriloc));
                        }
                    }
                }
            }
            return((new PGQuery <Conf>(query)).GetPG(paging));
        }
 public PartialViewResult ajax_paging(Conf_filter paging)
 {
     return(PartialView(_confServ.GetQueryPaging(paging)));
 }