📄 xx.asp
字号:
<!--#include file="../include/Pubconn.asp"-->
<!--#include file="../include/PubFun.asp"-->
<%username=getuser()
userclass=tablevisitor("f_aimdepart",username)
dyear=request("dyear")
xsbm=request("xsbm")
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>客户定单</title><link href="../cread.css" rel="stylesheet" type="text/css">
<base target="main1">
</head>
<body bgcolor="#FFFFFF" >
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%"><b><font size="3"><img border="0" src="../pic/it_22.gif">
</font><font size="2">详细信息</font></b><hr width="40%" size="1" align="left">
</td>
</tr>
</table>
<table width="100%" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0" height="35"><tr>
<td height="22">
</td></tr></table>
<table border="1" cellspacing="0" width="100%" height="38" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0">
<tr>
<td width="13%" height="1" align="center" bgcolor="#DDD2C4"><font size="2">项目(单位)</font></td>
<td width="6%" height="1" bgcolor="#DDD2C4">
<p align="center"><font size="2">年度目标</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">1月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">2月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">3月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">4月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">5月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">6月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">7月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">8月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">9月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">10月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">11月</font></td>
<td width="5%" align="center" bgcolor="#DDD2C4"><font size="2">12月</font></td>
</tr>
<tr bgcolor="#f7f7f7" >
<td width="13%" height="25" align="center">
订单金额(万元)</td>
<%str1="select * from f_aimdepart where object='订单金额(万元)' and year='"&dyear&"' and departcode='"&xsbm&"'"
' response.write str1
set rs1=pubconn.execute(str1)
if not rs1.eof then
a=rs1("objyear")/10000
a1=rs1("obj1")/10000
a2=rs1("obj2")/10000
a3=rs1("obj3")/10000
a4=rs1("obj4")/10000
a5=rs1("obj5")/10000
a6=rs1("obj6")/10000
a7=rs1("obj7")/10000
a8=rs1("obj8")/10000
a9=rs1("obj9")/10000
a10=rs1("obj10")/10000
a11=rs1("obj11")/10000
a12=rs1("obj12")/10000
else
a=0
a1=0
a2=0
a3=0
a4=0
a5=0
a6=0
a7=0
a8=0
a9=0
a10=0
a11=0
a12=0
end if
%>
<td width="6%" height="25" align="center">
<%=a%></td>
<td width="5%" align="center" height="25"><%=a1%> </td>
<td width="5%" align="center" height="25"><%=a2%> </td>
<td width="5%" align="center" height="25"><%=a3%> </td>
<td width="5%" align="center" height="25"><%=a4%> </td>
<td width="5%" align="center" height="25"><%=a5%> </td>
<td width="5%" align="center" height="25"><%=a6%> </td>
<td width="5%" align="center" height="25"><%=a7%> </td>
<td width="5%" align="center" height="25"><%=a8%> </td>
<td width="5%" align="center" height="25"><%=a9%> </td>
<td width="5%" align="center" height="25"><%=a10%> </td>
<td width="5%" align="center" height="25"><%=a11%> </td>
<td width="5%" align="center" height="25"><%=a12%> </td>
</tr>
<tr>
<td width="13%" height="25" align="center" bgcolor="#EDEBEC">
销售回款(万元)</td>
<%str2="select * from f_aimdepart where object='销售回款(万元)' and year='"&dyear&"' and departcode='"&xsbm&"'"
set rs2=pubconn.execute(str2)
if not rs2.eof then
a=rs2("objyear")/10000
a1=rs2("obj1")/10000
a2=rs2("obj2")/10000
a3=rs2("obj3")/10000
a4=rs2("obj4")/10000
a5=rs2("obj5")/10000
a6=rs2("obj6")/10000
a7=rs2("obj7")/10000
a8=rs2("obj8")/10000
a9=rs2("obj9")/10000
a10=rs2("obj10")/10000
a11=rs2("obj11")/10000
a12=rs2("obj12")/10000
else
a=0
a1=0
a2=0
a3=0
a4=0
a5=0
a6=0
a7=0
a8=0
a9=0
a10=0
a11=0
a12=0
end if
%>
<td width="6%" height="25" align="center" bgcolor="#EDEBEC">
<%=a%>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a1%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a2%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a3%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a4%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a5%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a6%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a7%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a8%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a9%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a10%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a11%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a12%> </td>
</tr bgcolor="#f7f7f7">
<tr>
<td width="13%" height="25" align="center">
丢单比率(%)</td>
<%str3="select * from f_aimdepart where object='丢单比率(%)' and year='"&dyear&"' and departcode='"&xsbm&"'"
set rs3=pubconn.execute(str3)
if not rs3.eof then
a=rs3("objyear")/10000
a1=rs3("obj1")/10000
a2=rs3("obj2")/10000
a3=rs3("obj3")/10000
a4=rs3("obj4")/10000
a5=rs3("obj5")/10000
a6=rs3("obj6")/10000
a7=rs3("obj7")/10000
a8=rs3("obj8")/10000
a9=rs3("obj9")/10000
a10=rs3("obj10")/10000
a11=rs3("obj11")/10000
a12=rs3("obj12")/10000
else
a=0
a1=0
a2=0
a3=0
a4=0
a5=0
a6=0
a7=0
a8=0
a9=0
a10=0
a11=0
a12=0
end if
%>
<td width="6%" height="25" align="center">
<%=a%>
<td width="5%" align="center" height="25"><%=a1%> </td>
<td width="5%" align="center" height="25"><%=a2%> </td>
<td width="5%" align="center" height="25"><%=a3%> </td>
<td width="5%" align="center" height="25"><%=a4%> </td>
<td width="5%" align="center" height="25"><%=a5%> </td>
<td width="5%" align="center" height="25"><%=a6%> </td>
<td width="5%" align="center" height="25"><%=a7%> </td>
<td width="5%" align="center" height="25"><%=a8%> </td>
<td width="5%" align="center" height="25"><%=a9%> </td>
<td width="5%" align="center" height="25"><%=a10%> </td>
<td width="5%" align="center" height="25"><%=a11%> </td>
<td width="5%" align="center" height="25"><%=a12%> </td>
</tr>
<tr>
<td width="13%" height="25" align="center" bgcolor="#EDEBEC">
人均访问客户次数(次)</td>
<%str4="select * from f_aimdepart where object='人均访问客户次数(次)' and year='"&dyear&"' and departcode='"&xsbm&"'"
set rs4=pubconn.execute(str4)
if not rs4.eof then
a=rs4("objyear")/10000
a1=rs4("obj1")/10000
a2=rs4("obj2")/10000
a3=rs4("obj3")/10000
a4=rs4("obj4")/10000
a5=rs4("obj5")/10000
a6=rs4("obj6")/10000
a7=rs4("obj7")/10000
a8=rs4("obj8")/10000
a9=rs4("obj9")/10000
a10=rs4("obj10")/10000
a11=rs4("obj11")/10000
a12=rs4("obj12")/10000
else
a=0
a1=0
a2=0
a3=0
a4=0
a5=0
a6=0
a7=0
a8=0
a9=0
a10=0
a11=0
a12=0
end if
%>
<td width="6%" height="25" align="center" bgcolor="#EDEBEC">
<%=a%>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a1%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a2%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a3%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a4%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a5%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a6%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a7%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a8%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a9%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a10%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a11%> </td>
<td width="5%" align="center" bgcolor="#EDEBEC" height="25"><%=a12%> </td>
</tr>
<tr bgcolor="#EDEBEC" >
<td width="13%" height="25" align="center" bgcolor="#F7F7F7">
业务员行动计划完成率(%)</td>
<%str5="select * from f_aimdepart where object='业务员行动计划完成率(%)' and year='"&dyear&"' and departcode='"&xsbm&"'"
set rs5=pubconn.execute(str5)
if not rs5.eof then
a=rs5("objyear")/10000
a1=rs5("obj1")/10000
a2=rs5("obj2")/10000
a3=rs5("obj3")/10000
a4=rs5("obj4")/10000
a5=rs5("obj5")/10000
a6=rs5("obj6")/10000
a7=rs5("obj7")/10000
a8=rs5("obj8")/10000
a9=rs5("obj9")/10000
a10=rs5("obj10")/10000
a11=rs5("obj11")/10000
a12=rs5("obj12")/10000
else
a=0
a1=0
a2=0
a3=0
a4=0
a5=0
a6=0
a7=0
a8=0
a9=0
a10=0
a11=0
a12=0
end if
%>
<td width="6%" height="25" align="center" bgcolor="#F7F7F7">
<%=a%>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a1%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a2%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a3%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a4%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a5%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a6%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a7%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a8%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a9%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a10%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a11%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a12%> </td>
</tr>
<tr bgcolor="#EDEBEC" >
<td width="13%" height="25" align="center" bgcolor="#F7F7F7">
新客户开发数量(家)</td>
<%str6="select * from f_aimdepart where object='新客户开发数量(家)' and year='"&dyear&"' and departcode='"&xsbm&"'"
set rs6=pubconn.execute(str6)
if not rs6.eof then
a=rs6("objyear")/10000
a1=rs6("obj1")/10000
a2=rs6("obj2")/10000
a3=rs6("obj3")/10000
a4=rs6("obj4")/10000
a5=rs6("obj5")/10000
a6=rs6("obj6")/10000
a7=rs6("obj7")/10000
a8=rs6("obj8")/10000
a9=rs6("obj9")/10000
a10=rs6("obj10")/10000
a11=rs6("obj11")/10000
a12=rs6("obj12")/10000
else
a=0
a1=0
a2=0
a3=0
a4=0
a5=0
a6=0
a7=0
a8=0
a9=0
a10=0
a11=0
a12=0
end if
%>
<td width="6%" height="25" align="center" bgcolor="#F7F7F7">
<%=a%>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a1%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a2%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a3%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a4%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a5%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a6%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a7%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a8%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a9%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a10%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a11%> </td>
<td width="5%" align="center" bgcolor="#F7F7F7" height="25"><%=a12%> </td>
</tr>
</table>
<p align="center">
<%if userclass>1 then%>
<a href="frame1.asp?xsbm=<%=xsbm%>&dyear=<%=dyear%>" target="_self">编辑</a>
<%else%>
<a href="frame1.asp?qx=1" target="_self">编辑</a>
<%end if%><a href="javascript:window.print()" target="_self">打印</a>
<a href="javascript:history.back(-1)" target="_self">返回</a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -