📄 index.jsp
字号:
<%@ page import="com.baosight.project.db.conn.ServerInfo"%>
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.baosight.project.db.result.*"%>
<%@ page import="com.baosight.project.util.*"%>
<%@ taglib uri="projectTag" prefix="project"%>
<jsp:include page="js.jsp" />
<jsp:useBean id="turn" scope="request" class="com.baosight.project.util.bean.TurnPageBean" />
<script language=JavaScript src="../../../js/Calendar.js"></script>
<%
String pageId = ( String )session.getAttribute( "PAGE_ID" );
String pageName = ( String )session.getAttribute( "PAGE_NAME" );
String userId = ( String )session.getAttribute( "USER_ID" );
String userName = ( String )session.getAttribute( "USER_NAME" );
String gwh = ( String )session.getAttribute( "GWH" );
String role = ( String )session.getAttribute( "ROLE" );
String deptName = ( String )session.getAttribute( "DEPT_NAME" );
pageId = pageId == null? "" : pageId;
pageName = pageName == null? "" : pageName;
gwh = gwh == null? "" : "-" + gwh;
role = role == null? "" : "-" + role;
String Item_code_type_s = (String)request.getParameter( "PPOPUP01__ITEM_CODE_TYPE_S" );
String Item_code_s = (String)request.getParameter( "PPOPUP01__ITEM_CODE_S" );
String Item_name_s = (String)request.getParameter( "PPOPUP01__ITEM_NAME_S" );
String Item_model_s = (String)request.getParameter( "PPOPUP01__ITEM_MODEL_S" );
String Item_specs_s = (String)request.getParameter( "PPOPUP01__ITEM_SPECS_S" );
String spage = (String)request.getParameter( "PAGE" );
String type = (String)request.getParameter( "TYPE" );
Item_code_type_s = Item_code_type_s == null?"":DeviceTool.turnTrans(Item_code_type_s);
Item_code_s = Item_code_s == null?"":DeviceTool.turnTrans(Item_code_s);
Item_name_s = Item_name_s == null?"":DeviceTool.turnTrans(Item_name_s);
Item_model_s = Item_model_s == null?"":DeviceTool.turnTrans(Item_model_s);
Item_specs_s = Item_specs_s == null?"":DeviceTool.turnTrans(Item_specs_s);
spage = spage == null?"1":DeviceTool.turnTrans(spage);
type = type == null?"0":DeviceTool.turnTrans(type);
DeviceTool dt = new DeviceTool();
String option = dt.ListBox("JCSJ_B_ITEMTYPE","ITEM_TYPE_NAME","ITEM_CODE_TYPE","","ITEM_CODE_TYPE",false,"1");
DbAccess da = new DbAccess();
DbResult sqlR = null;
if(type!="0"){
String sql = "SELECT B.ITEM_TYPE_NAME,A.*,F_ONWAY(A.ITEM_CODE_TYPE,A.ITEM_CODE) AS ONWAY_QTY "
+"FROM JCSJ_B_ITEM A,JCSJ_B_ITEMTYPE B "
+"WHERE A.ITEM_CODE_TYPE = B.ITEM_CODE_TYPE(+) AND A.VALID_SIGN='0' AND A.ITEM_CODE_TYPE LIKE '"
+ Item_code_type_s + "%' AND A.ITEM_CODE LIKE '"
+ Item_code_s + "%' AND NVL(A.ITEM_MODEL,' ') LIKE '"
+ Item_model_s + "%' AND NVL(A.ITEM_SPECS,' ') LIKE '"
+ Item_specs_s + "%' AND (NVL(A.ITEM_CHN_NAME,' ') LIKE '"
+ Item_name_s + "%' OR NVL(A.ITEM_ENG_NAME,' ') LIKE '"
+ Item_name_s + "%') ORDER BY A.ITEM_CODE_TYPE,A.ITEM_CODE";
sqlR = da.query( sql, MyStr.intOf(spage), 10 );
sqlR.goTop();
}
%>
<html>
<head>
<title></title>
<link href="../../../css/modality.css" rel="stylesheet" type="text/css">
<script language=JavaScript src="../../../js/tools.js"></script>
</head>
<STYLE type="text/css">
BODY {
scrollbar-face-color:#A7A7A7;
scrollbar-highlight-color:#DFDFDF;
scrollbar-3dlight-color:#DBDCDC;
scrollbar-darkshadow-color:#000000;
scrollbar-shadow-color:#808080;
scrollbar-arrow-color:#FFFFFF;
scrollbar-track-color:#DBDCDC;
}
a:link { color: #ffffff; text-decoration: none }
a:hover { color: #FFE400; text-decoration: none }
</STYLE>
<body leftmargin="2" topmargin="0" scroll=no style="border:none">
<script language=JavaScript src="../../../js/Validation.js"></script>
<div id="loadimg" style="OVERFLOW-Y: auto; OVERFLOW-X: auto; LEFT:100; TOP:100; POSITION: absolute; visibility:hidden;"><img src="../../../images/load.gif" border="0"></div>
<form method="POST" action="index.jsp" target="POPUP">
<input name="WINDOW" type="hidden" value="DLG">
<input name="PAGE" type="hidden" value="1">
<input name="TYPE" type="hidden" value="0">
<table border="0" width="98%" cellspacing="5">
<tr>
<td width="100%" colspan="2">
<table border="0">
<tr class="td">
<td align="right">代码类：</td>
<td><select name="PPOPUP01__ITEM_CODE_TYPE_S"><%=option%></select></td>
<td align="right">物料代码：</td>
<td><input name="PPOPUP01__ITEM_CODE_S" type="text"></td>
<td align="right">物料名称：</td>
<td><input name="PPOPUP01__ITEM_NAME_S" type="text"></td>
</tr>
<tr class="td">
<td align="right">型号：</td>
<td><input name="PPOPUP01__ITEM_MODEL_S" type="text"></td>
<td align="right">规格：</td>
<td><input name="PPOPUP01__ITEM_SPECS_S" type="text"></td>
<td align="right"> </td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" align="right" colspan="2">
<input type='button' class='submit' value='查询' name='search' onclick='searchJs();'>
<input type='button' class='submit' value='确认' name='doconfirm' onclick='doconfirmJs();'>
<input type='button' class='submit' value='关闭' name='doclose' onclick='docloseJs();'>
</td>
</tr>
<tr>
<td width="20%" align="left">
<div id=the11Div style="OVERFLOW-Y: auto; OVERFLOW-X: auto; WIDTH: 380; HEIGHT:280px ; border-right-style:double; border-right-color:#333333;"
onscroll=the11Div.scrollLeft=scrollLeft;>
<table border="0" cellspacing="0">
<tr>
<td>
<%
//构造物料树
PopupTree itree= new PopupTree();
String tree_html=itree.getTree(Item_code_type_s,Item_code_s);
out.print(tree_html);
%>
</td>
</tr>
</table>
</div>
</td>
<td width="80%" align="center">
<div id=the12Div style="OVERFLOW-Y: auto; OVERFLOW-X: auto; WIDTH: 600; HEIGHT:280px ; border-left-style:single; border-right-color:#333333;"
onscroll=the12Div.scrollLeft=scrollLeft;>
<table border="0" cellpadding="2">
<tr class="td" align="center" bgcolor="#C0C0C0">
<td>选择</td>
<td>代码类</td>
<td>物料代码</td>
<td>物料名称</td>
<td>型号</td>
<td>规格</td>
<td>库存量</td>
<td>预约量</td>
<td>在途量</td>
</tr>
<%
if(type!="0"&&!sqlR.empty()) {
int i = 1;
int b = 0;
String bcolor = "";
String bclass = "";
while(!sqlR.eof()) {
if(b == 0){
bcolor = "bgcolor='#FFFFFF'";
bclass = "class = 'whitetext'";
b = 1;
}else{
bcolor = "bgcolor='#D8D8D8'";
bclass = "class = 'graytext'";
b = 0;
}
out.println("<tr "+bcolor+">");
out.print("<td><input name='RADIOBUTTON' type='radio' value='"+i+"'></td>");
out.print("<td><input readonly size='10' name='FPOPUP01__ITEM_TYPE_NAME"+i+"' type='text' value='"+sqlR.valueOf("ITEM_TYPE_NAME")+"'"+bclass+">");
out.print("<td><input readonly size='15' name='FPOPUP01__ITEM_CODE"+i+"' type='text' value='"+sqlR.valueOf("ITEM_CODE")+"'"+bclass+"></td>");
out.println("<td><input readonly size='20' name='FPOPUP01__ITEM_CHN_NAME"+i+"' type='text' value='"+sqlR.valueOf("ITEM_CHN_NAME")+"'"+bclass+"></td>");
out.println("<td><input readonly size='20' name='FPOPUP01__ITEM_MODEL"+i+"' type='text' value='"+sqlR.valueOf("ITEM_MODEL")+"'"+bclass+"></td>");
out.println("<td><input readonly size='20' name='FPOPUP01__ITEM_SPECS"+i+"' type='text' value='"+sqlR.valueOf("ITEM_SPECS")+"'"+bclass+"></td>");
out.println("<td><input readonly size='10' name='FPOPUP01__STOCK_QTY"+i+"' type='text' value='"+sqlR.valueOf("STOCK_QTY")+"'"+bclass+"></td>");
out.println("<td><input readonly size='10' name='FPOPUP01__BOOKED_QTY"+i+"' type='text' value='"+sqlR.valueOf("BOOKED_QTY")+"'"+bclass+"></td>");
out.println("<td><input readonly size='10' name='FPOPUP01__ONWAY_QTY"+i+"' type='text' value='"+sqlR.valueOf("ONWAY_QTY")+"'"+bclass+"></td>");
out.println("</tr>");
out.println("<input name='FPOPUP01__ITEM_CODE_TYPE"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_CODE_TYPE")+"'>");
out.println("<input name='FPOPUP01__ITEM_ENG_NAME"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_ENG_NAME")+"'>");
out.println("<input name='FPOPUP01__ITEM_UNIT"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_UNIT")+"'>");
out.println("<input name='FPOPUP01__ITEM_WEIGHT"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_WEIGHT")+"'>");
out.println("<input name='FPOPUP01__ITEM_WEIGHT_UNIT"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_WEIGHT_UNIT")+"'>");
out.println("<input name='FPOPUP01__ITEM_GROUP"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_GROUP")+"'>");
out.println("<input name='FPOPUP01__ITEM_DRAWING"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_DRAWING")+"'>");
out.println("<input name='FPOPUP01__IS_SUPPRESSED"+i+"' type='hidden' value='"+sqlR.valueOf("IS_SUPPRESSED")+"'>");
out.println("<input name='FPOPUP01__IS_INSURANCE"+i+"' type='hidden' value='"+sqlR.valueOf("IS_INSURANCE")+"'>");
out.println("<input name='FPOPUP01__DEPT"+i+"' type='hidden' value='"+sqlR.valueOf("DEPT")+"'>");
out.println("<input name='FPOPUP01__BUY_CYC"+i+"' type='hidden' value='"+sqlR.valueOf("BUY_CYC")+"'>");
out.println("<input name='FPOPUP01__SIMU_PRICE"+i+"' type='hidden' value='"+sqlR.valueOf("SIMU_PRICE")+"'>");
out.println("<input name='FPOPUP01__ITEM_MATERIAL"+i+"' type='hidden' value='"+sqlR.valueOf("ITEM_MATERIAL")+"'>");
out.println("<input name='FPOPUP01__COST_TYPE"+i+"' type='hidden' value='"+sqlR.valueOf("COST_TYPE")+"'>");
sqlR.next();
i++;
}
}
%>
</table>
</div>
</td>
</tr>
<tr>
<td width="100%" align="center" colspan="2"><!--[5]-->
<%
if(type!="0"&&!sqlR.empty()){
String sUrl = "&PPOPUP01__ITEM_CODE_TYPE_S="+Item_code_type_s
+ "&PPOPUP01__ITEM_CODE_S="+Item_code_s
+ "&PPOPUP01__ITEM_NAME_S="+Item_name_s
+ "&PPOPUP01__ITEM_MODEL_S="+Item_model_s
+ "&PPOPUP01__ITEM_SPECS_S="+Item_specs_s;
%>
<table border='0' cellspacing='0' cellpadding='0'>
<tr>
<td nowrap align=left class='turn'><a href="index.jsp?TYPE=1&PAGE=1<%=sUrl%>"><font color=#808080>首页</font></a>|</td>
<td nowrap align=left class='turn'><a href="index.jsp?TYPE=1&PAGE=<%=sqlR.getCurrPage()-1%><%=sUrl%>"><font color=#808080>上一页</font></a>|</td>
<td nowrap align=left class='turn'><a href="index.jsp?TYPE=1&PAGE=<%=sqlR.getCurrPage()+1%><%=sUrl%>"><font color=#808080>下一页</font></a>|</td>
<td nowrap align=left class='turn'><a href="index.jsp?TYPE=1&PAGE=<%=sqlR.getPageCount()%><%=sUrl%>"><font color=#808080>尾页</font></a></td>
<td nowrap align=left class='turn'> 第<%=sqlR.getCurrPage()%>页/共<%=sqlR.getPageCount()%>页/共<%=sqlR.getTotalRow()%>条 </td>
<td><input type='button' class='submit' value='到' name='go' onclick="return goJs();"></td>
<td class='turn'><INPUT type='text' size='4' name='GOPAGE' style='HEIGHT: 20px; WIDTH: 30px' maxlength='4' value='1'>页</td>
</tr>
</table>
<%}%>
</td>
</tr>
<tr>
<td width="100%" align="center" colspan="2"> </td>
</tr>
</table>
<DIV id=MES>
</div>
<script language=JavaScript src="../../../js/place.js"></script>
<script language=javascript>
document.forms[0].PPOPUP01__ITEM_CODE_TYPE_S.value='<%=Item_code_type_s%>';
document.forms[0].PPOPUP01__ITEM_CODE_S.value='<%=Item_code_s%>';
document.forms[0].PPOPUP01__ITEM_NAME_S.value='<%=Item_name_s%>';
document.forms[0].PPOPUP01__ITEM_MODEL_S.value='<%=Item_model_s%>';
document.forms[0].PPOPUP01__ITEM_SPECS_S.value='<%=Item_specs_s%>';
</script>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -