Example #1
0
 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();
     }
   }
 }
Example #2
0
  public void setAmtReadOnly(
      DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
    String sta = dataDom.getRootTable().getSafeRowColumnValue("PRJ_STA");

    if (!"00".equals(sta)) {
      dataDom.getChildTable().getField("PRJL_ID").setReadonly(true);
      dataDom.getChildTable().getField("PRJL_NAM").setReadonly(true);
      dataDom.getChildTable().getField("YSZL_AMT").setReadonly(true);
      dataDom.getChildTable().getField("ZBS_AMT").setReadonly(true);
      dataDom.getChildTable().getField("BZ_AMT").setReadonly(true);
      dataDom.getChildTable().getField("DLFL_AMT").setReadonly(true);
    }

    if ("02".equals(sta)) {
      dataDom.getChildTable().getField("YSZL_AMT").setReadonly(false);
      dataDom.getChildTable().getField("ZBS_AMT").setReadonly(false);
      dataDom.getChildTable().getField("BZ_AMT").setReadonly(false);
      dataDom.getChildTable().getField("DLFL_AMT").setReadonly(false);
    }

    String DLF_TYP = dataDom.getTable("YXPRJMST").getSafeRow().getColumnValue("DLF_TYP");
    Table table = dataDom.getTable("YXPRJLIN");
    if ("A".equals(DLF_TYP)) {
      table.getField("DLFL_AMT").setReadonly(true);
    } else if ("B".equals(DLF_TYP)) {
      table.getField("DLFL_AMT").setReadonly(false);
    }
  }
Example #3
0
  public void init(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
    try {
      super.init(dataDom, sessionInfo, serviceRequest);
      String pkValue = dataDom.getTable("YXPBPFMST").getPkValue();
      Table table = dataDom.getTable("YXSWPFLIN");
      WhereLimit lw = new WhereLimit();
      if ((pkValue == null) || (pkValue.equals(""))) {
        pkValue = "-1";
      }
      lw.addColumn("PBPF_NO", pkValue);
      // 子表业务类型,B 商务评分,T 技术评分 Z 总报价评分,P 报价质量评分
      lw.addColumn("PBYS_TYP", "T");

      String PRJL_TYP = dataDom.getRootTable().getSafeRowColumnValue("PRJL_TYP");
      if (PRJL_TYP.equals("A")) {
        // 综合评分
        dataDom.getExtend().getSelect("evalSelector").setReadonly(true);
      } else {
        // 独立评分
        dataDom.getExtend().getSelect("evalSelector").setReadonly(false);
        // 初始化评委
        String prjNo = dataDom.getTable("YXPBPFMST").getSafeRow().getColumnValue("PRJ_NO");
        String prjlNo = dataDom.getTable("YXPBPFMST").getSafeRow().getColumnValue("PRJL_NO");
        if (!"".equals(prjNo)) {
          initEvalSelector(dataDom, prjlNo, prjNo);
        }
      }
      table.setWhereLimit(lw);
      table.refresh("B1YXM00173", sessionInfo);
    } catch (Exception e) {
      Log.error(e);
    }
    setReadOnly(dataDom);
  }
Example #4
0
  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();
    }
  }
Example #5
0
 /**
  * 初始化处理 @Override
  *
  * @param dataDom DataDom
  * @param sessionInfo SessionInfo
  * @param serviceRequest ServiceRequest
  */
 public void init(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
   super.init(dataDom, sessionInfo, serviceRequest);
   DataRule.setOrg(dataDom, sessionInfo, serviceRequest, "FINCWGWMST", "", true);
   Table table = dataDom.getRootTable();
   table.setOrderBy("FSTUSR_DTM@desc");
   table.refresh(dataDom.getProgramInfo().getProgramNo(), sessionInfo);
 }
Example #6
0
 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();
     }
   }
 }
Example #7
0
 /**
  * 页面tab页签切换 @Override
  *
  * @param dataDom DataDom
  * @param sessionInfo SessionInfo
  * @param serviceRequest ServiceRequest 含有tabName参数
  * @throws LiemsException
  */
 public void TabOnClick(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
   Table table = dataDom.getTable("YXPBPFLIN");
   if (null != table) {
     Field orgNoField = table.getField("ORG_NO");
     if (null != orgNoField) {
       Row currRow = table.getRow(0);
       String orgNo = "";
       // 增加当前行的判断,仅当当前行不为null时候取DataDom里的orgNo
       if (null != currRow) {
         orgNo = Charset.nullToEmpty(currRow.getColumnValue("ORG_NO"));
       }
       if (!("".equals(orgNo))) {
         serviceRequest.addParameter("selectorgno", orgNo);
       } else {
         serviceRequest.addParameter("selectorgno", sessionInfo.getOrg()[0].getValue());
       }
       // 没有公司编号字段,则取session中第一个公司编号
     } else {
       serviceRequest.addParameter("selectorgno", sessionInfo.getOrg()[0].getValue());
     }
   } else {
     serviceRequest.addParameter("selectorgno", sessionInfo.getOrg()[0].getValue());
   }
   super.TabOnClick(dataDom, sessionInfo, serviceRequest);
 }
Example #8
0
 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);
 }
Example #9
0
 /**
  * 设置只读
  *
  * @param dataDom
  * @addTime 2014-2-26 下午05:05:46
  * @author Libo
  */
 private void setReadOnly(DataDom dataDom) {
   Table chileTable = dataDom.getTable("YXDBJYLIN");
   String sta =
       "SELECT DLF_STA FROM YXDLFMST WHERE PRJ_NO = '"
           + dataDom.getTable("YXDBJYMST").getSafeRowColumnValue("PRJ_NO")
           + "'";
   if ("00".equals(sta) || "01".equals(sta)) {
     chileTable.getField("DLF_SUM").setReadonly(true);
   }
 }
Example #10
0
 public void initSel(DataDom dataDom) {
   Table table = dataDom.getRootTable();
   Row row = table.getRow(0L);
   String venNo = row.getColumnValue("VEN_NO");
   if ((venNo != null) && (!venNo.equals(""))) {
     creatSel(
         table.getField("VEN_LXR"),
         "SELECT LXR_NAM ,LXR_NAM FROM HLVDVENLIN WHERE VEN_NO=" + venNo,
         false,
         false);
   }
 }
Example #11
0
 public void init(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
   super.init(dataDom, sessionInfo, serviceRequest);
   DataRule.setOrg(dataDom, sessionInfo, serviceRequest, "YXPRJMST", "", true);
   initWhereLimit(dataDom, sessionInfo, serviceRequest);
   initData(dataDom, sessionInfo, serviceRequest);
   initSel(dataDom);
   setAmtReadOnly(dataDom, sessionInfo, serviceRequest);
   Table table = dataDom.getTable("YXPRJMST");
   Orderby orderby1 = new Orderby("FSTUSR_DTM", "desc");
   table.clearOrderby();
   table.addOrderby(orderby1);
 }
Example #12
0
 public void rowSave(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest)
     throws Exception {
   Table table = dataDom.getTable("YXDBJYMST");
   String pkValue = table.getPkValue();
   if ((pkValue == null) || ("".equals(pkValue)) || ("-1".equals(pkValue)))
     serviceRequest.getMessage().addError("??????????????");
   else
     try {
       String tableName = serviceRequest.getParameter("tableName");
       super.save(tableName, dataDom, sessionInfo, serviceRequest);
     } catch (Exception e) {
       Log.error(e);
       serviceRequest.getMessage().addInfo("保存子表失败");
     }
 }
Example #13
0
 public void save(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest)
     throws LiemsException {
   Table table = dataDom.getTable("YXPBPFMST");
   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 {
     super.save(dataDom, sessionInfo, serviceRequest);
   } catch (Exception e) {
     Log.error(e);
     serviceRequest.getMessage().addInfo("保存失败,请重试或联系系统管理员!");
   }
 }
Example #14
0
 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;
 }
Example #15
0
 /**
  * 初始化评委
  *
  * @param dataDom
  * @addTime 2014-3-19 下午02:30:01
  * @author Libo
  */
 private void initEvalSel(DataDom dataDom) {
   Table table = dataDom.getTable("YXPBPFLIN");
   String PBPF_NO = table.getSafeRowColumnValue("PBPF_NO");
   String pfTyp = table.getSafeRowColumnValue("PF_TYP");
   String prjl_no = table.getSafeRowColumnValue("PRJL_NO");
   Select select = dataDom.getExtend().getSelect("evalSelector");
   select.getOptions().clear();
   if ("A".equals(pfTyp)) {
     select.addOption(new Option("无评委", "-1"));
   } else if ("B".equals(pfTyp)) {
     creatSel(
         select,
         "select EVAL_PERS_NAM,EVAL_PERS_NO from YXPJEVALPERSMST where EVAL_PERS_NO in(select EVAL_PERS_NO from YXHSPWLIN where PRJ_NO=(SELECT PRJ_NO FROM YXPBPFMST WHERE PBPF_NO = '"
             + PBPF_NO
             + "') and PRJL_NO='"
             + prjl_no
             + "' and EVAL_TYP='B')",
         false,
         false);
   }
 }
Example #16
0
  private void initSel(DataDom dataDom, SessionInfo sessionInfo) {
    Table table = dataDom.getChildTable();
    String prjNo = dataDom.getRootTable().getSafeRowColumnValue("PRJ_NO");
    if ((prjNo != null) && (!(prjNo.equals("")))) {
      creatSel(
          table.getField("PRJL_NO"),
          "SELECT PRJL_NAM ,PRJL_NO FROM YXPRJLIN where PRJ_NO=" + prjNo,
          true,
          false);

      String sql =
          " select tbr_nam,tbr_no from ( select distinct f.tbr_nam,f.tbr_no,g.tot_seq "
              + " from YXBJDFLIN p "
              + "  left join YXPFTLIN g on p.pfgl_no=g.pfgl_no and p.tbr_no=g.tbr_no "
              + "   left join YXTBRMST f on p.TBR_NO = f.TBR_NO "
              + "  where p.PRJ_NO ="
              + prjNo
              + " order by g.tot_seq asc) ";
      creatSel(dataDom.getTable("YXDBJYLIN").getField("TBR_NO"), sql, true, false);
    }
  }
Example #17
0
  public void TabOnClick(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
    Table table = dataDom.getTable("YXDBJYMST");
    if (table != null) {
      Field orgNoField = table.getField("ORG_NO");
      if (orgNoField != null) {
        Row currRow = table.getRow(0L);
        String orgNo = "";

        if (currRow != null) {
          orgNo = Charset.nullToEmpty(currRow.getColumnValue("ORG_NO"));
        }
        if (!("".equals(orgNo))) serviceRequest.addParameter("selectorgno", orgNo);
        else serviceRequest.addParameter("selectorgno", sessionInfo.getOrg()[0].getValue());
      } else {
        serviceRequest.addParameter("selectorgno", sessionInfo.getOrg()[0].getValue());
      }
    } else {
      serviceRequest.addParameter("selectorgno", sessionInfo.getOrg()[0].getValue());
    }
    super.TabOnClick(dataDom, sessionInfo, serviceRequest);
  }
Example #18
0
 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);
 }
Example #19
0
  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();
    }
  }
Example #20
0
 public void saveChildTable(
     Database db, DataDom dataDom, SessionInfo sessionInfo, String pkValue) {
   Table rtbl = dataDom.getRootTable();
   String parentPkNam = rtbl.pkFieldName;
   Table[] ctbls = dataDom.getChildTable(rtbl);
   try {
     for (Table ctbl : ctbls) {
       int len = ctbl.getRows().size();
       for (int i = 0; i < len; i++) {
         if (ctbl.getRow(i) != null) {
           if ("new".equals(ctbl.getRow(i).getDataStatus())) {
             setColumnValue(ctbl.getRow(i), parentPkNam, pkValue);
           }
         } else {
           len++;
         }
       }
       ctbl.save(db);
     }
   } catch (Exception e) {
     e.printStackTrace();
   }
 }
Example #21
0
 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();
     }
   }
 }
Example #22
0
 /**
  * 子表行记录保存 @Override
  *
  * @param dataDom DataDom
  * @param sessionInfo SessionInfo
  * @param serviceRequest ServiceRequest
  * @throws LiemsException
  */
 public void rowSave(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest)
     throws Exception {
   Table table = dataDom.getTable("YXPBPFLIN");
   String pkValue = table.getPkValue();
   if (null == pkValue || "".equals(pkValue) || "-1".equals(pkValue)) {
     serviceRequest.getMessage().addError("请先维护主信息!");
   } else {
     try {
       String tableName = serviceRequest.getParameter("tableName");
       Table childTable = dataDom.getTable(tableName);
       // 添加whereLimit的判断,这里目前不加任何过滤字段由研发人员自行添加
       if (null != childTable) {
         WhereLimit whereLimit = childTable.getWhereLimit();
         if (null == whereLimit) {
           whereLimit = new WhereLimit();
         }
         super.save(tableName, dataDom, sessionInfo, serviceRequest);
       }
     } catch (Exception e) {
       Log.error(e);
       serviceRequest.getMessage().addInfo("保存失败,请重试或联系系统管理员!");
     }
   }
 }
Example #23
0
 public void initData(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest) {
   Table table = dataDom.getRootTable();
   Row row = table.getRow(0L);
   if (row == null) {
     row = new Row(false, 0, 0, "new");
     table.addRow(row);
   }
   String pkValue = table.getPkValue();
   if ((pkValue == null) || ("".equals(pkValue)) || ("-1".equals(pkValue))) {
     String STA = table.getSafeRowColumnValue("DBJY_STA");
     if ("".equals(STA)) {
       table.getSafeRow().addColumn("DBJY_EXT01", sessionInfo.getUserId());
       table.setSafeRowColumnValue("DBJY_STA", "00");
     }
   }
 }
Example #24
0
  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();
      }
    }
  }
Example #25
0
  /**
   * 招标代理费生成
   *
   * @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();
      }
    }
  }
Example #26
0
  public void save(DataDom dataDom, SessionInfo sessionInfo, ServiceRequest serviceRequest)
      throws LiemsException {
    Table table = dataDom.getTable("YXDBJYMST");
    Table cTable = dataDom.getTable("YXDBJYLIN");
    Row currRow = table.getRow(0L);
    if (currRow == null) {
      table.addRow(new Row(false, 0, 0, "new"));
      currRow = table.getRow(0L);
    }

    currRow.setFirstLastUserInfo(sessionInfo.getUserId());
    String prjNo = currRow.getColumnValue("PRJ_NO");
    Database db = null;
    try {
      db = Tools.getDatabase(false);
      if (currRow.getDataStatus().equals("new")) {
        currRow.addColumn("ORG_NO", sessionInfo.getDefaultOrg());
        if ((currRow.getColumn("DBJY_ID") == null)
            || (currRow.getColumn("DBJY_ID").getValue() == null)
            || (currRow.getColumn("DBJY_ID").getValue().equals(""))) {
          CommCodeNumber KLTYPID =
              new CommCodeNumber("DBJY", sessionInfo.getCurrentLanguage(), sessionInfo.getUserId());
          currRow.addColumn(new Column("DBJY_ID", KLTYPID.getNextValue()));
        }
      } else if ((currRow.getDataStatus().equals("modified"))
          && (CheckDate.isPrjNoChange(dataDom, db))) {
        deleteChildTable(dataDom, sessionInfo, serviceRequest, db);
      }
      String isSplit = Database.getValue(db, "select IS_SPLIT from YXPRJMST where PRJ_NO=" + prjNo);
      if ((prjNo != null) && (!(prjNo.equals(""))) && (Integer.parseInt(prjNo) > 0)) {
        if ((isSplit.equals("Y"))
            && (CheckDate.isTableEmpty(
                "YXDBJYLIN", dataDom, db, "PRJ_NO=" + prjNo, currRow.getPkValue("DBJY_NO"))))
          initTBRTable(dataDom, prjNo, db);
        else if ((isSplit.equals("N"))
            && (CheckDate.isTableEmpty(
                "YXDBJYLIN", dataDom, db, "PRJ_NO=" + prjNo, currRow.getPkValue("DBJY_NO")))) {
          initNoSplitTbrTab(dataDom, prjNo, db);
        }
      }
      super.save(dataDom, sessionInfo, serviceRequest, db);
      String pkValue = dataDom.getRootTable().getPkValue();
      //
      String selString =
          "select PRJL_NO,dlf_sum from YXDBJYLIN where DBJY_NO="
              + pkValue
              + " and dlf_sum is not null";
      Rowset rs = db.getRS(selString);
      Vector<String> vc = new Vector<String>();
      while (rs.next()) {
        String PRJL_NO = rs.getString("PRJL_NO");
        String dlf_sum = Charset.nullToEmpty(rs.getString("dlf_sum"));
        if (!"".equals(dlf_sum)) {
          String upPrjInfoString =
              "update yxprjlin set DLFL_AMT="
                  + dlf_sum
                  + " where PRJ_NO="
                  + prjNo
                  + " and prjl_no="
                  + PRJL_NO;
          vc.add(upPrjInfoString);
        }
      }
      if (vc.size() > 0) {
        db.execSqlUpdateBatch(vc);
      }
      db.commit();
    } catch (Exception e) {
      db.rollback();
      table.refresh("B1YXM00200", sessionInfo);
      Log.error(e);
      serviceRequest.getMessage().addInfo("保存失败");
    } finally {
      if (db != null) {
        db.cleanup();
      }
    }
    initSel(dataDom, sessionInfo);
    dataDom.getChildTable().refresh("B1YXM00200", sessionInfo);
  }
Example #27
0
 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();
     }
   }
 }