<%@ Language=VBScript%>
<%
Response.Buffer=false
Response.Expires=0
%>
<!-- #include file="../dsn.asp" -->
<!-- #include file="../links.asp" -->
<%
if session("adminusername")="" then
		session("xhy")=1
		Response.Redirect linkwarn
end if
showok=Request.QueryString ("showok")
cid=cint(Request.QueryString("cid"))
id=cint(Request.QueryString("id"))
pid=cint(Request.QueryString("pid"))
ppid=cint(Request.QueryString("ppid"))
pageno=Request.QueryString("pageno")
mode=Request.QueryString ("mode")
htmlname=linkadmin2&"?ppid="&ppid&"&pid="&pid&"&id="&id
if ppid<>9 then
		addhtml=linkadminedit2&"?ppid="&ppid&"&pid="&pid&"&id="&id
	else
		addhtml="admin2.asp?ppid="&ppid&"&pid="&pid&"&id="&id&"&showok=1"
end if			
backhtml=linkadmin2&"?ppid="&ppid&"&pid="&pid&"&id="&id
pbackhtml=linkadmin&"?ppid="&ppid&"&pid="&pid

if pid=20 or pid=63 or pid=64 or pid=65 then both=1

set cn=Server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")
set rs1=server.CreateObject("ADODB.Recordset")
set rs2=server.CreateObject("ADODB.Recordset")
if ppid<>0 then
		sqltext="select title from scool where id="&ppid
		rs1.Open sqltext,cn,1,1
		if not rs1.EOF then
				scoolname=rs1("title")
		end if
		rs1.Close 
end if
if pid<>0 then
		sqltext="select title from classes where id="&pid
		rs1.Open sqltext,cn,1,1
		if not rs1.EOF then
				classesname=rs1("title")
		end if
		rs1.Close 
end if
if id<>0 then
		sqltext="select title,zrs from danwei where id="&id
		rs1.Open sqltext,cn,1,1
		if not rs1.EOF then
				danweiname=rs1("title")
				zrs=clng(rs1("zrs"))
		end if
		rs1.Close 
end if
htmltitle="基本数据管理"
txtname="名称"
tabname="cdanwei"
if Request.ServerVariables("REQUEST_METHOD")="POST" and mode="888" then
		pl=trim(Request.Form("pl"))
		titletxt=trim(Request.Form("title"))
		if pl="" or not isnumeric(pl) then 
				sqltext3="select max(pl) as maxpl from "+tabname+" where pid="&id&" and ppid="&pid&" and pppid="&ppid
				rs2.Open sqltext3,cn,1,1
				if not rs2.EOF then
						pl=rs2("maxpl")+1
				end if
				rs2.Close 
		end if
		if pl="" or not isnumeric(pl) then pl=1
		sqltext3="select * from "+tabname+" where title='"+titletxt+"' and pid="&pid&" and ppid="&ppid&" and id<>"&id	
		rs2.Open sqltext3,cn,1,1
		if not rs2.EOF then
				err=1
				errtxt="错误：条目“"&titletxt&"”已存在，请换名重试！"
				titletxt=""
		end if
		if err<>1 and cid=0 then
				sqltext="select * from cdanwei"
				rs1.Open sqltext,cn,1,2
				rs1.AddNew 
				rs1.Update 
				cid=rs1("id")
				rs1.Close 
		end if
		if err<>1 and cid<>0 then
				sqltext2="select * from cdanwei where id="&cid
				rs1.Open sqltext2,cn,1,2
				rs1("title")=titletxt
				rs1("pl")=pl
				if Request.Form("showflag")="1" then
					rs1("enable")=1
				else	
					rs1("enable")=0
				end if
				if trim(Request.Form ("name2"))="" then
					name2="#ff6600"
				else
					name2=trim(Request.Form ("name2"))
				end if	
				rs1("name2")=name2
				rs1("pid")=id
				rs1("ppid")=pid
				rs1("pppid")=ppid
				rs1.Update
				rs1.Close
				Response.Redirect backhtml
		end if
		if err<>1 then Response.Redirect htmlname
end if 
if Request.ServerVariables("REQUEST_METHOD")="POST" then
		if not isempty(request("sel")) then
     		idlist=request("sel")
     		if instr(idlist,",")>0 then
				dim idarr
				idArr=split(idlist)
				for i = 0 to ubound(idarr)
	       			delid=clng(idarr(i))
	       			call setupdate(delid,mode)
				next
			else
				delid=clng(idlist)
				call setupdate(delid,mode)
			end if	
		end if
		delid=0
		Response.Redirect htmlname
end if
  sub setupdate(id,mm)
    if mm="999" then
		sqltext3="delete from "+tabname+" where id="&id
	elseif  mm="777" then
		sqltext3="update "+tabname+" set enable=1 where id="&id
	elseif  mm="666" then
		sqltext3="update "+tabname+" set enable=0 where id="&id
	elseif  mm="555" then
		sqltext3="update "+tabname+" set tjflag=1 where id="&id
		cn.Execute sqltext3
	elseif  mm="444" then
		sqltext3="update "+tabname+" set tjflag=0 where id="&id
		cn.Execute sqltext3			
	end if	
	cn.Execute sqltext3    
  end sub  
if cid<>0 then
		sqltext1="select * from "+tabname+" where id="&cid
		rs1.Open sqltext1,cn,1,1
		cdanweiname=trim(rs1("title"))
		enable=rs1("enable")
		name2=trim(rs1("name2"))
		titletxt=trim(rs1("title"))
		pl=rs1("pl")
		rs1.Close
		if len(cdanweiname)>18 then
				cdanweiname=left(cdanweiname,18)&"..."
		end if
	else
	    cdanweiname="增加新图片"
		enable=1
end if
if pid<>15 then
		txtname="名称"
	else	
		txtname="选项"
end if		
%>
<html>
<head>
<title><%=htmltitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {font-size: 12px; color: #000000; font-family: 宋体}
td {font-size: 12px; color: #000000; font-family: 宋体;line-height:130%}
.t1 {font:12px 宋体;color=000000} 
.t2 {font:12px 宋体;color:ffffff} 
.t3 {font:12px 宋体;color:336699} 
.t4 {font:12px 宋体;color:ff0000} 
.t5 {font:12px 宋体;color:ff6600} 


.bt1 {font:14px 宋体;color=000000} 
.bt2 {font:12px 宋体;color:ffffff} 
.bt3 {font:14px 宋体;color:336699} 
.bt4 {font:14px 宋体;color:ff0000} 
.bt5 {font:14px 宋体;color:0000ff}
.bt10 {font:14px 宋体;color:0000ff}

.td1 {font-size:12px;background-color:#3388bb;color:#ffffff}
.td2 {font-size:12px;background-color:#ffffff;color:#000000;}

A:link {color: #000077}
A:visited {color: #000077}
A:hover {color: #ff0000}

A.r1:link {text-decoration:none;color:#304556;}
A.r1:visited {text-decoration:none;color:#304556;}
A.r1:hover {text-decoration:underline;color:ff6600;}

A.r2:link {text-decoration:none;color:#ffffff;}
A.r2:visited {text-decoration:none;color:#ffffff;}
A.r2:hover {text-decoration:underline;color:cccc00;}

-->
</style>
</head>
<body topmargin=5>
<table width="100%" align=center>
	<tr>
	<td valign="top" align="left" width="100%">
		<table width="100%" height="20" border="0">
		  <tr>
			<td style="font-size:12px;"></td>
			<td><font class="t5">当前位置： <%Response.Write (scoolname)%>→  <%Response.Write (classesname)%>→  <%Response.Write (danweiname)%></font>
				← <a href="<%=pbackhtml%>">返回上级</a>
			</td>
		  </tr>
		</table>
	</td>
	</tr>
</table>
<table width="100%" height="20" border="0">
  <form action="<%=htmlname%>" method=post name="listform">
	<tr>
		<%
		sqltext1="select * from "+tabname+" where pid="&id&" and ppid="&pid&" and pppid="&ppid&" order by pl"
		'Response.Write sqltext1
		rs1.Open sqltext1,cn,1,1
		listcs=20
		rs1.PageSize=listcs
		if pageno="" then 
			pageno=1
		else
			pageno=cint(pageno)	
		end if	
		if rs1.PageCount>0 then rs1.AbsolutePage=pageno%>
				<td class=t1 align="left" width=340>
			<a href="Javascript:window.location.reload()">[刷新列表]</a>
			<a href="<%=addhtml%>&cid=0">[增加]</a>
			<a href="javascript:delrows()">[删除]</a>
			<a href="javascript:shows()">[显示]</a>
			<a href="javascript:noshows()">[不显示]</a>
			<%if ppid<>9 and both<>1 then%>
				<a href="javascript:prive()">[预览]</a>
			<%end if%>	
			
	
		</td>
		<td align="right">
		<%if rs1.PageCount>1 then%>
			[第<b><font color=ff6600><%=pageno%></font></b>页, 共<b><font color=ff6600><%=rs1.PageCount%></font></b>页<b><font color=ff6600><%=rs1.RecordCount%></font></b>条记录		              	
			<%if pageno>1 then%>
				<a class=r href="<%=htmlname%>&pageno=1">首页</a>              
				<a class=r href="<%=htmlname%>&pageno=<%=pageno-1%>">上页</a>              
			<%end if              
			if pageno<rs1.PageCount then%>              
				<a class=r href="<%=htmlname%>&pageno=<%=pageno+1%>">下页</a>              
				<a class=r href="<%=htmlname%>&pageno=<%=rs1.PageCount%>">末页</a>              
			<%end if%>              
		<%end if              
		%>              
		</td>
     </tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
  <tr><td height=300 valign=top>		
		<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
			<tr bgcolor="666669" style="color:#ffffff" align="center">
				<td class=bt2>&nbsp;</td>
				<td class=bt2 width=50>序号</td>
				<td class=bt2>是否显示</td>
				<td class=bt2><%=txtname%></td>
				<%if ppid<>9 and both<>1 then%>
						<td class=bt2>图片</td>
				<%end if%>		
			</tr>
		<%
		i=0
		do while not rs1.EOF and i<listcs 
			if (i mod 2)=1 then
				Response.Write("<tr bgcolor=fefefe>")
			else
				Response.Write("<tr bgcolor=efefef>")
			end if	
		%>
		<td width="20" align="center"><input type="checkbox" name="sel" value="<%=(rs1("id"))%>"></td>
		<td width="50" align="center"><%=rs1("pl")%></td>
		<td width="70" align="center">
			<%if rs1("enable")=1 then 
				Response.Write "显示"
		    else
				Response.Write "<font color=red>不显示</font>"
			end if%>
		</td>
		<td align=left><a href="<%=addhtml%>&cid=<%=rs1("id")%>"><%=rs1("title")%></a></td>
		<%if ppid<>9 and both<>1 then%>
		<td width="100" align="center">
				<a href="Javascript:editfile('<%=rs1("id")%>','1','cdanwei')">图片</a>
					<%if rs1("picflag1")="1" then Response.Write("<font color=red style='font-size:12px'>(有)</font>") else Response.Write("<font color=navy style='font-size:12px'>(无)</font>")%>
		</td>
		<%end if%>
		</tr>
	    <%rs1.MoveNext 
			i=i+1
	    loop%>
	    </form>
		</table>
	</td>
  </tr>		
</table>  
	 <%if showok="1" then%>
		<table width="100%" border="0" cellspacing="1" cellpadding="1">
		  <tr bgcolor="666699" style="color:#ffffff" align="center">
		    <td>
		    </td>
		  </tr>
		</table>
		<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
		  <tr bgcolor="ffffff" style="color:#ffffff" align="center">
		    <td height=20 align=left><font color=red><b><%=errtxt%></b></font></td>
		  </tr>
		</table>
		<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
		  <form action="<%=htmlname%>&cid=<%=cid%>&mode=888&showok=1" method=post name=editform onsubmit="return checkform(editform)">
			<tr><td align=right width="80">序号：</td><td><input type="text" value="<%=pl%>" name="pl" maxlength=15 size=5>
			     &nbsp;&nbsp;&nbsp;&nbsp;是否显示：<input type="checkbox" value="1" name="showflag" <%if enable=1 then Response.Write "checked"%>>
			</td></tr>
		    <tr><td align=right width="80"><%=txtname%>：</td><td><input type="text" value="<%=titletxt%>" name="title" maxlength=35 size=30><font color=red>*</font></td></tr>
		  	<%if pid=15 then%>
		  			<tr><td align=right width="80">示例图颜色：</td><td><input type="text" value="<%=name2%>" name="name2" maxlength=30 size=20><font color=red>例如："#FF6600"</font></td></tr>
		  	<%end if%>
		  	<tr><td height=40 width="80">&nbsp;</td><td><input type="submit" value="确定提交" name=s1>&nbsp;&nbsp;<input type="button" value="取消返回" name=re1 onClick="window.location.href='<%=htmlname%>'"></td></tr>
		 </form>
		</table>		
	<%end if%>		
	  </td></tr>
	 </table>	
	 
</body>
</html>
<script language="Javascript">

    function delrows()
    {
        document.listform.action="<%=htmlname%>&mode=999";
        document.listform.submit();
    }
    function shows()
    {
		listform.action="<%=htmlname%>&mode=777";
        document.listform.submit();
    }
    function noshows()
    {
        document.listform.action="<%=htmlname%>&mode=666";
        document.listform.submit();
    }
    function tj()
    {
		listform.action="<%=htmlname%>&mode=555";
        document.listform.submit();
    }
    function notj()
    {
        document.listform.action="<%=htmlname%>&mode=444";
        document.listform.submit();
    }    
	function editfile(keyno,pic,tablename)
	{
		var str
		str="file_upload.asp?" ;
		str=str+"keyno="+keyno+"&pic="+pic+"&tablename="+tablename
		window.open(str,"mywin","toolbar=no,location=no,directories=no,status=no,resizable=no,menubar=no,scrollbars=yes,width=550,height=400,left=120,top=70")		
	}
	function prive()
	{
	var src="view.asp?pppid=<%=ppid%>&tabname=cdanwei&ppid=<%=pid%>&pid=<%=id%>"
	window.open(src, 'myview', 'scrollbars=yes,width=700,height=400');
	}
	function checkform(form)
    {
        var flag;
        if(form("title").value==""){alert("<%=txtname%>不能为空！");form.title.focus();return false}else{flag=true}
        return flag;
    }
</script>
