📄 spcount.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Inc/Dataconn.asp" -->
<!--#include file="Inc/Funcs.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<link href="Inc/css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.STYLE1 {font-size: 14px}
-->
</style></head>
<body>
<table width="612" height="450" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td valign="top" bgcolor="#FFFFFF">
<br>
<span> <span class="STYLE1">商品按类别统计如下表：</span> </span>
<br>
<table width="610" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="25" align="center" background="Images/tbtitle1.jpg" bgcolor="#FFFFFF" class="Txt">商品类别</td>
<td align="center" background="Images/tbtitle1.jpg" bgcolor="#FFFFFF" class="Txt">商品种类数</td>
<td align="center" background="Images/tbtitle1.jpg" bgcolor="#FFFFFF" class="Txt">入库总数量</td>
<td align="center" background="Images/tbtitle1.jpg" bgcolor="#FFFFFF" class="Txt">出库总数量</td>
<td align="center" background="Images/tbtitle1.jpg" bgcolor="#FFFFFF" class="Txt">现有库存量</td>
<td align="center" background="Images/tbtitle1.jpg" bgcolor="#FFFFFF" class="Txt">入库总金额</td>
<td align="center" background="Images/tbtitle1.jpg" bgcolor="#FFFFFF" class="Txt">出库总金额</td>
</tr>
<%
SQLStr="Select * from LB"
rS.Open SQLStr,conn,1,1
For i=1 to rS.RecordCount%>
<tr>
<td height="20" align="center" bgcolor="#FFFFFF" class="Txt"><%=rS(1)%></td>
<td align="center" bgcolor="#FFFFFF" class="Txt"><%=GetSPCountBySPLBID(rS(0))%></td>
<td align="center" bgcolor="#FFFFFF" class="Txt"><%=GetRKCKKCSLBySPLBID(rS(0),"RK")%></td>
<td align="center" bgcolor="#FFFFFF" class="Txt"><%=GetRKCKKCSLBySPLBID(rS(0),"CK")%></td>
<td align="center" bgcolor="#FFFFFF" class="Txt"><%=GetRKCKKCSLBySPLBID(rS(0),"RK")-GetRKCKKCSLBySPLBID(rS(0),"CK")%></td>
<td bgcolor="#FFFFFF" class="Txt"> ￥：<%=GetRKCKKCSLBySPLBID(rS(0),"RKJE")%></td>
<td bgcolor="#FFFFFF" class="Txt"> ￥：<%=GetRKCKKCSLBySPLBID(rS(0),"CKJE")%></td>
</tr>
<%
rS.MoveNext
Next
rS.close
%>
</table> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -