public List<TActivityAwardteamAwardlistOrganEntity> queryAwardListOrgan(String AwardListId) {
   IPersistenceService dao = SwordPersistenceUtils.getPersistenceService();
   String sql =
       "select * from t_activity_awardteam_awardlist_organ t where t.activity_awardlist_id=? and t.invalid='N'";
   List<String> sqlParam = new ArrayList<String>();
   sqlParam.add(AwardListId);
   List<TActivityAwardteamAwardlistOrganEntity> actAwardListOrgan =
       dao.findAllBySql(TActivityAwardteamAwardlistOrganEntity.class, sql, sqlParam);
   return actAwardListOrgan;
 }
Exemple #2
0
  public List<TYearThOpusEntity> query(String yearThId) {
    IPersistenceService dao = SwordPersistenceUtils.getPersistenceService();
    String sql = "select * from t_year_th_opus t where t.year_th_id=? and t.invalid='N'";
    List<String> param = new ArrayList<String>();
    param.add(yearThId);
    List<TYearThOpusEntity> opus = dao.findAllBySql(TYearThOpusEntity.class, sql, param);

    for (TYearThOpusEntity entity : opus) {
      String id = entity.getYearThOpusId();
      String sql1 = "select * from t_year_th_opus_grouping t where t.year_th_opus_id=?";
      List<String> param1 = new ArrayList<String>();
      param1.add(id);
      List<TYearThOpusGroupingEntity> groups =
          dao.findAllBySql(TYearThOpusGroupingEntity.class, sql1, param1);
      entity.setOpusTypes(groups);
      entity.setOpusName("opusName");
    }

    return opus;
  }
Exemple #3
0
  public void save(List<TYearThOpusEntity> opusList, String sessionId)
      throws SwordBaseCheckedException {
    IPersistenceService dao = SwordPersistenceUtils.getPersistenceService();
    // 查询已存在作品信息
    String yearThOpusIds = "";
    String sql = "select * from t_year_th_opus t where t.year_th_id=? and t.invalid='N'";
    List<String> param = new ArrayList<String>();
    param.add(sessionId);
    List<TYearThOpusEntity> opusOldList = dao.findAllBySql(TYearThOpusEntity.class, sql, param);

    // 保存作品信息
    for (TYearThOpusEntity opus : opusList) {
      opus.setYearThId(sessionId);
      if (StringHelper.isEmpty(opus.getYearThOpusId())) {
        opus.setYearThOpusId(UUIDUtil.generateUUID());
      } else {
        yearThOpusIds += (opus.getYearThOpusId() + " ");
      }
      dao.saveOrUpdate(opus);

      // 查询已存在的作品分类
      String yearThOpusId = opus.getYearThOpusId();
      String groupIds = "";
      String sql1 = "select * from t_year_th_opus_grouping t where t.year_th_opus_id=?";
      List<String> param1 = new ArrayList<String>();
      param1.add(yearThOpusId);
      List<TYearThOpusGroupingEntity> groupList =
          dao.findAllBySql(TYearThOpusGroupingEntity.class, sql1, param1);

      // 保存分类
      List<TYearThOpusGroupingEntity> groups = opus.getOpusTypes();
      for (TYearThOpusGroupingEntity group : groups) {
        group.setYearThOpusId(yearThOpusId);
        if (StringHelper.isEmpty(group.getGroupingId())) {
          group.setGroupingId(UUIDUtil.generateUUID());
        } else {
          groupIds += (group.getGroupingId() + " ");
        }
        dao.saveOrUpdate(group);
      }
      // 删除分类
      for (TYearThOpusGroupingEntity entity : groupList) {
        if (groupIds.indexOf(entity.getGroupingId()) < 0) {
          dao.delete(entity);
        }
      }
    }

    // 删除作品信息
    for (TYearThOpusEntity opusEntity : opusOldList) {
      if (yearThOpusIds.indexOf(opusEntity.getYearThOpusId()) < 0) {
        String sql2 = "select * from t_year_th_opus_grouping t where t.year_th_opus_id=?";
        List<String> param2 = new ArrayList<String>();
        param2.add(opusEntity.getYearThOpusId());
        List<TYearThOpusGroupingEntity> delGroups =
            dao.findAllBySql(TYearThOpusGroupingEntity.class, sql2, param2);
        dao.delete(opusEntity);
        dao.deleteBatch(delGroups);
      }
    }
  }