20
6月
2020

DevExpress下GridControl控件的增删查改

DevExpress的GridControl控件可以从任何数据源绑定数据并进行增删查改等操作,和VS自带的dataGridView控件对比,GridControl控件可以实现更多自定义的功能,界面UI也更精美,今天我和大家分享一个Demo演示GridControl控件的增删查改操作!

首先,主界面由一个GridControl控件构成,可执行数据的增、删、查、改和导出操作,如图1所示:

interface

图1-主界面(点击图片可放大)

实战演示:

1.主界面添加一个GridControl控件和一个Button,如图2所示:

guide1

图2-操作步骤1(点击图片可放大)

2.将GridControl控件的UseEmbeddedNavigator 属性设置为True,如图3所示:

guide2

图3-操作步骤2(点击图片可放大)

3.项目中添加System.ComponentModel.DataAnnotations引用,用于验证字段数据正确性,如图4所示:

guide3

图4-操作步骤3(点击图片可放大)

4.在初始化方法中添加gridControl控件的标题、顶部添加项、允许编辑和删除事件等,代码如下:

public Form1()
       {
           InitializeComponent();

           //gridView1标题
           gridView1.GroupPanelText = "深圳精品4S旗舰店订单管理:";

           //gridView1顶部显示添加行
           gridView1.OptionsView.NewItemRowPosition = NewItemRowPosition.Top;

           //gridView1允许编辑
           gridView1.OptionsBehavior.Editable = true;

           //gridView1选中行后按快捷键 “Ctrl+Del” 删除
           gridControl1.ProcessGridKey += (s, e) =>
           {
               if (e.KeyCode == Keys.Delete && e.Modifiers == Keys.Control)
               {
                   if (XtraMessageBox.Show("是否删除选中行?", "删除行对话框", MessageBoxButtons.YesNo) !=
                     DialogResult.Yes)
                       return;
                   GridControl grid = s as GridControl;
                   GridView view = grid.FocusedView as GridView;
                   view.DeleteSelectedRows();
               }
           };
       }

5.定义一个类用来进行字段属性设置并通知客户端,代码如下:

/// <summary>
       /// 字段属性设置并验证字段属性数据的正确性,属性变更后向客户端发出属性值已更改的通知。
       /// </summary>
       public class Record : INotifyPropertyChanged
       {
           public Record()
           {
           }
           int id;
           [DisplayName("订单号")]
           public int ID
           {
               get { return id; }
               set
               {
                   if (id != value)
                   {
                       id = value;
                       OnPropertyChanged();
                   }
               }
           }

           string text;
           [DisplayName("品牌")]
           public string Brand
           {
               get { return text; }
               set
               {
                   if (text != value)
                   {
                       if (string.IsNullOrEmpty(value))
                           throw new Exception();
                       text = value;
                       OnPropertyChanged();
                   }
               }
           }
           Nullable<decimal> val;
           [DataType(DataType.Currency)]
           [DisplayName("售价")]
           public Nullable<decimal> Value
           {
               get { return val; }
               set
               {
                   if (val != value)
                   {
                       val = value;
                       OnPropertyChanged();
                   }
               }
           }
           DateTime dt;
           [DisplayName("交期")]
           public DateTime RequiredDate
           {
               get { return dt; }
               set
               {
                   if (dt != value)
                   {
                       dt = value;
                       OnPropertyChanged();
                   }
               }
           }
           bool state;
           [DisplayName("完成")]
           public bool Processed
           {
               get { return state; }
               set
               {
                   if (state != value)
                   {
                       state = value;
                       OnPropertyChanged();
                   }
               }
           }

           public event PropertyChangedEventHandler PropertyChanged;
           protected void OnPropertyChanged([CallerMemberName] string propertyName = "")
           {
               if (PropertyChanged != null)
                   PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
           }
       }

6.定义一个数据随机生成方法并传值到字段中,代码如下:

/// <summary>
        /// 生成随机字段数据
        /// </summary>
        public class DataHelper
        {
            public static string[] brands = new string[] { "奔驰", "宝马", "奥迪", "大众",
            "马自达", "雷克萨斯", "红旗" ,"路虎","丰田","本田","现代"};

            public static BindingList<Record> GetData(int count)
            {
                BindingList<Record> records = new BindingList<Record>();
                Random rnd = new Random();
                for (int i = 0; i < count; i++)
                {
                    int n = rnd.Next(10);
                    records.Add(new Record()
                    {
                        ID = i + 2020000,
                        Brand = brands[i % brands.Length],
                        RequiredDate = DateTime.Today.AddDays(n + 30),
                        Value = i % 2 == 0 ? (i + 1) * 123456 : i * 12345,
                        Processed = i % 2 == 0,
                    });
                };
                return records;
            }
        }

7.定义一个方法利用XtraPrinting导出GridControl中的信息并保存为Excel,代码如下:

/// <summary>
        /// 导出dataGrid为Excle
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Btn_Output_Click(object sender, EventArgs e)
        {
            SaveFileDialog fileDialog = new SaveFileDialog();
            fileDialog.Title = "导出Excel";
            fileDialog.Filter = "Excel文件(*.xls)|*.xls";
            DialogResult dialogResult = fileDialog.ShowDialog(this);
            if (dialogResult == DialogResult.OK)
            {
                DevExpress.XtraPrinting.XlsExportOptions options = new
                DevExpress.XtraPrinting.XlsExportOptions();
                gridControl1.ExportToXls(fileDialog.FileName);
                DevExpress.XtraEditors.XtraMessageBox.Show("保存成功!", "提示",
                MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

8.在Form_Load函数中给gridControl控件绑定数据并修改单元格外观,实现启动时自动加载数据,代码如下:

private void Form1_Load(object sender, EventArgs e)
      {
          //dataGrid自动在数据源中找到公共字段并创建列。
          gridControl1.DataSource = DataHelper.GetData(10);

          //创建一个ComboBox编辑器,在“品牌”列中显示可用的品牌。
          RepositoryItemComboBox riComboBox = new RepositoryItemComboBox();
          riComboBox.Items.AddRange(DataHelper.brands);
          gridControl1.RepositoryItems.Add(riComboBox);
          gridView1.Columns["Brand"].ColumnEdit = riComboBox;

          //设置订单号列的外观颜色
          GridColumn colID = gridView1.Columns["ID"];
          colID.AppearanceCell.BackColor2 = Color.DarkGreen;
          colID.AppearanceCell.BackColor = Color.LightGreen;
          colID.AppearanceCell.ForeColor = Color.White;

          //设置品牌列的外观颜色
          GridColumn colCompanyName = gridView1.Columns["Brand"];
          colCompanyName.AppearanceCell.BackColor = Color.DarkKhaki;
          colCompanyName.AppearanceCell.ForeColor = Color.Black;

          //设置交期列的外观颜色
          GridColumn colRequiredDate = gridView1.Columns["RequiredDate"];
          colRequiredDate.AppearanceCell.ForeColor = Color.Red;
      }

代码全文:

using System;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.Drawing;
using System.Runtime.CompilerServices;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Repository;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;

namespace dataGrid
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            //gridView1标题
            gridView1.GroupPanelText = "深圳精品4S旗舰店订单管理:";

            //gridView1顶部显示添加行
            gridView1.OptionsView.NewItemRowPosition = NewItemRowPosition.Top;

            //gridView1允许编辑
            gridView1.OptionsBehavior.Editable = true;

            //gridView1选中行后按快捷键 “Ctrl+Del” 删除
            gridControl1.ProcessGridKey += (s, e) =>
            {
                if (e.KeyCode == Keys.Delete && e.Modifiers == Keys.Control)
                {
                    if (XtraMessageBox.Show("是否删除选中行?", "删除行对话框", MessageBoxButtons.YesNo) !=
                      DialogResult.Yes)
                        return;
                    GridControl grid = s as GridControl;
                    GridView view = grid.FocusedView as GridView;
                    view.DeleteSelectedRows();
                }
            };
        }

        /// <summary>
        /// 字段属性设置并验证字段属性数据的正确性,属性变更后向客户端发出属性值已更改的通知。
        /// </summary>
        public class Record : INotifyPropertyChanged
        {
            public Record()
            {
            }
            int id;
            [DisplayName("订单号")]
            public int ID
            {
                get { return id; }
                set
                {
                    if (id != value)
                    {
                        id = value;
                        OnPropertyChanged();
                    }
                }
            }

            string text;
            [DisplayName("品牌")]
            public string Brand
            {
                get { return text; }
                set
                {
                    if (text != value)
                    {
                        if (string.IsNullOrEmpty(value))
                            throw new Exception();
                        text = value;
                        OnPropertyChanged();
                    }
                }
            }
            Nullable<decimal> val;
            [DataType(DataType.Currency)]
            [DisplayName("售价")]
            public Nullable<decimal> Value
            {
                get { return val; }
                set
                {
                    if (val != value)
                    {
                        val = value;
                        OnPropertyChanged();
                    }
                }
            }
            DateTime dt;
            [DisplayName("交期")]
            public DateTime RequiredDate
            {
                get { return dt; }
                set
                {
                    if (dt != value)
                    {
                        dt = value;
                        OnPropertyChanged();
                    }
                }
            }
            bool state;
            [DisplayName("完成")]
            public bool Processed
            {
                get { return state; }
                set
                {
                    if (state != value)
                    {
                        state = value;
                        OnPropertyChanged();
                    }
                }
            }

            public event PropertyChangedEventHandler PropertyChanged;
            protected void OnPropertyChanged([CallerMemberName] string propertyName = "")
            {
                if (PropertyChanged != null)
                    PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
            }
        }


        /// <summary>
        /// 生成随机字段数据
        /// </summary>
        public class DataHelper
        {
            public static string[] brands = new string[] { "奔驰", "宝马", "奥迪", "大众",
            "马自达", "雷克萨斯", "红旗" ,"路虎","丰田","本田","现代"};

            public static BindingList<Record> GetData(int count)
            {
                BindingList<Record> records = new BindingList<Record>();
                Random rnd = new Random();
                for (int i = 0; i < count; i++)
                {
                    int n = rnd.Next(10);
                    records.Add(new Record()
                    {
                        ID = i + 2020000,
                        Brand = brands[i % brands.Length],
                        RequiredDate = DateTime.Today.AddDays(n + 30),
                        Value = i % 2 == 0 ? (i + 1) * 123456 : i * 12345,
                        Processed = i % 2 == 0,
                    });
                };
                return records;
            }
        }

        /// <summary>
        /// 导出dataGrid为Excle
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Btn_Output_Click(object sender, EventArgs e)
        {
            SaveFileDialog fileDialog = new SaveFileDialog();
            fileDialog.Title = "导出Excel";
            fileDialog.Filter = "Excel文件(*.xls)|*.xls";
            DialogResult dialogResult = fileDialog.ShowDialog(this);
            if (dialogResult == DialogResult.OK)
            {
                DevExpress.XtraPrinting.XlsExportOptions options = new
                DevExpress.XtraPrinting.XlsExportOptions();
                gridControl1.ExportToXls(fileDialog.FileName);
                DevExpress.XtraEditors.XtraMessageBox.Show("保存成功!", "提示",
                MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }


        private void Form1_Load(object sender, EventArgs e)
        {
            //dataGrid自动在数据源中找到公共字段并创建列。
            gridControl1.DataSource = DataHelper.GetData(10);

            //创建一个ComboBox编辑器,在“品牌”列中显示可用的品牌。
            RepositoryItemComboBox riComboBox = new RepositoryItemComboBox();
            riComboBox.Items.AddRange(DataHelper.brands);
            gridControl1.RepositoryItems.Add(riComboBox);
            gridView1.Columns["Brand"].ColumnEdit = riComboBox;

            //设置订单号列的外观颜色
            GridColumn colID = gridView1.Columns["ID"];
            colID.AppearanceCell.BackColor2 = Color.DarkGreen;
            colID.AppearanceCell.BackColor = Color.LightGreen;
            colID.AppearanceCell.ForeColor = Color.White;

            //设置品牌列的外观颜色
            GridColumn colCompanyName = gridView1.Columns["Brand"];
            colCompanyName.AppearanceCell.BackColor = Color.DarkKhaki;
            colCompanyName.AppearanceCell.ForeColor = Color.Black;

            //设置交期列的外观颜色
            GridColumn colRequiredDate = gridView1.Columns["RequiredDate"];
            colRequiredDate.AppearanceCell.ForeColor = Color.Red;
        }
    
        private void Button1_Click(object sender, EventArgs e)
        {
            //欢迎访问大博客,阅读更多编程实战案例!
            System.Diagnostics.Process.Start("https://www.daboke.com");
        }

        private void Button2_Click(object sender, EventArgs e)
        {
            //原文链接!
            System.Diagnostics.Process.Start("https://www.daboke.com/devexpress/gridcontrol.html");
        }

        private void Button3_Click(object sender, EventArgs e)
        {
            //欢迎访问我的B站频道-编程自修室,观看更多C#编程实战视频!
            System.Diagnostics.Process.Start("https://space.bilibili.com/580719958");
        }
    }
}

原文链接:https://www.daboke.com/devexpress/gridcontrol.html

B站up主-编程自修室:https://space.bilibili.com/580719958

源码下载:dataGrid

 

You may also like...

4 Responses

  1. 周松松博客说道:

    技术大牛,支持

  2. kl说道:

    牛的!b站三连了。

发表评论

邮箱地址不会被公开。

微信 OR 支付宝 扫描二维码
为本文作者 打个赏
pay_weixin pay_weixin
最喜欢你一言不合就打赏的样子了^_^