view.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/Page.asp" -->
<%
Dim ObjDB,StrSQL,ObjRS,ObjRS1
Dim C,IntID,IntWeather,StrWeather

IntID=Request.QueryString("ID")
Set ObjDB = Server.CreateObject("ADODB.Connection")
OpenDB ObjDB

StrSQL = "Select AccountID,LoginTime,Logouttime From t_OA_Work_Sign Where ID=" & IntID & ""
Set C = Server.CreateObject ("CMS2003.DBhandle")
C.Init(ObjDB)
Set ObjRS = C.View(StrSQL)

StrSQL = "Select AccountName,TrueName From V_OA_SYS_Account Where ID=" & ObjRS("AccountID") & ""
Set ObjRS1 = C.View(StrSQL)

ObjDB.Close
Set ObjDB = Nothing

Sub Main
%>
	<form action="" method="post" onsubmit="return(CheckForm(this))" id=form1 name=form1>
	<table class=Ltable cellspacing=1 cellpadding=3>
	<tr class=LHtr>
		<td width="15%">查看登录</td>
		<td width="85%"> </td>
	</tr>
	<tr class=Ltr>
		<td>登录账号</td>
		<td><input type="text" class=Input readonly Check=1 Show="登录账号" name="_AccountID" value="<%=ObjRS1("AccountName")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>真实姓名</td>
		<td><input type="text" class=Input readonly Check=1 Show="登录账号" name="_AccountID" value="<%=ObjRS1("TrueName")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>登录时间</td>
		<td><input type="text" class=Input readonly Check=1 Show="登录时间" name="_LoginDate" value="<%=ObjRS("LoginTime")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>退出时间</td>
		<td><input type="text" class=Input readonly Check=1 Show="退出时间" name="_LoginDate" value="<%=ObjRS("Logouttime")%>"></td>
	</tr>
	</table>
	<table cellspacing=1 cellpadding=3>
	<tr>
		<td>
		<input type="button"  name="button" onclick="doList()" class=Button value="返   回"></td>
		<td></td>
	</tr>
	</table>
	</FORM>
<%
End Sub
%>
<!-- #include file="templet.asp" -->