movephonebean.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.order;

import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Map;

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

public class MovePhoneBean extends TF_BSSFlowRecord {
	private SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

	MovePhoneBean() {
		super();
	}

	MovePhoneBean(DacClient db, long objId) {
		super(db, objId);
	}

	MovePhoneBean(DacClient db) {
		super(db);
	}

	MovePhoneBean(DataRow dr) {
		super(dr);
	}

	public String getRecordIDS(String name) {
		if (name != null)
			name = name.toUpperCase();
		return super.getRecordIDS(name);
	}

	public void setRecordIDS(String name, String str) {
		if (name != null)
			name = name.toUpperCase();

		super.setRecordIDS(name, str);
	}

	public static MovePhoneBean getMovePhoneBean(DacClient db, long lProdOrderId) {
		TF_BSSFlowRecord flow = TF_BSSFlowRecord.getBSSFlowRecord(db, lProdOrderId);
		MovePhoneBean bean = new MovePhoneBean(flow.getDataRow());
		bean.dbClient = db;
		bean.childOrder = flow.childOrder;
		bean.tf_prodOrder = flow.tf_prodOrder;

		return bean;
	}

	public DataTable getBSSCustBean() {
		return getRecordFrom(BSSParamName.CUST_ARCHIVES_TABLE);
	}

	public void setBSSCustBean(DataTable custBean) {
		// 设置相关关键值。
		if (custBean != null) {
			if (custBean.getRows().getCount() > 0) {
				DataRow row = custBean.getRow(0);
				String sServID = row.getString(BSSParamName.CUST_ARCHIVES_SERV_ID);
				String sServTypeID = custBean.getRow(0).getString(BSSParamName.CUST_ARCHIVES_SERV_TYPE_ID);
				setRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_ID, sServID);
				setRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_TYPE_ID, sServTypeID);
				setRecordIDS(BSSParamName.CUST_ARCHIVES_CUST_ID, row.getString(BSSParamName.CUST_ARCHIVES_CUST_ID));
			}

			setRecordFrom(custBean, BSSParamName.CUST_ARCHIVES_TABLE);
		}
	}

	public DataTable getWebAccessBean() {
		return getRecordFrom(BSSParamName.WEB_ACCESS_TABLE);
	}

	public void setWebAccessBean(DataTable webAccess) {
		if (webAccess != null && webAccess.getRows().getCount() > 0) {
			setRecordFrom(webAccess, BSSParamName.WEB_ACCESS_TABLE);

			setRecordIDS(BSSParamName.WEB_ACCESS_ACCESS_ID, webAccess.getRow(0).getString(
					BSSParamName.WEB_ACCESS_ACCESS_ID));
			setRecordIDS(BSSParamName.WEB_ACCESS_EXCH_ID, webAccess.getRow(0)
					.getString(BSSParamName.WEB_ACCESS_EXCH_ID));
		}
	}

	public DataTable getAccNodeBean() {
		return getRecordFrom(BSSParamName.ACCNODE_TABLE);
	}

	public void setAccNodeBean(DataTable webAccess) {
		if (webAccess != null && webAccess.getRows().getCount() > 0) {
			setRecordFrom(webAccess, BSSParamName.ACCNODE_TABLE);
			setRecordIDS(BSSParamName.ACCNODE_ACC_NODE_ID, webAccess.getRow(0).getString(
					BSSParamName.ACCNODE_ACC_NODE_ID));
		}
	}

	public void setArchiveTable(DataTable dt, String sTableName) {
		if (dt != null && dt.getRows().getCount() > 0) {
			setRecordFrom(dt, sTableName);
		}
	}

	public DataTable callQryServFor(Map _map) {
		try {
			String QRY_OPER_MODEL = (String) _map.get("QRY_OPER_MODEL");
			String KEY_WORD = (String) _map.get("KEY_WORD");
			String CUSTiCUST_NAME = (String) _map.get("CUSTiCUST_NAME");
			String CORP_CUSTiCUST_ABBR = (String) _map.get("CORP_CUSTiCUST_ABBR");
			String CUSTiCUST_SIMP_NAME = (String) _map.get("CUSTiCUST_SIMP_NAME");
			String ACCTiACCT_NBR = (String) _map.get("ACCTiACCT_NBR");
			String CUSTiVIP = (String) _map.get("CUSTiVIP");
			String CUSTiCERT_NBR = (String) _map.get("CUSTiCERT_NBR");
			String SERV_ACC_NBRiSERV_ACC_NBR = (String) _map.get("SERV_ACC_NBRiSERV_ACC_NBR");
			String SERV_ACC_NBRiACC_NBR_AB = (String) _map.get("SERV_ACC_NBRiACC_NBR_AB");
			String SERV_ACCTiACCT_ID = (String) _map.get("SERV_ACCTiACCT_ID");
			String SERV_DATA_ACCESS_INiACC_SERV_ID = (String) _map.get("SERV_DATA_ACCESS_INiACC_SERV_ID");
			String SO_SPECIAL_NBRSiNBR = (String) _map.get("SO_SPECIAL_NBRSiNBR");
			String SERV_ACCESSiADDR_ID = (String) _map.get("SERV_ACCESSiADDR_ID");
			String FLAG1 = (String) _map.get("FLAG1");
			String SERViSERV_TYPE_ID = (String) _map.get("SERViSERV_TYPE_ID");
			String SERViAREA_ID = (String) _map.get("SERViAREA_ID");
            if ( ExtString.isEmpty(SERViAREA_ID) ) SERViAREA_ID = getRecordIDS("AREAID");
			String CITYCODE = (String) _map.get("CITYCODE");
            if ( ExtString.isEmpty(CITYCODE) ) CITYCODE = getRecordIDS("CITYCODE");

			QRY_OPER_MODEL = (QRY_OPER_MODEL == null) ? "" : QRY_OPER_MODEL;
			KEY_WORD = (KEY_WORD == null) ? "" : KEY_WORD;
			CUSTiCUST_NAME = (CUSTiCUST_NAME == null) ? "" : CUSTiCUST_NAME;
			CORP_CUSTiCUST_ABBR = (CORP_CUSTiCUST_ABBR == null) ? "" : CORP_CUSTiCUST_ABBR;
			CUSTiCUST_SIMP_NAME = (CUSTiCUST_SIMP_NAME == null) ? "" : CUSTiCUST_SIMP_NAME;
			ACCTiACCT_NBR = (ACCTiACCT_NBR == null) ? "" : ACCTiACCT_NBR;
			CUSTiVIP = (CUSTiVIP == null) ? "" : CUSTiVIP;
			CUSTiCERT_NBR = (CUSTiCERT_NBR == null) ? "" : CUSTiCERT_NBR;
			SERV_ACC_NBRiSERV_ACC_NBR = (SERV_ACC_NBRiSERV_ACC_NBR == null) ? "" : SERV_ACC_NBRiSERV_ACC_NBR;
			SERV_ACC_NBRiACC_NBR_AB = (SERV_ACC_NBRiACC_NBR_AB == null) ? "" : SERV_ACC_NBRiACC_NBR_AB;
			SERV_ACCTiACCT_ID = (SERV_ACCTiACCT_ID == null) ? "" : SERV_ACCTiACCT_ID;
			SERV_DATA_ACCESS_INiACC_SERV_ID = (SERV_DATA_ACCESS_INiACC_SERV_ID == null) ? ""
					: SERV_DATA_ACCESS_INiACC_SERV_ID;
			SO_SPECIAL_NBRSiNBR = (SO_SPECIAL_NBRSiNBR == null) ? "" : SO_SPECIAL_NBRSiNBR;
			SERV_ACCESSiADDR_ID = (SERV_ACCESSiADDR_ID == null) ? "" : SERV_ACCESSiADDR_ID;
			SERViSERV_TYPE_ID = (SERViSERV_TYPE_ID == null) ? "" : SERViSERV_TYPE_ID;
			SERViAREA_ID = (SERViAREA_ID == null) ? "" : SERViAREA_ID;
			FLAG1 = (FLAG1 == null) ? "" : FLAG1;

			return BssInter5.callWebQryServFor(QRY_OPER_MODEL, KEY_WORD, CUSTiCUST_NAME, CORP_CUSTiCUST_ABBR,
					CUSTiCUST_SIMP_NAME, ACCTiACCT_NBR, CUSTiVIP, CUSTiCERT_NBR, SERV_ACC_NBRiSERV_ACC_NBR,
					SERV_ACC_NBRiACC_NBR_AB, SERV_ACCTiACCT_ID, SERV_DATA_ACCESS_INiACC_SERV_ID, SO_SPECIAL_NBRSiNBR,
					SERV_ACCESSiADDR_ID, SERViSERV_TYPE_ID, SERViAREA_ID, FLAG1, CITYCODE);

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

		return null;
	}

	public DataTable callQryAddr(String preAddId) {
		try {
			String areaId = getRecordIDS("AREAID");
			String cityCode = getRecordIDS("CITYCODE");

			if (preAddId != null) {
				return BssInter2.callWebQryAddr(areaId, preAddId, cityCode);
			} else {
				return BssInter2.callWebQryAddrRoot(areaId, cityCode);
			}
		} catch (Exception ex) {
			FileLogger.getLogger().info(ex.getMessage(), ex);
		}

		return null;
	}

	public DataTable callQryExch() {
		try {
			String areaId = getRecordIDS("AREAID");
			String cityCode = getRecordIDS("CITYCODE");

			return BssInter2.callWebQryExch(areaId, "", "", cityCode);
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}

		return null;
	}

	public DataTable callQryAccNode() {
		try {
			String exchId = getRecordIDS(BSSParamName.EXCH_EXCH_ID);
			String cityCode = getRecordIDS("CITYCODE");

			return BssInter6.callWebQryAccNode(exchId, cityCode);
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}

		return null;
	}
	
	public String callCheckSoAlter() {
		String sResult = null;
		try {
			String sMenu_Id = getRecordIDS(BSSParamName.OTHER_MENU_ID);
			String sSo_Type_Id = getRecordIDS(BSSParamName.OTHER_SO_TYPE_ID);
			String sServ_Type_Id = getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_TYPE_ID);
			String sArea_Id = getRecordIDS("AREAID");
			String sServ_Id = getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_ID);
			String sCityCode = getRecordIDS("CITYCODE");

			Map result = BssInter1.callWebCheckSoAlter(sMenu_Id, sSo_Type_Id, sServ_Type_Id, sArea_Id, sServ_Id,
					sCityCode);

			if (result.get("TEMP_STS_WORDS1").equals("2")) {
				sResult = "2::" + (String) result.get("TEMP_STS_WORDS2");
			} else if (result.get("TEMP_STS_WORDS1").equals("0")) {
				sResult = "0::" + (String) result.get("ERROR_INFO");
			}
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
			
			sResult = "服务查询异常。";
		}

		return sResult;
	}

	public boolean callLockService() {
		boolean sResult = false;
		try {
			String sServ_Id = getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_ID);
			String sCityCode = getRecordIDS("CITYCODE");

			BssInter1.callWebServUnLock(sServ_Id, "1661011", sCityCode);
			sResult = true;
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}

		return sResult;
	}

	public DataSet callQryServByPhone() {
		// 检查ADSL档案信息是否存在，如果不存在则先取ADSL档案信息。
		if (getRecordFrom(BSSParamName.ARCHIVE_INFO_TABLE) == null) {
			String sServID = getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_ID);
			String sServTypeID = getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_TYPE_ID);

			DataSet dtSet = callQryServ(sServTypeID, sServID);
			if (dtSet != null) {
				DataTable dts[] = dtSet.getTables();
				for (int i = 0; i < dts.length; i++) {
					setArchiveTable(dts[i], dts[i].getTableName());
				}

				DataTable archive = dtSet.getDataTable(BSSParamName.ARCHIVE_INFO_TABLE);
				DataTable nwk = dtSet.getDataTable(BSSParamName.NWK_TABLE);
				if (archive != null && archive.getRows().getCount() > 0) {
					setRecordIDS(BSSParamName.ARCHIVE_INFO_PROD_ID, archive.getRow(0).getString(
							BSSParamName.ARCHIVE_INFO_PROD_ID));
					setRecordIDS(BSSParamName.ARCHIVE_INFO_SECRE_GRADE_ID, archive.getRow(0).getString(
							BSSParamName.ARCHIVE_INFO_SECRE_GRADE_ID));
					setRecordIDS(BSSParamName.ARCHIVE_INFO_LIMIT_DATE, archive.getRow(0).getString(
							BSSParamName.ARCHIVE_INFO_LIMIT_DATE));
					setRecordIDS(BSSParamName.ARCHIVE_INFO_BESP_DATE, archive.getRow(0).getString(
							BSSParamName.ARCHIVE_INFO_BESP_DATE));
				}

				if (nwk != null && nwk.getRows().getCount() > 0) {
					setRecordIDS(BSSParamName.NWK_SERV_ACC_NBR, nwk.getRow(0).getString(BSSParamName.NWK_SERV_ACC_NBR));
				}
			}

			return dtSet;
		}

		return new DataSet();
	}

	public DataSet callQryServByADSL() {
		// 检查ADSL档案信息是否存在，如果不存在则先取ADSL档案信息。
		if (getRecordFrom(BSSParamName.OTHER_ADSL_PREV + BSSParamName.ARCHIVE_INFO_TABLE) == null) {
			String sServID = getRecordIDS(BSSParamName.OTHER_ADSL_PREV + BSSParamName.CUST_ARCHIVES_SERV_ID);
			String sServTypeID = getRecordIDS(BSSParamName.OTHER_ADSL_PREV + BSSParamName.CUST_ARCHIVES_SERV_TYPE_ID);
			DataSet dtSet = callQryServ(sServTypeID, sServID);
			if (dtSet != null) {
				DataTable dts[] = dtSet.getTables();
				for (int i = 0; i < dts.length; i++) {
					setArchiveTable(dts[i], BSSParamName.OTHER_ADSL_PREV + dts[i].getTableName());
				}

				DataTable archive = getRecordFrom(BSSParamName.OTHER_ADSL_PREV + BSSParamName.ARCHIVE_INFO_TABLE);

				if (archive != null && archive.getRows().getCount() > 0) {
					setRecordIDS(BSSParamName.OTHER_ADSL_PREV + BSSParamName.ARCHIVE_INFO_PROD_ID, archive.getRow(0)
							.getString(BSSParamName.ARCHIVE_INFO_PROD_ID));
					setRecordIDS(BSSParamName.OTHER_ADSL_PREV + BSSParamName.ARCHIVE_INFO_SECRE_GRADE_ID, archive
							.getRow(0).getString(BSSParamName.ARCHIVE_INFO_SECRE_GRADE_ID));
					setRecordIDS(BSSParamName.OTHER_ADSL_PREV + BSSParamName.ARCHIVE_INFO_LIMIT_DATE, archive.getRow(0)
							.getString(BSSParamName.ARCHIVE_INFO_LIMIT_DATE));
					setRecordIDS(BSSParamName.OTHER_ADSL_PREV + BSSParamName.ARCHIVE_INFO_BESP_DATE, archive.getRow(0)
							.getString(BSSParamName.ARCHIVE_INFO_BESP_DATE));
				}

				DataTable nwk = getRecordFrom(BSSParamName.OTHER_ADSL_PREV + BSSParamName.NWK_TABLE);
				if (nwk != null && nwk.getRows().getCount() > 0) {
					setRecordIDS(BSSParamName.OTHER_ADSL_PREV + BSSParamName.NWK_SERV_ACC_NBR, nwk.getRow(0).getString(
							BSSParamName.NWK_SERV_ACC_NBR));
				}
			}

			return dtSet;
		}

		return new DataSet();
	}

	public DataSet callQryServ(String sServTypeID, String sServID) {
		String sKeyWord = "0";
		String sFlag = "1";
		String sCityCode = getRecordIDS("CITYCODE");

		if (sServTypeID != null && Integer.parseInt(sServTypeID) > 30) {
			sFlag = "0";
		}

		return BssQryServBean.callToSet(sServID, sKeyWord, sFlag, sCityCode);
	}

	public DataTable callQryDisctType() {
		try {
			String qryMode = "Y";
			String disctTypeId = "";
			String disctTypeName = "";
			String disctMethod = "";
			String servTypeId = getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_TYPE_ID);
			String soTypeId = getRecordIDS(BSSParamName.OTHER_SO_TYPE_ID);
			String areaId = getRecordIDS("AREAID");
			String limitId = "";
			String custId = "";
			String disctTypeSort = "";
			String sysDate = "";
			String protocolId = "";
			String cityCode = getRecordIDS("CITYCODE");

			return BssInter4.callWebQryDisctType(qryMode, disctTypeId, disctTypeName, disctMethod, servTypeId,
					soTypeId, areaId, limitId, custId, disctTypeSort, sysDate, protocolId, cityCode);
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}

		return null;
	}

	public DataTable callQryFee(boolean useDisct) {