C#仿QQ皮肤－DataGridView 最新1.2版

阅读全文：http://www.sufeinet.com/thread-598-1-1.html

 

先来看看效果吧

---

 

 

升级报告说明

---

   这次升级的功能主有

   1.对鼠标跟随效果进行的优化

   2.增加了行号的功能方便查找数据

   3.增加一个菜单功能，目前里面有的功能主要是冻结和恢复首行和首列功能。还有导出Excel和全选功能。

 

实现说明

---

   首先我们要准备两张图片，用来做什么呢，自然是用来做菜单使用的。我是临时整理了两张看着不怎么好看，不过功能不影响大家下载源代码后要吧自行修改的漂亮一些。

   然后我们第一步要做的是怎么样把这个图片添加到DataGridView里面去。在添加这个控件 之前呢我们要做两件事情，第一就是New一个左键菜单，绑定到这个菜单Button，

第二步是给这个button注册一个单击事件看下面的代码。

    #region 注册菜单项

            //在这里添加菜单项
            cmsleft.Items.Add(createItem("clumnsFist", "冻结首列", new EventHandler(clumnsFist_Click)));
            cmsleft.Items.Add(createItem("rowsFist", "冻结首行", new EventHandler(rowsFistFist_Click)));
            cmsleft.Items.Add(createItem("officeExeceout", "导出到Excel", new EventHandler(officeExeceout_Click)));
            cmsleft.Items.Add(createItem("fullSelect", "全选", new EventHandler(fullSelect_Click)));
            #endregion

            #region 绑定菜单

            Button objpb = new Button();
            objpb.BackgroundImage = bxyztSkin.Properties.Resources.caidan;
            objpb.Location = new Point(objpb.Location.X + 9, objpb.Location.Y + 4);
            objpb.Width = 17;
            objpb.Text = "";
            //绑定一个右键菜单
            objpb.ContextMenuStrip = cmsleft;
            objpb.Cursor = System.Windows.Forms.Cursors.Hand;
            objpb.Height = 17;
            objpb.BackgroundImageLayout = ImageLayout.Stretch;
            objpb.FlatStyle = FlatStyle.Popup;
            //在添加前先注册一个事件
            objpb.Click += new EventHandler(objpb_Click);
            this.Controls.Add(objpb);

            #endregion

 这样的话我们在运行这个控件时就可以看到菜单效果了，下面我们来分别对事件进行一下处理吧

1.Button单击事件

        //Button单击事件
        void objpb_Click(object sender, EventArgs e)
        {
            Button objbootn = (Button)sender;
            //显示菜单的位置
            objbootn.ContextMenuStrip.Show(Control.MousePosition.X, Control.MousePosition.Y);
        }

2.全选事件

   //全选
        void fullSelect_Click(object sender, EventArgs e)
        {
            this.SelectAll();
        }

3.导出到Excel事件

        //导出到Excel
        void officeExeceout_Click(object sender, EventArgs e)
        {
            if (this.Rows.Count > 0)
            {
                OfficeManagerMentServices.DataGridViewToExcel(this);
            }
        }

OfficeManagerMentServices类如下

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace bxyztSkin.csList
{
   public  class OfficeManagerMentServices
    {
        /// <summary>   
        /// 将 DataGridView的数据导出Excel
        /// </summary>   
        /// <remarks>   
        /// using System.IO;   
        /// </remarks>   
        /// <param name="dgv"></param>   
        public static void DataGridViewToExcel(bxyztSkin.Editors.CDataGridView dgv)
        {

            SaveFileDialog dlg = new SaveFileDialog();
            dlg.Filter = "Execl files (*.xls)|*.xls";
            dlg.CheckFileExists = false;
            dlg.CheckPathExists = false;
            dlg.FilterIndex = 0;
            dlg.RestoreDirectory = true;
            dlg.CreatePrompt = false;
            dlg.Title = "保存为Excel文件";
            dlg.FileName = DateTime.Now.Ticks.ToString().Trim();

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                Stream myStream;
                myStream = dlg.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
                string columnTitle = "";
                try
                {
                    //写入列标题   
                    for (int i = 0; i < dgv.ColumnCount; i++)
                    {
                        if (i > 0)
                        {
                            columnTitle += "\t";
                        }
                        columnTitle += dgv.Columns[i].HeaderText;
                    }
                    sw.WriteLine(columnTitle);

                    //写入列内容   
                    for (int j = 0; j < dgv.Rows.Count; j++)
                    {
                        string columnValue = "";
                        for (int k = 0; k < dgv.Columns.Count; k++)
                        {
                            if (k > 0)
                            {
                                columnValue += "\t";
                            }
                            if (dgv.Rows[j].Cells[k].Value == null)
                                columnValue += "";
                            else
                                columnValue += dgv.Rows[j].Cells[k].Value.ToString().Trim();
                        }
                        sw.WriteLine(columnValue);
                    }
                    sw.Close();
                    myStream.Close();
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.ToString());
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }
    }
}

4.冻结/恢复首列

//冻结/恢复首列
        void clumnsFist_Click(object sender, EventArgs e)
        {
            if (this.Columns.Count >= 1)
            {
                for (int i = 0; i < this.Columns.Count; i++)
                {
                    if (this.Columns[i].Visible == true)
                    {
                        if (this.Columns[i].Frozen)
                        {
                            this.Columns[i].Frozen = false;
                            ((ToolStripMenuItem)sender).Text = "冻结首列";
                            return;
                        }
                        else
                        {
                            this.Columns[i].Frozen = true;
                            ((ToolStripMenuItem)sender).Text = "恢复首列";
                            return;
                        }
                    }
                }
            }
        }

5.冻结/恢复首行

  //冻结/恢复首行
        void rowsFistFist_Click(object sender, EventArgs e)
        {
            if (this.Rows.Count >= 1)
            {
                if (this.Rows[0].Frozen)
                {
                    this.Rows[0].Frozen = false;
                    ((ToolStripMenuItem)sender).Text = "冻结首行";
                }
                else
                {
                    this.Rows[0].Frozen = true;
                    ((ToolStripMenuItem)sender).Text = "解冻首行";
                }
            }
        }

还有一个提供创建新的菜单项的方法

 /// <summary>
        /// 创建新的菜单项
        /// </summary>
        /// <param name="name">菜单名</param>
        /// <param name="Text">显示文字</param>
        /// <param name="objEh">绑定事件</param>
        /// <returns>返一个ToolStripMenuItem对象</returns>
        private ToolStripMenuItem createItem(string name, string Text, EventHandler objEh)
        {
            System.Windows.Forms.ToolStripMenuItem lolumns = new System.Windows.Forms.ToolStripMenuItem();
            lolumns.ForeColor = System.Drawing.Color.Black;
            lolumns.Name = name;
            lolumns.Size = new System.Drawing.Size(152, 24);
            lolumns.Text = Text;
            lolumns.Click += objEh;
            return lolumns;
        }

我把全部代码放上大家多多指教

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Diagnostics;
using System.Text;
using System.Drawing;
using System.Windows.Forms;
using bxyztSkin.csList;

namespace bxyztSkin.Editors
{
    public partial class CDataGridView : System.Windows.Forms.DataGridView
    {
        /// <summary>
        /// 类说明：CDataGridView控件的实现用来代替系统的DataGridView控件
        /// 编码日期：2011-03-02
        /// 编 码 人：  苏飞
        /// 联系方式：361983679  Email：sufei.1013@163.com  Blogs:http://sufei.cnblogs.com
        /// </summary>
        public CDataGridView()
        {
            this.SetStyle(ControlStyles.DoubleBuffer | ControlStyles.AllPaintingInWmPaint, true);
        }
        //[Description("是否调用复制的开关，True为开启，False为不开启"), EditorBrowsable(EditorBrowsableState.Always), Browsable(true)]
        //public Boolean clipboard { get; set; }


        //[Description("复制的单元格号码从0开始"), EditorBrowsable(EditorBrowsableState.Always), Browsable(true)]
        //public int clipboardnumber { get; set; }

        //[Description("行号的颜色"), EditorBrowsable(EditorBrowsableState.Always), Browsable(true)]
        //public Color RowIndexColor { get; set; }

        protected override void OnCreateControl()
        {
            this.EnableHeadersVisualStyles = false;
            this.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(247, 246, 239);
            this.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Raised;
            this.ColumnHeadersHeight = 26;
            this.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
            this.ColumnHeadersDefaultCellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
            this.ColumnHeadersDefaultCellStyle.ForeColor = System.Drawing.SystemColors.WindowText;
            this.ColumnHeadersDefaultCellStyle.SelectionBackColor = System.Drawing.SystemColors.Highlight;
            this.ColumnHeadersDefaultCellStyle.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
            this.RowHeadersDefaultCellStyle.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
            this.RowHeadersDefaultCellStyle.BackColor = System.Drawing.SystemColors.Window;
            this.RowHeadersDefaultCellStyle.ForeColor = System.Drawing.SystemColors.WindowText;
            this.RowHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single;
            this.DefaultCellStyle.SelectionBackColor = Color.Wheat;
            this.DefaultCellStyle.SelectionForeColor = Color.DarkSlateBlue;
            this.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing;
            this.GridColor = System.Drawing.SystemColors.GradientActiveCaption;
            this.BackgroundColor = System.Drawing.SystemColors.Window;
            this.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
            this.AllowUserToOrderColumns = true;
            this.AutoGenerateColumns = true;

            //奇数行的颜色
            this.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(216, 229, 248);
            base.OnCreateControl();

            #region 菜单体
            bxyztSkin.CControls.CContextMenuStrip cmsleft = new bxyztSkin.CControls.CContextMenuStrip();
            cmsleft.Font = new System.Drawing.Font("微软雅黑", 10F);
            cmsleft.Name = "cmsleft";
            cmsleft.Size = new System.Drawing.Size(61, 4);
            #endregion

            #region 注册菜单项

            //在这里添加菜单项
            cmsleft.Items.Add(createItem("clumnsFist", "冻结首列", new EventHandler(clumnsFist_Click)));
            cmsleft.Items.Add(createItem("rowsFist", "冻结首行", new EventHandler(rowsFistFist_Click)));
            cmsleft.Items.Add(createItem("officeExeceout", "导出到Excel", new EventHandler(officeExeceout_Click)));
            cmsleft.Items.Add(createItem("fullSelect", "全选", new EventHandler(fullSelect_Click)));
            #endregion

            #region 绑定菜单

            Button objpb = new Button();
            objpb.BackgroundImage = bxyztSkin.Properties.Resources.caidan;
            objpb.Location = new Point(objpb.Location.X + 9, objpb.Location.Y + 4);
            objpb.Width = 17;
            objpb.Text = "";
            //绑定一个右键菜单
            objpb.ContextMenuStrip = cmsleft;
            objpb.Cursor = System.Windows.Forms.Cursors.Hand;
            objpb.Height = 17;
            objpb.BackgroundImageLayout = ImageLayout.Stretch;
            objpb.FlatStyle = FlatStyle.Popup;
            //在添加前先注册一个事件
            objpb.Click += new EventHandler(objpb_Click);
            this.Controls.Add(objpb);

            #endregion
        }

        #region 菜单项的事件集合

        //全选
        void fullSelect_Click(object sender, EventArgs e)
        {
            this.SelectAll();
        }

        //导出到Excel
        void officeExeceout_Click(object sender, EventArgs e)
        {
            if (this.Rows.Count > 0)
            {
                OfficeManagerMentServices.DataGridViewToExcel(this);
            }
        }

        //冻结/恢复首列
        void clumnsFist_Click(object sender, EventArgs e)
        {
            if (this.Columns.Count >= 1)
            {
                for (int i = 0; i < this.Columns.Count; i++)
                {
                    if (this.Columns[i].Visible == true)
                    {
                        if (this.Columns[i].Frozen)
                        {
                            this.Columns[i].Frozen = false;
                            ((ToolStripMenuItem)sender).Text = "冻结首列";
                            return;
                        }
                        else
                        {
                            this.Columns[i].Frozen = true;
                            ((ToolStripMenuItem)sender).Text = "恢复首列";
                            return;
                        }
                    }
                }
            }
        }

        //冻结/恢复首行
        void rowsFistFist_Click(object sender, EventArgs e)
        {
            if (this.Rows.Count >= 1)
            {
                if (this.Rows[0].Frozen)
                {
                    this.Rows[0].Frozen = false;
                    ((ToolStripMenuItem)sender).Text = "冻结首行";
                }
                else
                {
                    this.Rows[0].Frozen = true;
                    ((ToolStripMenuItem)sender).Text = "解冻首行";
                }
            }
        }

        #endregion

        /// <summary>
        /// 创建新的菜单项
        /// </summary>
        /// <param name="name">菜单名</param>
        /// <param name="Text">显示文字</param>
        /// <param name="objEh">绑定事件</param>
        /// <returns>返一个ToolStripMenuItem对象</returns>
        private ToolStripMenuItem createItem(string name, string Text, EventHandler objEh)
        {
            System.Windows.Forms.ToolStripMenuItem lolumns = new System.Windows.Forms.ToolStripMenuItem();
            lolumns.ForeColor = System.Drawing.Color.Black;
            lolumns.Name = name;
            lolumns.Size = new System.Drawing.Size(152, 24);
            lolumns.Text = Text;
            lolumns.Click += objEh;
            return lolumns;
        }

        //Button单击事件
        void objpb_Click(object sender, EventArgs e)
        {
            Button objbootn = (Button)sender;
            //显示菜单的位置
            objbootn.ContextMenuStrip.Show(Control.MousePosition.X, Control.MousePosition.Y);
        }

        #region 鼠标颜色
        Color defaultcolor;

        //移到单元格时的颜色
        protected override void OnCellMouseMove(DataGridViewCellMouseEventArgs e)
        {
            base.OnCellMouseMove(e);
            try
            {
                Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.YellowGreen;
            }
            catch { }
        }

        //进入单元格时保存当前的颜色

        protected override void OnCellMouseEnter(DataGridViewCellEventArgs e)
        {
            base.OnCellMouseEnter(e);
            try
            {
                defaultcolor = Rows[e.RowIndex].DefaultCellStyle.BackColor;
            }
            catch { }
        }

        //离开时还原颜色
        protected override void OnCellMouseLeave(DataGridViewCellEventArgs e)
        {
            base.OnCellMouseLeave(e);
            try
            {
                Rows[e.RowIndex].DefaultCellStyle.BackColor = defaultcolor;
            }
            catch { }
        }

        //在生成列表时添加一个行号，颜色默认为红色
        protected override void OnRowPostPaint(DataGridViewRowPostPaintEventArgs e)
        {
            base.OnRowPostPaint(e);
            //自动编号与数据库无关
            Rectangle rectangle = new Rectangle(e.RowBounds.Location.X, e.RowBounds.Location.Y, RowHeadersWidth - 4, e.RowBounds.Height);
            TextRenderer.DrawText(e.Graphics, (e.RowIndex + 1).ToString(), RowHeadersDefaultCellStyle.Font, rectangle,
             Color.Red, TextFormatFlags.VerticalCenter | TextFormatFlags.HorizontalCenter);
        }

        #endregion
    }
}