📄 out_compiles2.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="top.asp"-->
<!--#include file="checkuser.asp"-->
<head>
<style type="text/css">
<!--
.select {
color: #FFFFFF;
background-color: #08246b;
}
.offline {
filter: Gray;
}
-->
</style>
<title>查找结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/main.css" rel="stylesheet" type="text/css">
<SCRIPT language=JavaScript src="css/User_Info_Modify.js"></SCRIPT>
</head>
<body >
<table width="100%" border="1" cellspacing="0" bordercolor="#D6D3CE">
<tr><td align="center" height="30"><font size="4"><%=request.Form("nian")%>年 配件出库汇总表</font></td>
</tr>
<tr><td align="center">
<%
nian=request.Form("nian")
%>
<table width="99%" border="0" cellpadding="1" cellspacing="0" bgcolor="#D4D0C8" class="tddown">
<tr class="but">
<td width="80" height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'">月 份</td>
<%
Dim cla(20)
j=0
set Rs=server.createobject("adodb.recordset")
rs.open "select classnumber from class ",conn,1,1
if not rs.eof then
do while not rs.eof
j=j+1
cla(j)=rs(0)
%>
<td width="60" height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'"><%=cla(j)%></td>
<%rs.movenext
loop%>
<%
end if
rs.close
set rs=nothing
%>
<td width="60" height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'">合 计</td>
</tr>
<%
Dim num(100,100)
dim n(100)
m=1
f=1
for m=1 to 12
end_time=nian&"-"&m&"-1"
end_time1=DateAdd("m",1,end_time)-1
%>
<tr><td height="20" width="120" bgcolor="#FFFFFF"> <%=nian%>年<%=m%>月 </td>
<%
n(m)=0
for f=1 to j
set Rs=server.createobject("adodb.recordset")
rs.open "select sum(Loan_Amount) from out_Store where class='"&cla(f)&"' and (uptime between #"&end_time&"# and #"&end_time1&"#) group by class",conn,1,1
if not rs.eof then
num(m,f)=rs(0)
n(m)=n(m)+num(m,f)
%>
<td width="60" align="right" bgcolor="#FFFFFF"><font color="#CC3300"><%=num(m,f)%> </td>
<%
else
num(m,f)=0
%>
<td width="60" align="right" bgcolor="#FFFFFF"><%=num(m,f)%> </td>
<%
end if
rs.close
set rs=nothing
next
%>
<td width="60" align="right" bgcolor="#FFFFFF"><font color="#FF6600"><%=n(m)%></font> </td>
</tr>
<tr><td colspan="18" height="1" bgcolor="#000000"></td></tr>
<%
next
%>
<tr class="but">
<td width="120" align="center" bgcolor="#FFFFFF">合 计</td>
<%
y=0
for f=1 to j
%>
<td width="60" height="20" align="right" bgcolor="#FFFFFF">
<%
w=0
for m=1 to 12
w=w+num(m,f)
y=y+num(m,f)
next
%><font color="#FF0000"><%=w%></font> </td>
<%next%>
<td width="60" align="right" bgcolor="#FFFFFF"><font color="#FF0000"><%=y%></font> </td>
</tr>
<tr><td colspan="18" height="1" bgcolor="#000000"></td></tr>
</table>
<br>
<table cellpadding="0">
<form name="search" method="post" action="out_Detail2.asp" target="_blank" >
<tr><td>
<input name="nian" type="hidden" value="<%=nian%>">
<input type="submit" name="sub" value="生成明细表"></td></tr></form></table>
</TD></TR>
</table>
</body>
</html>
<!--#include file="footer.htm"--></TD>
</BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -