/** 扩展基类的preDelete方法，对实际业务做删除前的检验 */
public int preDelete(
SessionContext ctx,
DatabaseConnection conn,
FormInstance instance,
ErrorMessages msgs,
EventManager manager,
SqlAssistor assistor) {
String cltNo = ctx.getParameter("CLIENTNO");
String bmStr = "select * from bmtable where clientno='" + cltNo + "'";
RecordSet bmRs = conn.executeQuery(bmStr);
if (bmRs.next()) {
msgs.add("还有业务没有删除");
return -1;
}
RecordSet rs = conn.executeQuery("select id from CMINDVCLIENT where clientno='" + cltNo + "'");
if (!rs.next()) {
msgs.add("取得id失败！");
return -1;
} else {
String id = rs.getString("ID");
String tempStr = "select * from bmguarantor where id='" + id + "'";
// System.out.println(tempStr);
RecordSet tempRs = conn.executeQuery(tempStr);
if (tempRs.next()) {
msgs.add("还有担保的贷款,不能删除！");
return -1;
}
}
String sql1[] = new String[4];
sql1[0] = "delete from CMINDVRELA where clientno='" + cltNo + "'";
sql1[1] = "delete from CMINDVASSET where clientno='" + cltNo + "'"; //
sql1[2] = "delete from CMINDVDEBT where clientno='" + cltNo + "'"; //
sql1[3] = "delete from CMINDVDEBTPAYMENT where clientno='" + cltNo + "'"; //
String sql2 = "";
for (int i = 0; i < sql1.length; i++) {
sql2 += sql1[i] + ";";
}
sql2 = sql2.substring(0, sql2.length() - 1);
// System.out.println(sql2);
int ret = conn.executeUpdate(sql2);
return ret;
}
public int postInsertOk(
SessionContext ctx,
DatabaseConnection conn,
FormInstance instance,
ErrorMessages msgs,
EventManager manager) {
if (this.isG) {
return conn.executeUpdate(
"delete from cmguarantor where id='" + ctx.getParameter("ID") + "'");
}
if (this.initClientNo == null) {
return 0;
}
MyDB.getInstance().addDBConn(conn);
int ret = 0;
try {
UserManager um = (UserManager) ctx.getAttribute(SystemAttributeNames.USER_INFO_NAME);
String OPERATOR = null;
OPERATOR = um.getUserName();
String clientno = null;
if (this.initClientNo != null) {
if (currClientNo == null) {
msgs.add("客户号码未发现，请重做交易！");
return -1;
} else {
ret = ClientMigration.clientMrig(initClientNo, currClientNo, OPERATOR);
if (ret >= 0) {
/** I comment following line temporarily to speed up perfomance JGO on 20040905 */
// ret = CMClientMan.updateClientCatAndType(currClientNo, OPERATOR);
ret = 0;
}
if (ret < 0) {
String msg = PropertyManager.getProperty("" + ret);
if (msg == null) {
msg = "" + ret;
}
ctx.setRequestAtrribute("title", "客户信息移行");
ctx.setRequestAtrribute("msg", "处理失败:" + msg);
ctx.setRequestAtrribute("flag", "0");
ctx.setTarget("/showinfo.jsp");
} else {
ctx.setRequestAtrribute("title", "客户信息移行");
ctx.setRequestAtrribute("msg", "处理成功完成！");
ctx.setRequestAtrribute("flag", "1");
ctx.setTarget("/showinfo.jsp");
}
}
}
} catch (Exception e) {
if (Debug.isDebugMode) {
e.printStackTrace();
}
ret = -1;
} finally {
MyDB.getInstance().releaseDBConn();
return ret;
}
}