public void CST_NO_onblur(
DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
Database db = null;
Rowset rs = null;
String sql = "";
String cstNo = "";
String cstId = "";
String cstNam = "";
try {
db = Tools.getDatabase(true);
cstId = Charset.nullToEmpty(serviceRequest.getParameter("value"));
if (!cstId.equals("")) {
sql = "select cst_no,cst_nam from ogcstmst where cst_id='" + cstId + "'";
rs = db.getRS(sql);
if (rs.getRowCount() <= 0) {
serviceRequest.addServiceReturnParameter("CSTFLG", "FALSE");
return;
} else {
if (rs.next()) {
cstNo = Charset.nullToEmpty(rs.getString("cst_no"));
cstNam = Charset.nullToEmpty(rs.getString("cst_nam"));
}
}
}
serviceRequest.addServiceReturnParameter("CSTFLG", "TRUE");
serviceRequest.addServiceReturnParameter("CST_NO", cstNo);
serviceRequest.addServiceReturnParameter("CST_NAM", cstNam);
} catch (Exception e) {
Log.error(e);
} finally {
if (db != null) db.cleanup();
}
}
public static void Wf_createFstNodeS(String params, HttpServletRequest request) throws Exception {
String[] p = params.split("\\;");
String userid = p[0];
String progid = p[1];
String dicttblid = p[2];
String seq = p[3];
String mdltypno = p[4];
String org_no = p[5];
Database db = null;
Rowset rs = null;
Rowset rsin = null;
Rowset obrs = null;
Rowset currrs = null;
String sql = null;
String startobj = null;
StringBuffer rtn = new StringBuffer();
sql = "SELECT user_id FROM WFSTRIGMST WHERE MDLTYP_NO='" + mdltypno + "' and USER_FLG='1'";
try {
rs = WorkFlowExecSql.wf_getRs(sql);
int i = 0;
while (rs.next()) {
if (i < rs.getRowCount()) {
rtn.append(rs.getString(1) + ";");
} else {
rtn.append(rs.getString(1));
}
i++;
}
String version = WorkFlowUtilExt.getWorkFlowCurrVerison(mdltypno);
sql =
"select object_no from wfobjmst t where t.model_no='"
+ version
+ "' and t.object_typ='01'";
obrs = WorkFlowExecSql.wf_getRs(sql);
if (obrs.next()) {
startobj = obrs.getString(1);
}
sql = "select object_no from vw_wfobjrelmst where head='" + startobj + "'";
currrs = WorkFlowExecSql.wf_getRs(sql);
if (currrs.next()) {
rtn = new StringBuffer(currrs.getString(1) + "|").append(rtn);
}
sql = "select WFAPP_ID from WFMDLTYPMST where MDLTYP_NO = " + mdltypno;
rsin = WorkFlowExecSql.wf_getRs(sql);
String appid = "";
if (rs.next()) {
appid = rsin.getString(1);
}
WorkflowUtil.creatFstNode(
dicttblid, progid, appid, seq, mdltypno, userid, "0", "1", rtn.toString(), "", org_no);
} catch (Exception se) {
se.printStackTrace();
} finally {
if (db != null) {
db.cleanup();
}
}
}
public static String getFWList(String params, HttpServletRequest request) throws Exception {
String reStr = "";
String sql =
"select t.MDLTYP_NO from OADOCTMPLMST t where t.WORKFLOW_TYP='02' and t.ORG_NO=" + params;
Rowset rs = Database.getRowset(sql);
int i = 1;
while (rs.next()) {
reStr = reStr + rs.getString("MDLTYP_NO");
if (rs.getRowCount() > i) {
reStr = reStr + ";";
}
i++;
}
return reStr;
}