ReportManage.jsp
5.33 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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.conn.*" %>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<SCRIPT language="javascript" src="../../js/weaver_wev8.js"></script>
</head>
<%
if(!HrmUserVarify.checkUserRight("ModeSetting:All", user)){
response.sendRedirect("/notice/noright.jsp");
return;
}
String imagefilename = "/images/hdMaintenance_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(15514,user.getLanguage());//报表管理
String needfav ="1";
String needhelp ="";
String reportname = Util.null2String(request.getParameter("reportname"));
String modeid=Util.null2String(request.getParameter("modeid"));
String modename = "";
String sql = "";
if(!modeid.equals("")){
sql = "select modename from modeinfo where id = " + modeid;
rs.executeSql(sql);
while(rs.next()){
modename = Util.null2String(rs.getString("modename"));
}
}
%>
<BODY>
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(197,user.getLanguage())+",javaScript:doSubmit(),_self} " ;//搜索
RCMenuHeight += RCMenuHeightStep ;
RCMenu += "{"+SystemEnv.getHtmlLabelName(365,user.getLanguage())+",javaScript:doAdd(),_self} " ;//新建
RCMenuHeight += RCMenuHeightStep ;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<table width=100% height=100% border="0" cellspacing="0" cellpadding="0">
<colgroup>
<col width="10">
<col width="">
<col width="10">
<tr>
<td height="10" colspan="3"></td>
</tr>
<tr>
<td ></td>
<td valign="top">
<TABLE class=Shadow>
<tr>
<td valign="top">
<form name="frmSearch" method="post" action="/formmode/report/ReportManage.jsp">
<table class="ViewForm">
<COLGROUP>
<COL width="15%">
<COL width="35%">
<COL width="15%">
<COL width="35%">
</COLGROUP>
<tr>
<td>
<%=SystemEnv.getHtmlLabelName(15517,user.getLanguage())%><!-- 报表名称 -->
</td>
<td class="Field">
<input type="text" name="reportname" class="inputStyle" value="<%=reportname%>">
</td>
<td>
<%=SystemEnv.getHtmlLabelName(28485,user.getLanguage())%><!-- 模块名称 -->
</td>
<td class="Field">
<button type="button" class=Browser id=formidSelect onClick="onShowModeSelect(modeid,modeidspan)" name=formidSelect></BUTTON>
<span id=modeidspan><%=modename%></span>
<input type="hidden" name="modeid" id="modeid" value="<%=modeid%>">
</td>
</tr>
<tr style="height:1px"><td colspan=4 class=Line></td></tr>
</table>
</form>
<%
//select a.modeid,a.reportname,a.customdesc,b.modename from mode_customsearch a,modeinfo b where a.modeid = b.id
String SqlWhere = " where a.modeid = b.id";
if(!reportname.equals("")){
SqlWhere += " and a.reportname like '%"+reportname+"%'";
}
if(!modeid.equals("")){
SqlWhere += " and a.modeid = '"+modeid+"'";
}
String perpage = "10";
String backFields = "a.id,a.modeid,a.reportname,a.reportdesc,b.modename";
String sqlFrom = " from mode_report a,modeinfo b";
String tableString=""+
"<table pagesize=\""+perpage+"\" tabletype=\"none\">"+
"<sql backfields=\""+backFields+"\" sqlform=\""+sqlFrom+"\" sqlprimarykey=\"a.id\" sqlsortway=\"Desc\" sqldistinct=\"true\" sqlwhere=\""+Util.toHtmlForSplitPage(SqlWhere)+"\"/>"+
"<head>"+ //报表名称
"<col width=\"30%\" text=\""+SystemEnv.getHtmlLabelName(15517,user.getLanguage())+"\" column=\"reportname\" target=\"_self\" linkkey=\"id\" linkvaluecolumn=\"id\" href=\"/formmode/report/ReportEdit.jsp\" orderkey=\"reportname\"/>"+
//模块名称
"<col width=\"30%\" text=\""+SystemEnv.getHtmlLabelName(28485,user.getLanguage())+"\" column=\"modename\" orderkey=\"modename\"/>"+
//描述
"<col width=\"40%\" text=\""+SystemEnv.getHtmlLabelName(433,user.getLanguage())+"\" column=\"reportdesc\" orderkey=\"reportdesc\"/>"+
"</head>"+
"</table>";
%>
<wea:SplitPageTag tableString='<%=tableString%>' mode="run" isShowTopInfo="true"/>
</td>
</tr>
</TABLE>
</td>
<td></td>
</tr>
<tr>
<td height="10" colspan="3"></td>
</tr>
</table>
<script type="text/javascript">
$(document).ready(function(){//onload事件
$(".loading", window.parent.document).hide(); //隐藏加载图片
if($("#modeid").val()=='0'){
if(confirm("<%=SystemEnv.getHtmlLabelName(30776,user.getLanguage())%>")){//请先保存基本信息！
window.parent.document.getElementById('modeBasicTab').click();
}else{
$('.href').hide();
}
}
})
function doSubmit(){
enableAllmenu();
document.frmSearch.submit();
}
function doAdd(){
enableAllmenu();
location.href="/formmode/report/ReportAdd.jsp?modeid=<%=modeid%>&reportname=<%=reportname%>";
}
function onShowModeSelect(inputName, spanName){
var datas = window.showModalDialog("/systeminfo/BrowserMain.jsp?url=/formmode/browser/ModeBrowser.jsp");
if (datas){
if(datas.id!=""){
$(inputName).val(datas.id);
if ($(inputName).val()==datas.id){
$(spanName).html(datas.name);
}
}else{
$(inputName).val("");
$(spanName).html("");
}
}
}
</script>
</BODY></HTML>