📄 sysaccount.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
rs.Open "select * from sysaccount",conn,1,1
%>
<html>
<head>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>帐套列表</title>
</head>
<body vlink="#48576C" link="#48576C" alink="#000000" bgcolor="#FFFFFF" topmargin="3">
<table align="center" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25"><strong><font size="2" class=title>帐套列表</font></strong> <a href="javascript:opensubwin('resizable=no, scrollbars=no, left= 100, top=100, menubar=no, location=no, toolbar=no ,width=400, height=250','newsysaccount.asp?type=新建');"><img src="../images/button_new.gif" border=0></a>
</td>
<td> </td>
</tr>
<tr>
<td height="16" colspan="2" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="DECFAD">
<tr bgcolor="EFEFEF">
<td width="15%" align=center>名称</td>
<td width="15%" align=center>开帐时间</td>
<td align=center>描述</td>
<td width="10%" align=center>创建者</td>
<td width="10%" align=center>帐套状态</td>
<td width="10%" align=center>生效</td>
<td width="15%" align=center>操作</td>
</tr>
<%
do while not rs.EOF
set SysAccountId=rs("SysAccountId")
set SysAccount=rs("SysAccount")
Creator=getfieldvalue("usertable","loginid",rs("Creator"),"username")
set CreateDate=rs("CreateDate")
set Used=rs("Used")
set Complete=rs("complete")
set Descriptions=rs("Descriptions")
%>
<tr bgcolor="#FFFFFF">
<td align=center height=18><a href="initialdata.asp?SysAccountId=<%=SysAccountId%>"><%=SysAccount%></a></td>
<td align=center><%=CreateDate%></td>
<td align=center><%=Descriptions%></td>
<td align=center><%=Creator%></td>
<td bgcolor="#FFFFFF" align=center>
<%if Complete then%>
<font color=red><%Response.Write "帐套设置完成"%></font></td>
<%else%>
<%Response.Write "帐套设置未完成"%></td>
<%end if%>
<td bgcolor="#FFFFFF" align=center>
<%if used then%>
<font color=red><%Response.Write "是"%></font></td>
<%else%>
<%Response.Write "否"%></td>
<%end if%>
<td align=center>
<%if used then%>
<a href="javascript:opensubwin('resizable=no, scrollbars=no, left= 300, top=220, menubar=no, location=no, toolbar=no ,width=300, height=200','sysaccountsubmit.asp?sysaccountid=<%=sysaccountid%>&mod=失效');">失效</a>
<%elseif not Complete then%>
<a href="javascript:opensubwin('resizable=no, scrollbars=no, left= 100, top=100, menubar=no, location=no, toolbar=no ,width=400, height=250','newSysAccount.asp?id=<%=SysAccountId%>&type=编辑');">编辑</a>
<%elseif Complete then%>
<a href="javascript:opensubwin('resizable=no, scrollbars=no, left= 300, top=220, menubar=no, location=no, toolbar=no ,width=300, height=200','sysaccountsubmit.asp?sysaccountid=<%=sysaccountid%>&mod=生效');">生效</a>
<%end if%>
</td>
</tr>
<%
i=i+1
rs.MoveNext
loop
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -