67,515
社区成员
发帖
与我相关
我的任务
分享
<%@ page language="java" pageEncoding="gb2312"%>
<%@ page autoFlush="true" %>
<%@ page import="com.SQF.pub.*" %>
<%@ page import="com.SQF.manage.front.*" %>
<%@ page import="java.util.*" %>
<%
String flag=request.getParameter("flag");
String prjcny=request.getParameter("prjcny");
String table="zn_svintrate";//flag=0 存款利率
String lc="svratetyp";
String strsql="";
String strsql2="";
if("1".equals(flag)){
table="zn_pmrate";
lc="ratetyp";
}else if("2".equals(flag)){//libor 利率
table="zn_fmarketrate";
lc="fratelevel";
strsql=" and currency="+pub_function.checkStr(prjcny);
strsql2=" where currency="+pub_function.checkStr(prjcny);
}
//这句至关重要,一定注意
response.setContentType("text/xml;charset=utf-8");
try{
String sql="select distinct dpdt as dpdt from "+table+strsql2+" order by dpdt desc";
Hashtable[] ht=frontPub.getRowHtbs(sql);
StringBuffer str=new StringBuffer();
str.append("<tree>");
if(ht!=null){
for(int i=0;i<ht.length;i++){
String dpdt=(String)ht[i].get("dpdt");
str.append("<tree text='");
str.append((String)ht[i].get("dpdt"));
str.append("'>");
String sql2="select a.*,b.datalable from "+table+" a "
+" left join pubdatatb b on a."+lc+"=b.datacode and typecode="+pub_function.checkStr(lc)
+" where dpdt="+pub_function.checkStr(dpdt)+strsql+" order by "+lc+" asc";
Hashtable[] ht2=frontPub.getRowHtbs(sql2);
if(ht2!=null){
for(int x=0;x<ht2.length;x++){
String datalable=(String)ht2[x].get("datalable");
if(pub_function.IsEmptyStr(datalable)) continue;
String gurratetyp=(String)ht2[x].get(lc);
String ratecode=(String)ht2[x].get("ratecode");
String ratevalue=(String)ht2[x].get("ratevalue");
str.append("<tree text='");
str.append(datalable+" ("+pub_function.numFormat(Double.parseDouble(ratevalue)*100,"0.0000")+"%)");
str.append("' openIcon='");
str.append(datalable+"#"+gurratetyp+"#"+ratecode+"#"+ratevalue);
str.append("' action='javascript:foo(tree.getSelected().openIcon)' />");
}
}
str.append("</tree>");
}
}
str.append("</tree>");
out.print(str.toString());
}catch( Exception e){
}finally{
out.close();
}
out.flush();
out.close();
%>
<html>
<head>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page autoFlush="true" %>
<%@ page import="java.util.Hashtable" %>
<%@ page import="com.SQF.pub.*" %>
<%@ page import="com.SQF.manage.front.*" %>
<title></title>
<SCRIPT src="/pub/public.js"></SCRIPT>
<script type="text/javascript" src="/njs/xtree.js"></script>
<script type="text/javascript" src="/njs/xmlextras.js"></script>
<script type="text/javascript" src="/njs/xloadtree.js"></script>
<link type="text/css" rel="stylesheet" href="/nstyle/xtree.css" />
<style type="text/css">
.tab2 {
border:1 solid #3DAC33;
border-top-color:#ffffff;
border-right-color:#000000;
border-bottom-color:#000000;
border-left-color: #ffffff;
}
td {font-family:宋体;font-size:12px;}
</style>
<%
String flag=request.getParameter("flag");//flag=0 存款利率
String tname="存款利率档次";
if("1".equals(flag)){
tname="贷款利率档次";
}
if("2".equals(flag)){
tname="libor利率档次";
}
String prjcny=request.getParameter("prjcny");
%>
<script type="text/javascript">
function foo(code) {
var codes=code.split("#");
var returnValue = new Object();
returnValue.gurratelable = codes[0];
returnValue.ratecode = codes[2];
var flg=document.getElementById("flag").value;
if(flg=="0"){
returnValue.gurratetyp = codes[1];
returnValue.gurbserate = (parseFloat(codes[3])*100).toFixed(5);
}else if(flg=="1"){
returnValue.ratelevel = codes[1];
returnValue.bserate = (parseFloat(codes[3])*100).toFixed(5);
}else if(flg="2"){
returnValue.fratelevel = codes[1];
returnValue.bserate = (parseFloat(codes[3])*100).toFixed(5);
}
alert(returnValue.gurratelable);
window.returnValue = returnValue;
window.close();
}
</script>
</head>
<%
%>
<body class="main_body" >
<form name ="mainForm" id="forms" onSubmit="return runsubmit(this)" action="" target="content">
<table width="100%" id="PowerTable0" border="0" cellspacing="0" cellpadding="0" align="center" style="border:1 solid #7F9DB9;
border-top-color: #7F9DB9;
border-right-color: #7F9DB9;
border-bottom-color: #7F9DB9;
border-left-color: #7F9DB9;" >
<input type="hidden" name="flag" id="flag" value="<%=flag%>">
</table>
</form>
<script type="text/javascript">
/// XP Look
webFXTreeConfig.rootIcon = "/images/xp/folder.png";
webFXTreeConfig.openRootIcon = "/images/xp/openfolder.png";
webFXTreeConfig.folderIcon = "/images/xp/folder.png";
webFXTreeConfig.openFolderIcon = "/images/xp/openfolder.png";
webFXTreeConfig.fileIcon = "/images/xp/file.png";
webFXTreeConfig.lMinusIcon = "/images/xp/Lminus.png";
webFXTreeConfig.lPlusIcon = "/images/xp/Lplus.png";
webFXTreeConfig.tMinusIcon = "/images/xp/Tminus.png";
webFXTreeConfig.tPlusIcon = "/images/xp/Tplus.png";
webFXTreeConfig.iIcon = "/images/xp/I.png";
webFXTreeConfig.lIcon = "/images/xp/L.png";
webFXTreeConfig.tIcon = "/images/xp/T.png";
//var tree = new WebFXLoadTree("WebFXLoadTree", "tree1.xml");
//tree.setBehavior("classic");
var tree = new WebFXTree("<%=tname%>");
//alert('00');
//var str=xmlDevokeTans('TRANSCODE=addwork_getTreeData&datacode=assettyp0','treeStr');
//alert(str);
var r = <%=Math.random()%>;
var aurl = "/swotech/proc/addwork/prj/zn_treeServlet1.jsp?number="+r+"&flag=<%=flag%>&prjcny=<%=prjcny%>";
tree.add(new WebFXLoadTreeItem("<%=tname%>", aurl,false));
document.write(tree);
tree.expandAll();
</script>
</body>
</html>