SPGridView 研究笔记 Part 3 - 分组

最新推荐文章于 2019-08-09 19:29:42 发布

原创最新推荐文章于 2019-08-09 19:29:42 发布 · 2.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#server #asp

本文探讨了SPGridView的数据分组功能，介绍了如何通过设置AllowGrouping和GroupField属性实现页面内的数据分组效果。同时，针对如何为分组列添加链接和菜单的需求，文章提到了需要使用SPMenuField和MenuTemplate，并且由于GroupMenu的特殊性，这部分通常需要在代码中进行添加。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SPGridView提供数据分组显示功能, 但是只能将页面内数据分组. 只要设置 AllowGrouping(true), GroupField(某列名) 就能实现下面的效果.

如果需要给分组的列加链接加菜单的话, 就得再设置GroupMenu. GroupMenu需要一个SPMenuField对象, 而SPMenuField又需要一个MenuTemplate.

所以我们先加入一个MenuTemplate.

<cc1:MenuTemplate ID="mtCategory" runat="server">
    <cc1:MenuItemTemplate ID="mitFilter" runat="server" Text="View Products" />

   cc1:MenuTemplate>

由于这个GroupMenu不在Columns里, 而SPMenuField又不能像MenuTemplate一样扔在SPGridView之外. 所以只好在代码里加了.

protected override void OnInit(EventArgs e)
{
    base.OnInit(e);
    this.SPGridView1.GroupMenu = new SPMenuField();
    this.SPGridView1.GroupMenu.MenuTemplateId = this.mtCategory.ID;
    this.SPGridView1.GroupMenu.HeaderText = "Category";
    this.SPGridView1.GroupMenu.TextFields = "CategoryName";
}

现在来看看效果吧.

完整代码:

<%@ Page Language="C#" MasterPageFile="~masterurl/Default.Master" %>

<%@ Register Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.WebControls" TagPrefix="cc1" %>

<script runat="server">   1:  
   2:     protected override void OnInit(EventArgs e)
   3:     {
   4:         base.OnInit(e);
   5:         this.SPGridView1.GroupMenu = new SPMenuField();
   6:         this.SPGridView1.GroupMenu.MenuTemplateId = this.mtCategory.ID;
   7:         this.SPGridView1.GroupMenu.HeaderText = "Category";
   8:         this.SPGridView1.GroupMenu.TextFields = "CategoryName";
   9:     }

   script>

<asp:Content ID="Content3" ContentPlaceHolderID="PlaceHolderAdditionalPageHead" runat="server">

    asp:Content>
<asp:Content ID="Content1" ContentPlaceHolderID="PlaceHolderPageTitleInTitleArea" runat="server">
    SPGridView Demo: Part 3 - Grouping

     asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="PlaceHolderMain" runat="server">
    
      
    <cc1:SPGridView ID="SPGridView1" runat="server" EnableViewState="false" AutoGenerateColumns="False" DataSourceID="ObjectDataSource1" AllowSorting="true" AllowGrouping="true" GroupField="CategoryName" AllowGroupCollapse="true">
        <Columns>
            <cc1:SPBoundField DataField="ProductId" HeaderText="Product ID" SortExpression="ProductId">
            
      cc1:SPBoundField>
            <cc1:SPBoundField DataField="ProductName" HeaderText="Product Name" SortExpression="ProductName" />
            <asp:BoundField DataField="UnitPrice" DataFormatString="${0:F2}" HeaderText="Unit Price" SortExpression="UnitPrice" />
            <asp:TemplateField HeaderText="Orderable" SortExpression="Discontinued">
                <itemtemplate>
                <asp:Label id="lblDiscontinued" runat="server" text='<%# Convert.ToBoolean(Eval("Discontinued")) ? "Yes" : "No" %>'>
       asp:Label>

        itemtemplate> 
         asp:TemplateField> 
          Columns> 
           cc1:SPGridView> 
             
             <cc1:MenuTemplate ID="mtCategory" runat="server"> <cc1:MenuItemTemplate ID="mitFilter" runat="server" Text="View Products" /> 
            cc1:MenuTemplate> 
              
              <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetProductList" TypeName="SPGridView_Demo.NorthwindData" SortParameterName="sortExpression">
             asp:ObjectDataSource> 
               
              asp:Content>