📄 empmain_basesearch.asp

📁 好用的管理,代码程序好用的管理,代码程序
💻 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 T_User  order by F_Id desc ",MM_EmpMain_STRING,1,3
if not rs.eof then
while not rs.eof
	str_ql=str_ql&rs("F_UserName")&","
	rs.movenext
wend
end if
%>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<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>

</head>
<body bgcolor="#EAF4FF" class="body">
<fieldset style="padding: 2" class="fiedset"><legend>请输入查询条件</legend>
<form name="form1" method="post" action="">
  <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#111111" class="table">
    <tr> 
      <td align="right" nowrap class="listTitle">查询字段</td>
      <td colspan="2" class="listTitle">查询值</td>
    </tr>
	
    <tr> 
      <td width="6%" align="right" nowrap class="Caption"> 
          <input name="EmpGender" type="checkbox" id="EmpGender" value="F_EClerk">
      </td>
      <td width="11%" align="right" nowrap class="CaptionS">业务员名:</td>
      <td width="83%" 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"> 
          <input name="MarrType" type="checkbox" id="MarrType" value="F_City">
         </td>
      <td align="right" nowrap class="CaptionS">销售地区:</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">
          <input name="Empbirthday" type="checkbox" id="Empbirthday" value="F_Redate">
          </td>
      <td align="right" nowrap class="CaptionS">记录时间:</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="6%" align="right" nowrap class="Caption"> 
          <input name="Empcompany" type="checkbox" id="Empcompany" value="F_CompanyName">
          </td>
      <td width="11%" align="right" nowrap class="CaptionS"> 
        公司名称:</td>
      <td colspan="2" class="ValueArea"> <input type="text" name="companyname" id="companyname" class="text"> </td>
    </tr>
	 <tr> 
      <td width="6%" align="right" nowrap class="Caption"> 
          <input name="Empmobile" type="checkbox" id="Empmobile" value="F_Tel">
       </td>
      <td width="11%" align="right" nowrap class="CaptionS"> 
        联系电话:</td>
      <td colspan="2" class="ValueArea"> <input type="text" name="Empmobileid" id="Empmobileid" class="text"> </td>
    </tr>

	<tr> 
      <td width="6%" align="right" nowrap class="Caption"> 
          <input name="EmpHireDep" type="checkbox" id="EmpHireDep" value="F_Levels">
      </td>
      <td width="11%" align="right" nowrap class="CaptionS">客户情况:</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>

  <table width="98%" border="0" align="center">
    <tr> 
      <td width="82%" nowrap><!--DWLayoutEmptyCell-->&nbsp; </td>
      <td width="9%" nowrap onClick="dosearch()" style="cursor:hand" class="CaptionS"> <img src="images/Search.gif" width="17" height="17" align="absmiddle">查询</td>
    </tr>
  </table>
<input type="hidden" name="searchfields" value="">
<input type="hidden" name="searchvalues" value="">
<input type="hidden" name="orgURL" value="">
</form>
</fieldset>
</body>

</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -