📄 contract_class.asp
字号:
<!--#include file="user_timeout.asp"-->
<!--#include file="getabcd.asp"-->
<%
query_time=request("query_time")
con_class=trim(request("con_class"))
if query_time="" then
query_time=year(now())
end if
if query_time="全部" then
if con_class="unpay" then
sql="select * from contract where c_state='new' or c_state='audited'"
else
sql="select * from contract where c_state='"&con_class&"'"
end if
else
if con_class="unpay" then
sql="select * from contract where create_time between #"&query_time&"-1-1 00:00:00# and #"&query_time&"-12-31 23:59:59# and (c_state='new' or c_state='audited')"
else
sql="select * from contract where create_time between #"&query_time&"-1-1 00:00:00# and #"&query_time&"-12-31 23:59:59# and c_state='"&con_class&"'"
end if
end if
'response.write sql
rs.open sql,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>北华航天工业学院 设备合同管理系统</title>
<link href="global.css" rel="stylesheet" type="text/css">
</head>
<body>
<center>
<%
if rs.eof then
response.write "暂无数据！"
else
%>
<table width="100%" border="1" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#cccccc" align="center">
<td>合同号</td>
<td>合同内容</td>
<td>总金额</td>
<td>录入时间</td>
<td>审核时间</td>
<td>首款</td>
<td>批首款时间</td>
<td>尾款</td>
<td>批尾款时间</td>
<td width=60>合同状态</td>
</tr>
<%
while not rs.eof
%>
<tr onMouseOver="this.style.backgroundColor='#eeeeee'" onMouseOut ="this.style.backgroundColor=''">
<td align="center">
<%
if rs("c_file")="nothing" then
response.write rs("c_no")
else
response.write "<a href='con_files/"&rs("c_file")&"' target='_black'>"&rs("c_no")&"</a>"
end if
%></td>
<td align="left"><%=rs("c_content")%></td>
<td align="right"><%=FormatCurrency(rs("c_total"))%></td>
<td align="left"><%=rs("create_time")%></td>
<td align="left"><%=rs("audit_time")%> </td>
<td align="right"><%=FormatCurrency(rs("first_payment"))%></td>
<td align="left"><%=rs("firstpay_time")%> </td>
<td align="right"><%=FormatCurrency(rs("last_payment"))%></td>
<td align="left"><%=rs("lastpay_time")%> </td>
<%
if rs("c_state")="new" then
c_state="<font color=#001a99>未审核</font>"
end if
if rs("c_state")="audited" then
c_state="<font color=#009966>已审核</font>"
end if
if rs("c_state")="f_passed" then
c_state="<font color=#cc9900>已批首款</font>"
end if
if rs("c_state")="l_passed" then
c_state="<font color=red>已批尾款</font>"
end if
%>
<td align="center"><%=c_state%></td>
</tr>
<%
rs.movenext
wend
%>
</table>
<%
end if
%>
<br><input type="button" class=button value=" 关 闭 " name=button1 onclick="javascript:window.close()">
</center>
</body>
</html>
<%call DBConnEnd()%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -