懒得安分通过本文主要向大家介绍了winform datagridview,winform datagrid,c winform datagrid,winform reportview,c#datagridview控件等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
刚到一家新公司,领导下发任务要用cs系统做一个表格折叠显示,这真是把我难倒了,自己工作6年一直以来都是做BS的系统。这如果在BS里面那太简单了,JqGrid默认都自带,可是DataGridview不支持折叠啊。自己一点经验没有,怎么办呢?于是上网搜了相关视频,资料,开始学习起来。最后借鉴源码封了这么一个东西,发出来分享下,也能让自己加深印象。
首先不多说,上图。如果大家感谢还不错,请继续往下阅读:
大概的效果就是这样。
上代码。
1、首先重写DataGridview,代码如下:
public class MasterControl : DataGridView { #region 字段 private List<int> rowCurrent = new List<int>(); internal static int rowDefaultHeight = ; internal static int rowExpandedHeight = ; internal static int rowDefaultDivider = ; internal static int rowExpandedDivider = - ; internal static int rowDividerMargin = ; internal static bool collapseRow; //detailControl变量作为一个容器用来保存子表格 public detailControl childView = new detailControl() { Visible = false }; // VBConversions Note: Initial value cannot be assigned here since it is non-static. Assignment has been moved to the class constructors. // internal System.Windows.Forms.ImageList RowHeaderIconList; private System.ComponentModel.Container components = null; // DataSet _cDataset; string _foreignKey; string _primaryKey; string _filterFormat; private controlType EControlType; public int ExpandRowIndex = ; #endregion #region 构造函数 /// <summary> /// 通过传递过来的枚举判断是两级还是三级展开,表的对应关系通过Relations来读取 /// 所以调用此构造函数的时候必须要讲Relations设置正确,才能正确显示层级关系。 /// oDataSet.Relations.Add("", oDataSet.Tables["T"].Columns["Menu_ID"], oDataSet.Tables["T"].Columns["Menu_ID"]); /// oDataSet.Relations.Add("", oDataSet.Tables["T"].Columns["Menu_Name"], oDataSet.Tables["T"].Columns["Menu_Name"]); /// 这两次Add的顺序不能颠倒,必须先添加一、二级的表关联,再添加二、三级的表关联 /// </summary> /// <param name="cDataset">数据源DataSet,里面还有各个表的对应关系</param> /// <param name="eControlType">枚举类型</param> public MasterControl(DataSet cDataset, controlType eControlType) { SetMasterControl(cDataset, eControlType); } /// <summary> /// 第二种使用方法 /// </summary> /// <param name="lstData">折叠控件第一层的集合</param> /// <param name="lstData">折叠控件第二层的集合</param> /// <param name="lstData">折叠控件第三层的集合</param> /// <param name="dicRelateKey">第一二层之间对应主外键</param> /// <param name="dicRelateKey">第二三层之间对应主外键</param> /// <param name="eControlType">枚举类型</param> public MasterControl(object lstData, object lstData, object lstData, Dictionary<string, string> dicRelateKey, Dictionary<string ,string>dicRelateKey, controlType eControlType) { var oDataSet = new DataSet(); try { var oTable = new DataTable(); oTable = Fill(lstData); oTable.TableName = "T"; var oTable = Fill(lstData); oTable.TableName = "T"; if (lstData == null || dicRelateKey == null || dicRelateKey.Keys.Count <= ) { oDataSet.Tables.AddRange(new DataTable[] { oTable, oTable }); oDataSet.Relations.Add("", oDataSet.Tables["T"].Columns[dicRelateKey.Keys.FirstOrDefault()], oDataSet.Tables["T"].Columns[dicRelateKey.Values.FirstOrDefault()]); } else { var oTable = Fill(lstData); oTable.TableName = "T"; oDataSet.Tables.AddRange(new DataTable[] { oTable, oTable, oTable }); //这是对应关系的时候主键必须唯一 oDataSet.Relations.Add("", oDataSet.Tables["T"].Columns[dicRelateKey.Keys.FirstOrDefault()], oDataSet.Tables["T"].Columns[dicRelateKey.Values.FirstOrDefault()]); oDataSet.Relations.Add("", oDataSet.Tables["T"].Columns[dicRelateKey.Keys.FirstOrDefault()], oDataSet.Tables["T"].Columns[dicRelateKey.Values.FirstOrDefault()]); } } catch { oDataSet = new DataSet(); } SetMasterControl(oDataSet, eControlType); } /// <summary> /// 控件初始化 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); base.RowHeaderMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(MasterControl_RowHeaderMouseClick); base.RowPostPaint += new System.Windows.Forms.DataGridViewRowPostPaintEventHandler(MasterControl_RowPostPaint); base.Scroll += new System.Windows.Forms.ScrollEventHandler(MasterControl_Scroll); base.SelectionChanged += new System.EventHandler(MasterControl_SelectionChanged); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MasterControl)); this.RowHeaderIconList = new System.Windows.Forms.ImageList(this.components); ((System.ComponentModel.ISupportInitialize)this).BeginInit(); this.SuspendLayout(); // //RowHeaderIconList // this.RowHeaderIconList.ImageStream = (System.Windows.Forms.ImageListStreamer)(resources.GetObject("RowHeaderIconList.ImageStream")); this.RowHeaderIconList.TransparentColor = System.Drawing.Color.Transparent; this.RowHeaderIconList.Images.SetKeyName(, "expand.png"); this.RowHeaderIconList.Images.SetKeyName(, "collapse.png"); // //MasterControl // ((System.ComponentModel.ISupportInitialize)this).EndInit(); this.ResumeLayout(false); } #endregion #region 数据绑定 /// <summary> /// 设置表之间的主外键关联 /// </summary> /// <param name="tableName">DataTable的表名称</param> /// <param name="foreignKey">外键</param> public void setParentSource(string tableName, string primarykey, string foreignKey) { this.DataSource = new DataView(_cDataset.Tables[tableName]); cModule.setGridRowHeader(this); _foreignKey = foreignKey; _primaryKey = primarykey; if (_cDataset.Tables[tableName].Columns[primarykey].GetType().ToString() == typeof(int).ToString() || _cDataset.Tables[tableName].Columns[primarykey].GetType().ToString() == typeof(double).ToString() || _cDataset.Tables[tableName].Columns[primarykey].GetType().ToString() == typeof(decimal).ToString()) { _filterFormat = foreignKey + "={}"; } else { _filterFormat = foreignKey + "=\'{}\'"; } } #endregion #region 事件 //控件的行头点击事件 private void MasterControl_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { try { Rectangle rect = new Rectangle(System.Convert.ToInt((double)(rowDefaultHeight - ) / ), System.Convert.ToInt((double)(rowDefaultHeight - ) / ), , ); if (rect.Contains(e.Location)) { //缩起 if (rowCurrent.Contains(e.RowIndex)) { rowCurrent.Clear(); this.Rows[e.RowIndex].Height = rowDefaultHeight; this.Rows[e.RowIndex].DividerHeight = rowDefaultDivider; this.ClearSelection(); collapseRow = true; this.Rows[e.RowIndex].Selected = true; if (EControlType == controlType.middle) { var oParent = ((MasterControl)this.Parent.Parent); oParent.Rows[oParent.ExpandRowIndex].Height = rowDefaultHeight * (this.Rows.Count + ); oParent.Rows[oParent.ExpandRowIndex].DividerHeight = rowDefaultHeight * (this.Rows.Count + ); if (oParent.Rows[oParent.Expand