C# winform 过滤条件

图列

代码

        //加载数据（时间用的dev的dateEdit）
        private void GetData()
        {
            try
            {
                if (MyHelper.IsConn())
                {
                    string strEmpName = txtEmpName.Text.Trim();
                    string strEmp = txtEmp.Text.Trim();
                    string strMachName = txtMachName.Text.Trim();
                    string strMach = txtMachNum.Text.Trim();
                    string strUpTime1 = dateEditUp1.Text.Trim();
                    string strUpTime2 = dateEditUp2.Text.Trim();
                    string strDownTime1 = dateEditDown1.Text.Trim();
                    string strDownTime2 = dateEditDown2.Text.Trim();
                    string strAuditXJ1 = dateEditAudit1.Text.Trim();
                    string strAuditXJ2 = dateEditAudit2.Text.Trim();
                    if (chkUp.Checked == false && chkStatusError.Checked == false
                        && strEmpName == "" && strEmp == "" && strMachName == "" &&  strMach == ""
                        && strUpTime1 == "" && strUpTime2 == "" && strDownTime1 == "" && strDownTime2 == ""
                        && strAuditXJ1 == "" && strAuditXJ2 == "")
                    {
                        MessageBox.Show("请输入筛选条件");
                        return;
                    }
                    string strSQL = @"select t2.FName as 员工,t1.FEmp as 员工工号,t3.FName as 设备名称,t1.FMach as 设备编号,convert(varchar(150),t1.Fdate1,21) as 上机时间,convert(varchar(150),t1.Fdate3,21) as 下机时间,
                                        convert(varchar(150),t4.FdateXJAudit,21) as 审核时间,t1.FFuncNumber as 功能编号,t1.FID as 内码,t1.FNote2 as 下机异常记录,t1.FStatus as 状态
                                        from M_Task_Date t1
                                        inner join M_EMP t2 on t1.FEmp=t2.FNumber
                                        inner join M_Mach t3 on t1.FMach=t3.FNumber
                                        left join M_TaskReport_KB4H t4 on t1.FID=t4.FID
                                        where 1=1 ";
                    if (chkUp.Checked == true){strSQL += " and t1.FStatus = 0 ";}
                    if (chkStatusError.Checked == true){strSQL += " and t1.FNote2<>'' "; }
                    if (strEmpName != "") { strSQL += " and t2.FName like '%" + strEmpName + "%' "; }
                    if (strEmp != "") { strSQL += " and t1.FEmp like '%" + strEmp + "%' "; }
                    if (strMachName != "") { strSQL += " and t3.FName like '%" + strMachName + "%' "; }
                    if (strMach != "") { strSQL += " and t1.FMach like '%" + strMach + "%' "; }
                    if (strUpTime1 != "") { strSQL += " and datediff(day,t1.Fdate1,'" + strUpTime1 + "') <= 0 "; }  //查询大于strUpTime1时间数据
                    if (strUpTime2 != "") { strSQL += " and datediff(day,t1.Fdate1,'" + strUpTime2 + "') >= 0 "; }  //查询小于strUpTime2时间数据
                    if (strDownTime1 != "") { strSQL += " and datediff(day,t1.Fdate3,'" + strDownTime1 + "') <= 0 "; }
                    if (strDownTime2 != "") { strSQL += " and datediff(day,t1.Fdate3,'" + strDownTime2 + "') >= 0 "; }
                    if (strAuditXJ1 != "") { strSQL += " and datediff(day,t4.FdateXJAudit,'" + strAuditXJ1 + "') <= 0 "; }
                    if (strAuditXJ2 != "") { strSQL += " and datediff(day,t4.FdateXJAudit,'" + strAuditXJ2 + "') >= 0 "; }
                    DynWebService BHWS = new DynWebService();
                    DataTable dt = BHWS.ExecPROC(MyHelper.strVerify, MyHelper.strIP, "", "M-" + "15", MyHelper.strIP, strSQL, new string[0]);
                    gridControl1.DataSource = dt;
                    for (int i = 0; i < gridView1.Columns.Count; i++)
                    {
                        gridView1.Columns[i].OptionsColumn.AllowEdit = false;
                    }
                    if (gridView1.Columns.Contains(gridView1.Columns["选择"])) gridView1.Columns["选择"].OptionsColumn.AllowEdit = true;
                    if (gridView1.Columns.Contains(gridView1.Columns["选择"])) gridView1.Columns["选择"].OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
                    //获取页面设置
                    DataTable dtPF = BHWS.GetPageSet(MyHelper.strVerify, MyHelper.strIP, "B-LPrint", MyHelper.strUser, "SJ_JL");
                    if (dtPF.Rows.Count > 0)
                    {
                        for (int i = 0; i < dtPF.Rows.Count; i++)
                        {
                            string strcol = dtPF.Rows[i]["列名"].ToString();
                            if (gridView1.Columns.Contains(gridView1.Columns[strcol]))
                            {
                                gridView1.Columns[strcol].VisibleIndex = Convert.ToInt32(dtPF.Rows[i]["序号"]);
                                gridView1.Columns[strcol].Width = Convert.ToInt32(dtPF.Rows[i]["列宽"]);
                                gridView1.Columns[strcol].Visible = Convert.ToBoolean(dtPF.Rows[i]["显示"]);
                                gridView1.Columns[strcol].Caption = Convert.ToString(dtPF.Rows[i]["显示名称"]);
                                if (Convert.ToString(dtPF.Rows[i]["是否固定列"]) == "True") gridView1.Columns[strcol].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
                            }
                        }
                    }
                    else
                    {
                        gridView1.BestFitColumns();
                    }
                    if (dt.Rows.Count < 1000)
                        gridView1.IndicatorWidth = 35;
                    if (dt.Rows.Count >= 1000)
                        gridView1.IndicatorWidth = 40;
                    if (dt.Rows.Count >= 10000)
                        gridView1.IndicatorWidth = 50;
                    if (dt.Rows.Count >= 100000)
                        gridView1.IndicatorWidth = 60;
                }
                else
                {
                    MessageBox.Show("与服务器断开连接！", "系统提示");
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("程序发生错误！详细信息：" + ex.Message, "系统提示");
                return;
            }
        }