Exemplo n.º 1
0
  /**
   * 删除设计信息。
   *
   * @param funcId -- 功能ID
   * @param pageType -- 页面类型
   * @return
   */
  public String deleteDesign(String funcId, String pageType) {
    if (funcId == null || funcId.length() == 0) {
      setMessage(JsMessage.getValue("pagedesign.funidisnull"));
      return _returnFaild;
    }
    if (pageType == null || pageType.length() == 0) {
      setMessage(JsMessage.getValue("pagedesign.pagetypeisnull"));
      return _returnFaild;
    }

    String sql = "delete from fun_design where fun_id = ? and page_type = ? ";

    DaoParam param = _dao.createParam(sql);
    param.addStringValue(funcId);
    param.addStringValue(pageType);
    param.setDsName(DefineName.DESIGN_NAME);

    boolean ret = _dao.update(param);
    if (!ret) {
      setMessage(JsMessage.getValue("pagedesign.dserror"));
      return _returnFaild;
    }

    return _returnSuccess;
  }
Exemplo n.º 2
0
  /**
   * 是否有设计信息
   *
   * @param funcId
   * @param pageType
   * @return
   */
  private boolean hasDesign(String funcId, String pageType) {
    String sql = "select count(*) as cnt from fun_design where fun_id = ? and page_type = ?";
    DaoParam param = _dao.createParam(sql);
    param.setDsName(DefineName.DESIGN_NAME);
    param.addStringValue(funcId).addStringValue(pageType);
    Map<String, String> mpcnt = _dao.queryMap(param);

    return MapUtil.hasRecord(mpcnt);
  }
Exemplo n.º 3
0
  /**
   * 创建新的树型记录ID
   *
   * @param parentID
   * @param level
   * @param tableName
   * @param pkField
   * @param levelCol
   * @param dsName
   * @return
   */
  public synchronized String createTreeKey(
      String parentID,
      int level,
      String tableName,
      String pkField,
      String levelCol,
      String dsName) {
    if (parentID == null) parentID = "";

    StringBuilder selsql = new StringBuilder();
    StringBuilder wheresql = new StringBuilder();
    selsql.append(" select max(" + pkField + ") as maxval, count(" + pkField + ") as cnt ");
    wheresql.append(" from " + tableName);
    if (parentID.length() == 0) {
      wheresql.append(" where " + pkField + " like '%' ");
      wheresql.append(" and " + levelCol + " = " + level);
    } else {
      wheresql.append(" where " + pkField + " like '" + parentID + "%' ");
      wheresql.append(" and " + levelCol + " = " + level);
    }
    selsql.append(wheresql);

    _log.showDebug("treeid selectsql = " + selsql.toString());

    DaoParam param = _dao.createParam(selsql.toString());
    param.setDsName(dsName);
    Map<String, String> keyMap = _dao.queryMap(param);

    String maxVal = keyMap.get("maxval");
    if (maxVal.length() == 0) {
      if (parentID.length() == 0) {
        return "1001";
      } else {
        // 本级别第一个节点
        return parentID + "0001";
      }
    } else {
      if (maxVal.equals("9999")) {
        _log.showWarn("treeid exceed 9999!");
        return "9999";
      }
    }
    maxVal = "0000" + (Long.parseLong(maxVal) + 1);
    String treeID = parentID + maxVal.substring(maxVal.length() - 4, maxVal.length());

    return treeID;
  }
Exemplo n.º 4
0
  // 新增设计信息
  private boolean insertDesign(String funcId, String pageType, String content) {
    String sql = "insert into fun_design(design_id, fun_id, page_type) " + "values(?, ?, ?)";

    // 创建主键
    String keyId = KeyCreator.getInstance().createKey("fun_design");

    DaoParam param = _dao.createParam(sql);
    param.setDsName(DefineName.DESIGN_NAME);
    param.addStringValue(keyId).addStringValue(funcId).addStringValue(pageType);

    _dao.update(param);

    // 保存大字段信息
    String usql = "update fun_design set page_content = ? where design_id = '" + keyId + "'";

    return BigFieldUtil.updateStream(usql, content, DefineName.DESIGN_NAME);
  }