本文接著完成上一節(jié)未完的界面設(shè)計(jì)內(nèi)容，DevExpress換膚功能已經(jīng)討論過(guò)了，這里就不再重復(fù)了。首先建立三個(gè)全局變量，一個(gè)存放文件路徑，一個(gè)存放數(shù)據(jù)，一個(gè)存放過(guò)濾條件。

取得數(shù)據(jù)并綁定到表格中：

string DBFileName;
        DataView dataView;
        string[] filter = new string[3];

給 imageList 添加一些圖標(biāo)（隨便找的）：

DBFileName = DevExpress.Utils.FilesHelper.FindingFileName(Application.StartupPath, "Products.xml");

            if (!string.IsNullOrEmpty(DBFileName))
            {
                DataSet dt = new DataSet();
                dt.ReadXml(DBFileName);
                gridControl1.DataSource = dataView = dt.Tables[0].DefaultView;
            }

將工具欄中的種類(lèi)項(xiàng)與圖標(biāo)和表格關(guān)聯(lián)起來(lái)：

string[] s = new string[] { "Beverages","Condiments","Confections","Dairy Products",
                                        "Grains/Cereals","Meat/Poultry","Produce","Seafood"};
            for (int i = 0; i < s.Length; i++)
                repositoryItemImageComboBox1.Items.Add(new ImageComboBoxItem(s[i], i + 1, i));
            RepositoryItem ri = repositoryItemImageComboBox1.Clone() as RepositoryItem;
            colCategoryID.ColumnEdit = ri;

修改種類(lèi)項(xiàng)的屬性：

this.repositoryItemImageComboBox1.SmallImages = this.imageList1;

此時(shí)運(yùn)行后界面應(yīng)該是這樣的：

下面添加條件篩選的功能，首先定義一個(gè)設(shè)置篩選的方法：

private void SetFilter()
        {
            string f = "";
            foreach (string s in filter)
            {
                if (f != "" && (!string.IsNullOrEmpty(s)))
                {
                    f += " And";
                }
                if (!string.IsNullOrEmpty(s))
                {
                    f += s;
                }

                dataView.RowFilter = (f == "") ? "No Filter" : "Filter: " + f;
                iRecords.Caption = "Records: " + dataView.Count.ToString();
            }
        }

然后定義3種點(diǎn)擊事件，一個(gè)是篩選checkBox，一個(gè)是小于所選日期，一個(gè)選擇種類(lèi)：

private void discontinued_EditValueChanged(object sender, EventArgs e)
        {
            if (discontinued.EditValue == null)
                filter[0] = "";
            else
                filter[0] = string.Format("[Discontinued] = {0}", discontinued.EditValue.ToString());
            SetFilter();
        }

        private void lastOrder_EditValueChanged(object sender, EventArgs e)
        {
            if (lastOrder.EditValue == null)
            {
                filter[1] = "";
            }
            else
            {
                filter[1] = string.Format("[LastOrder] < #{0}#", StringDataToFormat(lastOrder.EditValue.ToString()));
            }
            SetFilter();
        }

        private static string StringDataToFormat(string s)
        {
            try
            {
                DateTime dt = DateTime.Parse(s);
                return string.Format("{0}/{1}/{2}", dt.Month.ToString(), dt.Day.ToString(), dt.Year.ToString());
            }
            catch
            {
                return s;
            }
        }

        private void categories_EditValueChanged(object sender, EventArgs e)
        {
            if (categories.EditValue == null)
                filter[2] = "";
            else
                filter[2] = string.Format("[CategoryID] = {0}",categories.EditValue.ToString());
            SetFilter();
        }

此時(shí)效果如下：

此時(shí)界面基本完成，剩下的就是加上一些邊邊角角的東西，比如設(shè)置清除篩選條件按鈕：

private void iClearFilter_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            discontinued.EditValue = null;
            lastOrder.EditValue = null;
            categories.EditValue = null;
        }

然后總體效果圖就出來(lái)了：