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); }
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; }