search.asp

功能齐全的oa系统

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

<%
	If Request.Form.Count > 0 Then
		Dim ObjDB
		Dim C
		Dim StrWhere
		
		Set ObjDB = Server.CreateObject("ADODB.Connection")
		OpenDB ObjDB

		Set C = Server.CreateObject ("CMS2003.DBhandle")
		C.Init(ObjDB)
		StrWhere = C.Search("Is")
		Response.Redirect "List.asp?W="& Server.URLEncode(StrWhere)
		
		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%" 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=IsCompany>公司名称</td><td><input type=text class=input name="Company"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsLinkman>联系人</td><td><input type=text class=input name="Linkman"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsTitle>职称</td><td><input type=text class=input name="Title"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsAddress>地址</td><td><input type=text class=input name="Address"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsTel>电话</td><td><input type=text class=input name="Tel"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsFax>传真</td><td><input type=text class=input name="Fax"></td></tr>
	<tr class=Ltr><td colspan=2><input type="checkbox" name=IsEmail>Email</td><td><input type=text class=input name="Email"></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()"></td>
	</tr>
	</table>
	</form>
<%
End Sub
%>
<!-- #include file="Templet.asp" -->