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