📄 movephonebean.java
字号:
oldAccess.getString(BSSParamName.ACCESS_ACC_NODE_ID), oldAccess
.getString(BSSParamName.ACCESS_EXCH_ID), oldAccess
.getString(BSSParamName.ACCESS_ADDR_ID), oldAccess
.getString(BSSParamName.ACCESS_REF_TEL_NBR), oldAccess
.getString(BSSParamName.ACCESS_REF_ADDR_ID), "R");
}
// 设置号码信息。
setAcc_Nbr(dtSet.getDataTable(BssReferSoBean.ACC_NBR_TABLE));
// TODO 设置特殊号码的提交信息；
// 设置业务号的业务接入接口关联处理
// DataTable relTable =
// dtSet.getDataTable(BssReferSoBean.BUSINESS_REL_TABLE);
// relTable.getRows().add(relTable.newRow()); // 添加一条默认记录。
// 设置资源关联类型的确定
// relTable =
// dtSet.getDataTable(BssReferSoBean.RESOURCE_REL_TYPE_TABLE);
// relTable.getRows().add(relTable.newRow()); // 添加一条默认记录。
// 设置终端信息
setAcc_Term(dtSet.getDataTable(BssReferSoBean.ACC_TERM_TABLE));
// 设置产品附属信息
setProd_AddInfo(dtSet.getDataTable(BssReferSoBean.PROD_ADDINFO_TABLE));
// XXX 域名信息
// TODO 数据接入信息设置
// TODO 数据专线信息设置
// XXX 受理网络信息设置
// XXX 受理信源
// XXX 受理IP域名附加信息
// 受理费用划拨设置
// 暂时不传，没有有效的值。setDevided(dtSet.getDataTable(BssReferSoBean.DEVIDED_TABLE));
// 设置受理月租费通信费
setMonthly(dtSet.getDataTable(BssReferSoBean.MONTHLY_TABLE));
// 设置业务密码
setPWD(dtSet.getDataTable(BssReferSoBean.PWD_TABLE));
// 设置受理号簿信息
setDirec(dtSet.getDataTable(BssReferSoBean.DIREC_TABLE));
// 设置帐务周期
setBilling_Cycle(dtSet.getDataTable(BssReferSoBean.BILLING_CYCLE_TABLE));
// TODO 设置帐单传送信息
// TODO 设置祥单(跟帐单传送信息传的参数一样)
// TODO 提交担保信息
// TODO 数据业务认证信息申请表。
// TODO 受理特性信息(可多条)
// TODO 提交协议受理信息表
setProtocol_Info(dtSet.getDataTable(BssReferSoBean.PROTOCOL_INFO_TABLE));
// TODO 提交优惠协议受理信息表(可多条)
// XXX 提交企业邮局(可多条)
// TODO 提交使用客户信息
// XXX 提交位置服务信息表
dtSet.acceptChanges();
Map _map = BssReferSoBean.call(dtSet, getRecordIDS("CITYCODE"));
setRecordIDS(BSSParamName.OUTPUT_PHONE_SO_ID, (String) _map.get(BssReferSoBean.OUTPUT_SO_ID));
setRecordIDS(BSSParamName.OUTPUT_PHONE_SO_NBR, (String) _map.get(BssReferSoBean.OUTPUT_SO_NBR));
setRecordIDS(BSSParamName.OUTPUT_PHONE_SO_SEQ, (String) _map.get(BssReferSoBean.OUTPUT_SO_SEQ));
setRecordIDS(BSSParamName.OUTPUT_PHONE_APPL_DATE, (String) _map.get(BssReferSoBean.OUTPUT_APPL_DATE));
dtSet = null;
ret = true;
} catch (Exception ex) {
FileLogger.getLogger().warn(ex.getMessage(), ex);
} finally {
// 不管是否成功，都需要将提交过程所产生的数据保存到数据库中。
save();
}
return ret;
}
private void setProtocol_Info(DataTable dataTable) {
DataRow newRow = dataTable.newRow();
// XXX 设置其它协议信息
newRow.setValue(BssReferSoBean.PROTOCOL_INFO_SEQ, "1");
newRow.setValue(BssReferSoBean.PROTOCOL_INFO_ACTION_TYPE, "X");
newRow.setValue(BssReferSoBean.PROTOCOL_INFO_PROD_ID, getRecordIDS(BSSParamName.ARCHIVE_INFO_PROD_ID));
newRow.setValue(BssReferSoBean.PROTOCOL_INFO_PROD_ID2, getRecordIDS(BSSParamName.ARCHIVE_INFO_PROD_ID));
dataTable.getRows().add(newRow);
}
private void setBilling_Cycle(DataTable dt) {
DataTable at = getRecordFrom(BSSParamName.BILL_CYCLE_TABLE);
for (int i = 0; at != null && i < at.getRows().getCount(); i++) {
DataRow dr = at.getRow(i);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.BILLING_CYCLE_CYCLE_TYPE_ID, dr
.getString(BSSParamName.BILL_CYCLE_CYCLE_TYPE_ID));
dt.getRows().add(newRow);
}
}
private void setDirec(DataTable dt) {
DataTable at = getRecordFrom(BSSParamName.DIREC_TABLE);
for (int i = 0; at != null && i < at.getRows().getCount(); i++) {
DataRow dr = at.getRow(i);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.DIREC_AREA_ID, dr.getString(BSSParamName.DIREC_AREA_ID));
newRow.setValue(BssReferSoBean.DIREC_EMAIL, dr.getString(BSSParamName.DIREC_EMAIL));
newRow.setValue(BssReferSoBean.DIREC_URL, dr.getString(BSSParamName.DIREC_URL));
newRow.setValue(BssReferSoBean.DIREC_DIREC_NAME, dr.getString(BSSParamName.DIREC_DIREC_NAME));
newRow.setValue(BssReferSoBean.DIREC_DIREC_NBR, dr.getString(BSSParamName.DIREC_DIREC_NBR));
newRow.setValue(BssReferSoBean.DIREC_DIREC_ADDR, dr.getString(BSSParamName.DIREC_DIREC_ADDR));
dt.getRows().add(newRow);
}
}
private void setPWD(DataTable dt) {
DataTable at = getRecordFrom(BSSParamName.PWD_TABLE);
for (int i = 0; at != null && i < at.getRows().getCount(); i++) {
DataRow dr = at.getRow(i);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.PWD_PASSWORD, dr.getString(BSSParamName.PWD_PASSWORD));
newRow.setValue(BssReferSoBean.PWD_PWD_TYPE, dr.getString(BSSParamName.PWD_PWD_TYPE));
dt.getRows().add(newRow);
}
}
private void setMonthly(DataTable dt) {
DataTable at = getRecordFrom(BSSParamName.MONTHLY_TABLE);
for (int i = 0; at != null && i < at.getRows().getCount(); i++) {
DataRow dr = at.getRow(i);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.MONTHLY_AGREE_CODE, dr.getString(BSSParamName.MONTHLY_AGREE_CODE));
newRow.setValue(BssReferSoBean.MONTHLY_AGREE_TYPE_ID, dr.getString(BSSParamName.MONTHLY_AGREE_TYPE_ID));
newRow.setValue(BssReferSoBean.MONTHLY_REMARKS, dr.getString(BSSParamName.MONTHLY_REMARKS));
newRow.setValue(BssReferSoBean.MONTHLY_ACTION_TYPE, "X");
dt.getRows().add(newRow);
}
}
// private void setDevided(DataTable dt) {
// DataTable at = getRecordFrom(BSSParamName.DEVIDED_TABLE);
// for (int i = 0; at != null && i < at.getRows().getCount(); i++) {
// DataRow dr = at.getRow(i);
// DataRow newRow = dt.newRow();
// newRow.setValue(BssReferSoBean.DEVIDED_ACCT_ITEM_TYPE_ID,dr.getString(BSSParamName.DEVIDED_ACCT_ITEM_TYPE_ID));
// newRow.setValue(BssReferSoBean.DEVIDED_ACCT_ID,dr.getString(BSSParamName.DEVIDED_ACCT_ID));
// newRow.setValue(BssReferSoBean.DEVIDED_DEVIDED_ID,dr.getString(BSSParamName.DEVIDED_DEVIDED_ID));
// newRow.setValue(BssReferSoBean.DEVIDED_OUT_AREA_ID,dr.getString(BSSParamName.DEVIDED_OUT_AREA_ID));
// newRow.setValue(BssReferSoBean.DEVIDED_IN_AREA_ID,dr.getString(BSSParamName.DEVIDED_IN_AREA_ID));
// //
// newRow.setValue(BssReferSoBean.DEVIDED_REMARKS,dr.getString(BSSParamName.DEVIDED_REMARKS));
// newRow.setValue(BssReferSoBean.DEVIDED_ACTION_TYPE,"X");
//
// dt.getRows().add(newRow);
// }
// }
private void setProd_AddInfo(DataTable dt) {
DataTable at = getRecordFrom(BSSParamName.PROD_ADDINFO_TABLE);
for (int i = 0; at != null && i < at.getRows().getCount(); i++) {
DataRow dr = at.getRow(i);
String sProdId = dr.getString(BSSParamName.PROD_ADDINFO_PROD_ID);
String sName = dr.getString(BSSParamName.PROD_ADDINFO_ADDINFO_NAME);
String sValue = dr.getString(BSSParamName.PROD_ADDINFO_ADDINFO_VALUE);
if (isEmpty(sValue) && isEmpty(sName) && isEmpty(sProdId))
continue;
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.PROD_ADDINFO_PROD_ID, sProdId);
newRow.setValue(BssReferSoBean.PROD_ADDINFO_ADDINFO_NAME, sName);
newRow.setValue(BssReferSoBean.PROD_ADDINFO_ADDINFO_VALUE, sValue);
newRow.setValue(BssReferSoBean.PROD_ADDINFO_ADDINFO_SEQ, String.valueOf(i + 1));
dt.getRows().add(newRow);
}
}
private void setAcc_Term(DataTable dt) {
DataTable at = getRecordFrom(BSSParamName.ACC_TERM_TABLE);
for (int i = 0; at != null && i < at.getRows().getCount(); i++) {
DataRow dr = at.getRow(i);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.ACC_TERM_PROD_ID, dr.getString(BSSParamName.ACC_TERM_PROD_ID));
newRow.setValue(BssReferSoBean.ACC_TERM_TERM_TYPE, dr.getString(BSSParamName.ACC_TERM_TERM_TYPE));
newRow.setValue(BssReferSoBean.ACC_TERM_PROPERTY, dr.getString(BSSParamName.ACC_TERM_PROPERTY));
newRow.setValue(BssReferSoBean.ACC_TERM_MTN_GRADE, dr.getString(BSSParamName.ACC_TERM_MTN_GRADE));
newRow.setValue(BssReferSoBean.ACC_TERM_PROD_COUNT, dr.getString(BSSParamName.ACC_TERM_PROD_COUNT));
newRow.setValue(BssReferSoBean.ACC_TERM_APPL_DATE, dr.getString(BSSParamName.ACC_TERM_APPL_DATE));
newRow.setValue(BssReferSoBean.ACC_TERM_MATURE_DATE, dr.getString(BSSParamName.ACC_TERM_MATURE_DATE));
newRow.setValue(BssReferSoBean.ACC_TERM_PROTOCOL_ID, dr.getString(BSSParamName.ACC_TERM_PROTOCOL_ID));
newRow.setValue(BssReferSoBean.ACC_TERM_SERIAL_NBR, dr.getString(BSSParamName.ACC_TERM_SERIAL_NBR));
newRow.setValue(BssReferSoBean.ACC_TERM_MODEL_NO, dr.getString(BSSParamName.ACC_TERM_MODEL_NO));
newRow.setValue(BssReferSoBean.ACC_TERM_INSTALL, dr.getString(BSSParamName.ACC_TERM_INSTALL));
newRow.setValue(BssReferSoBean.ACC_TERM_IS_CERTIF_CHECK, dr
.getString(BSSParamName.ACC_TERM_IS_CERTIF_CHECK));
newRow.setValue(BssReferSoBean.ACC_TERM_CERTIFICATION, dr.getString(BSSParamName.ACC_TERM_CERTIFICATION));
newRow.setValue(BssReferSoBean.ACC_TERM_MAX_SPEED, dr.getString(BSSParamName.ACC_TERM_MAX_SPEED));
newRow.setValue(BssReferSoBean.ACC_TERM_EQPT_IP, dr.getString(BSSParamName.ACC_TERM_EQPT_IP));
newRow.setValue(BssReferSoBean.ACC_TERM_ACTION_TYPE, "X");
dt.getRows().add(newRow);
}
}
private void setAcc_Nbr(DataTable dt) {
if (getRecordFrom(BSSParamName.ACC_NBR_TABLE) != null) {
DataRow oldAccNbr = getRecordFrom(BSSParamName.ACC_NBR_TABLE).getRow(0);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.ACC_NBR_ACC_NBR_AB, oldAccNbr.getString(BSSParamName.ACC_NBR_ACC_NBR_AB));
newRow.setValue(BssReferSoBean.ACC_NBR_ACC_NBR, oldAccNbr.getString(BSSParamName.ACC_NBR_SERV_ACC_NBR));
newRow.setValue(BssReferSoBean.ACC_NBR_ACCESS_ID, oldAccNbr.getString(BSSParamName.ACC_NBR_ACCESS_ID));
newRow.setValue(BssReferSoBean.ACC_NBR_AREA_ID, getRecordIDS("AREAID"));
newRow.setValue(BssReferSoBean.ACC_NBR_EXCH_ID, oldAccNbr.getString(BSSParamName.ACC_NBR_EXCH_ID));
// newRow.setValue(BssReferSoBean.ACC_NBR_INSTALL_LEVEL, null);
newRow.setValue(BssReferSoBean.ACC_NBR_IS_CHOSEN, oldAccNbr.getString(BSSParamName.ACC_NBR_IS_CHOSEN));
newRow.setValue(BssReferSoBean.ACC_NBR_IS_SECRET, oldAccNbr.getString(BSSParamName.ACC_NBR_IS_SECRET));
// newRow.setValue(BssReferSoBean.ACC_NBR_MAINTAIN_LEVEL,
// oldAccNbr.getString(BSSParamName.ACC_NBR_MAINTAIN_LEVEL));
newRow.setValue(BssReferSoBean.ACC_NBR_NBR_SEQ, "1");
newRow.setValue(BssReferSoBean.ACC_NBR_SEQ, oldAccNbr.getString(BSSParamName.ACC_NBR_SEQ));
// newRow.setValue(BssReferSoBean.ACC_NBR_SERV_NBR_ID,
// oldAccNbr.getString(BSSParamName.ACC_NBR_SERV_NBR_ID));
// newRow.setValue(BssReferSoBean.ACC_NBR_TEMP_STS_WORDS2, null);
newRow.setValue(BssReferSoBean.ACC_NBR_ACTION_TYPE, "X");
dt.getRows().add(newRow);
}
}
private void setAccess(DataTable dt, String sAccessID, String sAccNodeID, String sExchID, String sAddrId,
String sRelTelNgr, String sRelAddrId, String sActionType) {
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.ACCESS_ACCESS_ID, sAccessID);
newRow.setValue(BssReferSoBean.ACCESS_ACC_NODE_ID, sAccNodeID);
newRow.setValue(BssReferSoBean.ACCESS_EXCH_ID, sExchID);
newRow.setValue(BssReferSoBean.ACCESS_ADDR_ID, sAddrId);
newRow.setValue(BssReferSoBean.ACCESS_REF_TEL_NBR, sRelTelNgr);
newRow.setValue(BssReferSoBean.ACCESS_REF_ADDR_ID, sRelAddrId);
newRow.setValue(BssReferSoBean.ACCESS_ACTION_TYPE, sActionType);
dt.getRows().add(newRow);
}
private void setNWK(DataTable dt, String sProdId) {
// 设置程控功能。
DataTable nwk = getRecordFrom(BSSParamName.NWK_TABLE);
for (int i = 0; nwk != null && i < nwk.getRows().getCount(); i++) {
DataRow dr = nwk.getRow(i);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.NWK_ACC_NBR, sProdId);
newRow.setValue(BssReferSoBean.NWK_PROD_ID, dr.getString(BSSParamName.NWK_PROD_ID));
newRow.setValue(BssReferSoBean.NWK_ACTION_TYPE, "X");
dt.getRows().add(newRow);
}
}
private void setBusiness(DataTable dt, String sGradeId, String sLimitDate, String sBespDate, String sProdId,
String sCustId, String sActionType) {
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.BUSINESS_SECRE_GRADE_ID, sGradeId);
newRow.setValue(BssReferSoBean.BUSINESS_LIMIT_DATE, sLimitDate);
newRow.setValue(BssReferSoBean.BUSINESS_BESP_DATE, sBespDate);
newRow.setValue(BssReferSoBean.BUSINESS_PROD_ID, sProdId);
newRow.setValue(BssReferSoBean.BUSINESS_CUST_ID, sCustId);
newRow.setValue(BssReferSoBean.BUSINESS_ACTION_TYPE, sActionType);
dt.getRows().add(newRow);
}
private void setServAcct(DataTable dt) {
// 提交付费信息。
DataTable acc = getRecordFrom(BSSParamName.ACC_TABLE);
for (int i = 0; acc != null && i < acc.getRows().getCount(); i++) {
DataRow dr = acc.getRow(i);
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.SERV_ACCT_ACCT_ID, dr.getString(BSSParamName.ACC_ACCT_ID));
newRow.setValue(BssReferSoBean.SERV_ACCT_ACCT_ITEM_TYPE_ID, dr
.getString(BSSParamName.ACC_ACCT_ITEM_TYPE_ID));
newRow.setValue(BssReferSoBean.SERV_ACCT_ACTION_TYPE, "X");
newRow.setValue(BssReferSoBean.SERV_ACCT_BILLING_TYPE_ID, dr.getString(BSSParamName.ACC_BILLING_TYPE_ID));
newRow.setValue(BssReferSoBean.SERV_ACCT_PAY_RATING, dr.getString(BSSParamName.ACC_PAY_RATING));
dt.getRows().add(newRow);
}
}
private void setProdFun(DataTable dt) {
// 设置程控功能。
DataTable nwk = getRecordFrom(BSSParamName.NWK_TABLE);
for (int i = 0; nwk != null && i < nwk.getRows().getCount(); i++) {
DataRow dr = nwk.getRow(i);
setProd(dt, dr.getString(BSSParamName.NWK_PROD_ID), 1, "X");
}
}
private void setProd(DataTable dt, String sId, int iNum, String sType) {
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.PROD_PROD_ID, sId);
newRow.setValue(BssReferSoBean.PROD_PROD_NUM, String.valueOf(iNum));
newRow.setValue(BssReferSoBean.PROD_ACTION_TYPE, sType);
dt.getRows().add(newRow);
}
private void setCorrInfo(DataTable dt, String sType, String sName, String sTel, String sCertType, String sCertNbr) {
if (isEmpty(sName) && isEmpty(sTel) && isEmpty(sCertType) && isEmpty(sCertNbr))
return;
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.CORR_INFO_CONTACT_TYPE, sType);
newRow.setValue(BssReferSoBean.CORR_INFO_CONTACT_NAME, sName);
newRow.setValue(BssReferSoBean.CORR_INFO_CONTACT_TEL, sTel);
newRow.setValue(BssReferSoBean.CORR_INFO_CERT_TYPE, sCertType);
newRow.setValue(BssReferSoBean.CORR_INFO_CERT_NBR, sCertNbr);
dt.getRows().add(newRow);
}
private void setApplyInfo(DataTable dt) {
DataRow newRow = dt.newRow();
newRow.setValue(BssReferSoBean.APPLY_INFO_SO_ID, getSo_ID());
newRow.setValue(BssReferSoBean.APPLY_INFO_SO_NBR, getSo_Nbr());
newRow.setValue(BssReferSoBean.APPLY_INFO_AREA_ID, getRecordIDS("AREAID"));
newRow.setValue(BssReferSoBean.APPLY_INFO_SERV_TYPE_ID, getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_TYPE_ID));
if (getRecordIDS("MOVE_USE_NP") == null || getRecordIDS("MOVE_USE_NP").equalsIgnoreCase("N")) {
// 局内外移
newRow.setValue(BssReferSoBean.APPLY_INFO_SO_TYPE_ID, "42");
} else {
// 跨局移。
newRow.setValue(BssReferSoBean.APPLY_INFO_SO_TYPE_ID, "251");
}
// 异地受理信息。
newRow.setValue(BssReferSoBean.APPLY_INFO_SERV_AREA_ID, getRecordIDS("AREAID"));
newRow.setValue(BssReferSoBean.APPLY_INFO_CUST_ID, getRecordIDS(BSSParamName.CUST_ARCHIVES_CUST_ID));
newRow.setValue(BssReferSoBean.APPLY_INFO_DISCT_TYPE_ID, getRecordIDS(BSSParamName.PRODTYPE_DISCT_TYPE_ID));
newRow.setValue(BssReferSoBean.APPLY_INFO_SO_STAFF_ID, getRecordIDS(BSSParamName.OTHER_STAFF_ID));
newRow.setValue(BssReferSoBean.APPLY_INFO_PRIORITY, getRecordIDS(BSSParamName.OTHER_PRIORITY));
newRow.setValue(BssReferSoBean.APPLY_INFO_ACCEPT_TYPE, "N");
newRow.setValue(BssReferSoBean.APPLY_INFO_ACCEPT_DATE, dateFormat.format(new Date()));
newRow.setValue(BssReferSoBean.APPLY_INFO_SERV_ID, getRecordIDS(BSSParamName.CUST_ARCHIVES_SERV_ID));
dt.getRows().add(newRow);
}
private boolean isEmpty(String str) {
if (str == null || str.equals(""))
return true;
return false;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -