?? out_detail2.asp
字號(hào):
<!--#include file="conn.asp"-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="css/main.css" rel="stylesheet" type="text/css">
<title>入庫(kù)配件匯總表</title>
<!--media=print 這個(gè)屬性可以在打印時(shí)有效-->
<style media=print>
.Noprint{display:none;}
.PageNext{page-break-after: always;}
</style>
</head>
<body leftmargin="30" topmargin="20">
<table width="1000" border="1" cellspacing="0" bordercolor="#D6D3CE">
<tr><td align="center" height="50"><font size="4"><%=request.Form("nian")%>年 配件出庫(kù)匯總表</font></td></tr>
<tr><td align="center">
<%
nian=request.Form("nian")
%>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFFF">
<tr>
<td width="160" height="20" align="center" >月 份</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="75" align="center" ><%=cla(j)%></td>
<%rs.movenext
loop%>
<%
end if
rs.close
set rs=nothing
%>
<td width="80" align="center" >合 計(jì)</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" > <%=nian%>年<%=m%>月 </a></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 align="right" ><%=num(m,f)%> </td>
<%
else
num(m,f)=0
%>
<td align="right" ><%=num(m,f)%> </td>
<%
end if
rs.close
set rs=nothing
next
%>
<td align="right" ><%=n(m)%> </td>
</tr>
<%
next
%>
<tr>
<td align="center" bgcolor="#FFFFFF">合 計(jì)</td>
<%
y=0
for f=1 to j
%>
<td height="20" align="right" bgcolor="#FFFFFF">
<%
w=0
for m=1 to 12
w=w+num(m,f)
y=y+num(m,f)
next
%><%=w%> </td>
<%next%>
<td align="right" bgcolor="#FFFFFF"><%=y%> </td>
</tr>
</table>
<table>
<tr><td height="30" colspan="10" align="center"><OBJECT id=WebBrowser classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 width=0 VIEWASTEXT>
</OBJECT>
<input type=button value=打印 onClick="document.all.WebBrowser.ExecWB(6,1)" class="NOPRINT">
<input type=button value=直接打印 onClick="document.all.WebBrowser.ExecWB(6,6)" class="NOPRINT">
<input type=button value=頁(yè)面設(shè)置 onClick="document.all.WebBrowser.ExecWB(8,1)" class="NOPRINT">
<input type=button value=打印預(yù)覽 onClick="document.all.WebBrowser.ExecWB(7,1)" class="NOPRINT">
</td></tr>
</table>
</body>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -