C# 继承DataGridView仿Excel表格程序

0.前言

本文及相关资源在本人承接项目中实际使用，作者声明，使用本文相关资源造成的后果与作者无关。

本文唯一原创地址（CSDN）：http://blog.csdn.net/ljfblog/article/details/17048047

本文相关资源唯一原创下载地址（CSDN）：http://download.csdn.net/detail/ljfblog/6636933

转载请无删改保留本节，谢谢！

1.接口

    public interface IZCGridSubControl
    {
        void Show(System.Windows.Forms.DataGridViewCell cell);
        Control ToControl();
        bool IsAlwaysShow();
        void ReLocation();
    }

2.继承（核心代码）

        private void OnCotentCellLeftMouseUp(DataGridViewCellMouseEventArgs e)
        {
            this.HideCurrentSubControl();
            if (this.SelectedCells.Count > 1) return;
            DataGridViewCell cell = this.Rows[e.RowIndex].Cells[e.ColumnIndex];
            if (this.CurrentCell.Equals(cell) == false && this.IsCurrentCellInEditMode) return;
            string columnName = this.Columns[e.ColumnIndex].Name;
            if (!this.subControls.ContainsKey(columnName)) return;
            IZCGridSubControl ictrl = this.subControls[columnName];
            if (ictrl == null) return;
            Control ctrl = ictrl.ToControl();
            if (cell.OwningColumn.ReadOnly && !ictrl.IsAlwaysShow()) 
                return;
            if (ctrl == null || ctrl.IsDisposed) return;

            if (!this.Controls.Contains(ctrl))
            {
                ctrl.Visible = false;
                this.Controls.Add(ctrl);
                ctrl.BringToFront();
            }
            this.currentSubControl = ictrl;
            Rectangle rect = this.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false);

            ctrl.Location = new Point(rect.Right, rect.Bottom - ctrl.Height - 1);
            cell.Style.SelectionBackColor = cell.Style.BackColor;
            ctrl.BringToFront();
            ictrl.Show(cell);
        }

3.使用

            
            //列标头合并
            //焊口信息
            ZCControl.ZCGridColumn columnWeldInfo = new ZCControl.ZCGridColumn(this.zcGrid1,0,1,
                new string[]{"焊口号","焊工"},"焊口信息", "焊口信息");
 
            //检验信息
            ZCControl.ZCGridColumn columnInspectInfo = new ZCControl.ZCGridColumn(this.zcGrid1, 0, 0,
                 new string[] { "外观", "无损", "热处理", "铁素体" },"检验信息", "检验信息");
                
            //焊口检验
            ZCControl.ZCGridColumn columnWeldInspect = new ZCControl.ZCGridColumn(this.zcGrid1,1, 1,
                new string[]{"外观","无损"}, "焊口检验", "焊口检验");

            //其它检验
            ZCControl.ZCGridColumn columnElseInspect = new ZCControl.ZCGridColumn(this.zcGrid1,1, 1,
                new string[] { "热处理", "铁素体" },"其它检验", "其它检验");
                 
            this.zcGrid1.AddMultiColumns(3, columnWeldInfo, columnInspectInfo, columnWeldInspect, columnElseInspect);
        
            //批量隐藏列
            this.zcGrid1.HideColumns("标头提示", "标头图标");
            //另有:
            //this.zcGrid1.SetReadOnlyColumns("");
            //this.zcGrid1.SetVisibleColumns("");


            //下拉列表
            ZCControl.ZCGridComboBox cbbWeldNo = new ZCControl.ZCGridComboBox();
            cbbWeldNo.Items.AddRange(new string[]{"011", "012", "013"});
            this.zcGrid1.SubControls.Add("焊口号", cbbWeldNo);

            ZCControl.ZCGridComboBox cbbResult = new ZCControl.ZCGridComboBox();
            cbbResult.Items.AddRange(new string[] { "ACC", "REJ" });
            this.zcGrid1.SubControls.Add("结果", cbbResult);

            //数据拾取器
            ZCControl.ZCGridDataSelector slrWelder = new ZCControl.ZCGridDataSelector();
            slrWelder.DataForm.ConnectionString = "server=(local);database=ICQuotedPriceDataBase;user id=sa;password=111111;Connection Timeout=1200;min pool size=0;max pool size=99;";
            slrWelder.DataForm.SetTreeParams("select * from tProject", "Id","ID_Parent","Name","Name");
            slrWelder.DataForm.SetDataParams("select * from tProjectWorkType where ProjectName=@Name","WorkTypeName", "WorkTypeName");
            this.zcGrid1.SubControls.Add("焊工", slrWelder);

            //日期拾取器
            ZCControl.ZCGridDateTimePicker dtpReportDate = new ZCControl.ZCGridDateTimePicker();
            this.zcGrid1.SubControls.Add("日期", dtpReportDate);

            //拖动排序按钮
            //this.zcGrid1.DataSource = this.dataTable时才能看到效果
            ZCControl.ZCGridUpDownButton btnUpDown = new ZCControl.ZCGridUpDownButton(true);
            btnUpDown.ScrollToDestRow = true;
            this.zcGrid1.SubControls.Add("编号", btnUpDown);

            //弹出文本编辑器
            ZCControl.ZCGridFormStringEditor txtVI = new ZCControl.ZCGridFormStringEditor();
            this.zcGrid1.SubControls.Add("外观", txtVI);

            //编辑框
            this.zcGrid1.SquareSelection = true;

            //行标头图标
            this.zcGrid1.SetErrIconColumns("标头图标", "标头提示");
            this.zcGrid1.Rows[0].Cells["标头图标"].Value = ZCControl.ZCGridErrIconType.Icon_Correct.ToString();
            this.zcGrid1.Rows[2].Cells["标头图标"].Value = ZCControl.ZCGridErrIconType.Icon_Err.ToString();
            this.zcGrid1.Rows[2].Cells["标头提示"].Value = "出错提示";
            this.zcGrid1.Rows[3].Cells["标头图标"].Value = ZCControl.ZCGridErrIconType.Icon_Info.ToString();

4.效果图示

5.资源下载

ZCGrid-C#继承DataGridView仿Excel表格，并增强编辑功能
http://download.csdn.net/detail/ljfblog/6636933