public void Delete(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) { Table table = dataDom.getTable("YXDBJYMST"); Row row = table.getRow(0L); if (row == null) { serviceRequest.getMessage().addInfo("没有需要删除的数据"); return; } String pkValue = table.getPkValue(); if ((pkValue == null) || ("".equals(pkValue.trim()))) { serviceRequest.getMessage().addInfo("没有需要删除的数据"); return; } Database db = null; try { db = Tools.getDatabase(false); deleteChildTable(dataDom, sessionInfo, serviceRequest, db); super.Delete(dataDom, sessionInfo, serviceRequest, db); db.commit(); dataDom.refresh(sessionInfo); serviceRequest.getMessage().addInfo("删除数据成功"); } catch (Exception e) { if (db != null) { db.rollback(); } Log.error(e); serviceRequest.getMessage().addInfo("发生异常,请联系管理员"); } finally { if (db != null) { db.cleanup(); } dataDom.refresh(sessionInfo); } init(dataDom, sessionInfo, serviceRequest); }
public String getuser(String usrid, HttpServletRequest request) { String resu = ""; Database db = null; Rowset rs = null; try { db = Tools.getDatabase(true); String str_ALLUSRID = usrid; String[] ARR_USR = str_ALLUSRID.split("\\|"); String str_rtn = ""; for (int i = 0; i < ARR_USR.length; i++) { String str_USRID = ARR_USR[i]; if ((str_USRID != null) && (!str_USRID.equals(""))) { String str_SQL = "select USR_NAM from UTUSRMST where USR_ID = '" + str_USRID + "'"; rs = db.getRS(str_SQL); if (rs.next()) { String userpos = getUserInfo.getAttribute(str_USRID); if ((userpos == null) || (userpos.equals(""))) { userpos = " "; } if (str_rtn.equals("")) { str_rtn = str_USRID + "|" + rs.getString("USR_NAM") + "|" + userpos; } else { str_rtn = str_rtn + "||" + str_USRID + "|" + rs.getString("USR_NAM") + "|" + userpos; } } } } resu = str_rtn; } catch (Exception e) { Log.error(e); } finally { db.cleanup(); } return resu; }
public static void Wf_createFstNode(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; String sql = null; try { sql = "select WFAPP_ID from WFMDLTYPMST where MDLTYP_NO = " + mdltypno; rs = WorkFlowExecSql.wf_getRs(sql); String appid = ""; if (rs.next()) { appid = rs.getString(1); } WorkflowUtil.creatFstNode( dicttblid, progid, appid, seq, mdltypno, userid, "0", "2", null, "", org_no); } catch (Exception se) { se.printStackTrace(); } finally { if (db != null) { db.cleanup(); } } }
public void Delete(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) { Table table = dataDom.getTable("YXPBPFMST"); Row row = table.getRow(0L); if (row == null) { /* */ serviceRequest.getMessage().addInfo("没有需要删除的数据!"); return; } String pkValue = table.getPkValue(); if ((pkValue == null) || ("".equals(pkValue.trim()))) { serviceRequest.getMessage().addInfo("没有需要删除的数据!"); return; } Database db = null; try { db = Tools.getDatabase(false); deleteChildTable(dataDom, sessionInfo, serviceRequest, db); super.Delete(dataDom, sessionInfo, serviceRequest, db); db.commit(); serviceRequest.getMessage().addInfo("删除成功!"); } catch (Exception e) { if (db != null) { db.rollback(); } Log.error(e); serviceRequest.getMessage().addInfo("删除失败,请重试或联系系统管理员!"); } finally { if (db != null) db.cleanup(); } }
public void clearDLFL_AMT(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws Exception { Table table = dataDom.getTable("YXPRJMST"); Database db = null; String pk = ""; try { db = Tools.getDatabase(false); save(dataDom, sessionInfo, serviceRequest); serviceRequest.getMessage().clear(); pk = table.getPkValue(); db.execSqlUpdate("update YXPRJLIN set DLFL_AMT='' where PRJ_NO = " + pk); db.commit(); pk = table.getPkValue(); WhereLimit wr = new WhereLimit(); wr.addColumn(new Column("PRJ_NO", pk)); dataDom.getTable("YXPRJLIN").setWhereLimit(wr); dataDom.getTable("YXPRJLIN").refresh("B1YXM00030", sessionInfo); } catch (Exception ex) { db.rollback(); Log.error(ex); } finally { if (db != null) { db.cleanup(); } } }
public void DeleteAllSubTable_FB( DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws Exception { Table table = dataDom.getTable("YXPRJMST"); Database db = null; String pk = ""; try { db = Tools.getDatabase(false); save(dataDom, sessionInfo, serviceRequest); serviceRequest.getMessage().clear(); pk = table.getPkValue(); if ((pk != null) && (!"".equals(pk))) { db.execSqlUpdate("delete from YXPRJLIN where IS_FB='Y' and PRJ_NO = " + pk); } db.commit(); WhereLimit wr = new WhereLimit(); wr.addColumn(new Column("PRJ_NO", pk)); dataDom.getTable("YXPRJLIN").setWhereLimit(wr); dataDom.getTable("YXPRJLIN").refresh("B1YXM00030", sessionInfo); } catch (Exception ex) { if (db != null) { db.rollback(); } Log.error(ex); } finally { if (db != null) { db.cleanup(); } } }
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 deletedata(String params, HttpServletRequest request) throws Exception { Database db = null; try { db = Tools.getDatabase(true); String sql = "delete from WFTESTMST where CLIENTIP = '" + request.getRemoteAddr() + "'"; db.execSqlUpdate(sql); } catch (SQLException se) { Log.error(se.getMessage()); return "删除失败"; } finally { if (db != null) { db.cleanup(); } } return "删除成功"; }
public static void initWhereLimit( DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) { String userId = sessionInfo.getUserId(); if (!"SYS".equals(userId)) { String issql = " select count(1) num "; issql = issql + " from dkworkgrpmst a "; issql = issql + " left join dkworkgrpposlnk c on a.workgrp_id=c.workgrp_id "; issql = issql + " left join cmpositionmst d on c.pos_no=d.position_no "; issql = issql + " left join cmempposmst e on d.position_no=e.position_no "; issql = issql + " left join cmempmst f on e.emp_no=f.emp_no "; issql = issql + " where f.emp_id='" + userId + "' and a.workgrp_id='XMXICK' "; String num = Database.getValue(issql); if (!num.equals("1")) { String pkField = dataDom.getRootTable().getPkFieldName(); String tableName = dataDom.getRootTable().getName(); String wfSql = JHSMMST.getUsrWfSql(tableName, userId); // 当前用户有关的工作流记录数据 String lmt = "1=1 AND ( PRJ_FMNG='" + userId + "' or PRJ_SMNG='" + userId + "' or FSTUSR_ID='" + userId + "' or " + pkField + " in (" + wfSql + "))"; dataDom.getRootTable().getWhereLimit().addColumn("new_sql_wherelimit", lmt); } } }
public boolean deleteChildTable( DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest, Database db) throws LiemsException { try { if ((dataDom.getRootTable().getPkValue() != null) && (!"".equals(dataDom.getRootTable().getPkValue()))) { String sql = "delete from YXPRJLIN where PRL_NO=" + dataDom.getRootTable().getPkValue(); String sql2 = "delete from YXDOCMST where PRJ_NO=" + dataDom.getRootTable().getPkValue(); db.execSqlUpdate(sql); db.execSqlUpdate(sql2); } } catch (Exception e) { e.printStackTrace(); } return true; }
public void Delete(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) { Table table = dataDom.getTable("YXPRJMST"); Row row = table.getRow(0L); if (row == null) { serviceRequest.getMessage().addInfo("没有需要删除的数据!"); return; } String pkValue = table.getPkValue(); if ((pkValue == null) || ("".equals(pkValue.trim()))) { serviceRequest.getMessage().addInfo("没有需要删除的数据!"); return; } Database db = null; try { db = Tools.getDatabase(false); deleteChildTable(dataDom, sessionInfo, serviceRequest, db); super.Delete(dataDom, sessionInfo, serviceRequest, db); db.commit(); String pk = table.getPkValue(); table.refreshG(pk); pk = table.getPkValue(); WhereLimit wl = new WhereLimit(); wl.addColumn("new_sql_wherelimit", "PRJ_NO =" + pk); Log.info("PRJ_NO:" + pk); dataDom.getTable("YXPRJLIN").setWhereLimit(wl); dataDom.getTable("YXPRJLIN").refresh2("B1YXM00030", sessionInfo); } catch (Exception e) { if (db != null) { db.rollback(); } Log.error(e); serviceRequest.getMessage().addInfo("删除失败,请重试或联系系统管理员!"); table.refresh("B1YXM00030", sessionInfo); ; } finally { if (db != null) { db.cleanup(); } } }
public void setReadOnly(DataDom dataDom) { String prjNo = dataDom.getRootTable().getSafeRowColumnValue("PRJ_NO"); if ((prjNo != null) && (!(prjNo.equals("")))) { String stag = Database.getValue("select PRJ_STAG from yxprjmst where PRJ_NO=" + prjNo); if (!("05".equals(stag))) { dataDom.getChildTable().getField("TBR_NO").setReadonly(true); dataDom.getChildTable().getField("SWPF_SCT").setReadonly(true); dataDom.getChildTable().getField("SWPF_NOT").setReadonly(true); } } }
public void isSplitChange( DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) { try { String pkValue = dataDom.getRootTable().getPkValue(); if ((pkValue != null) && (!"".equals(pkValue))) { Database.execString("delete from yxprjlin where prj_no=" + pkValue); } } catch (Exception e) { Log.error(e); } }
private Object _$15996(String pk) { String id = ""; try { Rowset rs = Database.getRowset("select PRJL_ID from YXPRJLIN where PRJL_NO =" + pk); if (rs.next()) { id = rs.getString("PRJL_ID"); } } catch (Exception e) { e.printStackTrace(); } return id; }
private void initTBRTable(DataDom dataDom, String prjNo, Database db) throws Exception { String sql1 = "select PRJL_NO from YXPRJLIN where PRJ_NO = " + prjNo; String unit = getMonUnit(prjNo); Rowset rs = db.getRS(sql1); CommSequence seq = CommSequence.getInstance("YXDBJYLIN_SEQ"); while (rs.next()) { String prjlNo = Charset.nullToEmpty(rs.getString("PRJL_NO")); String sql = "insert into YXDBJYLIN(DBJYL_NO,PRJL_NO,PRJ_NO,IS_NTC,IS_RCV,MON_UNIT)values(" + seq.getNextValue() + "," + prjlNo + "," + Charset.nullToEmpty(prjNo) + "," + "'N', 'N'," + unit + ")"; db.execSqlUpdate(sql); } }
/** * ??????????????л?????λ * * @param prj_no * @return * @addTime 2014-2-25 ????10:47:13 * @author Libo */ private String getMonUnit(String prj_no) { String unit = ""; try { Rowset rs = Database.getRowset("SELECT MON_UNIT FROM YXKBRMST WHERE PRJ_NO = '" + prj_no + "'"); if (rs.next()) { unit = Charset.nullToEmpty(rs.getString(1)); } } catch (Exception e) { Log.error(e); } return unit; }
public void DeleteAllSubTable( DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws Exception { Table table = dataDom.getTable("YXPRJMST"); Database db = null; String pk = ""; try { db = Tools.getDatabase(false); save(dataDom, sessionInfo, serviceRequest); serviceRequest.getMessage().clear(); pk = table.getPkValue(); db.execSqlUpdate("delete from YXPRJLIN where PRJ_NO = " + pk); db.commit(); } catch (Exception ex) { db.rollback(); Log.error(ex); } finally { if (db != null) { db.cleanup(); } } setFirstRowSubTable(dataDom, sessionInfo, serviceRequest); }
public void setFirstRowSubTable( DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws Exception { String ZB_ID = serviceRequest.getParameter("ZB_ID"); String PRJ_NAM = serviceRequest.getParameter("PRJ_NAM"); Table table = dataDom.getTable("YXPRJMST"); Database db = null; String pk = ""; try { db = Tools.getDatabase(false); pk = table.getPkValue(); String nextPkValue = CommSequence.getInstance("YXPRJLIN_SEQ").getNextValue(); db.execSqlUpdate( "insert into YXPRJLIN(PRJL_NO,PRJ_NO,PRJL_ID,PRJL_NAM,IS_FB) values( " + nextPkValue + "," + pk + ",'" + ZB_ID + "','" + PRJ_NAM + "','Y') "); db.commit(); pk = table.getPkValue(); WhereLimit wr = new WhereLimit(); wr.addColumn(new Column("PRJ_NO", pk)); dataDom.getTable("YXPRJLIN").setWhereLimit(wr); dataDom.getTable("YXPRJLIN").refresh("B1YXM00030", sessionInfo); } catch (Exception ex) { db.rollback(); Log.error(ex); } 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; }
private boolean saveBefore( DataDom dataDom, ServiceRequest serviceRequest, SessionInfo sessionInfo) { Table ctb = dataDom.getChildTable(); String pkValue = dataDom.getRootTable().getPkValue(); ArrayList<String> prjlIds = new ArrayList<String>(); try { Rowset rs = Database.getRowset("select PRJL_ID from YXPRJLIN where PRJ_NO =" + pkValue); while (rs.next()) { String lid = rs.getString("PRJL_ID"); prjlIds.add(lid); } Iterator<?> it = ctb.getRows().keySet().iterator(); String zbId = dataDom.getRootTable().getSafeRowColumnValue("PRJ_ID"); while (it.hasNext()) { String rowNo = (String) it.next(); Row row = (Row) ctb.getRows().get(rowNo); String rPk = row.getColumnValue("PRJL_NO"); if ((rPk != null) && (Integer.parseInt(rPk) > 0)) { prjlIds.remove(_$15996(rPk)); } } Iterator<?> it2 = ctb.getRows().keySet().iterator(); while (it2.hasNext()) { String rowNo = (String) it2.next(); Row row = (Row) ctb.getRows().get(rowNo); String prjId = row.getColumnValue("PRJL_ID"); if (prjlIds.contains(prjId)) { serviceRequest .getMessage() .addError("第" + (Integer.parseInt(rowNo) + 1) + "行的分包编号之前已经使用过,请重新输入!"); return false; } if ((!prjId.startsWith(zbId + "-")) && (!prjId.equals(zbId))) { serviceRequest .getMessage() .addError("第" + (Integer.parseInt(rowNo) + 1) + "行的分包编号格式错误,未包含招标编号,请重新输入!"); return false; } prjlIds.add(prjId); } } catch (Exception e) { e.printStackTrace(); Log.error(e); return false; } return true; }
public static String getLinCount(String params, HttpServletRequest request) { String flag = "0"; String pkValue = params; try { if ((pkValue != null) && (!"".equals(pkValue))) { Rowset rs = Database.getRowset("select count(1) num from YXPRJLIN where PRJ_NO = " + pkValue); if (rs.next()) { return rs.getString("num"); } } } catch (Exception ex) { Log.error(ex.getMessage()); ex.printStackTrace(); } return flag; }
public boolean deleteChildTable( DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest, Database db) throws LiemsException { try { String sql = "delete from " + dataDom.getChildTable().getName() + " where " + dataDom.getRootTable().getPkFieldName() + "=" + dataDom.getRootTable().getPkValue(); db.execSqlUpdate(sql); } catch (Exception e) { e.printStackTrace(); } return true; }
/** 扩展字段 创建下拉列表 Select aa = dataDom.getExtend().getSelect("字段"); */ public void creatSel(Select select, String strSQL, boolean canNull) { try { Rowset rs = Database.getRowset(strSQL); if (select != null) { for (int i = 0; i < select.getOptions().size(); i++) { select.removeOption(i); } } if (canNull) { select.addOption(new Option("", "")); } if (rs != null) while (rs.next()) select.addOption(new Option(rs.getString(1), rs.getString(2))); } catch (Exception e) { Log.error(e); } }
public String setVenLxr(String org_no, HttpServletRequest request) { String venNo = Charset.nullToEmpty(request.getParameter("venNo")); String returnValue = ""; String sql = "SELECT LXR_NAM FROM HLVDVENLIN WHERE VEN_NO=" + venNo; try { Rowset rs = Database.getRowset(sql); while (rs.next()) { String lixNam = Charset.nullToEmpty(rs.getString("LXR_NAM")); returnValue = returnValue + ",['" + lixNam + "','" + lixNam + "']"; } if ((returnValue.length() > 0) && (returnValue.charAt(0) == ',')) { returnValue = returnValue.substring(1); returnValue = "array=[" + returnValue + "]"; } } catch (Exception e) { e.printStackTrace(); } return returnValue; }
public void initEvalSelector(DataDom dataDom, String prjlNo, String prjNo) { String sql = ""; String PW_TYP = Database.getValue("select PW_TYP from YXHSPWMST where PRJ_NO=" + prjNo); if ("B".equals(PW_TYP)) { // 独立评委 独立评分 sql = "select EVAL_PERS_NAM,EVAL_PERS_NO from YXPJEVALPERSMST where EVAL_PERS_NO in(select EVAL_PERS_NO from YXHSPWLIN where PRJ_NO='" + prjNo + "' and PRJL_NO='" + prjlNo + "' and EVAL_TYP='T')"; } else if ("A".equals(PW_TYP)) { // 统一评委 独立评分 sql = "select EVAL_PERS_NAM,EVAL_PERS_NO from YXPJEVALPERSMST where EVAL_PERS_NO in(select EVAL_PERS_NO from YXHSPWLIN where PRJ_NO='" + prjNo + "' and PRJL_NO is null and EVAL_TYP='T')"; } creatSel(dataDom.getExtend().getSelect("evalSelector"), sql, false, false); }
public void reStartPrj(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) { String pkValue = dataDom.getRootTable().getPkValue(); if ((pkValue != null) && (!"".equals(pkValue))) { CommSequence cs = CommSequence.getInstance("YXPRJMST_SEQ"); CommCodeNumber KLTYPID = new CommCodeNumber("PRJ", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId()); String newPk = cs.getNextValue(); String prjNam = dataDom.getRootTable().getSafeRowColumnValue("PRJ_NAM"); String rSql = "declare v_wkpl YXPRJMST%rowtype; zbTime yxprjmst.ZB_TIMES%type; begin select * into v_wkpl from YXPRJMST where PRJ_NO =" + pkValue + ";" + " v_wkpl.OLD_PRJ := v_wkpl.PRJ_NO;" + " v_wkpl.PRJ_NO := " + newPk + ";" + " select nvl(max(ZB_TIMES),v_wkpl.ZB_TIMES) into zbTime from YXPRJMST where PRJ_NAM ='" + prjNam + "';" + " v_wkpl.ZB_TIMES := zbTime+1;" + " v_wkpl.VALID_STA := 'A';" + " v_wkpl.VEN_NO := null;" + " v_wkpl.ZB_ID := null;" + " v_wkpl.PRJ_STA := '00';" + " v_wkpl.PRJ_STAG := '01';" + " v_wkpl.PRJ_ID := '" + KLTYPID.getNextValue() + "';" + " v_wkpl.FSTUSR_DTM := sysdate;" + " v_wkpl.FSTUSR_ID := '" + sessionInfo.getUserId() + "';" + " insert into YXPRJMST values v_wkpl;" + "end;"; Database.execString(rSql); setForwardURL(Tools.getProgramURL(dataDom, "B1YXM00030", "jsp?pkValue=" + newPk)); } else { serviceRequest.getMessage().addError("请先维护主表!"); } }
private void initNoSplitTbrTab(DataDom dataDom, String prjNo, Database db) throws Exception { String sql = "select t.TBR_NAM,t.TBR_NO,d.PRJL_NO from YXTBRMST t join YXBJDFLIN d on t.TBR_NO=d.TBR_NO where d.PRJ_NO = " + prjNo; Rowset rs = db.getRS(sql); Table ct1 = dataDom.getTable("YXDBJYLIN"); Row row = new Row(false, 0, 0, "new"); row.addColumn("PRJ_NO", Charset.nullToEmpty(prjNo)); String unit = getMonUnit(prjNo); row.addColumn("IS_NTC", "N"); row.addColumn("IS_RCV", "N"); row.addColumn("MON_UNIT", unit); if (rs.next()) { row.addColumn("PRJL_NO", Charset.nullToEmpty(rs.getString("PRJL_NO"))); row.addColumn("TBR_NO", rs.getString("TBR_NO")); ct1.getRows().put("0", row); creatSel(ct1.getField("TBR_NO"), sql, false, false); } else { ct1.clearRow(); } }
/** * 招标代理费生成 * * @param dataDom * @param sessionInfo * @param serviceRequest * @throws LiemsException */ public void creatDLFEE(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws LiemsException { Database db = null; Table table = dataDom.getTable("YXDBJYMST"); Row currRow = table.getRow(0L); try { db = Tools.getDatabase(true); String DBJY_NO = currRow.getColumnValue("DBJY_NO"); String PRJ_NO = currRow.getColumnValue("PRJ_NO"); String ORG_NO = currRow.getColumnValue("ORG_NO"); Vector<String> vc = new Vector<String>(); String sel1 = "select distinct TBR_NO from YXDBJYLIN where DBJY_NO=" + DBJY_NO + " and IS_ZB='01'"; Rowset rs = db.getRS(sel1); while (rs.next()) { // 查询投标单位 生成主表 String TBR_NO = rs.getString("TBR_NO"); CommSequence cs = CommSequence.getInstance("YXDLFMST_SEQ"); String TBDJ_NO = cs.getNextValue(); CommCodeNumber seq = new CommCodeNumber( "DLF", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId(), db); String TBDJ_ID = seq.getNextValue(); String insertSQL = " insert into YXDLFMST(DLF_NO,ORG_NO,DLF_STA,DLF_ID,PRJ_NO,TBR_NO,FSTUSR_ID,FSTUSR_DTM) " + " values(" + TBDJ_NO + "," + ORG_NO + ",'00','" + TBDJ_ID + "'," + PRJ_NO + ",'" + TBR_NO + "','" + sessionInfo.getUserId() + "',sysdate) "; vc.add(insertSQL); // 查询标包 生成子表明细数据 String sel2 = "select YXDBJYLIN.PRJL_NO,YXPRJLIN.DLFL_AMT from YXDBJYLIN,YXPRJLIN " + " where YXDBJYLIN.PRJL_NO=YXPRJLIN.PRJL_NO and YXDBJYLIN.TBR_NO = " + TBR_NO + " and YXDBJYLIN.DBJY_NO=" + DBJY_NO + " and YXDBJYLIN.IS_ZB='01'"; Rowset rs2 = db.getRS(sel2); while (rs2.next()) { String PRJL_NO = rs2.getString("PRJL_NO"); CommSequence cs2 = CommSequence.getInstance("YXDBJYLIN_SEQ"); String TBDJL_NO = cs2.getNextValue(); String DLFL_AMT = rs2.getString("DLFL_AMT"); insertSQL = " insert into YXDBJYLIN(DLFL_NO,DLF_NO,TBR_NO,PRJ_NO,PRJL_NO,DLFL_AMT,IS_JF) " + " values(" + TBDJL_NO + "," + TBDJ_NO + "," + TBR_NO + "," + PRJ_NO + "," + PRJL_NO + "," + DLFL_AMT + ", 'N')"; vc.add(insertSQL); } } db.execSqlUpdateBatch(vc); db.commit(); serviceRequest.addServiceReturnParameter("relString", "true"); } catch (Exception e) { e.printStackTrace(); serviceRequest.addServiceReturnParameter("relString", e.toString()); } finally { if (db != null) { db.cleanup(); } } }
public void save(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) throws LiemsException { if (!saveBefore(dataDom, serviceRequest, sessionInfo)) { return; } Table table = dataDom.getTable("YXPRJMST"); Database db = null; Row currRow = table.getRow(0L); if (currRow == null) { table.addRow(new Row(false, 0, 0, "new")); currRow = table.getRow(0L); } currRow.setFirstLastUserInfo(sessionInfo.getUserId()); try { db = Tools.getDatabase(false); String isSplit = dataDom.getRootTable().getSafeRowColumnValue("IS_SPLIT"); if (currRow.getDataStatus().equals("new")) { currRow.addColumn("ORG_NO", sessionInfo.getDefaultOrg()); if ((currRow.getColumn("PRJ_ID") == null) || (currRow.getColumn("PRJ_ID").getValue() == null) || (currRow.getColumn("PRJ_ID").getValue().equals(""))) { String idTyp = currRow.getColumnValue("PRJ_EXT02"); if ("A".equals(idTyp)) { CommCodeNumber KLTYPID = new CommCodeNumber( "PRJ", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId()); currRow.addColumn(new Column("PRJ_ID", KLTYPID.getNextValue())); } CommCodeNumber ZB_ID = new CommCodeNumber("ZBBH", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId()); currRow.addColumn(new Column("ZB_ID", ZB_ID.getNextValue())); currRow.addColumn("VALID_STA", "A"); currRow.addColumn(new Column("ZB_TIMES", "1")); } if ("N".equals(isSplit)) { Row row = new Row(false, 0, 0, "new"); row.addColumn("PRJL_NAM", currRow.getColumnValue("PRJ_NAM")); row.addColumn("PRJL_ID", currRow.getColumnValue("PRJ_ID")); row.addColumn("BZ_AMT", "0.00"); row.addColumn("IS_FB", "Y"); dataDom.getChildTable().getRows().put("0", row); } } String dlfTyp = dataDom.getRootTable().getSafeRowColumnValue("DLF_TYP"); super.save(dataDom, sessionInfo, serviceRequest, db); db.commit(); String pkValue = currRow.getPkValue("PRJ_NO"); if (isSplit.equals("Y")) { String sql = ""; if (dlfTyp.equals("B")) { sql = "update YXPRJMST set ZBS_AMT = (select sum(ZBS_AMT) from YXPRJLIN where PRJ_NO=" + pkValue + ")," + "BZ_AMT = (select sum(BZ_AMT) from YXPRJLIN where PRJ_NO=" + pkValue + ")," + "DL_AMT=(select sum(DLFL_AMT) from YXPRJLIN where PRJ_NO=" + pkValue + ")" + " where PRJ_NO = " + pkValue; dataDom.getChildTable().getField("DLFL_AMT").setReadonly(false); } else { sql = "update YXPRJMST set ZBS_AMT = (select sum(ZBS_AMT) from YXPRJLIN where PRJ_NO=" + pkValue + ")," + "BZ_AMT = (select sum(BZ_AMT) from YXPRJLIN where PRJ_NO=" + pkValue + ")" + " where PRJ_NO = " + pkValue; dataDom.getChildTable().getField("DLFL_AMT").setReadonly(true); } Database.execString(sql); } serviceRequest.getMessage().addInfo("保存成功"); initSel(dataDom); dataDom.getChildTable().getWhereLimit().addColumn("PRJ_NO", pkValue); dataDom.refresh(sessionInfo); } catch (Exception e) { if (db != null) { db.rollback(); } Log.error(e); serviceRequest.getMessage().addInfo("保存失败,请重试或联系系统管理员!"); } finally { if (db != null) { db.cleanup(); } } }