📄 in_detail1.asp

📁 汽车4s店库存管理系统
💻 ASP
字号:
<!--#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>入库配件汇总表</title>
<!--media=print 这个属性可以在打印时有效--> 
<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"><%=year(request.Form("end_time"))%>年<%=month(request.Form("end_time"))%>月 配件入库汇总表</font></td></tr>
  <tr><td align="center">


<%
end_time=request.Form("end_time")
end_time1=request.Form("end_time1")
Dim names(100)
i=0
set Rs=server.createobject("adodb.recordset")
rs.open "select Supplier from In_Store where uptime  between  #"&end_time&"# and #"&end_time1&"# group by Supplier",conn,1,1
if not rs.eof then 
do while not rs.eof
i=i+1
names(i)=rs(0)
rs.movenext
loop
end if
rs.close
set rs=nothing
%>

<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" >合 计</td>
          </tr>
          
				<%
Dim num(100,100)
dim n(100)
m=1
f=1
for m=1 to i
%>
<tr><td height="20" > <%=names(m)%></a></td>
<%
n(m)=0
for f=1 to j
set Rs=server.createobject("adodb.recordset")
rs.open "select sum(use_Amount) from In_Store where supplier='"&names(m)&"' and class='"&cla(f)&"' and (uptime  between  #"&end_time&"# and #"&end_time1&"#) group by Supplier",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)%>&nbsp;</td>
<%
else
num(m,f)=0
%>
<td align="right" ><%=num(m,f)%>&nbsp;</td>
<%
end if
rs.close
set rs=nothing
next
%>
<td  align="right" ><%=n(m)%>&nbsp;</td>
</tr>
<%
next
%>

 <tr> 
            
            <td  align="center"  bgcolor="#FFFFFF">合 计</td>
			<%
			y=0
			for f=1 to j
			%>
<td height="20" align="right" bgcolor="#FFFFFF">
<%
w=0
for m=1 to i
w=w+num(m,f)
y=y+num(m,f)
next
%><%=w%>&nbsp;</td>
<%next%>
	<td  align="right" bgcolor="#FFFFFF"><%=y%>&nbsp;</td>
          </tr>
<tr><td colspan="16" height="30" bgcolor="#FFFFFF">  付单： <%=i%> 张</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=页面设置 onClick="document.all.WebBrowser.ExecWB(8,1)" class="NOPRINT"> 
<input type=button value=打印预览 onClick="document.all.WebBrowser.ExecWB(7,1)" class="NOPRINT">
</td></tr>
				</table>
				
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -