📄 testatesort.asp

📁 OFFICE办公自动化
💻 ASP
字号:
<%
'功能：编辑会员等级
'作者：展亮
'日期：2003-12-2 12:00
'参数：	request.form("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
'------------------------------------------------
'------------------------------------------------修改记录
table="TbioaHrmTestateSort" '表名
if request.form("subed")="增加" then
'表单提交后

	'接受录入参数
	input_name=Request.Form("input_name")'种类名称
	input_nsqx=Request.Form("input_nsqx")'年审期限


	'添加时使用的字段
	field1=array("name","nsqx")
	value1=array(input_name,input_nsqx)

	for i=0 to ubound(field1)
		value1(i)=replace(value1(i),"'","''")
	next
	sql = "INSERT INTO " & table & " (" & Join(field1, ",") & ") VALUES ('" & Join(value1, "','") & "')"
	On Error Resume Next
	oConn.Execute sql
	If Err.Number <> 0 Then
		response.write "<script>alert('证书种类已经存在！')</script>"
		Err.Clear
	End If
end if

if request.form("subed")="修改" then
'表单提交后

	'接受录入参数
	id=Request.Form("id")'记录号
	input_name=Request.Form("input_name")'种类名称
	input_nsqx=Request.Form("input_nsqx")'年审期限


	'添加时使用的字段
	field1=array("name","nsqx")
	value1=array(input_name,input_nsqx)

	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='" & id & "'"
	next
	On Error Resume Next
	oConn.Execute sql
	If Err.Number <> 0 Then
		response.write "<script>alert('证书种类已经存在！')</script>"
		Err.Clear
	End If
end if
if request.form("subed")="删除" then
'表单提交后
	'接受录入参数
	id=Request.Form("id")'记录号

	oConn.Execute "DELETE FROM " & table & " WHERE ID='" & id & "'"
end if

set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from " & table & " order by id"
rs.open sql,oConn,1,1
'------------------------------------------------
%>


<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>编辑上岗证种类</title>
<script src="../js/front_chec.js"></script>
<script language="JavaScript">
<!--
 function require(form){
	return	checnull(form.input_name,"请填写上岗证名称！")&&
	checnull(form.input_nsqx,"请填写年审期限！")&&
	checplusint(form.input_nsqx,"年审期限必须为正整数！")&&
	1==1;
 }
-->
</script>
</head>
<body topmargin="10" leftmargin="10">
<br>
<div align="center">
<table cellspacing="1" cellpadding="4" class="tab">
  <tr>
    <td width="100%" class="tdBottom" valign="top">
      <table width="100%" cellspacing="1" cellpadding="2" class="tab">
        <tr>
          <td width="100%" class="tdTop">
	    <table border="0" width="100%" cellspacing="0" cellpadding="0">
	      <tr>
	        <td class="tdTop2">
	          <img border="0" src="../images/icon_title.gif" align="left">维护上岗证种类
	        </td>
	      </tr>
	    </table>
          </td>
        </tr>
        <tr>
          <td class="td1">
              <table border="0" width="100%" cellspacing="1" cellpadding="2" class="tab">
                <tr class="td1">
                <form name="eventfrm" method="POST" action="" onSubmit="return require(this)">
                  <td nowrap colspan="5">
                  　上岗证名称：<INPUT type=text size=15 name=input_name maxlength="50" class=input>
                  　年审期限：<INPUT type=text size=8 name=input_nsqx maxlength="5" class=input>（年）
                  　<input type="submit" value="增加" name="subed" class="button0" onmouseout=className="button0" onmouseover=className="button1">
                  </td>
                </form>
                </tr>
                <tr>
                  <td class="tdtop" nowrap>上岗证名称</td>
                  <td class="tdtop" nowrap>年审期限</td>
                  <td class="tdtop" colspan="2" width=80 nowrap>操作</td>
                </tr>
                <%while not rs.eof%>
	        <tr>
	        <form name="eventfrm" method="POST" action="" onSubmit="return require(this)">
	          <input type="hidden" name="id" size=40 value="<%=rs("id")%>">
	          <td nowrap class="td2">
	            <input type="text" name="input_name" size=40 maxlength="50" value="<%=htmlout(rs("name"))%>" class="button0" onmouseout=className="button0" onmouseover=className="button1">
	          </td>
	          <td nowrap class="td2">
	            <input type="text" size=8 maxlength="2" value="<%=rs("nsqx")%>" name="input_nsqx" class="button0" onmouseout=className="button0" onmouseover=className="button1">
	          </td>
	          <td nowrap class="td2" width=40>
	            <input type="submit" value="修改" name="subed" class="button0" onmouseout=className="button0" onmouseover=className="button1">
	          </td>
	          <td nowrap class="td2" width=40>
	            <input type="submit" value="删除" name="subed" class="button0" onmouseout=className="button0" onmouseover=className="button1" onClick="return confirm('删除证书种类将删除相关证书的年审记录\n确定要删除该证书种类吗？\n该操作不可恢复！')">
	          </td>
          </form>
	        </tr>
                <%
                  rs.movenext
                wend
                %>
              </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</div>
</body>

</html>

<%'释放对象变量
rs.close
oConn.close
%>
⌨️ 快捷键说明

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