public override SoaDataGridGroupResponse Group(SoaDataGridGroupRequest request)
        {
            //List<object> list = new List<object>();

            //DataSet oDS = LoadData();
            //DataView oDataView = new DataView(oDS.Tables[0]);

            //oDataView.Sort = request.Groupings.ToSqlString();
            //oDataView.RowFilter = request.Filters.ToSqlString();

            //string field = request.Groupings[0].Column.Name;

            SoaDataGridGroupResponse response = new SoaDataGridGroupResponse();

            //int iGroupCount = 0;
            //object _lastValue = Guid.NewGuid();
            //for (int i = 0; i < oDataView.Count; i++)
            //{
            //    if ((_lastValue == null && oDataView[i][field] != null) ||
            //      _lastValue != null && !_lastValue.Equals(oDataView[i][field]))
            //    {
            //        _lastValue = oDataView[i][field];

            //        if (iGroupCount >= request.Offset && iGroupCount < request.Offset + request.Count)
            //        {
            //            SoaDataGridGroup oGroup = new SoaDataGridGroup();
            //            oGroup.Column = field;
            //            oGroup.GroupValue = _lastValue;

            //            response.Groups.Add(oGroup);

            //            list.Add(_lastValue);
            //        }

            //        iGroupCount++;
            //    }
            //}

            //response.GroupCount = iGroupCount;

            return(response);
        }
Esempio n. 2
0
        public override SoaDataGridGroupResponse Group(SoaDataGridGroupRequest request)
        {
            //List<object> list = new List<object>();

            //DataSet oDS = LoadData();
            //DataView oDataView = new DataView(oDS.Tables[0]);

            //oDataView.Sort = request.Groupings.ToSqlString();
            //oDataView.RowFilter = request.Filters.ToSqlString();

            //string field = request.Groupings[0].Column.Name;

            SoaDataGridGroupResponse response = new SoaDataGridGroupResponse();

            //int iGroupCount = 0;
            //object _lastValue = Guid.NewGuid();
            //for (int i = 0; i < oDataView.Count; i++)
            //{
            //    if ((_lastValue == null && oDataView[i][field] != null) ||
            //      _lastValue != null && !_lastValue.Equals(oDataView[i][field]))
            //    {
            //        _lastValue = oDataView[i][field];

            //        if (iGroupCount >= request.Offset && iGroupCount < request.Offset + request.Count)
            //        {
            //            SoaDataGridGroup oGroup = new SoaDataGridGroup();
            //            oGroup.Column = field;
            //            oGroup.GroupValue = _lastValue;

            //            response.Groups.Add(oGroup);

            //            list.Add(_lastValue);
            //        }

            //        iGroupCount++;
            //    }
            //}

            //response.GroupCount = iGroupCount;

            return response;
        }