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,TrueName,Pos,CreateTime From V_OA_SYS_Department_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 Check=1 Show="TrueName" name="_TrueName" readonly value="<%=ObjRS("TrueName")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>职务</td>
		<td><input type="text" class=Input Check=1 Show="Pos" name="_Pos"  readonly value="<%=ObjRS("Pos")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>创建时间</td>
		<td><input type="text" class=Input Check=1 Show="CreateTime" 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" -->