📄 main_list_customer.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->
<!--#include file="../script/trimFunction.asp"-->
<%
var rsCust = Server.CreateObject("ADODB.Recordset");
var strSQL;
var ds;
var strSearch;
var listCust = "all";
listCust = String(Request("listCust"));
ds = String(Request("ds"));
strSearch = trim_str(String(Request("txtSearch")));
if(listCust == 'active')
{
strSQL = "Select * From vwCust Where CDelete=1";
}
if(listCust == 'deactive')
{
strSQL = "Select * From vwCust Where CDelete=0";
}
if(listCust == 'all')
{
strSQL = "Select * From vwCust";
}
if(strSearch != "")
{
if(listCust == 'all')
{
strSQL+= " Where"
}
else
{
strSQL+= " AND"
}
if(ds == "email")
{
strSQL+= " CEmail Like N'%" + strSearch + "%' ";
}
if(ds == "name")
{
strSQL+= " CName Like N'%" + strSearch + "%' ";
}
}
rsCust.Open(strSQL,oConn,3,1);
rsCust.PageSize=10;
var totalPage=rsCust.PageCount;
var cid = Request.Form("chkProID");
if(Request.Form('update'))
{
var strSQL_update;
if(String(Request.Form('update')) == 'Kích hoạt')
{
strSQL_update = "Update tblCustomer Set CDelete = 1 Where CID IN (" + cid + ")";
oConn.Execute(strSQL_update);
Response.Redirect("admin_done.asp?mess=Tài khoản đã được kích hoạt!!!&gourl=main_List_Customer.asp?listCust=all|ds=|txtSearch=");
}
if(String(Request.Form('update')) == 'Ngừng kích hoạt')
{
strSQL_update = "Update tblCustomer Set CDelete = 0 Where CID IN (" + cid + ")";
oConn.Execute(strSQL_update);
Response.Redirect("admin_done.asp?mess=Tài khoản đã bị ngừng hoạt động!!!&gourl=main_List_Customer.asp?listCust=all|ds=|txtSearch=");
}
}
if(String(Request.Form('del')) == 'Xóa khách hàng')
{
var strSQL_del = "Delete From tblCustomer Where CID IN (" + cid + ")";
oConn.Execute(strSQL_del);
Response.Redirect("admin_done.asp?mess=Tài khoản đã được xóa!!!&gourl=main_List_Customer.asp?listCust=all|ds=|txtSearch=");
}
%>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>List Customer</title>
<script src="lib/checkAll.js"></script>
<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">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="frmlist" action="main_List_Customer.asp" method="post">
<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">DANH SÁCH KHÁCH HÀNG</font></strong>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="left" valign="bottom" style="padding-right:5px; padding-left:5px; " class="list">
<select name="listCust" size="1" onChange="change();">
<option value="all" <%if(String(Request('listCust')) == 'all'){%> selected<%}%>>Tất cả</option>
<option value="active" <%if(String(Request('listCust')) == 'active'){%> selected<%}%>>Kích hoạt</option>
<option value="deactive" <%if(String(Request('listCust')) == 'deactive'){%> selected<%}%>>Chưa kích hoạt</option>
</select>
</td>
</tr>
<tr>
<td align="right" valign="top" style="padding-right:5px; " class="list"> </td>
</tr>
<tr>
<td align="left" valign="top" style="padding-left:5px; " class="list">
<font face="arial, tahoma, verdana" size="2">Từ khóa tìm kiếm </font>
<input type="text" size="18" class="textbox" name="txtSearch" value="<%=strSearch%>">
<font face="arial, tahoma, verdana" size="2">Theo</font>
<select name="ds" size="1" class="textbox">
<option value="email" <%if(ds=='email'){%> selected <%}%>>Email</option>
<option value="name" <%if(ds=='name'){%> selected <%}%>>Tên</option>
</select>
<script language="jscript">
function callReset()
{
document.frmlist.txtSearch.value = "";
}
</script>
<input type="submit" name="btnSearch" value="Tìm kiếm">
<input type="button" name="btnReset" value="Xóa" onClick="callReset();">
<input type="hidden" name="hiddenField"></td>
</tr>
<tr>
<td align="right" valign="top" style="padding-right:5px; " class="list">>>Tổng số <strong><%=rsCust.RecordCount%></strong> thành viên</td>
</tr>
<%
var intCurrentPage;
var i;
if(isNaN(Request.QueryString("page")))
{
intCurrentPage = 1;
}
else
{
intCurrentPage = parseInt(Request.QueryString("page"));
}
if (totalPage > 0)
{
rsCust.AbsolutePage = parseInt(intCurrentPage);
}
else
{
intCurrentPage = 0;
}
i=1;
var n=1;
if(rsCust.RecordCount==0)
{
%>
<tr>
<td align="center" valign="middle" style="padding-right:5px; " class="list">
<%
Response.Write("<font size=3><strong>Không có khách hàng nào trong mục này!</strong></font>");
%>
</td>
</tr>
<%}
else
{
%>
<tr>
<td align="left" valign="top" style="padding-left:5px; padding-right:5px; ">
<table style=" border:1px solid; border-collapse:collapse" width="100%" border="1" bordercolor="#0066CC" cellspacing="0" cellpadding="2">
<tr align="center" valign="top">
<td width="5%"><font face="arial, tahoma, verdana" size="2"><strong>STT</strong></font></td>
<td width="26%"><strong><font face="arial, tahoma, verdana" size="2">Email</font></strong></td>
<td width="27%"><strong><font face="arial, tahoma, verdana" size="2">Mật khẩu</font></strong></td>
<td width="37%"><strong><font face="arial, tahoma, verdana" size="2">Tên khách hàng</font></strong></td>
<td width="5%"><input name="chkAll" type="checkbox" id="chkAll" value="checkbox" <%if((rsCust.BOF)&&(rsCust.EOF)){%> disabled <%}%> onClick="checkall();"></td>
</tr>
<%
var dem=1;
while((!rsCust.BOF)&&(!rsCust.EOF))
{
if((n%2)==0)
{
%>
<tr valign="middle" <%if(rsCust.Fields('CDelete') == 0){%> bgcolor="#E9E9E9" <%}%>>
<td align="center" class="list"><%=rsCust.PageSize * (intCurrentPage-1) + dem%></td>
<td align="left" class="list"><a title="Bam vao day de Gui email cho nguoi nay" href="javascript:openWin('admin_sendmail.asp?email=<%=rsCust.Fields("CEmail")%>','_sendmail','height=300,width=500,scrollbars=no,resizable=no')"><%=rsCust.Fields('CEmail')%></a></td>
<td align="left" class="list"><%=rsCust.Fields('CPass')%></td>
<td align="left" class="list"><a href="#" class="name" onClick="JavaScript:openPopup('popup_Customer.asp?cid=<%=rsCust.Fields('CID')%>');"><%=rsCust.Fields('CName')%></a></td>
<td align="center" class="list"><input name="chkProID" type="checkbox" value="<%=rsCust.Fields("CID")%>" onClick="docheckone();"></td>
</tr>
<%
} else {
%>
<tr valign="middle" bgcolor="<%if(rsCust.Fields('CDelete') == 0){Response.Write('#E9E9E9');}else{Response.Write('#FFEFBF');}%>">
<td align="center" class="list"><%=rsCust.PageSize * (intCurrentPage-1) + dem%></td>
<td align="left" valign="middle" class="list"><a title="Bam vao day de Gui email cho nguoi nay" href="javascript:openWin('admin_sendmail.asp?email=<%=rsCust.Fields("CEmail")%>','_sendmail','height=300,width=500,scrollbars=no,resizable=no')"><%=rsCust.Fields('CEmail')%></a></td>
<td align="left" class="list"><%=rsCust.Fields('CPass')%></td>
<td align="left" class="list"><a href="#" class="name" onClick="JavaScript:openPopup('popup_Customer.asp?cid=<%=rsCust.Fields('CID')%>');"><%=rsCust.Fields('CName')%></a></td>
<td align="center" class="list"><input name="chkProID" type="checkbox" value="<%=rsCust.Fields("CID")%>" onClick="docheckone();"></td>
</tr>
<%
}
if(i==rsCust.PageSize)
{
break;
}
i++;
n++;
dem++;
rsCust.MoveNext();
}
}
%>
</table></td>
</tr>
<tr>
<td align="right" valign="bottom" style="padding-right:3px; padding-bottom:5px; padding-top:5px; "><div align="right"> <input type="submit" name="del" value="Xóa khách hàng" onClick="return checkInput(this);" <%if((rsCust.BOF)&&(rsCust.EOF)){%> disabled <%}%>>
<input name="update" type="submit" value="<%if((listCust=='active')||(listCust=='all')){Response.Write('Ngừng kích hoạt');}else{Response.Write('Kích hoạt');}%>" <%if((rsCust.BOF)&&(rsCust.EOF)){%> disabled <%}%> onClick="return checkInput(this);">
</div></td>
</tr>
<%
if (rsCust.PageCount > 1){
%>
<tr>
<td align="center" valign="top">
<%
var intCount;
if(intCurrentPage>1)
Response.Write("<a href=?page=" + (intCurrentPage-1) + "&listCust=" + String(Request('listCust')) + "&txtSearch=" + String(Request('txtSearch')) + "&ds=" + String(Request('ds')) + ">Trước</a>" + " |");
else
Response.Write("<font color='#999999' size='2'>Trước</font> |");
for(intCount = 1;intCount<=rsCust.PageCount;intCount++)
{
if (intCount == intCurrentPage)
Response.Write("<font color='#DD0000' size='2'>" + " " + intCount + "</font>" + " | ");
else{
Response.Write("<a href=?page=" + intCount + "&listCust=" + String(Request('listCust')) + "&txtSearch=" + String(Request('txtSearch')) + "&ds=" + String(Request('ds')) + ">" + " " + intCount + "</a> " + " | ");
}
}
if(intCurrentPage!=rsCust.PageCount)
Response.Write("<a href=?page=" + (intCurrentPage+1) + "&listCust=" + String(Request('listCust')) + "&txtSearch=" + String(Request('txtSearch')) + "&ds=" + String(Request('ds')) + ">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%> / <%=rsCust.PageCount%></font>
</td>
</tr>
<%
}
rsCust.Close();
oConn.Close();
%>
</table></td>
</tr>
</form>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -