用数据查询-CSDN博客

本文链接：https://blog.csdn.net/qq_43403588/article/details/137729480
    //查询按钮
        private void btnSearch_Click(object sender, EventArgs e)
        {
            List<DataTreeNode> data = new List<DataTreeNode>();
            data = DataTreeListHelper.ParseDir(Common.Global.AppConfig.TestDataDir, data);
            var result = data.Where(p => p.NodeType == DataTreeNodeTypes.File);
            if (ceKeyWord.Checked)
            {
                if (String.IsNullOrEmpty(this.txtKeyWork.Text))
                {
                    string msg = "请输入关键字!";
                    DevExpress.XtraEditors.XtraMessageBox.Show(msg, Wongoing.Basic.LanguageHelper.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                else
                {
                    result = result.Where(p => p.NodeText.ToLower().Contains(this.txtKeyWork.Text.ToLower()));
                }
            }
            if (ceDateTime.Checked)
            {
                if (String.IsNullOrEmpty(this.deBeginDate.Text))
                {
                    string msg = "请选择开始日期!"; ;
                    DevExpress.XtraEditors.XtraMessageBox.Show(msg, Wongoing.Basic.LanguageHelper.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                if (String.IsNullOrEmpty(this.deEndDate.Text))
                {
                    string msg = "请选择结束日期!";
                    DevExpress.XtraEditors.XtraMessageBox.Show(msg, Wongoing.Basic.LanguageHelper.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                result = result.Where(p => Wongoing.Basic.DataProcessor.ConvertStrToDateTime(p.CreateDate) >= Wongoing.Basic.DataProcessor.ConvertStrToDateTime(this.deBeginDate.Text));
                result = result.Where(p => Wongoing.Basic.DataProcessor.ConvertStrToDateTime(p.CreateDate) <= Wongoing.Basic.DataProcessor.ConvertStrToDateTime(this.deEndDate.Text));
                Console.WriteLine(this.deBeginDate.Text);
                Console.WriteLine(this.deEndDate.Text);
            }
            if (ceTaskFile.Checked)
            {
                if (String.IsNullOrEmpty(this.txtTaskFile.Text))
                {
                    string msg = "请输入任务文件名!";
                    DevExpress.XtraEditors.XtraMessageBox.Show(msg, Wongoing.Basic.LanguageHelper.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                result = result.Where(p => p.NodeText.ToLower().Contains(this.txtTaskFile.Text.ToLower()));
            }
            if (ceBarcode.Checked)
            {
                if (String.IsNullOrEmpty(this.txtBarcode.Text))
                {
                    string msg = "请输入电池条码!";
                    DevExpress.XtraEditors.XtraMessageBox.Show(msg, Wongoing.Basic.LanguageHelper.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                result = result.Where(p => p.NodeText.Contains(this.txtBarcode.Text));
            }
            this.gridControl1.DataSource = result;
            Common.GridControl.GridControlHelper.DisableSelectStyle(this.gridControl1.MainView as DevExpress.XtraGrid.Views.Base.ColumnView);
        }