📄 salarycheck.asp

📁 财务管理系统报账等基本功能实现有完整的实现

💻 ASP

字号:

<!--#include file="../../conndb.asp"-->
<html>
<head>
<title>审核调薪信息</title>
</head>
<body>
<%
 Dim sid,eid,nSal
 Set rs = Server.CreateObject("ADODB.RECORDSET")
 sid = Request.QueryString("sid")
 '更改此项目信息
 sql="Update Salary Set Flag=1 Where Id=" & sid
 Set rs = conn.Execute(sql)
 '读取调薪的员工编号和调薪后工资
 sql = "Select EmpId,NewSalary From Salary Where Id=" & sid
 Set rs = conn.Execute(sql)
 If Not rs.EOF Then
   eid = rs("EmpId")
   nSal = rs("NewSalary")
   '更改此员工的基本工资信息
   sql = "Update Employees Set Salary=" & nSal & " Where EmpId=" & eid
   Set rs = conn.Execute(sql)
 End If
 Response.Write "<h3>调薪信息成功审核</h3>"
 Set rs = Nothing
%>
</body>
<script language="javascript">
  // 刷新父级窗口，延迟此关闭
  opener.location.reload();
  setTimeout("window.close()",600);
</script>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -