Asp.Net 中实现DataGrid指定列的聚合功能,支持模板列聚合

  /// <summary>
  /// 纵向合并指定列的相同文本单元格  
  /// </summary>
  /// <usage>
  /// MergeSameCellAtTextColumn(DataGridInstance,columnIndex);
  /// </usage>
  /// <param name="curGrid"></param>
  /// <param name="columnIndex"></param>
  private void MergeSameCellAtTextColumn(DataGrid curGrid,int columnIndex)
  {
   DataGridItem  curItem = null;
   DataGridItem  nextItem = null;
   for (int r = 0; r < curGrid.Items.Count; r++)
   {
    ///当前单元格
    curItem = curGrid.Items[r];
    ///其下单元格
    if(r + 1 < curGrid.Items.Count)
     nextItem = curGrid.Items[r + 1];
    else
     nextItem = null;
    string curValue = curItem == null ? string.Empty:curItem.Cells[columnIndex].Text;
    string nextValue = nextItem == null ? string.Empty:nextItem.Cells[columnIndex].Text;
    ///如果单元格内容相同
    if(curValue != string.Empty && nextValue != string.Empty && curValue == nextValue)
    {
     
     ///设置其下单元格不可见
     if(nextValue != null)nextItem.Cells[columnIndex].Visible = false;
     ///如果当前单元格可见,则将其RowSpan + 1
     if(curItem.Cells[columnIndex].Visible == true)
     {
      curItem.Cells[columnIndex].RowSpan += 1;      
     }
      ///如果当前单元格不可见,则直接回溯到其上第一个可见单元格为止
     else if(curItem.Cells[columnIndex].Visible == false)
     {
      int preRowIndex = r;
      while(preRowIndex >= 0 && curGrid.Items[preRowIndex].Cells[columnIndex].Visible == false)
      {
       preRowIndex -= 1;
      }
      ///将其上第一个可见单元格的RowSpan + 1
      curGrid.Items[preRowIndex].Cells[columnIndex].RowSpan += 1;
     }
    } 
    ///如果单元格内容不同
    else if(curValue != string.Empty && nextValue != string.Empty && curValue != nextValue)
    {
     ///判断是否是临界行:上面的一行或多行与下面的一行或多行的对应单元格内容不同
     if(curItem.Cells[columnIndex].Visible == false)
     {
      int preRowIndex = r;
      while(preRowIndex >= 0 && curGrid.Items[preRowIndex].Cells[columnIndex].Visible == false)
      {
       preRowIndex -= 1;
      }
      ///将其上第一个可见单元格的RowSpan + 1
      curGrid.Items[preRowIndex].Cells[columnIndex].RowSpan += 1;
     }     
     else
     {
      ///非临界
     }
    }
    ///数据列表的最后一行
    else if(r == curGrid.Items.Count - 1 && curItem.Cells[columnIndex].Visible == false)
    {
     int preRowIndex = r;
     while(preRowIndex >= 0 && curGrid.Items[preRowIndex].Cells[columnIndex].Visible == false)
     {
      preRowIndex -= 1;
     }
     ///将其上第一个可见单元格的RowSpan + 1
     curGrid.Items[preRowIndex].Cells[columnIndex].RowSpan += 1;
    }
   }
   
  } 
  /// <summary>
  /// 纵向合并指定列的相同模板单元格
  /// </summary>
  /// <usage>
  /// MergeSameCellAtTemplateColumn(DataGridInstance,"TemplateControlId",columnIndex);
  /// </usage>
  /// <param name="curGrid"></param>
  /// <param name="columnIndex"></param>
  /// <param name="controlName"></param>
  private void MergeSameCellAtTemplateColumn(DataGrid curGrid,int columnIndex,string controlName)
  {
   DataGridItem  curItem = null;
   DataGridItem  nextItem = null;
   for (int r = 0; r < curGrid.Items.Count; r++)
   {
    ///当前单元格
    curItem = curGrid.Items[r];
    ///其下单元格
    if(r + 1 < curGrid.Items.Count)
     nextItem = curGrid.Items[r + 1];
    else
     nextItem = null;
    ///调用时注意修改此处的模板控件类型和模板控件获取值的方法
    string curValue = curItem == null ? string.Empty:((ListBox)curItem.FindControl(controlName)).SelectedText;
    string nextValue = nextItem == null ? string.Empty:((ListBox)nextItem.FindControl(controlName)).SelectedText;
    ///如果单元格内容相同
    if(curValue != string.Empty && nextValue != string.Empty && curValue == nextValue)
    {
     ///设置其下单元格不可见
     if(nextValue != null)nextItem.Cells[columnIndex].Visible = false;
     ///如果当前单元格可见,则将其RowSpan + 1
     if(curItem.Cells[columnIndex].Visible == true)
     {
      curItem.Cells[columnIndex].RowSpan += 1;      
     }
      ///如果当前单元格不可见,则直接回溯到其上第一个可见单元格为止
     else if(curItem.Cells[columnIndex].Visible == false)
     {
      int preRowIndex = r;
      while(preRowIndex >= 0 && curGrid.Items[preRowIndex].Cells[columnIndex].Visible == false)
      {
       preRowIndex -= 1;
      }
      ///将其上第一个可见单元格的RowSpan + 1
      curGrid.Items[preRowIndex].Cells[columnIndex].RowSpan += 1;
     }
    } 
    ///如果单元格内容不同
    else if(curValue != string.Empty && nextValue != string.Empty && curValue != nextValue)
    {
     ///判断是否是临界行:上面的一行或多行与下面的一行或多行的对应单元格内容不同
     if(curItem.Cells[columnIndex].Visible == false)
     {
      int preRowIndex = r;
      while(preRowIndex >= 0 && curGrid.Items[preRowIndex].Cells[columnIndex].Visible == false)
      {
       preRowIndex -= 1;
      }
      ///将其上第一个可见单元格的RowSpan + 1
      curGrid.Items[preRowIndex].Cells[columnIndex].RowSpan += 1;
     }
     else
     {
      ///非临界
     }
    }
    ///数据列表的最后一行
    else if(r == curGrid.Items.Count - 1 && curItem.Cells[columnIndex].Visible == false)
    {
     int preRowIndex = r;
     while(preRowIndex >= 0 && curGrid.Items[preRowIndex].Cells[columnIndex].Visible == false)
     {
      preRowIndex -= 1;
     }
     ///将其上第一个可见单元格的RowSpan + 1
     curGrid.Items[preRowIndex].Cells[columnIndex].RowSpan += 1;
    }
   }
   
  }