📄 itemtabledir.jsp
字号:
<%@ page
language="java"
contentType="text/html; charset=GBK"
import="imis.*,javax.naming.*,javax.rmi.PortableRemoteObject,java.util.*,java.text.*"
%>
<%
session=request.getSession();
userStruct user=(userStruct)session.getAttribute("user");
if(user==null){
response.sendRedirect("../../login.html");
}
else
//if(!((user.getAccess().intValue()==9)||(user.getAccess().intValue()==10))){
if(!(((user.getAccess().intValue()==9)||(user.getAccess().intValue()==10)||(user.getAccess().intValue()==6)))){
response.sendRedirect("../../error/access.html");
}else{
%>
<jsp:useBean id="itemtableget" scope="page" class="imis.itemtableget" />
<%
String itemtype=request.getParameter("itemtype");
String itemname=request.getParameter("itemname");
String sqlwhereget="ITEMTYPE="+itemtype.trim()+" and ITEMNAME like '%"+itemname.trim()+"%'";
//String sqlwhereget="itemtype="+itemtype.trim()+" and itemname like '%"+itemname.trim()+"%'";
itemtableget.setSqlwhereget(sqlwhereget);
itemtableget.query(pageContext);
//out.print(itemtableget.getRows());
if( (itemtableget.getRows()>0) && (itemtableget.getRows()==1) ){ //if one
response.sendRedirect("transcatIns.jsp?itemid="+itemtableget.getItemid());
}else if(itemtableget.getRows()==0){
%>
<script>
alert("未查到任何记录!");
history.back();
</script>
<%
}else{
%>
<HTML><HEAD>
<TITLE>MSA Office</TITLE>
<link rel="stylesheet" href="../../css/msa.css" type="text/css">
<script language="JavaScript" src="../../public/js/table_display.js"></script>
<script language="JavaScript" src="../../public/js/all_checked.js"></script>
<script language="JavaScript" src="../../public/js/contract_menu.js"></script>
<script language="javascript" src="../../public/util/openselect.js"></script>
<script language="javascript" src="../../public/js/getdate.js"></script>
<script language="javascript">
init1();
</script>
</HEAD>
<BODY class="bg" topMargin=20 leftmargin="0" marginwidth="0" marginheight="0">
<DIV align=center>
<TABLE class=outter cellSpacing=0 cellPadding=0 width=600 border=0>
<TR>
<TD><IMG height=4 src="../../MacOS/lefttop.gif" width=6></TD>
<TD background=../../MacOS/top.gif colSpan=3><IMG height=4
src="../MacOS/top.gif" width=1></TD>
<TD><IMG height=4 src="../../MacOS/righttop.gif"></TD>
</TR>
<TR>
<TD vAlign=top background=../../MacOS/lwing.gif rowSpan=3><IMG height=18
src="../../MacOS/left.gif" width=6></TD>
<TD vAlign=top background=../../MacOS/titlebg.gif width="16"> <DIV><img src="../../MacOS/logo.gif" width="16" height="16" border="0" alt="返回MSA_Office首页"></a></DIV></TD>
<TD vAlign=top noWrap align=center width="100%"
background=../../MacOS/titlebg.gif><SPAN
style="BACKGROUND-COLOR: #cecece"><FONT class=strong> MSA - OFFICE </font></SPAN></TD>
<TD><IMG height=18 src="../../MacOS/right_b2.gif" width=18 border="0" alt="关闭窗口"></TD>
<TD vAlign=top background=../../MacOS/rwing.gif rowSpan=3><IMG height=18
src="../../MacOS/right.gif" width=7></TD>
</TR>
<TR>
<TD background=../../MacOS/hr.gif colSpan=3><IMG height=2
src="../../MacOS/hr.gif" width=1></TD>
</TR>
<TR>
<TD colSpan=3 align="center" valign="top"><br> <table width="600" border="1" cellspacing="1" bordercolor="#666666">
<tr bgcolor="#FAFAFA">
<td valign="top">
<table width="601" border="0" cellspacing="0" cellpadding="2">
<form name="frm1" action="itemtableDir.jsp" method="post">
<tr>
<td width="589" height="15" bgcolor="#666666"><font color='white' size='2'>合同管理</font></td>
</tr>
<tr bgcolor="#fafafa">
<td><a href="contractdisplay.jsp">合同管理</a>>> 项目批文查询
</td>
</tr>
</form>
</table>
<table class=title width="600" border="0" cellspacing="1" cellpadding="2">
<form name="form1" method="post" action="contractinputed.jsp" ENCTYPE="multipart/form-data" onSubmit="return check_input()">
<tr bgcolor="#666666">
<td height="20" colspan="3"> <font class="strongw">查询结果:</font>
</td>
</tr>
<tr>
<td>项目编号</td>
<td>项目名称</td>
<td>操作</td>
</tr>
<%
for(int i=0;i<itemtableget.getRows();i++){ //for one
itemtableget.next();
%>
<tr bgcolor="#e0e0e0">
<td width="131" bgcolor="#e0e0e0"> <font class="strong" ><%=itemtableget.getItemid()%></font>
</td>
<td width="131" bgcolor="#e0e0e0"> <font class="strong" ><%=itemtableget.getItemname()%></font>
</td>
<td width="463" bgcolor="#e0e0e0"><a href="transcatIns.jsp?itemid=<%=itemtableget.getItemid()%>">新建</td>
</tr>
<%
} //end for one
%>
</form>
</table></td>
</tr>
</table>
<p><img src="../../images/msalogo.gif" width="272" height="50">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3"><img src="../personal/project/a.gif" width="1" height="1"></td>
</tr>
<tr>
<td background="../../MacOS/hr.gif"><img src="../../MacOS/hr.gif" width="1" height="2"></td>
</tr>
<tr>
<td height="3"><img src="../personal/project/a.gif" width="1" height="1"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="right"><a href="../help.htm" target="blank" style="cursor:help" title="使用帮助"><img src="../../MacOS/help.gif" width="16" height="16" border="0">HELP</a></div></td>
</tr>
</table></TD>
</TR>
<TR>
<TD><IMG height=7 src="../../MacOS/leftbottom.gif" width=6></TD>
<TD background="../../MacOS/bottom.gif" colSpan=3><IMG height=7
src="../../MacOS/bottom.gif" width=1></TD>
<TD><IMG height=7 src="../../MacOS/rightbottom.gif"
width=7></TD>
</TR>
</TABLE>
<BR>
<TABLE cellSpacing=1 cellPadding=2 width="300" border=0>
<TBODY>
<TR>
<TD align=center><FONT class=footer><IMG height=8
src="../../MacOS/hr_black.gif" width="100%"><BR>
Orient Super Net NMIE-OFFICE System V1.2
</FONT></TD>
</TR>
</TBODY>
</TABLE>
</DIV>
</BODY></HTML>
<%
} //end if one
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -