?? empmain_basesearch.asp
字號:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/EmpMain.asp" -->
<!--#include file="EmpMain_CheckRight.asp"-->
<%
dim rs,str_ql
Set rs= Server.CreateObject ("ADODB.RecordSet")
rs.open "select * from user order by id desc ",MM_EmpMain_STRING,1,3
if not rs.eof then
while not rs.eof
str_ql=str_ql&rs("username")&","
rs.movenext
wend
end if
%>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>資料檢索</title>
<link rel="stylesheet" href="CSS/SellWellWeb.css" type="text/css">
<script language="javascript" src="Js_Lib/Calendar.js"></script>
<script>
function selectall(obj){
if(obj.checked){
for(i=0;i<document.form1.elements.length;i++){
if(document.form1.elements[i].type=="checkbox"){
document.form1.elements[i].checked = true
}
}
}
else{
for(i=0;i<document.form1.elements.length;i++){
if(document.form1.elements[i].type=="checkbox"){
document.form1.elements[i].checked = false
}
}
}
}
function fnIntNumOnly(max){
key=window.event.keyCode;
if((key>47&&key<58) && window.event.shiftKey)
{
window.event.returnValue=false;
return;
}
if (window.event.keyCode>=33 && window.event.keyCode<=46) return;
switch(window.event.keyCode)
{
case 8:
return;
case 13:
return
case 9:
return;
}
if( (String.fromCharCode(key) < "0" || String.fromCharCode(key) > "9" ) && (String.fromCharCode(key) < "a" || String.fromCharCode(key) > "i") && String.fromCharCode(key)!="`")
event.returnValue=false;
if(key >= 96 && key <=105 )
ipChar=(key-96) + ""
else
ipChar=String.fromCharCode(key)
if(max){
if((window.event.srcElement.value+ipChar)*1 > max)
event.returnValue=false;
}
}
function dosearch1(){
if(!confirm("別急，此模塊正在制作中")){
return
}
}
function dosearch(){
ischecked = 0
for(i=0;i<document.form1.elements.length;i++){
if(document.form1.elements[i].type=="checkbox"){
if(document.form1.elements[i].checked ==true){
ischecked = 1
}
}
}
if(ischecked ==0){
alert("至少選擇一個查詢條件才能查詢!")
return
}
searchFields = ""
searchValue =""
if(document.all.EmpGender.checked){//name search
searchFields = searchFields + "," + document.all.EmpGender.value
searchValue = searchValue + "," + document.all.EmpGendervalue.options[document.all.EmpGendervalue.selectedIndex].value
}
if(document.all.MarrType.checked){//diqu search
searchFields = searchFields + "," + document.all.MarrType.value
searchValue = searchValue + "," + document.all.MarrTypevalue.options[document.all.MarrTypevalue.selectedIndex].value
}
if(document.all.EmpHireDep.checked){//diqu search
searchFields = searchFields + "," + document.all.EmpHireDep.value
searchValue = searchValue + "," + document.all.EmpHireDepvalue.options[document.all.EmpHireDepvalue.selectedIndex].value
}
if(document.all.Empbirthday.checked){
searchFields = searchFields + "," + document.all.Empbirthday.value
searchValue = searchValue + "," + document.all.startdate.value
}
if(document.all.Empcompany.checked){
searchFields = searchFields + "," + document.all.Empcompany.value
searchValue = searchValue + "," + document.all.companyname.value
}
if(document.all.Empmobile.checked){
searchFields = searchFields + "," + document.all.Empmobile.value
searchValue = searchValue + "," + document.all.Empmobileid.value
}
document.form1.searchfields.value = searchFields
document.form1.searchvalues.value = searchValue
document.form1.target = "frmTop"
document.form1.action ="EmpMain_BaseSearch_Process.asp"
strUrl = window.parent.parent.frames("frmright").frames("frmTop").window.location.href
document.form1.submit()
}
</script>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
</head>
<body bgcolor="#EAF4FF" class="body">
<form name="form1" method="post" action="">
<fieldset style="padding: 2" class="fiedset"> <legend><font size="2">請輸入查詢條件</font></legend>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#111111" class="table">
<tr bgcolor="#9933FF">
<td height="22" align="right" nowrap><div align="center"><span lang="zh-cn">
</span></div></td>
<td align="right" nowrap><div align="center" class="style1">查詢字段</div></td>
<td colspan="2"><div align="center" class="style1">查詢值</div></td>
</tr>
<tr>
<td width="3%" align="right" nowrap class="Caption"><div align="center"><span lang="zh-cn">
<input name="EmpGender" type="checkbox" id="EmpGender" value="錄入人">
</span></div></td>
<td width="28%" align="right" nowrap class="Caption"><span lang="zh-cn"><font size="2">姓名:</font></span></td>
<td colspan="2" class="ValueArea"><select name="EmpGendervalue" size="1" class="Text" id="EmpGendervalue" style="width:100%">
<%if fncheckupart(1)=true or fncheckupart(2)=true or fncheckupart(3)=true then%>
<%call select_str( str_ql,1,"")%>
<%else%>
<option value="<%=session("name")%>"><%=session("name")%></option>
<%end if%>
</select> </td>
</tr>
<tr>
<td align="right" nowrap class="Caption"><div align="center"><span lang="zh-cn">
<input name="MarrType" type="checkbox" id="MarrType" value="城市">
</span></div></td>
<td align="right" nowrap class="Caption">地區:</td>
<td colspan="2" class="ValueArea"><select name="MarrTypevalue" size="1" class="select" id="select" style="width:100%">
<%if fncheckupart(1)=true or fncheckupart(2)=true or fncheckupart(3)=true then
response.write(createSel("地區",""))
else
response.write(usersel(""))
end if%>
</select></td>
</tr>
<tr>
<td align="right" nowrap class="Caption"><div align="center"><span lang="zh-cn">
<input name="Empbirthday" type="checkbox" id="Empbirthday" value="redate">
</span></div></td>
<td align="right" nowrap class="Caption">時間:</td>
<td class="ValueArea"><input name="startdate" type="text" id="startdate" class="text" onclick="getDate(this,'2')" readonly style="cursor:hand"></td>
</tr>
<tr>
<td width="3%" align="right" nowrap class="Caption"><div align="center"><span lang="zh-cn">
<input name="Empcompany" type="checkbox" id="Empcompany" value="公司名稱">
</span></div></td>
<td width="28%" align="right" nowrap class="Caption"><span lang="zh-cn"><font size="2">
客戶名稱:</font></span></td>
<td colspan="2" class="ValueArea"> <input type="text" name="companyname" id="companyname" class="text"> </td>
</tr>
<tr>
<td width="3%" align="right" nowrap class="Caption"><div align="center"><span lang="zh-cn">
<input name="Empmobile" type="checkbox" id="Empmobile" value="手機">
</span></div></td>
<td width="28%" align="right" nowrap class="Caption"><span lang="zh-cn"><font size="2">
手機:</font></span></td>
<td colspan="2" class="ValueArea"> <input type="text" name="Empmobileid" id="Empmobileid" class="text"> </td>
</tr>
<tr>
<td width="3%" align="right" nowrap class="Caption"><div align="center"><span lang="zh-cn">
<input name="EmpHireDep" type="checkbox" id="EmpHireDep" value="客戶等級">
</span></div></td>
<td width="28%" align="right" nowrap class="Caption"><span lang="zh-cn"><font size="2">意向情況:</font></span></td>
<td colspan="2" class="ValueArea"> <select name="EmpHireDepvalue" size="1" class="select" id="select2">
<option value="" />
<option value="已購買">已購買</option>
<option value="意向客戶">意向客戶</option>
<option value="無價值">無價值</option>
</select> </td>
</tr>
</table>
</fieldset>
<table width="98%" border="0" align="center">
<tr>
<td width="9%" nowrap><!--DWLayoutEmptyCell--> </td>
<td width="82%" nowrap><!--DWLayoutEmptyCell--> </td>
<td width="9%" nowrap onClick="dosearch()" style="cursor:hand"> <div align="right"><span lang="zh-cn"><font size="2"><img src="images/Search.gif" width="17" height="17" align="absmiddle">查詢</font></span></div></td>
</tr>
</table>
<p align="right"><span lang="zh-cn">時間是從指定日期起到今日有更新條件!</span></p>
<input type="hidden" name="searchfields" value="">
<input type="hidden" name="searchvalues" value="">
<input type="hidden" name="orgURL" value="">
</form>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -