publicclass.java

来自「电信的网厅的整站代码」· Java 代码 · 共 203 行

package com.doone.fj1w.fjmgr.config;

import com.doone.data.DacClient;
import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.util.FileLogger;


public class PublicClass {
	
	public PublicClass() {
	}
	
	/**获取地市列表
	 * 
	 * @param dbClient
	 * @return
	 */
	public static DataTable getCityList(DacClient dbClient){
		try {
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select ");
			sql.append("Citycode,");
			sql.append("CityName,");
			sql.append("CITYSHORTNAME");
			sql.append(" from ");
			sql.append("td_city");
			dt = dbClient.executeQuery(sql.toString());
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**获取某个城市的信息
	 * 
	 * @param dbClient
	 * @param cityCode
	 * @return
	 */
	public static DataRow getCityInfo(DacClient dbClient,String cityCode){
		try {
			DataRow dr = null;
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select ");
			sql.append("Citycode,");
			sql.append("CityName,");
			sql.append("CITYSHORTNAME");
			sql.append(" from ");
			sql.append("td_city where Citycode=?");
			Object[] aParam = new Object[1];
			aParam[0] = cityCode;//按地域权限的
			dt = dbClient.executeQuery(sql.toString(),aParam);
			dr = dt.getRow(0);
			return dr;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**获取某个城市区域的信息
	 * 
	 * @param dbClient
	 * @param cityCode
	 * @return
	 */
	public static DataRow getAreaInfo(DacClient dbClient,String areaCode){
		try {
			DataRow dr = null;
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("SELECT ");
			sql.append("AREACODE,");
			sql.append("CITYCODE,");
			sql.append("AREANAME,");
			sql.append("STATE");
			sql.append(" FROM ");
			sql.append("td_area where AreaCode=?");
			Object[] aParam = new Object[1];
			aParam[0] = areaCode;//按地域权限的
			dt = dbClient.executeQuery(sql.toString(),aParam);
			dr = dt.getRow(0);
			return dr;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	/**获取某个用户的信息
	 * 
	 * @param dbClient
	 * @param userId
	 * @return
	 */
	public static DataRow getUserInfo(DacClient dbClient,String userId){
		try {
			DataRow dr = null;
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("SELECT ");
			sql.append("*");
			sql.append(" FROM ");
			sql.append("tf_custinfoweb where userId=?");
			Object[] aParam = new Object[1];
			aParam[0] = userId;//按地域权限的
			dt = dbClient.executeQuery(sql.toString(),aParam);
			dr = dt.getRow(0);
			return dr;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**根据FUNCODE获得程控功能信息
	 * 
	 * @param dbClient
	 * @param funCode
	 * @return
	 */
	public static DataRow getProdfunInfoByfunCode(DacClient dbClient,String funCode,String cityCode){
		try {
			ProdfunBean prodfunBean = new ProdfunBean();
			DataRow dr = null;
			DataTable dt = prodfunBean.getChangeTaoCanByCode(dbClient,funCode,cityCode);
			dr = dt.getRow(0);
			return dr;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**根据prodfunId获得程控功能信息
	 * 
	 * @param dbClient
	 * @param funCode
	 * @return
	 */
	public static DataRow getProdfunInfoByprodfunId(DacClient dbClient,String prodfunId){
		try {
			ProdfunBean prodfunBean = new ProdfunBean();
			DataRow dr = null;
			DataTable dt = prodfunBean.getProdfunByProdfunId(dbClient,prodfunId);
			dr = dt.getRow(0);
			return dr;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	/**获取某地市所有的区域列表
	 * 
	 * @param dbClient
	 * @param cityCode
	 * @return
	 */
	public static DataTable getAreaList(DacClient dbClient,String cityCode){
		try {
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("SELECT ");
			sql.append("AREACODE,");
			sql.append("CITYCODE,");
			sql.append("AREANAME,");
			sql.append("STATE");
			sql.append(" FROM ");
			sql.append("TD_AREA ");
			sql.append("WHERE STATE='E'");
			if(cityCode==null || cityCode.equals("")){
				dt = dbClient.executeQuery(sql.toString());
				return dt;
			}
			else{
				sql.append(" AND CITYCODE=?");
				Object[] aParam = new Object[1];
				aParam[0] = cityCode;//按地域权限的
				dt = dbClient.executeQuery(sql.toString(),aParam);
				return dt;
			}
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
}