📄 transcatappend.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" />
<jsp:useBean id="transcatget" scope="page" class="imis.transcatget" />
<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>
<SCRIPT>
window.onload=init
</SCRIPT>
<script>
function frm1_check(){
if(frm1.itemname.value==""){
alert("请填写项目名称！");
frm1.itemname.focus();
}else{
frm1.sqlwhereget.value="ITEMNAME like '%" + frm1.itemname.value + "%'";
frm1.submit();
}
}
</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="transcatAppend.jsp" method="post">
<tr>
<td colspan="3" height="15" bgcolor="#666666"><font color='white' size='2'>合同管理</font></td>
</tr>
<tr bgcolor="#fafafa">
<td colspan="3"><a href="contractdisplay.jsp">合同管理</a>>>
谈判小组查询 </td>
</tr>
<tr bgcolor="#fafafa">
<td width="86"> <font class="strong" > 项目名称：</font> </td>
<td width="303"> <input type="text" name="itemname" class="file">
<input type="button" name="Submit" value="查询" class="file" onClick="frm1_check()">
<input name="reset" type="reset" class="file" id="reset" value="还原">
</td>
<td width="200"> </td>
</tr>
<input type="hidden" name="sqlwhereget">
</form>
</table>
<table class=title width="600" border="0" cellspacing="1" cellpadding="2">
<form name="frm2" method="post" action="transcatInsed.jsp">
<tr bgcolor="#666666">
<td height="20" colspan="4"> <font class="strongw">谈判小组列表:</font>
</td>
</tr>
<tr bgcolor="#e0e0e0">
<td>编号</td>
<td>项目名称</td>
<td>主持人</td>
<td>填写人单位</td>
</tr>
<%
//out.print(session.getAttribute("pubids")); //测试用
int rows,pagenums,pages,cpage,i;
String sqlwhere="",t_temp="",tt_temp="";
/**
* rows ：记录的总数；
*pagenums ：是每页显示的记录数；
* pages ：页的总数；
* cpage ：当前显示的页；
* i ：分页循环的变量
*--------------------------------------
* sqlhwere：存放取得高级查询的条件
* t_temp：存放session变量pubids的值
* tt_temp：存放pub_id的字符串如 “,4,”
*/
//*设置当前页码*/
cpage = (request.getParameter("cpage")==null)?-1:Integer.parseInt(request.getParameter("cpage").trim());
if(cpage==-1){
sqlwhere=request.getParameter("sqlwhereget");
if(sqlwhere!=null ){
session.setAttribute("sqlwhereget",sqlwhere);
}
//out.print("<br>****sqlwhereget*********"+request.getParameter("sqlwhereget")+"*************<br>");//test use
cpage=1;
}
//*设置结束*/
sqlwhere=(String)session.getAttribute("sqlwhereget");
if(sqlwhere!="" && sqlwhere!=null)
transcatget.setSqlwhereget(sqlwhere);
else
transcatget.setSqlwhereget(null);
//*开始执行*/
transcatget.setSqlwhereget(sqlwhere);
transcatget.query(pageContext);
rows=transcatget.getRows(); //查询到的记录数
pagenums=10; //每页显示的记录数
if(rows%pagenums==0){
pages=rows/pagenums; //页的总数
}else{
pages=rows/pagenums+1;
}
//*处理当前页码*/
if(cpage<1){
cpage=1;
}else if(cpage>pages){
cpage=pages;
}
%>
<%
//int i=0;
i=0;
if(transcatget.getRows()>0){ // first if
transcatget.setCursor((cpage-1)*pagenums-1) ;
while(transcatget.next()){ //while
i=i+1;
if(i<=pagenums){ //second if
%>
<tr bgcolor="#e0e0e0">
<td width="131" bgcolor="#e0e0e0"><font class="strong"><a href="transcatInfo.jsp?itemid=<%=transcatget.getItemid()%>"><%=transcatget.getId()%></a></font>
</td>
<td width="463" bgcolor="#e0e0e0"><%=transcatget.getItemname()%></td>
<td width="131" bgcolor="#e0e0e0"><%=transcatget.getMainperson()%>
</td>
<td width="463" bgcolor="#e0e0e0"><%=transcatget.getUnitid()%></td>
</tr>
<%
}else{
break;
} //end second if
}// end while
}// end first if
%>
<tr bgcolor="#e0e0e0">
<td colspan="8">
<a href="transcatAppend.jsp?cpage=<%=cpage-1%>"><img src="../../images/prev.gif" width="40" height="12" border="0"></a>
<%for(i=1;i<=pages;i++){%>
<a href="transcatAppend.jsp?cpage=<%=i%>">
<%
if(cpage==i){
out.print("<font color=\"blue\">"+i+"</font>");
}else{
out.print(i);
}
%>
</a>
<%}%>
<a href="transcatAppend.jsp?cpage=<%=cpage+1%>"><img src="../../images/next.gif" width="40" height="12" border="0"></a> 第<%=cpage%>页 共<%=rows%>条信息 分<%=pages%>页显示
</td>
</tr>
</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>
<%
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -