bssinter2.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.order;

import java.io.IOException;
import java.util.Hashtable;

import com.doone.data.DataTable;
import com.doone.iossp.EMessage;
import com.doone.iossp.FormBody;
import com.doone.util.FileLogger;

public class BssInter2 {

	public BssInter2() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * <p>
	 * 查询服务类型信息
	 * </p>
	 * 
	 * @param citycode
	 * @return SERV_TYPEiSERV_TYPE_ID 服务类型编码 String SERV_TYPEiSERV_TYPE_NAME
	 *         服务类型名称 String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */
	static public DataTable callWebQryServType(String citycode) throws IOException, RuntimeException {
		String methodname = "WebQryServType";

		Hashtable ht = new Hashtable();
		ht.put("OPER_LOG_ID", "QZ00015822");
		ht.put("STAFF_ID", "QZ02900");
		ht.put("AREA_ID", "33");
		ht.put("SERIAL1", "20030318200330342682032");
		ht.put("SERIAL2", "1");
		ht.put("SERIAL3", "1");
		ht.put("MODULE_ID", "1");
		ht.put("MENU_ID", "1");
		ht.put("OPER_CODE", "A");

		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);
		EMessage msg = new EMessage(result);
		if ("".equals(msg.getBody()))
			return null;

		return msg.getDataTableBody();
	}

	/**
	 * <p>
	 * 查询申请类型信息
	 * </p>
	 * 
	 * @param citycode
	 * @return SO_TYPEiSO_TYPE_ID 申请类型编码 String SO_TYPEiSO_TYPE_NAME 申请类型名称
	 *         String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */

	public static DataTable callWebQrySoType(String citycode) throws IOException, RuntimeException {
		String methodname = "WebQrySoType";
		Hashtable ht = new Hashtable();
		ht.put("OPER_LOG_ID", "QZ00015822");
		ht.put("STAFF_ID", "QZ02900");
		ht.put("AREA_ID", "33");
		ht.put("SERIAL1", "20030318200330342682032");
		ht.put("SERIAL2", "1");
		ht.put("SERIAL3", "1");
		ht.put("MODULE_ID", "1");
		ht.put("MENU_ID", "1");
		ht.put("OPER_CODE", "A");
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);
		// System.out.println("result111=>"+result);
		EMessage msg = new EMessage(result);
		if ("".equals(msg.getBody()))
			return null;

		return msg.getDataTableBody();
	}

	/**
	 * <p>
	 * 查询地区信息
	 * </p>
	 * 
	 * @param AREA_INFOiUP_AREA_ID
	 *            上级地区 String 默认传6（表示泉州地区）；不传则返回全省地区
	 * @param citycode
	 * @return AREA_INFOiAREA_ID 地区编码 String AREA_INFOiAREA_CODE 地区代码 String
	 *         AREA_INFOiAREA_SIMP_NAME 地区简拼 String AREA_INFOiNAME 地区名称 String
	 *         AREA_INFOiAREA_TYPE 地区类型 String AREA_INFOiUP_AREA_ID 上级地区编码
	 *         String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */
	static public DataTable callWebQryAreaInfo(String AREA_INFOiUP_AREA_ID, String citycode) throws IOException,
			RuntimeException {
		Hashtable ht = new Hashtable();
		ht.put("AREA_INFOiUP_AREA_ID", AREA_INFOiUP_AREA_ID);

		String methodname = "WebQryAreaInfo";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);

		EMessage msg = new EMessage(result);
		if ("".equals(msg.getBody()))
			return null;

		return msg.getDataTableBody();
	}

	/**
	 * <p>
	 * 根据地区编码、所属管理区编码、局向类型等，查询局向信息
	 * </p>
	 * 
	 * @param EXCHiAREA_ID
	 *            地区编码 String 可空
	 * @param EXCHiMANAGE_AREA_ID
	 *            所属管理区 String 可空
	 * @param EXCHiEXCH_TYPE
	 *            局向类型 String 可空
	 * 
	 * @return EXCHiEXCH_ID 局向编码 String EXCHiEXCH_CODE 局向代码 String
	 *         EXCHiEXCH_NAME 局向名称 String EXCHiEXCH_TYPE 局向类型 String
	 *         EXCHiMANAGE_AREA_ID 管理区编码 String EXCHiAREA_ID 地区编码 String
	 *         AREA_INFOiNAME 地区名称 String TEMP_STS_WORDS1 局向类型名称 String
	 *         MANAGE_AREAiMANAGE_AREA_NAME 管理区名称 String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */
	static public DataTable callWebQryExch(String EXCHiAREA_ID, String EXCHiMANAGE_AREA_ID, String EXCHiEXCH_TYPE,
			String citycode) throws IOException, RuntimeException {
		EMessage msg = null;
		try {
		Hashtable ht = new Hashtable();
		ht.put("EXCHiAREA_ID", EXCHiAREA_ID);
		ht.put("EXCHiMANAGE_AREA_ID", EXCHiMANAGE_AREA_ID);
		ht.put("EXCHiEXCH_TYPE", EXCHiEXCH_TYPE);

		String methodname = "WebQryExch";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);
		msg = new EMessage(result);
		if (msg == null || "".equals(msg.getBody()))
			return null;
		else
			return msg.getDataTableBody();
		}catch(Exception e) {
			FileLogger.getLogger().warn(e.getMessage(),e);
		}

		return null;
	}

	/**
	 * <p>
	 * 查询字段意思信息
	 * </p>
	 * 
	 * @param SP_STATUSiTAB_NAME
	 *            表名 String
	 * @param SP_STATUSiCOL_NAME
	 *            字段名 String
	 * 
	 * @return SP_STATUSiSTS_ID 字段值 String SP_STATUSiSTS_WORDS 显示说明 String
	 *         SP_STATUSiSTS_DESC 具体备注说明 String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */
	static public DataTable callWebQrySPSTATUS(String SP_STATUSiTAB_NAME, String SP_STATUSiCOL_NAME, String citycode)
			throws IOException, RuntimeException {
		EMessage msg = null;
		try {
		Hashtable ht = new Hashtable();
		ht.put("SP_STATUSiTAB_NAME", SP_STATUSiTAB_NAME);
		ht.put("SP_STATUSiCOL_NAME", SP_STATUSiCOL_NAME);

		String methodname = "WebQrySPSTATUS";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);
		msg = new EMessage(result);
		if (msg == null || "".equals(msg.getBody()))
			return null;
		else
			return msg.getDataTableBody();
		}catch(Exception e) {
			FileLogger.getLogger().warn(e.getMessage(),e);
		}
		return null;
	}

	/**
	 * <code>
	 *   接口字段意思单个值获取
	 *   *: 无值或异常返回空字符.
	 * </code>
	 * 
	 * @param SP_STATUSiTAB_NAME
	 * @param SP_STATUSiCOL_NAME
	 * @param citycode
	 * @param value
	 * @return string
	 */
	static public String getMean(String SP_STATUSiTAB_NAME, String SP_STATUSiCOL_NAME, String citycode, String value) {

		DataTable dt = null;
		try {
			dt = callWebQrySPSTATUS(SP_STATUSiTAB_NAME, SP_STATUSiCOL_NAME, citycode);
		} catch (Exception ex) {
			return "";
		}

		if (dt == null || dt.getRows().getCount() == 0)
			return "";

		int i = dt.getRows().getCount();
		for (; --i >= 0 && !value.equals(dt.getRow(i).getString("SP_STATUSiSTS_ID"));)
			;

		if (i >= 0)
			return dt.getRow(i).getString("SP_STATUSiSTS_WORDS");

		return "";
	}

	/**
	 * <p>
	 * 根据地区查询根目录地址信息
	 * </p>
	 * 
	 * @param AREA_INFOiAREA_ID
	 *            地区编码 String 必填
	 * 
	 * @return SUB_ADDRiSUB_ADDR_NAME 根目录地址名称 String SUB_ADDRiSUB_ADDR_ID
	 *         根目录地址编码 String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */
	static public DataTable callWebQryAddrRoot(String AREA_INFOiAREA_ID, String citycode) throws IOException,
			RuntimeException {

		Hashtable ht = new Hashtable();
		ht.put("AREA_INFOiAREA_ID", AREA_INFOiAREA_ID);

		String methodname = "WebQryAddrRoot";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);

		EMessage msg = new EMessage(result);
		if ("".equals(msg.getBody()))
			return null;

		return msg.getDataTableBody();
	}

	/**
	 * <p>
	 * 根据地区和上一层的地址编码查询出下一层的所有地址
	 * </p>
	 * 
	 * @param SUB_ADDRiAREA_ID
	 *            地区编码 String 必填
	 * @param SUB_ADDRiUP_SUB_ADDR_ID
	 *            上一层的地址编码 String 必填
	 * 
	 * @return SUB_ADDRiSUB_ADDR_NAME 下一层地址名称 String SUB_ADDRiSUB_ADDR_ID
	 *         下一层地址编码 String
	 * 
	 */
	static public DataTable callWebQryAddr(String SUB_ADDRiAREA_ID, String SUB_ADDRiUP_SUB_ADDR_ID, String citycode)
			throws IOException, RuntimeException {

		Hashtable ht = new Hashtable();
		ht.put("SUB_ADDRiAREA_ID", SUB_ADDRiAREA_ID);
		ht.put("SUB_ADDRiUP_SUB_ADDR_ID", SUB_ADDRiUP_SUB_ADDR_ID);

		String methodname = "WebQryAddr";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);

		EMessage msg = new EMessage(result);
		if ("".equals(msg.getBody()))
			return null;

		return msg.getDataTableBody();
	}

	/**
	 * <p>
	 * 查询员工信息
	 * </p>
	 * 
	 * @param STAFFiSTAFF_ID
	 *            员工编码(可传入多个编码) String 第一种方法时必填
	 * 
	 * @return STAFFiSTAFF_ID 员工编码 String STAFFiSTAFF_GRADE_ID 员工级别编码 String
	 *         STAFF_GRADEiSTAFF_GRADE_NAME 员工级别名称 String STAFFiSITE_ID 操作点编码
	 *         String WORK_GROUPiSITE_NAME 操作点名称 String STAFFiMENU_PROJECT_ID
	 *         菜单方案编码 String MENU_PROJECTiPROJECT_NAME 菜单方案名称 String
	 *         STAFFiSTAFF_CODE 员工代码 String STAFFiSTAFF_NAME 员工姓名 String
	 *         STAFFiCERT_TYPE_ID 证件类型编码 String CERT_TYPEiCERT_TYPE_NAME 证件类型名称
	 *         String STAFFiCERT_NBR 证件号码 String STAFFiCONTACT_TEL 联系电话 String
	 *         STAFFiHOME_ADDR 地址信息 String AREA_INFOiAREA_ID 地区编码 String
	 *         AREA_INFOiNAME 地区名称 String STAFFiMODI_DATE 修改日期 String
	 * 
	 */
	static public FormBody callWebQryStaffInfo(String STAFFiSTAFF_ID, String citycode) throws IOException,
			RuntimeException {
		Hashtable ht = new Hashtable();
		ht.put("STAFFiSTAFF_ID", STAFFiSTAFF_ID);

		String methodname = "WebQryStaffInfo";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);
		FormBody fb = new FormBody();
		fb.fromXML(result);
		return fb;
	}

	/**
	 * <p>
	 * 提取客户详尽信息查询
	 * </p>
	 * 
	 * @param OPER_LOG_ID
	 *            操作日志编码(固定一个值) String (暂时：QZ00015822)
	 * @param CUSTiCUST_ID
	 *            客户编码 String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */
	static public BssReferCustBean callWebQryCustPatic(String OPER_LOG_ID, String CUSTiCUST_ID, String citycode)
			throws IOException, RuntimeException {
		Hashtable ht = new Hashtable();
		ht.put("OPER_LOG_ID", OPER_LOG_ID);
		ht.put("CUSTiCUST_ID", CUSTiCUST_ID);

		String methodname = "WebQryCustPatic";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);

		FormBody fb = new FormBody();
		fb.fromXML(result);

		if (fb == null)
			throw new RuntimeException("提取客户详尽信息查询为空.");

		BssReferCustBean _brCB = new BssReferCustBean();
		_brCB.parFormBody(fb);

		return _brCB;
	}

	public static DataTable call_webQryCustPatic(String OPER_LOG_ID, String CUSTiCUST_ID, String citycode)
			throws IOException, RuntimeException {
		FormBody fb = null;
		try {
			Hashtable ht = new Hashtable();
			ht.put("OPER_LOG_ID", OPER_LOG_ID);
			ht.put("CUSTiCUST_ID", CUSTiCUST_ID);
//System.out.println(citycode + "::" + ht);
			String methodname = "WebQryCustPatic";
			String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);

			fb = new FormBody();
			fb.fromXML(result);
			if (fb == null)
				throw new RuntimeException("提取客户详尽信息查询为空.");

		} catch (Exception e) {
            e.printStackTrace();
            FileLogger.getLogger().info(e.getMessage(),e);
		}

		return fb.toDataTable();
	}

	/**
	 * <p>
	 * 查询积分信息
	 * </p>
	 * 
	 * @param SERViSERV_ID
	 *            用户唯一标识 String
	 * 
	 * @return SERViSERV_ID 用户唯一标识 String SERV_TYPEiSERV_TYPE_ID 服务类型标识 String
	 *         SERV_TYPEiSERV_TYPE_NAME 服务类型名称 String INTEGRAL_TOTALiID 积分管理代码
	 *         String SO_PROD_ADDINFOiSEQ 序号 String
	 *         INTEGRAL_CONFIGiINTEGRAL_TYPE_ID 积分类型代码 String
	 *         INTEGRAL_CONFIGiINTEGRAL_TYPE_NAME 积分类型名称 String
	 *         INTEGRAL_TOTALiINTEGRAL_SUM 积分总数 String INTEGRAL_TOTALiEFF_DATE
	 *         生效时间 String INTEGRAL_TOTALiEXP_DATE 失效时间 String
	 *         SERV_PROTOCOL_INFOiBEGIN_DATE 登记时间 String
	 * 
	 * @throws IOException
	 * @throws RuntimeException
	 */
	static public FormBody callWebQryIntegral(String SERViSERV_ID, String citycode) throws IOException,
			RuntimeException {
		Hashtable ht = new Hashtable();
		ht.put("SERViSERV_ID", SERViSERV_ID);

		String methodname = "WebQryIntegral";
		String result = CallTuxdoInter.callTuxdo(ht, CallTuxdoInter.BSS_SERVICENAME, citycode, methodname);
		FormBody fb = new FormBody();
		fb.fromXML(result);
		return fb;
	}
}