addnew.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="Include/DataEnvi.asp" -->
<!-- #include virtual="Include/Page.asp" -->
<!-- #include virtual="Include/SelectValue.asp" -->
<%
	Dim ObjDB,ObjRS,StrSQL
	Dim C
	Dim StrSelectTrueName
	Dim IntDepID
	
	IntDepID = Request.QueryString("ParentID")

	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_SYS_Department_Account")
		
		ObjDB.Close
		Set ObjDB = Nothing
%>
<script language=javascript>
parent.doList()
</script>
<%
	Else
		StrSQL = "SELECT AccountID,TrueName FROM t_OA_SYS_Account_Character WHERE (AccountID NOT IN (SELECT AccountID FROM t_OA_SYS_Department_Account WHERE DepID = " & IntDepID & "))"
		'Response.Write StrSQL
		StrSelectTrueName = SelectValue(ObjDB,StrSQL)
		ObjDB.Close 
		Set ObjDB = Nothing

	End If

%>


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

	
	<form action="" method="post" onsubmit="return(CheckForm(this))" id=form1 name=form1>
	<input type=hidden name=_DepID value="<%=IntDepID%>">
	<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><%=StrSelectTrueName%></select></td>
	</tr>
	<tr class=Ltr>
		<td>职务</td>
		<td><input type="text" class=Input name="_Pos"></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" -->