ad_dofz.asp
来自「OFFICE办公自动化」· ASP 代码 · 共 282 行
ASP
282 行
<%
'==============================================================
'OA 表单生成器
'版本: 1.1.0 -- 2005-5-24
'程序版权：(c) 2004 by 展亮
'说明：本代码为自由代码，用户可以自由使用，但请保留作者文件头部说明
' 在使用过程中如出现什么问题请及时与作者联系。
' 电子邮件：zlbox@yeah.net QQ:2343397
'=============================================================
'功能：添加/编辑户外广告登记表
'参数： request.form("addedit_subed")="true"#表单提交; request("id")#要编辑记录的ID;
'=============================================================
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<!--#include file="../inc/ronger.asp"-->
<%
'response.buffer=false
'------------------------------------------------设置参数
LoginID=trim(Session("LoginID")) : if LoginID="" then LoginID=0 '当前用户ID
pid=request("id"):if pid="" then pid=0 '记录ID
'------------------------------------------------
'------------------------------------------------添加/修改记录
table="tbioaAd" '表名
if request.form("addedit_subed")="true" then
'表单提交后
if pid=0 then
call insert(table,false)
response.write "<script>alert('户外广告登记表录入成功！');this.location='ad_list.asp'</script>"
response.end
else
call update(table,"id",pid,false)
response.write "<script>alert('户外广告登记表修改成功！');history.go(-2)</script>"
response.end
end if
end if
'--------------------------------------------取记录
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from " & table & " where ID="&pid
rs.open sql,oConn,1,1
'------------------------------------------------
function showvalue(field)
if rs.eof then
showvalue=""
else
if (isnull(rs(field))) then showvalue="" else showvalue=Server.HTMLEncode(rs(field))
end if
end function
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>main</title>
<script src="../js/Popup.js"></script>
<script src="../js/formatdate.js"></script>
<script src="../js/front_chec.js"></script>
</head>
<body topmargin="10" leftmargin="10">
<table border=0 cellspacing="0" cellpadding="0">
<tr>
<td><img border="0" src="../images/icon_menu.gif" align="left"><a href="ad_sc.asp">户外广告发证</a> </td>
</tr>
</table>
<hr width="100%" size=1 color="#000000">
<br>
<div align="center">
<table width="500" cellspacing="1" cellpadding="2" class="tab">
<tr>
<td width="100%" class="tdTop">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="tdTop">
<p align="left"><img border="0" src="../images/icon_title.gif" align="left">录入户外广告登记表</p>
</td>
<td width="90" class="tdTop">
<p align="left"><img border="0" src="../images/icon_return.gif" align="left">
<a href="javascript:history.back()" class="linkTop">返回列表</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<form name="eventfrm" method="POST" action="?id=<%=pid%>" onSubmit="return checknull(this)">
<input type=hidden name="addedit_subed" value="true">
<input type=hidden name="smod" value="4">
<td width="25%" class="td1">
提交单位：<%=HtmlOut(GetTableValue("tbioaDepartment","Name","id",rs("area")))%>
提交人：<%=HtmlOut(GetUserName(rs("userid")))%>
提交时间：<%=rs("sdate")%>
状态：<%=GetAdMod(rs("smod"))%>
<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>
<%fzrq=showvalue("fzrq")
if fzrq="" then fzrq=date()
%>
<tr>
<td colSpan="3" class="td0">
<div align="center">
《户外广告登记证》编号 </div> </td>
<td colSpan="5" class="td0">
<input type="text" name="djzbh" value="<%=showvalue("djzbh")%>" size="20" maxlength="30" class="input" check_null="请填写《户外广告登记证》编号"> <font COLOR="RED">*</font>
</td>
<td colSpan="3" class="td0">
<div align="center">
发证日期 </div> </td>
<td width="129" colSpan="2" class="td0">
<input TYPE="TEXT" SIZE="12" MAXLENGTH="12" NAME="fzrq" value="<%=fzrq%>" class="input" check_null="请填写发证日期" check_date="日期格式错误" onKeyUp="DateFormat(this,this.value,event,false,'2')"> <a href=# title="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.eventfrm.fzrq, 'winpop', 234, 261);return false"><img src="../images/datetime.gif" border=0></a> <font COLOR="RED">*</font>
</td>
</tr>
<tr>
<td colSpan="3" class="td0">
<div align="center">
领证人 </div> </td>
<td colSpan="5" class="td0">
<input type="text" name="lzr" value="<%=showvalue("lzr")%>" size="20" maxlength="250" class="input" check_null="请填写领证人"> <font COLOR="RED">*</font>
</td>
<td colSpan="3" class="td0">
<div align="center">
发证人 </div> </td>
<td width="129" colSpan="2" class="td0">
<%=HtmlOut(GetUserName(LoginID))%>
<input type="hidden" name="fzr" value="<%=LoginID%>">
</td>
</tr>
<tr>
<td colSpan="3" class="td0">
<div align="center">
领证人联系电话 </div> </td>
<td width="159" colSpan="5" class="td0">
<input type="text" name="lzrdh" value="<%=showvalue("lzrdh")%>" size="20" maxlength="250" class="input">
</td>
<td colSpan="3" class="td0">
<div align="center">
备 注 </div> </td>
<td width="129" colSpan="2" class="td0">
<input type="text" name="bz" value="<%=showvalue("bz")%>" size="20" maxlength="250" class="input">
</td>
</tr>
<tr>
<td colSpan="4" class="td0">
<div align="center">
原《户外广告登记证》缴销情况 </div> </td>
<td width="360" colSpan="9" class="td0">
<input type="text" name="jxqk" value="<%=showvalue("jxqk")%>" size="59" maxlength="250" class="input">
</td>
</tr>
<tr>
<td colspan="13" align="center">
<input type="submit" value="确定" class="button0" onmouseout=className="button0" onmouseover=className="button1"> <input type="reset" value="全部重写" class="button0" onmouseout=className="button0" onmouseover=className="button1">
</td>
</tr>
</table>
</td>
</form>
</tr>
<tr>
<td width="25%" class="tdBottom">
</td>
</tr>
</table>
</div>
</body>
</html>
<%'释放对象变量
rs.close
oConn.close
%> ⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?