Beispiel #1
0
  /**
   * 新增專案
   *
   * @return boolean
   * @throws Exception
   */
  public boolean insertNewProjectAndAttribut(ProjectVo vo, List<Projects_attributeJsonVo> avo)
      throws Exception {
    SqlSession session = null;
    boolean status = false;
    int cnt = 0;
    int cntAvo = 0;
    String json = "";
    try {
      logger.debug("insertNewProjectAndAttribut entry ======");

      session = getSession(false);
      // insert a new major project
      cnt = session.insert("project.insertProject", vo);

      // setting the project id to attributes
      for (Projects_attributeJsonVo d : avo) {
        d.setPid(vo.getId());
      }

      // transfer the attributes to its JsonVo
      ProjectJsonVo pvo = new ProjectJsonVo();
      pvo.setMajorPrjAttributes(avo);

      // to Json
      Gson gson = new Gson();
      json = gson.toJson(pvo);

      DB_jsonMappingVo dbMapVo = new DB_jsonMappingVo();
      dbMapVo.setId(vo.getId());
      dbMapVo.setJson(json);
      cnt = session.update("project.updateProjectAttribute", dbMapVo);

      if (cnt > 0) {
        status = true;
      }
      session.commit();
    } catch (Exception e) {
      e.printStackTrace();
      logger.error(e.getMessage());
      session.rollback();
      throw e;
    } finally {
      closeCoonnection(session);
    }

    return status;
  }
Beispiel #2
0
 /**
  * 啟用專案
  *
  * @return boolean 成功或失敗
  */
 public boolean enable(ProjectVo vo) {
   SqlSession session = null;
   boolean status = false;
   try {
     session = getSession(false);
     vo.setStatus(STAUS_ENABLE);
     int cnt = session.update("project.updateStatus", vo);
     // logger.debug("cnt:" + cnt);
     session.commit();
     if (cnt > 0) {
       status = true;
     }
   } catch (Exception e) {
     e.printStackTrace();
     logger.error(e.getMessage());
     session.rollback();
   } finally {
     closeCoonnection(session);
   }
   return status;
 }