要分組和鎖定列很簡單，主要是ExtJS是支持的。只要糾正/... - FineUI 官方论坛

public static class GridHelp
{
/// <summary>
/// Grid功能重置
/// </summary>
public static Dictionary<string, string> GridReset = new Dictionary<string, string>();
/// <summary>
/// Grid欄位鎖定（類似Excel列凍結）
/// </summary>
/// <param name="g">表格</param>
/// <param name="ColumnID">唯一標識</param>
public static void GridFieldLock(FineUI.Grid g, String[] ColumnIDs)
{
String GridFieldLockMark = "{1C1A60AC-9E4B-4688-991F-BE95290BD1E9}";
String GridFieldUnLockMark = "{1D1CE2BE-C0E1-4DFB-A3AA-FF30A8DE73A5}";
foreach (GridColumn gc in g.Columns)
{
g.FindColumn(gc.ColumnID).HeaderText += GridFieldUnLockMark;
}
foreach (String gid in ColumnIDs)
{
g.FindColumn(gid).HeaderText = g.FindColumn(gid).HeaderText.Replace(GridFieldUnLockMark, "");
g.FindColumn(gid).HeaderText += GridFieldLockMark;
}
GridReset.Add(GridFieldLockMark + """, "",locked:true,lockable:false");
GridReset.Add(GridFieldUnLockMark + """, "",lockable:false");
}
/// <summary>
/// Grid設置分組
/// </summary>
/// <param name="g">表格</param>
/// <param name="FirstColumnID">第一列ColumnI</param>
/// <param name="GroupColumnID">需要分組列的ColumnI</param>
/// <param name="Collapsed">是否不展開</param>
public static void GridFieldGroup(FineUI.Grid g, String FirstColumnID, String GroupColumnID, Boolean Collapsed)
{
string GridMark = "features:[{ftype:'grouping',groupHeaderTpl:'X1',hideGroupedHeader:true,enableGroupingMenu:false,startCollapsed:X2}],";
GridMark = GridMark.Replace("X1", "{name}").Replace("X2", Collapsed ? "true" : "false");
GridReset.Add("id:"" + g.ClientID + "",", "id:"" + g.ClientID + ""," + GridMark);
GridMark = ("Ext.create('Ext.data.ArrayStore',{fields:[{name:"X"}").Replace("X", FirstColumnID);
GridReset.Add(GridMark, GridMark.Replace("fields:", ("groupField:'X',fields:").Replace("X", GroupColumnID)));
}
}

复制代码

protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
StringWriter sw = new StringWriter();
base.Render(new System.Web.UI.HtmlTextWriter(sw));
String html = sw.ToString();
if (GridHelp.GridReset.Count > 0)
{
foreach (KeyValuePair<string, string> dict in GridHelp.GridReset)
{
html = html.Replace(dict.Key, dict.Value);
}
}
writer.Write(html);
}

复制代码

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="grid.aspx.cs" Inherits="FineUI.Examples.grid.grid" %>
<!DOCTYPE html>
<html>
<head runat="server">
<title></title>
<link href="../css/main.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<x:PageManager ID="PageManager1" runat="server" />
<x:Grid ID="Grid1" ShowBorder="true" ShowHeader="true" Title="表格" Width="400px" runat="server"
DataKeyNames="Guid">
<Columns>
<x:TemplateField ColumnID="f1" Width="60px">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Container.DataItemIndex + 1 %>'></asp:Label>
</ItemTemplate>
</x:TemplateField>
<x:BoundField ColumnID="f2" Width="100px" DataField="Name" DataFormatString="{0}" HeaderText="姓名" />
<x:TemplateField Width="60px" HeaderText="性别">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# GetGender(Eval("Gender")) %>'></asp:Label>
</ItemTemplate>
</x:TemplateField>
<x:BoundField Width="60px" DataField="EntranceYear" HeaderText="入学年份" />
<x:CheckBoxField Width="60px" RenderAsStaticField="true" DataField="AtSchool" HeaderText="是否在校" />
<x:HyperLinkField HeaderText="所学专业" DataToolTipField="Major" DataTextField="Major"
DataTextFormatString="{0}" DataNavigateUrlFields="Major" DataNavigateUrlFormatString="http://gsa.ustc.edu.cn/search?q={0}"
DataNavigateUrlFieldsEncode="true" Target="_blank" ExpandUnusedSpace="True" />
<x:ImageField Width="60px" DataImageUrlField="Group" DataImageUrlFormatString="~/images/16/{0}.png"
HeaderText="分组">
</x:ImageField>
<x:BoundField Width="100px" DataField="LogTime" DataFormatString="{0:yy-MM-dd}" HeaderText="注册日期" />
</Columns>
</x:Grid>
<br />
<br />
</form>
</body>
</html>

复制代码

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Text;
using System.IO;
namespace FineUI.Examples.grid
{
public partial class grid : PageBase
{
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
StringWriter sw = new StringWriter();
base.Render(new System.Web.UI.HtmlTextWriter(sw));
String html = sw.ToString();
if (GridHelp.GridReset.Count > 0)
{
foreach (KeyValuePair<string, string> dict in GridHelp.GridReset)
{
html = html.Replace(dict.Key, dict.Value);
}
}
writer.Write(html);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridHelp.GridFieldLock(Grid1, new string[] { "f1", "f2" });
//GridHelp.GridFieldGroup(Grid1, "f1", "fx", true);
BindGrid();
}
}
#region BindGrid
private void BindGrid()
{
DataTable table = GetDataTable();
Grid1.DataSource = table;
Grid1.DataBind();
}
#endregion
}
public static class GridHelp
{
/// <summary>
/// Grid功能重置
/// </summary>
public static Dictionary<string, string> GridReset = new Dictionary<string, string>();
/// <summary>
/// Grid欄位鎖定（類似Excel列凍結）
/// </summary>
/// <param name="g">表格</param>
/// <param name="ColumnID">唯一標識</param>
public static void GridFieldLock(FineUI.Grid g, String[] ColumnIDs)
{
String GridFieldLockMark = "{1C1A60AC-9E4B-4688-991F-BE95290BD1E9}";
String GridFieldUnLockMark = "{1D1CE2BE-C0E1-4DFB-A3AA-FF30A8DE73A5}";
foreach (GridColumn gc in g.Columns)
{
g.FindColumn(gc.ColumnID).HeaderText += GridFieldUnLockMark;
}
foreach (String gid in ColumnIDs)
{
g.FindColumn(gid).HeaderText = g.FindColumn(gid).HeaderText.Replace(GridFieldUnLockMark, "");
g.FindColumn(gid).HeaderText += GridFieldLockMark;
}
GridReset.Add(GridFieldLockMark + """, "",locked:true,lockable:false");
GridReset.Add(GridFieldUnLockMark + """, "",lockable:false");
}
/// <summary>
/// Grid設置分組
/// </summary>
/// <param name="g">表格</param>
/// <param name="FirstColumnID">第一列ColumnI</param>
/// <param name="GroupColumnID">需要分組列的ColumnI</param>
/// <param name="Collapsed">是否不展開</param>
public static void GridFieldGroup(FineUI.Grid g, String FirstColumnID, String GroupColumnID, Boolean Collapsed)
{
string GridMark = "features:[{ftype:'grouping',groupHeaderTpl:'X1',hideGroupedHeader:true,enableGroupingMenu:false,startCollapsed:X2}],";
GridMark = GridMark.Replace("X1", "{name}").Replace("X2", Collapsed ? "true" : "false");
GridReset.Add("id:"" + g.ClientID + "",", "id:"" + g.ClientID + ""," + GridMark);
GridMark = ("Ext.create('Ext.data.ArrayStore',{fields:[{name:"X"}").Replace("X", FirstColumnID);
GridReset.Add(GridMark, GridMark.Replace("fields:", ("groupField:'X',fields:").Replace("X", GroupColumnID)));
}
}
}

复制代码