1.sql语句

 

2.

 
  
  1. <et:form type="user" action="#" method= "get" > 
  2.       <table> 
  3.         <tr> 
  4.           <td>所属销售点</td> 
  5.           <td><et:dropdownlist id="pos" name="pos" textfield="POSName" valuefield="ID" sourcetype="table" source="U_POSInfo"  > 
  6.               <et:ListItem value="">请选择</et:ListItem> 
  7.             </et:dropdownlist> 
  8.           </td> 
  9.           <td>所属部门</td> 
  10.           <td><et:dropdownlist id="dept" name="dept" textfield="DepartmentName" valuefield="ID" sourcetype="table" source="U_DepartmentInfo" joinfield="ID" joinelement="pos" > 
  11.               <et:ListItem value="">请选择</et:ListItem> 
  12.             </et:dropdownlist> 
  13.           </td> 
  14.         </tr> 
  15.       </table> 
  16.       <input type="submit" value="查询" /> 
  17.     </et:form> 
 
  
3. 
 
  
 
  
  1. <script type="text/javascript"> 
  2. jQuery(function(){  
  3. $("#pos").change(function(){   
  4. window.setTimeout( function(){   
  5. var ps = $("#dept>option");  
  6. if(ps.size()>0){  
  7. $(ps[0]).before("<option value='' >请选择</option>");  
  8. $("#dept")[0].selectedIndex = 0;  
  9. }else{  
  10. $("#dept").append("<option value='' >请选择</option>");  
  11. $("#dept")[0].selectedIndex = 0;  
  12. }  
  13. },200);  
  14.  } );  
  15. });  
  16. </script>