<%@page import="com.amarsoft.asquery.*"%> <%@page contentType="text/html; charset=GBK"%><%@ include file="/IncludeBeginMDAJAX.jsp"%><% /* Content: 对查询条件进行处理,生成Sql */ String queryClass = CurPage.getParameter("queryClass"); //JBO主对象 //String groupString = CurPage.getParameter("GroupList;;Other;"); //分组列表 String summaryString = CurPage.getParameter("SummaryList;;Other;"); //汇总列表 String orderString = CurPage.getParameter("OrderList;;Other;"); //排序列表 String displayString = CurPage.getParameter("DisplayList;;Other;"); //显示列表 String displayNames = CurPage.getParameter("displayNames"); //显示列表 String queryModelName = CurPage.getParameter("queryModelName"); //查询模块名称 String saveflag = CurPage.getParameter("saveflag"); //保存标识 //if(groupString==null) groupString=""; if(summaryString==null) summaryString=""; if(orderString==null) orderString=""; if(displayString==null) displayString=""; if(saveflag==null) saveflag=""; if(queryModelName==null) queryModelName=""; //处理显示字段 if(StringX.isEmpty(displayString)) displayString = "*"; //有合计字段的,拼接在显示字段 if(!StringX.isEmpty(summaryString)) displayString += "," + summaryString; //构造查询方案,生成真正sql ASQueryScheme queryScheme = new ASQueryScheme(request, queryClass); queryScheme.setDisplayItems(displayString); queryScheme.setSummaryItems(summaryString); queryScheme.setOrderItems(orderString); String querySQL = queryScheme.genQuerySQL(); /* //添加默认条件 String defaultValue = (String)JboRelatedObjCache.getInstance().getdefaultConditionMap().get(queryClass); if(defaultValue!=null){ querySQL += defaultValue; } */ querySQL = StringFunction.replace(querySQL,"#ManageOrgID","(select ORG_INFO.OrgID from jbo.xquery.ORG_INFO ORG_INFO where ORG_INFO.SortNo like '"+CurOrg.getSortNo()+"%')"); querySQL = StringFunction.replace(querySQL,"#OperateOrgID","(select ORG_INFO.OrgID from jbo.xquery.ORG_INFO where ORG_INFO.SortNo like '"+CurOrg.getSortNo()+"%')"); ARE.getLog().debug(">>>>[querySQL]=="+querySQL); ARE.getLog().debug("[displayString]=="+displayString+"@@[orderString]=="+orderString); //保存查询方案 queryScheme.setQuerySQL(querySQL); if("1".equals(saveflag)){ queryScheme.saveScheme(); //异步查询方案名称 queryModelName=queryScheme.getQuerySchemeName(); } session.setAttribute("queryModelName", queryModelName); session.setAttribute("querySQL",querySQL); session.setAttribute("querySQLHeaders",displayNames); %><%@ include file="/IncludeEndAJAX.jsp"%>