rateproalterdb.java

电信的网厅的整站代码

				// 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";

				/**
				 * --数据接入信息 SO_DATA_ACCESS_INFOiTERM_ACC_ID=
				 * SO_DATA_ACCESS_IiACC_PURPOSE_ID=
				 * SO_DATA_ACCESS_INFOiACC_SERV_ID=QZ000987300 --是否默认该用户的号码,如果?
				 * SO_DATA_ACCESS_INFOiBILL_SERV_ID=QZ000987300
				 * SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID=0
				 * SERV_DATA_ACCESS_INFOiPAY_RATING=100%
				 * SO_DATA_ACCESS_INFOiSEQ=1 SO_DATA_ACCESS_INFOiACT_TYPE=X
				 * 
				 * 数据接入信息档案 SERV_DATA_ACCESS_INiTERM_ACC_ID 接入方式编码
				 * DATA_TERM_ACCESSiACC_NAME 接入方式名称
				 * SERV_DATA_ACCESSiACC_PURPOSE_ID 入网目的编码 ACC_PURPOSEiNAME 入网目的
				 * SERV_DATA_ACCESS_INiACC_SERV_ID 接入号码编码
				 * SERV_DATA_ACCESS_INFOiMODI_DATE 变更时间
				 * SO_DATA_ACCESS_INFOiBILL_SERV_ID 计费号码编码
				 * SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID 帐目类型编码
				 * 
				 */
				String SO_DATA_ACCESS_INFOiTERM_ACC_ID = custProduct_dt.getRow(
						0).getString("SERV_DATA_ACCESS_INiTERM_ACC_ID")
						+ "【★】"
						+ custProduct_dt.getRow(0).getString(
								"SERV_DATA_ACCESS_INiTERM_ACC_ID") + "【★】";
				String SO_DATA_ACCESS_IiACC_PURPOSE_ID = custProduct_dt.getRow(
						0).getString("SERV_DATA_ACCESSiACC_PURPOSE_ID")
						+ "【★】"
						+ custProduct_dt.getRow(0).getString(
								"SERV_DATA_ACCESSiACC_PURPOSE_ID") + "【★】";
				String SO_DATA_ACCESS_INFOiACC_SERV_ID = custProduct_dt.getRow(
						0).getString("SERV_DATA_ACCESS_INiACC_SERV_ID")
						+ "【★】"
						+ custProduct_dt.getRow(0).getString(
								"SERV_DATA_ACCESS_INiACC_SERV_ID") + "【★】"; // tf_BSSFlowRecord.getRecordIDS(BssParameter.SERVISERV_ID);
				String SO_DATA_ACCESS_INFOiBILL_SERV_ID = custProduct_dt
						.getRow(0).getString("SERV_ACC_TERMiEQPT_IP")
						+ "【★】"
						+ custProduct_dt.getRow(0).getString(
								"SERV_ACC_TERMiEQPT_IP") + "【★】"; // tf_BSSFlowRecord.getRecordIDS(BssParameter.SERVISERV_ID);
				String SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID = custProduct_dt
						.getRow(0).getString(
								"SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID")
						+ "【★】"
						+ custProduct_dt.getRow(0).getString(
								"SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID")
						+ "【★】"; // CommonMethod.formatString(tf_BSSFlowRecord.getRecordIDS("PAYTYPE"));
				String SERV_DATA_ACCESS_INFOiPAY_RATING = "100%【★】100%【★】";
				String SO_DATA_ACCESS_INFOiSEQ = "1【★】2【★】";
				String SO_DATA_ACCESS_INFOiACT_TYPE = "R【★】A【★】";

				/**
				 * --数据专线信息 数据专线信息档案 数据专线信息档案 SERV_DATA_LINEiDATA_LINE_ACC_ID
				 * 线路接入方式编码 DATA_LINE_ACCESSiACC_NAME 接入方式名称
				 * SERV_DATA_LINE_INFiLINE_TYPE_ID 线路类型编码
				 * LINE_TYPEiLINE_TYPE_NAME 线路类型名称 SERV_DATA_LINE_INFOiLINE_USE
				 * 专线用途 SERV_DATA_LINE_INFOiIS_NODE 是否节点机接入
				 * SERV_DATA_LINE_INFOiIP_AMOUNT IP个数
				 * SERV_DATA_LINE_INFOiIP_TYPE IP类型 SO_DATA_LINE_INFOiIP_TYPE
				 * IP类型解释 SERV_DATA_LINE_INFOiMODI_DATE 变更时间
				 * SERV_DATA_LINE_INFOiREMARKS 备注
				 */

				String SO_DATA_LINE_IiDATA_LINE_ACC_ID = custProduct_dt.getRow(
						0).getString("SERV_DATA_LINEiDATA_LINE_ACC_ID");
				String SO_DATA_LINE_INFOiLINE_TYPE_ID = custProduct_dt
						.getRow(0).getString("SERV_DATA_LINE_INFiLINE_TYPE_ID");
				String SO_DATA_LINE_INFOiLINE_USE = custProduct_dt.getRow(0)
						.getString("SERV_DATA_LINE_INFOiLINE_USE");
				String SO_DATA_LINE_INFOiIS_NODE = custProduct_dt.getRow(0)
						.getString("SERV_DATA_LINE_INFOiIS_NODE");
				String SO_DATA_LINE_INFOiIP_AMOUNT = custProduct_dt.getRow(0)
						.getString("SERV_DATA_LINE_INFOiIP_AMOUNT");
				String SO_DATA_LINE_INFOiIP_TYPE = custProduct_dt.getRow(0)
						.getString("SERV_DATA_LINE_INFOiIP_TYPE");
				String SO_DATA_LINE_INFOiREMARKS = custProduct_dt.getRow(0)
						.getString("SERV_DATA_LINE_INFOiREMARKS");
				// --都没有值是否要A ? ? ? ?
				String SO_DATA_LINE_INFOiACTION_TYPE = "X";

				/**
				 * --提交协议服务性质 --LAN基本协议 --??协议包问题
				 * SO_PROTOCOL_INFOiPROTOCOL_ID=E54,4【★】E56,1
				 * SO_PROTOCOL_INFOiFLAG=【★】【★】 SO_PROTOCOL_INFOiLASTED=【★】【★】
				 * SO_PROTOCOL_INFOiBEGIN_DATE=2005-9-21【★】【★】
				 * SO_PROTOCOL_INFOiEND_DATE=【★】【★】 SO_PROTOCOL_INFOiSEQ=1【★】2
				 * --主产品 PROD_RELAiPROD_ID= QE0001160【★】QE0001160
				 * PROD_RELAiPROD_ID2= QE0001160【★】QE0001160
				 * SO_PROTOCOL_INFOiACTION_TYPE=R【★】A
				 * 
				 * 
				 * 
				 * 提取协议信息 SERV_PROTOCOL_INFOiSEQ SERV_PROTOCOL_INFOiPROTOCOL_ID
				 * SERV_PROTOCOL_INFOiBEGIN_DATE SERV_PROTOCOL_INFOiEND_DATE
				 * PROT_INFO_SYSiPROTOCOL_NAME
				 * 
				 */

				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 = "";

				int all_sql = 1;
				for (int i = 0; i < custProduct_dt.getRows().getCount(); i++) {
					DataRow dr = custProduct_dt.getRow(i);
					String pro_id = dr
							.getString("SERV_PROTOCOL_INFOiPROTOCOL_ID");
					if (!"".equals(pro_id) && !temp_list.contains(pro_id)) {
						temp_list.add(pro_id);
						SO_PROTOCOL_INFOiPROTOCOL_ID += dr
								.getString("SERV_PROTOCOL_INFOiPROTOCOL_ID")
								+ "【★】";
						SO_PROTOCOL_INFOiFLAG += "" + "【★】";
						SO_PROTOCOL_INFOiLASTED += "" + "【★】";
						SO_PROTOCOL_INFOiBEGIN_DATE += dr
								.getString("SERV_PROTOCOL_INFOiBEGIN_DATE")
								+ "【★】";
						SO_PROTOCOL_INFOiEND_DATE += dr
								.getString("SERV_PROTOCOL_INFOiEND_DATE")
								+ "【★】";
						SO_PROTOCOL_INFOiSEQ += dr
								.getString("SERV_PROTOCOL_INFOiSEQ")
								+ "【★】";
						// SERViPROD_ID服务性质编码
						PROD_RELAiPROD_ID += custProduct_dt.getRow(0)
								.getString("SERViPROD_ID")
								+ "【★】";
						PROD_RELAiPROD_ID2 += custProduct_dt.getRow(0)
								.getString("SERViPROD_ID")
								+ "【★】";
						if (i == 0) {
							SO_PROTOCOL_INFOiACTION_TYPE += "R" + "【★】";
						} else {
							SO_PROTOCOL_INFOiACTION_TYPE += "X" + "【★】";
						}
						all_sql++;
					}
				}

				// 取已经选择的协议信息
				DataTable protocol_dt = tf_BSSFlowRecord
						.getRecordFrom(BssParameter.SELECT_PROTOCOL_TABLE);

				if (protocol_dt != null && protocol_dt.getRows().getCount() > 0) {

					for (int i = 0; i < protocol_dt.getRows().getCount(); i++) {
						String pro_id_new = protocol_dt.getRow(i).getString(
								BssParameter.PROTOCOLID);
						if (!"".equals(pro_id_new)
								&& !temp_list.contains(pro_id_new)) {
							temp_list.add(pro_id_new);
							SO_PROTOCOL_INFOiPROTOCOL_ID += protocol_dt.getRow(
									i).getString(BssParameter.PROTOCOLID)
									+ "【★】";
							SO_PROTOCOL_INFOiFLAG += "" + "【★】";
							SO_PROTOCOL_INFOiLASTED += "" + "【★】";
							SO_PROTOCOL_INFOiBEGIN_DATE += "" + "【★】";
							SO_PROTOCOL_INFOiEND_DATE += "" + "【★】";
							SO_PROTOCOL_INFOiSEQ += all_sql + "【★】";
							// SERViPROD_ID服务性质编码
							PROD_RELAiPROD_ID += tf_BSSFlowRecord
									.getRecordIDS(BssParameter.SERVPROPERTY)
									+ "【★】";
							PROD_RELAiPROD_ID2 += tf_BSSFlowRecord
									.getRecordIDS(BssParameter.SERVPROPERTY)
									+ "【★】";
							SO_PROTOCOL_INFOiACTION_TYPE += "A" + "【★】";
						}
					}
				}

				/**
				 * 业务密码 SERV_PWDiPASSWORD 业务密码 SERV_PWDiPWD_TYPE 密码类型 --受理费用划拨
				 * --业务密码可多条 C帐号密码 Y学生 X家长 SO_PWDiPWD_TYPE=C【★】M【★】Q --数字密码
				 * SO_PWDiPASSWORD=618512【★】A"!0 IO【★】A"!0 IO --受理帐务周期信息
				 * 
				 */
				String SO_PWDiPWD_TYPE = ""; // 帐号密码
				String SO_PWDiPASSWORD = "";
				for (int i = 0; i < custProduct_dt.getRows().getCount(); i++) {
					String pwd_type = custProduct_dt.getRow(0).getString(
							"SERV_PWDiPWD_TYPE");
					temp_list.add(pwd_type);
					if (!"".equals(pwd_type) && !temp_list.contains(pwd_type)) {
						SO_PWDiPWD_TYPE += custProduct_dt.getRow(i).getString(
								"SERV_PWDiPWD_TYPE")
								+ "【★】";
						SO_PWDiPASSWORD += custProduct_dt.getRow(0).getString(
								"SERV_PWDiPASSWORD")
								+ "【★】";
					}
				}

				System.out.println("STAFF_ID=" + STAFF_ID);
				System.out.println("SOiSO_ID=" + SOiSO_ID);
				System.out.println("SOiSO_NBR=" + SOiSO_NBR);
				System.out.println("SOiAREA_ID=" + SOiAREA_ID);
				System.out.println("SOiSO_TYPE_ID=" + SOiSO_TYPE_ID);
				System.out.println("SOiSERV_TYPE_ID=" + SOiSERV_TYPE_ID);
				System.out.println("SOiSERV_AREA_ID=" + SOiSERV_AREA_ID);

				// String SOiSO_ID = soId_dt.getRow(0).getString("SOISO_ID");
				// String SOiSO_NBR = soId_dt.getRow(0).getString("SOISO_NBR");
				System.out.println("SOiSERV_SO_ID=" + SOiSO_ID);
				System.out.println("SOiSERV_SO_SEQ=" + SOiSERV_SO_SEQ);
				System.out.println("SOiSERV_SO_NBR=" + SOiSO_NBR);

				System.out.println("SOiCUST_ID=" + SOiCUST_ID);
				System.out.println("SOiSUBS_CODE=" + SOiSUBS_CODE);
				System.out.println("SOiDISCT_TYPE_ID=" + SOiDISCT_TYPE_ID);
				System.out.println("SOiSTAFF_ID=" + SOiSTAFF_ID);
				System.out.println("SOiPRIORITY=" + SOiPRIORITY);
				System.out.println("SOiACCEPT_TYPE=" + SOiACCEPT_TYPE);
				System.out.println("SOiACCEPT_DATE=" + SOiACCEPT_DATE);
				System.out.println("SOiSTATE=" + SOiSTATE);
				System.out.println("SOiSERV_ID=" + SOiSERV_ID);
				System.out.println("SOiANN_ACT_TYPE=" + SOiANN_ACT_TYPE);
				System.out.println("FLAG1=" + FLAG1);
				System.out.println("SOiPRI_SERV_ID=" + SOiPRI_SERV_ID);
				System.out.println("CORR_INFOiCONTACT_TYPE="
						+ CORR_INFOiCONTACT_TYPE);
				System.out.println("CORR_INFOiCONTACT_NAME="
						+ CORR_INFOiCONTACT_NAME);
				System.out.println("CORR_INFOiCONTACT_TEL="
						+ CORR_INFOiCONTACT_TEL);
				System.out
						.println("CORR_INFOiCERT_TYPE=" + CORR_INFOiCERT_TYPE);
				System.out.println("CORR_INFOiCERT_NBR=" + CORR_INFOiCERT_NBR);
				System.out.println("SO_PRODiPROD_ID=" + SO_PRODiPROD_ID);
				System.out.println("SO_PRODiPROD_NUM=" + SO_PRODiPROD_NUM);
				System.out
						.println("SO_PRODiACTION_TYPE=" + SO_PRODiACTION_TYPE);
				// ACCTiACCT_ID += "【★】"+ACCTiACCT_ID;
				// SERV_ACCTiACCT_ITEM_TYPE_ID +=
				// "【★】"+SERV_ACCTiACCT_ITEM_TYPE_ID ;
				//
				System.out.println("SO_SERV_ACCTiACCT_ITEM_TYPE_ID="
						+ SERV_ACCTiACCT_ITEM_TYPE_ID);
				System.out.println("SO_SERV_ACCTiACCT_ID=" + ACCTiACCT_ID);
				System.out.println("SO_SERV_ACCTiBILLING_TYPE_ID="
						+ SO_SERV_ACCTiBILLING_TYPE_ID);
				System.out.println("SERV_ACCTiPAY_RATING="
						+ SERV_ACCTiPAY_RATING);
				System.out.println("SO_SERV_ACCTiACTION_TYPE="
						+ SO_SERV_ACCTiACTION_TYPE);
				// --受理业务
				System.out.println("SO_BUSINESSiSECRE_GRADE_ID="
						+ SO_BUSINESSiSECRE_GRADE_ID);
				System.out.println("SO_BUSINESSiLIMIT_DATE="
						+ SO_BUSINESSiLIMIT_DATE);
				System.out.println("SO_BUSINESSiBESP_DATE="
						+ SO_BUSINESSiBESP_DATE);
				System.out
						.println("SO_BUSINESSiPROD_ID=" + SO_BUSINESSiPROD_ID);
				System.out.println("CORP_CUSTiCUST_ID=" + CORP_CUSTiCUST_ID);
				System.out.println("SO_BUSINESSiACTION_TYPE="
						+ SO_BUSINESSiACTION_TYPE);

				// System.out.println("SO_PROD_ADDINFOiPROD_ID="+SO_PROD_ADDINFOiPROD_ID);
				// System.out.println("SO_PROD_ADDINFOiADDINFO_NAME="+SO_PROD_ADDINFOiADDINFO_NAME);
				// System.out.println("SO_PROD_ADDINFOiADDINFO_VALUE="+SO_PROD_ADDINFOiADDINFO_VALUE);
				// System.out.println("SO_PROD_ADDINFOiADDINFO_SEQ="+SO_PROD_ADDINFOiADDINFO_SEQ);
				// --受理资源接入信息 取用户固有的信息
				// --泉州市 柏仁楼 -- 不一定装到根目录
				System.out
						.println("SO_ACCESSiACCESS_ID=" + SO_ACCESSiACCESS_ID);
				// --接入点编码 要传
				System.out.println("SO_ACCESSiACC_NODE_ID="
						+ SO_ACCESSiACC_NODE_ID);
				System.out.println("SO_ACCESSiEXCH_ID=" + SO_ACCESSiEXCH_ID);
				System.out.println("SO_ACCESSiADDR_ID=" + SO_ACCESSiADDR_ID);
				System.out.println("SO_ACCESSiREF_TEL_NBR="
						+ SO_ACCESSiREF_TEL_NBR);
				System.out.println("SO_ACCESSiREF_ADDR_ID="
						+ SO_ACCESSiREF_ADDR_ID);
				System.out.println("SO_ACCESSiACTION_TYPE="
						+ SO_ACCESSiACTION_TYPE);
				// --查询空闲号 预占先查询业务号段(前台选号)?
				System.out.println("SO_ACC_NBRiNBR_SEQ=" + SO_ACC_NBRiNBR_SEQ);
				System.out.println("SO_ACC_NBRiSEQ=" + SO_ACC_NBRiSEQ);
				// --SO_ACC_NBRiSEQ=1
				// --号码编码SS0000000541769
				System.out.println("SO_ACC_NBRiACC_NBR=" + SO_ACC_NBRiACC_NBR);
				// --前台选号
				System.out.println("SO_ACC_NBRiIS_CHOSEN="
						+ SO_ACC_NBRiIS_CHOSEN);
				System.out.println("SO_ACC_NBRiACC_NBR_AB="
						+ SO_ACC_NBRiACC_NBR_AB);
				// --局向必传 必须由后台人工干预?
				// --城东局WebQryExch 数据号码的局向？？？添电话的局方
				System.out.println("SO_ACC_NBRiEXCH_ID=" + SO_ACC_NBRiEXCH_ID);
				// --114是否保密
				System.out.println("SO_ACC_NBRiIS_SECRET="
						+ SO_ACC_NBRiIS_SECRET);
				System.out.println("SERV_ACCESSiACCESS_ID="
						+ SERV_ACCESSiACCESS_ID);
				System.out.println("SO_ACC_NBRiMAINTAIN_LEVEL="
						+ SO_ACC_NBRiMAINTAIN_LEVEL);
				System.out.println("SO_ACC_NBRiINSTALL_LEVEL="
						+ SO_ACC_NBRiINSTALL_LEVEL);
				System.out.println("SO_ACC_NBRiACTION_TYPE="
						+ SO_ACC_NBRiACTION_TYPE);
				System.out.println("TEMP_STS_WORDS2=" + TEMP_STS_WORDS2);
				System.out.println("SERV_NBRiAREA_ID=" + SERV_NBRiAREA_ID);
				System.out.println("SERV_NBRiSERV_NBR_ID="
						+ SERV_NBRiSERV_NBR_ID);
				// --特殊号码的提交 拨号帐号电话 阳光帐号@sunny.qzadsl/qzlan
				System.out
						.println("SO_SPECIAL_NBRSiNBR=" + SO_SPECIAL_NBRSiNBR);
				// --取不到想要的?
				System.out.println("SO_SPECIAL_NBRSiNBR_TYPE="
						+ SO_SPECIAL_NBRSiNBR_TYPE);
				// --动作类型(当So_type_id 是9,73,80,116,313,331,341, 中的一个值时传值为R)????
				System.out.println("SO_SPECIAL_NBRSiACTION_TYPE="
						+ SO_SPECIAL_NBRSiACTION_TYPE);
				// --(当So_type_id 是9,73,80,116,313,331,341,
				// 中的一个值是,值传--SO_SPECIAL_NBRSiNBR的值)
				System.out.println("TEMP_STS_WORDS2=" + TEMP_STS_WORDS2);
				System.out.println("SERV_NBRiAREA_ID=" + SERV_NBRiAREA_ID);
				// --接入点编码
				System.out.println("SERV_NBRiSERV_NBR_ID="
						+ SERV_NBRiSERV_NBR_ID);
				System.out.println("SO_SPECIAL_NBRSiNBR_ID="