📄 archive_query_name_modify.jsp
字号:
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import = "java.net.URLEncoder"%>
<%@ page import = "java.util.*"%>
<%@ page import = "cn.js.fan.util.*"%>
<%@ page import = "cn.js.fan.web.*"%>
<%@ page import = "com.redmoon.oa.archive.*"%>
<%@ page import = "com.redmoon.oa.BasicDataMgr"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>用户档案查询</title>
<script language="javascript" type="text/javascript">
function saveQuery(){
window.location.href='archive_query_list.jsp?sql='+form1.sql.value+'&show_field_code='+form1.show_field_code.value;
}
</script>
<link href="../common.css" rel="stylesheet" type="text/css">
</head>
<body>
<jsp:useBean id="privilege" scope="page" class="com.redmoon.oa.pvg.Privilege"/>
<%
//if (!privilege.isUserPrivValid(request, "archive")) {
//out.println(cn.js.fan.web.SkinUtil.makeErrMsg(request, cn.js.fan.web.SkinUtil.LoadString(request, "pvg_invalid")));
//return;
//}
%>
<br>
<%
String table_code = ParamUtil.get(request,"table_code");
String show_field_code = ParamUtil.get(request,"show_field_code");
String save_condition_field_code = ParamUtil.get(request,"save_condition_field_code");
String sel_condition_field_code = ParamUtil.get(request,"sel_condition_field_code");
String order_field_code = "",new_order_field_code = "";
String[] fieldCodeArr = ParamUtil.getParameters(request,"field_code");
int i = 0;
while(i < fieldCodeArr.length){
if(!fieldCodeArr[i].equals("")){
order_field_code += fieldCodeArr[i] + ",";
}
i++;
}
new_order_field_code = order_field_code.substring(0,order_field_code.lastIndexOf(","));
String sql = "select " + show_field_code + " from " + table_code + " where " + sel_condition_field_code + " order by " + new_order_field_code;
%>
<form name="form1" method="post" action="archive_query_do.jsp?op=add">
<table width="95%" border="0">
<tr>
<td>
<table class="tableframe" cellSpacing="1" cellPadding="2" width="95%" align="center" border="0" bgcolor="#FFFFFF">
<tbody>
<tr>
<td colspan="3" class="right-title">综合查询</td>
</tr>
<tr>
<td width="10%" noWrap>查询名称：</td>
<td width="90%" noWrap><input type="text" name="query_name"></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td align="center"><input value="保存查询" type="submit" >
<input value="立即查询" type="button" onClick="saveQuery()">
<input type="hidden" name="table_code" value="<%=table_code%>">
<input type="hidden" name="show_field_code" value="<%=show_field_code%>">
<input type="hidden" name="save_condition_field_code" value="<%=save_condition_field_code%>">
<input type="hidden" name="sel_condition_field_code" value="<%=sel_condition_field_code%>">
<input type="hidden" name="order_field_code" value="<%=new_order_field_code%>">
<input type="hidden" name="sql" value="<%=StrUtil.UrlEncode(sql)%>">
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -