📄 taxedit.asp

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

💻 ASP

字号:

<!--#include file="../../conndb.asp"-->
<html>
<head>
<title>编辑工资税率</title>
<link rel="stylesheet" href="../../style.css">
<Script Language="JavaScript">
//域校验
function CheckFlds(){
  if (document.form1.lower.value==""){
   alert("请输入税率下限金额！");
   form1.lower.focus;
   return false;
 } 
  if (document.form1.upper.value==""){
   alert("请输入税率上限金额！");
   form1.upper.focus;
   return false;
 } 
return true;
}
</Script>
</head>
<%
  Dim TaxId,uLimit,lLimit,Rate,Deduct
  Dim Action
  '变量初始化
  Action = "add"
  uLimit = 0
  lLimit = 0
  Rate = 0
  Deduct = 0
  '读取参数action
  Action = Request.QueryString("action")
  TaxId = Request.QueryString("tid")  
  '编辑工资税率记录
  If Action = "edit" Then
    '设置SELECT语句，读取税率记录数据
    sql = "Select *,(CONVERT(varchar,Rate)) AS rt From TaxRate Where Id=" & TaxId
    Set rs = Conn.Execute(sql)
    If Not rs.EOF Then
      lLimit = rs("LowerLimit")
      uLimit = rs("UpperLimit")
      Rate = rs("rt")
      Deduct = rs("Deduct")
   End If
  End If
%>
<body leftmargin="1" topmargin="0">
<form name="form1" method="POST" action="TaxSave.asp?action=<%=Action%>&tid=<%=TaxId%>" onsubmit="return CheckFlds()">
<br>
 <table align="center" border="1" cellspacing="0" width="96%" bordercolor="#64B9E1" bordercolorlight="#64B9E1" bordercolordark="#FFFFFF">
    <tr>
      <td bgcolor="#FFFFFF" colspan="4" background="../pic/tax.jpg" height="90">
      <p align="center"><b><font face="华文彩云" color="#000080" size="6">工资税率信息</font></b></p>
      </td>
    </tr>
    <tr>
      <td width="30%" bgcolor="#CEE7FF">下限金额</td>
      <td width="70%"><input type="text" name="lower" size="20" value="<%=lLimit%>">&nbsp;</td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">上限金额</td>
      <td><input type="text" name="upper" size="20" value="<%=uLimit%>">&nbsp;</td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">税率</td>
      <td><input type="text" name="rate" size="20" value="<%=Rate%>">&nbsp;</td>
    </tr>
    <tr>
      <td bgcolor="#CEE7FF">速算扣除数</td>
      <td><input type="text" name="deduct" size="20" value="<%=Deduct%>">&nbsp;</td>
    </tr>
 </table>
  <p align=center><input type="submit" value=" 提 交 " name="B1">
  <input type="reset" value=" 重 写 " name="B2"></p>
</form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -