sqlsugar进行单个表聚合搜索时 sql语句用法 .net

简单记录：sqlsugar 搜索
后台代码：加上了layui要用的分页，不使用layui框架忽略掉就可

 public void QueryTableData(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            int total = 0;//用来存储总数
            var pageIndex = int.Parse(context.Request.Params["page"]);//当前页面
            var pageSize = int.Parse(context.Request.Params["limit"]);//当前页面显示条数

            var QueryContent = context.Request.Params["selectcontent"]; //搜索的内容
            var SearchLiebe = context.Request.Params["SearchLiebe"]; //内容的所属类别

            var PagingOnCustomerInfo = DbContext.Queryable<T_CustomerInfo>().ToPageList(pageIndex, pageSize, ref total);

            
            var Get = DbContext.Queryable<T_CustomerInfo>().With(SqlWith.NoLock)//.With(SqlWith.NoLock) 不锁表查询 以后查询代码 必须加上这句话
                    .WhereIF(SearchLiebe == "1", it => it.ID == int.Parse(QueryContent))
                    .WhereIF(SearchLiebe == "2", it => it.CustomerName.Contains(QueryContent))
                    .WhereIF(SearchLiebe == "3", it => it.CustomerAge == int.Parse(QueryContent))
                    .WhereIF(SearchLiebe == "4", it => it.CustomerAddress.Contains(QueryContent))
                    .WhereIF(SearchLiebe == "5", it => it.CustomerPhone.Contains(QueryContent))
                    .WhereIF(SearchLiebe == "6", it => it.CustomerRemarks.Contains(QueryContent))
                    .ToPageList(pageIndex, pageSize, ref total);
            if (Get.Count == 0)
            {
                Get = DbContext.Queryable<T_CustomerInfo>().ToPageList(pageIndex, pageSize, ref total);
            }
            var reurt = new { code = 0, count = total, msg = "", data = Get };
            context.Response.Write(JsonConvert.SerializeObject(reurt));
            
            DbContext.Close();
        }