예제 #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();
     }
   }
 }
예제 #2
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();
     }
   }
 }
예제 #3
0
 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;
 }
예제 #4
0
 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 "删除成功";
 }
예제 #5
0
 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;
 }
예제 #6
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);
 }
예제 #7
0
  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);
    }
  }
예제 #8
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();
     }
   }
 }