reportsysservice.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.rpt;

import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Map;

import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

import com.doone.data.DBTypes;
import com.doone.data.DacClient;
import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.fj1w.fjmgr.statana.Simpreportqry;
import com.doone.util.FileLogger;

/**
 * @说明 这个类用于处理本系统的报表子系统
 *  
 * @author zengzc
 * @version v0.0.1
 * @备注 创建本文当
 * @创建时间 2006-1-8 12:00
 * 
 * @修改历史
 * <li>版本号  	修改日期     修改人  影响面   	 			   修改说明
 * <li>
 * <li>
 * <li>
 */
public class ReportSysService {
	static private FileLogger log = new FileLogger();

    /**
	 * 获取查询内容表的内容视图.
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	static public String getRptList(ServletRequest request, ServletResponse response, Map _map) {
		try {
			if(_map==null || _map.isEmpty())
				return "";
			
			String sReportId = (String)_map.get("reportid");
			
			//获取记录结果
			return ReportImpl.getInstance(Long.parseLong(sReportId)).genHtml(_map);
		} catch (Exception rux) {
			log.warn(rux.getMessage(), rux);
		}

		return null;
	}

	/**
	 * 总记录数
	 */
	static public int getRptCount(ServletRequest request, ServletResponse response, Map _map) {
		String sReportId = (String)_map.get("reportid");
		
		return ReportImpl.getInstance(Long.parseLong(sReportId)).getRptListCount(_map);
	}
	/**
	 * 
	 * @param _map
	 * @return
	 * @throws java.sql.SQLException
	 * @throws RuntimeException
	 */
	static public String getRptSql(java.util.Map _map)
	throws java.sql.SQLException, RuntimeException {
		String s_report_sql = "";
		try {
			if(_map==null || _map.isEmpty())
				return "";
			
			//获取sql语句
			String s_report_id =(String) _map.get("reportid");
			DataTable dt_reports = Simpreportqry.gettf_reports("",s_report_id); 
			
			if(dt_reports!=null){
				for(int it=0;it<dt_reports.getRows().getCount();it++){
					s_report_sql = dt_reports.getRow(it).getString("reportsql");
				}
			}
		} catch (Exception ex) {
			log.warn(ex.getMessage(), ex);
		}
		return s_report_sql;		
	}	
    
}