private List<GridViewColumn> GetCrossTabColumns(out string ColumnsSQL, out List<ASPxSummaryItem> SummaryFooter) 
        {
            //пытаемся взять значения из кеша
            List<GridViewColumn> Cols = (List<GridViewColumn>)Grid.Page.Cache["ColumnsList_id" + idObject.ToString()];
            ColumnsSQL = (string)Grid.Page.Cache["SQLList_id" + idObject.ToString()];
            SummaryFooter = (List<ASPxSummaryItem>)Grid.Page.Cache["SummaryFooter_id" + idObject.ToString()];

             //для теста
            //SummaryFooter = null;
            //List<GridViewColumn> Cols = null;
            //ColumnsSQL = "";

            //если получилось, то передаем их на выход
            if (Cols != null)
                return Cols;

            SummaryFooter = new List<ASPxSummaryItem>();

            var CaptionQueryStr = @"
                SELECT prpc.""ParamRes_id"", prpc.""NameGroup"", param_res.""Name"", rc.""Name"", rc.res_id FROM ""Tepl"".""PointRead"" pr
	            LEFT JOIN ""Tepl"".""ParamResPlc_cnt"" prpc USING (prp_id)
	            LEFT JOIN ""Tepl"".""ParametrResourse"" param_res ON param_res.""ParamRes_id"" = prpc.""ParamRes_id""
	            LEFT JOIN ""Tepl"".""Resourse_cnt"" rc ON rc.res_id = param_res.res_id
	            WHERE plc_id = ";
            CaptionQueryStr += idObject.ToString();
            CaptionQueryStr += @" ORDER BY rc.""Name"", param_res.""Name""";  //сортировки должны совпадать здесь и в crosstab

            var Reader = GetSelectSQLData(CaptionQueryStr);

            if (Reader.HasRows)
            {
                Cols = new List<GridViewColumn>();

                //первая клонка уже создана в дизайнере. Чтобы не геморроится с динамической загрузкой шаблонов из-за 4-х строчек текста 
                Cols.Add(new GridViewDataDateColumn());
                Cols[0].Assign(Grid.AllColumns[0]);
                Cols[0].FooterTemplate = Grid.AllColumns[0].FooterTemplate;

                var i = 0;
                var curGroup = "";
                List<GridViewBandColumn> BandList = new List<GridViewBandColumn>();

                while (Reader.Read())
                {
                    if (curGroup != Reader.GetString(3))
                    {
                        curGroup = Reader.GetString(3);
                        BandList.Add(new GridViewBandColumn());
                        BandList[Cols.Count - 1].Caption = curGroup;
                        Cols.Add(BandList[BandList.Count - 1]);
                    }

                    var CurrentFieldName = "field_" + i.ToString();
                    ColumnsSQL += String.Format("sum(CASE WHEN prp.\"ParamRes_id\" = {0} THEN ar.\"DataValue\" else NULL END) {1},",
                        Convert.ToString(Reader.GetInt32(0)), CurrentFieldName);

                    GridViewDataTextColumn ValueColumn = new GridViewDataTextColumn();
                    ValueColumn.Caption = Reader.GetString(2).Trim();
                    ValueColumn.FieldName = CurrentFieldName;
                    ValueColumn.PropertiesEdit.DisplayFormatString = "{0:F2}";
                    ValueColumn.VisibleIndex = Cols.Count;
                    BandList[BandList.Count - 1].Columns.Add(ValueColumn);

                    ASPxSummaryItem ColumnSummary1 = new ASPxSummaryItem(); //среднее
                    ColumnSummary1.DisplayFormat = "{0:F2}";
                    ColumnSummary1.ValueDisplayFormat = "{0:F2}";
                    ColumnSummary1.FieldName = CurrentFieldName;
                    ColumnSummary1.ShowInColumn = CurrentFieldName;
                    ColumnSummary1.SummaryType = SummaryItemType.Average;
                    SummaryFooter.Add(ColumnSummary1);

                    ASPxSummaryItem ColumnSummary2 = new ASPxSummaryItem(); //минимум
                    ColumnSummary2.DisplayFormat = "{0:F2}";
                    ColumnSummary2.FieldName = CurrentFieldName;
                    ColumnSummary2.ShowInColumn = CurrentFieldName;
                    ColumnSummary2.SummaryType = SummaryItemType.Min;
                    SummaryFooter.Add(ColumnSummary2);

                    ASPxSummaryItem ColumnSummary3 = new ASPxSummaryItem(); //максимум
                    ColumnSummary3.DisplayFormat = "{0:F2}";
                    ColumnSummary3.FieldName = CurrentFieldName;
                    ColumnSummary3.ShowInColumn = CurrentFieldName;
                    ColumnSummary3.SummaryType = SummaryItemType.Max;
                    SummaryFooter.Add(ColumnSummary3);

                    ASPxSummaryItem ColumnSummary4 = new ASPxSummaryItem(); //лимит
                    ColumnSummary4.DisplayFormat = "{0:F2}";
                    ColumnSummary4.ValueDisplayFormat = "{0:F2}";
                    ColumnSummary4.FieldName = CurrentFieldName;
                    ColumnSummary4.ShowInColumn = CurrentFieldName;
                    ColumnSummary4.SummaryType = SummaryItemType.Custom;
                    SummaryFooter.Add(ColumnSummary4);

                    i++;
                }

                Reader.Close();
                //удаляем последнюю ","
                ColumnsSQL = ColumnsSQL.Remove(ColumnsSQL.Length - 1);
            }

            //кешируем результаты 
            Grid.Page.Cache.Insert("ColumnsList_id" + idObject.ToString(), Cols, null, DateTime.Now.AddMinutes(CacheTime),
                System.Web.Caching.Cache.NoSlidingExpiration);
            Grid.Page.Cache.Insert("SQLList_id" + idObject.ToString(), ColumnsSQL, null, DateTime.Now.AddMinutes(CacheTime),
                System.Web.Caching.Cache.NoSlidingExpiration);
            Grid.Page.Cache.Insert("SummaryFooter_id" + idObject.ToString(), SummaryFooter, null, DateTime.Now.AddMinutes(CacheTime),
                System.Web.Caching.Cache.NoSlidingExpiration);

            return Cols;
        }