📄 scm_bom_view.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.util.*, java.lang.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.easycon.platform.po.UniversalValueObject"%>
<%@ page import="com.easycon.platform.system.db.DBTransaction"%>
<%@ page import="com.easycon.platform.frame.dao.DAOUniversal"%>
<%@ page import="com.easycon.platform.frame.CMDUniOperation"%>
<html>
<head>
<title>TAB</title>
<SCRIPT language=javascript src="/plats/js/ui.js"></SCRIPT>
<SCRIPT language=javascript src="/plats/js/util.js"></SCRIPT>
<SCRIPT language=javascript src="/plats/js/Popcalendar.js"></SCRIPT>
<SCRIPT language=javascript src="/plats/js/check_1.js"></SCRIPT>
<script language="javaScript" src="/plats/PS/js/MzTreeView12.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style>
body {font:normal 12px 宋体;MARGIN: 0px;}
a.MzTreeview /* TreeView 链接的基本样式 */ { cursor: hand; color: black; font:normal 12px 宋体; text-decoration: none; }
.MzTreeViewRow {border:none;width:500px;padding:0px;margin:0px;border-collapse:collapse}
.MzTreeViewCell0 {border-bottom:1px solid #CCCCCC;padding:0px;margin:0px;}
.MzTreeViewCell1 {border-bottom:1px solid #CCCCCC;border-left:1px solid #CCCCCC;width:200px;padding:0px;margin:0px;}
</style>
</head>
<%
String fjbm=request.getParameter("FJBM");
String fjmc=request.getParameter("FJMC");
%>
<body onload="__pageLoad()">
<TABLE><tr><td><font size="2"><b> 名称 - 数量 - 产出率</b></font><div id="kkk"></div></td></tr></TABLE>
<script language="javascript" type="text/javascript">
<!--
window.tree = new MzTreeView("tree");
tree.icons["book"] = "book.gif";
/*
tree.icons["property"] = "property.gif";
tree.icons["css"] = "collection.gif";
tree.icons["event"] = "collection.gif";
tree.icons["book"] = "book.gif";
tree.iconsExpand["book"] = "bookopen.gif"; //展开时对应的图片
*/
tree.setIconPath("images/"); //可用相对路径
tree.N["0_<%=fjbm%>"] = "T:<%=fjmc%>;"
<%
CMDUniOperation deluni = new CMDUniOperation();
DBTransaction tranc = new DBTransaction();
Collection coll = null;
deluni.setTransaction(tranc);
try {
String sql = "SELECT FJBM || '_' || ZJBM AS BM, NVL(ZJMC,'') AS ZJMC, NVL(ZJDW,'') AS ZJDW, NVL(ZJGG,'') AS ZJGG, NVL(SL,'0') AS SL, NVL(CCL,'0') AS CCL FROM PS_BOM START WITH FJBM = '"+fjbm+"' CONNECT BY PRIOR ZJBM = FJBM";
coll = deluni.loadBySQLStatementAndReturnFields("PS_BOM",sql,new String[]{"BM","ZJMC","ZJGG","SL","CCL"});
for (Iterator it = coll.iterator(); it.hasNext();) {
UniversalValueObject uvo=(UniversalValueObject)it.next();
System.out.println("uvo:"+uvo.getString("ZJMC"));
%>
tree.N["<%=uvo.getString("BM")%>"] = "T:<%=uvo.getString("ZJMC")%> - <%=uvo.getString("SL")%> - <%=uvo.getString("CCL")%>;"
<%
}
tranc.commit();
} catch (Exception e) {
tranc.rollback();
} finally {
tranc.close();
}
%>
tree.setURL("#");
tree.wordLine = false;
tree.setTarget("main");
document.getElementById("kkk").innerHTML=tree.toString();
tree.expandAll();
</script>
</body>
</html>
<script language="javascript">
function __pageLoad() {
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -