wuzi_edit_save.asp

对学校物资管理系统的一份设计

<!--#include file = "Startup.asp"-->
<!-- #include file="Function.asp" -->
<%
call adminer()
Call ComeUrl()
Call jifanggl()
%>

<%
id=request("id")
bianhao=request("bianhao")
wzname=request("wzname")
danwei=request("danwei")
danjia=request("danjia")
gongyin=request("gongyin")
jbtime=request("jbtime")
baoxiou=request("baoxiou")
shcoolname=request("shcoolname")
bmname=request("bmname")
jfcode=request("jfcode")
office=request("office")
jieyon=request("jieyon")
wzclass=request("wzclass")
zhuangtai=request("zhuangtai")
cpu=request("cpu")
zhuban=request("zhuban")
disk=request("disk")
leicuen=request("leicuen")
xianka=request("xianka")
xianshiqi=request("xianshiqi")
shenka=request("shenka")
wangka=request("wangka")
jixiang=request("jixiang")
cdrom=request("cdrom")
yinxiang=request("yinxiang")
jianpan=request("jianpan")
shubiao=request("shubiao")
beizhu=request("beizhu")

set rs=server.createObject("adodb.recordset")
sql="select * from cangku where id="&id
rs.open sql,oconn,1,2
rs("编号")=bianhao
rs("名称")=wzname
rs("单位")=danwei
rs("单价")=danjia
rs("供应商")=gongyin
rs("质保起始时间")=jbtime
rs("报修记录")=baoxiou
rs("所属校区")=shcoolname
rs("所属部门")=bmname
rs("所属办公室")=office
rs("所属机房")=jfcode
rs("借用记录")=jieyon
rs("所属分类")=wzclass
rs("状态")=zhuangtai
rs("cpu")=cpu
rs("主板")=zhuban
rs("硬盘")=disk
rs("内存")=leicuen
rs("显卡")=xianka
rs("显示器")=xianshiqi
rs("声卡")=shenka
rs("网卡")=wangka
rs("机箱")=jixiang
rs("光驱")=cdrom
rs("音箱")=yinxiang
rs("键盘")=jianpan
rs("鼠标")=shubiao
rs("备注")=beizhu

rs.update
rs.close

set rs=server.createobject("adodb.recordset")
sql="select * from rizhi"
rs.open sql,oConn,1,2
rs.addnew
rs("操作人")=session("username")
rs("操作时间")=date()
rs("操作介绍")="修改操作"
rs("物资名")=wzname
rs("物资ID")=id
rs.update
rs.close

response.write"<center><font color=red>修改成功</font></center><br>"
response.write"<center><a href=wuzi_magic.asp target='_self'>返回</a></center><br>"
%>