<%
' 文件名:list.asp
' 功能:客户定单列表
%>
<%
If Session("userid")= "" Then Response.Redirect "../../login.asp?link=./xxpt/advertise/list.asp"
struser="Select companyname From user where userid="&Session("userid")
set rsuser=Conn.Execute(struser)
%>
欢迎进入科迅电子电器有限公司主页--广告管理--<%=rsuser("companyname")%>的广告定单
<% strSQL="select count(bannerid) as AdCount from banner where userid="&session("userid")
set rsAd=Conn.execute(strSQL)
intSum = rsAd("AdCount")
set rsAd = nothing
strSQL="select count(bannerid) as AdCount from banner where isconfirmed=1 and userid="&session("userid")
set rsAd=Conn.execute(strSQL)
intConfirmed = rsAd("AdCount")
set rsAd = nothing
strSQL="select count(bannerid) as AdCount from banner where isconfirmed=0 and userid="&session("userid")
set rsAd=Conn.execute(strSQL)
intUnconfirmed = rsAd("AdCount")
set rsAd = nothing
%>
<% strSQL="select count(adid) as AdCount from advertisement where userid="&session("userid")
set rsAd=Conn.execute(strSQL)
intSum = rsAd("AdCount")
set rsAd = nothing
strSQL="select count(adid) as AdCount from advertisement where (isconfirmed=1 or isconfirmed=2) and userid="&session("userid")
set rsAd=Conn.execute(strSQL)
intConfirmed = rsAd("AdCount")
set rsAd = nothing
strSQL="select count(adid) as AdCount from advertisement where isconfirmed=0 and userid="&session("userid")
set rsAd=Conn.execute(strSQL)
intUnconfirmed = rsAd("AdCount")
set rsAd = nothing
%>
