excelsetDimension.jsp
3.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<html>
<%
String accountId = Util.null2String(request.getParameter("accountId"));
String isrc = Util.null2String(request.getParameter("isrc"));
//以后可改成缓存类
String numberCode = "";
rs.executeQuery(" select numberCode from FnaAccountInfo where id = ? ", accountId);
if(rs.next()){
numberCode = Util.null2String(rs.getString("numberCode"));
}
String noticeinfo = "row".equals(isrc) ? "行维":"列维";
%>
<head>
<title>行列维度设置</title>
<style type="text/css">
.div_select {
float:left;
vertical-align: middle;
line-height:30px;
}
</style>
<script type="text/javascript">
var dialog = window.top.getDialog(window);
function setDimension(){
var dimensionVal = jQuery.trim($('#dimension').val());
var dimensionText = jQuery.trim($('#dimension').find("option:selected").text());
var dimensionStatus = jQuery.trim($('#dimensionStatus').val());
var dimensionStatusText = jQuery.trim($('#dimensionStatus').find("option:selected").text());
var djson = {op:"edit",value:dimensionVal,text:dimensionText,status:dimensionStatus,statusText:dimensionStatusText};
dialog.close(djson);
}
function clearDimension(){
var djson = {op:"clear"};
dialog.close(djson);
}
</script>
</head>
<body style='overflow: hidden'>
<div style="font-size:9pt;margin:10px;">
<div id="div_dimension" style="padding:6px;">
<div class="div_select" style="width:60px;"><%=noticeinfo %> : </div>
<div class="div_select" >
<select id="dimension" name="dimension" onchange="memberSearch();" style="width:105px;">
<%
rs.executeQuery("select id, dimensionName from FnaBudgetDimension_"+numberCode+" order by displayOrder ");
while(rs.next()){
String id = Util.null2String(rs.getString("id"));
String dimensionName = Util.null2String(rs.getString("dimensionName"));
%>
<option value="<%=id%>" ><%=dimensionName%></option>
<%
}
%>
</select>
</div>
<div style="margin-top:32px;">
<div class="div_select" style="width:60px;"><%=SystemEnv.getHtmlLabelName(501186, user.getLanguage()) %> : </div>
<div class="div_select" >
<select id="dimensionStatus" name="dimensionStatus" style="width:105px;">
<option value="0"><%=SystemEnv.getHtmlLabelName(501185, user.getLanguage()) %></option>
<option value="1"><%=SystemEnv.getHtmlLabelName(1823, user.getLanguage()) %></option>
</select>
</div>
</div>
</div>
</div>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
<wea:layout needImportDefaultJsAndCss="false">
<wea:group context="" attributes="{groupDisplay:none}">
<wea:item type="toolbar">
<input type="button" value="确定" id="nextStepBtn" class="zd_btn_cancle" onclick="setDimension();">
<input type="button" value="清除" id="cancelBtn" class="zd_btn_cancle" onclick="clearDimension()">
</wea:item>
</wea:group>
</wea:layout>
</div>
</body>
</html>