private boolean initFordo(IMessage message, String soa_processid) {
con = null;
usrno = null;
usrname = null;
password = null;
roleno = null;
employeeid = null;
state = null;
lastupdateuser = null;
lastupdatetime = null;
note = null;
enabled = null;
oldRoleno = null;
con = (Connection) message.getOtherParameter("con");
usrno = message.getUserParameterValue("usrno");
usrname = message.getUserParameterValue("usrname");
password = message.getUserParameterValue("password");
roleno = message.getUserParameterValue("roleno").trim();
oldRoleno = message.getUserParameterValue("oldRoleno").trim();
default_roleno = message.getUserParameterValue("default_roleno");
old_default_roleno = message.getUserParameterValue("old_default_roleno");
employeeid = message.getUserParameterValue("employeeid");
state = message.getUserParameterValue("state");
lastupdateuser = message.getUserParameterValue("lastupdateuser");
lastupdatetime = message.getUserParameterValue("lastupdatetime");
note = message.getUserParameterValue("note");
enabled = message.getUserParameterValue("enabled");
// 获取运行流程项
IProcess process = ProcessFactory.getInstance(soa_processid);
String processInfo = process.getNameSpace() + "." + process.getName();
String debug_UpdateUser =
"******"
+ usrno
+ "\n"
+ "usrname = "
+ usrname
+ "\n"
+ "password = "******"\n"
+ "roleno = "
+ roleno
+ "\n"
+ "oldRoleno = "
+ oldRoleno
+ "\n"
+ "default_roleno = "
+ default_roleno
+ "\n"
+ "old_default_roleno = "
+ old_default_roleno
+ "\n"
+ "employeeid = "
+ employeeid
+ "\n"
+ "state = "
+ state
+ "\n\r"
+ "lastupdateuser = "******"\n"
+ "lastupdatetime = "
+ lastupdatetime
+ "\n"
+ "note = "
+ note
+ "\n"
+ "enabled = "
+ enabled
+ "\n";
log.debug(processInfo + ",修改用户时用户提交的参数: " + debug_UpdateUser);
if (usrno == null
|| usrname == null
|| password == null
|| roleno == null
|| employeeid == null
|| state == null
|| lastupdateuser == null
|| lastupdatetime == null
|| note == null
|| enabled == null) {
message.addServiceException(
new ServiceException(
ServiceExceptionType.PARAMETERLOST,
"添加用户时参数为空",
this.getId(),
soa_processid,
new java.util.Date(),
null));
log.error(processInfo + ",修改用户,缺少输入参数");
return false;
}
return true;
}
@SuppressWarnings("unchecked")
public ExecuteResult undoService(IMessage message, String soa_processid) {
IProcess process = ProcessFactory.getInstance(soa_processid);
String processInfo = process.getNameSpace() + "." + process.getName();
Object obj = message.getOtherParameter(this.getClass().getName());
if (obj instanceof Map) {
Map<String, String> map = (Map<String, String>) obj;
String map_usrno = map.get("rs_usrno");
String map_usrname = map.get("rs_usrname");
String map_password = map.get("rs_password");
String map_oldRoleno = map.get("rs_oldRoleno").trim();
String map_employeeid = map.get("rs_employeeid").trim();
String map_old_default_roleno = map.get("rs_old_default_roleno");
String map_state = map.get("rs_state");
String map_lastupdateuser = map.get("rs_lastupdateuser");
String map_lastupdatetime = map.get("rs_lastupdatetime");
String map_note = map.get("rs_note");
String map_enabled = map.get("rs_enabled");
String map_debug =
"map_usrno = "
+ map_usrno
+ "\n"
+ "map_usrname = "
+ map_usrname
+ "\n"
+ "map_password = "******"\n"
+ "map_oldRoleno = "
+ map_oldRoleno
+ "\n"
+ "map_employeeid = "
+ map_employeeid
+ "\n"
+ "map_state = "
+ map_state
+ "\n"
+ "map_lastupdateuser = "******"\n"
+ "map_lastupdatetime = "
+ map_lastupdatetime
+ "\n"
+ "map_note = "
+ map_note
+ "\n"
+ "map_enabled = "
+ map_enabled;
log.debug(processInfo + "修改用户回退操作Map接收的所有信息为: map_debug = " + map_debug);
try {
Statement stmt = null;
try {
IDAO_UserManager dao =
DAOFactory_UserManager.getInstance(DataBaseType.getDataBaseType(con));
if (dao == null) {
message.addServiceException(
new ServiceException(
ServiceExceptionType.UNKNOWNDATABASETYPE,
"",
this.getId(),
soa_processid,
new Date(),
null));
log.error(processInfo + ",修改用户回退操作,加载数据库错误,未知的数据库类型");
return ExecuteResult.fail;
}
log.debug(processInfo + ",修改用户回退操作,加载数据库成功");
stmt = con.createStatement();
String undo_sql_update;
// password be changed
if (!password.equals("********")) {
undo_sql_update =
dao.getSQL_UpdateUser(
map_usrno,
map_usrname,
map_password,
map_employeeid,
map_state,
map_lastupdateuser,
map_lastupdatetime,
map_note,
map_enabled);
} else // password not changed
{
undo_sql_update =
dao.getSQL_UpdateUser(
map_usrno,
map_usrname,
map_employeeid,
map_state,
map_lastupdateuser,
map_lastupdatetime,
map_note,
map_enabled);
}
log.debug("修改用户回退操作的sql语句: undo_sql_update = " + undo_sql_update);
stmt.executeUpdate(undo_sql_update);
String sql_deleteDataUserRole = "";
String sql_insertDataUserRole = "";
String[] role_old = map_oldRoleno.split(":");
sql_deleteDataUserRole = dao.getSQL_DeleteDataUserRole(new Integer(map_usrno));
log.debug("根据角色号，删除新角色号的sql语句:sql_deleteDataUserRole = " + sql_deleteDataUserRole);
stmt.executeUpdate(sql_deleteDataUserRole);
for (String ch : role_old) {
if (ch != null && !ch.equals("")) {
if (map_old_default_roleno.equals(ch)) {
sql_insertDataUserRole =
dao.getSQL_insertDataUserRole(new Integer(usrno), new Integer(ch), "0");
} else {
sql_insertDataUserRole =
dao.getSQL_insertDataUserRole(new Integer(usrno), new Integer(ch), "1");
}
log.debug(
"插入原有角色号data_user_role表的sql语句: sql_insertDataUserRole = "
+ sql_insertDataUserRole);
stmt.executeUpdate(sql_insertDataUserRole);
}
}
} catch (SQLException sqle) {
message.addServiceException(
new ServiceException(
ServiceExceptionType.DATABASEERROR,
"数据库错误" + sqle,
this.getId(),
soa_processid,
new Date(),
sqle));
log.fatal(processInfo + ",修改用户,数据库操作异常" + sqle.toString());
return ExecuteResult.fail;
} finally {
if (stmt != null) stmt.close();
}
} catch (Exception e) {
message.addServiceException(
new ServiceException(
ServiceExceptionType.UNKNOWN,
e.toString(),
this.getId(),
soa_processid,
new java.util.Date(),
e));
log.fatal(processInfo + ",修改用户,未知异常" + e.toString());
return ExecuteResult.fail;
}
}
return ExecuteResult.sucess;
}
