C#多条件联合查询,多个文本或者下拉的情况下

  private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                com = comNames.Text.Trim();
                XlName = ComUserName.Text.Trim();
                comUsers = comUser.Text.Trim();
                TxtUlogsS = TxtUlogs.Text.Trim();
                comDs = ComDKQ.Text.Trim();
                SQbase.ReplaceSQLChar(com);
                SQbase.ReplaceSQLChar(XlName);
                SQbase.ReplaceSQLChar(comUsers);
                SQbase.ReplaceSQLChar(TxtUlogsS);
                SQbase.ReplaceSQLChar(Comlogs.Text.Trim());
                if (grid == 1)
                {
                    da1 = DateTime.Parse(dpic1.Value.ToString(dati));
                    da2 = DateTime.Parse(dpic2.Value.ToString(datis));
                    if (da1 >= da2)
                    {
                        MessageBox.Show("开始时间必须小于结束时间", "提示");
                    }
                    else
                    {
                        string sql = string.Format("  where 1=1");

                        if (com == "全部")
                        {
                            sql += string.Format(@"");
                        }
                        else
                        {
                            sql += string.Format(@" and   holderName='" + com + "'");
                        }
                        if (comDs == "全部")
                        {
                            sql += string.Format(@"");
                        }
                        else
                        {
                            sql += string.Format(@" and   Name='" + comDs + "'");
                        }
                        if (CKBox.Checked != true)
                        {
                            sql += string.Format(@" and '" + da2.ToString() + "'>=  g.[OPtime]  and  g.[OPtime]  >='" + da1.ToString() + "'");
                        }
                        else
                        {
                            sql += string.Format(@"");
                        }

                        sql += "  ORDER BY   g.[OPtime] DESC ";

                        DataGdv.DataSource = SKJLS.Cardlogs_Getdate(sql);

                        SQbase.Roswtxt(DataGdv, RoswSTxt);
                    }
                }
                if (grid == 2)
                {

                    da1 = DateTime.Parse(dpic1.Value.ToString(dati));
                    da2 = DateTime.Parse(dpic2.Value.ToString(datis));
                    if (da1 >= da2)
                    {
                        MessageBox.Show("开始时间必须小于结束时间", "提示");
                    }
                    else
                    {
                        string sql = string.Format("  where 1=1");

                        if (comUsers == "全部")
                        {

                            sql += string.Format(@"");
                        }
                        else
                        {

                            sql += string.Format(@"and  ul.[Name] = '" + comUsers + "'");
                        }
                        if (!string.IsNullOrEmpty(TxtUlogsS))
                        {
                            if (TxtUlogsS == "全部")
                            {
                                sql += string.Format(@" and [oEvent] like '%%'");

                            }
                            else
                            {
                                sql += string.Format(@" and [oEvent] like '%" + TxtUlogsS + "%'");

                            }
                        }
                        if (!string.IsNullOrEmpty(Comlogs.Text.Trim()))
                        {
                            if (Comlogs.Text.Trim() == "全部")
                            {
                                sql += string.Format(@"");

                            }
                            else
                            {
                                sql += string.Format(@" and [EventType] like '%" + Comlogs.Text.Trim().ToString() + "%'");

                            }
                        }
                        if (CKBox.Checked != true)
                        {
                            sql += string.Format(@" and ('" + da2.ToString() + "'>OPtime and OPtime>'" + da1.ToString() + "')");
                        }
                        else
                        {
                            sql += string.Format(@"");
                        }
                        sql += " order by  [OPtime] desc";
                        DataGdv.DataSource = YHCZJLS.Userlogs_Getdate(sql);

                        SQbase.Roswtxt(DataGdv, RoswSTxt);
                    }


                }
                if (grid == 3)
                {
                    da1 = DateTime.Parse(dpic1.Value.ToString(dati));
                    da2 = DateTime.Parse(dpic2.Value.ToString(datis));
                    if (da1 >= da2)
                    {
                        MessageBox.Show("开始时间必须小于结束时间", "提示");
                    }
                    else
                    {
                        string sql = "where 1=1";
                        if (!string.IsNullOrEmpty(XlName))
                        {
                            if (XlName == "全部")
                            {

                                sql += string.Format(@"");
                            }
                            else
                            {
                                sql += string.Format(@" and [Name]='" + XlName + "'");
                            }

                        }
                        if (!string.IsNullOrEmpty(com))
                        {

                            if (com == "全部")
                            {

                                sql += string.Format(@"");
                            }
                            else
                            {
                                sql += string.Format(@" and holderName='" + com + "'");
                            }

                        }
                        if (CKBox.Checked != true)
                        {
                            sql += string.Format(@" and '" + da2.ToString() + "'>=OPtime and OPtime >='" + da1.ToString() + "'");
                        }
                        else
                        {
                            sql += string.Format(@"");
                        }
                        sql += string.Format(@" order by  [OPtime] desc ");
                        DataGdv.DataSource = XGJLS.Routelogs_getdate(sql);

                        SQbase.Roswtxt(DataGdv, RoswSTxt);
                    }
                }
                if (grid == 4)
                {
                    da1 = DateTime.Parse(dpic1.Value.ToString(dati));
                    da2 = DateTime.Parse(dpic2.Value.ToString(datis));
                    if (da1 >= da2)
                    {
                        MessageBox.Show("开始时间必须小于结束时间", "提示");
                    }
                    else
                    {
                        string sql = "";
                        if (!string.IsNullOrEmpty(XlName))
                        {
                            if (XlName == "全部")
                            {


                                sql += string.Format(@"");
                            }
                            else
                            {
                                sql += string.Format(@" and [Name]='" + XlName + "'");
                            }

                        }
                        if (!string.IsNullOrEmpty(com))
                        {

                            if (com == "全部")
                            {

                                sql += string.Format(@"");
                            }
                            else
                            {
                                sql += string.Format(@" and  [holderName]='" + com + "'");
                            }

                        }
                        if (CKBox.Checked != true)
                        {
                            sql += string.Format(@" and '" + da2.ToString() + "'>=OPtime and OPtime >='" + da1.ToString() + "'");
                        }
                        else
                        {
                            sql += string.Format(@"");
                        }
                        sql += string.Format(@" order by [RouteLogID],[order]");

                        XGXxShowS(DataGdv, sql);

                        SQbase.Roswtxt(DataGdv, RoswSTxt);
                    }
                }

                if (grid == 5)
                {
                    da1 = DateTime.Parse(dpic1.Value.ToString(dati));
                    da2 = DateTime.Parse(dpic2.Value.ToString(datis));
                    if (da1 >= da2)
                    {
                        MessageBox.Show("开始时间必须小于结束时间", "提示");
                    }
                    else
                    {
                        string sql = "  where [order]=1";
                        if (!string.IsNullOrEmpty(XlName))
                        {
                            if (XlName == "全部")
                            {

                                sql += string.Format(@"");

                            }
                            else
                            {
                                sql += string.Format(@" and t.[Name] ='" + XlName + "'");



                            }
                        }
                        if (!string.IsNullOrEmpty(com))
                        {
                            if (com == "全部")
                            {

                                sql += string.Format(@"");
                            }
                            else
                            {
                                sql += string.Format(@" and [holderName]='" + com + "'");
                            }

                        }
                        if (CKBox.Checked != true)
                        {
                            sql += string.Format(@" and '" + da2.ToString() + "'> NextActioT and  NextActioT>'" + da1.ToString() + "'");
                        }
                        else
                        {
                            sql += string.Format(@"");
                        }

                        sql += string.Format(@"      order by Startuptime,e.[RouteID],[Order]  ");

                        XLXGS(DataGdv, sql);

                        if (!string.IsNullOrEmpty(XlName) && XlName != "全部")
                        {
                            DataTable dtco = new DataTable();

                            dtco = bl.countS(XlName);

                            foreach (DataRow dr in dtco.Rows)
                            {
                                if (dr[0].ToString() != "0")
                                {

                                    DataGdv.Rows[0].Cells[4].Value = dr[0].ToString();

                                }
                                else
                                {

                                    RoswSTxt.Text = "";

                                }
                            }
                        }

                        SQbase.Roswtxt(DataGdv, RoswSTxt);

                    }

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());

            }
        }