xslist.asp

来自「创建和运行动态、交互的Web服务器应用程序」· ASP 代码 · 共 120 行

ASP
120 行
字号 
<!--#include file="conn.asp"-->
<html>
<head>
<title><%=webname%>--图书销售小票单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/css2.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
dim action,xianji,zipiao,zholin,shijian,dxdingdan,dx,dxindex,i,bookid,bookname,bkcount,shichangjia,dxzk

    action = request.QueryString("action")
    zholin = request("zli")
    xianji = request("xjk")
    zipiao = request("zpk")

    '//数据处理
    shijian = now()
    dxdingdan = "Ax"&year(shijian)&month(shijian)&day(shijian)&hour(shijian)&minute(shijian)&second(shijian)

    dx      = Session("mydx") 
    dxindex = session("dxindex")

for i=1 to dxindex-1

    bookid       = dx(i,0)   
    bookname     = dx(i,1)
    bkcount      = dx(i,2)
    shichangjia  = dx(i,3)
    dxzk         = dx(i,4)  

set rs2=server.CreateObject("adodb.recordset")
    rs2.open "select * from shop_dxaction",conn,1,3

    rs2.addnew
    rs2("dxdingdan")  = dxdingdan
    rs2("username")   = "Ax000000"
    rs2("bookid")     = bookid
    rs2("xbkcount")   = bkcount
    rs2("dxmy")       = shichangjia*bkcount
    rs2("dxzk")       = dx(i,4)
    rs2("dxsy")       = shichangjia*bkcount*dxzk
    rs2("dxactiondate") = date
    rs2("xianji") = xianji
    rs2("zipiao") = zipiao
    rs2("zholin") = zholin
    rs2.update
next

for i=0 to dxindex 
    for j=0 to 5
    dx(i,j)=""
    next
next

Session("mydx")=dx 
session("dxindex")=0

'//显示
set rs=server.CreateObject("adodb.recordset")
    rs.open "select shop_books.bookid,shop_books.bookname,shop_books.isbn,shop_books.shichangjia,shop_dxaction.username,shop_dxaction.dxdingdan,shop_dxaction.xbkcount,shop_dxaction.dxsy,shop_dxaction.dxactiondate,shop_dxaction.xianji,shop_dxaction.zipiao,shop_dxaction.zholin FROM shop_dxaction INNER JOIN shop_books ON shop_dxaction.bookid = shop_books.bookid where shop_dxaction.dxdingdan='"&dxdingdan&"' ",conn,1,1
%>
<table width="90%" height="450" border="0"  cellpadding="0" cellspacing="0">
   <tr><td><br>
       <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr><td height=5></td></tr> 
          <tr>
             <td align="center" colspan="4"><font color=blue size=3><b><%=webname%>图书销售小票</b></font></td>
          </tr>
          <tr><td colspan=4 align="center"><hr noshade color=#cccccc size=1></td></tr>
          <tr> 
             <td STYLE='PADDING-LEFT: 30px'>日期：  <font color=#ff3300><%=rs("dxactiondate")%></font></td>
             <td STYLE='PADDING-LEFT: 30px'>流水号：<font color=#ff3300><%=rs("dxdingdan")   %></font></td>
             <td STYLE='PADDING-LEFT: 30px'>会员号：<font color=#ff3300><%=rs("username")    %></font></td>
             <td STYLE='PADDING-LEFT: 30px'>收银员：<font color=#ff3300><%=session("admin")  %></font></td>
          </tr>
          <tr><td height=5></td></tr> 
          </tr> 
       </table>

       <table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#cccccc">
          <tr>
             <td width="37%" bgcolor="#ece9d8" align="center">书名</td>
             <td width="8%"  bgcolor="#ece9d8" align="center">定价</td>
             <td width="10%" bgcolor="#ece9d8" align="center">数量</td>
             <td width="12%" bgcolor="#ece9d8" align="center">金额</td>
          </tr>
          <%do while not rs.eof%> 
          <tr>
             <td width="37%" bgcolor="#ffffff" align="center"><%=rs("bookname")%></td>
             <td width="8%"  bgcolor="#ffffff" align="center"><%=formatnumber(rs("shichangjia"))%></td>
             <td width="10%" bgcolor="#ffffff" align="center"><%=rs("xbkcount")%></td>
             <td width="12%" bgcolor="#ffffff" align="center"><%=formatnumber(rs("dxsy"),2)%></td>
            <%
              total1 = total1+rs("xbkcount")
              total2 = total2+rs("dxsy")
             %>           
          </tr> 
            <%
          rs.movenext
             loop
          rs.movefirst
            %>
          </tr>
       </table>
       <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr height=40> 
             <td width="10%" align="right">总数量&nbsp;</td><td><font color="#FF0000"><%=total1%></font>&nbsp;册</td>
             <td width="10%" align="right">总金额&nbsp;</td><td><font color="#FF0000"><%=formatnumber(total2,2)%></font>&nbsp;元</td>
             <td width="8%"  align="right">现金&nbsp;  </td><td><font color="#FF0000"><%=formatnumber(rs("xianji"),2)%></font>&nbsp;元</td>
             <td width="8%"  align="right">支票&nbsp;  </td><td><font color="#FF0000"><%=formatnumber(rs("zipiao"),2)%></font>&nbsp;元</td>
             <td width="8%"  align="right">找零&nbsp;  </td><td><font color="#FF0000"><%=formatnumber(rs("zholin"),2)%></font>&nbsp;元</td>
          </tr>
      </table>

    </tr>
</table>
</body>
</html>

xslist.asp - 源码说明

本页面展示了「创建和运行动态、交互的Web服务器应用程序」中的 xslist.asp 源码文件，采用 ASP 编程语言编写，共 120 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与Web服务器相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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