edit.asp

功能齐全的oa系统

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

	
	IntID       = Request.QueryString("ID")
	
	
	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_Message_Account")
	    ObjDB.Close
     	Set ObjDB = Nothing
     	
     	
     	
Dim easymail     	
Set easymail = server.CreateObject("easymail.Users")
easymail.ChangeUserPassWord Request.Form("_UserName"),Request.Form("_Password")
Set easymail = nothing

%>
<script language=javascript>
parent.doList()
</script>
<%
		Response.End 
	End If

	Set ObjRS = C.View("Select ID,Address,UserName,Password,MailServerName,CreateTime From V_OA_Message_Account Where ID = " & IntID)

	StrSQL = "SELECT ID,MailServerName FROM t_OA_Message_MailServer"
	StrSelectTrueName = SelectValue(ObjDB,StrSQL)

	ObjDB.Close
	Set ObjDB = Nothing

%>


<%'==================================================================%>
<%Sub Main%>
<%'------------------------------------------------------------------%>

	
	<form action="" method="post" onsubmit="return(CheckForm(this))" id=form1 name=form1>
	<input type=hidden name=ID value="<%=IntID%>">
	<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="用户名" name="_UserName" value=<%=ObjRS("UserName")%>></td>
	</tr>
	<tr class=Ltr>
		<td>密码</td>
		<td><input type="password" class=Input name="_Password" value=<%=ObjRS("Password")%>></td>
	</tr>
	<tr class=Ltr>
		<td>邮件服务器</td>
		<td><select name="_MailServerID" class=Input><%=StrSelectTrueName%></select></td>
	</tr>
	<tr class=Ltr>
		<td>创建时间</td>
		<td><input type="text" class=Input name="CreateTime" readonly value=<%=ObjRS("CreateTime")%>></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()" id=button1 name=button1>
		</td>
		<td>
		</td>
	</tr>
	</table>
	</form>
	


<%'------------------------------------------------------------------%>
<%End Sub%>
<%'==================================================================%>

<!-- #include file="templet.asp" -->