Example #1
0
 public Long updateMa1(Connection conn, Long tmid, int status, String content, Integer sro)
     throws SQLException {
   Dao.Tables.t_materialsauth tm = new Dao().new Tables().new t_materialsauth();
   tm.auditStatus.setValue(status);
   tm.authTime.setValue(new Date());
   tm.option.setValue(content);
   tm.criditing.setValue(sro);
   return tm.update(conn, " id = " + tmid);
 }
Example #2
0
 public Long addCheckRecord(
     Connection conn, Integer creditrating, Long adminId, Long userId, Integer mterType)
     throws SQLException {
   Long result = -1L;
   Dao.Tables.t_user_check check = new Dao().new Tables().new t_user_check(); // 审核员的审核记录更新
   DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
   String date = format.format(new Date()); //
   check.checkdate.setValue(date); // 设置审核时间
   // 查询t_materialsauth表中信用积分
   Map<String, String> map = null;
   int precreditrating = -1;
   Dao.Tables.t_materialsauth materialsauth = new Dao().new Tables().new t_materialsauth();
   try {
     DataSet ds =
         materialsauth.open(
             conn,
             "criditing",
             " userId =" + userId + " AND materAuthTypeId = " + mterType,
             "",
             -1,
             -1);
     map = BeanMapUtils.dataSetToMap(ds);
   } catch (DataException e) {
     e.printStackTrace();
   }
   if (map.size() > 0 && map != null) {
     precreditrating = Convert.strToInt(map.get("criditing"), -1);
   }
   if (precreditrating != -1) {
     check.perrecode.setValue(precreditrating); // 设置原来的信用分数
     check.afterrecode.setValue(precreditrating + creditrating);
     check.adminId.setValue(adminId); // 设置审核者的id
     check.userId.setValue(userId);
     check.materialType.setValue(mterType); // 插入用户审核的类型
     return check.insert(conn); // 插入审核员的id
   }
   return result;
 }
Example #3
0
 /**
  * 更新视频认证的审核状态
  *
  * @param conn
  * @param tmid 证件主表id
  * @param status 审核状态
  * @return
  * @throws SQLException
  */
 public Long updateMa(Connection conn, Long tmid, int status) throws SQLException {
   Dao.Tables.t_materialsauth tm = new Dao().new Tables().new t_materialsauth();
   tm.auditStatus.setValue(status);
   return tm.update(conn, " id = " + tmid);
 }
Example #4
0
  /**
   * 添加信用总分
   *
   * @param conn
   * @param userId
   * @param alloption
   * @param creditrating
   * @param adminId
   * @param mterType
   * @return
   * @throws SQLException
   * @throws Exception
   */
  public Long Updatecreditrating(
      Connection conn,
      Long userId,
      String alloption,
      Integer creditrating,
      Integer mterType,
      int status)
      throws SQLException, Exception {

    Long resut1 = -1L;
    Long resut2 = -1L;

    Dao.Tables.t_user user = new Dao().new Tables().new t_user();
    Dao.Tables.t_materialsauth materialsauth = new Dao().new Tables().new t_materialsauth();
    DataSet ds = user.open(conn, "creditrating", " id = " + userId, "", -1, -1);
    DataSet mads =
        materialsauth.open(
            conn,
            "auditStatus",
            " userId = " + userId + " AND materAuthTypeId = " + mterType,
            "",
            0,
            -1);

    Integer precreditrating = -1; // 原来的信用积分
    Integer auditStatus = -1;
    boolean flag = false;
    Map<String, String> map = new HashMap<String, String>();
    Map<String, String> nmap = new HashMap<String, String>();
    map = BeanMapUtils.dataSetToMap(ds);
    nmap = BeanMapUtils.dataSetToMap(mads);
    if (map != null && map.size() > 0 && nmap.size() > 0 && nmap != null) {
      precreditrating = Convert.strToInt(map.get("creditrating"), -1);
      auditStatus = Convert.strToInt(nmap.get("auditStatus"), -1);
    } else {
      return -1L;
    }

    if (StringUtils.isNotBlank(alloption) && mterType != null && alloption != null) { // 向证件类型主表更新数据

      // 设置失效时间
      DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      String authTime = format.format(new Date());
      Calendar cal = Calendar.getInstance();
      cal.setTime(format.parse(authTime));
      cal.add(Calendar.DATE, 30);
      String passDate = null;
      passDate = format.format(cal.getTime());
      if (passDate != null && auditStatus == 2 && auditStatus != -1) {
        materialsauth.pastTime.setValue(passDate);
      }
      // =====
      materialsauth.criditing.setValue(creditrating);
      materialsauth.option.setValue(alloption);
      materialsauth.auditStatus.setValue(status);
      resut1 =
          materialsauth.update(conn, " userId = " + userId + " AND materAuthTypeId = " + mterType);
      if (resut1 > 0) {
        flag = true;
      } else {
        flag = false;
      }
    }
    if (creditrating != null && creditrating != -1 && precreditrating != -1) {
      user.creditrating.setValue(creditrating + precreditrating); // 当前的信用积分加上后台添加的信用分数
      resut2 = user.update(conn, " id = " + userId); // 更新信用分
      if (resut2 > 0) {
        flag = true;
      } else {
        flag = false;
      }
    }
    map = null;
    nmap = null;
    ds = null;
    mads = null;
    if (flag) {
      return 1L;
    } else {
      return -1L;
    }
  }