SH高级搜索

前端代码：

createTbar : function() {
			tbarOpr.push('->');
			tbarOpr.push({
				xtype : "label",
				text : "法规或文件名称查询："
			}, {
				xtype:"textfield",
				width:100,
				id:'zName',
				maxLength:100,
				value : jQuery("#zName").val()
		    },'-',{
				text : '查询',
				iconCls : 'previewIcon',
				handler : function() {
					listView.queryResItem();
				}
			});
			tbarOpr.push('-');  
			tbarOpr.push({
				text : '高级查询',
				iconCls:'gj_query',
				handler : function() {
					gjQuery=!gjQuery;
					var dc = document.getElementById('DetailCondition');
                	var oldh = grid.getHeight();
                    if (gjQuery) {
                        var tid =  grid.tbar.id ;
                        var tbarDom = document.getElementById(tid);
						var son= tbarDom.firstChild;
						
						dc.style.display ='';
						if(tbarDom.childNodes.length <2){
							var clone = son.cloneNode(false);
							clone.id = clone.id +'_clone';
							clone.appendChild(dc);
							son.parentNode.appendChild(clone);
						}
					   var dch = Ext.fly(dc).getHeight();
                       grid.tbar.setHeight(27  + dch);
                       grid.setHeight(oldh );
                       jQuery("#gjQuery").val("true");
                    }
                    else {
                    	var dch = Ext.fly(dc).getHeight();
                    	dc.style.display ='none';
                    	grid.setHeight(oldh + dch);
                        grid.tbar.setHeight(27);
                        jQuery("#gjQuery").val("false");
                    }
					
				}
		    });
	
			tbarOpr.push('-');  
			return tbarOpr;
		},
queryResItem : function(v,s) {
			var ptool = Ext.getCmp('page');
			if ( !v ){
			   v = ptool.pageSize;
			}
			var params = {
				"start" : s!=null?s:0,//(ptool.getPageData().activePage -1 ) * v,
				"limit" : v,
				//"zzName" : Ext.getCmp('zName').getValue(),
				"colModel" : "id,zName,forOrg,tNumber,releTime,zStatus,fgfl,orderNo,lastTime,textField,textSrc"
			};
			
			if(gjQuery||jQuery("#gjQuery").val()=="true"){
				params = listView.getParams(params);
			}
			store.load({
				params : params
		    });
		},
		getParams:function(params){
			if(params == null){
				params = {};
			}
			var v = jQuery("#firstArea").val();
			if(v!=null&&v!=""&&v!="0"){
				params.firstArea = v;
			}
			v = jQuery("#secondArea").val();
			if(v!=null&&v!=""&&v!="0"){
				params.secondArea = v;
			}
			v = jQuery("#thirdArea").val();
			if(v!=null&&v!=""&&v!="0"){
				params.thirdArea = v;
			}
			v = jQuery("#status").val();
			if(v!=null&&v!=""){
				params.status = v;
			}
			v = jQuery("#zName2").val();
			if(v!=null&&v!=""){
				params.zName = v;
			
			}
			
			v = jQuery("#textField").val();
			if(v!=null&&v!=""){
				params.textField = v;
				
			}
			v = jQuery("#fgfl").val();
			if(v!=null&&v!=""){
				params.fgfl = v;
			}
			v = jQuery("#forOrg").val();
			if(v!=null&&v!=""){
				params.forOrg = v;
			}
			v = jQuery("#orderNo").val();
			if(v!=null&&v!=""){
				params.orderNo = v;
			}
			v = jQuery("#tNumber").val();
			if(v!=null&&v!=""){
				params.tNumber = v;
			}
			v = jQuery("#lastTime").val();
			if(v!=null&&v!=""){
				params.lastTime = v;
			}
			v = jQuery("#releTime").val();
			if(v!=null&&v!=""){
				params.releTime = v;
			}
			//console.debug(escape(this.jsonSerialize(params)));
			
			return params;
		},

后端代码（修改查询所有方法）：

	@Override
	public PageVo findzcfg(ZZcfg zzcfg, PageVo page, User currentUser) throws Exception {
		StringBuffer hql = new StringBuffer();
 		List<Object> params = new ArrayList<Object>();
		hql.append(" from ZZcfg c ");
		hql.append(" where c.deleted = false ");
        if (StringUtils.isNotBlank(zzcfg.getzName())) {
            hql.append(" and zName like ? ");
            params.add("%" + StringUtils.trim(zzcfg.getzName()) + "%");
        }
        if (StringUtils.isNotBlank(zzcfg.getTextField())) {
            hql.append(" and textField like ? ");
            params.add("%" + StringUtils.trim(zzcfg.getTextField()) + "%");
        }
        if (StringUtils.isNotBlank(zzcfg.getFgfl())) {
            hql.append(" and fgfl like ? ");
            params.add("%" + StringUtils.trim(zzcfg.getFgfl()) + "%");
        }
        if (StringUtils.isNotBlank(zzcfg.getForOrg())) {
            hql.append(" and forOrg like ? ");
            params.add("%" + StringUtils.trim(zzcfg.getForOrg()) + "%");
        }
        if (StringUtils.isNotBlank(zzcfg.gettNumber())) {
            hql.append(" and tNumber like ? ");
            params.add("%" + StringUtils.trim(zzcfg.gettNumber()) + "%");
        }
        if (StringUtils.isNotEmpty(zzcfg.getReleTime())) {
            hql.append(" and releTime = ? ");
            params.add(zzcfg.getReleTime());
           
        }
        if (StringUtils.isNotEmpty(zzcfg.getLastTime())) {
            hql.append(" and lastTime = ? ");
            params.add(zzcfg.getLastTime());
        }
        if (StringUtils.isNotBlank(zzcfg.getOrderNo())) {
            hql.append(" and orderNo like ? ");
            params.add("%" + StringUtils.trim(zzcfg.getOrderNo()) + "%");
        }else {
			hql.append(" order by c.id asc ");
		}
		return this.findByPage(hql.toString(), page, params.toArray());
	}

效果图：

END