📄 adslflowservice.java
字号:
try {
if(isLock == false) {
//如果不能办理需调用WebServUnLock进行解锁
String SOiSERV_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.SERVISERV_ID);
BssInter1.callWebServUnLock(SOiSERV_ID,"",tf_BSSFlowRecord.getRecordIDS("CITYCODE"));
}
}catch(Exception e) {
FileLogger.getLogger().warn("解锁失败：" + e);
return null;
}
return "1";
}
/**产生申请记录
*
* @param tf_BSSFlowRecord
* @return
*/
public static String webApply(TF_BSSFlowRecord tf_BSSFlowRecord) {
String info = "";
try {
DataTable custArchives_dt = tf_BSSFlowRecord.getRecordFrom(BssParameter.CUST_ARCHIVES_TABLE);
String cityCode = "";
BssReferProductBean productBean = null;
BssReferCustBean custBean = null;
CustArchivesBean custArchivesBean = AdslFlow.setfirstflow(custArchives_dt);
java.util.Map custMap = new java.util.HashMap();
if(tf_BSSFlowRecord.getRecordIDS("CUSTICUST_ID") != null &&
tf_BSSFlowRecord.getRecordIDS("CITYCODE") != null){
custMap.put("CUSTiCUST_ID",tf_BSSFlowRecord.getRecordIDS("CUSTICUST_ID"));
custMap.put("CITYCODE",tf_BSSFlowRecord.getRecordIDS("CITYCODE"));
custBean = BssSreachCustImpl.queryCustomer(custMap);
}
if(tf_BSSFlowRecord.getRecordFrom(BssParameter.PRODUCT_ARCHIVES_TABLE) != null){
productBean = new BssReferProductBean();
productBean.parDataTable(tf_BSSFlowRecord.getRecordFrom(BssParameter.PRODUCT_ARCHIVES_TABLE));
}
cityCode = tf_BSSFlowRecord.getRecordIDS("CITYCODE"); //城市编号
String SOiAREA_ID = custArchivesBean.getSERVIAREA_ID();//受理地区
String SOiSERV_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.SERVISERV_ID);//服务编码(必须传,可为空)
/*判断某服务档案是否允许办理变更业务(对判断条件进行合并)*/
info = AdslFlowService.webCheck(tf_BSSFlowRecord,"1");
info = "1";
System.out.println("info==>"+info);
if(info == null) {
return null;
}
else if(info.equals("1")){
//如果不能办理需调用WebServUnLock进行启用服务
BssInter1.callWebServUnLock(SOiSERV_ID,"",cityCode);
DataTable soType_dt = BssInter2.callWebQrySoType(cityCode);//查询申请类型信息
tf_BSSFlowRecord.setRecordIDS("SO_TYPEISO_TYPE_ID",soType_dt.getRow(0).getString("SO_TYPEISO_TYPE_ID"));
tf_BSSFlowRecord.setRecordIDS("SO_TYPEISO_TYPE_NAME",soType_dt.getRow(0).getString("SO_TYPEISO_TYPE_NAME"));
DataTable soId_dt = BssInter6.callWebGetSoIDNbr(SOiAREA_ID,cityCode);//取申请流水号
String SOiSO_ID = soId_dt.getRow(0).getString("SOISO_ID");
String SOiSO_NBR = soId_dt.getRow(0).getString("SOISO_NBR");
tf_BSSFlowRecord.setRecordFrom(soId_dt,BssParameter.SO_TABLE);
tf_BSSFlowRecord.setRecordIDS("SOISO_ID",SOiSO_ID);//申请流水号
tf_BSSFlowRecord.setRecordIDS("SOISO_NBR",SOiSO_NBR);//申请单号
String SOiSO_TYPE_ID = "1";//申请类型编码(新装)
String SOiSERV_TYPE_ID = "45";//ADSL服务类型编码
String SOiSERV_AREA_ID = SOiAREA_ID;//服务地区编码
String SOiSERV_SO_ID = "";//服务申请流水号
String SOiSERV_SO_SEQ = "";//服务申请流水序号
String SOiSERV_SO_NBR = "";//服务地申请单号
String SOiCUST_ID = custBean.getCUSTiCUST_ID();//客户编码
String SOiSUBS_CODE = "";//用户代码
String SOiDISCT_TYPE_ID = tf_BSSFlowRecord.getRecordIDS("DISCTTYPE");//优惠类型编码(需要获取)
String SOiSTAFF_ID = "QZ02900";//CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("DEVELOPMEN"));//发展员工编码QZ02900
String SOiPRIORITY = tf_BSSFlowRecord.getRecordIDS("OPERATIONLEVEL");//处理级别
String SOiACCEPT_TYPE = "N";//tf_BSSFlowRecord.getRecordIDS("ACCEPTSOURCE");//受理来源
/*获取受理日期*/
Date date = new Date();
String SOiACCEPT_DATE = date.toLocaleString();//受理日期
String SOiSTATE = "N";//状态
String SOiANN_ACT_TYPE = "C";//附加动作类型
String FLAG1 = "";//提交标志
String STAFF_ID="QZ02900";
String SOiPRI_SERV_ID = "";//主的serv_id(中继专用)
//提交受理经办人，受理联系人
String CORR_INFOiCONTACT_TYPE = "";
String CORR_INFOiCONTACT_NAME = "";
String CORR_INFOiCONTACT_TEL = "";
String CORR_INFOiCERT_TYPE = "";
String CORR_INFOiCERT_NBR = "";
if(tf_BSSFlowRecord.getRecordIDS("ACCEPTMEN_NAME") != null &&
!tf_BSSFlowRecord.getRecordIDS("ACCEPTMEN_NAME").equals("")) {
CORR_INFOiCONTACT_TYPE = "C"+"【★】"+"D";//相关人类型C代表受理联系人D代表受理经办人
CORR_INFOiCONTACT_NAME = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_RELATIONNAME")
+"【★】"+tf_BSSFlowRecord.getRecordIDS("ACCEPTMEN_NAME");//相关人名称
CORR_INFOiCONTACT_TEL = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_RELATIONPHO")
+"【★】"+tf_BSSFlowRecord.getRecordIDS("ACCEPTMEN_PHO");//联系电话
CORR_INFOiCERT_TYPE = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_CARD")
+"【★】"+tf_BSSFlowRecord.getRecordIDS("ACCEPTMEN_CARD");//证件类型
CORR_INFOiCERT_NBR = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_CARDNO")
+"【★】"+tf_BSSFlowRecord.getRecordIDS("ACCEPTMEN_CARDNO");//证件号码
}
else {
CORR_INFOiCONTACT_TYPE = "C";//相关人类型C代表受理联系人D代表受理经办人
CORR_INFOiCONTACT_NAME = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_RELATIONNAME");//相关人名称
CORR_INFOiCONTACT_TEL = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_RELATIONPHO");//联系电话
CORR_INFOiCERT_TYPE = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_CARD");//证件类型
CORR_INFOiCERT_NBR = tf_BSSFlowRecord.getRecordIDS("CUSTICUST_CARDNO");//证件号码
}
// 数据业务提交申请产品(端设备也是填此)
/*主产品信息*/
String SO_PRODiPROD_ID = productBean.getSab().getSERViPROD_ID();//产品编码(服务性质编码)
String SO_PRODiPROD_NUM = "1";//产品数量
String SO_PRODiACTION_TYPE = SOiSO_TYPE_ID;//动作类型
/*可选业务信息*/
if(productBean.getSob() != null) {
String reProdFunId = "";
for(int i=0;i<productBean.getSob().length;i++){
if(productBean.getSob()[i] != null &&
productBean.getSob()[i].getSERV_NWKiPROD_ID() !=null &&
!productBean.getSob()[i].getSERV_NWKiPROD_ID().equals("")) {
if(reProdFunId.equals("")) {
SO_PRODiPROD_ID += "【★】" + productBean.getSob()[i].getSERV_NWKiPROD_ID();
SO_PRODiPROD_NUM += "【★】" + "1";
SO_PRODiACTION_TYPE += "【★】" + "X";
}
else if(!reProdFunId.equals("") &&
!reProdFunId.equals(productBean.getSob()[i].getSERV_NWKiPROD_ID())) {
SO_PRODiPROD_ID += "【★】" + productBean.getSob()[i].getSERV_NWKiPROD_ID();
SO_PRODiPROD_NUM += "【★】" + "1";
SO_PRODiACTION_TYPE += "【★】" + "X";
}
reProdFunId = productBean.getSob()[i].getSERV_NWKiPROD_ID();
}
}
}
//接入终端信息
if(productBean.getLtb() != null) {
String reDeviceId = "";
for(int i=0;i<productBean.getLtb().length;i++){
if(productBean.getLtb()[i] != null &&
productBean.getLtb()[i].getSERV_ACC_TERMiPROD_ID() !=null &&
!productBean.getLtb()[i].getSERV_ACC_TERMiPROD_ID().equals("")) {
if(reDeviceId.equals("")) {
SO_PRODiPROD_ID += "【★】" + productBean.getLtb()[i].getSERV_ACC_TERMiPROD_ID();
SO_PRODiPROD_NUM += "【★】" + "1";
SO_PRODiACTION_TYPE += "【★】" + "X";
}
else if(!reDeviceId.equals("") &&
!reDeviceId.equals(productBean.getLtb()[i].getSERV_ACC_TERMiPROD_ID())) {
SO_PRODiPROD_ID += "【★】" + productBean.getLtb()[i].getSERV_ACC_TERMiPROD_ID();
SO_PRODiPROD_NUM += "【★】" + "1";
SO_PRODiACTION_TYPE += "【★】" + "X";
}
reDeviceId = productBean.getLtb()[i].getSERV_ACC_TERMiPROD_ID();
}
}
}
Vector selected_deviceIds = new Vector();
selected_deviceIds = QueryBssInfoFromDB.queryselectedDeviceIds(tf_BSSFlowRecord);//取新装终端设备
if(selected_deviceIds != null && selected_deviceIds.size() > 0) {
for(int i=0;i<selected_deviceIds.size();i++){
SO_PRODiPROD_ID += "【★】" + (String)selected_deviceIds.elementAt(i);
SO_PRODiPROD_NUM += "【★】" + "1";
SO_PRODiACTION_TYPE += "【★】" + "A";
}
}
//提交付费信息
String SO_SERV_ACCTiACCT_ITEM_TYPE_ID = CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("PAYTYPE"));//帐目类型编码
/*根据业务号码查询客户档案*/
String qry_oper_model = "7";
custArchives_dt = BssInter5.callWebQryServFor(qry_oper_model,
"2",
"","","","","","",
custArchivesBean.getSERV_ACC_NBRISERV_ACC_NBR(),"","","","","",
"1",custArchivesBean.getSERVIAREA_ID(),"",cityCode);
String SO_SERV_ACCTiACCT_ID = custArchives_dt.getRow(0).getString("ACCTiACCT_NBR");//帐户编码
tf_BSSFlowRecord.setRecordIDS("ACCTIACCT_ID",SO_SERV_ACCTiACCT_ID);
String SO_SERV_ACCTiBILLING_TYPE_ID = CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("PAYMODE"));//计费方式编码
String SERV_ACCTiPAY_RATING = CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("PERCENT"));//付费额度：付费金额（元）或付费的百分比（含百分号）
String SO_SERV_ACCTiACTION_TYPE = "A";//动作类型
// 受理业务
String SO_BUSINESSiSECRE_GRADE_ID = "";//保密级别编码
String SO_BUSINESSiLIMIT_DATE = "";//服务期限
String SO_BUSINESSiBESP_DATE = CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("BESPEAKTIME"));//预约装机日期
String SO_BUSINESSiPROD_ID = tf_BSSFlowRecord.getRecordIDS("SERVPROPERTY");//服务性质编码
String CORP_CUSTiCUST_ID = "";//客户编码
String SO_BUSINESSiACTION_TYPE = "A";//动作类型
//受理受理产品的附加属性
String SO_PROD_ADDINFOiPROD_ID = "";
String SO_PROD_ADDINFOiADDINFO_NAME = "";
String SO_PROD_ADDINFOiADDINFO_VALUE = "";
String SO_PROD_ADDINFOiADDINFO_SEQ = "";
if(selected_deviceIds != null && selected_deviceIds.size() > 0) {
for(int i=0;i<selected_deviceIds.size();i++){
SO_PROD_ADDINFOiPROD_ID += (String)selected_deviceIds.elementAt(i)+"【★】";
SO_PROD_ADDINFOiADDINFO_NAME += "颜色"+"【★】";
SO_PROD_ADDINFOiADDINFO_VALUE += ""+"【★】";
SO_PROD_ADDINFOiADDINFO_SEQ += "1"+"【★】";
}
}
// 受理资源接入信息
String SO_ACCESSiACCESS_ID = productBean.getLnb().getSERV_ACCESSiACCESS_ID();//业务接入编码
String SO_ACCESSiACC_NODE_ID = productBean.getLnb().getSERV_ACCESSiACC_NODE_ID();//接入点编码
String SO_ACCESSiEXCH_ID = productBean.getLnb().getSERV_ACCESSiEXCH_ID();//地址局向
String SO_ACCESSiADDR_ID = productBean.getLnb().getSERV_ACCESSiADDR_ID();//地址编码
String SO_ACCESSiREF_TEL_NBR = productBean.getLnb().getSO_ACCESSiREF_TEL_NBR();//就近电话
String SO_ACCESSiREF_ADDR_ID = productBean.getLnb().getSO_ACCESSiREF_ADDR_ID();//就近地址
String SO_ACCESSiACTION_TYPE = "A";//动作类型
// 号码信息
String SO_ACC_NBRiNBR_SEQ = "1";
String SO_ACC_NBRiSEQ = "1";
//号码编码
String SO_ACC_NBRiACC_NBR = tf_BSSFlowRecord.getRecordIDS("DATANbr");
//前台选号
String SO_ACC_NBRiIS_CHOSEN = "Y";
String SO_ACC_NBRiACC_NBR_AB = "";
//局向必传
String SO_ACC_NBRiEXCH_ID = productBean.getLnb().getSERV_ACCESSiEXCH_ID();
//114是否保密
String SO_ACC_NBRiIS_SECRET = "";
String SERV_ACCESSiACCESS_ID = "";
String SO_ACC_NBRiMAINTAIN_LEVEL = "C";//(需要获取)
String SO_ACC_NBRiINSTALL_LEVEL = "";
String SO_ACC_NBRiACTION_TYPE = "A";
String TEMP_STS_WORDS2 = "";
String SERV_NBRiAREA_ID = "";
String SERV_NBRiSERV_NBR_ID = "";
//特殊号码的提交 拨号帐号电话
String SO_SPECIAL_NBRSiNBR = tf_BSSFlowRecord.getRecordIDS("DIALUPACC");
String SO_SPECIAL_NBRSiNBR_TYPE = "A";
String SO_SPECIAL_NBRSiACTION_TYPE = "A";
TEMP_STS_WORDS2 = "";
SERV_NBRiAREA_ID = SOiAREA_ID;
//接入点编码
SERV_NBRiSERV_NBR_ID = "";
String SO_SPECIAL_NBRSiNBR_ID = "";
// 受理接入终端
String SO_ACC_TERMiPROD_ID = "";
if(selected_deviceIds != null && selected_deviceIds.size() > 0) {
for(int i=0;i<selected_deviceIds.size();i++){
SO_ACC_TERMiPROD_ID = (String)selected_deviceIds.elementAt(i);
}
}
String SO_ACC_TERMiTERM_TYPE = "";
//产权归属自备
DataTable select_attach_dt = tf_BSSFlowRecord.getRecordFrom(BssParameter.SELECT_ATTACH_TABLE);
String SO_ACC_TERMiPROPERTY =
AdslFlowService.getInfoByDervice(SO_ACC_TERMiPROD_ID,select_attach_dt,BssParameter.ATTACHID);
if(SO_ACC_TERMiPROPERTY == null ||
SO_ACC_TERMiPROPERTY.equals("") ||
SO_ACC_TERMiPROPERTY.equals(" ")) {
SO_ACC_TERMiPROPERTY = "";
}
//维护级别自维
DataTable select_service_dt = tf_BSSFlowRecord.getRecordFrom(BssParameter.SELECT_SERVICE_TABLE);
String SO_ACC_TERMiMTN_GRADE =
AdslFlowService.getInfoByDervice(SO_ACC_TERMiPROD_ID,select_service_dt,BssParameter.SERVICEID);
if(SO_ACC_TERMiMTN_GRADE == null ||
SO_ACC_TERMiMTN_GRADE.equals("") ||
SO_ACC_TERMiMTN_GRADE.equals(" ")) {
SO_ACC_TERMiMTN_GRADE = "";
}
String SO_ACC_TERMiPROD_COUNT = "";
String SO_ACC_TERMiAPPL_DATE = "";
String SO_ACC_TERMiMATURE_DATE = "";
String SO_ACC_TERMiPROTOCOL_ID = "";
String SO_ACC_TERMiSERIAL_NBR = "";
String SO_ACC_TERMiMODEL_NO = "";
String SO_ACC_TERMiINSTALL = "";
String SO_ACC_TERMiIS_CERTIF_CHECK = "";
String SO_ACC_TERMiCERTIFICATION = "";
String SO_ACC_TERMiMAX_SPEED = "";
String SO_ACC_TERMiEQPT_IP = "";
String SO_ACC_TERMiACTION_TYPE = "A";
// 数据接入信息
String SO_DATA_ACCESS_INFOiTERM_ACC_ID = "";
String SO_DATA_ACCESS_IiACC_PURPOSE_ID = "";
String SO_DATA_ACCESS_INFOiACC_SERV_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.SERVISERV_ID);
String SO_DATA_ACCESS_INFOiBILL_SERV_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.SERVISERV_ID);
String SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID = CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("PAYTYPE"));
String SERV_DATA_ACCESS_INFOiPAY_RATING = CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("PERCENT"));
String SO_DATA_ACCESS_INFOiSEQ = "1";
String SO_DATA_ACCESS_INFOiACT_TYPE = "A";
// 业务密码
//String SO_PWDiPWD_TYPE = "C";//帐号密码
//String SO_PWDiPASSWORD = CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("DIALUPPWD"));
// 提交协议受理信息表
DataTable protocol_dt = tf_BSSFlowRecord.getRecordFrom(BssParameter.SELECT_PROTOCOL_TABLE);
String SO_PROTOCOL_INFOiPROTOCOL_ID = "";
String SO_PROTOCOL_INFOiFLAG = "";
String SO_PROTOCOL_INFOiLASTED = "";
String SO_PROTOCOL_INFOiBEGIN_DATE = "";
String SO_PROTOCOL_INFOiEND_DATE = "";
String SO_PROTOCOL_INFOiSEQ = "";
String PROD_RELAiPROD_ID = "";
String PROD_RELAiPROD_ID2 = "";
String SO_PROTOCOL_INFOiACTION_TYPE = "";
if(protocol_dt != null && protocol_dt.getRows().getCount()>0) {
for(int i=0;i<protocol_dt.getRows().getCount();i++){
SO_PROTOCOL_INFOiPROTOCOL_ID += protocol_dt.getRow(i).getString(BssPar⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -