📄 file_add_db.asp
字号:
<!--#INCLUDE FILE="data.asp" -->
<%
set rs=server.createobject("ADODB.recordset")
rs.Open "SELECT * FROM jhtdata Where ID is null",conn,1,3
rs.addnew
application("downdir")="download/"
if Session("Ulogin")<>"yes" then
Response.Redirect ("index.htm")
end if
ip= Request.ServerVariables("REMOTE_ADDR")
nowtime=now()
sj=cstr(year(nowtime))+"-"+cstr(month(nowtime))+"-"+cstr(day(nowtime))+" "+cstr(hour(nowtime))+":"+right("0"+cstr(minute(nowtime)),2)+":"+right("0"+cstr(second(nowtime)),2)
%>
<!--#include FILE="upload_5xsoft.inc"-->
<%
dim upload,file,formName,formPath,iCount,filename,fileExt,ranNum
set upload=new upload_5xsoft ''建立上传对象
formPath="download/"
iCount=0
for each formName in upload.objForm ''列出所有form数据
next
for each formName in upload.objFile ''列出所有上传了的文件
set file=upload.file(formName) ''生成一个文件对象
if file.filesize<100 then
response.write "<font size=2>请先选择你要上传的文件 [ <a href=# onclick=history.go(-1)>重新上传</a> ]</font>"
response.end
end if
fileExt=lcase(right(file.filename,4))
if fileEXT<>".gif" and fileEXT<>".jpg" and fileEXT<>".zip" and fileEXT<>".rar" and fileEXT<>".doc" then
response.write "<font size=2>文件格式不正确 [ <a href=# onclick=history.go(-1)>重新上传</a> ]</font>"
response.end
end if
randomize
ranNum=int(90000*rnd)+10000
filename=formPath&year(now)&month(now)&day(now)&hour(now)&minute(now)&second(now)&ranNum&fileExt
' filename=formPath&year(now)&month(now)&day(now)&hour(now)&minute(now)&second(now)&file.FileName
if file.FileSize>0 then ''如果 FileSize > 0 说明有文件数据
file.SaveAs Server.mappath(FileName) ''保存文件
else
response.write "未找到文件 <A HREF=javascript:history.back(1)>返回</A>"
response.end
end if
next
rs("type") ="1"
rs("tname") =upload.form("Rname")
rs("part") = upload.form("Upart")
rs("title") = upload.form("biaoti")
rs("ttext") = upload.form("Rname")&"的上传文件"
rs("html") =filename
rs("IP")=ip
rs("time")=sj
rs("fjname")=file.FileName
rs.Update
rs.close
Set rs=nothing
Conn.Close
Set Conn=nothing
%>
<LINK href="oa.css" rel=stylesheet>
<BODY bgColor=#ffffff leftMargin=0
style="BACKGROUND-ATTACHMENT: scroll; BACKGROUND-IMAGE: url('images/main_bg.gif'); BACKGROUND-POSITION: left bottom; BACKGROUND-REPEAT: no-repeat"
topMargin=0>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD bgColor=#4e5960 class=heading colSpan=2 height=3></TD></TR>
<TR>
<TD bgColor=#4e5960 class=heading> <FONT
color=#ffffff><B>上报文件</B></FONT></TD>
<TD align=right bgColor=#4e5960 class=heading height=20></TD></TR>
<TR>
<TD align=middle vAlign=top width=109></TD>
<TD align=middle>
<TABLE bgColor=#666666 border=0 cellPadding=1 cellSpacing=1
width="100%">
<TR>
<TD bgColor=#efefef>文件已经成功上报，是否继续添加……<BR>
<P>上报人：<%=upload.form("Rname")%><BR>
单 位：<%=upload.form("Upart")%><BR>
说 明：<%=upload.form("biaoti")%><BR>
<P><P><A HREF="addfile.asp">继续添加</A> <A HREF="images/oa_menu.swf">返回主页</A></TD>
</TR>
</table>
</td></tr></table>
<%set upload=nothing ''删除此对象
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -