📄 tjzl_mrtj.asp
字号:
<html>
<head>
<title>每日统计</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="other/customer.css">
<style type="text/css">
<!--
.font {
letter-spacing: 3pt;
}
-->
</style>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
'与数据库*.mdb建立连接
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};pwd=webcool_2000;dbq=" & Server.MapPath("../database/customer.mdb")
'发送一条查询指令
SET rs=CONN.EXECUTE("SELECT * FROM company WHERE day(dat)=day(date())")
'计算新增客户数量
counter=0
while not rs.eof
counter=counter+1
rs.movenext
wend
'发送一条查询指令
SET rs1=CONN.EXECUTE("SELECT * FROM worker where name_njd='0'")
'今日业务员数量
counter1=0
while not rs1.eof
counter1=counter1+1
rs1.movenext
wend
'发送一条查询指令
SET rs2=CONN.EXECUTE("SELECT * FROM talk WHERE day(dat)=day(date())")
'计算洽谈总次数
counter2=0
while not rs2.eof
counter2=counter2+1
rs2.movenext
wend
'发送一条查询指令
SET rs3=CONN.EXECUTE("SELECT * FROM jiaoyi WHERE day(dat)=day(date())")
'计算交易总次数
counter3=0
while not rs3.eof
counter3=counter3+1
rs3.movenext
wend
'发送一条查询指令
SET rs4=CONN.EXECUTE("SELECT * FROM jiaoyi WHERE day(dat)=day(date())")
'计算交易总额
money_total=0
while not rs4.eof
money_total=money_total+rs4("money_1")
rs4.movenext
wend
%>
<p><br>
<br>
</p><center>
<table width="65%" border="0" cellpadding="0" cellspacing="1" bgcolor="#475d8f">
<tr>
<td height="441" bgcolor="#FFFFFF">
<table width="100%" cellspacing="0" height="369" class="small" align="center">
<tr class="small">
<td height="77" width="37%" bgcolor="#FFFFFF">
<p> <img src="images/grywysl.gif" width="70" height="63"></p>
</td>
<td height="77" width="37%" bgcolor="#FFFFFF">
<table width="75%" border="0" cellpadding="2" cellspacing="1" bgcolor="#475d86" class="font">
<tr>
<td bgcolor="#657CB1"><font color="#ffffff" class="big">洽谈总数量</font></td>
</tr>
</table>
</td>
<td height="77" colspan="3" bgcolor="#FFFFFF" align="center"><%=counter2%>
<hr size="1">
</td>
<td height="77" width="11%" bgcolor="#FFFFFF"><font color="#657cb1">次</font></td>
</tr>
<tr>
<td height="83" width="37%" bgcolor="#FFFFFF"> <img src="images/szkhsl.gif" width="70" height="63"></td>
<td height="83" width="37%" bgcolor="#FFFFFF">
<table width="75%" border="0" cellpadding="2" cellspacing="1" bgcolor="#475d86" class="font">
<tr>
<td bgcolor="#657cb1"><font color="#ffffff"><span class="big">今日业务员数量</span></font></td>
</tr>
</table>
<font color="#ffffff"> </font></td>
<td height="83" colspan="3" bgcolor="#FFFFFF" align="center"><%=counter1%>
<hr size="1">
</td>
<td height="83" width="11%" bgcolor="#FFFFFF"><font color="#657cb1">人</font></td>
</tr>
<tr>
<td height="101" width="37%" bgcolor="#FFFFFF"> <img src="images/oth.gif" width="70" height="63"></td>
<td height="101" width="37%" bgcolor="#FFFFFF">
<table width="75%" border="0" cellpadding="2" cellspacing="1" bgcolor="#475d86" class="font">
<tr>
<td bgcolor="#657cb1"><font color="#ffffff" class="big">新增客户数量</font><font color="#ffffff"> </font></td>
</tr>
</table>
<font color="#ffffff" class="big"> </font></td>
<td height="101" colspan="3" bgcolor="#FFFFFF" align="center"><%=counter%>
<hr size="1">
</td>
<td height="101" width="11%" bgcolor="#FFFFFF" class="small"><font color="#657cb1">人</font></td>
</tr>
<tr>
<td height="98" width="37%" bgcolor="#FFFFFF"> <img src="images/qtzlcs.gif" width="70" height="63"></td>
<td height="98" width="37%" bgcolor="#FFFFFF">
<table width="75%" border="0" cellpadding="2" cellspacing="1" bgcolor="#475d86" class="font">
<tr>
<td bgcolor="#657cb1"><font color="#ffffff" class="big">交易总次数</font></td>
</tr>
</table>
</td>
<td height="98" colspan="3" bgcolor="#FFFFFF" align="center"><%=counter3%>
<hr size="1">
</td>
<td height="98" width="11%" bgcolor="#FFFFFF" class="small"><font color="#657cb1">次</font></td>
</tr>
<tr>
<td height="76" width="37%" bgcolor="#FFFFFF"> <img src="images/gyzge.gif" width="70" height="63"></td>
<td height="76" width="37%" bgcolor="#FFFFFF">
<table width="75%" border="0" cellpadding="2" cellspacing="1" bgcolor="#475d86" class="font">
<tr>
<td bgcolor="#657cb1"><font color="#ffffff" class="big">交易总金额</font></td>
</tr>
</table>
</td>
<td height="76" colspan="3" bgcolor="#FFFFFF" align="center"><%=money_total%>
<hr size="1">
</td>
<td height="76" width="11%" bgcolor="#FFFFFF" class="small"><font color="#657cb1">.00元</font></td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</body>
</html>
<html></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -