saveunit.asp

一个相当好的电话管理程序

<%@language="jscript"%>
<%
/*
''''''''''''''''''''''''''''''''''
' corp_save.asp					 '
'功能：存储电话登记 作者:廖永南，苏绿'
'公司:建瓯朝日网络有限公司
''''''''''''''''''''''''''''''''''
*/
var conn=Server.CreateObject("adodb.connection")
conn.provider="Microsoft.jet.OLEDB.4.0"
DB=Server.mapPath("../data/20040908.mdb")
conn.open(DB)

function check_num(str)
{
	if(isNaN(str))
	{
	Response.write("非法参数,程序中止运行")
	Response.end
	}
	else
	{
	return str
	}
}
function check_str(str)
{
	return str.replace(/'/gi,"")
}
function check_empty(str)
{
   return /\S/gi.test(str)
}
frm_city=check_num(new String(Request.form("city")))
frm_town=check_num(new String(Request.form("town")))
frm_units=check_num(new String(Request.form("units")))
frm_unit=check_str(new String(Request.form("unit")))
frm_unit_address=check_str(new String(Request.form("unit_address"))).substr(0,45)
frm_unit_postcode=check_num(new String(Request.form("unit_postcode")))
frm_unit_Website=check_str(new String(Request.form("unit_Website"))).substr(0,45)
frm_unit_intro=check_str(new String(Request.form("unit_intro"))).substr(0,200)
frm_unit_intro=frm_unit_intro.replace(/\r\n/gi,"<br>")
frm_unit_produce_serve=check_str(new String(Request.form("unit_produce_serve"))).substr(0,200)
frm_unit_produce_serve=frm_unit_produce_serve.replace(/\r\n/gi,"<br>")
frm_unit_manage_range=check_str(new String(Request.form("unit_manage_range"))).substr(0,200)
frm_unit_manage_range=frm_unit_manage_range.replace(/\r\n/gi,"<br>")
frm_unit_office=check_str(new String(Request.form("unit_office"))).substr(0,45)
frm_unit_fax=check_str(new String(Request.form("unit_fax"))).substr(0,45)
frm_unit_tel=check_str(new String(Request.form("unit_tel"))).substr(0,45)
frm_unit_Email=check_str(new String(Request.form("unit_Email"))).substr(0,45)
frm_unitid=Request.form("unitid")-0
if(conn.execute("select id from t_tel where f_unit='"+frm_unit+"' or f_unit_tel='"+frm_unit_tel+"'").eof){
if(check_empty(frm_unit)&&check_empty(frm_unit_office)&&check_empty(frm_unit_tel)){
var sql="insert into t_tel(f_city,f_town,f_units,f_unit,f_unit_address,f_unit_postcode,f_unit_Website,f_unit_intro,f_unit_produce_serve"
sql+=",f_unit_manage_range,f_unit_office,f_unit_fax,f_unit_tel,f_unit_Email)"
sql+="values("+frm_city+","+frm_town+","+frm_units+",'"+frm_unit+"','"+frm_unit_address+"'"
sql+=","+frm_unit_postcode+",'"+frm_unit_Website+"','"+frm_unit_intro+"','"+frm_unit_produce_serve+"'"
sql+=",'"+frm_unit_manage_range+"','"+frm_unit_office+"','"+frm_unit_fax+"','"+frm_unit_tel+"','"+frm_unit_Email+"')"
try{
conn.execute(sql)
}
catch(e)
{
Response.write("出错原因:"+e.description)
Response.write("<br>保存失败!<a href=left.asp>返回</a>")
Response.end
}
Response.write("保存记录"+frm_unit+"成功!<br>")
Response.write("保存成功!<a href=left.asp>返回</a>")
Response.end
}
}
else
{
if(frm_unitid>0)
{
var sql="update t_tel set f_city="+frm_city+",f_town="+frm_town+",f_units="+frm_units+",f_unit='"+frm_unit+"'"
sql+=",f_unit_address='"+frm_unit_address+"',f_unit_postcode="+frm_unit_postcode+",f_unit_Website='"+frm_unit_Website+"',f_unit_intro='"+frm_unit_intro+"',f_unit_produce_serve='"+frm_unit_produce_serve+"'"
sql+=",f_unit_manage_range='"+frm_unit_manage_range+"',f_unit_office='"+frm_unit_office+"',f_unit_fax='"+frm_unit_fax+"',f_unit_tel='"+frm_unit_tel+"',f_unit_Email='"+frm_unit_Email+"'"
sql+=" where id="+frm_unitid
try{
conn.execute(sql)
}
catch(e)
{
Response.write("出错原因:"+e.description)
Response.write("<br>更新失败!<a href=left.asp>返回</a>")
Response.end
}
Response.write("更新记录"+frm_unit+"成功!<br>")
Response.write("更新成功!<a href=left.asp>返回</a>")
Response.end
}
}
%>