/**
* MOS native 从sysconfig中取得MOS需要的缓存
*
* @return
* @throws SysException
* @throws AppException
*/
public String getSysConfig4MOS() throws SysException, AppException {
IM4MOSServicesService service = new IM4MOSServicesServiceLocator();
IM4MOSServices_PortType client = null;
// String urlStr = "http://127.0.0.1:7001/web/services/";
String urlStr = "";
// 如果初始化缓存则使用缓存地址
if (!StringUtil.isBlank(
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_INIT_CONFIG, null, null, null, null, null))
&& SysConstants.TRUE.equals(
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_INIT_CONFIG, null, null, null, null, null))) {
urlStr =
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_LOCAL_SERVER_ADDR, null, null, null, null, null);
} else {
// 没有初始化则使用常量
urlStr = SysConstants.MOS_SELF_SERVER_ADDR_FOR_ACTION;
}
// String urlStr = SysConfigData.getSysConfigCurValue(
// SysConstants.SYS_CONFIG_MOS_SERVER_ADDR, null, null, null,
// null, null);
urlStr = urlStr + "IM4MOSServices";
URL url;
String vesion = null;
try {
url = new URL(urlStr);
client = service.getIM4MOSServices(url);
vesion =
client.svcCallIOMByMosNative(SysConstants.SYS_CONFIG_MOS_QUERY_SYS_CONFIG, null, null);
} catch (RemoteException e) {
throw new AppException("", "调用远程webservice方法失败！");
} catch (MalformedURLException e1) {
throw new AppException("", "调用远程webservice方法失败！");
} catch (ServiceException e) {
throw new AppException("", "调用远程webservice方法失败！");
}
log.debug("client: " + client);
if (StringUtil.isExcetionInfo(vesion)) {
throw new AppException("", "调用远程webservice方法失败！" + StringUtil.getExcetionInfo(vesion));
}
return vesion;
}
public String resChange(String paramStr) throws AppException, SysException {
String urlStr = "";
try {
RmsServiceForMos service = new RmsServiceForMosLocator();
RmsServiceForMosDelegate client = null;
// 如果初始化缓存则使用缓存地址
if (!StringUtil.isBlank(
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_INIT_CONFIG, null, null, null, null, null))
&& SysConstants.TRUE.equals(
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_INIT_CONFIG, null, null, null, null, null))) {
urlStr =
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_SERVER_ADDR, null, null, null, null, null);
} else {
// 没有初始化则使用常量
urlStr = SysConstants.MOS_SERVER_ADDR_FOR_ACTION;
}
URL url = new URL(urlStr);
client = service.getRmsServiceForMosPort(url);
String mosCallLog = client.resChange(paramStr);
return mosCallLog;
} catch (RemoteException e) {
throw new AppException("", "调用远程webservice方法失败！" + urlStr + e.getMessage());
} catch (MalformedURLException e) {
log.info(e.toString());
throw new AppException("", "webserviceURL地址错误！" + urlStr + e.getMessage());
} catch (ServiceException e) {
log.info(e.toString());
throw new AppException("", "调用远程webservice方法失败！" + urlStr + e.getMessage());
}
}
public String queryDevice(String paramStr) throws AppException, SysException {
String urlStr = "";
try {
RmsServiceForMos service = new RmsServiceForMosLocator();
RmsServiceForMosDelegate client = null;
// String urlStr = SysConfigData.getSysConfigCurValue(
// SysConstants.SYS_CONFIG_MOS_SERVER_ADDR, null, null, null,
// null, null);
// 如果初始化缓存则使用缓存地址
if (!StringUtil.isBlank(
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_INIT_CONFIG, null, null, null, null, null))
&& SysConstants.TRUE.equals(
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_INIT_CONFIG, null, null, null, null, null))) {
urlStr =
SysConfigData.getSysConfigCurValue(
SysConstants.SYS_CONFIG_MOS_SERVER_ADDR, null, null, null, null, null);
} else {
// 没有初始化则使用常量
urlStr = SysConstants.MOS_SERVER_ADDR_FOR_ACTION;
}
// String urlStr = SysConstants.SYS_CONFIG_MOS_SERVER_ADDR;
// urlStr = "http://10.22.1.41:8080/trms/services/RmsForMosService";
URL url = new URL(urlStr);
client = service.getRmsServiceForMosPort(url);
String mosLoginRep = client.deviceQuery(paramStr);
return mosLoginRep;
} catch (RemoteException e) {
throw new AppException("", "调用远程webservice方法失败！" + urlStr + e.getMessage());
} catch (MalformedURLException e) {
log.info(e.toString());
throw new AppException("", "webserviceURL地址错误！" + urlStr + e.getMessage());
} catch (ServiceException e) {
log.info(e.toString());
throw new AppException("", "调用远程webservice方法失败！" + urlStr + e.getMessage());
}
}
public PagView findByLocalNet(GenericVO svo, String localNetId, PagInfo pagInfo)
throws AppException, SysException {
SysAreaConfigMVO vo = (SysAreaConfigMVO) svo;
List results = null;
Sql sql = new Sql("select");
sql.append(
" a.SYS_AREA_CONFIG_ID,a.CONFIG_ID,a.SP_AREA_ID,a.CUR_VALUE,a.VALUE_DESC,b.name,b.system_name,b.config_type ");
sql.append(
" from SYS_AREA_CONFIG a,sys_config b where 1=1 and a.config_id=b.config_id and b.config_type='L'");
// if (vo.getSysAreaConfigId() != null) {
// sql.append(" and a.SYS_AREA_CONFIG_ID=:sysAreaConfigId");
// sql.setInteger("sysAreaConfigId", StringUtil.toString(vo.getSysAreaConfigId()).trim());
// }
if (vo.getSysAreaConfigId() != null) {
sql.append(" and a.SYS_AREA_CONFIG_ID like :sysAreaConfigId");
sql.setString(
"sysAreaConfigId", "%" + StringUtil.toString(vo.getSysAreaConfigId()).trim() + "%");
}
if (vo.getConfigId() != null) {
sql.append(" and b.CONFIG_ID like :configId");
sql.setString("configId", "%" + vo.getConfigId() + "%");
}
if (vo.getSpAreaId() != null) {
sql.append(" and a.SP_AREA_ID=:spAreaId");
sql.setString("spAreaId", vo.getSpAreaId());
}
if (vo.getCurValue() != null) {
sql.append(" and a.CUR_VALUE=:curValue");
sql.setString("curValue", vo.getCurValue());
}
if (vo.getValueDesc() != null) {
sql.append(" and a.VALUE_DESC like :valueDesc");
sql.setString("valueDesc", "%" + vo.getValueDesc() + "%");
}
if (vo.getName() != null) {
sql.append(" and b.name like :name");
sql.setString("name", "%" + vo.getName() + "%");
}
if (vo.getConfigType() != null) {
sql.append(" and b.config_type=:configType");
sql.setString("configType", vo.getConfigType());
}
if (localNetId != null) {
sql.append(" and a.sp_area_id=:spId");
sql.setString("spId", localNetId);
}
sql.append(" union select ");
sql.append(
" a.SYS_AREA_CONFIG_ID,a.CONFIG_ID,a.SP_AREA_ID,a.CUR_VALUE,a.VALUE_DESC,b.name,b.system_name,b.config_type ");
sql.append(
" from SYS_AREA_CONFIG a,sys_config b,AREA C where 1=1 and a.config_id=b.config_id and b.config_type='A' ");
sql.append(" and c.area_id=a.sp_area_id and c.sts='A' ");
// if (vo.getSysAreaConfigId() != null) {
// sql.append(" and a.SYS_AREA_CONFIG_ID=:sysAreaConfigId");
// sql.setInteger("sysAreaConfigId", StringUtil.toString(vo.getSysAreaConfigId()).trim());
// }
if (vo.getSysAreaConfigId() != null) {
sql.append(" and a.SYS_AREA_CONFIG_ID like :sysAreaConfigId");
sql.setString(
"sysAreaConfigId", "%" + StringUtil.toString(vo.getSysAreaConfigId()).trim() + "%");
}
// if (vo.getConfigId() != null) {
// sql.append(" and a.CONFIG_ID=:configId");
// sql.setInteger("configId", vo.getConfigId());
// }
if (vo.getConfigId() != null) {
sql.append(" and b.CONFIG_ID like :configId");
sql.setString("configId", "%" + vo.getConfigId() + "%");
}
if (vo.getSpAreaId() != null) {
sql.append(" and a.SP_AREA_ID=:spAreaId");
sql.setString("spAreaId", vo.getSpAreaId());
}
if (vo.getCurValue() != null) {
sql.append(" and a.CUR_VALUE=:curValue");
sql.setString("curValue", vo.getCurValue());
}
if (vo.getValueDesc() != null) {
sql.append(" and a.VALUE_DESC like :valueDesc");
sql.setString("valueDesc", "%" + vo.getValueDesc() + "%");
}
if (vo.getName() != null) {
sql.append(" and b.name like :name");
sql.setString("name", "%" + vo.getName() + "%");
}
if (vo.getConfigType() != null) {
sql.append(" and b.config_type=:configType");
sql.setString("configType", vo.getConfigType());
}
if (localNetId != null) {
sql.append(" and c.local_NET_ID=:localNetId");
sql.setString("localNetId", localNetId);
}
sql.append(" union select ");
sql.append(
" a.SYS_AREA_CONFIG_ID,a.CONFIG_ID,a.SP_AREA_ID,a.CUR_VALUE,a.VALUE_DESC,b.name,b.system_name,b.config_type ");
sql.append(
" from SYS_AREA_CONFIG a,sys_config b,exch c where 1=1 and a.config_id=b.config_id and b.config_type='A' ");
sql.append(" and c.exch_id=a.sp_area_id and c.sts='A' ");
// if (vo.getSysAreaConfigId() != null) {
// sql.append(" and a.SYS_AREA_CONFIG_ID=:sysAreaConfigId");
// sql.setInteger("sysAreaConfigId", StringUtil.toString(vo.getSysAreaConfigId()).trim());
// }
if (vo.getSysAreaConfigId() != null) {
sql.append(" and a.SYS_AREA_CONFIG_ID like :sysAreaConfigId");
sql.setString(
"sysAreaConfigId", "%" + StringUtil.toString(vo.getSysAreaConfigId()).trim() + "%");
}
// if (vo.getConfigId() != null) {
// sql.append(" and a.CONFIG_ID=:configId");
// sql.setInteger("configId", vo.getConfigId());
// }
if (vo.getConfigId() != null) {
sql.append(" and b.CONFIG_ID like :configId");
sql.setString("configId", "%" + vo.getConfigId() + "%");
}
if (vo.getSpAreaId() != null) {
sql.append(" and a.SP_AREA_ID=:spAreaId");
sql.setString("spAreaId", vo.getSpAreaId());
}
if (vo.getCurValue() != null) {
sql.append(" and a.CUR_VALUE=:curValue");
sql.setString("curValue", vo.getCurValue());
}
if (vo.getValueDesc() != null) {
sql.append(" and a.VALUE_DESC like :valueDesc");
sql.setString("valueDesc", "%" + vo.getValueDesc() + "%");
}
if (vo.getName() != null) {
sql.append(" and b.name like :name");
sql.setString("name", "%" + vo.getName() + "%");
}
if (vo.getConfigType() != null) {
sql.append(" and b.config_type=:configType");
sql.setString("configType", vo.getConfigType());
}
if (localNetId != null) {
sql.append(" and c.local_NET_ID=:localNetId");
sql.setString("localNetId", localNetId);
}
sql.append(" union select ");
sql.append(
" a.SYS_AREA_CONFIG_ID,a.CONFIG_ID,a.SP_AREA_ID,a.CUR_VALUE,a.VALUE_DESC,b.name,b.system_name,b.config_type ");
sql.append(
" from SYS_AREA_CONFIG a,sys_config b,work_area c where 1=1 and a.config_id=b.config_id and b.config_type='A' ");
sql.append(" and c.work_area_id=a.sp_area_id and c.sts='A' ");
// if (vo.getSysAreaConfigId() != null) {
// sql.append(" and a.SYS_AREA_CONFIG_ID=:sysAreaConfigId");
// sql.setInteger("sysAreaConfigId", StringUtil.toString(vo.getSysAreaConfigId()).trim());
// }
if (vo.getSysAreaConfigId() != null) {
sql.append(" and a.SYS_AREA_CONFIG_ID like :sysAreaConfigId");
sql.setString(
"sysAreaConfigId", "%" + StringUtil.toString(vo.getSysAreaConfigId()).trim() + "%");
}
// if (vo.getConfigId() != null) {
// sql.append(" and a.CONFIG_ID=:configId");
// sql.setInteger("configId", vo.getConfigId());
// }
if (vo.getConfigId() != null) {
sql.append(" and b.CONFIG_ID like :configId");
sql.setString("configId", "%" + vo.getConfigId() + "%");
}
if (vo.getSpAreaId() != null) {
sql.append(" and a.SP_AREA_ID=:spAreaId");
sql.setString("spAreaId", vo.getSpAreaId());
}
if (vo.getCurValue() != null) {
sql.append(" and a.CUR_VALUE=:curValue");
sql.setString("curValue", vo.getCurValue());
}
if (vo.getValueDesc() != null) {
sql.append(" and a.VALUE_DESC like :valueDesc");
sql.setString("valueDesc", "%" + vo.getValueDesc() + "%");
}
if (vo.getName() != null) {
sql.append(" and b.name like :name");
sql.setString("name", "%" + vo.getName() + "%");
}
if (vo.getConfigType() != null) {
sql.append(" and b.config_type=:configType");
sql.setString("configType", vo.getConfigType());
}
if (localNetId != null) {
sql.append(" and c.local_NET_ID=:localNetId");
sql.setString("localNetId", localNetId);
}
Connection connection = null;
ResultSet rs = null;
PagView pagView = null;
try {
connection = ConnectionFactory.getConnection();
sql.logPartition(null, this.getClass());
pagView = PagUtil.InitPagViewJDBC(connection, sql, pagInfo);
pagView.getPagCount();
rs = PagUtil.queryOracle(connection, sql, pagInfo);
results = (List) ResultSetUtil.convertToList(rs, SysAreaConfigMVO.class);
pagView.setViewList(results);
} catch (Exception e) {
throw new SysException("", "findByVO error..", e);
} finally {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
}
}
return pagView;
}