📄 shourunote.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<html>
<head><link href="css.css" rel="stylesheet" type="text/css">
<title>三角进销存-收入明细</title></head>
<body>
<table width="100%" class="inputb"><tr><td align="center">财务收入明细</td></tr></table>
<br>
<%
Set Rs=Server.Createobject("adodb.recordset")
Sql="select * from ShouRu where month(intime)=month(date())"
Rs.Open Sql,conn,1,1
response.write"<form name=form1 action=ShouRunote.asp method=post>"
response.write"<table width=100% border=1 cellpadding=0 cellspacing=0 bordercolorlight=#cccccc bordercolordark=#ffffff>"
response.write"<tr bgcolor=#cccfff><td align=center>收入编号</td><td align=center>收入项目</td><td align=center>收入说明</td><td align=center>收入金额</td><td align=center>收入日期</td><td align=center>选择</td></tr>"
while not rs.eof
response.write"<tr bgcolor=#f1f1f1><td align=center>"&rs("id")&"</td>"
response.write"<td align=center>"&rs("xiangmu")&"</td>"
response.write"<td align=center>"&rs("yuanyin")&"</td>"
response.write"<td align=center>"&rs("qianshu")&"元</td>"
response.write"<td align=center>"&rs("intime")&"</td>"
response.write"<td align=center><input name=id type=checkbox value="&rs("id")&"></td>"
response.write"</tr>"
rs.movenext
wend
rs.close
response.write"<tr bgcolor=#f1f1f1><td align=center colspan=6><input name=submit type=submit class=inputb value=作废选中的记录></td></tr>"
response.write"<tr bgcolor=#f1f1f1><td align=center colspan=6>*为节省系统资源只显示当月支出项目，其它的可以通过搜索查看!</td></tr>"
response.write"</table></form>"
id=request("id")
if not isnumeric(id) or id="" then
response.end
else
Sqlstr="delete * from ShouRu where id="&id
conn.execute(sqlstr)
response.write"<script language=javascript>alert('本条记录作废成功！');location.href='ShouRunote.asp';</script>"
end if
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -