页面多个检索条件下 开发技巧

项目中，经常会遇见查询页面有很多的查询条件，刚入门者通常不知道如何写这些查询，现在以如下图例子说明：

可以看到页面的检索条件如：门，纲，目，科，属，拉丁名，中文名，分布，生物活性，临床报道，药理作用；

SQL语句设计如下：

string.Format("select plantid, phylum, class, plant_order, family, genus, latinname, chinaname, medicinalpart, famt, functionaindi, references, chinasomename, distribute, cultivation, harvestseason, prepare, shapesandproperties, identify, assay, usageanddosage, bioactivity, pharmacological, clinicalreport, createor_id, create_date from PLANTBASIC t WHERE 1=1 {0}", strSql);

 页面后台的方法如下：

 StringBuilder sb = new StringBuilder();
        if (!string.IsNullOrEmpty(this.txtPhyLum.Text.Trim()))
        {
            sb.Append(" AND PHYLUM like '%"+this.txtPhyLum.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtClass.Text.Trim()))
        {
            sb.Append(" AND CLASS LIKE '%"+this.txtClass.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtOrder.Text.Trim()))
        {
            sb.Append(" AND PLANT_ORDER LIKE '%"+this.txtOrder.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtFamily.Text.Trim()))
        {
            sb.Append(" AND FAMILY LIKE '%"+this.txtFamily.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtGenus.Text.Trim()))
        {
            sb.Append(" AND GENUS LIKE '%"+this.txtGenus.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtLatinName.Text.Trim()))
        {
            sb.Append(" AND LATINNAME LIKE '%"+this.txtLatinName.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtCnName.Text.Trim()))
        {
            sb.Append(" AND CHINANAME LIKE '%"+this.txtCnName.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtDistribute.Text.Trim()))
        {
            sb.Append(" AND DISTRIBUTE LIKE '%"+this.txtDistribute.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtBioactivity.Text.Trim()))
        {
            sb.Append(" AND BIOACTIVITY LIKE '%"+this.txtBioactivity.Text.Trim()+"%'");
        }
        if (!string.IsNullOrEmpty(this.txtClinicalReport.Text.Trim()))
        {
            sb.Append(" AND CLINICALREPORT LIKE '%"+this.txtClinicalReport.Text.Trim()+"%'");
        }
        this.hidSql.Value = sb.ToString();

通过这样可以很方便检索出结果、无论是多表检索，还是再复杂的检索。