?? rdownload_edit.asp
字號:
<%
'功能：增加檔案庫信息
'參數(shù)：request.form("addedit_subed")="true"#表單提交;
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<%
'response.buffer=false
'------------------------------------------------設置參數(shù)
LoginID=trim(session("LoginID")) : if LoginID="" then LoginID=0 '當前用戶ID
cid=request("id") '檔案庫ID
Typeid=request("Typeid") : if Typeid="" then Typeid=0 '當前欄目ID
'------------------------------------------------
'------------------------------------------------增加記錄
table="tbioaDownload_sort" '表名
if request.form("addedit_subed")="true" then
'表單提交后
input_name=Request.Form("input_name")'標題
input_viewer=Request.Form("input_viewer")'查看者
input_viewermod=Request.Form("input_viewermod")'查看者屬性
input_viewdirmod=Request.Form("input_viewdirmod")'查看目錄屬性
input_manager=Request.Form("input_manager")'管理者
input_managermod=Request.Form("input_managermod")'管理者屬性
input_remark=Request.Form("input_remark")'備注
'編輯時使用的字段
field1=array("name","viewer","viewermod","viewdirmod","manager","managermod","remark","mdate")
value1=array(input_name,input_viewer,input_viewermod,input_viewdirmod,input_manager,input_managermod,input_remark,date&" "&time)
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=" & cid
next
oConn.Execute sql
set rs_id=Server.CreateObject("ADODB.RECORDSET")
rs_id.Open "SELECT MAX(id) AS id FROM " & table,oConn
word="<p>檔案庫信息已成功修改!</p><p><img border=0 src=../images/icon_show.gif align=left width=16 height=16><a href='javascript: history.back()'>繼續(xù)修改</a>"
rs_id.close
else'------------------------------------------------取記錄
'取檔案庫記錄 （返回rs對象）
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from " & table & " where ID="&cid
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.input_name,"請?zhí)顚憴n案庫名稱！") &&
checnull(form.viewer,"請設置檔案庫查詢權限！") &&
checnull(form.manager,"請設置檔案庫管理權限！")
}
function doSel_Cx(sCxqx,sCxqxsz){
url = "../inc/SelectQx.asp?cxqx="+sCxqx+"&cxqxsz="+sCxqxsz
k=showModalDialog(url,"","dialogWidth:510px;status:no;dialogHeight:60px")
if (k!="") {
k=k.split("_")
if (k[0]!="0"){
eventfrm1.viewer.value=k[2].replace(/ /g,"\n")
eventfrm1.input_viewer.value=k[1]
eventfrm1.input_viewermod.value=k[0]
}else{
eventfrm1.viewer.value='全部人員'
eventfrm1.input_viewer.value=k[1]
eventfrm1.input_viewermod.value=k[0]
}
}
}
function doSel_Gl(sCxqx,sCxqxsz){
url = "../inc/SelectQx.asp?cxqx="+sCxqx+"&cxqxsz="+sCxqxsz
k=showModalDialog(url,"","dialogWidth:510px;status:no;dialogHeight:60px")
if (k!="") {
k=k.split("_")
if (k[0]!="0"){
eventfrm1.manager.value=k[2].replace(/ /g,"\n")
eventfrm1.input_manager.value=k[1]
eventfrm1.input_managermod.value=k[0]
}else{
eventfrm1.manager.value='全部人員'
eventfrm1.input_manager.value=k[1]
eventfrm1.input_managermod.value=k[0]
}
}
}
-->
</script>
</head>
<body topmargin="10" leftmargin="10">
<!--#include file="menu.html"-->
<hr width="100%" size=1 color="#000000">
<br>
<div align="center">
<table width="580" 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>
<td class="tdTop2" width="50">
<p align="left"><img border="0" src="../images/icon_return.gif" align="left"><a href="RDownload_index.asp" class="linktop">返回</a></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="eventfrm1" method="POST" action="?id=<%=cid%>" onSubmit="return require(this)">
<input type=hidden name="addedit_subed" value="true">
<table width="100%" cellspacing="3" cellpadding="2">
<tr>
<td width="100" class="td1" align="right"><font COLOR="RED">*</font> 名稱:</td>
<td class="td1"><input type="text" name="input_name" value="<%=htmlout(rs("name"))%>" size="50" maxlength="50" class="input"></td>
</tr>
<tr>
<td width="100" class="td1" align="right" valign="_top"><font COLOR="RED">*</font> 查詢權限:
<img src="../images/selectman.gif" border="0" onclick="doSel_Cx(eventfrm1.input_viewer.value,eventfrm1.input_viewermod.value)" style="cursor:hand">
</td>
<td class="td1"><textarea rows="7" name="viewer" cols="60" class="textarea" readonly><%=ShowNames(rs("viewermod"),rs("viewer"))%></textarea>
<input type=hidden name="input_viewermod" value="<%=rs("viewermod")%>">
<input type=hidden name="input_viewer" value="<%=rs("viewer")%>">
</td>
</tr>
<tr>
<td width="100" class="td1" align="right" valign="_top"><font COLOR="RED">*</font> 查詢顯示標志:</td>
<td class="td1"><input type="radio" name="input_viewdirmod" value="1" <%if rs("viewdirmod") then response.write "checked"%>>無查詢權限的員工可只看到目錄
<input type="radio" name="input_viewdirmod" value="0" <%if not rs("viewdirmod") then response.write "checked"%>>無查詢權限的員工看不到目錄
</td>
</tr>
<tr>
<td width="100" class="td1" align="right" valign="_top"><font COLOR="RED">*</font> 管理權限:
<img src="../images/selectman.gif" border="0" onclick="doSel_Gl(eventfrm1.input_manager.value,eventfrm1.input_managermod.value)" style="cursor:hand">
</td>
<td class="td1"><textarea rows="7" name="manager" cols="60" class="textarea" readonly><%=ShowNames(rs("managermod"),rs("manager"))%></textarea>
<input type=hidden name="input_managermod" value="<%=rs("managermod")%>">
<input type=hidden name="input_manager" value="<%=rs("manager")%>">
</td>
</tr>
<tr>
<td width="100" class="td1" align="right" valign="top">備注:</td>
<td class="td1"><textarea rows="3" name="input_remark" cols="60" class="textarea"><%=htmlout(rs("remark"))%></textarea></td>
</tr>
<tr>
<td class="tdBottom" colspan="2"></td>
</tr>
<tr>
<td class="td1" width="100%" colspan="2" align="center">
<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
%>
<%
Function ShowNames(smod,sid)
if not smod then ShowNames="全部人員"
dim sql,str
if smod=1 then
sql="select * from tbioaDepartment where ID in (" + sid + ")"
set rs_ShowNames=oConn.execute(sql)
while not rs_ShowNames.EOF '循環(huán)
str=str + htmlout(rs_ShowNames("name")) + vbcrlf
rs_ShowNames.MoveNext
wend
rs_ShowNames.close
ShowNames=str
elseif smod=2 then
sql="select a.*,b.name from tbioaRole a,tbioaDepartment b where a.department=b.id and a.id in (" + sid + ")"
set rs_ShowNames=oConn.execute(sql)
while not rs_ShowNames.EOF '循環(huán)
str=str + htmlout(rs_ShowNames("name")) + "/" + htmlout(rs_ShowNames("rolename")) + vbcrlf
rs_ShowNames.MoveNext
wend
rs_ShowNames.close
ShowNames=str
end if
End Function
%> ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -