?? staff_edit.asp
字號:
<!-- #include file="Include/Chk.asp" -->
<!-- #include file="Conn.asp" -->
<%
id=Request.QueryString("id")
if id="" then
Response.Write "<script language='javascript'>alert('參數(shù)錯誤!');history.go(-1);</script>"
Response.End()
end if
set rs=server.createobject("Adodb.Recordset")
sql="Select * from Staff where id="&id
rs.open sql,conn,1,3
if rs.eof then
Response.Write "<script language='javascript'>alert('沒有指定的證書');history.go(-1);</script>"
Response.End()
else
bid=rs("bid")
name=rs("name")
sid=rs("sid")
cate=rs("cate")
dep=rs("dep")
source=rs("source")
bs=rs("bs")
sj=rs("sj")
cname=rs("cname")
rs.Close
end if
if Request.QueryString("Action")="edit" then
dim bid,name,sid,cate,dep,source,bs,sj,cname
bid= Trim(Request.Form("bid"))
name= Trim(Request.Form("name"))
sid= Trim(Request.Form("sid"))
cate= Trim(Request.Form("cate"))
dep= Trim(Request.Form("dep"))
source= Trim(Request.Form("source"))
bs= Trim(Request.Form("bs"))
sj= Trim(Request.Form("sj"))
cname= Trim(Request.Form("cname"))
if bid="" or name="" or sid="" or cate="" or dep="" or source="" or bs="" or sj="" or cname="" then
Response.Write "<script language='javascript'>alert('帶*號的必須填寫!');history.go(-1);</script>"
Response.End()
else
set rs2=server.createobject("Adodb.Recordset")
SQL2="Select * from Staff where bid='"&bid&"' and id<>"&id
rs2.open SQL2,conn,1,1
if not rs2.eof then
rs2.Close
Set rs2=Nothing
Response.Write "<script language='javascript'>alert('系統(tǒng)中已存在您輸入的證書編號!');history.go(-1);</script>"
Response.End()
else
rs2.Close
Set rs2=Nothing
end if
end if
SQL="Select * from Staff where id="&id
rs.open SQL,conn,1,3
rs("bid")=bid
rs("name")=name
rs("sid")=sid
rs("cate")=cate
rs("dep")=dep
rs("source")=source
rs("bs")=bs
rs("sj")=sj
rs("cname")=cname
rs.Update
rs.Close
Set rs=Nothing
Response.Write "<script language='javascript'>alert('成功修改了一條證書記錄 !');document.location.href('Staff_Manage.asp');</script>"
Response.End()
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<link href="Images/default.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" name="form1" method="post" action="?Action=edit&id=<%=id%>">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td height="24" colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="82" height="24" align="center" valign="middle" background="Images/t_1.gif" class="AddGoods"><a href="#">添加證書信息</a></td>
<td width="1" align="center" valign="middle"></td>
<td width="88" height="24" align="center" valign="bottom" class="AddGoods"><table width="88" height="22" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle" background="Images/t_2.gif"><a href="Staff_Manage.asp" class="AddGoods">管理證書信息</a></td>
</tr>
</table></td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="5" colspan="2" background="Images/topnav.gif"></td>
</tr>
<tr>
<td height="5" colspan="2"></td>
</tr>
<tr>
<td width="11%" height="25" align="right" valign="middle" bgcolor="#efefef">證書編號：</td>
<td width="89%" height="25" align="left" valign="middle">
<input name="bid" type="text" id="bid" style="ime-mode:disabled" value="<%=bid%>" size="15" maxlength="15"/>
* 不能與現(xiàn)有記錄重復(fù)，1-15位數(shù)字</td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">學(xué)員姓名：</td>
<td height="25" align="left" valign="middle">
<input name="name" type="text" id="name" value="<%=name%>" size="15" maxlength="5" />
* 不能超過5個字 </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">身份證號：</td>
<td height="25" align="left" valign="middle">
<input name="sid" type="text" id="sid" style="ime-mode:disabled" value="<%=sid%>" size="15" maxlength="18" />
* 必須為數(shù)字</td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">認證專業(yè)：</td>
<td height="25" align="left" valign="middle">
<input name="dep" type="text" id="dep" value="<%=dep%>" size="15" maxlength="20" />
* 不能超過20個字</td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">證書名稱：</td>
<td height="25" align="left" valign="middle">
<input name="cname" type="text" id="cname" value="<%=cname%>" size="15" maxlength="20" />
* 不能超過20個字</td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">證書類別：</td>
<td height="25" align="left" valign="middle">
<select name="Cate" id="Cate">
<%
set fs=server.createobject("adodb.recordset")
fs.open "select * from Cate where id="&cate,conn,1,1
if fs.eof then
Response.Write "<option value=''>類別設(shè)置錯誤</option>"
else
%><option value="<%=Trim(fs("id"))%>"><%=Trim(fs("Catename"))%></option><%
end if
fs.Close
fs.open "select * from Cate",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option value=''>未設(shè)置證書類別</option>"
Else
Do While Not fs.EOF
%>
<option value="<%=Trim(fs("id"))%>"><%=Trim(fs("Catename"))%></option>
<%
fs.MoveNext
Loop
End If
fs.Close
Set fs=nothing
%>
</select>
*</td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">總 成 績：</td>
<td height="25" align="left" valign="middle">
<input name="source" type="text" id="source" style="ime-mode:disabled" value="<%=source%>" size="15" maxlength="10" />
* </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">筆試成績：</td>
<td height="25" align="left" valign="middle">
<input name="bs" type="text" id="bs" style="ime-mode:disabled" value="<%=bs%>" size="15" maxlength="10" />
* </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">上機成績：</td>
<td height="25" align="left" valign="middle">
<input name="sj" type="text" id="sj" style="ime-mode:disabled" value="<%=sj%>" size="15" maxlength="10" />
* </td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef"> </td>
<td height="25" align="left" valign="middle">
<input type="submit" name="Submit" value="修 改" />
<span class="C_Title">
<input name="button" type="button" onclick="history.back(-1)" value="返 回" />
帶
* 的項目為必填內(nèi)容</span> </td>
</tr>
</table>
</form>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -