📄 xufei2.asp
字号:
<%
if request.cookies("flag")="" then
response.redirect "login.asp"
response.end
else
%>
<!--#include file="dbconn.asp"-->
<html>
<head>
<title>Untitled Document</title>
<LINK href="css/style.css" type=text/css rel=stylesheet>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p align="center"> </p><form name="form1" method="post" action="search_yewu.asp">
<div align="center"><font color="#808080" style="font-size: 9pt"><font color="#000000">搜索：</font>
<input name="search" size="30" style="border: 1 solid #808080"> </font> <input type="submit" name="Submit" value="搜索">
</div></form><p align="center"> </p><p> <%
set rs=server.createobject("ADODB.recordset")
sql="select * from caiwu order by [到期日期] desc"
rs.open sql,conn,1,1
%> </p><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="1246" id="AutoNumber1">
<tr bgcolor="#CCCCCC"> <td width="42" height="28"> <div align="center"><b>编号</b></div></td><td width="65" height="28">
<div align="center"><b>合同号</b></div></td><td width="234" height="28"> <div align="center"><b>企业名称</b></div></td><td width="59" height="28">
<div align="center"><b><font color="#000000">经办人</font></b></div></td><td width="136" height="28">
<div align="center"><b>业务分类</b></div></td><td width="254" height="28"> <div align="center"><b>具体内容</b></div></td><td width="58" height="28">
<div align="center"><b>开始日期</b></div></td><td width="58" height="28"> <div align="center"><b>到期日期</b></div></td><TD WIDTH="58" HEIGHT="28">
<DIV ALIGN="center"><B>应收金额</B></DIV></TD><td width="58" height="28"> <div align="center"><b>实收金额</b></div></td><TD WIDTH="58" HEIGHT="28">
<DIV ALIGN="center"><B>待收款</B></DIV></TD><td width="59" height="28"> <div align="center"><b>成本支出</b></div></td><td width="59" height="28">
<div align="center"><b>经办人1</b></div></td><td width="59" height="28"> <div align="center"><b>经办人2</b></div></td><td width="91" height="28">
<div align="center"><b>备注</b></div></td><td width="115" height="28"> <div align="center"><b>操作</b></div></td></tr>
<%
nowtime=now()
nowtime=datevalue(nowtime)
now30=now()+30
now30=datevalue(now30)
%> <%do while not rs.eof%> <%
dtime=rs("到期日期")
if dtime < now30 then%> <tr> <td width="42" height="32"> <div align="center"><font color="#0000FF"><b><font face="Arial, Helvetica, sans-serif"><%=rs("id")%></font></b></font></div></td><td width="65" height="32">
<div align="center"><%=rs("合同编号")%></div></td><td width="234" height="32"> <div align="left"> <a href="list.asp?company=<%=rs("企业名称")%>"><%=rs("企业名称")%></a></div></td><td width="59" height="32">
<div align="center"><%=rs("企业经办人")%></div></td><td width="136" height="32"> <div align="center"><%=rs("项目")%></div></td><td width="254" height="32">
<div align="left"> <%=rs("具体内容")%></div></td><td width="58" height="32"> <div align="center"><%=rs("开始日期")%></div></td><td width="58" height="32">
<div align="center"><%=rs("到期日期")%></div></td><TD WIDTH="58" HEIGHT="32"> <DIV ALIGN="center"><%=rs("应收金额")%></DIV></TD><td width="58" height="32">
<div align="center"><%=rs("实收金额")%></div></td><TD WIDTH="58" HEIGHT="32"> <DIV ALIGN="center"><%=rs("应收金额")-rs("实收金额")%></DIV></TD><td width="59" height="32">
<div align="center"><%=rs("成本支出")%></div></td><td width="59" height="32"> <div align="center"><%=rs("经办人1")%></div></td><td width="59" height="32">
<div align="center"><%=rs("经办人2")%></div></td><td width="91" height="32"> <div align="center"><%=rs("memo")%></div></td><td width="115" height="32">
<div align="center"><A HREF="edit_yewu.asp?id=<%=rs("id")%>">修改</A>|<A HREF="del_yewu.asp?id=<%=rs("id")%>">删除</A>|<A HREF="xufei_yewu.asp?id=<%=rs("id")%>">续费</A></div></td></tr>
<%end if%> <%
rs.movenext
loop
%> <%rs.close
set rs=nothing
%> </table>
</body>
</html>
<%end if%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -