c1FlexGrid 冻结列 和冻结行

 

 

　　　　// 冻结列

            c1FlexGrid1.Cols.Frozen = 3;

　　　　// 冻结行

            c1FlexGrid1.Rows.Frozen = -1;

 

冻结最后一行,和最右边列.的方法,已经找到,研究一下,成功了再贴上来!Oh Yeah!...

 

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

namespace FlexFreezeBottomSample
{
	/// <summary>
	/// 
	/// FlexFreezeBottom
	/// 
	/// This is a control (derived from Panel) that contains a FlexGrid. The
	/// contained FlexGrid is positioned with a negative Y coordinate within 
	/// the panel so that the fixed rows are not visible.
	/// 
	/// The contained grid is also sized and scrolled via code so that the 
	/// bottom 'n' rows are visible.
	/// 
	/// The contained grid is bound to a main FlexGrid and therefore shares 
	/// the underlying grid model (data, layout, styles, selection, etc).
	/// 
	/// The whole control (panel and contained grid) is attached to the main 
	/// FlexGrid and positioned at its bottom. This way, the control always
	/// shows the bottom 'n' rows of the main grid.
	/// 
	/// </summary>
	internal class FlexFreezeBottom : Panel
	{
		private C1.Win.C1FlexGrid.C1FlexGrid _frz;
		private C1.Win.C1FlexGrid.C1FlexGrid _main;
		private int  _rows;
		internal FlexFreezeBottom(C1.Win.C1FlexGrid.C1FlexGrid main, int rows)
		{
			// save info we'll need later
			_main = main;
			_rows = rows;

			// create child grid with frozen bottom rows
			_frz = new C1.Win.C1FlexGrid.C1FlexGrid();
			_frz.ScrollBars = ScrollBars.None;
			_frz.BorderStyle = C1.Win.C1FlexGrid.Util.BaseControls.BorderStyleEnum.None;
			_frz.DrawMode = DrawModeEnum.OwnerDraw;
			_frz.OwnerDrawCell += new C1.Win.C1FlexGrid.OwnerDrawCellEventHandler(_frz_OwnerDrawCell);
			_frz.SetupEditor   += new C1.Win.C1FlexGrid.RowColEventHandler(_frz_SetupEditor);
			_frz.AfterScroll   += new C1.Win.C1FlexGrid.RangeEventHandler(_frz_AfterScroll);
			_frz.GridChanged   += new C1.Win.C1FlexGrid.GridChangedEventHandler(_main_GridChanged);
			Controls.Add(_frz);

			// bind frozen grid to main grid (share data, layout, styles, selection)
			_frz.DataSource = main;

			// add this to the main grid
			main.Controls.Add(this);

			// hook up the events we need to synchronize with the main grid
			main.Resize      += new System.EventHandler(_main_Resize);
			main.AfterScroll += new C1.Win.C1FlexGrid.RangeEventHandler(_main_AfterScroll);
			main.SelChange   += new System.EventHandler(_main_SelChange);
			main.GridChanged += new C1.Win.C1FlexGrid.GridChangedEventHandler(_main_GridChanged);

			// initialize
			AdjustLayout();
		}

		internal void AdjustLayout()
		{
			// get index of the bottom (frozen) rows
			RowCollection rows = _main.Rows;
			int r2 = rows.Count-1;
			int r1 = r2 - _rows + 1;
			if (r1 <= rows.Fixed) r1 = rows.Fixed;

			// hide control if the main grid is big enough
			Visible = (r1 <= r2);
			if (!Visible) return;

			// set control size and location
			Rectangle rc = _main.ClientRectangle;
			if (rows[r2].Bottom <= rc.Bottom)
			{
				Visible = false;
				return;
			}
			int hei = rows[r2].Bottom - rows[r1].Top + 1;
			rc.Y = rc.Bottom - hei;
			rc.Height = hei;
			Bounds = rc;

			// adjust child grid to hide fixed rows
			rc = ClientRectangle;
			hei = rows[rows.Fixed + rows.Frozen].Top;
			rc.Y -= hei;
			rc.Height += hei;
			_frz.Bounds = rc;

			// syncronize scroll position
			SynchScrollPosition(false);
		}
		internal void SynchScrollPosition(bool synchMain)
		{
			Point pos;

			// optionally synchronize X scroll position on the main grid
			if (synchMain)
			{
				pos = _frz.ScrollPosition;
				pos.Y = _main.ScrollPosition.Y;
				_main.ScrollPosition = pos;
			}

			// syncronize X scroll position of the frozen grid with main
			pos = _main.ScrollPosition;
			pos.Y = -64000;
			_frz.ScrollPosition = pos;

			// update everything right away
			_main.Update();
			_frz.Update();
		}

		// make normal and scrollable areas look different
		// (when painting and when editing)
		private void _frz_OwnerDrawCell(object sender, C1.Win.C1FlexGrid.OwnerDrawCellEventArgs e)
		{
			if (e.Style.BackColor == _frz.Styles.Normal.BackColor)
			{
				e.Graphics.FillRectangle(Brushes.Beige, e.Bounds);
				e.DrawCell(DrawCellFlags.Border | DrawCellFlags.Content);
			}
		}
		private void _frz_SetupEditor(object sender, C1.Win.C1FlexGrid.RowColEventArgs e)
		{
			_frz.BackColor = Color.Beige;
		}

		// adjust layout after resizing the main grid (our container)
		private void _main_Resize(object sender, System.EventArgs e)
		{
			AdjustLayout();
		}

		// synchronize scrolling
		private void _main_AfterScroll(object sender, C1.Win.C1FlexGrid.RangeEventArgs e)
		{
			SynchScrollPosition(false);
		}
		private void _frz_AfterScroll(object sender, C1.Win.C1FlexGrid.RangeEventArgs e)
		{
			// if the frozen grid has the focus and the user selects non-frozen
			// cells, scroll main grid up.
			if (_frz.Focused)
			{
				int row = Math.Min(_frz.Row, _frz.RowSel);
				int bot = _main.Rows[row].Bottom + _main.ScrollPosition.Y;
				if (bot > Top)
				{
					// unless this is a mouse selection, give focus to main grid
					if (!_frz.Capture) _main.Focus();
					_main.TopRow = _main.Row;
				}
			}
			SynchScrollPosition(true);
		}

		// scroll while selecting
		// if the user extends the selection down on the main grid, scroll it down.
		private void _main_SelChange(object sender, System.EventArgs e)
		{
			// only when the main grid has the focus!
			if (!_main.Focused) return;

			// calculate selection bottom (accounting for scrolling)
			int row = Math.Max(_main.Row, _main.RowSel);
			int bot = _main.Rows[row].Bottom + _main.ScrollPosition.Y;

			// try scrolling if past the bottom of the frozen area
			if (bot > Top) _main.TopRow++;
		}

		// adjust layout after massive changes (resize rows/cols, sort, etc)
		private void _main_GridChanged(object sender, C1.Win.C1FlexGrid.GridChangedEventArgs e)
		{
			switch (e.GridChangedType)
			{
				case GridChangedTypeEnum.GridChanged:
				case GridChangedTypeEnum.LayoutChanged:
					AdjustLayout();
					break;
			}
		}
	}
}

　　主要是这个类.

然后有相应的 这段代码来 进行 c1flexGrid 底部冻结

 _flex.AllowFreezing = AllowFreezingEnum.Both;

   // bind main grid to Customers table   

　　 Bind("select * from customers");

   // create frozen area at the bottom, with 3 rows   

 FlexFreezeBottom ffb = new FlexFreezeBottom(_flex, 3);