search.asp

功能齐全的oa系统

<% option explicit%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/Page.asp" -->
<!-- #include virtual="include/SelectValue.asp" -->

<%
		Dim ObjDB
		Dim C
		Dim StrWhere
		Dim StrRoleName

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

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

	If Request.Form.Count > 0 Then
	
		
		StrWhere = C.Search("Is")
		Response.Redirect "List.asp?W=" & Server.URLEncode(StrWhere)
		ObjDB.Close
		Set ObjDB = Nothing
	Else
			
		StrRoleName = SelectValue(ObjDB,"Select ID,RoleName From t_OA_SYS_Role")

	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%" colspan=2></td>
	</tr>

	
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsID>ID</td><td><input type=text class=input name="ID"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsTrueName>真实姓名</td><td><input type=text class=input name="TrueName"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsRoleName>系统角色</td><td><select name=RoleName class=Input><%=StrRoleName%></select></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsCreateTime>创建时间</td><td><input type=text class=input name="CreateTime" onclick="InputDate(this)" value="<%=Date()%>"></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>
		
	</tr>
	</table>
	</form>
	


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


<!-- #include virtual="Templet/Templet.asp" -->