/**
* 대상자그룹등록
*
* @param targetList
* @return
* @throws DataAccessException
*/
public int insertTargetList(TargetList targetList) throws DataAccessException {
String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.insert");
Map<String, Object> param = new HashMap<String, Object>();
param.put("targetName", targetList.getTargetName());
param.put("description", targetList.getDescription());
param.put("userID", targetList.getUserID());
param.put("bookMark", targetList.getBookMark());
param.put("shareType", targetList.getShareType());
param.put("shareID", targetList.getShareID());
param.put("targetType", targetList.getTargetType());
param.put("upload_key", targetList.getUploadKey());
param.put("dbID", targetList.getDbID());
param.put("queryText", targetList.getQueryText());
param.put("countQuery", targetList.getCountQuery());
param.put("targetCount", targetList.getTargetCount());
param.put("directText", targetList.getDirectText());
param.put("state", targetList.getState());
param.put("sendedDate", targetList.getSendedDate());
param.put("successYN", targetList.getSuccessYN());
param.put("openYN", targetList.getOpenYN());
param.put("clickYN", targetList.getClickYN());
param.put("rejectcallYN", targetList.getRejectcallYN());
param.put("connectedDbID", targetList.getConnectedDbID());
param.put("massmailGroupID", targetList.getMassmailGroupID());
param.put("targetGroupID", targetList.getTargetGroupID());
param.put("targetUIID", targetList.getTargetUIID());
return getSimpleJdbcTemplate().update(sql, param);
}
public int updateTargetList(TargetList targetList) throws DataAccessException {
String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.update");
Map<String, Object> param = new HashMap<String, Object>();
param.put("targetID", targetList.getTargetID());
param.put("targetName", targetList.getTargetName());
param.put("description", targetList.getDescription());
param.put("shareType", targetList.getShareType());
param.put("shareID", targetList.getShareID());
param.put("targetType", targetList.getTargetType());
param.put("dbID", targetList.getDbID());
param.put("queryText", targetList.getQueryText());
param.put("countQuery", targetList.getCountQuery());
param.put("targetCount", targetList.getTargetCount());
param.put("targetGroupID", targetList.getTargetGroupID());
return getSimpleJdbcTemplate().update(sql, param);
}