代码如下: StringBuilder selCondition = new StringBuilder();
        selCondition.Append("select EDOCKEYID,QZH,MENLEI,ZRZ,AJTM");
        selCondition.Append(" from MainDoc");
        if (ddlSelectField.SelectedValue.ToString() == "selectAll")
        {
            selCondition.Append(" where QZH like  '%@QZH%' or");
            selCondition.Append(" AJTM like  '%@AJTM%' or");
            selCondition.Append(" MENLEI like  '%@MENLEI%' or");
            selCondition.Append(" GDND like  '%@GDND%' or");
            selCondition.Append(" BGQX like  '%@BGQX%' or");
            selCondition.Append(" CWND like  '%@CWND%' or");
            selCondition.Append(" CWYF like  '%@CWYF%' or");
            selCondition.Append(" CWRQ like  '%@CWRQ%' or");
            selCondition.Append(" WJND like  '%@WJND%' or");
            selCondition.Append(" WJDZ like  '%@WJDZ%' or");
            selCondition.Append(" WJBH like  '%@WJBH%' or");
            selCondition.Append(" ZRZ like  '%@ZRZ%' or");
            selCondition.Append(" KFBZ like  '%@KFBZ%'");
            SqlParameter[] paraments ={
                        new SqlParameter("@QZH",SqlDbType.VarChar),
                        new SqlParameter("@AJTM",SqlDbType.VarChar),
                        new SqlParameter("@MENLEI",SqlDbType.VarChar),
                        new SqlParameter("@GDND",SqlDbType.VarChar),
                        new SqlParameter("@BGQX",SqlDbType.VarChar),
                        new SqlParameter("@CWND",SqlDbType.VarChar),
                        new SqlParameter("@CWYF",SqlDbType.VarChar),
                        new SqlParameter("@CWRQ",SqlDbType.VarChar),
                        new SqlParameter("@WJND",SqlDbType.VarChar),
                        new SqlParameter("@WJDZ",SqlDbType.VarChar),
                        new SqlParameter("@WJBH",SqlDbType.VarChar),
                        new SqlParameter("@ZRZ%",SqlDbType.VarChar),
                        new SqlParameter("@KFBZ",SqlDbType.VarChar)}
%号应该怎么样加
请那位大虾指点一下