阅读背景:

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

来源:互联网 
        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;
        }        public static void ExportExcel(Form win



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: