simpreportqry.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.statana;

import java.util.HashMap;
import java.util.Set;

import com.doone.data.DacClient;
import com.doone.data.DataTable;
import com.doone.iossp.FormBody;
import com.doone.util.FileLogger;
import com.doone.uurm.StateEnum;

public class Simpreportqry {
	/**
	 * 
	 * @param cityCode
	 * @param reporttypeid
	 * @return
	 */
	public static DataTable gettf_reports(String cityCode, String reporttypeid) {
        DataTable ret = null;
        
        if(reporttypeid==null && reporttypeid.equals(""))
        	return ret;

        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select * from tf_reports b where b.reportid=? and b.state=?");
            int paramCount = 2;
            Object[] aParam = new Object[paramCount];
            int idx = 0;            
            aParam[idx++] = reporttypeid;             
            aParam[idx++] = StateEnum.ENABLED;             

            DacClient db = new DacClient();
            ret = db.executeQuery(sql.toString(), aParam);

        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex.getMessage(), ex);

            throw new RuntimeException(ex);
        }

        return ret;
    }
	
	/**
	 * 
	 */
	
	public static DataTable gettf_reportssql(String cityCode, String reportid, String reporttypeid) {
        DataTable ret = null;
        
        if(reportid==null || reportid.equals("") || reporttypeid==null && reporttypeid.equals(""))
        	return ret;

        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select * from tf_reports b where b.reportid=? and b.reportid=? and b.state=?");
            int paramCount = 3;
            Object[] aParam = new Object[paramCount];
            int idx = 0;            
            aParam[idx++] = reportid;
            aParam[idx++] = reporttypeid;
            aParam[idx++] = StateEnum.ENABLED;             

            DacClient db = new DacClient();
            ret = db.executeQuery(sql.toString(), aParam);

        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex.getMessage(), ex);

            throw new RuntimeException(ex);
        }

        return ret;
    }	
	
	/**
	 * 
	 */
	
	public static DataTable gettd_reportpara(String cityCode, String reportid) {
        DataTable ret = null;
        
        if(reportid==null || reportid.equals(""))
        	return ret;

        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select * from td_report_para c where c.reportid=? ");
            int paramCount = 1;
            Object[] aParam = new Object[paramCount];
            int idx = 0;            
            aParam[idx] = reportid;          

            DacClient db = new DacClient();
            ret = db.executeQuery(sql.toString(), aParam);

        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex.getMessage(), ex);

            throw new RuntimeException(ex);
        }

        return ret;
    }
	
	/**
	 * 
	 */
	public static DataTable gettd_reportparas(String cityCode, String reportid) {
        DataTable ret = null;
        
        if(reportid==null || reportid.equals(""))
        	return ret;

        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select * from td_report_para c where c.reportid=? and upper(c.controltype) <> 'FIX'");
            int paramCount = 1;
            Object[] aParam = new Object[paramCount];
            int idx = 0;            
            aParam[idx] = reportid;          

            DacClient db = new DacClient();
            ret = db.executeQuery(sql.toString(), aParam);

        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex.getMessage(), ex);

            throw new RuntimeException(ex);
        }

        return ret;
    }	

	/**
	 * 
	 */
	public static int gettd_reportcount(String cityCode, String reportid) {
        int ret = 0;
        
        if(reportid==null || reportid.equals(""))
        	return 0;

        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select count(*) from td_report_para c where c.reportid=?");
            int paramCount = 1;
            Object[] aParam = new Object[paramCount];
            int idx = 0;            
            aParam[idx++] = reportid;          

            DacClient db = new DacClient();
            ret = Integer.parseInt(db.getStringFromSqlQuery(sql.toString(), aParam));

        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex.getMessage(), ex);

            throw new RuntimeException(ex);
        }

        return ret;
    }
	
	/**
	 * 
	 */
	
	public static DataTable getsqlresult(String sql, HashMap hm) {
        DataTable ret = null;
        int place = sql.indexOf("?"); 
        if(place>0)
        	if(hm.isEmpty())
        		return ret;

        try {
        	
            int paramCount = hm.size();
            Object[] aParam = new Object[paramCount];
            
			if(!hm.isEmpty()){
				Set sKeys = hm.keySet();
				Object[] key = sKeys.toArray();
				for(int t=0;t<hm.size();t++){
					//Object value = hm.get(key[t]);
					Object value = hm.get(String.valueOf(t));
					if(value!=null){
						aParam[t] = value; 
						//System.out.println("aParam[t]:"+aParam[t]+" "+t);
					}
				}				
			}        	

            DacClient db = new DacClient();
            ret = db.executeQuery(sql, aParam);

        } catch (Exception ex) {
            FileLogger.getLogger().warn(ex.getMessage(), ex);

            throw new RuntimeException(ex);
        }

        return ret;
    }	
	
    public static String showparam(DataTable _dt,String _citycode) {
    	String sResult = "";  
    	try {  	      	  	      	
  	      	if (_dt.getRows().getCount()>=0){  	      	   
  	      		for (int i=0 ; i < _dt.getRows().getCount() ; i++ ) {
  	      			
  	  	      		sResult += "<tr>" ;
  	  	      		sResult += "<td width=\"10%\" class=\"Caption_Td\" align=\"right\" nowrap=\"nowrap\">" ;
  	  	      		sResult +=  _dt.getRow(i).getString("PARA_CNAME") ;
  	  	      		sResult += "：</td>" ;
  	  	      		sResult += "<td width=\"40%\" align=\"left\" nowrap=\"nowrap\" class=\"body_td\">" +
  	  	      				   "<select name=\"PARA_NAME\" style=\"width: 100%;\">"+
  	  	      				   "<option value=\"\">"+_dt.getRow(i).getString("PARA_NAME")+"</option>"+
  	  	      				   "</select>";
  	  	      		sResult += "</td>" ;
  	  	
      		    sResult += "<td width=\"10%\" class=\"Caption_Td\" align=\"right\" nowrap=\"nowrap\">" ;
	      		sResult +=  "参数值" ;
	      		sResult += "：</td>" ;  
	      		
      		    sResult += "<td width=\"40%\" align=\"left\" nowrap=\"nowrap\" class=\"body_td\">" ;  	  	
  	  	      		if ("TEXT".equals(_dt.getRow(i).getString("CONTROLTYPE"))){
  	  	      			if("CITYCODE".equals(_dt.getRow(i).getString("PARA_NAME")) && _citycode!=null && !_citycode.equals("")){
  	  	      				sResult +="<select NAME=\"PARA_NAMEVALUE"+String.valueOf(i)+"\" style=\"width: 45%;\">"+
  	  	      				   			   "<option value=\""+_citycode+"\">"+_citycode+"</option>"+
  	  	      				          "</select>";
  	  	      			}else{
  	  	      				sResult = sResult + "<INPUT TYPE=\"TEXT\" NAME=\"PARA_NAMEVALUE"+String.valueOf(i)+"\" style=\"width: 45%;\" >" ;
  	  	      			}
  	  	      		}else if ("DATE".equals(_dt.getRow(i).getString("CONTROLTYPE"))){
  	  	      			sResult = sResult + "<INPUT TYPE=\"TEXT\" NAME=\"PARA_NAMEVALUE"+String.valueOf(i)+"\" ID=\""+_dt.getRow(i).getString("PARA_NAME")+"\" >" ;
  	  	      			sResult = sResult + "<span style=\"cursor:hand\" onClick=\"return showCalendar('"+_dt.getRow(i).getString("PARA_NAME")+"', '%Y-%m-%d %H:%M:%S', '24', true);\"  >";
  	  	      			sResult = sResult + "<img border=\"0\" src=\"../calendar/date_botton.gif\" width=\"20\" height=\"14\"></span>";
  	  	      		}  	  	      	
  	  	      		sResult += "</td>" ;
  	  	      		sResult += "</tr>" ;
  	      		}
  	      	}
			
  	    }catch (Exception ex) {
  	  	  FileLogger.getLogger().error(ex.getMessage()) ;
  	    }
    	return sResult ;
    }	
}