📄 sys_dept.asp
字号:
<%@ Language=VBScript %>
<%
Response.Buffer=true
Response.Expires=0
if Session("userqx")>="1" and Session("userqx")<="9" then
else
Response.Redirect "warn.asp"
end if
%>
<!-- #include file="../dsn.asp" -->
<%
myflag=Request.QueryString("myflag")
keyno=Request.QueryString("keyno")
pageno=Request.QueryString("pageno")
delkeyno=Request.QueryString("delkeyno")
if myflag="" then myflag="0"
if keyno="" then keyno="0"
tablename="sys_dept"
set cn=server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")
set rs2=server.CreateObject("ADODB.Recordset")
htmltitle="单位联系部门"
for i=1 to 4
Randomize
if i mod 2=1 then
temp=temp&chr(int(rnd*26)+97)
else
temp=temp&chr(int(rnd*10)+48)
end if
next
myurl="sys_dept.asp?temp="+temp
if Request.ServerVariables("REQUEST_METHOD")="POST" then
if Request.Form("submit")<>"" then
sortnum=trim(Request.Form("sortnum"))
if keyno="0" then
if not isnumeric(sortnum) then
sqltext="select sortnum from "+tablename+" order by sortnum desc "
rs2.Open sqltext,cn,1,1
if not rs2.EOF then
sortnum=rs2(0)+1
else
sortnum=1
end if
rs2.Close
end if
sql="select code from "+tablename+" order by code desc"
rs2.Open sql,cn,1,1
if not rs2.EOF then
code=rs2(0)+1
else
code="101"
end if
rs2.Close
rs.Open tablename,cn,3,3
rs.AddNew
rs("code")=code
else
sqltext="select * from "+tablename+" where code='"+keyno+"'"
rs.Open sqltext,cn,3,3
end if
if isnumeric(sortnum) then rs("sortnum")=sortnum
rs("deptname")=trim(Request.Form("deptname"))
rs("deptname2")=trim(Request.Form("deptname2"))
rs("shortname")=trim(Request.Form("shortname"))
rs("shortname2")=trim(Request.Form("shortname2"))
rs("address")=trim(Request.Form("address"))
rs("address2")=trim(Request.Form("address2"))
rs("linkman")=trim(Request.Form("linkman"))
rs("linkman2")=trim(Request.Form("linkman2"))
rs("phone")=trim(Request.Form("phone"))
rs("fax")=trim(Request.Form("fax"))
rs("zip")=trim(Request.Form("zip"))
rs("website")=trim(Request.Form("website"))
rs("flag")=trim(Request.Form("flag"))
rs("email")=trim(Request.Form("email"))
rs.Update
rs.Close
myflag="0"
else
rectot=Request.Form("rectot")
for i=1 to rectot
checksele=Request.Form("checksele"&i)
if checksele<>"" then
seleitem=Request.Form("seleitem"&i)
cn.BeginTrans
sqltext="delete from "+tablename+" where code='"+seleitem+"'"
cn.Execute sqltext
cn.CommitTrans
end if
next
end if
end if
%>
<HTML>
<HEAD>
<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: 宋体;}
.t1 {font:12px 宋体;color=000000}
.t2 {font:12px 宋体;color:ffffff}
.bt1 {font:14px 宋体;color=000000}
.bt2 {font:14px 宋体;color:ffffff}
A:link {color: #000066}
A:visited {color: #000066}
A:hover {color: #ff0000}
A.r1:link {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:visited {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:hover {font-size:12px;text-decoration:underline;color:#ff0000;}
A.r2:link {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:visited {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:hover {font-size:12px;text-decoration:underline;color:#ff6600;}
A.r3:link {font-size:12px;text-decoration:none;color:#000000;}
A.r3:visited {font-size:12px;text-decoration:none;color:#000000;}
A.r3:hover {font-size:12px;text-decoration:underline;color:#ff0000;}
-->
</style>
</HEAD>
<body topmargin=5 leftmargin=5 bgcolor=#ffffff>
<table width="100%" align=center border="0" cellspacing="0" cellpadding="2">
<%
sqltext="select * from "+tablename+" order by sortnum "
rs.Open sqltext,cn,1,1
%>
<tr><td align="left">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height=24>
<form name="xxform" method=post >
<tr valign=bottom>
<td style="font-size:12px;">
<font color="DarkSlateGray" style="font-size:14px"><b><%=htmltitle%></b></font>
<font color=ff6600 style="font-size:12px"><b><%=Server.HTMLEncode(mytitle)%></b></font>
<a href="<%=myurl%>">[刷新列表]</a>
<a href="<%=myurl%>&myflag=1">[增加]</a>
</td>
<td>
</td>
</tr>
</form>
</table>
</td></tr>
<tr><td height=120 valign=top>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<form name=form1 method="post" action="<%=htmlname%>">
<tr bgcolor="527c72" style="color:#ffffff" align="center">
<td width=10 height=20 align=center>
<td class=t2 width=40>序号</td>
<td class=t2 align=center>部门名称</td>
<td class=t2 align=center>联系电话</td>
<td class=t2 align=center>性质</td>
<td class=t2 align=center>电子信箱</td>
</tr>
<%
i=1
do while not rs.EOF
if (i mod 2)=0 then
Response.Write("<tr bgcolor=fefefe>")
else
Response.Write("<tr bgcolor=efefef>")
end if
%>
<td width=10 height=20 align=center>
<input type=hidden name="seleitem<%=i%>" value="<%=rs("code")%>">
<input type=checkbox name="checksele<%=i%>" value="0">
</td>
<td width=40 align="center" height=20><%=rs("sortnum")%></td>
<td height=20>
<a href="<%=myurl%>&myflag=1&keyno=<%=rs("code")%>"><%=Server.HTMLEncode(trim(rs("deptname")))%></td>
<td align="left" height=20><%=trim(rs("phone"))%></td>
<td width=60 align="center" height=20>
<%
if rs("flag")="1" then
Response.Write("<font color=800000>总部</font>")
end if
%>
</td>
<td align="left" height=20><%=trim(rs("email"))%></td>
</tr>
<%
i=i+1
rs.MoveNext
loop
rs.Close
%>
<input type=hidden value="<%=i-1%>" name=rectot>
</table>
</td></tr>
<tr><td valign=top height=30>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td colspan=2 bgcolor="696969" height=1></td></tr>
<tr><td>
<input type="button" name="mydele" value="删除" style="width:60px;height:20px" onclick="delmsg(this.form)">
<input type="checkbox" name="seleall" onclick="checkall(this.form)" >全选
</td><td align=right height=30>
[共<b><font color=ff6600><%=i-1%></font></b>条记录]
</td></tr>
</table>
</form>
</td></tr>
</table>
<%if myflag="1" then%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<form action="<%=myurl%>&keyno=<%=keyno%>" method=post name=editform onsubmit="return checkform(editform)" autocomplete = "off">
<%
if keyno="0" then
flag="0"
sqltext="select sortnum from "+tablename+" order by sortnum desc "
rs2.Open sqltext,cn,1,1
if not rs2.EOF then
sortnum=rs2(0)+1
else
sortnum=1
flag="1"
end if
rs2.Close
else
sqltext="select * from "+tablename+" where code='"+keyno+"'"
rs.Open sqltext,cn,1,1
if not rs.EOF then
sortnum=rs("sortnum")
deptname=trim(rs("deptname"))
deptname2=trim(rs("deptname2"))
shortname=trim(rs("shortname"))
shortname2=trim(rs("shortname2"))
address=trim(rs("address"))
address2=trim(rs("address2"))
linkman=trim(rs("linkman"))
linkman2=trim(rs("linkman2"))
phone=trim(rs("phone"))
fax=trim(rs("fax"))
zip=trim(rs("zip"))
email=trim(rs("email"))
website=trim(rs("website"))
flag=trim(rs("flag"))
end if
rs.Close
end if
%>
<tr bgcolor=898989><td colspan=2 height=20><font class=t2>具体内容</font></td></tr>
<tr><td width=560>
<table width="100%" border="0" cellspacing="1" cellpadding="0" align="center">
<tr><td width=70 class=td1 align=right height=5></td>
<td class=td2></td></tr>
<tr><td width=70 class=td1 align=right>序号：</td>
<td class=td2><input type="text" value="<%=sortnum%>" name=sortnum maxlength=10 size=6>
<input type=checkbox name=flag value="1" <%if flag="1" then Response.Write("checked")%>>是否总部(每个单位有且仅有一个)
</td></tr>
<tr><td class=td1 align=right>部门名称：</td>
<td class=td2>
<input type="text" value="<%=deptname%>" name=deptname maxlength=60 size=60><font color=ff4500>*</font>
</td></tr>
<!--tr><td class=td1 align=right>名称(英)：</td>
<td class=td2>
<input type="text" value="<%=deptname2%>" name=deptname2 maxlength=120 size=60>
</td></tr>
<tr><td class=td1 align=right>部门简称：</td>
<td class=td2>
<input type="text" value="<%=shortname%>" name=shortname maxlength=50 size=40>
</td></tr>
<tr><td class=td1 align=right>简称(英)：</td>
<td class=td2>
<input type="text" value="<%=shortname2%>" name=shortname2 maxlength=60 size=40>
</td></tr-->
<tr><td class=td1 align=right>联系地址：</td>
<td class=td2>
<input type="text" value="<%=address%>" name=address maxlength=60 size=60>
</td></tr>
<!--tr><td class=td1 align=right>地址(英)：</td>
<td class=td2>
<input type="text" value="<%=address2%>" name=address2 maxlength=120 size=60>
</td></tr-->
<tr><td class=td1 align=right>联系人：</td>
<td class=td2>
<input type="text" value="<%=linkman%>" name=linkman maxlength=50 size=26>
<!--英文名：<input type="text" value="<%=linkman2%>" name=linkman2 maxlength=50 size=24>-->
</td></tr>
<tr><td class=td1 align=right>联系电话：</td>
<td class=td2>
<input type="text" value="<%=phone%>" name=phone maxlength=60 size=60>
</td></tr>
<tr><td class=td1 align=right>传真：</td>
<td class=td2>
<input type="text" value="<%=fax%>" name=fax maxlength=30 size=30>
邮政编码：<input type="text" value="<%=zip%>" name=zip maxlength=10 size=18>
</td></tr>
<tr><td class=td1 align=right>联系信箱：</td>
<td class=td2>
<input type="text" value="<%=email%>" name=email maxlength=60 size=50>
</td></tr>
<!--tr><td class=td1 align=right>网址：</td>
<td class=td2>
<input type="text" value="<%=website%>" name=website maxlength=60 size=50>
</td>
</tr-->
</tr>
<tr><td class=td2 bgcolor=ffffff ></td><td class=td2 bgcolor=ffffff align=left><br>
<input type="submit" name="submit" value="确认提交">
</td></tr>
</table>
</td>
<td> </td>
</tr>
<script language=Javascript>editform.deptname.focus()</script>
</form>
</table>
<form name=preview method=post action="../admin/content_view.asp" target=winview>
<input type=hidden name=viewtitle value=""><input type=hidden name=viewbody value="">
</form>
<%end if%>
</body>
</html>
<!-- #include file="sysfunc.inc.asp" -->
<script language="Javascript">
function checkall(form)
{
for (var i=0;i<form.elements.length;i++)
{
var obj = form.elements[i];
var objname=obj.name;
if(objname.substring(0,9)=="checksele")
{
obj.checked=form.seleall.checked
}
}
}
function delmsg(form)
{
var flag=false;
var i,rectot,obj1
rectot=form.rectot.value;
for(i=1;i<=rectot;i++)
{
obj1=eval("form.checksele"+i);
if (obj1.checked) flag=true;
}
if (flag){
if (confirm('确认删除选择的记录吗？')==true) form.submit();
}else alert("请先选择要删除的记录!");
}
function checkform(form)
{
var flag=true;
if(form("deptname").value==""){alert("部门名称不能为空!");form("deptname").focus();return false;}
return flag;
}
function format(flag)
{
switch(flag){
case "bold":
begintxt="<b>";
endtxt="</b>";
break;
case "italic":
begintxt="<i>";
endtxt="</i>";
break;
case "underline":
begintxt="<u>";
endtxt="</u>";
break;
case "center":
begintxt="<center>";
endtxt="</center>";
break;
case "space":
begintxt=" ";
endtxt="";
break;
}
dealcontent()
}
function formatcolor(newvalue)
{
begintxt="<font color="+newvalue+">"
endtxt="</font>";
dealcontent()
}
function formatfont(newvalue)
{
begintxt="<font face="+newvalue+">"
endtxt="</font>";
dealcontent()
}
function formatsize(newvalue)
{
begintxt="<font size="+newvalue+">"
endtxt="</font>";
dealcontent()
}
function dealcontent()
{
if ((document.selection)&&(document.selection.type == "Text"))
{
var range = document.selection.createRange();
var ch_text=range.text;
range.text = begintxt + ch_text + endtxt;
}
else
{
document.editform.content.value=begintxt+document.editform.content.value+endtxt;
document.editform.content.focus();
}
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -