📄 khtj_nftj_ok.asp
字号:
<html>
<head>
<title>『晨景软体』-客户资源管理系统</title>
<link rel="stylesheet" href="other/customer.css">
<style>
.drag{position:relative;cursor:hand}
</style>
<script language="JavaScript">
var dragapproved=false
var eventsource,x,y
function move()
{
if (event.button==1&&dragapproved) //改变被拖动元素在页面上的位置
{
self.moveBy (event.clientX-x,event.clientY-y); //改变窗体位置
return false
}
}
function drags()
{
if (!document.all)
return
if (event.srcElement.className=="drag") //捕捉鼠标当前位置
{
dragapproved=true//确信当前鼠标是按下
x=event.clientX//鼠标当前位置
y=event.clientY//鼠标当前位置
document.onmousemove=move//调动move函数
}
}
document.onmousedown=drags //鼠标左键按下时,准备拖动
document.onmouseup=new Function("dragapproved=false")//鼠标左键放开时,拖动停止
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<%
if request("nian")="" then
request_nian="2000"
else
request_nian=request("nian")
end if
dim yue_id(12)
'打开数据库
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};pwd=webcool_2000;dbq=" & Server.MapPath("../database/customer.mdb")
for aaa=1 to 12
'建立rs对象
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT id FROM company where nian='"&request_nian&"'and yue='"&cstr(aaa)&"'"
'发送一条SQL的指令
rs.Open sql, conn, 3
yue1=0
while not rs.eof
yue1=yue1+1
rs.movenext
wend
yue_id(aaa)=yue1
next
if yue_id(1)=0 and yue_id(2)=0 and yue_id(3)=0 and yue_id(4)=0 and yue_id(5)=0 and yue_id(6)=0 and yue_id(7)=0 and yue_id(8)=0 and yue_id(9)=0 and yue_id(10)=0 and yue_id(11)=0 and yue_id(12)=0 then
total=2
else
total=yue_id(1)+yue_id(2)+yue_id(3)+yue_id(4)+yue_id(5)+yue_id(6)+yue_id(7)+yue_id(8)+yue_id(9)+yue_id(10)+yue_id(11)+yue_id(12)
end if
%>
<body bgcolor="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table border="0" cellpadding="0" cellspacing="0" width="619">
<tr>
<td><img src="images/spacer.gif" width="5" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="609" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="5" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="1" height="1" border="0"></td>
</tr>
<tr>
<td colspan="3" background="images/cx_r1_c1.gif" class="title" valign="middle"> 『晨景软体』-客户统计-年份统计
<div id="Layer1" style="position:absolute; width:22px; height:21px; z-index:3; left: 598px; top: 6px"><a href="javascript:window.close()"><img src="images/xx.gif" width="13" height="13" border="0"></a></div>
</td>
<td><img src="images/spacer.gif" width="1" height="26" border="0"></td>
</tr>
<tr>
<td rowspan="2"><img name="cx_r2_c1" src="images/cx_r2_c1.gif" width="5" height="423" border="0"></td>
<td bgcolor="#cdd5e4">
<table width="100%" cellspacing="1" height="415">
<tr>
<td height="37" colspan="2">
<table width="100%" bordercolor="#000000" border="1" cellspacing="0">
<FORM METHOD=POST ACTION="khtj_nftj_ok.asp" >
<tr bgcolor="#657cb1" bordercolor="#657cb1">
<td class="big" valign="bottom" height="2" width="47%">
<div align="right">请选择要统计的年份</div>
</td>
<td class="small" valign="middle" height="2" width="12%">
<select name="nian">
<%if request("nian")="1999" or request("nian")="" then%>
<option selected>1999</option>
<%else%>
<option>1999</option>
<%end if%>
<%if request("nian")="2000" or request("nian")="" then%>
<option selected>2000</option>
<%else%>
<option>2000</option>
<%end if%>
<%if request("nian")="2001" then%>
<option selected>2001</option>
<%else%>
<option>2001</option>
<%end if%>
<%if request("nian")="2002" then%>
<option selected>2002</option>
<%else%>
<option>2002</option>
<%end if%>
<%if request("nian")="2003" then%>
<option selected>2003</option>
<%else%>
<option>2003</option>
<%end if%>
<%if request("nian")="2004" then%>
<option selected>2004</option>
<%else%>
<option>2004</option>
<%end if%>
<%if request("nian")="2005" then%>
<option selected>2005</option>
<%else%>
<option>2005</option>
<%end if%>
<%if request("nian")="2006" then%>
<option selected>2006</option>
<%else%>
<option>2006</option>
<%end if%>
<%if request("nian")="2007" then%>
<option selected>2007</option>
<%else%>
<option>2007</option>
<%end if%>
<%if request("nian")="2008" then%>
<option selected>2008</option>
<%else%>
<option>2008</option>
<%end if%>
<%if request("nian")="2009" then%>
<option selected>2009</option>
<%else%>
<option>2009</option>
<%end if%>
<%if request("nian")="2010" then%>
<option selected>2010</option>
<%else%>
<option>2010</option>
<%end if%>
</select>
</td>
<td class="small" valign="middle" height="2" width="41%"><input type="image" img src="images/qd.gif" width="45" height="17"></td>
</tr>
</FORM>
</table>
</td>
</tr>
<tr>
<td height="349" colspan="2">
<table width="100%" cellspacing="1" bgcolor="#666666">
<tr bgcolor="#657cb1" class="big_b">
<td width="12%">
<div align="center">月 份</div>
</td>
<td width="22%">
<div align="center">客户数</div>
</td>
<td width="66%">
<div align="center">统 计 图</div>
</td>
</tr>
<tr bgcolor="#F8F4E0">
<td width="12%" class="small" align="center">1 月</td>
<td width="22%"class="small"><%=yue_id(1)%></td>
<td width="66%"class="small"><img src="images/red.jpg" width="<%=yue_id(1)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F4F4E8">
<td width="12%" class="small" align="center">2 月</td>
<td width="22%" class="small"><%=yue_id(2)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(2)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F8F4E0">
<td width="12%" class="small" align="center">3 月</td>
<td width="22%" class="small"><%=yue_id(3)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(3)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F4F4E8">
<td width="12%" class="small" align="center">4 月</td>
<td width="22%" class="small"><%=yue_id(4)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(4)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F8F4E0">
<td width="12%" class="small" align="center">5 月</td>
<td width="22%" class="small"><%=yue_id(5)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(5)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F4F4E8">
<td width="12%" class="small" align="center">6 月</td>
<td width="22%" class="small"><%=yue_id(6)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(6)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F8F4E0">
<td width="12%" class="small" align="center">7 月</td>
<td width="22%" class="small"><%=yue_id(7)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(7)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F4F4E8">
<td width="12%" class="small" align="center">8 月</td>
<td width="22%" class="small"><%=yue_id(8)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(8)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F8F4E0">
<td width="12%" class="small" align="center">9 月</td>
<td width="22%" class="small"><%=yue_id(9)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(9)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F4F4E8">
<td width="12%" class="small" align="center">10月</td>
<td width="22%" class="small"><%=yue_id(10)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(10)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F8F4E0">
<td width="12%" class="small" align="center">11月</td>
<td width="22%" class="small"><%=yue_id(11)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(11)/total*100%>" height='15'></td>
</tr>
<tr bgcolor="#F4F4E8">
<td width="12%" class="small" align="center">12月</td>
<td width="22%" class="small"><%=yue_id(12)%></td>
<td width="66%" class="small"><img src="images/red.jpg" width="<%=yue_id(12)/total*100%>" height='15'></td>
</tr>
</table> <p align="center"><br>
<a href="javascript:window.close()"><img src="images/tc.gif" width="45" height="17" border="0"></a></p>
</td>
</tr>
<tr>
<td class="small" width="23%" >
<div align="left"></div>
</td>
<td class="small" width="77%" >
<div align="right" ></div>
</td>
</tr>
</table>
</td>
<td rowspan="2"><img name="cx_r2_c3" src="images/cx_r2_c3.gif" width="5" height="423" border="0"></td>
<td><img src="images/spacer.gif" width="1" height="418" border="0"></td>
</tr>
<tr>
<td><img name="cx_r3_c2" src="images/cx_r3_c2.gif" width="609" height="5" border="0"></td>
<td><img src="images/spacer.gif" width="1" height="5" border="0"></td>
</tr>
</table>
<div class="drag" id="Layer2" style="position:absolute; left:2px; top:1px; width:596px; height:22px; z-index:2"></div>
<%'=关闭数据库============================
conn.close'关闭数据库
set conn=nothing
%>
</body>
</html>
<html></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -