thirdqueryimpl.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.order.list;

import java.io.IOException;
import java.util.Map;
import com.doone.data.DataTable;
import com.doone.fj1w.fjmgr.order.*;import com.doone.util.FileLogger;
;

public class ThirdQueryImpl extends DAO implements QueryListInterface {
	
	private static final long serialVersionUID = -45315435432342L;
	
	static FileLogger _logger = new FileLogger();
	
	/** 接口取值，现在不确定 */
	// private Object _object = "";
	public ThirdQueryImpl() {
	}
	
	/*
	 * (non-Javadoc)
	 * 
	 * @see com.doone.fj1w.fjmgr.order.list.QueryListInterface#getList(java.util.Map)
	 */
	public DataTable getList(Map map) throws RuntimeException {
		try {
			throw new UnsupportedOperationException("暂时没有实现");
			
		} catch (RuntimeException rux) {
			_logger.warn(rux.getMessage(), rux);
			throw new RuntimeException(rux);
		}
	}
	
	/**
	 * <code>服务性质<code>
	 * @param map
	 * @return
	 * @throws RuntimeException
	 */
	static public DataTable getServiceType(Map map) throws RuntimeException {
		
		try {
			if (map == null)
				throw new NullPointerException("getServiceType方法的入参为空");
			
			String servicetype = (String) map.get("SERVITYPE");
			String citycode = (String) map.get("CITYCODE");
			
			DataTable _db = BssInter3.callWebQryMenuFold(servicetype, citycode);
			
			return _db;
			
		} catch (IOException iox) {
			_logger.warn(iox.getMessage(), iox);
			throw new RuntimeException(iox);
		} catch (RuntimeException rux) {
			_logger.warn(rux.getMessage(), rux);
			throw new RuntimeException(rux);
		}
	}

	/**
	 * <code>
	 *  服务性质,引用前台那棵树。
	 * <code>
	 * @param map
	 * @return
	 * @throws RuntimeException
	 */
	static public String getServiceTypeTree(Map map) throws RuntimeException {
		
		try {
			if (map == null)
				throw new NullPointerException("getServiceType方法的入参为空");
			
			String servicetype = (String) map.get("SERVITYPE");
			String citycode    = (String) map.get("CITYCODE");
			String contentPath = (String) map.get("CONTENT");
			
			DataTable _db = BssInter3.callWebQryMenuFold(servicetype, citycode);
			if (_db == null || _db.getRows().getCount() == 0)
				return "";
			// LEVEL    层次  String  
			// PROD_TYPEiPROD_TYPE_ID  产品类型编码  String  
			// PROD_TYPEiPROD_TYPE_NAME    产品类型名称  String  
			// PRODiPROD_ID    产品编码    String  
			// PRODiPROD_NAME  产品名称    String  
			StringBuffer _sb = new StringBuffer();
			
			_sb.append("<link rel='StyleSheet' href='");
			_sb.append(contentPath);
			_sb.append("/common/img/dtree.css' type='text/css' />");
			_sb.append("<script type='text/javascript' src='");
			_sb.append(contentPath);
			_sb.append("/common/img/dtree.js'></script>");
			_sb.append("<table width='100%'  border='0' align='left' cellpadding='0' cellspacing='2'");
			_sb.append(" style='table-layout:fixed;word-break:break-all'>");
			_sb.append("<tr>");
			_sb.append("<td width='2%' align='left'>&nbsp;</td>");
			_sb.append("<td width='96%' align='left'>");
			_sb.append("<div class='dtree'>");
			_sb.append("<script type=\"text/javascript\">");
			_sb.append("d = new dTree('d','");
			_sb.append(contentPath);
			_sb.append("/common/');");
			
			for (int i = 0; i < _db.getRows().getCount(); i++) {
				
				String level = _db.getRow(i).getString("LEVEL");
				if (level == null || level.equals("")) {
					level = "3";
				}
				
				String PRODiPROD_ID = _db.getRow(i).getString("PRODiPROD_ID");
				try {
					switch (Integer.parseInt(level)) {
					case 1://第一层
						_sb.append("d.add(");
						_sb.append(_db.getRow(i).getString("PROD_TYPEiPROD_TYPE_ID"));
						_sb.append(",0,'");
//						_sb.append("<span onclick = 'fuc_clickme('");
//						_sb.append(_db.getRow(i).getString("PROD_TYPEiPROD_TYPE_ID"));
//						_sb.append("~");
//						_sb.append(_db.getRow(i).getString("PROD_TYPEiPROD_TYPE_NAME"));
//						_sb.append("')' >");
//						_sb.append(_db.getRow(i).getString("PROD_TYPEiPROD_TYPE_NAME"));
//						_sb.append("</span>");
						_sb.append("','','','','");
						_sb.append(contentPath);
						_sb.append("/common/img/icon_5.gif');" );
						break;
					case 2://第二层
					case 3://第三层
						if(PRODiPROD_ID != null && !PRODiPROD_ID.equals("")){
						
							_sb.append("d.add(");
							_sb.append(PRODiPROD_ID);
							_sb.append(",");
							_sb.append(_db.getRow(i).getString("PROD_TYPEiPROD_TYPE_ID"));
							_sb.append(",'");
//							_sb.append("<span onclick = 'fuc_clickme('");
//							_sb.append(PRODiPROD_ID);
//							_sb.append("~");
//							_sb.append(_db.getRow(i).getString("PRODiPROD_NAME"));
//							_sb.append("')' >");
//							_sb.append(_db.getRow(i).getString("PRODiPROD_NAME"));
//							_sb.append("</span>");
							_sb.append("','','','','");
							_sb.append(contentPath);
							_sb.append("/common/img/icon_5.gif');" );
							
						}
						break;
						
					}
				} catch (RuntimeException rux) {
					_logger.warn(rux.getMessage(), rux);
				}
				
			}
			
			_sb.append(" document.write(d);");
			_sb.append(" </script>");
			_sb.append(" </div><br>");
			_sb.append(" </td>");
			_sb.append(" <td width=\"2%\" align=\"left\">&nbsp;</td>");
			_sb.append(" </tr>");
			_sb.append(" </table>"); 
			
			return _sb.toString();
		} catch (Exception ex) {
			_logger.warn(ex.getMessage(), ex);
		}
		return "";
	}
	
	/**
	 * <code>查询帐务周期信息</code>
	 * 
	 * @param map
	 * @return
	 * @throws RuntimeException
	 */
	static public DataTable getBillCycly(Map map) throws RuntimeException {
		try {
			if (map == null)
				throw new NullPointerException("getBillCycly方法的入参为空");
			
			String citycode = (String) map.get("CITYCODE");
			return BssInter3.callWebQryBILLCYCLE(citycode);
			
		} catch (IOException iox) {
			_logger.warn(iox.getMessage(), iox);
			throw new RuntimeException(iox);
		} catch (RuntimeException rux) {
			_logger.warn(rux.getMessage(), rux);
			throw new RuntimeException(rux);
		}
	}
	
	/**
	 * <code>查询帐目类型</code>
	 * 
	 * @param map
	 * @return DataTable
	 * @throws RuntimeException
	 */
	static public DataTable getLedger(Map map) throws RuntimeException {
		try {
			if (map == null)
				throw new NullPointerException("getLedger方法的入参为空");
			
			String servicetype = (String) map.get("SERVITYPE");
			String citycode = (String) map.get("CITYCODE");
			
			return BssInter3.callWebQryAcctItem(servicetype, citycode);
			
		} catch (IOException iox) {
			_logger.warn(iox.getMessage(), iox);
			throw new RuntimeException(iox);
		} catch (RuntimeException rux) {
			_logger.warn(rux.getMessage(), rux);
			throw new RuntimeException(rux);
		}
	}
	
	/**
	 * <code>
	 *   获取bss系统 sp-status表里的列表
	 * </code>
	 * 
	 * @return DataTable
	 * @throws RuntimeException
	 */
	static public DataTable getSPStatus(Map map) throws RuntimeException {
		try {
			if (map == null)
				throw new NullPointerException("getLedger方法的入参为空");
			
			String SP_STATUSiTAB_NAME = (String) map.get("SP_STATUSiTAB_NAME");
			String SP_STATUSiCOL_NAME = (String) map.get("SP_STATUSiCOL_NAME");
			String CITYCODE = (String) map.get("CITYCODE");
			
			return BssInter2.callWebQrySPSTATUS(SP_STATUSiTAB_NAME,
					SP_STATUSiCOL_NAME, CITYCODE);
			
		} catch (IOException iox) {
			_logger.warn(iox.getMessage(), iox);
			throw new RuntimeException(iox);
		} catch (RuntimeException rux) {
			_logger.warn(rux.getMessage(), rux);
			throw new RuntimeException(rux);
		}
	}
	
	/**
	 * <code>
	 *   优惠类型
	 * </code>
	 * 
	 * @param map
	 * @return
	 * @throws RuntimeException
	 */
	static public DataTable getWebQryDisctType(Map map) throws RuntimeException {
		try {
			if (map == null)
				throw new NullPointerException("getLedger方法的入参为空");
			
			String AREAID = (String) map.get("SERVIAREA_ID");
			String CITYCODE = (String) map.get("CITYCODE");
			
			return BssInter4.callWebQryDisctType("", "", "", "", "", "",
					AREAID, "", "", "", "", "", CITYCODE);
			
		} catch (IOException iox) {
			_logger.warn(iox.getMessage(), iox);
			throw new RuntimeException(iox);
		} catch (RuntimeException rux) {
			_logger.warn(rux.getMessage(), rux);
			throw new RuntimeException(rux);
		}
	}
	
}