📄 jingfeisave.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("admin")="" then
response.redirect "admin.asp"
end if
%>
<%
dim rs,sql
dim title
dim content
dim sbbh,sbmc
dim classid,Nclassid
dim Nkey
dim price
dim images
dim state
dim errmsg
dim recommend
dim founderr
founderr=false
if trim(request.form("xmm"))="" then
founderr=true
errmsg="<li>项目名称不能为空</li>"
end if
if trim(request.form("xmsx"))="" then
founderr=true
errmsg=errmsg+"<li>项目属性不能为空</li>"
end if
if trim(request.form("xmfzr"))="" then
founderr=true
errmsg=errmsg+"<li>项目负责人不能为空</li>"
end if
if trim(request.form("jfly"))="" then
founderr=true
errmsg=errmsg+"<li>经费来源不能为空</li>"
end if
if trim(request.form("jbr"))="" then
founderr=true
errmsg=errmsg+"<li>经办人不能为空</li>"
end if
if trim(request.form("rq"))="" then
founderr=true
errmsg=errmsg+"<li>立项日期不能为空</li>"
end if
set rs=server.createobject("adodb.recordset")
if request("action")="add" then
call newsoft()
elseif request("action")="edit" then
call editsoft()
else
founderr=true
errmsg=errmsg+"<li>没有选定参数</li>"
end if
sub newsoft()
sql="select * from jingfei "
rs.open sql,conn,1,3
rs.addnew
rs("xmm")=trim(request.form("xmm"))
rs("xmsx")=trim(request.form("xmsx"))
rs("xmfzr")=trim(request.form("xmfzr"))
rs("zc")=trim(request.form("zc"))
rs("sr")=trim(request.form("sr"))
rs("jfly")=trim(request.form("jfly"))
rs("jbr")=trim(request.form("jbr"))
rs("rq")=trim(request.form("rq"))
rs.update
sbbh=rs("xmm")
sbmc=rs("xmsx")
end sub
sub editsoft()
sql="select * from product where productid="&request("id")
rs.open sql,conn,1,3
rs("title")=title
rs("content")=content
rs("Nclassid")=Nclassid
rs("classid")=classid
rs("images")=images
rs("Nkey")=Nkey
if request.form("recommend")="1" then
recommend=1
else
recommend=2
end if
if request.form("price")<>"" then
rs("price")=trim(request.form("price"))
end if
if request.form("state")<>"" then
rs("state")=trim(request.form("state"))
end if
rs.update
productid=rs("productid")
end sub
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="../include/STYLE.CSS">
</head>
<body>
<div align="center"><center>
<br><br>
<table class="border" align=center width="50%" border="0" cellpadding="4" cellspacing="0" bordercolor="#999999">
<tr align=center>
<td width="100%" class="title" height="20"><b>
<%if request("action")="add" then%>
添加
<%else%>
修改
<%end if%>
设备成功</b></td>
</tr>
<tr>
<td class="tdbg"><p align="left"><br>
项目名称为：
<%response.write sbbh%>
<br>
项目属性为：
<%response.write sbmc%>
</p>
您可以进行其他操作
</td>
</tr>
</table>
</center></div>
<%
%>
</body>
</html>
<%
sub Error()
response.write " <html><head><link rel='stylesheet' href='/include/STYLE.CSS'></head><body>"
response.write " <br><br><br>"
response.write " <table align='center' width='300' border='0' cellpadding='4' cellspacing='0' class='border'>"
response.write " <tr > "
response.write " <td class='title' colspan='2' height='15'> "
response.write " <div align='center'>由于以下的原因不能保存数据!</div>"
response.write " </td>"
response.write " </tr>"
response.write " <tr> "
response.write " <td align=center class='tdbg' colspan='2' height='23'> "
response.write " <br>"
response.write errmsg& " <br><br>"
response.write " <a href='javascript:onclick=history.go(-1)'>返回</a>"
response.write " <br><br></td>"
response.write " </tr> </table></body></html>"
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -