Esempio n. 1
0
        private string GetSqlGrid(LazyPagination pagger)
        {
            var sql = _sql ?? _gridModel.GridSql;

            sql = _filter.AddCondition(sql);

            var orderColumns = _gridModel.Column.First(x => string.Equals(x.SystemName, _gridOptions.SortOptions.Column, StringComparison.OrdinalIgnoreCase));

            string orderColumn = orderColumns.OrderByName ?? orderColumns.SystemName;

            var orderBy = new OrderByBuilder(orderColumn, _gridOptions.SortOptions.Direction).QueryResult;

            sql += Environment.NewLine + orderBy;

            sql += Environment.NewLine + pagger.GetOffestRow();

            return(sql);
        }