home *** CD-ROM | disk | FTP | other *** search
/ 203.33.198.31 / ftp-203.33.198.31.7z / 203.33.198.31 / getdropdown.jsp.bak < prev    next >
Encoding:
Text File  |  2008-12-15  |  3.2 KB  |  144 lines
  1.  
  2. <%
  3. String ajax="";
  4. ajax = request.getParameter("ajax");
  5.  
  6. if (ajax == null ) ajax = "";
  7.  
  8.  
  9. if(ajax.equals("statf"))
  10. {
  11.  
  12. String argvar = request.getParameter("argvar");
  13. if (argvar == null ) argvar = "";
  14. String argval = request.getParameter("argval");
  15. if (argval == null ) argval = "";
  16. String argvar2 = request.getParameter("argvar2");
  17. if (argvar2 == null ) argvar2 = "";
  18.  
  19. String sdesc="";
  20. String tmpprod="";
  21.  
  22. if(argvar.equals("stat"))
  23. {
  24.     Hashtable[] kts = database.fetch("select dist from district_master  where ltrim(rtrim(stat)) ='"+argval.trim()+"' order by dist asc" );
  25.     
  26.         if(kts != null)
  27.         {
  28.             sdesc =     kts.length+"";
  29.             for(i=0;i<kts.length;i++)
  30.             {
  31.                 sdesc = sdesc+"|"+kts[i].get("dist").toString();
  32.             }
  33.             sdesc = sdesc+"|";
  34.             out.println(sdesc);
  35.         }else{
  36.                     sdesc="1|error|";
  37.                     out.println(sdesc);
  38.         }
  39. }
  40. if(argvar.equals("pstc"))
  41. {
  42.     Hashtable[] kts1 = database.fetch("select * from tsgal044"+comp+" where ltrim(rtrim(cpsf)) <= '"+argval.trim()+"' and ltrim(rtrim(cpst)) >= '"+argval.trim()+"'" );
  43.  
  44.         if(kts1 != null)
  45.         {
  46.             sdesc = kts1.length+"";
  47.             for(i=0;i<kts1.length;i++)
  48.             {
  49.                 sdesc = sdesc+"|"+kts1[i].get("cctp").toString();
  50.             }
  51.             sdesc = sdesc+"|";
  52.             out.println(sdesc);
  53.         }else{
  54.                     sdesc="1|error|";
  55.                     out.println(sdesc);
  56.         }
  57.         
  58. }
  59. if(argvar.equals("prod"))
  60. {
  61.         if(argvar2.equals("prodsub"))
  62.         {
  63.             Hashtable[] kts2 = database.fetch("select prodsub from prodsub where ltrim(rtrim(prod)) ='"+argval.trim()+"' order by prodsub asc" );
  64.             if(kts2 != null)
  65.             {
  66.                 sdesc =     kts2.length+"";
  67.                 for(i=0;i<kts2.length;i++)
  68.                 {
  69.                     sdesc = sdesc+"|"+kts2[i].get("prodsub").toString();
  70.                 }
  71.                 sdesc = sdesc+"|";
  72.                 out.println(sdesc);
  73.             }else{
  74.                         sdesc="1|error|";
  75.                         out.println(sdesc);
  76.             }
  77.         }
  78.         if(argvar2.equals("natw"))
  79.         {
  80.             Hashtable[] kts3 = database.fetch("select * from prodnatw where ltrim(rtrim(prod)) ='"+argval.trim()+"'" );
  81.     
  82.             if(kts3 != null)
  83.             {
  84.                 sdesc =     kts3.length+"";
  85.                 for(i=0;i<kts3.length;i++)
  86.                 {
  87.                     sdesc = sdesc+"|"+kts3[i].get("natw").toString();
  88.                     tmpprod = kts3[i].get("prod").toString();
  89.                 }
  90.                 sdesc = sdesc+"|";
  91.                 if(kts3[i-1].get("prod").toString().equals("REFRIGERATOR"))
  92.                 {        
  93.                         sdesc = sdesc+"R000000|";
  94.                 }
  95.                 else
  96.                 {
  97.                     if(kts3[i-1].get("prod").toString().equals("WASHER"))
  98.                     {        
  99.                             sdesc = sdesc+"W000000|";
  100.                     }
  101.                     else
  102.                     {
  103.                         if(tmpprod.equals("AIR CONDITIONER"))
  104.                         {        
  105.                                 sdesc = sdesc+"A000000|";
  106.                         }
  107.                         else
  108.                         {
  109.                             if(kts3[i-1].get("prod").toString().equals("MICROWAVE"))
  110.                             {        
  111.                                     sdesc = sdesc+"N000000|";
  112.                             }
  113.                             else
  114.                             {
  115.                                 if(kts3[i-1].get("prod").toString().equals("DVD"))
  116.                                 {        
  117.                                         sdesc = sdesc+"E000000|";
  118.                                 }
  119.                                 else
  120.                                 {
  121.                                     if(kts3[i-1].get("prod").toString().equals("TELEVISION"))
  122.                                     {        
  123.                                             sdesc = sdesc+"T000000|";
  124.                                     }
  125.                                     else
  126.                                     {        
  127.                                             sdesc = sdesc+" |";
  128.                                     }
  129.                                 }
  130.                             }
  131.                         }
  132.                     }
  133.                 }
  134.                 
  135.                 out.println(sdesc);
  136.             }else{
  137.                         sdesc="1|error|";
  138.                         out.println(sdesc);
  139.             }
  140.         }
  141. }
  142. }
  143.  
  144. %>