📄 sortadmin.asp

📁 这是一个物流网站的源代码
💻 ASP
字号:
<!--#include file="../inc/Config.asp"-->
<!--#include file="../inc/CheckAdmin.asp"-->
<!--#include file="../inc/Conn.asp"-->
<!--#include file="../inc/tree.asp"-->
<% 
Dim Language
Language=formatStr(Request("Language"))
table_behind="CompanySort_"
table=Get_Table(table_behind,Language)   
if table="None" then
   table=table_behind&"C"
   Language="C"  
end if 

if instr(table,"Product") then
   prefix="PS_"
elseif instr(table,"CompanySort_") then
   prefix="NS_"
elseif instr(table,"Download") then
   prefix="DS_"     
elseif instr(table,"Picture") then
   prefix="TS_"
end if 
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<link href="../Css_Main.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {color: #FF0000}
.style1 {color: #CCCCCC}
.STYLE4 {color: #FF0000; font-weight: bold; }
-->
</style>
<script language="javascript">
	function sltAll()
{
	var nn = self.document.all.item("id");
	for(j=0;j<nn.length;j++)
	{
		self.document.all.item("id",j).checked = true;
	}
}

	function sltNull()
{
	var nn = self.document.all.item("id");
	for(j=0;j<nn.length;j++)
	{
		self.document.all.item("id",j).checked = false;
	}
}

</script>
<body>
<table width="98%"  border="0" align="center" cellpadding="0" cellspacing="1" class="border">
  <tr>
    <td class="title_dh"><div align="center">企业管理——分类管理</div></td>
  </tr>
  <tr>
    <td class="tdbg"><!--#include file="../inc/Language_Radio.asp"--></td>
  </tr>
</table>
<table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="20" align="center"><span class="STYLE4">注意：</span>您无法删除类别，但是您可以选择要在前台显示的类别(默认未选中)。</td>
  </tr>
</table><form name="form1" method="post" action="">
<table width="99%"  border="0" align="center" cellpadding="0" cellspacing="1" class="border">
  <tr class="title_top">
    <td width="6%" height="32%"><div align="center">ID</div></td>
    <td width="80%"><div align="center">类别名称</div></td>
    <td width="14%"><div align="center">请选择</div></td>
  </tr>
  <%sql="select * from "&table%>
  <% set rs=conn.execute(sql) %>
  <% If rs.eof Then %>
  <tr class="tdbg" align="center">
    <td colspan="3" align="center">暂无分类.</td>
  </tr>
  <% Else %>
  <% do while not rs.eof %>
  <tr class="tdbg" align="center">
    <td><%= rs("ns_id") %></td>
    <td align="left"><a href="SortAdmin.asp?action=edit&id=<%= rs("ns_id") %>&name=<%= rs("ns_Name") %>"><%= rs("ns_Name") %></a></td>
    <td>
      <input name="id" type="checkbox" id="id" value="<%= rs("ns_id") %>"<% If rs("NS_State")=1 Then %> checked="checked"<% End If %>>    </td>
  </tr>
  <% rs.movenext %>
  <% loop %>
  <% End If %>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="50" valign="bottom"><div align="center">
      <input type="button" name="Submit3" value="全 选" onClick="sltAll()">&nbsp;
      <input type="submit" name="Submit" value="提 交">&nbsp;
      <input type="reset" name="Submit2" value="重 置">&nbsp;
      <input type="button" name="Submit32" value="全不选" onClick="sltNull()">
	  <input name="action" type="hidden" id="action" value="update">
    </div></td>
  </tr>
</table>
</form>
<% if Trim(Request.QueryString("action"))="edit" then 
sTitle = Request.QueryString("name")
id=Trim(Request.QueryString("id"))
%>
<form name="UFrom" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><div align="center">
		<font color="#FFFFFF"><b><font color="#000000">类别名称</font></b></font>
		<input type="hidden" name="id" value="<%=id%>"> 
		<input type="text" name="txttitle" size="20" value="<%=sTitle%>">
		<input type="submit" name="Submit" value=" 修 改 ">
	    <input name="action" type="hidden" id="action" value="update1">
    </div></td>
  </tr>
</table>
</form>
<% End If %>
</body>
</html>
<% 
if Trim(Request.Form("action"))="update" then
	id=Trim(Request.Form("id"))
	if id<>"" then
		sql="update "& table &" set NS_State=0"
		conn.execute(sql)
		sql="update Company set N_State=0 where N_Language like '%"&Language&"%'"
		conn.execute(sql)
		sql="update "& table &" set NS_State=1 where NS_id in ("&id&")"
		conn.execute(sql)
		sql="update Company set N_State=1 where N_Language like '%"&Language&"%' and  N_Sortid in ("&id&")"
		conn.execute(sql)
		response.Write("<script language=javascript>alert('修改成功。');")
		response.Write("window.location.href='sortAdmin.asp';</script>")
		response.End()
	else
		sql="update "& table &" set NS_State=0"
		conn.execute(sql)
		sql="update Company set N_State=0 where N_Language like '%"&Language&"%'"
		conn.execute(sql)
		response.Write("<script language=javascript>alert('修改成功。');")
		response.Write("window.location.href='sortAdmin.asp';</script>")
		response.End()
	end if
end if
if Trim(Request.Form("action"))="update1" then
	id=Trim(Request.Form("id"))
	tname=Trim(Request.Form("txttitle"))
	sql="update " &table &" set Ns_name='"&tname&"' where ns_id="&id
	conn.execute(sql)
	response.Write("<script language=javascript>alert('修改成功。');")
	response.Write("window.location.href='sortAdmin.asp';</script>")
	response.End()
end if
%>
⌨️ 快捷键说明

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