view.asp

来自「功能齐全的oa系统」· ASP 代码 · 共 62 行

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

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

	Set C = Server.CreateObject ("CMS2003.DBhandle")
	C.Init(ObjDB)
	Set ObjRS = C.View("Select Title,Place,Remark,StartDate,EndDate From t_OA_Private_Log Where ID="&IntID&"")
	
	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="_Title" value="<%=ObjRS("Title")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>工作地点</td>
		<td>
	<input type="text" readonly class=Input Check=1 Show="工作地点" name="_Place" value="<%=ObjRS("Place")%>"></td>
		</td>
	</tr>
<tr class=Ltr>
		<td>备注</td>
		<td><textarea class=Textarea Check=1 Show="备注" readonly name="_Remark" value=""><%=ObjRS("Remark")%></textarea></td>
	</tr>
	<tr class=Ltr>
		<td>开始时间</td>
		<td><input type="text" readonly class=Input Check=1 Show="开始时间" name="_StartDate" value="<%=ObjRS("StartDate")%>"></td>
	</tr>
	
	<tr class=Ltr>
		<td>结束时间</td>
		<td bgcolor="#F0F0F0"><input class=Input type="text" Check=1 Show="结束时间" readonly name="_EndDate" value="<%=ObjRS("EndDate")%>"></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" -->