📄 main.asp

📁 具有计划、任务、通告、公文、员工档案、等网络办公功能
💻 ASP
字号:
<%response.expires=0%>
<%Response.Buffer=true%>
<!-- #include file="../conn_lr.asp"-->
<!-- #include file="../css.asp"-->
<%
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" then 
	response.write("<script language=""javascript"">")
	response.write("window.top.location.href='../../default.asp';")
	response.write("</script>")
	response.end
end if
%>
<%
set conn=opendb("oabusy","conn","accessdsn")
set rs=server.createobject("adodb.recordset")
sql="select * from userinf where username='" & oabusyusername&"'"
rs.open sql,conn,1
allow_zichan_manage=rs("allow_zichan_manage")     
conn.close
set conn=nothing
set rs=nothing
if allow_zichan_manage<>"yes" then
response.write("<font color=red size=""+1"">对不起，需要资产管理权限！</font>")
	response.end
	end if
%>

<html>
<head>
<title>固定资产</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="d" method="post" action="../dbdisp/disp.asp">
<input type="hidden" name="opFlag" value="">
<%
function opendb(DBPath,sessionname,dbsort)
dim conn
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../../db/#sdoa.asa")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set session(sessionname)=conn
set opendb=session(sessionname)
end function
set conn=opendb("oabusy","conn","accessdsn")
set rs=server.createobject("adodb.recordset")
sql="select * from userinf where username='" & oabusyusername&"'"
rs.open sql,conn,1
allow_zichan_manage=rs("allow_zichan_manage")     
conn.close
set conn=nothing
set rs=nothing
if allow_zichan_manage="yes" then
%> 
	<input type="hidden" name="LinkFlag" value="000110">
	<input type="hidden" name="EnabledAddNew" value="yes">
<%else%>
	<input type="hidden" name="LinkFlag" value="000100">
	<input type="hidden" name="EnabledAddNew" value="no">
<%end if%>

<input type="hidden" name="EditFile" value="../gdzc/edit.asp">
<input type="hidden" name="mFiledsCount" value="12">
<input type="hidden" name="mFileds" value="vnumber,vname,vtype,vregtime,format(vmoney^'0.00') as tmoney,vcount,format(vmoney*vcount^'0.00') as jine,format(0.01*vcount*vmoney*vzjl*(year(date())-val(left(vregtime^4)))^'0.00') as zhejiu,format(vxiyi^'0.00') as xiaoyi,format(vzjl/100^'0.00%') as zjl,format(vmoney*vcount-0.01*vcount*vmoney*vzjl*(year(date())-val(left(vregtime^4)))^'0.00') as xz,vinfo,">
<input type="hidden" name="mFiledsCaptions" value="编号,名称,类型,购买时间,单价,数量,金额,折旧,效益,折旧率,目前价值,备注,">
<input type="hidden" name="mFiledsWidths" value=",,,,-45,,-45,-45,-45,-45,-45,0,">
<input type="hidden" name="mSortBy2" value="vname DESC">
<input type="hidden" name="DispFile" value="../gdzc/disp.asp">
<input type="hidden" name="mTable" value="gdzc">
<input type="hidden" name="mTitle" value="固定资产">
<input type="hidden" name="mImage" value="../images/gdzc.gif">
</form>
<script language="JavaScript">
	document.all.d.submit()
</script>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -