addnew.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,ObjRS,StrSQL
Dim C
Dim StrSelectTrueName
Dim StrSelectUserName
	

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

If Request.Form.Count > 0 Then
	Set C = Server.CreateObject("CMS2003.DBHandle")
	C.Init(ObjDB)
	ObjRS = C.AddNew("_","t_OA_Message_Account")
		
	ObjDB.Close
	Set ObjDB = Nothing
%>
<script language=javascript>
  parent.doList()
</script>
<%
Else
	StrSQL = "SELECT ID,MailServerName FROM t_OA_Message_MailServer"
	StrSelectTrueName = SelectValue(ObjDB,StrSQL)

	StrSQL = "SELECT AccountID,TrueName FROM t_OA_SYS_Account_Character"
	StrSelectUserName = SelectValue(ObjDB,StrSQL)

	ObjDB.Close 
	Set ObjDB = Nothing
End If

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><Select Name="_AccountID" class=Input><%=StrSelectUserName%></Select></td>
	</tr>
	</tr>
		<tr class=Ltr>
		<td>用户名</td>
		<td><input type="text" class=Input Check=1 Show="用户名" name="_UserName"></td>
	</tr>
	<tr class=Ltr>
		<td>密码</td>
		<td><input type="password" class=Input name="_Password"></td>
	</tr>
	<tr class=Ltr>
		<td>邮件服务器</td>
		<td><select name="_MailServerID" class=Input><%=StrSelectTrueName%></select></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" -->