?? admin_hw.asp
字號:
<!--#include file="inc/Conn.asp" -->
<!--#include file="Admin_IsLogin.asp" --><%
if request("action")="sh" then
Response.write("<script>alert(""信息審核成功！"");location.href=""Admin_hw.asp"";</script>")
Response.end
end if
if request("action")="sh1" then
conn.execute("Update hw set sh=0 where id = ("&request("id")&")")
Response.write("<script>alert(""信息已被鎖定！"");location.href=""Admin_hw.asp"";</script>")
Response.end
end if
if request("action")="tj" then
conn.execute("Update hw set tj=1 where id = ("&request("id")&")")
Response.write("<script>alert(""信息推薦成功！"");location.href=""Admin_hw.asp"";</script>")
Response.end
end if
if request("action")="tj1" then
conn.execute("Update hw set tj=0 where id = ("&request("id")&")")
Response.write("<script>alert(""信息已被取消推薦！"");location.href=""Admin_hw.asp"";</script>")
Response.end
end if
if request("action")="alldel" then
rcID=trim(request("rcID"))
if instr(rcID,",")>0 then
dim idarr,i
idArr=split(rcID)
for i = 0 to ubound(idArr)
call DelArticle(clng(idarr(i)))
next
else
call DelArticle(clng(rcID))
end if
sub DelArticle(ID)
sqlDel="select * from hw where id=" & CLng(ID)
Set rsDel= Server.CreateObject("ADODB.Recordset")
rsDel.open sqlDel,conn,1,3
rsDel.delete
rsDel.update
set rsDel=nothing
end sub
Response.Write "信息刪除成功..."
Response.write("<script>alert(""信息刪除成功！"");location.href=""Admin_hw.asp"";</script>")
Response.end
end if
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Images/Style.css" rel="stylesheet" type="text/css">
<SCRIPT language=javascript>
function unselectall()
{
if(document.del.chkAll.checked){
document.del.chkAll.checked = document.del.chkAll.checked&0;
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.Name != "chkAll")
e.checked = form.chkAll.checked;
}
}
function ConfirmDel()
{
if(confirm("確定要刪除選中的信息嗎？一旦刪除將不能恢復(fù)！"))
return true;
else
return false;
}
</SCRIPT>
</head>
<BODY bgcolor="D6DFF7" leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="50%" height="13">·貨物信息管理</td>
<form method="post" action="?" name="Form1">
<td width="50%" height="13" align="right">信息搜索：<input type="text" name="KeyWord" size="20" value="<% = Request("KeyWord")%>" class="face"> <input type="submit" name="Submit" value="搜" class="button"></td>
</form>
</tr>
</table>
<div align="center">
<table class=tableBorder width="98%" border=0 cellpadding=5 cellspacing=1>
<tbody>
<tr>
<th height=21 sytle="line-height:150%" width="33">選擇</th>
<th height=21 width="383">標(biāo)題</th>
<th height=21 width="215">貨物名</th>
<th height=21 width="44">狀態(tài)</th>
<th height=21 width="55">推薦</th>
<th height=21 width="118">添加時間</th>
<th height=21 width="33">修改</th>
</tr><%
Dim rdsInfo '/通告的數(shù)據(jù)庫對象及SQL語句/
Dim sqlInfo
Dim rdsTotalRec
Dim strKeyWord '/關(guān)鍵字/
Dim intPage '/當(dāng)前頁/
Dim intTotalRec '/所有記錄/
Dim intInfoCot '/通告條數(shù)/
Dim intInfoCount
Dim n,p,ii '/定義一些臨時變量/
Dim strState
strKeyWord = Request("KeyWord")
sh=Request("sh")
intPage = Trim(Request("Page"))
if intPage = "" then
intPage = 1
else
intPage = Clng(intPage)
end if
intInfoCot =20
strsql=""
if sh<>"" then
sh=cint(sh)
strsql=strsql&"and sh="&sh&""
end if
if strKeyWord <> "" then
strsql=strsql&" and (title like '%"&strKeyWord&"%' or hwname like '%"&strKeyWord&"%' or bz like '%"&strKeyWord&"%')"
end if
set rdsInfo = Server.CreateObject("ADODB.Recordset")
set rdsTotalRec = Conn.Execute("Select Count(id) from hw Where title<>'' "&strsql&"")
intTotalRec = rdsTotalRec(0)
sqlInfo = "Select * from hw Where title<>'' "&strsql&" Order By id Desc"
rdsInfo.Open sqlInfo,Conn,1,1
if not rdsInfo.EOF then
if intTotalRec mod intInfoCot = 0 then
n = intTotalRec \ intInfoCot
else
n = intTotalRec \ intInfoCot + 1
end if
rdsInfo.MoveFirst
if intPage > n then intPage = n
if intPage < 1 then intPage = 1
rdsInfo.Move (intPage - 1) * intInfoCot
do while not rdsInfo.EOF and intInfoCount < Clng(intInfoCot)
intInfoCount = intInfoCount + 1
%>
<form name="del" method="Post" action="?action=alldel" onsubmit="return ConfirmDel();">
<tr>
<td class=forumRow height=21 sytle="line-height:150%">
<p align="center"><input name='rcID' type='checkbox' onclick="unselectall()" id="rcID" value='<% = rdsInfo("id")%>'></td>
<td class=forumRow height=21 sytle="line-height:150%" align="center"><a href="../showhw.asp?id=<% = rdsInfo("id")%>"><% = rdsInfo("title")%></a></td>
<td class=forumRow height=21 sytle="line-height:150%" align="center"><% = rdsInfo("hwname")%></td>
<td class=forumRow height=21 sytle="line-height:150%" align="center"><% if rdsInfo("sh")<>"1" then%>
<a href='Admin_hw.asp?action=sh&id=<% = rdsInfo("id")%>' onclick="{if(confirm('確定審核此信息嗎?')){return true;}return false;}"><font color="#428EFF">鎖定</font></a>
<%else%>
<a href='Admin_hw.asp?action=sh1&id=<% = rdsInfo("id")%>' onclick="{if(confirm('確定取消審核嗎?')){return true;}return false;}"><font color="#ff0000">開通</font></a>
<%end if%></td>
<td class=forumRow height=21 sytle="line-height:150%" align="center"><% if rdsInfo("tj")<>"1" then%>
<a href='Admin_hw.asp?action=tj&id=<% = rdsInfo("id")%>' onclick="{if(confirm('確定把此信息設(shè)為推薦嗎?')){return true;}return false;}"><font color="#428EFF">否</font></a>
<%else%>
<a href='Admin_hw.asp?action=tj1&id=<% = rdsInfo("id")%>' onclick="{if(confirm('確定取消對此信息的推薦嗎?')){return true;}return false;}"><font color="#ff0000">是</font></a>
<%end if%></td>
<td class=forumRow height=21 sytle="line-height:150%" align="center"><% = rdsInfo("time")%></td>
<td class=forumRow height=21 sytle="line-height:150%" align="center">
<a href="mod_hw.asp?id=<% = rdsInfo("id")%>">修改</a></td></tr><%
rdsInfo.MoveNext
loop
else
Response.Write "<tr><td colspan=""7"" class=""forumRow""> <font color=""#FF0000"">沒有符合條件的信息...</font></td></tr>"
end if
rdsInfo.Close
set rdsInfo = nothing
if intPage - 1 mod 10 = 0 then
p = (intPage - 1) \ 10
else
p = (intPage - 1) \ 10
end if
%>
<tr>
<td class=forumRow colspan="7"><input name="chkAll" type="checkbox" id="chkAll" onclick=CheckAll(this.form) value="checkbox">
選中本頁顯示的所有記錄<input name="submit" type='submit' value='刪除選定的信息'></td>
</tr>
<tr>
<td class=forumRow colspan="7"><table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<form method="post" action="InfoEaa.asp" name="Form2">
<input type="hidden" name="KeyWord" value="<% = strKeyWord%>">
<input type="hidden" name="strfcclass" value="<% = strfcclass%>">
<input type="hidden" name="sh" value="<% =sh%>">
<input type="hidden" name="class" value="<% =strclass%>">
<tr>
<td width="30%" height="30" valign="middle">頁次：<b><%= intPage %></b>/<b><%= n %></b>頁 每頁<b><%= intInfoCot %></b>條 共<b><%= intTotalRec %></b>條</td>
<td width="70%" height="30" valign="middle"><div align="right">分頁：
<%
if intPage = 1 then
Response.Write "<font face=webdings>9</font> "
else
Response.Write "<a href='?Page=1&KeyWord="& strKeyWord &"&strfcclass="& strfcclass &"&sh="&sh&"&class="&strclass&"' title=首頁><font face=webdings>9</font></a> "
end if
if p * 10 > 0 then Response.Write "<a href='?Page="&Cstr(p*10)&"&sh="&sh&"&class="&strclass&"&KeyWord="& strKeyWord &"&strfcclass="& strfcclass &"' title=上十頁><font face=webdings>7</font></a> "
Response.Write "<b>"
for ii = p * 10 + 1 to P * 10 + 10
if ii = intPage then
Response.Write "<font color=""#FF0000"">"+Cstr(ii)+"</font> "
else
Response.Write "<a href='?Page="&Cstr(ii)&"&sh="&sh&"&class="&strclass&"&KeyWord="& strKeyWord &"&strfcclass="& strfcclass &"'>"+Cstr(ii)+"</a> "
end if
if ii = n then exit for
next
Response.Write "</b>"
if ii < n then Response.Write "<a href='?Page="&Cstr(ii)&"&sh="&sh&"&class="&strclass&"&KeyWord="& strKeyWord &"&strfcclass="& strfcclass &"' title=下十頁><font face=webdings>8</font></a> "
if intPage=n then
Response.Write "<font face=webdings>:</font> "
else
Response.Write "<a href='?Page="&Cstr(n)&"&sh="&sh&"&class="&strclass&"&KeyWord="& strKeyWord &"&strfcclass="& strfcclass &"' title=尾頁><font face=webdings>:</font></a> "
end if
%>
</div></td>
</tr>
</form>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
<!--#include file="end.asp"-->
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -