Dev 7.3.6中关于GridControl的导出和过滤问题

最新推荐文章于 2023-09-25 22:23:42 发布

Clarence

最新推荐文章于 2023-09-25 22:23:42 发布

阅读量3.5k

点赞数

分类专栏： DevExpress学习小结文章标签： filter string winform excel

本文链接：https://blog.csdn.net/magieclarence/article/details/7102987

版权

DevExpress学习小结专栏收录该内容

7 篇文章 0 订阅

订阅专栏

        public static void ExportExcel(Form winForm, DevExpress.XtraGrid.Views.Grid.GridView girdView, string fileName)
        {
            SaveFileDialog form = new SaveFileDialog();
            form.Filter = "EXCEL(*.xls)|*.xls";
            form.FileName = string.Format("{0}.xls", fileName);
            if (form.ShowDialog(winForm) == DialogResult.Cancel) return;
            girdView.ExportToXls(form.FileName);


            XtraMessageBox.Show(string.Format("{0}导出完成！", fileName));
        }


        public static void GriView2BlurQuery(DevExpress.XtraGrid.Views.Grid.GridView girdView)
        {
            string newFilter = string.Empty;
            string filter = girdView.ActiveFilterString;


            string[] filter1 = filter.Replace(" And ", "|").Split('|');
            foreach (string item in filter1)
            {
                string itemFilter = string.Empty;


                string[] filter2 = item.Replace(" Like ", "|").Split('|');
                if (filter2.Length == 1)
                {
                    itemFilter = item;
                }
                else
                {
                    if (filter2[1].Contains("'%"))
                    {
                        itemFilter = item;
                    }
                    else
                    {
                        itemFilter = filter2[0] + " LIKE '%" + filter2[1].Substring(1);
                    }
                }
                if (string.IsNullOrEmpty(newFilter))
                {
                    newFilter = itemFilter;
                }
                else
                {
                    newFilter = newFilter + " And " + itemFilter;
                }
            }
            girdView.ActiveFilterString = newFilter;
        }