edit.asp

功能齐全的oa系统

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

IntID = Request.QueryString("ID")
If IntID ="" Then IntID = 1

Set ObjDB = Server.CreateObject("ADODB.Connection")
OpenDB ObjDB

Set C = Server.CreateObject ("CMS2003.DBhandle")
C.Init(ObjDB)

If Request.Form.Count > 0 Then
	IntID = Request.Form("ID")
	Call C.Edit(IntID,"_","t_OA_Public_Address")
	Response.Redirect "List.asp"
End If
StrSQL="Select * From t_OA_Public_Address Where ID = " & IntID
Set ObjRS = 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>
	<input type=hidden name=ID value="<%=IntID%>"></tr>
	<tr class=LHtr>
		<td width="15%">修改联系人</td>
		<td width="85%"> &nbsp; </td>
	</tr>
	<tr class=Ltr>
		<td>公司名称</td>
		<td><input type="text" class=Input size=40 Check=1 Show="公司名称" name="_Company" value="<%=ObjRS("Company")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>联系人</td>
		<td><input type="text" class=Input size=40 Check=1 Show="联系人" name="_Linkman" value="<%=ObjRS("Linkman")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>职称</td>
		<td><input type="text" class=Input size=40 Check=0 Show="职称" name="_Title" value="<%=ObjRS("Title")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>住址</td>
		<td><input type="text" class=Input Check=0 size=40 Show="住址" name="_Address" value="<%=ObjRS("Address")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>电话</td>
		<td><input type="text" class=Input Check=1 size=40 Show="电话" name="_Tel" value="<%=ObjRS("Tel")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>传真</td>
		<td><input type="text" class=Input Check=0 size=40 Show="传真" name="_Fax" value="<%=ObjRS("Fax")%>"></td>
	</tr>
	<tr class=Ltr>
		<td>E-mail</td>
		<td><input type="text" class=Input Check=0 size=40 Show="E-mail" name="_Email" value="<%=ObjRS("Email")%>"></td>
	</tr>
	<tr class=Ltr>
		<td valign=top>备注</td>
		<td><textarea  class=textarea Check=0 rows=10 cols=33 Show="备注" name="_Des" ><%=ObjRS("Des")%></textarea></td>
	</tr>	
	<table cellspacing=1 cellpadding=3>
	<tr>
		<td>
		<input type="submit"  name="Submit" class=Button value="提 交"><input type="button" class=Button value="取 消"onclick="doList()"></td>
		<td></td>
	</tr>
	</table>
	</form>
<%
End Sub
%>
<!-- #include file="Templet.asp" -->