コード例 #1
0
 public static IQueryable <T> ApplyFilterAndSort <T>(IQueryable <T> query, ModelProperty[] properties,
                                                     DataTablesRequest dtRequest)
 {
     query = ApplyTableFilter(query, properties, dtRequest);
     query = ApplyColumnFilter(query, properties, dtRequest);
     query = ApplyOrderBy(query, properties, dtRequest);
     return(query);
 }
コード例 #2
0
 private static IQueryable <T> ApplyColumnFilter <T>(IQueryable <T> query, ModelProperty[] properties,
                                                     DataTablesRequest dtRequest)
 {
     foreach (var sc in dtRequest.Columns.Where(s => s.Searchable && s.Search.Value != "").Select(s => s))
     {
         var searchValue = sc.Search.Value;
         var property    = properties.First(c => c.Name == sc.Data);
         var builder     = new DataTablesWhereBuilder();
         builder.AddFilter(property, searchValue);
         query = query.Where(string.Join(" or ", builder.DynamicLinqString),
                             builder.DynamicLinqParameters.ToArray());
     }
     return(query);
 }
コード例 #3
0
        public DatatablesRepsonse GetResponse <TSource>(IQueryable <TSource> query, DataTablesRequest param)
        {
            var totalRecords = query.Count(); //Execute this query

            var modelProperties = ModelProperties <TSource> .Properties;

            query = DataTablesFiltering.ApplyFilterAndSort(query, modelProperties, param);
            var totalDisplayRecords = query.Count(); //Execute this query

            var skipped = query.Skip(param.Start);
            var data    = (param.Length <= 0 ? skipped : skipped.Take(param.Length)).ToArray(); //Execute this query

            return(new DatatablesRepsonse
            {
                recordsTotal = totalRecords,
                recordsFiltered = totalDisplayRecords,
                draw = param.Draw,
                data = data.Cast <object>().ToArray(),
            });
        }
コード例 #4
0
        private static IQueryable <T> ApplyOrderBy <T>(IQueryable <T> query, ModelProperty[] columns,
                                                       DataTablesRequest dtParameters)
        {
            var sortString = "";

            for (var i = 0; i < dtParameters.Order.Count(); i++)
            {
                var columnNumber = dtParameters.Order[i].Column;
                var sortDir      = dtParameters.Order[i].Dir;
                var columnName   = dtParameters.Columns[columnNumber].Data;
                if (i != 0)
                {
                    sortString += ", ";
                }
                sortString += columnName + " " + sortDir;
            }
            if (string.IsNullOrWhiteSpace(sortString))
            {
                sortString = columns[0].Name;
            }
            query = query.OrderBy(sortString);
            return(query);
        }
コード例 #5
0
        public JsonResult GetJSonResult <TSource>(IQueryable <TSource> query, DataTablesRequest param)
        {
            var result = GetResponse(query, param);

            return(new JsonResult(result));
        }