edit.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="Include/DataEnvi.asp" -->
<!-- #include virtual="Include/Page.asp" -->
<!-- #include virtual="Include/SelectValue.asp" -->
<!-- #include virtual="Include/GetRoleIDs.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,AccountID 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

if not CheckRole(1) AND (ObjRS("AccountID") <> Session("AccountID")) then
%>
<script language=javascript>
  alert("您无此权限！");
  window.history.back();
</script>
<%
  Response.End
end if

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" -->