queryedit.jsp

管理公司合同

<%@ page contentType = "text/html;charset=GBK"%>
<%@ taglib uri="/WEB-INF/tag.tld" prefix="tag" %>
<%@ taglib uri="/WEB-INF/displaytag-11.tld" prefix="display" %>
<%@ page import="cn.com.juneng.system.common.COMMON"%>
<%@ page import="cn.com.juneng.system.vo.QueryHeaderVOImpl"%>
<%@ page import="java.util.List" %>
<%@ page import="cn.com.juneng.system.vo.QueryDetailVOImpl" %>
<link href="<%=request.getContextPath()%>/css/commonPage.css" rel="stylesheet" type="text/css">
<script type='text/javascript' language='JavaScript' src='<%=request.getContextPath()%>/js/COMMON.js'></script>
<script type='text/javascript' language='JavaScript' src='<%=request.getContextPath()%>/js/calendar.js'></script>
<script language="JavaScript" src="<%=request.getContextPath()%>/js/xmlhttp.js"></script>
<%
	QueryHeaderVOImpl vo = (QueryHeaderVOImpl)request.getAttribute("VO");
	List detailList = (List)request.getAttribute("DetailList");
%>
<script>
	function toSpell(){
		var hz = event.srcElement.value;
		var spell = "";
		if(hz!=""){
			var res = new methodInvoke("cn.com.juneng.system.common.util.CnToSpell","getFirstSpell",hz);
			spell = res[1];
		}
		form1.queryIndex.value = spell;
	}
	function addDetail(){
		form1.actionType.value = "newDetail";
		form1.submit();
	}
	function	query(size){
		if(size!=0){
			window.location="<%=request.getContextPath()%>/system/query/condition.jsp?queryId=<%=vo.getQueryId()%>";
		}else{
			//window.location="<%=request.getContextPath()%>/standard/queryHeader.do?Type=execute&QueryId=<%=vo.getQueryId()%>";
			//form1.target = "_blank";
			form1.method = "get";
			form1.actionType.value = "execute";
			form1.submit();
		}
	}
</script>
<table >
<tr>
<td class="tHeading"><div align='center'><b>查询定制<%=vo.isReadonly()?"":".编辑"%></b></div></td>
</tr>
<%
if(request.getAttribute("Error")!=null){%>
<tr>
<td ><font color='red'><%=request.getAttribute("Error")%></font></td>
</tr>
<%}%>
</table>
<form name="form1" action="<tag:attr source="ActionUrl" />" method="post">
<input type="hidden" name="readonly" value="<tag:attr source="VO" attr="readonly" />">
<input type="hidden" name="currentPage" value="<tag:attr source="VO" attr="currentPage" />">
<input type="hidden" name="actionType" value="<tag:attr source="VO" attr="actionType" />">
<input type="hidden" name="queryId" value="<tag:attr source="VO" attr="queryId" />">
<input type="hidden" name="queryDetailId" value="<tag:attr source="VO" attr="queryId" />">

<table <%=COMMON.TABLE_STYLE %> >
	<tr>
		<td class="list_condition_td_title" width='20%'>对应数据源</td>
		<td class="list_condition_td_input" width='30%'>
		<tag:dic name="queryType" value="<%=vo.getQueryType() %>" sql="select SOURCE_ID as CODE,SOURCE_NAME as detail from data_source"  showType="select" attr="required='true'"/>
		<td class="list_condition_td_title" width='20%'>查询标题</td>
		<td class="list_condition_td_input" width='30%'><input type="text"  required='true' name="queryName" value="<tag:attr source="VO" attr="queryName" />" onpropertychange='toSpell()'></td>
	</tr>
	<tr>
		<td class="list_condition_td_title" width='20%'>英文标识</td>
		<td class="list_condition_td_input" width='30%'><input type="text"  required='true' name="queryIndex" value="<tag:attr source="VO" attr="queryIndex" />"></td>
		<td class="list_condition_td_title">优先级</td>
		<td class="list_condition_td_input" ><input type="text"  required='true' name="priority" value="<tag:attr source="VO" attr="priority" />"></td>
	</tr>
	<tr>
		<td class="list_condition_td_title">查询SQL语句</td>
		<td class="list_condition_td_input" colspan='3'>
			<textarea required='true' name="queryContent" style="width:100%" rows='5'><tag:attr source="VO" attr="queryContent" /></textarea>
		</td>
	</tr>
	<tr>
		<td class="list_condition_td_title">其他选项，如排序和分组</td>
		<td class="list_condition_td_input" colspan='3'><input type="text"  style="width:100%" name="queryOther" value="<tag:attr source="VO" attr="queryOther" />"></td>
	</tr>
	<tr>
		<td class="list_condition_td_title">引用的HTML</td>
		<td class="list_condition_td_input" colspan='3'><input type="text"  style="width:100%" name="includeHtml" value="<tag:attr source="VO" attr="includeHtml" />"></td>
	</tr>
	<tr>
		<td class="list_condition_td_title">引用的JScript</td>
		<td class="list_condition_td_input" colspan='3'><input type="text"  style="width:100%" name="includeJs" value="<tag:attr source="VO" attr="includeJs" />"></td>
	</tr>
	<tr>
		<td class="list_condition_td_title">超连接的列</td>
		<td class="list_condition_td_input" ><input type="text"  name="linkColumn" value="<tag:attr source="VO" attr="linkColumn" />"></td>
		<td class="list_condition_td_title">超连接的SRC</td>
		<td class="list_condition_td_input" ><input type="text"  name="linkSrc" value="<tag:attr source="VO" attr="linkSrc" />"></td>
	</tr>
</table><br>
<%if(!vo.isReadonly()){%><input type=submit id="s_button" ACCESSKEY="S" title="【CTRL+S】或者【ALT+S】快速存盘" value="保存" onclick="return CheckForm(form1)"><%}%>
<%if("save".equals(vo.getActionType())){%>
<input type=button value="测试"  onclick="query(<%=detailList.size()%>)">
<%}%>
<input type=button value="返回" onclick='back()'>
<%if("save".equals(vo.getActionType())){%>
<br>
<div align='left'><strong>查询条件明细</strong></div>
<HR width=100% color='#663366' size='1' align=center>
<display:table class="its" name="DetailList"  id="VO1" export="false" attribute="<%=COMMON.TABLE_STYLE%>">
	<display:column title="选择" attribute="style='cursor:hand' title='点击全选' onclick=\"selectAll('Ids')\"">
		<input type=checkbox name=Ids value='<tag:attr source="VO1" attr="queryDetailId" />'>
	</display:column>
	<display:column title="查询项目" attribute="style='cursor:hand' title='点击排序' onclick=\"orderBy('detailDesc')\"" >
		<a  href="#" onclick="form1.queryDetailId.value='<tag:attr source="VO1" attr="queryDetailId" />';form1.actionType.value='viewDetail';form1.submit()">
			<tag:attr source="VO1" attr="detailDesc" />
		</a>
	</display:column>
	<display:column title="对应数据库列" attribute="style='cursor:hand' title='点击排序' onclick=\"orderBy('queryColumn')\"" property="queryColumn"/>
	<display:column title="匹配条件" attribute="style='cursor:hand' title='点击排序' onclick=\"orderBy('condition')\"" property="condition"/>
	<display:column title="是否必填项" attribute="style='cursor:hand' title='点击排序' onclick=\"orderBy('isNeed')\"" >
		<tag:dic name="isNeed" value="<%=((QueryDetailVOImpl)VO1).getIsNeed() %>" kind="002"  onlyshow="true"/>
	</display:column>
</display:table>
<br>
<input type=button value="增加明细" onclick="addDetail()">
<input type=button value="删除明细" onclick="selectAndExecute('delDetail') ">	
<%}%>	
</form>