Example #1
0
        public override void ExecuteQuery()
        {
            ReportFromQueryData.JoinDatatableInQuery();
            while (ReportFromQueryData.ThreadExcecuteData.IsAlive)
            {
            }

            ResultDatatable = ReportFromQueryData.ExecuteDataTable;

            // order column by group -> not group
            var listColumnOrder = ReportFromQueryData.ListFieldToGroup.ToList();

            listColumnOrder.AddUniqueRange(ReportFromQueryData.ListAllFields);

            ResultDatatable.SetColumnsOrder(listColumnOrder.Select(f => f.FieldName).ToArray());
            ResultDatatable.SortByColumns(ReportFromQueryData.ListFieldToGroup.Select(f => f.FieldName).ToArray());

            NumFieldToGroup = ReportFromQueryData.ListFieldToGroup.Count;
        }