📄 content.asp
字号:
<!--#include file="../../include/db.asp"-->
<!--#include file="../../include/admin_check.asp"-->
<!--#INCLUDE FILE="../DATAFORM.ASP"-->
<!--#INCLUDE FILE="../../include/table.inc"-->
<!--#INCLUDE FILE="power.ASP"-->
<%
Set conn = OpenOrGet_Database("sql_conn")
'函数 checkAdmin ,判断 checkStr 是否包含在 adminStr 中
function checkAdmin(checkStr,adminStr)
if adminStr="" or isnull(adminStr) then
checkAdmin=false
else
if instr(adminStr,"/"&checkStr&"/")<>0 then
checkAdmin=true
else
checkAdmin=false
end if
end if
end function
'得到项目列表
sql="select number,name,id from item_type where number='"&trim(request("type"))&"'"
Set ItemRs=Open_rs(conn,sql)
'执行查询操作
if trim(request("act"))="search" then
session("yc_content")=""
selectsql="select id,title,user_name,date,type_id from content where 1=1"
if trim(request("title"))<>"" then
selectsql=selectsql&" and title like '%"&transValue(trim(request("title")))&"%'"
end if
if trim(request("user_name"))<>"" then
selectsql=selectsql&" and user_name like '%"&transValue(trim(request("user_name")))&"%'"
end if
if trim(request("type"))<>"" and trim(request("type"))<>"0" then
selectsql=selectsql&" and type_id='"&trim(request("type"))&"'"
end if
if trim(request("mydate"))="" then
mydate=now
else
mydate=cdate(trim(request("mydate")))
end if
if mydate<>"" then
if trim(request("select_date"))="myAfter" then
selectsql=selectsql&" and date>='"&mydate&"' order by date desc"
else
selectsql=selectsql&" and date<='"&mydate&"' order by date desc"
end if
end if
end if
if trim(request("myjoke"))="1" then session("yc_content")=""
if selectsql="" then
selectsql="select id,title,user_name,date,type_id from content order by date desc"
end if
set Rs=OpenOrGet_RsAndPageSize(conn,selectsql,"yc_content",10)
'response.end
if isnull(session("yc_content")) then
myEmpty=true
end if
id=trim(request("select_del"))
if trim(request("myjoke"))<>"1" and id<>"" then
Actiondel "content","id","content","title" '删除操作
rs.requery
end if
if isobject(rs) then
Page = CLng(Request("Page"))
If Page < 1 Then Page = 1
If Page > Rs.PageCount Then Page = Rs.PageCount
end if
'response.write rs.recordcount
'response.end
%>
<html>
<head>
<title>深圳育才一小欢迎您！</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="/include/page.css" type="text/css">
<LINK href="/Include/DatePicker.css" rel=stylesheet type=text/css>
<SCRIPT language=javascript src="/include/DateObject.js"></SCRIPT>
<SCRIPT language=javascript src="/include/DatePicker.js"></SCRIPT>
<SCRIPT language=javascript src="/include/editlib.js"></SCRIPT>
</head>
<body >
<table width="1" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="753" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><!--#include file="../../include/admin_banner.inc"--></td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1%"> </td>
<td width="99%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="td1"> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="21%" valign="top"><!--#include file="../../include/admin_left.inc"--></td>
<td width="2%" valign="top"> </td>
<td width="77%" height=1 valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td background="/images/middle/m-bg.gif" width="70"><img src="/images/wzgl.gif"></td>
<td background="/images/middle/m-bg.gif" align="right"><img src="/images/middle/pacer1.gif" width="3" height="38"></td>
<td background="/images/middle/m-bg.gif" align="right" valign="middle" width="16"><a href=# onClick="more()"><img src="/images/middle/more.gif" width="16" height="16" border=0 alt="更多"></a></td>
<td background="/images/middle/m-bg.gif" align="right" width="8"><img src="/images/middle/pacer.gif" width="8" height="38"></td>
<td background="/images/middle/m-bg.gif" align="right" valign="middle" width="16"><a href=# onClick="help()"><img src="/images/middle/help.gif" width="16" height="16" border=0 alt="栏目帮助"></a></td>
<td width="6" align="right"><img src="/images/middle/M-r.gif" width="16" height="38"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="bg-left" width="6"><img src="/images/left/l-l.gif" border=0></td>
<td class="newsborder" width="100%" >
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td height="200" valign="top">
<div align="center"><form name=search method=post action="content.asp?act=search"><table width=95% border=0 cellspacing=0 cellpadding=1 bgcolor="#999999">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#F5F5F5">
<tr>
<td class=ttTable width="60" height="35" nowrap> 题目：</td>
<td width="90">
<input class=edline maxlength=30
name=title style="HEIGHT: 22px; WIDTH: 80px" value="" size="30">
</td>
<td width="70" class=ttTable>发布人：</td>
<td width="110" class=ttTable>
<input class=edline maxlength=30
name=user_name style="HEIGHT: 22px; WIDTH: 80px" value="" size="30">
</td>
<td class=ttTable width="70">项目名：</td>
<td width="120">
<% response.write itemRs("name") %><input type=hidden name="type" value="<%=trim(request("type"))%>">
</td>
<td class=ttTable>
</td>
</tr>
<tr>
<td class=ttTable width="60" height="35" nowrap> 时间：</td>
<td colspan="2">
<%
yy=0
mm=0
dd=0
%>
<script language=javascript>
if (<%=yy%>>1900)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -