📄 namecard_edit.asp
字号:
<%
'功能：编辑名片信息
'参数： request("caseid")=int #当前名片夹ID; request("page")=int #当前页码; request("Name")=chr #按该姓名查询名片
' request.form("addedit_subed")="true"#表单提交; request("id")#要编辑名片的ID;
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<%
'response.buffer=false
'------------------------------------------------设置参数
LoginID=trim(session("LoginID")) : if LoginID="" then LoginID=0 '当前用户ID
caseid=request("caseid") : if caseid="" then caseid=1 '当前名片夹ID
currentpage=request("page") : if currentpage="" then currentpage=1 '当前页码
SearchName=request("Name") '按该姓名查询名片
cid=request("id") '名片ID
'------------------------------------------------
'------------------------------------------------编辑记录
table="tbioaNamecard" '表名
if request.form("addedit_subed")="true" then
'表单提交后
Name=Request.Form("Name")'姓名
Unit=Request.Form("Unit")'单位
Possie=Request.Form("Possie")'职位
Email=Request.Form("Email")'E妹儿
OfficeTel=Request.Form("OfficeTel")'办公电话
HomeTel=Request.Form("HomeTel")'家庭电话
Mobile=Request.Form("Mobile")'手机
Homepage=Request.Form("Homepage")'主页
Address=Request.Form("Address")'地址
PostCode=Request.Form("PostCode")'邮政编码
Body=Request.Form("Body")'其他
CCaseID=Request.Form("CaseID")'其他
'编辑时使用的字段
field1=array("CaseID","Name","Unit","Possie","Email","OfficeTel","HomeTel","Mobile","Homepage","Address","PostCode","Body")
value1=array(CCaseID,Name,Unit,Possie,Email,OfficeTel,HomeTel,Mobile,Homepage,Address,PostCode,Body)
sql="UPDATE " & table & " SET "
for i=0 to ubound(field1)
sql = sql & field1(i) & "='" & replace(value1(i),"'","''") & "'"
if i <> ubound(field1) then sql=sql & "," else sql=sql & " where id=" & cid
next
oConn.Execute sql
word="<p>名片信息修改成功!</p><p><img border=0 src=../images/icon_show.gif align=left width=16 height=16><a href=namecard_index.asp?caseid="&caseid&"&Name="&SearchName&"&page="¤tpage&">返回名片夹</a>"
else'--------------------------------------------取记录
'取名片记录 （返回rs对象）
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from " & table & " where ID="&cid
rs.open sql,oConn,1,1
'------------------------------------------------取记录
'取名片夹记录 （返回rs1对象）
set rs1=Server.CreateObject("ADODB.RecordSet")
sql="select * from tbioaCardcase where UserID="&LoginID&" order by ID desc"
rs1.open sql,oConn,1,1
'------------------------------------------------
end if
'------------------------------------------------
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>main</title>
<base target="FrmMain">
<script src="../js/front_chec.js"></script>
<script language="JavaScript">
<!--
function require(form){
return checnull(form.Name,"请填写姓名！")
}
-->
</script>
</head>
<body topmargin="10" leftmargin="10">
<!--#include file="cardcase_menu.html"-->
<hr width="100%" size=1 color="#000000">
<!--#include file="namecard_head.html"-->
<%if request.form("addedit_subed")<>"true" then %>
<table width="100" border=0 cellspacing="0" cellpadding="0">
<tr>
<td width=100><img border=0 src=../images/icon_show.gif align=left width=16 height=16><a href="namecard_index.asp?caseid=<%=caseid%>&Name=<%=SearchName%>&page=<%=currentpage%>">返回名片夹</a></td>
</tr>
</table>
<%end if%>
<hr width="100%" size=1 color="#000000">
<br>
<div align="center">
<table width="550" cellspacing="1" cellpadding="2" class="tab">
<tr>
<td width="100%" class="tdTop">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="tdTop">
<p align="left"><img border="0" src="../images/icon_title.gif" align="left">编辑名片</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="25%" class="td1">
<% if request.form("addedit_subed")="true" then %>
<table border="0" width="100%" cellspacing="10" cellpadding="0">
<tr>
<td width="36%">
<p align="right"><img border="0" src="../images/edit.gif" width="32" height="32">
</td>
<td width="64%"><p> </p>
<%=word%>
</td>
</tr>
<tr>
<td width="100%" colspan="2">
</td>
</tr>
</table>
<% else %>
<form name="eventfrm" method="POST" action="" onSubmit="return require(this)">
<input type=hidden name="addedit_subed" value="true">
<table width="100%" cellspacing="3" cellpadding="2">
<tr>
<td width="12%" class="td1" align="right"><font COLOR="RED">*</font> 姓名:</td>
<td class="td1"><input type="text" name="Name" size="25" value="<%=Server.HTMLEncode(rs("Name"))%>" maxlength="50" class="input"></td>
<td width="12%" class="td1" align="right">职位:</td>
<td class="td1"><input type="text" name="Possie" size="25" value="<%=Server.HTMLEncode(rs("Possie"))%>" maxlength="50" class="input"></td>
</tr>
<tr>
<td class="td1" align="right">单位:</td>
<td class="td1"><input type="text" name="Unit" size="25" value="<%=Server.HTMLEncode(rs("Unit"))%>" maxlength="100" class="input"></td>
<td class="td1" align="right">网址:</td>
<td class="td1"><input type="text" name="Homepage" size="25" value="<%=Server.HTMLEncode(rs("Homepage"))%>" maxlength="100" class="input"></td>
</tr>
<tr>
<td class="td1" align="right">办公电话:</td>
<td class="td1"><input type="text" name="OfficeTel" size="25" value="<%=Server.HTMLEncode(rs("OfficeTel"))%>" maxlength="50" class="input"></td>
<td class="td1" align="right">家庭电话:</td>
<td class="td1"><input type="text" name="HomeTel" size="25" value="<%=Server.HTMLEncode(rs("HomeTel"))%>" maxlength="50" class="input"></td>
</tr>
<tr>
<td class="td1" align="right">手机:</td>
<td class="td1"><input type="text" name="Mobile" size="25" value="<%=Server.HTMLEncode(rs("Mobile"))%>" maxlength="50" class="input"></td>
<td class="td1" align="right">E-mail:</td>
<td class="td1"><input type="text" name="Email" size="25" value="<%=Server.HTMLEncode(rs("Email"))%>" maxlength="50" class="input"></td>
</tr>
<tr>
<td class="td1" align="right">地址:</td>
<td class="td1"><input type="text" name="Address" size="25" value="<%=Server.HTMLEncode(rs("Address"))%>" maxlength="100" class="input"></td>
<td class="td1" align="right">邮编:</td>
<td class="td1"><input type="text" name="PostCode" size="25" value="<%=Server.HTMLEncode(rs("PostCode"))%>" maxlength="50" class="input"></td>
</tr>
<tr>
<td class="td1" align="right" valign="top">其他:</td>
<td class="td1" colspan="3"><textarea rows="3" name="Body" cols="62" class="textarea"><%=Server.HTMLEncode(rs("Body"))%></textarea></td>
</tr>
<tr>
<td class="tdBottom" colspan="4"></td>
</tr>
<tr>
<td class="td1" align="right">名片夹:</d>
<td class="td1" colspan="3">
<select name="CaseID" size=1 class=fstyle style="WIDTH:135">
<%while not rs1.EOF '循环%>
<option value="<%=rs1("ID")%>" <%if rs1("ID")=cint(caseid) then response.write("selected")%>><%=rs1("Title")%></option>
<%rs1.MoveNext: wend%>
</select> (如果不移动该名片到其他名片夹，请不要改变该选项。)
</td>
</tr>
<tr>
<td class="td1" width="100%" colspan="4">
<input type="submit" value="确定" name="B1" class="button0" onmouseout=className="button0" onmouseover=className="button1"> <input type="reset" value="全部重写" name="B2" class="button0" onmouseout=className="button0" onmouseover=className="button1">
</td>
</tr>
</table>
</form>
<% end if %>
</td>
</tr>
<tr>
<td width="25%" class="tdBottom">
</td>
</tr>
</table>
</div>
</body>
</html>
<%'释放对象变量
oConn.close
%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -