C1FlexGrid 学习（1） - 博客文库 - 博客园

Public Sub Subtotal(ByVal aggType As C1.Win.C1FlexGrid.AggregateEnum, ByVal level As Integer, ByVal groupOn As Integer, ByVal totalOn As Integer, ByVal caption As String)

.Subtotal()

整了两个小时才搞清楚C1FlexGrid.Subtotal(AggregateEnum.Sum, 0, 1, c, "Grand Total");各个参数的意思。 AggregateEnum.Sum ： 对C1FlexGrid里面的数据求和。

                               0 ： 对C1FlexGrid数据分组的第0层。

                               1： 是根据第 1 列数据进行分组

           Grand Total： 第0层分组的头标题

using System; using System.Drawing; using System.Drawing.Printing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using C1.Win.C1FlexGrid;

namespace Subtotals { ///

/// Summary description for Form1. /// public class Form1 : System.Windows.Forms.Form {   private C1.Win.C1FlexGrid.C1FlexGrid _flex;   private System.Windows.Forms.CheckBox _chkAbove;   private System.Windows.Forms.CheckBox _chkGrand;   private System.Windows.Forms.CheckBox _chkDirection;   private System.Windows.Forms.CheckBox _chkRegion;   private System.Windows.Forms.Button _btnPrint;         private CheckBox checkBox1;   ///   /// Required designer variable.   ///   private System.ComponentModel.Container components = null;

  public Form1()   {    //    // Required for Windows Form Designer support    //    InitializeComponent();

   //    // TODO: Add any constructor code after InitializeComponent call    //   }

  ///

  /// Clean up any resources being used.   ///   protected override void Dispose( bool disposing )   {    if( disposing )    {     if (components != null)     {      components.Dispose();     }    }    base.Dispose( disposing );   }

  #region Windows Form Designer generated code   ///

  /// Required method for Designer support - do not modify   /// the contents of this method with the code editor.   ///   private void InitializeComponent()   {             System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));             this._flex = new C1.Win.C1FlexGrid.C1FlexGrid();             this._chkAbove = new System.Windows.Forms.CheckBox();             this._chkGrand = new System.Windows.Forms.CheckBox();             this._chkDirection = new System.Windows.Forms.CheckBox();             this._chkRegion = new System.Windows.Forms.CheckBox();             this._btnPrint = new System.Windows.Forms.Button();             this.checkBox1 = new System.Windows.Forms.CheckBox();             ((System.ComponentModel.ISupportInitialize)(this._flex)).BeginInit();             this.SuspendLayout();             //             // _flex             //             this._flex.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)                         | System.Windows.Forms.AnchorStyles.Left)                         | System.Windows.Forms.AnchorStyles.Right)));             this._flex.ColumnInfo = "10,1,0,0,0,75,Columns:";             this._flex.Location = new System.Drawing.Point(8, 30);             this._flex.Name = "_flex";             this._flex.Rows.DefaultSize = 16;             this._flex.Size = new System.Drawing.Size(610, 317);             this._flex.StyleInfo = resources.GetString("_flex.StyleInfo");             this._flex.TabIndex = 0;             //             // _chkAbove             //             this._chkAbove.Checked = true;             this._chkAbove.CheckState = System.Windows.Forms.CheckState.Checked;             this._chkAbove.Location = new System.Drawing.Point(8, 7);             this._chkAbove.Name = "_chkAbove";             this._chkAbove.Size = new System.Drawing.Size(144, 15);             this._chkAbove.TabIndex = 1;             this._chkAbove.Text = "Subtotals Above Data";             this._chkAbove.CheckedChanged += new System.EventHandler(this._chk_CheckedChanged);             //             // _chkGrand             //             this._chkGrand.Checked = true;             this._chkGrand.CheckState = System.Windows.Forms.CheckState.Checked;             this._chkGrand.Location = new System.Drawing.Point(168, 7);             this._chkGrand.Name = "_chkGrand";             this._chkGrand.Size = new System.Drawing.Size(72, 15);             this._chkGrand.TabIndex = 1;             this._chkGrand.Text = "Grand";             this._chkGrand.CheckedChanged += new System.EventHandler(this._chk_CheckedChanged);             //             // _chkDirection             //             this._chkDirection.Checked = true;             this._chkDirection.CheckState = System.Windows.Forms.CheckState.Checked;             this._chkDirection.Location = new System.Drawing.Point(256, 7);             this._chkDirection.Name = "_chkDirection";             this._chkDirection.Size = new System.Drawing.Size(72, 15);             this._chkDirection.TabIndex = 1;             this._chkDirection.Text = "Direction";             this._chkDirection.CheckedChanged += new System.EventHandler(this._chk_CheckedChanged);             //             // _chkRegion             //             this._chkRegion.Checked = true;             this._chkRegion.CheckState = System.Windows.Forms.CheckState.Checked;             this._chkRegion.Location = new System.Drawing.Point(336, 7);             this._chkRegion.Name = "_chkRegion";             this._chkRegion.Size = new System.Drawing.Size(80, 15);             this._chkRegion.TabIndex = 1;             this._chkRegion.Text = "Region";             this._chkRegion.CheckedChanged += new System.EventHandler(this._chk_CheckedChanged);             //             // _btnPrint             //             this._btnPrint.Location = new System.Drawing.Point(487, 7);             this._btnPrint.Name = "_btnPrint";             this._btnPrint.Size = new System.Drawing.Size(72, 19);             this._btnPrint.TabIndex = 2;             this._btnPrint.Text = "&Print";             this._btnPrint.Click += new System.EventHandler(this._btnPrint_Click);             //             // checkBox1             //             this.checkBox1.AutoSize = true;             this.checkBox1.Location = new System.Drawing.Point(401, 6);             this.checkBox1.Name = "checkBox1";             this.checkBox1.Size = new System.Drawing.Size(80, 16);             this.checkBox1.TabIndex = 3;             this.checkBox1.Text = "checkBox1";             this.checkBox1.UseVisualStyleBackColor = true;             this.checkBox1.CheckedChanged += new System.EventHandler(this._chk_CheckedChanged);             //             // Form1             //             this.AutoScaleBaseSize = new System.Drawing.Size(5, 12);             this.ClientSize = new System.Drawing.Size(626, 352);             this.Controls.Add(this.checkBox1);             this.Controls.Add(this._btnPrint);             this.Controls.Add(this._chkAbove);             this.Controls.Add(this._flex);             this.Controls.Add(this._chkGrand);             this.Controls.Add(this._chkDirection);             this.Controls.Add(this._chkRegion);             this.Name = "Form1";             this.Text = "C1FlexGrid: Subtotals";             this.Load += new System.EventHandler(this.Form1_Load);             ((System.ComponentModel.ISupportInitialize)(this._flex)).EndInit();             this.ResumeLayout(false);             this.PerformLayout();

  }   #endregion

  ///

  /// The main entry point for the application.   ///   [STAThread]   static void Main()   {    Application.Run(new Form1());   }

  private void Form1_Load(object sender, System.EventArgs e)   {    // populate grid    Random rnd = new Random();    _flex.Rows.Count = 14;    _flex[0,1] = "Direction";    _flex[0,2] = "Region";    CellRange rg = _flex.GetCellRange(0,3,0,_flex.Cols.Count-1);    rg.Data = "Rnd";    for (int r = 1; r < _flex.Rows.Count; r++)    {     _flex[r,0] = r;     _flex[r,1] = (r < 7)? "Inbound": "Outbound";     _flex[r,2] = (r < 3)? "North": (r < 7)? "South": (r < 10)? "East": "West";     for (int c = 3; c < _flex.Cols.Count; c++)     {      _flex[r,c] = rnd.Next(1000);      _flex.Cols[c].Format = "#,###";     }    }

   // set up styles    CellStyle s = _flex.Styles[CellStyleEnum.Subtotal0];     s.BackColor = Color.Black;     s.ForeColor = Color.White;     s.Font = new Font(_flex.Font, FontStyle.Bold);    s = _flex.Styles[CellStyleEnum.Subtotal1];     s.BackColor = Color.DarkBlue;     s.ForeColor = Color.White;    s = _flex.Styles[CellStyleEnum.Subtotal2];     s.BackColor = Color.DarkRed;     s.ForeColor = Color.White;

   // more setup    _flex.AllowDragging = AllowDraggingEnum.None;    _flex.AllowEditing = false;    _flex.Cols[0].WidthDisplay /= 3;    _flex.Tree.Column = 1;

   // show totals    UpdateTotals();     }   private void UpdateTotals()   {    // clear existing totals    _flex.Subtotal(AggregateEnum.Clear);

   // calculate subtotals (three levels, totals on every column)    for (int c = 3; c < _flex.Cols.Count; c++)    {     if (_chkGrand.Checked)      _flex.Subtotal(AggregateEnum.Sum, 0, -1, c, "Grand Total");     if (_chkDirection.Checked)      _flex.Subtotal(AggregateEnum.Sum, 1, 1, c, "Total for {0}");     if (_chkRegion.Checked)      _flex.Subtotal(AggregateEnum.Sum, 2, 2, c, "Total for {0}");                 if (checkBox1.Checked)                     _flex.Subtotal(AggregateEnum.Sum, 1, 2, c, "Total for {0}");

   }

   // done, autosize columns to finish             _flex.AutoSizeCols();   }

  private void _chk_CheckedChanged(object sender, System.EventArgs e)   {    // set subtotal position    _flex.SubtotalPosition = (_chkAbove.Checked)     ? SubtotalPositionEnum.AboveData     : SubtotalPositionEnum.BelowData;

   // and update totals    UpdateTotals();   }

  private void _btnPrint_Click(object sender, System.EventArgs e)   {    PrintDocument pd = _flex.PrintParameters.PrintDocument;    pd.DefaultPageSettings.Landscape = true;    Margins m = pd.DefaultPageSettings.Margins;    m.Left = 25;    m.Right = 25;    m.Top = 25;    m.Bottom = 25;    _flex.PrintGrid("Subtotals",     PrintGridFlags.ShowPreviewDialog |     PrintGridFlags.FitToPage);   } } }