筛选函数

  private void queryIndent_Click(object sender, EventArgs e)
        {
            string GS = this.CompanySelect.Text;
            string DDBH = this.OrderNumber.Text.Trim();
            string KHBH = this.CustomerNumber.Text.Trim();
            string CPBH = this.GoodsNumber.Text;
            string State = this.state.Text;
            string GGTZD = this.ChangeDoc.Text;
            string JLY = this.Recorder.Text.Trim();
             string StringKDRQfrom = this.OrderDateFrom.Value.ToString();
            string StringKDRQto = this.OrderDateTo.Value.ToString();
            string StringJHRQfrom = this.DeliveryDateFrom.Value.ToString();
            string StringJHRQto = this.DeliveryDateTo.Value.ToString();

 if (DDBH != "")
                DDBH = "DDBH like '%" + DDBH+"%'";

            if (GS != "")
                if(DDBH!="")
                   GS = "and Company ='" + GS + "'";
                 else
                   GS = "Company ='" + GS + "'";

            if (KHBH != "")
                if(DDBH!="" || GS != "")
                  KHBH = "and KHBH like '%" + KHBH + "%'";
                else
                  KHBH = "KHBH like '%" + KHBH + "%'";

            if (CPBH != "")
                if (DDBH != "" || GS != "" || KHBH!="")
                  CPBH = "and CX like '%" + CPBH + "%'";
                else
                  CPBH = "CX like '%" + CPBH + "%'";

            if (State != "")
                if (DDBH != "" || GS != "" || KHBH != "" || CPBH!="")
                   State = "and State like '%" + State + "%'";
                else
                   State = "State like '%" + State + "%'";

            if (GGTZD != "")
                if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "")
                   GGTZD = "and GGD like '%" + GGTZD + "%'";
                else
                   GGTZD = "GGD like '%" + GGTZD + "%'";

            if (JLY != "")
                if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "")
                   JLY = "and ZDY like '%" + JLY + "%'";
                else
                   JLY = "ZDY like '%" + JLY + "%'";

           if (StringKDRQfrom!="")
                if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "")
                    StringKDRQfrom = "and ZDRQ >'" + StringKDRQfrom + "'";
                else
                    StringKDRQfrom = "ZDRQ >'" + StringKDRQfrom + "'";

          if (StringKDRQto!="")
                if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "")
                    StringKDRQto = "and ZDRQ < '" + StringKDRQto + "'";
                else
                    StringKDRQto = "ZDRQ < '" + StringKDRQto + "'";


            if (StringJHRQfrom!="")
                if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "" || StringKDRQto != "")
                    StringJHRQfrom = "and CHRQ > '" + StringJHRQto + "'";
                else
                  StringJHRQfrom = "CHRQ > '" + StringJHRQfrom + "'";


          if (StringJHRQto!="")
                if (DDBH != "" || GS != "" || KHBH != "" || CPBH != "" || State != "" || GGTZD != "" || JLY != "" || StringKDRQfrom != "" || StringKDRQto != "" || StringJHRQfrom != "")
                    StringJHRQto = "and CHRQ < '" + StringJHRQto + "'";
                else
                    StringJHRQto = "CHRQ < '" + StringJHRQto + "'";


            string sql = "select DDBH,Company,ZDRQ,KHBH,DHDW,CX,SL,CHRQ,State,SM,ZDY,GGD from DHZZD where " + DDBH + GS + KHBH + CPBH + State + GGTZD + JLY + StringKDRQfrom + StringKDRQto + StringJHRQfrom + StringJHRQto;
 
            BindSearchResult(sql);

            SetColumns();
                  }
         }
}