📄 staff_add.asp
字号:
<!-- #include file="Include/Chk.asp" -->
<!-- #include file="Conn.asp" -->
<%
if Request.QueryString("Action")="add" 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&"'"
rs2.open SQL2,conn,1,1
if not rs2.eof then
rs2.Close
Set rs2=Nothing
Response.Write "<script language='javascript'>alert('系统中已存在您输入的证书编号!');history.go(-1);</script>"
Response.End()
else
rs2.Close
Set rs2=Nothing
end if
end if
SQL="Select * from Staff"
set rs=server.createobject("Adodb.Recordset")
rs.open SQL,conn,1,3
rs.AddNew
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=add">
<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" size="15" maxlength="15" style="ime-mode:disabled"/>
* 不能与现有记录重复，1-15位数字</td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">学员姓名：</td>
<td height="25" align="left" valign="middle">
<input name="name" type="text" id="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" size="15" maxlength="18" style="ime-mode:disabled" />
* 必须为数字</td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#efefef">认证专业：</td>
<td height="25" align="left" valign="middle">
<input name="dep" type="text" id="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" 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",conn,1,1
If fs.RecordCount=0 Then
Response.Write "<option value=''>未设置证书类别</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" size="15" maxlength="10" style="ime-mode:disabled" />
* </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" size="15" maxlength="10" style="ime-mode:disabled" />
* </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" size="15" maxlength="10" style="ime-mode:disabled" />
* </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">带
* 的项目为必填内容</span> </td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -