📄 admin_nsort.asp
字号:
nid=int(rs(0))
if int(cid)=nid then
t22=rs(1)
rs.movenext
if rs.eof then exit do
t2=rs(0)
t11=rs(1)
call joekoe_cms.exec("update jk_class set c_order="&t11&" where c_id="&t1,0)
call joekoe_cms.exec("update jk_class set c_order="&t22&" where c_id="&t2,0)
exit do
end if
rs.movenext
loop
rs.close
else
t1=int(sid)
sql="select jk_sort.c_id from jk_class inner join jk_sort on jk_class.c_id=jk_sort.c_id where jk_sort.s_id="&sid
set rs=joekoe_cms.exec(sql,1)
if rs.eof then
rs.close
call joekoe_chk_main()
exit sub
end if
cid=int(rs(0))
rs.close
sql="select s_id,s_order from jk_sort where c_id="&cid&" order by s_order"&sql_add&",s_id"&sql_add
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
nid=int(rs(0))
if int(sid)=nid then
t22=rs(1)
rs.movenext
if rs.eof then exit do
t2=rs(0)
t11=rs(1)
call joekoe_cms.exec("update jk_sort set s_order="&t11&" where s_id="&t1,0)
call joekoe_cms.exec("update jk_sort set s_order="&t22&" where s_id="&t2,0)
exit do
end if
rs.movenext
loop
rs.close
end if
call joekoe_chk_main()
end sub
sub joekoe_chk_edits()
dim s_order,ncid
sql="select top 1 c.c_name,s.s_name from jk_class c inner join jk_sort s on c.c_id=s.c_id where c.nsort='"&nsort&"' and s.s_id="&sid
set rs=joekoe_cms.exec(sql,1)
if rs.eof then
rs.close
call admin_msg("二级"&tit_fir&"ID("&sid&")不存在!","?nsort="&nsort,1)
exit sub
end if
cname=rs(0)
sname=rs(1)
rs.close
%>
<table cellspacing=1 cellpadding=3 class=table0>
<tr>
<td class=td width='20%'></td>
<td class=td width='80%'><%response.write ntit&"("&ntit2&")"%></td>
</tr>
<%
if chk() then
sname=code_admin("s_name",1,16)
if sname="" then
call admin_error("二级"&tit_fir&"名称不能为空!")
response.write "</table>"
exit sub
end if
sql="update jk_sort set s_name='"&sname&"' where s_id="&sid
call joekoe_cms.exec(sql,0)
call admin_msg("成功修改二级"&tit_fir&"("&sname&")!","?nsort="&nsort,1)
response.write "</table>"
exit sub
end if
call form_first()
%>
<form action='?nsort=<%response.write nsort%>&action=edits&s_id=<%response.write sid%>' method=post>
<input type=hidden name=chk value='yes'>
<tr>
<td>一级<%response.write tit_fir%>名称:</td>
<td><font class=blue><b><%response.write cname%></b></font></td>
</tr>
<tr>
<td>二级<%response.write tit_fir%>名称:</td>
<td><input type=text name=s_name value='<%response.write sname%>' size=30 maxlength=16><%response.write redx%></td>
</tr>
<%
call submit_edit()
response.write "</table>"
end sub
sub joekoe_chk_adds()
dim s_order,ncid
sql="select top 1 c_name from jk_class where nsort='"&nsort&"' and c_id="&cid
set rs=joekoe_cms.exec(sql,1)
if rs.eof then
rs.close
call admin_msg("一级"&tit_fir&"ID("&cid&")不存在!","?nsort="&nsort,1)
exit sub
end if
cname=rs(0)
rs.close
%>
<table cellspacing=1 cellpadding=3 class=table0>
<tr>
<td class=td width='20%'></td>
<td class=td width='80%'><%response.write ntit&"("&ntit2&")"%></td>
</tr>
<%
if chk() then
sname=code_admin("s_name",1,16)
if sname="" then
call admin_error("二级"&tit_fir&"名称不能为空!")
response.write "</table>"
exit sub
end if
s_order=1
sql="select top 1 s_order from jk_sort where c_id="&cid&" order by s_order desc"
set rs=joekoe_cms.exec(sql,1)
if not rs.eof then s_order=int(rs(0))+1
rs.close
sql="insert into jk_sort(c_id,s_name,s_order) values('"&cid&"','"&sname&"',"&s_order&")"
call joekoe_cms.exec(sql,0)
call admin_msg("成功添加二级"&tit_fir&"("&sname&")!","?nsort="&nsort,1)
response.write "</table>"
exit sub
end if
call form_first()
%>
<form action='?nsort=<%response.write nsort%>&action=adds&c_id=<%response.write cid%>' method=post>
<input type=hidden name=chk value='yes'>
<tr>
<td>一级<%response.write tit_fir%>名称:</td>
<td><font class=blue><b><%response.write cname%></b></font></td>
</tr>
<tr>
<td>二级<%response.write tit_fir%>名称:</td>
<td><input type=text name=s_name size=30 maxlength=16><%response.write redx%></td>
</tr>
<%
call submit_add()
response.write "</table>"
end sub
sub joekoe_chk_editc()
sql="select top 1 c_name,c_remark from jk_class where nsort='"&nsort&"' and c_id="&cid
set rs=joekoe_cms.exec(sql,1)
if rs.eof then
rs.close
call admin_msg("一级"&tit_fir&"ID("&cid&")不存在!","?nsort="&nsort,1)
exit sub
end if
cname=rs(0)
cremark=rs(1)
rs.close
%>
<table cellspacing=1 cellpadding=3 class=table0>
<tr>
<td class=td width='20%'></td>
<td class=td width='80%'><%response.write ntit&"("&ntit2&")"%></td>
</tr>
<%
if chk() then
cname=code_admin("c_name",1,16)
if cname="" then
call admin_error("一级"&tit_fir&"名称不能为空!")
response.write "</table>"
exit sub
end if
cremark=code_admin("c_remark",1,250)
sql="update jk_class set c_name='"&cname&"',c_remark='"&cremark&"' where c_id="&cid
call joekoe_cms.exec(sql,0)
call admin_msg("成功编辑一级"&tit_fir&"("&cname&")!","?nsort="&nsort,1)
response.write "</table>"
exit sub
end if
call form_first()
%>
<form action='?nsort=<%response.write nsort%>&action=editc&c_id=<%response.write cid%>' method=post>
<input type=hidden name=chk value='yes'>
<tr>
<td>一级<%response.write tit_fir%>名称:</td>
<td><input type=text name=c_name value='<%response.write cname%>' size=30 maxlength=16><%response.write redx%></td>
</tr>
<% if nsort="flea" then %>
<tr>
<td>一级<%response.write tit_fir%>说明:</td>
<td class=gray><input type=text name=c_remark value='<%response.write cremark%>' size=50 maxlength=250><%response.write redx%>跳蚤市场专用</td>
</tr>
<%
end if
call submit_edit()
response.write "</table>"
end sub
sub joekoe_chk_addc()
dim c_order
%>
<table cellspacing=1 cellpadding=3 class=table0>
<tr>
<td class=td width='20%'></td>
<td class=td width='80%'><%response.write ntit&"("&ntit2&")"%></td>
</tr>
<%
if joekoe_cms.chk() then
cname=code_admin("c_name",1,16)
if cname="" then
call admin_error("一级"&tit_fir&"名称不能为空!")
response.write "</table>"
exit sub
end if
c_order=1
cremark=code_admin("c_remark",1,250)
sql="select top 1 c_order from jk_class where nsort='"&nsort&"' order by c_order desc"
set rs=joekoe_cms.exec(sql,1)
if not rs.eof then c_order=int(rs(0))+1
rs.close
sql="insert into jk_class(nsort,c_name,c_order,c_remark) values('"&nsort&"','"&cname&"',"&c_order&",'"&cremark&"')"
call joekoe_cms.exec(sql,0)
call admin_msg("成功添加一级"&tit_fir&"("&cname&")!","?nsort="&nsort,1)
response.write "</table>"
exit sub
end if
call form_first()
%>
<form name=add_frm action='?jk_mod=<%response.write jk_mod%>&nsort=<%response.write nsort%>&action=addc' method=post>
<input type=hidden name=chk value='yes'>
<tr>
<td>一级<%response.write tit_fir%>名称:</td>
<td><input type=text name=c_name size=30 maxlength=16><%response.write redx%></td>
</tr>
<% if nsort="flea" then %>
<tr>
<td>一级<%response.write tit_fir%>说明:</td>
<td class=gray><input type=text name=c_remark size=50 maxlength=250><%response.write redx%>跳蚤市场专用</td>
</tr>
<%
end if
call submit_add()
response.write "</table>"
end sub
sub joekoe_chk_main()
dim rs2,sql2
%>
<table cellspacing=1 cellpadding=3 class=table0>
<tr align=center>
<td class=td width='70%'><%response.write ntit%>名称及添加操作</td>
<td class=td width='30%'>相关操作</td>
</tr>
<%
'sql="select c.c_id,s.s_id,c.c_name,s.s_name from jk_class c inner join jk_sort s on c.c_id=s.c_id where c.nsort='"&nsort&"' order by c.c_order,c.c_id,s.s_order,s.s_id"
sql="select c_id,c_name,c_remark from jk_class where nsort='"&nsort&"' order by c_order,c_id"
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
cid=rs(0)
cname=rs("c_name")
%>
<tr>
<td> <%response.write img_admin("s_left","")%> <font class=red2><b><%response.write cname%></b></font> (<a href='?nsort=<%response.write nsort%>&action=adds&c_id=<%response.write cid%>'>添加二级分类</a>)</td>
<td>
<a href='?nsort=<%response.write nsort%>&c_id=<%response.write cid%>&action=editc'>编辑</a>
<a href='?nsort=<%response.write nsort%>&c_id=<%response.write cid%>&action=up'><%response.write img_admin("up_1","向上移动此主"&tit_fir)%></a>
<a href='?nsort=<%response.write nsort%>&c_id=<%response.write cid%>&action=down'><%response.write img_admin("down_1","向下移动此主"&tit_fir)%></a>
<a href='?nsort=<%response.write nsort%>&c_id=<%response.write cid%>&action=del' onclick="return del_nsort(<%response.write cid%>,'<%response.write cname%>','yes');">删除</a>
</td>
</tr>
<%
sql2="select s_id,s_name from jk_sort where c_id="&cid&" order by s_order,s_id"
set rs2=joekoe_cms.exec(sql2,1)
do while not rs2.eof
sid=rs2(0)
sname=rs2(1)
%>
<tr>
<td> <font class=blue><b><%response.write sname%></b></font></td>
<td>
<a href='?nsort=<%response.write nsort%>&s_id=<%response.write sid%>&action=edits'>修改</a>
<a href='?nsort=<%response.write nsort%>&s_id=<%response.write sid%>&action=up'><%response.write img_admin("up_2","向上移动此二级"&tit_fir)%></a>
<a href='?nsort=<%response.write nsort%>&s_id=<%response.write sid%>&action=down'><%response.write img_admin("down_2","向下移动此二级"&tit_fir)%></a>
<a href='?nsort=<%response.write nsort%>&s_id=<%response.write sid%>&action=del' onclick="return del_nsort(<%response.write sid%>,'<%response.write sname%>','no');">删除</a>
</td>
</tr>
<%
rs2.movenext
loop
rs2.close
rs.movenext
loop
rs.close
if isobject(rs2) then set rs2=nothing
%>
</table>
<script language=javascript>
<!--
function del_nsort(t1,t2,t3)
{
if (t3=="yes")
{
var cf=window.confirm("您确定要删除主<%response.write tit_fir%>("+t2+")吗?\n其下的二级<%response.write tit_fir%>也将一并删除!\n\n删除后将不可恢复!是否确定该操作?");
if (cf)
{ return true; }
else
{ return false; }
}
else
{
var cf1=window.confirm("您确定要删除二级<%response.write tit_fir%>("+t2+")吗?\n\n删除后将不可恢复!是否确定该操作?");
if (cf1)
{ return true; }
else
{ return false; }
}
return false;
}
-->
</script>
<%
end sub
sub joekoe_chk_dim()
dim tmpsort
tmpsort=trim(request.querystring("nsort"))
nnum=-1
sql="select m_nsort,m_tit_fir,m_data_name,m_on_power,m_on_emoney from admin_menu where m_is_master=1 and m_is_nsort=1"
if jk_mod="batch" then
sql=sql&" and (m_on_power=1 or m_on_emoney=1)"
end if
sql=sql&" order by m_id"
call joekoe_cms.exec("",-1)
rs.open sql,conn,1,1
if not rs.eof then
nnum=rs.recordcount-1
redim ndim(4,nnum)
for i=1 to nnum+1
ndim(0,i-1)=rs(0)
ndim(1,i-1)=rs(1)
ndim(2,i-1)=rs(2)
ndim(3,i-1)=rs(3)
ndim(4,i-1)=rs(4)
if tmpsort=ndim(0,i-1) then
nsort=tmpsort
ntit=ndim(1,i-1)
n_data_name=ndim(2,i-1)
n_on_power=ndim(3,i-1)
n_on_omoney=ndim(4,i-1)
end if
rs.movenext
next
if nsort="" then
nsort=ndim(0,0)
ntit=ndim(1,0)
n_data_name=ndim(2,0)
n_on_power=ndim(3,0)
n_on_omoney=ndim(4,0)
end if
ntit1=ntit
ntit=ntit&tit_fir
end if
rs.close
end sub
sub joekoe_chk_erase()
if isarray(ndim) then erase ndim
end sub
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -