Entity Framework 动态查询

不想多说什么直接说代码：

 

#region 搜索并分页 -LJY
        /// <summary>
        /// 传入搜索条件，当前页码，每页的显示的条数，数据的总数(输出参数)，三个参数，返回供应商实体
        /// </summary>
        /// <param name="restrain">搜索条件</param>
        /// <param name="pageindex">当前页码</param>
        /// <param name="pagesize">每页的显示的条数</param>
        /// <param name="a">数据的总数</param>
        /// <returns></returns>
        public IQueryable<Entity.供应商信息表> Pagljy(string restrain,int pageindex, int pagesize, out int a)
        {
            IQueryable<Entity.供应商信息表> customs = null;
            try
            {
                a = context.TB_CUS_SUPPLIER_INFO.Where(restrain).Count();
                if (a <= 0 || pagesize <= 0 || pageindex <= 0)
                {
                    return null;
                }
                customs = (from custom in context.TB_CUS_SUPPLIER_INFO.Where(restrain)
                           orderby custom.SUPP_ID
                           select custom
                              ).Skip((pageindex - 1) * pagesize).Take(pagesize);
            }
            catch
            {
                a = 0;
            }
            return customs;
        }

        #endregion

 

在页面调用时如果通过时间来查询，请记住一定要这样写：

 strWhere = "it.JION_TIME<datetime'" + t2 + "'";

如果少了datetime,就会出现“操作的参数类型“Edm.DateTime”和“Edm.String”不兼容”的异常