📄 store_compiles2.asp

📁 汽车4s店库存管理系统
💻 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")%>年—<%=request.Form("nian1")%>年  余额查询</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>
<%
nian=request.Form("nian")
nian1=request.Form("nian1")
end_time0=nian&"-1-1"
for i=nian to nian1
for m=1 to 12
end_time=i&"-"&m&"-1"
end_time1=DateAdd("m",1,end_time)-1
%>
<tr><td height="20" width="120" bgcolor="#FFFFFF"> <%=i%>年<%=m%>月 </td>
<%
n=0
for f=1 to j
set Rs=server.createobject("adodb.recordset")
rs.open "select sum(use_Amount) from In_Store where  class='"&cla(f)&"' and (uptime  between  #"&end_time0&"# and #"&end_time1&"#) group by class",conn,1,1
if not rs.eof then 
num=rs(0)
n=n+num
else
num=0
end if
rs.close
set rs=nothing
set Rs=server.createobject("adodb.recordset")
rs.open "select sum(Loan_Amount) from out_Store where  class='"&cla(f)&"' and (uptime  between  #"&end_time0&"# and #"&end_time1&"#) group by class",conn,1,1
if not rs.eof then 
num1=rs(0)
n=n-num1
else
num1=0
end if
rs.close
set rs=nothing
%>
<td width="60" align="right" bgcolor="#FFFFFF"><%=num-num1%>&nbsp;</td>
<%
next
%>
<td width="60" align="right" bgcolor="#FFFFFF"><font color="#FF6600"><%=n%></font>&nbsp;</td>
</tr>
<tr><td colspan="18" height="1" bgcolor="#000000"></td></tr>
<%
next
next
%>


        </table>
		<br>
				<table cellpadding="0">
				<form name="search" method="post" action="store_Detail2.asp" target="_blank" >
				  <tr><td>
				   <input name="nian" type="hidden" value="<%=nian%>">
				   <input name="nian1" type="hidden" value="<%=nian1%>">
				  <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 + -