55 lines
2.5 KiB
Plaintext
55 lines
2.5 KiB
Plaintext
<%@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"%> |