⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 main_list_admin.asp

📁 Computer SHOP+DATABASE
💻 ASP
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="admin_common.asp"-->

<%
		var rsA = Server.CreateObject("ADODB.Recordset");
		var strSQL;
		var list;
		list = String(Request("list"));
		if(list == '')
		{
			list = 'all';
		}
		
		if(list == 'active')
		{
			strSQL = "Select * From vwAdmin Where ADelete=1";
		}
		if(list == 'deactive')
		{
			strSQL = "Select * From vwAdmin Where ADelete=0";
		}
		if(list == 'all')
		{
			strSQL = "Select * From vwAdmin";
		}
		rsA.Open(strSQL,oConn,3,1);
		var aid = Request.Form("chkProID");

		if(Request.Form('update'))
		{
			var strSQL_update;
			if(String(Request.Form('update')) == 'Kích hoạt')
			{		
				strSQL_update = "Update tblAdmin Set ADelete = 1 Where AID IN (" + aid + ")"; 
				oConn.Execute(strSQL_update);
				Response.Redirect("admin_done.asp?mess=Tài khoản đã được kích hoạt!!!&gourl=main_List_Admin.asp?list=all");
			}
			if(String(Request.Form('update')) == 'Ngừng kích hoạt')
			{
				strSQL_update = "Update tblAdmin Set ADelete = 0 Where AID IN (" + aid + ")"; 
				oConn.Execute(strSQL_update);
				Response.Redirect("admin_done.asp?mess=Tài khoản đã bị ngưng kích hoạt!!!&gourl=main_List_Admin.asp?list=all");
			}
		}			
		if(String(Request.Form('del')) == 'Xóa Admin')
		{
			var strSQL_del = "Delete From tblAdmin Where AID IN (" + aid + ")";
			oConn.Execute(strSQL_del);
			Response.Redirect("admin_done.asp?mess=Tài khoản đã được xóa!!!&gourl=main_List_Admin.asp?list=all");
		}
%>

<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>List Admin</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_Admin.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">BAN QUẢN TRỊ</font></strong>
			</td>
      </tr>
      <tr>
        <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td align="left" valign="top" style="padding-top:15; padding-bottom:10; padding-left:5px; ">
			<select name="list" size="1" onChange="change();">
				<option value="all" <%if(String(Request('list')) == 'all'){%> selected<%}%>>Tất cả</option>
				<option value="active" <%if(String(Request('list')) == 'active'){%> selected<%}%>>Kích hoạt</option>
				<option value="deactive" <%if(String(Request('list')) == 'deactive'){%> selected<%}%>>Chưa kích hoạt</option>
			</select>
			<input type="hidden" name="hiddenField"><input type="hidden" name="hiddenField"><input type="hidden" name="hiddenField"><input type="hidden" name="hiddenField">
			</td>
          </tr>
        </table></td>
      </tr>
      
      <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="4">
          <tr align="center" valign="top" bgcolor="#FFE8C6">
            <td width="5%"><strong><font face="arial, tahoma, verdana" size="2">STT</font></strong></td>
            <td width="29%"><strong><font face="arial, tahoma, verdana" size="2">Tên đăng nhập</font></strong></td>
            <td width="51%"><strong><font face="arial, tahoma, verdana" size="2">Mật khẩu</font></strong></td>
            <td width="5%"><input name="chkAll" type="checkbox" <%if((rsA.BOF)&&(rsA.EOF)){%> disabled <%}%> id="chkAll" value="checkbox" onClick="checkall();"></td>
            <td width="10%"><strong><font face="arial, tahoma, verdana" size="2">Sửa</font></strong></td>
            </tr>
		<%
			var i=1;
			while((!rsA.BOF)&&(!rsA.EOF))
			{
		%>
          <tr valign="middle" <%if(rsA.Fields('ADelete') == 0){%> bgcolor="#E9E9E9" <%}%>>
            <td height="30" align="center" class="list"><%=i%></td>
            <td height="30" align="left" class="list"><%=rsA.Fields('ALogin')%></td>
            <td align="left" class="list"><%=rsA.Fields('APass')%></td>
            <td align="center" class="list"><input name="chkProID" type="checkbox" value="<%=rsA.Fields("AID")%>" onClick="docheckone();"></td>
            <td align="center"><a title="Sửa Admin" href="main_Create_Admin.asp?type=edit&aid=<%=rsA.Fields('AID')%>" class="command"><img src="../images/icon_edit.gif" border="0"></a></td>
            </tr>
		<%i++;rsA.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="button" name="btnCreate" value="Thêm Admin" onClick="javascript:document.location.href='main_Create_Admin.asp?type=create'">
		  &nbsp;&nbsp;<input type="submit" name="del" value="Xóa Admin" onClick="return checkInput(this);" <%if((rsA.BOF)&&(rsA.EOF)){%> disabled <%}%>>
		  &nbsp;&nbsp;<input name="update" type="submit" value="<%if((String(Request('list'))=='active')||(String(Request('list'))=='all')){Response.Write('Ngừng kích hoạt');}else{Response.Write('Kích hoạt');}%>" <%if((rsA.BOF)&&(rsA.EOF)){%> disabled <%}%> onClick="return checkInput(this);">
		  </div>
		  </td>
      </tr>
      
    </table></td>
  </tr>
  </form>
</table>
		  </td>
        </tr>
      </table></td>
    </tr>
  </table>
</div>
</body>
</html>
<%rsA.Close();oConn.Close();%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -