Beispiel #1
0
        /// <summary>
        ///  获取数据列表,高级查询
        /// </summary>
        /// <param name="queryParam"></param>
        /// <returns></returns>
        public JsonResult Query(Sys_ApplicationQueryParam queryParam)
        {
            JsonResult result = new JsonResult();

            result.Data = dalSY.Query(queryParam);
            return(result);
        }
        /// <summary>
        /// 全查询分页
        /// </summary>
        /// <param name="queryParam">自定义扩展查询参数</param>
        /// <returns></returns>
        public ListByPages <vSys_Application> Query(Sys_ApplicationQueryParam queryParam)
        {
            var query = from temp in activeContext.Sys_Application
                        where
                        (string.IsNullOrEmpty(queryParam.KeyWords) ||
                         temp.Domain.Contains(queryParam.KeyWords) ||
                         temp.VisitUrl.Contains(queryParam.KeyWords) ||
                         temp.Code.Contains(queryParam.KeyWords) ||
                         temp.Name.Contains(queryParam.KeyWords) ||
                         temp.Icon.Contains(queryParam.KeyWords))
                        select new vSys_Application
            {
                Id       = temp.Id,
                Domain   = temp.Domain,
                VisitUrl = temp.VisitUrl,
                Code     = temp.Code,
                Name     = temp.Name,
                IsFreeze = temp.IsFreeze,
                Sort     = temp.Sort,
                Icon     = temp.Icon,
            }
            ;
            var tempquery = query.ToListByPages(queryParam);

            return(tempquery);
        }
 /// <summary>
 /// 分页查询
 /// </summary>
 /// <param name="queryParam">自定义扩展查询参数</param>
 /// <returns></returns>
 public ListByPages <vSys_Application> Query(Sys_ApplicationQueryParam queryParam)
 {
     return(Dal.Query(queryParam));
 }