addguuang.asp
资源名称:qnmov30.rar [点击查看]
上传用户:qyswxdl
上传日期:2013-06-01
资源大小:1373k
文件大小:9k
源码类别:
家庭/个人应用
开发平台:
ASP/ASPX
- <!--#include file="security.asp"-->
- <%if session("flag")>1 then
- response.write "<script>alert('您的操作权限不够!');history.back();</script>"
- response.end
- end if
- %>
- <!--#include file="../checkpost.asp"-->
- <html>
- <head>
- <title></title>
- <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
- <link rel="stylesheet" type="text/css" href="inc/Admin_STYLE.CSS">
- <style type="text/css">
- <!--
- body {
- background-color: #FFFFFF;
- }
- .样式1 {
- color: #000000;
- font-weight: bold;
- }
- .样式2 {color: #000000}
- .样式3 {color: #FF0000}
- -->
- </style></head>
- <body>
- <!--#include file="conn1.asp"-->
- <%
- if trim(request("ccc22"))="add" then %>
- <%
- set rs=server.createobject("adodb.recordset")
- sql="SELECT * from gg "
- rs.open sql,conn,1,3
- rs.addnew
- rs("gjie")=nnoo(request("gjie"))
- rs("gw")=nnoo(request("gw"))
- rs("gh")=nnoo(request("gh"))
- rs("gglei")=nnoo(request("gglei"))
- rs("ggri")=nnoo(request("ggri"))
- rs("ggok")=nnoo(request("ggok"))
- rs("ggjia")=nnoo(request("ggjia"))
- rs("ggimg")=request("ggimg")
- rs("ggurl")=request("ggurl")
- rs.update
- rs.close
- Response.Write "<script Language=Javascript>alert('添加完毕');location.href = 'addguuang.asp';</script>"
- response.end
- end if %><%
- if request("del")="ok" then
- conn.execute("delete from gg where ggid="&nnoo(request("id"))&"")
- Response.Write "<script Language=Javascript>alert('删除完毕');location.href = 'addguuang.asp';</script>"
- response.end
- end if %>
- <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
- <tr>
- <td colspan="3"> </td>
- </tr>
- <tr>
- <td width="18"> </td>
- <td>
- <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
- <tr>
- <td>
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td background="../images/back_3.gif" rowspan="2">
- <table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
- <tr>
- <td class="12v" >
- <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="96" width="100%">
- <tr>
- <td>
- <table class="border" width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
- <tr class="title">
- <td height="22" bgcolor="#FFFFFF" class="title"><div align="center" class="样式1">广告位添加</div></td>
- </tr>
- <tr>
- <td height="177" valign="top" class="tdbg"><div align="center"></div>
- <form name="form1" method="post" action="?ccc22=add">
- <table width="100%" border="0" cellspacing="0" cellpadding="0" height="164">
- <tr>
- <td rowspan="2"><div align="center">广告说明</div></td>
- <td width="73%" height="44">
- <input name="gjie" type="text" id="gjie" size="50"> </td>
- </tr>
- <tr> </tr>
- <tr>
- <td width="27%" height="52"><div align="center"></div></td>
- <td width="73%" height="52">长度 <input name="gw" type="text" id="gw" size="7">
- 宽度
- <input name="gh" type="text" id="gh" size="7">
- <br>
- 广告位置:
- <select name="gglei" id="gglei">
- <option value="0">首页广告</option>
- <option value="1">分类内广告</option>
- <option value="2">点播页广告</option>
- <option value="3">广告版点播页1</option>
- <option value="4">广告版点播页2</option>
- <option value="5">广告版点播页3</option>
- <option value="6">其他位置</option>
- </select></td>
- </tr>
- <tr>
- <td height="26"> </td>
- <td height="26"><input name="ggri" type="text" id="ggri" size="10">
- 租用日期/天
- <select name="ggok" id="ggok">
- <option value="1">暂未使用</option>
- <option value="0">已被租用</option>
- </select> <br> <input name="ggjia" type="text" id="ggjia" size="10">
- 价格/元 </td>
- </tr>
- <tr>
- <td height="26"> </td>
- <td height="26"><input type="Submit" name="Submit" value="确定" width="75" height="22"></td>
- </tr>
- </table>
- </form> </td>
- </tr>
- <tr>
- <td height="52" valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
- <tr>
- </tr>
- <tr class="title">
- <td width="18%" height="22">
- <div align="center" class="样式2"><strong>位置</strong></div></td>
- <td width="41%" height="22"><div align="center" class="样式2"><strong>说明</strong></div></td>
- <td width="11%" height="22"><div align="center" class="样式2"><strong>规格</strong></div></td>
- <td width="13%" height="22"><div align="center" class="样式2"><strong>到期时间</strong></div></td>
- <td width="8%" height="22"><div align="center" class="样式2"><strong>已租</strong></div></td>
- <td width="9%" height="22"><div align="center" class="样式2"><strong>元/月</strong></div></td>
- </tr>
- <%set rs= Server.CreateObject("adodb.recordset")
- sql="select * from gg order by gglei desc "
- rs.open sql,conn,1,3
- for ff=1 to int(rs.recordcount) %>
- <tr class="tdbg">
- <td> <div align="center">
- <%select case rs("gglei")
- case 0
- Response.Write("首页广告")
- case 1
- Response.Write("分类内广告")
- case 2
- Response.Write("商品详细内")
- case 3
- Response.Write("产品详细底")
- case 4
- Response.Write("首页广告底部")
- case else
- Response.Write("其他位置")
- end select %>
- <img src="images/delete.gif" alt="删除" width="12" height="12" border="0" onClick="if(confirm('您确定要删除吗?')){location='?id=<%=rs("ggid")%>&del=ok'}else{return(false)}" onMouseMove="this.style.cursor='hand'"> </div></td>
- <td height="30"><a href="addgg.asp?id=<%=rs("ggid")%>"><%=rs("gjie")%><font color="#990000"><修改></font></a></td>
- <td><div align="center"><%=rs("gw")%>X<%=rs("gh")%></div></td>
- <td>
- <div align="center">
- <%if rs("ggtime")+rs("ggri")<=date() then
- Response.Write("-------NO------")
- else
- Response.Write(""&rs("ggtime")+rs("ggri")&"")
- end if %>
- </div></td>
- <td> <div align="center">
- <% if rs("ggok")=1 then
- Response.Write("<font color=#FF0000><b>X</b></font>")
- else
- Response.Write("<b>√</b>")
- end if %>
- </div></td>
- <td><div align="center"><%=rs("ggjia")%></div></td>
- </tr>
- <% rs.movenext
- next %>
- </table> </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table></td>
- <td width="18" background="img/admin5.gif"> </td>
- </tr>
- </table>
- <br>
- </body>
- </html>