📄 show_sell_detail.asp

📁 Activity——活动管理模块 Analyse——分析模块 Client——客户管理系统模块 Email——E-mail管理模块 Fee——费用管理模块 Report——报表模块 Sel
💻 ASP
字号:
<%@ LANGUAGE="VBSCRIPT"%>
<!--#include file="../conn.asp"-->
<!--#include file="../IsUser.asp"-->
<!--#include file="../Pub_Fun.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>销售详表</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META http-equiv=Pragma content=no-cache>
<META content="MSHTML 6.00.2715.400" name=GENERATOR>
<style type="text/css">
<!--
.style1 {color: #FF6600}
-->
</style>

</HEAD>
<LINK href="../css.css" rel=stylesheet>

<body>
<%
''接受传递过来的参数
if  (request("selltopic")) ="" then
   topic=""
else
    topic=trim(request("selltopic")) 
end if
if  (request("selldate")) ="" then
   selldate=""
else
    selldate=trim(request("selldate")) 
end if

	set rec = server.createobject("adodb.recordset")
	sql = "select * from sell where  selltopic ='" & topic&"'  and selldate='"&selldate&"' order by sellID"
	
	
	rec.open sql,conn,3
%>

<TABLE border=0 cellPadding=5 cellSpacing=0 width="600" align="center">
	<tr class='CListTTL'>		
      <td height = '30' valign="middle" colspan="2"><font color = yellow size = 3><b>销售明细</b></font></td>
	</tr>
<%
if not rec.eof then%>
	<tr class=CRow>		
      <td height = '24' align="left"><strong>销售主题：</strong>&nbsp;&nbsp;<%=rec("selltopic")%>
		</td>
         <td height = '24' align="left"> &nbsp;&nbsp;<strong>销售日期：</strong>&nbsp;&nbsp;<%=rec("selldate")%>
		</td>
	</tr>
	<tr class=CRow>		
      <td height = '24' align="left"><strong>相关客户：</strong>&nbsp;&nbsp;<%=showclientname(rec("sellclientid"))%>
		</td>
       <td height = '24' align="left"> &nbsp;&nbsp;<strong>相关联系人：</strong>&nbsp;&nbsp;<%=showtouchmanname(rec("selltouchmanID"))%>
		</td>
	</tr>
	<tr class=CRow>
		<td height = '24' align="left" colspan="2"><strong>订单/合同号：</strong>&nbsp;&nbsp;<%=rec("SellOrderNum")%></td>
	</tr>
	<tr class=CRow>
		<td height = '24' align="left" colspan="2"><strong>操作者</strong>：&nbsp;&nbsp;<%=showoperatorname(rec("sellCreatorID"))%></td>
	</tr>
	<tr class=CRow>
		<td height = '24' align="left" colspan="2">
 <strong>销售说明：</strong></td>
	</tr>
	<tr class=CRow>
		<td height = '24' align="left" colspan="2">
<%=rec("Selldetail")%>&nbsp;&nbsp;
		</td>
	</tr>
<% else%>
	<tr class=CRow>
		<td height = '24' align="left" colspan="2">
&nbsp;&nbsp;没有此记录！
		</td>
	</tr>
<%end if%>
</TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="600" align="center">
	<TR class=CRow>
		<TD>		
			<table border="1" cellPadding=0 cellSpacing=0  width="600">
			  	<tr class=CRow>
					<td align="center" >物品名称</td>
					<td align="center" >销售价格</td>
					<td align="center" >销售数量</td>
					<td align="center">金额</td>
				</tr>
			 <%
			 total = 0
			 while not rec.eof
				total = total + cdbl(rec("SellProductPrice")) * cdbl(rec("sellProductnum"))
				%>
			  <tr class=CRow>
				<td  align="center">&nbsp;<%=rec("Sellproduct")%></td>
				<td  align="right">&nbsp;<%=formatNumber(rec("SellProductPrice"),2,-1)%>&nbsp;</td>
				<td  align="right">&nbsp;<%=rec("sellProductnum")%>&nbsp;</td>
				<td  align="right">&nbsp;<%=formatNumber(cdbl(rec("SellProductPrice")) * cdbl(rec("sellProductnum")),2,-1)%>&nbsp;</td>
			  </tr>
			<%	rec.movenext
			  wend%>
			 	 <tr class=CRow>					
					<td colspan="2">&nbsp;</td>
					<td align="right">&nbsp;合计：</td>
					<td align="right">&nbsp;<b><%=formatNumber(total,2,-1)%>&nbsp;</td>
				 </tr>
			</table>
		<TD>
	</TR>
</TABLE>
<br>
<center>
<input name="CancelButton" type="button" class="button_all"  value="关闭" onclick="window.close()">
</center>

</BODY>
</HTML>
⌨️ 快捷键说明

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