📄 rateprotocolalterweb.java
字号:
String SOiSO_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.SOISO_ID);
String SOiSO_SEQ = tf_BSSFlowRecord.getRecordIDS(BssParameter.SOISO_SEQ);
String SOiSO_NBR = tf_BSSFlowRecord.getRecordIDS(BssParameter.SOISO_NBR);
String area_id = tf_BSSFlowRecord.getRecordIDS(BssParameter.SERVIAREA_ID);
String SOiSERV_TYPE_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.SERViSERV_TYPE_ID);
String citycode = tf_BSSFlowRecord.getRecordIDS(BssParameter.CITYCODE);
Hashtable ht = new Hashtable();
ht.put("SOiSO_ID",SOiSO_ID);
ht.put("SOiSO_SEQ",SOiSO_SEQ);
ht.put("SOiSO_NBR",SOiSO_NBR);
Date date = new Date();
Calendar cal = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String SOiACCEPT_DATE = (String) sdf.format(cal.getTime());
//String SOiACCEPT_DATE = date.toLocaleString();//受理日期
ht.put("SOiAPPL_DATE",SOiACCEPT_DATE);
ht.put("SOiAREA_ID",area_id);
ht.put("SOiSO_TYPE_ID",SO_TYPE_ID);
ht.put("SOiSERV_TYPE_ID",SOiSERV_TYPE_ID);
String re = "1";
try {
FormBody fb = BssInter1.callWebDealNewOrd( SOiSO_ID,
SOiSO_SEQ,
SOiSO_NBR,
SOiACCEPT_DATE,
area_id,
SO_TYPE_ID,
SOiSERV_TYPE_ID,
citycode);
if(fb.getString("doonewebfld").equals("E")){
//当调度成功时更改数据库的状态位。
tf_BSSFlowRecord.finishFlow();
tf_BSSFlowRecord.save();
return re;
}else{
/*wull 2006-5-10如果发起调度不成功。返回0*/
re = "0";
return re;
}
} catch (Exception ex) {
re = "0";//说明异常
FileLogger.getLogger().warn("WebDealNewOrd出错！", ex);
}
return re;
}
/**
* 撤销申请单,并解锁....
SOiSO_ID 申请流水号
SOiSO_SEQ 申请序列号
SOiSO_NBR 申请单号
撤销服务信息
SERViSERV_ID 唯一标识
撤销客户信息
CUSTiCUST_ID 客户ID
撤销帐户
ACCTiACCT_ID 帐户ID
撤销接入编码与业务号码的关联
ACCESS_INTERFACEiACCESS_ID 接入编码
* @return String
*/
public String WebCancelSo(String prodOrderId) {
TF_BSSFlowRecord tf_BSSFlowRecord = TF_BSSFlowRecord.getBSSFlowRecord(new
DacClient(), Long.parseLong(prodOrderId));
String SOiSO_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.SOISO_ID);
String SOiSO_SEQ = tf_BSSFlowRecord.getRecordIDS(BssParameter.SOISO_SEQ);
String SOiSO_NBR = tf_BSSFlowRecord.getRecordIDS(BssParameter.SOISO_NBR);
String CUSTiCUST_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.CUSTICUST_ID);
String SERViSERV_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.
SERViSERV_ID);
String ACCTiACCT_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.ACCTIACCT_ID);
String ACCESS_INTERFACEiACCESS_ID = tf_BSSFlowRecord.getRecordIDS(BssParameter.ACCTIACCT_ID);
String citycode = tf_BSSFlowRecord.getRecordIDS(BssParameter.CITYCODE);
try {
BssInter1.callWebCancelSo(SOiSO_ID,
SOiSO_SEQ,
SOiSO_NBR,
SERViSERV_ID,
CUSTiCUST_ID,
ACCTiACCT_ID,
ACCESS_INTERFACEiACCESS_ID,
citycode);
/*2006-5-7 修改先撤单完，解锁*/
BssInter1.callWebServUnLock(SERViSERV_ID, "", citycode);
} catch (Exception ex) {
FileLogger.getLogger().warn("WebDealNewOrd出错！", ex);
}
return "";
}
/**
* 根据某个ID号取协议的基本信息
* @param PROTOCOL_PARAMETERiPARA_ID String
* @param citycode String
* @return FormBody
*/
public FormBody SingleProtocolDesc(String PROTOCOL_PARAMETERiPARA_ID,
String citycode) {
FormBody fb = null;
try {
fb = BssInter4.callWebQryProtoPara(PROTOCOL_PARAMETERiPARA_ID,
citycode);
} catch (Exception ex) {
FileLogger.getLogger().warn("SingleProtocolDesc出错！", ex);
}
return fb;
}
/** <p>
* 查询产品目录结构(查询服务性质)
* </p>
*
* @param MENU_INFOiMENU_ID 菜单编码 String 固定值
* --new phone 00001677
* --adls 00001477 移机00001366
* -- LAN新装 00001392 Lan移机_new 00001393
*
* @return
* LEVEL 层次 String
* PROD_TYPEiPROD_TYPE_ID 产品类型编码 String
* PROD_TYPEiPROD_TYPE_NAME 产品类型名称 String
* PRODiPROD_ID 产品编码 String
* PRODiPROD_NAME 产品名称 String
*/
public DataTable WebQryMenuFold(String prodOrderId, String citycode) {
String MENU_INFOiMENU_ID = "00001367"; //00001115
DataTable dt = null;
TF_BSSFlowRecord tf_BSSFlowRecord = TF_BSSFlowRecord.getBSSFlowRecord(new
DacClient(), Long.parseLong(prodOrderId));
try {
dt = BssInter3.callWebQryMenuFold(MENU_INFOiMENU_ID,
citycode);
if(dt != null && dt.getRows().getCount()>=1){
tf_BSSFlowRecord.setRecordFrom(dt,
BssParameter.ADSLSEVER_TABLE);
tf_BSSFlowRecord.save();
}
} catch (Exception ex) {
FileLogger.getLogger().warn("WebQryMenuFold出错！", ex);
}
return dt;
}
/**
* <p>
* 查询可选协议信息
* </p>
* @param SERV_TYPEiSERV_TYPE_ID 服务类型 String
* @param SO_TYPEiSO_TYPE_ID 申请类型 String
* @param STAFFiSTAFF_ID 员工编号 String
* @param SERViSERV_ID 服务编号 String
* @param PRODiPROD_ID 产品编号 String
* @param citycode
* @return
* PROT_INFO_SYSiPROTOCOL_LEVEL 协议层次 String
* PROT_INFO_SYSiPROTOCOL_ID 协议标识 String
* PROT_INFO_SYSiPROTOCOL_NAME 协议名称 String
* PROT_INFO_SYSiSUMMARY 协议摘要 String
* PROT_INFO_SYSiPROTOCOL_TYPE 协议类型 String
* PROT_INFO_SYSiEXCLUDE 是否排他性 String
* PROT_INFO_SYSiEFF_DATE 协议生效时间 String
* PROT_INFO_SYSiEXP_DATE 协议失效时间 String
* SERV_PROTOCOL_INFOiPROTOCOL_ID 上一层协议标识 String
*/
public DataTable WebQryProtocol(String prodOrderId,
String SERV_TYPEiSERV_TYPE_ID,
String citycode,
String SERViSERV_ID,
String PRODiPROD_ID) {
TF_BSSFlowRecord tf_BSSFlowRecord = TF_BSSFlowRecord.getBSSFlowRecord(new
DacClient(), Long.parseLong(prodOrderId));
DataTable dt = null;
try {
dt = BssInter3.callWebQryProtocol(SERV_TYPEiSERV_TYPE_ID,
citycode,
SO_TYPE_ID,
STAFFiSTAFF_ID,
SERViSERV_ID,
PRODiPROD_ID);
if(dt != null && dt.getRows().getCount()>=1){
tf_BSSFlowRecord.setRecordFrom(dt,
BssParameter.ADSLPROTOCOL_TABLE);
tf_BSSFlowRecord.save(); //信
}
} catch (Exception ex) {
FileLogger.getLogger().warn("WebQryProtocol出错！", ex);
}
return dt;
}
/**
* 查询证件名称
* @return DataTable
*/
public String WebQrySPSTATUS(String prodOrderId, String citycode,
String cardname_web,String cardno_web) {
TF_BSSFlowRecord tf_BSSFlowRecord = TF_BSSFlowRecord.getBSSFlowRecord(new
DacClient(), Long.parseLong(prodOrderId));
String id = "";
try {
DataTable card_dt = BssInter2.callWebQrySPSTATUS("CUST", "CERT_TYPE",
citycode);
/**********/
String cardName = "";
if (card_dt != null && card_dt.getRows().getCount() > 0) {
for (int i = 0; i < card_dt.getRows().getCount(); i++) {
id = card_dt.getRow(i).getString("SP_STATUSiSTS_ID");
cardName = card_dt.getRow(i).getString("SP_STATUSiSTS_WORDS");
//String selected = "";
if (cardname_web.equals(cardName)) {
break;
}
}
}
if("".equals(id))cardno_web="";
//同时保存证件号与号码
tf_BSSFlowRecord.setRecordIDS(BssParameter.CUSTICUST_CARDNO,cardno_web);
tf_BSSFlowRecord.setRecordIDS(BssParameter.CUSTICUST_CARD, id);
tf_BSSFlowRecord.save(); //信
} catch (Exception ex) {
FileLogger.getLogger().warn("WebQrySPSTATUS出错！", ex);
}
return id;
}
/**
* 根所价格的ID选出二维的单条记录（有：服务类型与协议信息）
* @param ADSL_PRICE_ID String
* @return DataTable
*/
public DataTable SingleAdslPrice(String prodOrderId, String ADSL_PRICE_ID) {
DataTable dt = null;
TF_BSSFlowRecord tf_BSSFlowRecord = TF_BSSFlowRecord.getBSSFlowRecord(new
DacClient(), Long.parseLong(prodOrderId));
//先从数据库表里查看有没有东东，如果没有则从接口取。
dt = tf_BSSFlowRecord.getRecordFrom(BssParameter.CUST_PATIC_TABLE);
dt = RateProalterDB.getInstance().QuerySingleAdslPrice(
ADSL_PRICE_ID);
if(dt != null && dt.getRows().getCount()>=1){
String vv = dt.getRow(0).getString("BSS_PROTO_ID");
String type_id = dt.getRow(0).getString("BSS_TYPE_ID");//服务类型编码
String case_id = dt.getRow(0).getString("BSS_PROTO_ID");//协议类型编码
String[] value = new String[1];
value[0] = vv;
//把JSP用户传进来的服务性质入库
tf_BSSFlowRecord.setRecordIDS(BssParameter.SERVPROPERTY_OLD,
type_id); //旧
tf_BSSFlowRecord.setRecordIDS(BssParameter.PROTOCOLID, case_id);
tf_BSSFlowRecord.setRecordIDS(BssParameter.SERVPROPERTY,
type_id); //有可能更改
//取出用户传进来的协议ID构建一下DT存入数据库中
DataTable sel_dt = RateProalterDB.getInstance().getNewTable(BssParameter.
SELECT_PROTOCOL_TABLE, BssParameter.PROTOCOLID, value);
tf_BSSFlowRecord.setRecordFrom(sel_dt,
BssParameter.SELECT_PROTOCOL_TABLE);
//价格的DT
tf_BSSFlowRecord.setRecordFrom(dt,
BssParameter.adsl_price_table);
tf_BSSFlowRecord.save();
}
return dt;
}
/**
* 保存前台送进来的协议信息保存为DT格式。
* @param id String
* @param value String[]
* @return DataTable
*/
public DataTable WebQryProtocolNEW(String id, String[] value) {
DataTable dt = null;
TF_BSSFlowRecord tf_BSSFlowRecord = TF_BSSFlowRecord.getBSSFlowRecord(new
DacClient(), Long.parseLong(id));
dt = RateProalterDB.getInstance().getNewTable(BssParameter.
SELECT_PROTOCOL_TABLE,
BssParameter.PROTOCOLID, value);
tf_BSSFlowRecord.setRecordFrom(dt, BssParameter.SELECT_PROTOCOL_TABLE);
tf_BSSFlowRecord.save();
return dt;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -