📄 wsoadatabasemanage.asp
字号:
<!--#INCLUDE FILE="../HXINCLUDE/HXINCLUDEHEAD.ASP"-->
<%if WS_S.MemberPriv("WS_SystemSetWSOADATABASEMANAGE")<>1 then HX_GoBack "对不起,您的权限不够!",""
action=request("action")
select case action
case "compact"
msg="数据库优化成功!"
HX_ClosDB
CompactDB=Server.MapPath("WSOATEMP.MDB")
Call WS_S.CheckFile(CompactDB,True)
Dim fso, Engine
Set fso = CreateObject("Scripting.FileSystemObject")
Set Engine = CreateObject("JRO.JetEngine")
Engine.CompactDatabase ConnStr,"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&CompactDB
fso.CopyFile CompactDB,WS_S.DBPathAddress(Dir)
fso.DeleteFile(CompactDB)
Set fso = nothing
Set Engine = nothing
HX_Conn Dir
call WS_S.SaveAdminLog(LOGINUSERNAME,LogAppointment,msg)
HX_GoBack msg,"WSOADATABASEMANAGE.ASP"
case "bak"
HX_ClosDB
set fso=Server.CreateOBject("Scripting.FileSystemObject")
if fso.fileexists(WS_S.DBPathAddress(Dir)) then
fso.CopyFile WS_S.DBPathAddress(Dir),Server.MapPath("../Databak/WSOACOM.MDB")
end if
set fso=nothing
HX_Conn Dir
msg="数据库备份成功！"
call WS_S.SaveAdminLog(LOGINUSERNAME,LogAppointment,msg)
HX_GoBack msg,"WSOADATABASEMANAGE.ASP"
case "restore"
HX_ClosDB:msg="数据库恢复成功！"
set fso=Server.CreateOBject("Scripting.FileSystemObject")
if fso.fileexists(Server.MapPath("../Databak/WSOACOM.MDB")) then
fso.CopyFile Server.MapPath("../Databak/WSOACOM.MDB"),WS_S.DBPathAddress(Dir)
else
msg="数据库恢复失败：先备份数据库！"
end if
set fso=nothing
HX_Conn Dir
call WS_S.SaveAdminLog(LOGINUSERNAME,LogAppointment,msg)
HX_GoBack msg,"WSOADATABASEMANAGE.ASP"
end select
WSOASCOMSTR="<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>单位管理</title><link rel=stylesheet type=text/css href='../HXinclude/HX_Style.css'></head><body topmargin='20' leftmargin='0' bottommargin='0'><table width='596' border='0' cellspacing='1' cellpadding='0' align=center bgcolor='#115F8F'><tr><td colspan='2' bgcolor=ffffff><table width='100%' border='0' cellspacing='0' cellpadding='0'><tr><td height='25' background='../hximages/titleline.gif'><font class='fontmenu'>数据库管理</font></td></tr></table><table width='100%' border='0' cellspacing='1' cellpadding='6' bgcolor='#f1f1f1'><tr bgcolor='#A1BBE0' class='td4'><td>执行以下操作前建议先备份</td></tr><tr bgcolor='#FFFFFF'><td align='left' height='30'><input type='button' name='Submit' value='数据库优化' onclick=""location.href='?action=compact';"">"
dim objFTemp
set fso=Server.CreateOBject("Scripting.FileSystemObject")
if fso.fileexists(WS_S.DBPathAddress(Dir)) then
Set objFTemp=FSO.GetFile(WS_S.DBPathAddress(Dir))
WSOASCOMSTR=WSOASCOMSTR&"数据库大小："&WS_S.GetSize(objFTemp.size,"b")
WSOASCOMSTR=WSOASCOMSTR&" <font color=blue>数据库建立或上次优化时间："&WS_S.Format_Time(objFTemp.DateLastModified,2)&"</font>"
end if
set fso=nothing
WSOASCOMSTR=WSOASCOMSTR&"<br>当系统长时间使用后，可以对数据库进一次优化，可以适当的提高数据库的执行效率！</td></tr><tr bgcolor='#FFFFFF'><td align='left' height='30'><input type='button' name='Submit' value='数据库恢复' onclick=""location.href='?action=restore';""><br>当某些模块出现非正常的现象时（比如出现警告或错误等），可以合数据库恢复功能！</td></tr><tr bgcolor='#FFFFFF'><td align='left' height='30'><input type='button' name='Submit' value='数据库备份' onclick=""location.href='?action=bak';"">"
set fso=Server.CreateOBject("Scripting.FileSystemObject")
if fso.fileexists(Server.MapPath("../Databak/WSOACOM.MDB")) then
Set objFTemp=FSO.GetFile(Server.MapPath("../Databak/WSOACOM.MDB"))
WSOASCOMSTR=WSOASCOMSTR&"<a href='../Databak/WSOACOM.MDB' target='_bank'><font color=red>下载备份数据库</font></a>（"&WS_S.GetSize(objFTemp.size,"b")&"）"
WSOASCOMSTR=WSOASCOMSTR&"<font color=blue>上次备份时间："&WS_S.Format_Time(objFTemp.DateLastModified,2)&"</font>"
end if
set fso=nothing
WSOASCOMSTR=WSOASCOMSTR&"<br>将当前数据库中的数据备份到来以便日后修复数据库！</td></tr><tr bgcolor='#FFFFFF'><td align='left' height='30'><input type='button' name='Submit' value='数据库升级' onclick=""alert('此版本是最新版本，无需升级！');""><br>低版本升级到高版本时，可以使用数据库升级功能将低版本中数据导入高版本中！</td></tr></table></td></tr></table>"
response.Write WSOASCOMSTR%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -