view.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="Include/DataEnvi.asp" -->
<!-- #include virtual="Include/Page.asp" -->
<%
Dim ObjDB,StrSQL,ObjRS
Dim IntID
Dim C
	
IntID = Request.QueryString("ID")
	
Set ObjDB = Server.CreateObject("ADODB.Connection")
OpenDB ObjDB

Set C = Server.CreateObject ("CMS2003.DBhandle")
C.Init(ObjDB)
	
StrSQL ="Select ID,Address,UserName,Password,MailServerName,CreateTime From V_OA_Message_Account Where ID = " & IntID 
	
Set ObjRS = C.View(StrSQL)
	
ObjDB.Close
Set ObjDB = Nothing

Sub Main
%>
	<table class=Ltable cellspacing=1 cellpadding=3>
	<tr class=LHtr>
		<td width="15%">查看邮件帐号</td>
		<td width="85%"><%=ObjRS("ID")%></td>
	</tr>
	<tr class=Ltr>
		<td>邮箱地址</td>
		<td><input type="text" class=Input name="MailboxName" readonly value="<%=ObjRS("UserName") & "@"%><%=ObjRS("Address")%>"</td>
	</tr>
	<tr class=Ltr>
		<td>用户名</td>
		<td><input type="text" class=Input name="_TrueName" readonly value="<%=ObjRS("UserName")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>邮件服务器</td>
		<td><input type="text" class=Input name="_MailServerName" readonly value="<%=ObjRS("MailServerName")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>创建时间</td>
		<td><input type="text" class=Input name="_CreateTime" readonly value="<%=ObjRS("CreateTime")%>"></td>
	</tr>
	</table>
	</table>
	<table cellspacing=1 cellpadding=3>
	<tr>
		<td>
		<input type="button" class=Button value="返 回" id=button1 name=button1 onclick="doList()"></td>
		<td></td>
	</tr>
	</table>
<%
End Sub
%>
<!-- #include file="templet.asp" -->