rateproalterdb.java

电信的网厅的整站代码

						+ SO_SPECIAL_NBRSiNBR_ID);

				// --终端设备信息
				// --阿尔卡特
				System.out
						.println("SO_ACC_TERMiPROD_ID=" + SO_ACC_TERMiPROD_ID);
				System.out.println("SO_ACC_TERMiTERM_TYPE="
						+ SO_ACC_TERMiTERM_TYPE);
				// --产权归属 自备
				System.out.println("SO_ACC_TERMiPROPERTY="
						+ SO_ACC_TERMiPROPERTY);
				// --维护级别自维
				System.out.println("SO_ACC_TERMiMTN_GRADE="
						+ SO_ACC_TERMiMTN_GRADE);
				System.out.println("SO_ACC_TERMiPROD_COUNT="
						+ SO_ACC_TERMiPROD_COUNT);
				System.out.println("SO_ACC_TERMiAPPL_DATE="
						+ SO_ACC_TERMiAPPL_DATE);
				System.out.println("SO_ACC_TERMiMATURE_DATE="
						+ SO_ACC_TERMiMATURE_DATE);
				System.out.println("SO_ACC_TERMiPROTOCOL_ID="
						+ SO_ACC_TERMiPROTOCOL_ID);
				System.out.println("SO_ACC_TERMiSERIAL_NBR="
						+ SO_ACC_TERMiSERIAL_NBR);
				System.out.println("SO_ACC_TERMiMODEL_NO="
						+ SO_ACC_TERMiMODEL_NO);
				System.out
						.println("SO_ACC_TERMiINSTALL=" + SO_ACC_TERMiINSTALL);
				System.out.println("SO_ACC_TERMiIS_CERTIF_CHECK="
						+ SO_ACC_TERMiIS_CERTIF_CHECK);
				System.out.println("SO_ACC_TERMiCERTIFICATION="
						+ SO_ACC_TERMiCERTIFICATION);
				System.out.println("SO_ACC_TERMiMAX_SPEED="
						+ SO_ACC_TERMiMAX_SPEED);
				System.out
						.println("SO_ACC_TERMiEQPT_IP=" + SO_ACC_TERMiEQPT_IP);
				System.out.println("SO_ACC_TERMiACTION_TYPE="
						+ SO_ACC_TERMiACTION_TYPE);
				// --数据接入信息
				System.out.println("SO_DATA_ACCESS_INFOiTERM_ACC_ID="
						+ SO_DATA_ACCESS_INFOiTERM_ACC_ID);
				System.out.println("SO_DATA_ACCESS_IiACC_PURPOSE_ID="
						+ SO_DATA_ACCESS_IiACC_PURPOSE_ID);
				System.out.println("SO_DATA_ACCESS_INFOiACC_SERV_ID="
						+ SO_DATA_ACCESS_INFOiACC_SERV_ID);
				// --是否默认该用户的号码,如果?
				System.out.println("SO_DATA_ACCESS_INFOiBILL_SERV_ID="
						+ SO_DATA_ACCESS_INFOiBILL_SERV_ID);
				System.out.println("SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID="
						+ SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID);
				System.out.println("SERV_DATA_ACCESS_INFOiPAY_RATING="
						+ SERV_DATA_ACCESS_INFOiPAY_RATING);
				System.out.println("SO_DATA_ACCESS_INFOiSEQ="
						+ SO_DATA_ACCESS_INFOiSEQ);
				System.out.println("SO_DATA_ACCESS_INFOiACT_TYPE="
						+ SO_DATA_ACCESS_INFOiACT_TYPE);

				// 数据专线信息档案
				System.out.println("SO_DATA_LINE_IiDATA_LINE_ACC_ID="
						+ SO_DATA_LINE_IiDATA_LINE_ACC_ID);
				System.out.println("SO_DATA_LINE_INFOiLINE_TYPE_ID="
						+ SO_DATA_LINE_INFOiLINE_TYPE_ID);
				System.out.println("SO_DATA_LINE_INFOiLINE_USE="
						+ SO_DATA_LINE_INFOiLINE_USE);
				System.out.println("SO_DATA_LINE_INFOiIS_NODE="
						+ SO_DATA_LINE_INFOiIS_NODE);
				System.out.println("SO_DATA_LINE_INFOiIP_AMOUNT="
						+ SO_DATA_LINE_INFOiIP_AMOUNT);
				System.out.println("SO_DATA_LINE_INFOiIP_TYPE="
						+ SO_DATA_LINE_INFOiIP_TYPE);
				System.out.println("SO_DATA_LINE_INFOiREMARKS="
						+ SO_DATA_LINE_INFOiREMARKS);
				System.out.println("SO_DATA_LINE_INFOiACTION_TYPE="
						+ SO_DATA_LINE_INFOiACTION_TYPE);

				// System.out.println("SO_PWDiPWD_TYPE="+SO_PWDiPWD_TYPE);
				// System.out.println("SO_PWDiPASSWORD="+SO_PWDiPASSWORD);
				System.out.println("SO_PROTOCOL_INFOiPROTOCOL_ID="
						+ SO_PROTOCOL_INFOiPROTOCOL_ID);
				System.out.println("SO_PROTOCOL_INFOiFLAG="
						+ SO_PROTOCOL_INFOiFLAG);
				System.out.println("SO_PROTOCOL_INFOiLASTED="
						+ SO_PROTOCOL_INFOiLASTED);
				System.out.println("SO_PROTOCOL_INFOiBEGIN_DATE="
						+ SO_PROTOCOL_INFOiBEGIN_DATE);
				System.out.println("SO_PROTOCOL_INFOiEND_DATE="
						+ SO_PROTOCOL_INFOiEND_DATE);
				System.out.println("SO_PROTOCOL_INFOiSEQ="
						+ SO_PROTOCOL_INFOiSEQ);
				// 主产品
				System.out.println("PROD_RELAiPROD_ID=" + PROD_RELAiPROD_ID);
				System.out.println("PROD_RELAiPROD_ID2=" + PROD_RELAiPROD_ID2);
				System.out.println("SO_PROTOCOL_INFOiACTION_TYPE="
						+ SO_PROTOCOL_INFOiACTION_TYPE);

				if (!"".equals(SO_PWDiPWD_TYPE)) {
					System.out.println("SO_PWDiPWD_TYPE=" + SO_PWDiPWD_TYPE);
					System.out.println("SO_PWDiPASSWORD=" + SO_PWDiPASSWORD);
				}

				Hashtable ht = new Hashtable();
				ht.put("SOiSO_ID", SOiSO_ID);
				ht.put("SOiSO_NBR", SOiSO_NBR);
				ht.put("SOiAREA_ID", SOiAREA_ID);
				ht.put("SOiSO_TYPE_ID", SOiSO_TYPE_ID);
				ht.put("SOiSERV_TYPE_ID", SOiSERV_TYPE_ID);
				ht.put("SOiSERV_AREA_ID", SOiSERV_AREA_ID);
				ht.put("SOiSERV_SO_ID", SOiSERV_SO_ID);
				ht.put("SOiSERV_SO_SEQ", SOiSERV_SO_SEQ);
				ht.put("SOiSERV_SO_NBR", SOiSERV_SO_NBR);
				ht.put("SOiCUST_ID", SOiCUST_ID);
				ht.put("SOiSUBS_CODE", SOiSUBS_CODE);
				ht.put("SOiDISCT_TYPE_ID", SOiDISCT_TYPE_ID);
				ht.put("SOiSTAFF_ID", SOiSTAFF_ID);
				ht.put("SOiPRIORITY", SOiPRIORITY);
				ht.put("SOiACCEPT_TYPE", SOiACCEPT_TYPE);
				ht.put("SOiACCEPT_DATE", SOiACCEPT_DATE);
				ht.put("SOiSTATE", SOiSTATE);
				ht.put("SOiSERV_ID", SOiSERV_ID);
				ht.put("SOiANN_ACT_TYPE", SOiANN_ACT_TYPE);
				ht.put("FLAG1", FLAG1);
				ht.put("STAFF_ID", STAFF_ID);
				ht.put("SOiPRI_SERV_ID", SOiPRI_SERV_ID);
				ht.put("CORR_INFOiCONTACT_TYPE", CORR_INFOiCONTACT_TYPE);
				ht.put("CORR_INFOiCONTACT_NAME", CORR_INFOiCONTACT_NAME);
				ht.put("CORR_INFOiCONTACT_TEL", CORR_INFOiCONTACT_TEL);
				ht.put("CORR_INFOiCERT_TYPE", CORR_INFOiCERT_TYPE);
				ht.put("CORR_INFOiCERT_NBR", CORR_INFOiCERT_NBR);
				ht.put("SO_PRODiPROD_ID", SO_PRODiPROD_ID);
				ht.put("SO_PRODiPROD_NUM", SO_PRODiPROD_NUM);
				ht.put("SO_PRODiACTION_TYPE", SO_PRODiACTION_TYPE);
				ht.put("SO_SERV_ACCTiACCT_ITEM_TYPE_ID",
						SERV_ACCTiACCT_ITEM_TYPE_ID);
				ht.put("SO_SERV_ACCTiACCT_ID", ACCTiACCT_ID);
				ht.put("SO_SERV_ACCTiBILLING_TYPE_ID",
						SO_SERV_ACCTiBILLING_TYPE_ID);
				ht.put("SERV_ACCTiPAY_RATING", SERV_ACCTiPAY_RATING);
				ht.put("SO_SERV_ACCTiACTION_TYPE", SO_SERV_ACCTiACTION_TYPE);
				ht
						.put("SO_BUSINESSiSECRE_GRADE_ID",
								SO_BUSINESSiSECRE_GRADE_ID);
				ht.put("SO_BUSINESSiLIMIT_DATE", SO_BUSINESSiLIMIT_DATE);
				ht.put("SO_BUSINESSiBESP_DATE", SO_BUSINESSiBESP_DATE);
				ht.put("SO_BUSINESSiPROD_ID", SO_BUSINESSiPROD_ID);
				ht.put("CORP_CUSTiCUST_ID", CORP_CUSTiCUST_ID);
				ht.put("SO_BUSINESSiACTION_TYPE", SO_BUSINESSiACTION_TYPE);
				// ht.put("SO_PROD_ADDINFOiPROD_ID",SO_PROD_ADDINFOiPROD_ID);
				// ht.put("SO_PROD_ADDINFOiADDINFO_NAME",SO_PROD_ADDINFOiADDINFO_NAME);
				// ht.put("SO_PROD_ADDINFOiADDINFO_VALUE",SO_PROD_ADDINFOiADDINFO_VALUE);
				// ht.put("SO_PROD_ADDINFOiADDINFO_SEQ",SO_PROD_ADDINFOiADDINFO_SEQ);
				ht.put("SO_ACCESSiACCESS_ID", SO_ACCESSiACCESS_ID);
				ht.put("SO_ACCESSiACC_NODE_ID", SO_ACCESSiACC_NODE_ID);
				ht.put("SO_ACCESSiEXCH_ID", SO_ACCESSiEXCH_ID);
				ht.put("SO_ACCESSiADDR_ID", SO_ACCESSiADDR_ID);
				ht.put("SO_ACCESSiREF_TEL_NBR", SO_ACCESSiREF_TEL_NBR);
				ht.put("SO_ACCESSiREF_ADDR_ID", SO_ACCESSiREF_ADDR_ID);
				ht.put("SO_ACCESSiACTION_TYPE", SO_ACCESSiACTION_TYPE);
				ht.put("SO_ACC_NBRiNBR_SEQ", SO_ACC_NBRiNBR_SEQ);
				ht.put("SO_ACC_NBRiSEQ", SO_ACC_NBRiSEQ);
				ht.put("SO_ACC_NBRiACC_NBR", SO_ACC_NBRiACC_NBR);
				ht.put("SO_ACC_NBRiIS_CHOSEN", SO_ACC_NBRiIS_CHOSEN);
				ht.put("SO_ACC_NBRiACC_NBR_AB", SO_ACC_NBRiACC_NBR_AB);
				ht.put("SO_ACC_NBRiEXCH_ID", SO_ACC_NBRiEXCH_ID);
				ht.put("SO_ACC_NBRiIS_SECRET", SO_ACC_NBRiIS_SECRET);
				ht.put("SERV_ACCESSiACCESS_ID", SERV_ACCESSiACCESS_ID);
				ht.put("SO_ACC_NBRiMAINTAIN_LEVEL", SO_ACC_NBRiMAINTAIN_LEVEL);
				ht.put("SO_ACC_NBRiINSTALL_LEVEL", SO_ACC_NBRiINSTALL_LEVEL);
				ht.put("SO_ACC_NBRiACTION_TYPE", SO_ACC_NBRiACTION_TYPE);
				ht.put("TEMP_STS_WORDS2", TEMP_STS_WORDS2);
				ht.put("SERV_NBRiAREA_ID", SERV_NBRiAREA_ID);
				ht.put("SERV_NBRiSERV_NBR_ID", SERV_NBRiSERV_NBR_ID);
				/*
				 * ************************前台传进来的宽带帐号********************
				 */
				ht.put("SO_SPECIAL_NBRSiNBR", SO_SPECIAL_NBRSiNBR);
				ht.put("SO_SPECIAL_NBRSiNBR_TYPE", SO_SPECIAL_NBRSiNBR_TYPE);
				ht.put("SO_SPECIAL_NBRSiACTION_TYPE",
						SO_SPECIAL_NBRSiACTION_TYPE);
				ht.put("TEMP_STS_WORDS2", TEMP_STS_WORDS2);
				ht.put("SERV_NBRiAREA_ID", SERV_NBRiAREA_ID);
				ht.put("SERV_NBRiSERV_NBR_ID", SERV_NBRiSERV_NBR_ID);
				ht.put("SO_SPECIAL_NBRSiNBR_ID", SO_SPECIAL_NBRSiNBR_ID);

				ht.put("SO_ACC_TERMiPROD_ID", SO_ACC_TERMiPROD_ID);
				ht.put("SO_ACC_TERMiTERM_TYPE", SO_ACC_TERMiTERM_TYPE);
				ht.put("SO_ACC_TERMiPROPERTY", SO_ACC_TERMiPROPERTY);
				ht.put("SO_ACC_TERMiMTN_GRADE", SO_ACC_TERMiMTN_GRADE);
				ht.put("SO_ACC_TERMiPROD_COUNT", SO_ACC_TERMiPROD_COUNT);
				ht.put("SO_ACC_TERMiAPPL_DATE", SO_ACC_TERMiAPPL_DATE);
				ht.put("SO_ACC_TERMiMATURE_DATE", SO_ACC_TERMiMATURE_DATE);
				ht.put("SO_ACC_TERMiPROTOCOL_ID", SO_ACC_TERMiPROTOCOL_ID);
				ht.put("SO_ACC_TERMiSERIAL_NBR", SO_ACC_TERMiSERIAL_NBR);
				ht.put("SO_ACC_TERMiMODEL_NO", SO_ACC_TERMiMODEL_NO);
				ht.put("SO_ACC_TERMiINSTALL", SO_ACC_TERMiINSTALL);
				ht.put("SO_ACC_TERMiIS_CERTIF_CHECK",
						SO_ACC_TERMiIS_CERTIF_CHECK);
				ht.put("SO_ACC_TERMiCERTIFICATION", SO_ACC_TERMiCERTIFICATION);
				ht.put("SO_ACC_TERMiMAX_SPEED", SO_ACC_TERMiMAX_SPEED);
				ht.put("SO_ACC_TERMiEQPT_IP", SO_ACC_TERMiEQPT_IP);
				ht.put("SO_ACC_TERMiACTION_TYPE", SO_ACC_TERMiACTION_TYPE);

				ht.put("SO_DATA_ACCESS_INFOiTERM_ACC_ID",
						SO_DATA_ACCESS_INFOiTERM_ACC_ID);
				ht.put("SO_DATA_ACCESS_IiACC_PURPOSE_ID",
						SO_DATA_ACCESS_IiACC_PURPOSE_ID);
				ht.put("SO_DATA_ACCESS_INFOiACC_SERV_ID",
						SO_DATA_ACCESS_INFOiACC_SERV_ID);
				ht.put("SO_DATA_ACCESS_INFOiBILL_SERV_ID",
						SO_DATA_ACCESS_INFOiBILL_SERV_ID);
				ht.put("SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID",
						SERV_DATA_ACCESS_INFOiACCT_ITEM_TYPE_ID);
				ht.put("SERV_DATA_ACCESS_INFOiPAY_RATING",
						SERV_DATA_ACCESS_INFOiPAY_RATING);
				ht.put("SO_DATA_ACCESS_INFOiSEQ", SO_DATA_ACCESS_INFOiSEQ);
				ht.put("SO_DATA_ACCESS_INFOiACT_TYPE",
						SO_DATA_ACCESS_INFOiACT_TYPE);

				ht.put("SO_DATA_LINE_IiDATA_LINE_ACC_ID",
						SO_DATA_LINE_IiDATA_LINE_ACC_ID);
				ht.put("SO_DATA_LINE_INFOiLINE_TYPE_ID",
						SO_DATA_LINE_INFOiLINE_TYPE_ID);
				ht
						.put("SO_DATA_LINE_INFOiLINE_USE",
								SO_DATA_LINE_INFOiLINE_USE);
				ht.put("SO_DATA_LINE_INFOiIS_NODE", SO_DATA_LINE_INFOiIS_NODE);
				ht.put("SO_DATA_LINE_INFOiIP_AMOUNT",
						SO_DATA_LINE_INFOiIP_AMOUNT);
				ht.put("SO_DATA_LINE_INFOiIP_TYPE", SO_DATA_LINE_INFOiIP_TYPE);
				ht.put("SO_DATA_LINE_INFOiREMARKS", SO_DATA_LINE_INFOiREMARKS);
				ht.put("SO_DATA_LINE_INFOiACTION_TYPE",
						SO_DATA_LINE_INFOiACTION_TYPE);
				if (!"".equals(SO_PWDiPWD_TYPE)) {
					ht.put("SO_PWDiPWD_TYPE", SO_PWDiPWD_TYPE);
					ht.put("SO_PWDiPASSWORD", SO_PWDiPASSWORD);
				}
				ht.put("SO_PROTOCOL_INFOiPROTOCOL_ID",
						SO_PROTOCOL_INFOiPROTOCOL_ID);
				ht.put("SO_PROTOCOL_INFOiFLAG", SO_PROTOCOL_INFOiFLAG);
				ht.put("SO_PROTOCOL_INFOiLASTED", SO_PROTOCOL_INFOiLASTED);
				ht.put("SO_PROTOCOL_INFOiBEGIN_DATE",
						SO_PROTOCOL_INFOiBEGIN_DATE);
				ht.put("SO_PROTOCOL_INFOiEND_DATE", SO_PROTOCOL_INFOiEND_DATE);
				ht.put("SO_PROTOCOL_INFOiSEQ", SO_PROTOCOL_INFOiSEQ);

				ht.put("PROD_RELAiPROD_ID", PROD_RELAiPROD_ID);
				ht.put("PROD_RELAiPROD_ID2", PROD_RELAiPROD_ID2);
				ht.put("SO_PROTOCOL_INFOiACTION_TYPE",
						SO_PROTOCOL_INFOiACTION_TYPE);
				FormBody fb = BssInter7.callWebReferSo(ht, cityCode);
				tf_BSSFlowRecord.setRecordIDS("SOISO_SEQ", fb
						.getString("SOiSO_SEQ"));// 申请序列号
				tf_BSSFlowRecord.setRecordIDS("SOISO_ID", fb
						.getString("SOiSO_ID"));// 申请流水号
				tf_BSSFlowRecord.setRecordIDS("SOISO_NBR", fb
						.getString("SOiSO_NBR"));// 申请单号
				tf_BSSFlowRecord.setRecordIDS("SOIAPPL_DATE", fb
						.getString("SOiAPPL_DATE"));// 申请时间
				tf_BSSFlowRecord.setStepSN(11);
				tf_BSSFlowRecord.save();
				return "1";
			} else {
				return info;
			}
		} catch (Exception e) {
			// log.warn(e.getMessage(), e);
			return null;
		}
	}

	/**
	 * 新建DataTable只支持多行单列
	 * 
	 * @param tableName
	 * @param colName
	 * @param value
	 * @return
	 */
	public DataTable getNewTable(String tableName, String colName,
			String value[]) {
		DataTable newDt = new DataTable();
		try {
			newDt.setTableName(tableName);
			DataColumn dataColumn = new DataColumn();
			DBTypes dbType = new DBTypes();
			dataColumn.setColumnName(colName);
			dbType.set(DBTypes.VARCHAR);
			dataColumn.setDataType(dbType);
			newDt.getColumns().add(dataColumn);
			for (int i = 0; i < value.length; i++) {
				DataRow dataRow = newDt.newRow();
				dataRow.setValue(colName, value[i]);
				newDt.getRows().add(dataRow);
			}
			newDt.acceptChanges();
			return newDt;
		} catch (Exception e) {
			// log.warn(e.getMessage(), e);
			return null;
		}
	}

	public DataTable addRows(DataTable dt, String colName, String value[]) {
		try {
			if (dt.getRows().getCount() > 0) {
				for (int j = 0; j < dt.getRows().getCount(); j++) {
					for (int i = 0; i < value.length; i++) {
						if (!dt.getRow(j).getString(colName).equals(value[i])) {
							DataRow dataRow = dt.newRow();
							dataRow.setValue(colName, value[i]);
							dt.getRows().add(dataRow);
						}
					}
				}
			} else {
				for (int i = 0; i < value.length; i++) {
					DataRow dataRow = dt.newRow();
					dataRow.setValue(colName, value[i]);
					dt.getRows().add(dataRow);
				}
			}
			dt.acceptChanges();
			return dt;
		} catch (Exception e) {
			// log.warn(e.getMessage(), e);
			return null;
		}
	}

	public DataTable addRow(DataTable dt, String colName, String value) {
		try {
			for (int j = 0; j < dt.getRows().getCount(); j++) {
				if (!dt.getRow(j).getString(colName).equals(value)) {
					DataRow dataRow = dt.newRow();
					dataRow.setValue(colName, value);
					dt.getRows().add(dataRow);
				}
			}
			dt.acceptChanges();
			return dt;
		} catch (Exception e) {
			// log.warn(e.getMessage(), e);
			return null;
		}
	}

}