dialogAdvanceAmountOfHistoryQry.jsp
5.39 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
<%@page import="java.text.DecimalFormat"%>
<%@page import="weaver.workflow.field.BrowserComInfo"%>
<%@page import="weaver.fna.budget.FnaWfSet"%>
<%@page import="weaver.systeminfo.label.LabelComInfo"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@ taglib uri="/browserTag" prefix="brow"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@ page import="weaver.general.Util" %>
<%@ 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" />
<jsp:useBean id="UserDefaultManager" class="weaver.docs.tools.UserDefaultManager" scope="session" />
<%
if(user==null){
response.sendRedirect("/notice/noright.jsp") ;
return ;
}
DecimalFormat df = new DecimalFormat("#################################################0.00");
int requestid = Util.getIntValue(request.getParameter("requestid"));
int workflowid = Util.getIntValue(request.getParameter("workflowid"));
int detailRecordId = Util.getIntValue(request.getParameter("detailRecordId"));
%>
<HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<script language="javascript" src="/wui/theme/ecology8/jquery/js/zDialog_wev8.js"></script>
<script language="javascript" src="/wui/theme/ecology8/jquery/js/zDrag_wev8.js"></script>
<script language="javascript" src="/js/weaver_wev8.js"></script>
<script language="javascript" src="/fna/js/e8Common_wev8.js?r=3"></script>
</head>
<%
String imagefilename = "/images/hdMaintenance_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(82,user.getLanguage())+SystemEnv.getHtmlLabelName(83190,user.getLanguage());
String needfav ="1";
String needhelp ="";
%>
<BODY style="overflow:hidden;">
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<div class="zDialog_div_content">
<jsp:include page="/systeminfo/commonTabHead.jsp">
<jsp:param name="mouldID" value="fna"/>
<jsp:param name="navName" value="<%=SystemEnv.getHtmlLabelName(83190,user.getLanguage()) %>"/>
</jsp:include>
<table id="topTitle" cellpadding="0" cellspacing="0">
<tr><td> </td>
<td class="rightSearchSpan" style="text-align: right;">
<span title="<%=SystemEnv.getHtmlLabelNames("83190,83", user.getLanguage())%>" class="cornerMenu"></span>
</td>
</tr>
</table>
<form action="">
<%
//设置好搜索条件
//select * from FnaAdvanceInfoAmountLog a where a.dtlid = 275 ORDER BY a.id desc
String backFields =" createUid, amountAdvanceAfter, createDate, memo1 ";//禁用
String fromSql = " from FnaAdvanceInfoAmountLog a \r";
String sqlWhere = " where a.requestid = "+requestid+" and a.dtlid = "+detailRecordId+" ";
String orderBy = " a.id ";
String sqlprimarykey = "a.id";
//out.println("select "+backFields+" "+fromSql+" "+sqlWhere+" order by "+orderBy);
String tableString=""+
"<table pagesize=\"6\" tabletype=\"none\">"+
"<sql backfields=\""+Util.toHtmlForSplitPage(backFields)+"\" sqlform=\""+Util.toHtmlForSplitPage(fromSql)+"\" sqlwhere=\""+Util.toHtmlForSplitPage(sqlWhere)+"\" "+
" sqlorderby=\""+Util.toHtmlForSplitPage(orderBy)+"\" "+
" sqlprimarykey=\""+Util.toHtmlForSplitPage(sqlprimarykey)+"\" sqlsortway=\"desc\" />"+
"<head>"+
"<col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(15823,user.getLanguage())+"\" column=\"createUid\" "+//调整人
" transmethod=\"weaver.fna.general.FnaSplitPageTransmethod.getHrmNameLink\" />"+
"<col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(83278,user.getLanguage())+"\" column=\"amountAdvanceAfter\" "+//调整后金额
" />"+
"<col width=\"20%\" text=\""+SystemEnv.getHtmlLabelName(18254,user.getLanguage())+"\" column=\"createDate\" orderkey=\"createDate\" "+//调整时间
" />"+
"<col width=\"40%\" text=\""+SystemEnv.getHtmlLabelName(83241,user.getLanguage())+"\" column=\"memo1\" "+//调整说明
" />"+
"</head>"+
"</table>";
%>
<wea:layout type="1col">
<wea:group context="" attributes="{'groupDisplay':'none'}">
<wea:item attributes="{'isTableList':'true'}">
<wea:SplitPageTag tableString='<%=tableString%>' mode="run" />
</wea:item>
</wea:group>
</wea:layout>
</form>
<jsp:include page="/systeminfo/commonTabFoot.jsp"></jsp:include>
</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 class="zd_btn_cancle" type="submit" id="btnClose" onclick="doClose();"
value="<%=SystemEnv.getHtmlLabelName(201,user.getLanguage())%>"/><!-- 取消 -->
</wea:item>
</wea:group>
</wea:layout>
</div>
<script language=javascript>
var _Label33574 = "<%=SystemEnv.getHtmlLabelName(33574,user.getLanguage()) %>";//正在处理数据，请不要离开该页面，请稍等...
jQuery(document).ready(function(){
resizeDialog(document);
});
//快速（高级）搜索事件
function onBtnSearchClick(from_advSubmit){
}
//关闭
function doClose(){
//var parentWin = parent.getParentWindow(window);
//parentWin.closeDialog();
var dialog = parent.getDialog(window);
dialog.closeByHand();
}
function onCancel(){
var dialog = parent.getDialog(window);
dialog.close();
}
</script>
</BODY>
</HTML>