?? file_edit.asp
字號:
<%
'功能：編輯文件信息
'參數：request("typeid")=int #當前文件夾ID; request("page")=int #當前頁碼; request.form("addedit_subed")="true"#表單提交
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<%
'response.buffer=false
'------------------------------------------------設置參數
LoginID=trim(session("LoginID")) : if LoginID="" then LoginID=0 '當前用戶ID
typeid=request("typeid") : if typeid="" then typeid=1 '當前文件夾ID
currentpage=request("page") : if currentpage="" then currentpage=1 '當前頁碼
SearchName=request("Name") '按該文件名查詢文件
fid=request("id") '文件ID
'------------------------------------------------
'------------------------------------------------修改記錄
table="tbioaDownloadFile" '表名
if request.form("addedit_subed")="true" then
'表單提交后
name=Request.Form("name")'文件名
Body=Request.Form("Body")'文件說明
stypeid=Request.Form("stypeid")'文件夾
'編輯時使用的字段
field1=array("name","Body","typeid")
value1=array(name,Body,stypeid)
sql="UPDATE " & table & " SET "
for i=0 to ubound(field1)
sql = sql & field1(i) & "='" & replace(value1(i),"'","''") & "'"
if i <> ubound(field1) then sql=sql & "," else sql=sql & " where id=" & fid
next
oConn.Execute sql
word="<p>文件信息修改成功!</p><p><img border=0 src=../images/icon_show.gif align=left width=16 height=16><a href=file_index.asp?typeid=" & typeid & "&page=" & currentpage & "&Name=" & SearchName & ">返回文件夾</a>"
else'--------------------------------------------取記錄
'取文件記錄 （返回rs對象）
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from " & table & " where ID="&fid
rs.open sql,oConn,1,1
end if
'------------------------------------------------
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>main</title>
<base target="FrmMain">
<script src="../js/front_chec.js"></script>
<script language="JavaScript">
<!--
function require(form){
return checnull(form.name,"請填寫文件名！")
}
-->
</script>
</head>
<body topmargin="10" leftmargin="10">
<!--#include file="menu.html"-->
<hr width="100%" size=1 color="#000000">
<!--#include file="file_head.html"-->
<table width="100" border=0 cellspacing="0" cellpadding="0">
<tr>
<td width=100><img border=0 src=../images/icon_show.gif align=left width=16 height=16><a href="file_index.asp?typeid=<%=typeid%>&page=<%=currentpage%>&Name=<%=SearchName%>">返回文件夾</a></td>
</tr>
</table>
<hr width="100%" size=1 color="#000000">
<br>
<div align="center">
<table width="350" cellspacing="1" cellpadding="2" class="tab">
<tr>
<td width="100%" class="tdTop">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="tdTop">
<p align="left"><img border="0" src="../images/icon_title.gif" align="left">編輯文件信息</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="25%" class="td1">
<% if request.form("addedit_subed")="true" then %>
<table border="0" width="100%" cellspacing="10" cellpadding="0">
<tr>
<td width="36%">
<p align="right"><img border="0" src="../images/edit.gif" width="32" height="32">
</td>
<td width="64%"><p> </p>
<%=word%>
</td>
</tr>
<tr>
<td width="100%" colspan="2">
</td>
</tr>
</table>
<% else %>
<form name="eventfrm" method="POST" action="" onSubmit="return require(this)">
<input type=hidden name="addedit_subed" value="true">
<table width="100%" cellspacing="3" cellpadding="2">
<tr>
<td class="td1" align="right">文件夾:</d>
<td class="td1" colspan="3">
<select name="stypeid" size=1 class=fstyle style="WIDTH:135">
<%call pOptions2("tbioaDownload_sort","name",0,rs("typeid"),"","Pid")%>
</select>
<%'call pOptions2("tbioaDownload_sort","name",0,rs("typeid"),"","Pid")%>
</td>
</tr>
<tr>
<td width="70" class="td1" align="right"><font COLOR="RED">*</font> 文件名:</td>
<td class="td1"><input type="text" name="name" value="<%=Server.HTMLEncode(rs("name"))%>" size="30" maxlength="50" class="input"></td>
</tr>
<tr>
<td width="70" class="td1" align="right">文件:</td>
<td class="td1"><input type="text" name="url" value="<%=Server.HTMLEncode(rs("url"))%>" size=30 class="input" disabled></td>
</tr>
<tr>
<td width="70" class="td1" align="right">介紹:</td>
<td class="td1"><textarea rows=5 name="body" cols=30 class=fstyle><%=Server.HTMLEncode(rs("body"))%></textarea></td>
</tr>
<tr>
<td class="tdBottom" colspan="2"></td>
</tr>
<tr>
<td class="td1" width="100%" colspan="4">
<input type="submit" value="確定" name="B1" class="button0" onmouseout=className="button0" onmouseover=className="button1"> <input type="reset" value="全部重寫" name="B2" class="button0" onmouseout=className="button0" onmouseover=className="button1">
</td>
</tr>
</table>
</form>
<%
rs.close
end if
%>
</td>
</tr>
<tr>
<td width="25%" class="tdBottom">
</td>
</tr>
</table>
</div>
</body>
</html>
<%'釋放對象變量
oConn.close
%> ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -