📄 left.asp

📁 一个相当好的电话管理程序
💻 ASP
字号:
<%@language=JScript codepage=936%>
<%Response.Buffer =true;
var conn=Server.CreateObject("adodb.connection")
conn.provider="Microsoft.jet.OLEDB.4.0"
DB=Server.mapPath("../data/20040908.mdb")
conn.open(DB)
function closedb()
{
conn.close()
conn=null;
}
if(Session("admin")!="廖永南")
{
Response.write("<script>alert('你无权限进入');location='login.asp';</script>")
Response.end
}
%>
<%
exitadmin=new String(Request.querystring("exitadmin"))
if(exitadmin=="exit"){
Session("admin")=null
Session.abandon
}
%>
<html>
<head>
<title>电话查询后台管理</title>
<meta name="Generator" content="EditPlus">
<meta name="Author" content="廖永南">
<meta name="Keywords" content="电话查询程序">
<meta name="Description" content="电话查询程序">
<script src="../inc/tel.js"></script>
<style type="text/css">
body{
	text-align:center;
　　color: #333;
　　font-family:arial,verdana,sans-serif;
	scrollbar-face-color: #b4b4b4;
	scrollbar-highlight-color: #f3f3f3;
	scrollbar-shadow-color: #f3f3f3;
	scrollbar-dark-shadow-color: #ffffff;
	scrollbar-3d-light-color: #b4b4b4;*/
	background-color:#E1DBC5;
	scrollbar-base-color:#E1DBC5;
	scrollbar-arrow-color: #C0815E;
	font-size:12px;	
}
#header{
width:776px;
margin-right: auto;
margin-left: auto; 
padding: 0px;
background: #EEE;
height:60px;
text-align:center;
} #contain{
margin-right: auto;
margin-left: auto;
width: 776px;
border:1px solid black;
} #mainbg{
width:776px;
padding: 0px;
background: #60A179;
float: left;
}
#right{
float: right; 
margin: 2px 0px 2px 0px;
padding:0px; 
width: 350px; 
background: #ccd2de;
text-align:left;
}
#left{
float: left; 
margin: 2px 2px 0px 0px; 
padding: 0px; 
background: #F2F3F7;
width: 414px;
text-align:left;
}
#footer{
clear:both;
width:776px;
margin-right: auto;
margin-left: auto; 
padding: 0px;
background: #EEE;
height:60px;}
.text{margin:0px;padding:20px;font-size:12px;
}
</style>
<div id="header"><br>朝日电话查询系统后台程序<br>日期：2004年9月08日(作者：廖永南) </div>
<div id="contain">
<div id="mainbg">
<div id="right">
<div 
class="text">
<%
var not_found="没有相关的内容!<p><a href=javascript:history.back()>返回</a>"
var sql
var keyword=String(Request.querystring("keyword"))
var delid=String(Request.QueryString("delid"))
if(delid!="undefined")
{
conn.execute("delete * from t_tel where id="+delid+"")
Response.write("<script>alert('删除成功');self.location='left.asp';</script>")
Response.end
}
if(keyword!="undefined")
{
sql="select id,f_unit_office,f_unit,f_unit_tel from t_tel where f_unit_office like '%"+keyword+"%' or f_unit like '%"+keyword+"%' or f_unit_tel like '%"+keyword+"%' order by id desc"
}
else
{
sql="select id,f_unit_office,f_unit,f_unit_tel from t_tel order by id desc"
}
show_result(sql)
%>
</div>
</div>
<%
//-----------------------------------------------
//	函数名:		show_result()
//	参  数:		数据查寻结果 (rs)
//	功  能:		列出结果
//	最后修改时间:	2004.7.27
//-----------------------------------------------
function show_result(sql)
{
 var ors=Server.CreateObject("adodb.recordset");
ors.open(sql,conn,1)

 if(!ors.eof&&!ors.bof)
 {
 var count,page,currentpage,p_start,pre_page,next_page,i
 pagesize=1;
 count=parseInt(ors.recordcount);
 page=Math.ceil(count/pagesize);
 currentpage=Request("page")-0;
 if(isNaN(currentpage))
	currentpage=1;
 else if(currentpage<1)
	currentpage=1;
 else if(currentpage>page)
	currentpage=page;
 p_start=(currentpage-1)*pagesize;
 pre_page=currentpage-1;
 next_page=currentpage+1;
  for(i=0;i<p_start;i++)
	ors.moveNext()

    Response.write("关键字:<input size=15 name='keyword'>　<input type='submit' value='查询' onclick=location='?keyword='+keyword.value><table border=0 cellspacing=0 cellpadding=3 style='font-size:12px'>"+
		"<tr>"+
		"<th>"+
		"ID</th> "+
		"<th >单位科室</th>"+
		"<th >单位名称</th>"+
		"<th >电话</th>"+
		"<th >操作</th></tr>");

    for(i=0;i<pagesize;i++)
      if(!ors.eof)
       {
	f_unit_office=(ors("f_unit_office")+"")=="null"?"&nbsp;":ors("f_unit_office");
	f_unit=(ors("f_unit")+"")=="null"?"&nbsp;":ors("f_unit");
	f_unit_tel=((ors("f_unit_tel")+"")=="null"?"&nbsp;":ors("f_unit_tel"))+"&nbsp;";
	Response.write("<tr><td>"+ors("id")+"</td>"+
			"<td>"+f_unit_office+"</td>"+
			"<td>"+f_unit+"</td>"+
			"<td>"+f_unit_tel+"</td>"+
			"<td><a href=?search="+ors("id")+">修改</a> <a href=?delid="+ors("id")+">删除</a></td>");
	ors.moveNext();
       }

     Response.write("<tr height=1><th colspan=6 height=1 style=background-color:#999999></th></tr>"+
		"<tr class=foot><th colspan=6 height=20>"+
		count+"条;"+currentpage+"/"+page+"页;"+
		""+(currentpage==1?"首页":"<a href=?page=1>首页</a>")+
		""+(currentpage==1?"上一页":"<a href=?page="+pre_page+">上一页</a>")+
		""+(currentpage==page?"下一页":"<a href=?page="+next_page+">下一页</a>")+
		""+(currentpage==page?"尾页":"<a href=?page="+page+">尾页</a>")+
		"</th></tr>")
     Response.write("</table>");
  }
  else
 {
 Response.write(not_found);
 }

 ors.close();
 ors=null;
}
%>
<%
//编辑内容
if(String(Request.QueryString("search"))!="undefined"){
var editunit=conn.execute("select f_unit,f_unit_address,f_unit_postcode,f_unit_Website,f_unit_office,f_unit_fax,f_unit_tel,f_unit_Email,f_unit_intro,f_unit_produce_serve,f_unit_manage_range from t_tel where id="+Request.QueryString("search")+"")
str="<script>function editunit()"
str+="{editobj=document.frm_unit;\n"
str+="editobj.unit.value='"+String(editunit(0))+"'\n"
str+="editobj.unit_address.value='"+String(editunit(1))+"'\n"
str+="editobj.unit_postcode.value='"+String(editunit(2))+"'\n"
str+="editobj.unit_Website.value='"+String(editunit(3))+"'\n"
str+="editobj.unit_office.value='"+String(editunit(4))+"'\n"
str+="editobj.unit_fax.value='"+String(editunit(5))+"'\n"
str+="editobj.unit_tel.value='"+String(editunit(6))+"'\n"
str+="editobj.unit_Email.value='"+String(editunit(7))+"'\n"
str+="editobj.unit_intro.value='"+String(editunit(8))+" '\n"
str+="editobj.unit_produce_serve.value='"+String(editunit(9))+"'\n"
str+="editobj.unit_manage_range.value='"+String(editunit(10))+"'\n"
str+="editobj.unitid.value='"+String(Request.QueryString("search"))+"'\n"
str+="editobj.submit.value='编辑';}</script>"
Response.write(str)
}

%>
<div id="left">
<form action="saveunit.asp" name="frm_unit" method="post" onsubmit="return checkform(this)">
所属城市: <select name="city" onchange="choosetwons(this.selectedIndex)"></select><font color="red">*</font><br>
所属城镇: <select name="town"></select><font color="red">*</font><br>
机关所属: <select name="units"></select><br>
单位名称: <input  name="unit" maxlength="50" size=40><font color="red">*</font><br>
单位地址: <input  name="unit_address" maxlength="50" size=40><br>
单位邮编: <input  name="unit_postcode" maxlength="50" size=40 value="353100"><font color="red">*</font><br>
单位网址: <input  name="unit_Website" maxlength="50" size=40 value="http://"><br>
单位科室: <input  name="unit_office" maxlength="50" size=40><font color="red">*</font><br>
　　 传真:<input  name="unit_fax" maxlength="50"><br>
　　 电话:<input  name="unit_tel" maxlength="50"><font color="red">*</font><br>
　 E-mail:<input name="unit_Email" maxlength="50"><br><br>
         <input  name="unitid" type="hidden">
公司简介: <textarea name="unit_intro" cols="40" rows="6" maxlength="200"></textarea><font color="blue">*</font>200个<br>
产品及服务:<textarea name="unit_produce_serve" cols="40" rows="6" maxlength="200"></textarea><font color="blue">*</font>200个<br>
经营范围: <textarea  name="unit_manage_range" cols="40" rows="6" maxlength="200"></textarea><font color="blue">*</font>200个<br>

　　　　<input name="submit" type="submit" value="添加">　　　<input  type="reset" value="取消">
</form>
</div>
<div id="footer">
<script src="../inc/fun.js"></script>
<%if(String(Request.QueryString("search"))!="undefined"){
Response.write("<script>editunit()</script>")
}
%>
<span class="noclick" onclick="location='?exitadmin=exit'"><br>&copy;版权所有:建瓯朝日网络公司<br><u>● 退出管理</u></span>
</div>
</body>
</html>
💿 文件大小 27 K
👤 上传用户 xfzzp_0321
📂 所属分类 Internet/网络编程
🏷️ 相关标签

#电话管理 #程序
⌨️ 快捷键说明

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