📄 main_list_new.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/convertDate.asp"-->
<%
if(Request.Form("delSome")=="Xóa tin tức")
{
var id = Request.Form("chkProID");
var strSQL_del = "Delete From tblNews Where NID In(" + id + ")";
oConn.Execute(strSQL_del);
}
var today = new Date();
maxYear = today.getYear();
var newDay = String(Request('day'));
if(newDay=='undefined'){newDay='';}
var newMonth = String(Request('month'));
if(newMonth=='undefined'){newMonth='';}
var newYear = String(Request('year'));
if(newYear=='undefined'){newYear='';}
var strSQL = "SELECT NID, NTitle, NQ_view, NImage, NDate FROM vwNews ";
if((newDay!="")&&(newMonth=="")&&(newYear==""))
{
strSQL+= " Where Day(NDate)='" + newDay + "'";
}
if((newDay=="")&&(newMonth!="")&&(newYear==""))
{
strSQL+= " Where Month(NDate)='" + newMonth + "'";
}
if((newDay=="")&&(newMonth=="")&&(newYear!=""))
{
strSQL+= " Where Year(NDate)='" + newYear + "'";
}
if((newDay!="")&&(newMonth!="")&&(newYear==""))
{
strSQL+= " Where Day(NDate)='" + newDay + "' AND Month(NDate)='" + newMonth + "'";
}
if((newDay=="")&&(newMonth!="")&&(newYear!=""))
{
strSQL+= " Where Month(NDate)='" + newMonth + "' AND Year(NDate)='" + newYear + "'";
}
if((newDay!="")&&(newMonth=="")&&(newYear!=""))
{
strSQL+= " Where Day(NDate)='" + newDay + "' AND Year(NDate)='" + newYear + "'";
}
if((newDay!="")&&(newMonth!="")&&(newYear!=""))
{
strSQL+= " Where Day(NDate)='" + newDay + "' AND Month(NDate)='" + newMonth + "' AND Year(NDate)='" + newYear + "'";
}
//Response.Write(strSQL);Response.End();
strSQL = strSQL + " Order By NDate Desc, NID Desc";
var rsN=Server.CreateObject("ADODB.Recordset");
rsN.Open(strSQL,oConn,3,1);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>List News</title>
<script src="lib/checkAll.js"></script>
</head>
<body topmargin="0" rightmargin="0" leftmargin="0" bottommargin="0">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" background="images/menu_left_bg.gif">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="160" background="images/menu_left_bg.gif" style="background-repeat:repeat "><!--#include file="lib/inc_menuleft.asp"--></td>
<td align="left" valign="top" bgcolor="#FFFFFF">
<form name="frmlist" action="" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top" bgcolor="#004182" style="padding-top:5px; padding-bottom:10px; "> <strong><font color="#FFFFFF" face="arial, tahoma, verdana"; size="5">CÁC TIN ĐÃ ĐƯA</font></strong> </td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="middle">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8"></td>
<td width="67%" height="8"></td>
</tr>
<tr>
<td width="33%" height="24" align="right" valign="bottom"><font face="arial, tahoma, verdana"> <strong>..:: Xem tin ngày</strong> </font></td>
<td style="padding-left:10px; " valign="middle"><select name="day" size="1" class="textbox">
<option value="">DAY</option>
<%
var iDay;
for(iDay=1;iDay<=31;iDay++)
{
%>
<option value="<%=iDay%>" <%if(parseInt(newDay)==iDay){%> selected <%}%>><%if(iDay>=10){Response.Write(iDay);}else{Response.Write('0'+iDay);}%></option>
<%}%>
</select>
<strong> tháng</strong>
<select name="month" size="1" class="textbox">
<option value="">MONTH</option>
<%
var iMonth;
for(iMonth=1;iMonth<=12;iMonth++)
{
%>
<option value="<%=iMonth%>" <%if(parseInt(newMonth)==iMonth){%> selected <%}%>><%if(iMonth>=10){Response.Write(iMonth);}else{Response.Write('0'+iMonth);}%></option>
<%}%>
</select>
<strong> năm</strong>
<select name="year" class="textbox">
<option value="">YEAR</option>
<%
var iYear;
for(iYear=2001;iYear<=maxYear;iYear++)
{
%>
<option value="<%=iYear%>" <%if(parseInt(newYear)==iYear){%> selected <%}%>><%=iYear%></option>
<%}%>
</select>
<input type="submit" name="submit" value=" XEM "><input type="hidden"><input type="hidden">
<input type="hidden">
</td>
</tr>
</table></td>
</tr>
<tr>
<td style="padding-left:5px; padding-right:5px; "><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right" valign="top" style="padding-top:5px; " class="list">>> Có <%=rsN.RecordCount%> tin tức trong CSDL </td>
</tr>
<tr>
<td align="left" valign="top">
<%
var intCurrentPage;
var i,j;
if (isNaN(Request.QueryString("page")))
{
intCurrentPage = 1;
}
else
{
intCurrentPage = parseInt(Request.QueryString("page"));
}
rsN.PageSize = 6;
if (rsN.PageCount > 0)
{
rsN.AbsolutePage = parseInt(intCurrentPage);
}
else
{
intCurrentPage = 0;
}
i=1;
var n=1;
if(rsN.RecordCount==0)
{
%>
</td>
</tr>
<tr>
<td>
<div align="center" class="navlink"> </div></td>
</tr>
<tr>
<td align="center" valign="middle" style="padding-top:5px; " class="list">
<%
Response.Write("<font size=3><strong>Không có tin nào trong thời gian này!</strong></font>");
%>
</td>
</tr>
<%}
else
{
%>
</table></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top" style="padding-left:3px; padding-right:3px; ">
<table style=" border:1px solid; border-collapse:collapse" width="100%" border="1" bordercolor="#0066CC" cellspacing="0" cellpadding="2">
<tr valign="top" bgcolor="#FCFCFC">
<td width="230" align="center"><strong>Tiêu đề</strong></td>
<td width="405" align="center"><strong>Trích</strong></td>
<td width="94" align="center"><strong>Ngày đăng</strong></td>
<td width="29" align="center"><input name="chkAll" <%if((rsN.BOF)&&(rsN.EOF)){%> disabled <%}%> type="checkbox" id="chkAll" value="checkbox" onClick="checkall();"></td>
<td width="36" align="center"><strong>Sửa</strong></td>
</tr>
<%
while((!rsN.BOF)&&(!rsN.EOF))
{
if((n%2)==0)
{ %>
<tr bgcolor="#FFFFFF">
<td width="230" align="left" valign="middle"><% = rsN.Fields("NTitle")%>
</td>
<td width="405" align="left" valign="middle" class="list"><% = rsN.Fields("NQ_view")%>
<a href="#" onClick="JavaScript:openPopup('popup_NewsDetail.asp?NID=<%=rsN.Fields('NID')%>');" class="chi tiet"><font size="-2" color="#FF0000">Chi tiết</font></a> </td>
<td align="center" valign="middle" class="list"><div align="center">
<% Response.Write(convertDate(rsN.Fields("NDate")));%>
</div></td>
<td align="center" valign="middle" class="list"><input name="chkProID" type="checkbox" value="'<%=rsN.Fields("NID")%>'" onClick="docheckone();"></td>
<td align="center" valign="middle" class="list"><a href="main_Edit_New.asp?NID=<% = rsN.Fields("NID")%>&page=<%=Request('page')%>&new_day=<%= Request('new_day')%>&new_month=<%= Request('new_month')%>&new_year=<%= Request('new_year')%>" class="command"><img border="0" src="images/icon_edit.gif" width="15" height="15"></a></td>
</tr>
<%} else {%>
<tr bgcolor="#FFEFBF">
<td width="230" align="left" valign="middle"><% = rsN.Fields("NTitle")%>
</td>
<td width="405" align="left" valign="middle"class="list"><% = rsN.Fields("NQ_view")%>
<a href="#" onClick="JavaScript:openPopup('popup_NewsDetail.asp?NID=<%=rsN.Fields('NID')%>');" class="chi tiet"><font size="-2" color="#FF0000">Chi tiết</font></a></td>
<td align="center" valign="middle"class="list"><div align="center">
<%Response.Write(convertDate(rsN.Fields("NDate")));%>
</div></td>
<td align="center" valign="middle"class="list"><input name="chkProID" type="checkbox" value="'<%=rsN.Fields("NID")%>'" onClick="docheckone();"></td>
<td align="center" valign="middle" class="list"><a href="main_Edit_New.asp?NID=<% = rsN.Fields("NID")%>&page=<%=Request('page')%>&new_day=<%= Request('new_day')%>&new_month=<%= Request('new_month')%>&new_year=<%= Request('new_year')%>" class="command"><img border="0" src="images/icon_edit.gif" width="15" height="15"></a></td>
</tr>
<%
}
if(i==rsN.PageSize)
{
break;
}
i++;
n++;
rsN.MoveNext();
}
%>
</table></td>
</tr>
<tr>
<td align="right" valign="middle" style="padding-bottom:4px; padding-top:4px; "><input title="Xóa tin tức" name="delSome" type="submit" value="Xóa tin tức" <%if ((rsN.EOF)&&(rsN.BOF)){%> disabled <%}%> onClick="return checkInput(this);"></td>
</tr>
<tr>
<td align="center" valign="top">
<%
if (rsN.PageCount > 1){
%>
<tr>
<td align="center" valign="bottom">
<%
var intCount;
if(intCurrentPage>1)
Response.Write("<a href=?page=" + (intCurrentPage-1) + "&new_day=" + Request('new_day') + "&new_month=" + Request('new_month') + "&new_year=" + Request('new_year') +">Trước</a>" + " |");
else
Response.Write("<font color='#999999' size='2'>Trước</font> |");
for(intCount = 1;intCount<=rsN.PageCount;intCount++)
{
if (intCount == intCurrentPage)
Response.Write("<font color='#DD0000' size='2'>" + " " + intCount + "</font>" + " | ");
else{
Response.Write("<a href=?page=" + intCount + "&new_day=" + Request('new_day') + "&new_month=" + Request('new_month') + "&new_year=" + Request('new_year') + ">" + " " + intCount + "</a> " + " | ");
}
}
if(intCurrentPage!=rsN.PageCount)
Response.Write("<a href=?page=" + (intCurrentPage+1) + "&new_day=" + Request('new_day') + "&new_month=" + Request('new_month') + "&new_year=" + Request('new_year') + ">Sau</a>");
else
Response.Write(" <font color='#999999' size='2'>Sau</font>");
%>
</td>
</tr>
<tr>
<td align="center" valign="top"> <font color="darkblue" face="arial, tahoma, verdana" size="2">Trang <%=intCurrentPage%> / <%=rsN.PageCount%></font> </td>
</tr>
<%
}
}rsN.Close();
oConn.Close();
%>
</table></td>
</tr>
</table>
</form>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -