⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 dx_expense_edit.asp

📁 功能介绍: 1、产品入库
💻 ASP
字号:
<!--#include file="inc/config.asp"-->
<!--#include file="inc/Dx_admin_check.asp"-->
<%
if request.Form.count>0 then
dx_expense_id=request.QueryString("dx_expense_id")
dx_expense_out=request.Form("dx_expense_out")
dx_expense_title=request.Form("dx_expense_title")
dx_expense_user=request.Form("dx_expense_user")
if len(dx_expense_out)=0 then
call showerr("请输入支出金额!","1")
end if
if len(dx_expense_title)=0 then
call showerr("请输入支出理由","1")
end if
sqlstr="select * from [dx_expense] where dx_expense_id="& dx_expense_id
rs.open sqlstr,conn,1,3
dx_de_out=rs("dx_expense_out")-cdbl(dx_expense_out)
if not rs.eof then
rs("dx_expense_out")=cdbl(dx_expense_out)
rs("dx_expense_title")=dx_expense_title
rs("dx_expense_user")=dx_expense_user
rs("dx_expense_time")=now()
rs.update
end if
rs.close
sqlstr="select * from [dx_site]"
rs.open sqlstr,conn,1,3
rs("dx_site_money")=rs("dx_site_money")+cdbl(dx_de_out)
rs.update
rs.close
call showerr("修改成功!","dx_expense_list.asp")
else
dx_expense_id=request.QueryString("dx_expense_id")
sqlstr="select * from [dx_expense] where dx_expense_id="& dx_expense_id
rs.open sqlstr,conn,1,3
if not rs.eof then
dx_expense_out=rs("dx_expense_out")
dx_expense_title=rs("dx_expense_title")
dx_expense_user=rs("dx_expense_user")
rs.update
end if
rs.close
end if
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>其它支出</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/style.css" rel="stylesheet" type="text/css">
<style>
body {
	background-color:#FFFFFF;
}
</style>
</HEAD>

<BODY>
<%
if session("Dx_Admin")="" then
%>
<br><center><img src="Images/note.gif" align="absmiddle">&nbsp;<font color="#FF0000">你不具备此权限,请与管理员联系!</font></center>
<%  
  response.end
end if
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
<tr>
<td><img src="Images/r_1.gif" alt="" /></td>
<td width="100%" background="Images/r_0.gif">
  <table cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td>&nbsp;其它支出</td>
	  <td align="right">&nbsp;</td>
    </tr>
  </table>
</td>
<td><img src="Images/r_2.gif" alt="" /></td>
</tr>
<tr>
<td></td>
<td>
<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">
	  <form name="form1" method="post" >	  
	  <tr>
        <td align="right" height="30">支出金额:</td>
        <td class="category">&nbsp;
		<input name="dx_expense_out" type="text" onKeyUp="if(isNaN(value))execCommand('undo')" onafterpaste="if(isNaN(value))execCommand('undo')" value="<%=dx_expense_out%>">
		</td>
      </tr>
	  <tr>
	    <td align="right" height="30">支出理由:</td>
	    <td class="category">&nbsp;
		<input name="dx_expense_title" type="text" id="title" size="50" value="<%=dx_expense_title%>"></td>
	  </tr>  
	  <tr>
	  <td height="30" align="right">添加人:</td>
	  <td class="category">&nbsp;
	  <input name="dx_expense_user" type="text" value="<%=dx_expense_user%>"></td>
	  </tr>
      <tr>
	    <td height="30">&nbsp;</td>
        <td class="category">
		  <input type="submit" value=" 提交确认" onClick="return check1()" class="button">
		  <input type="reset" value=" 重新填写 " class="button">		  </td>
      </tr>
	  </form>
</table>
</td>
<td></td>
</tr>
<tr>
<td><img src="Images/r_4.gif" alt="" /></td>
<td></td>
<td><img src="Images/r_3.gif" alt="" /></td>
</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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