📄 ad_show.asp
字号:
<%
'OA 表单生成器1.0
'功能：查看户外广告登记表
'参数：request("id")=int #记录ID
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<%
'response.buffer=false
'------------------------------------------------设置参数
LoginID=trim(Session("LoginID")) : if LoginID="" then LoginID=0 '当前用户ID
pid=request("id") '记录ID
'------------------------------------------------
'------------------------------------------------取记录
'取要查看的记录 （返回rs对象）
table="tbioaAd" '表名
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from " & table & " where ID="&pid
rs.open sql,oConn,1,1
'------------------------------------------------
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>户外广告登记表详细信息</title>
</head>
<body topmargin="10" leftmargin="10">
<div class="noprint">
<table border="0" cellspacing='0' cellpadding='4' width="100%" class="noprint" style="border-bottom: 1 dotted #808080">
<tr>
<td nowrap>
<img src="../images/icon_title.gif" align="absMiddle"> <b>户外广告登记（变更登记）审核表</b>
</td>
<td width="85" nowrap>
<object id="WebBrowser" width=0 height=0 classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" > </object>
<img src="../images/PageSetup.gif" align="absMiddle"> <a href="#" onClick="document.all.WebBrowser.ExecWB(8,1);return false">
页面设置</a>
</td>
<td width="85" nowrap>
<img src="../images/print.gif" align="absMiddle"> <a href="#" onClick="document.all.WebBrowser.ExecWB(7,1);return false">
打印预览</a>
</td>
<td width="85" nowrap>
<img src="../images/icon_close.gif" align="absMiddle"> <a href="javascript:window.close()">
关闭窗口</a>
</td>
</tr>
</table>
<br>
提交单位：<%=HtmlOut(GetTableValue("tbioaDepartment","Name","id",rs("area")))%>
提交人：<%=HtmlOut(GetUserName(rs("userid")))%>
提交时间：<%=rs("sdate")%>
状态：<%=GetAdMod(rs("smod"))%><br>
广告样件：
<%
sql="select * from tbioaAdYj where adid='"&pid&"'"
set rsyj=Server.CreateObject("ADODB.recordset")
rsyj.Open sql,oconn,1,3
while not rsyj.eof
%>
[<a href="files/<%=rsyj("filename")%>" target="_blank"><font color=red><%=rsyj("name")%></font></a>]
<%
rsyj.movenext
wend
rsyj.close
%>
</div>
<div align="right">
编号 <u><%=right("000000"&rs("id"),6)%></u></div>
<div align="center" style="font-size: 16px;">
<p><b>户外广告登记（变更登记）审核表</b></p>
</div>
<div align="center">
<table align="center" height="564" width="640" cellspacing="0" cellpadding="0" bordercolorlight="#C0C0C0" border="1" bordercolordark="#FFFFFF">
<tr>
<td colSpan="13" align="center" class="td1">
<div align="center">
<b>受 理 情
况</b> </div> </td>
</tr>
<tr>
<td width="120" colSpan="2" class="td0">
<div align="center">
受理通知书文号</div> </td>
<td width="118" colSpan="3" class="td0"><%=HtmlOut(rs("wh"))%> </td>
<td width="87" colSpan="2" class="td0">
<div align="center">
受理日期 </div> </td>
<td width="90" colSpan="3" class="td0"><%=HtmlOut(rs("slrq"))%> </td>
<td width="84" colSpan="2" class="td0">
<div align="center">
受理人员 </div> </td>
<td width="96" class="td0"><%=HtmlOut(rs("slry"))%> </td>
</tr>
<tr>
<td colSpan="13" align="center" class="td1">
<div>
<b>拟 核 准
情 况</b> </div> </td>
</tr>
<tr>
<td colSpan="2" class="td0">
<div align="center">
发布单位名称 </div> </td>
<td width="476" colSpan="11" class="td0"><%=HtmlOut(rs("fbdw"))%> </td>
</tr>
<tr>
<td colSpan="2" class="td0">
<div align="center">
广告发布地点 </div>
<div align="center">
及具体位置 </div> </td>
<td width="476" colSpan="11" class="td0"><%=HtmlOut(rs("fbwz"))%> </td>
</tr>
<tr>
<td colSpan="2" class="td0">
<div align="center">
广告发布期限 </div> </td>
<td width="476" colSpan="11" class="td0">
自 <%=formatdatetime(rs("fbqxs"),1)%> 至 <%=formatdatetime(rs("fbqxe"),1)%> </td>
</tr>
<tr>
<td colSpan="2" class="td0">
<div align="center">
广告形式、数 </div>
<div align="center">
量及规格 </div> </td>
<td width="476" colSpan="11" class="td0"><%=HtmlOut(rs("ggxs"))%> </td>
</tr>
<tr>
<td colSpan="2" class="td0">
<div align="center">
广告内容 </div> </td>
<td width="476" colSpan="11" class="td0">
名称：<%=HtmlOut(rs("ggmc"))%> 样件编号：<%=HtmlOut(rs("yjbh"))%> </td>
</tr>
<tr>
<td width="303" colSpan="6" class="td0">
<div align="center">
户外广告登记证号标准要求 </div> </td>
<td width="292" colSpan="7" class="td0">
<div align="center">
<%if rs("bzyq") then%>
□应当标注 ■同意不标注
<%else%>
■应当标注 □同意不标注
<%end if%>
</div> </td>
</tr>
<tr>
<td class="td0">
<div align="center">
审查人 </div> </td>
<td width="187" colSpan="5" class="td0"><%=HtmlOut(GetUserName(rs("scr")))%> </td>
<td colSpan="3" class="td0" align="center">
审查日期 </td>
<td width="204" colSpan="4" class="td0"><%=HtmlOut(rs("scrq"))%> </td>
</tr>
<tr>
<td class="td0">
<div align="center">
<b>审</b> </div>
<div align="center">
<b>核</b> </div>
<div align="center">
<b>意</b> </div>
<div align="center">
<b>见</b> </div> </td>
<td colSpan="12" class="td0" valign="top"><p><%=HtmlOut(rs("shyj"))%></p>
<p align="right">签字：<%=HtmlOut(GetUserName(rs("shr")))%>
<%if rs("shrq")<>"" then response.Write formatdatetime(rs("shrq"),1)%> </p></td>
</tr>
<tr>
<td colSpan="13" align="center" class="td1">
<div align="center">
<b>《户外广告登记证》核发情况</b> </div> </td>
</tr>
<tr>
<td colSpan="3" class="td0">
<div align="center">
《户外广告登记证》编号 </div> </td>
<td width="159" colSpan="5" class="td0"><%=HtmlOut(rs("djzbh"))%> </td>
<td colSpan="3" class="td0">
<div align="center">
发证日期 </div> </td>
<td width="129" colSpan="2" class="td0"><%if rs("fzrq")<>"" then response.Write formatdatetime(rs("fzrq"),1)%> </td>
</tr>
<tr>
<td colSpan="3" class="td0">
<div align="center">
领证人签字 </div> </td>
<td width="159" colSpan="5" class="td0"><%=HtmlOut(rs("lzr"))%> </td>
<td colSpan="3" class="td0">
<div align="center">
发证人签字 </div> </td>
<td width="129" colSpan="2" class="td0"><%=HtmlOut(GetUserName(rs("fzr")))%> </td>
</tr>
<tr>
<td colSpan="3" class="td0">
<div align="center">
领证人联系电话 </div> </td>
<td width="159" colSpan="5" class="td0"><%=HtmlOut(rs("lzrdh"))%> </td>
<td colSpan="3" class="td0">
<div align="center">
备 注 </div> </td>
<td width="129" colSpan="2" class="td0"><%=HtmlOut(rs("bz"))%> </td>
</tr>
<tr>
<td colSpan="4" class="td0">
<div align="center">
原《户外广告登记证》缴销情况 </div> </td>
<td width="360" colSpan="9" class="td0"><%=HtmlOut(rs("jxqk"))%> </td>
</tr>
</table>
</body>
</html>
<%'释放对象变量
rs.close
oConn.close
%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -