📄 contractsearch.jsp
字号:
<%@ page
language="java"
contentType="text/html; charset=GBK"
import="imis.*,javax.naming.*,javax.rmi.PortableRemoteObject,java.util.*,java.text.*,java.io.*"
%>
<jsp:useBean id="contractget" scope="page" class="imis.contractget" />
<jsp:useBean id="contractdel" scope="page" class="imis.contractdel" />
<jsp:useBean id="commonjava" scope="page" class="imis.commonjava" />
<SCRIPT language=JavaScript src= "../../public/js/selffunction.js" type=text/Javascript></script>
<%
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{
try{
String sqlwhereget=request.getParameter("sqlwhereget");
if ((sqlwhereget==null)&&(request.getParameter("cpage")!=null))
sqlwhereget=(String)session.getAttribute("sqlwhereget");
else
session.setAttribute("sqlwhereget",sqlwhereget);
//System.out.println(sqlwhereget);
String flagdel=request.getParameter("flagdel");
if(flagdel!=null&&flagdel.equalsIgnoreCase("true")){
contractdel.setSqlwheredelete(commonjava.setsqlwheredelete(request.getParameterValues("chk")));
contractdel.execute(pageContext);
// String filename1=contractget.
// File file1 = new File(filename1);
// if(file1.exists()){
// done = file1.delete();
//}
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>MSA Office</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb_2312-80">
<META content="Microsoft FrontPage 4.0" name=GENERATOR>
<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 checkdel(){
var re = confirm("您确实要删除吗？");
if(re){
form2.flagdel.value="true";
form2.action="contractsearch.jsp";
form2.submit();
}
}
function highsearch(){
var contractid=form1.contractid2.value;
var timesign2=form1.timesign2.value;
var maturity2=form1.maturity2.value;
var itemname2=form1.itemname2.value;
var manufacturer2=form1.manufacturer2.value;
var sqlwhere="";
if(contractid!=""){
sqlwhere=" contract_id='"+contractid+"'";
}
if(timesign2!=""){
if(sqlwhere=="")
sqlwhere+=" time_sign='"+timesign2+"'";
else
sqlwhere+=" and time_sign='"+timesign2+"'";
}
if(maturity2!=""){
if(sqlwhere=="")
sqlwhere+=" manurity='"+maturity2+"'";
else
sqlwhere+=" and manurity='"+maturity2+"'";
}
if(itemname2!=""){
if(sqlwhere=="")
sqlwhere+=" itemname like '%"+itemname2+"%'";
else
sqlwhere+=" and itemname like'%"+itemname2+"%'";
}
if(manufacturer2!=""){
if(sqlwhere=="")
sqlwhere+=" manufacturer like '%"+manufacturer2+"%'";
else
sqlwhere+=" and manufacturer like '%"+manufacturer2+"%'";
}
form1.sqlwhereget.value=sqlwhere;
form1.submit();
}
</SCRIPT>
</HEAD>
<BODY class="bg" topMargin=20 leftmargin="0" marginwidth="0" marginheight="0" onclick="h_cele_date()">
<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" ></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" ></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"> <br>
<table width="600" border="1" cellspacing="1" bordercolor="#666666">
<tr bgcolor="#fafafa">
<td> <div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<form name="form1" method="post" action="contractsearch.jsp">
<tr bgcolor="#666666">
<td colspan="4" height="15"><font class="strongw">设备管理</font></td>
</tr>
<tr>
<td colspan="4"><a href="contractdisplay.html">合同管理</a>>>合同查询</td>
</tr>
<tr bgcolor="#fafafa">
<td width="64"> <nobr><font class="strong" > 合同编号：</font> </nobr></td>
<td width="208">
<input type="text" name="contractid2" class="file">
</td>
</tr>
<tr bgcolor="#e0e0e0">
<td width="131"> <font class="strong"> 合同签订时间： </font>
</td>
<td width="463"> <input name="timesign2" type="text" class="file" size="9" maxlength="9" readonly>
<input type="button" value=" " name="Submit_timesion2" class="button_date" onClick="show_cele_date(Submit_timesion2,'','',timesign2)">
</td>
</tr>
<tr bgcolor="#fafafa">
<td width="131"><font class="strong"> 合同到期时间</font>：</td>
<td width="463"> <input name="maturity2" type="text" class="file" value="" size="9" maxlength="9" readonly>
<input type="button" value=" " name="Submit_maturity2" class="button_date" onClick="show_cele_date(Submit_maturity2,'','',maturity2)">
</td>
</tr>
<tr bgcolor="#e0e0e0">
<td width="131"> <font class="strong"> 供货商</font>：
</td>
<td width="463"> <input name="manufacturer2" class="file" type="text" value="" size="52">
</td>
</tr>
<tr bgcolor="#fafafa">
<td width="131"> <font class="strong"> 项目名称</font>：
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -