package com.sp2p.service.admin;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.shove.base.BaseService;
import com.shove.data.DataException;
import com.shove.data.dao.Database;
import com.shove.data.dao.MySQL;
import com.shove.vo.PageBean;
import com.sp2p.dao.admin.ShoveApproveNoticeTemplateDao;
/**
* 提醒记录 service
* @author C_J
*
*/
public class ShoveApproveNoticeTemplateService extends BaseService {
private static Log log = LogFactory.getLog(ShoveApproveNoticeTemplateService.class);
private ShoveApproveNoticeTemplateDao shoveApproveNoticeTemplateDao ;
/**
* 增加记录
* @param conn
* @param notice_id
* @param name
* @param template
* @param nid
* @return
* @throws SQLException
*/
public Long addApproveNoticeTemplate(int notice_id ,String name,String template,String nid ) throws SQLException{
Connection conn = MySQL.getConnection();
long result = -1L;
try {
result = shoveApproveNoticeTemplateDao.addApproveNoticeTemplate(conn, notice_id, name, template, nid);
conn.commit();
} catch (SQLException e) {
log.error(e);
conn.rollback();
e.printStackTrace();
throw e;
}finally{
conn.close();
}
return result;
}
/**
* 修改
* @param conn
* @param id
* @param notice_id
* @param name
* @param template 模板
* @param nid
* @return
* @throws SQLException
*/
public Long updateApproveNoticeTemplate(int id,int notice_id ,String name,String template,int sort ) throws SQLException {
Connection conn = MySQL.getConnection();
long result = -1L;
try {
result = shoveApproveNoticeTemplateDao.updateApproveNoticeTemplate(conn, id, notice_id, name, template,sort);
conn.commit();
} catch (SQLException e) {
log.error(e);
conn.rollback();
e.printStackTrace();
throw e;
}finally{
conn.close();
}
return result;
}
/**
* 删除
* @param conn
* @param id
* @return
* @throws SQLException
* @throws SQLException
*/
public Long deleteApproveNoticeTemplate(int id) throws SQLException{
Connection conn = MySQL.getConnection();
long result = -1L;
try {
result = shoveApproveNoticeTemplateDao.deleteApproveNoticeTemplate(conn, id);
conn.commit();
} catch (SQLException e) {
log.error(e);
conn.rollback();
e.printStackTrace();
throw e;
}finally{
conn.close();
}
return result;
}
/**
* 分页查询
* @param conn
* @param pageBean
* @throws DataException
* @throws SQLException
* @throws DataException
* @throws SQLException
*/
public void queryApproveTemplatePageAll(PageBean<Map<String,Object>> pageBean) throws DataException, SQLException {
Connection conn = MySQL.getConnection();
try {
shoveApproveNoticeTemplateDao.queryApproveTemplatePageAll(conn, pageBean);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
} catch (DataException e) {
log.error(e);
e.printStackTrace();
throw e;
}finally{
conn.close();
}
}
/**
* 根据ID 查询
* @param conn
* @param id
* @return
* @throws SQLException
* @throws DataException
* @throws SQLException
* @throws DataException
*/
public Map<String,String> queryApproveTemplateById(int id) throws SQLException, DataException{
Connection conn= MySQL.getConnection();
Map<String,String> map= null;
try {
map = shoveApproveNoticeTemplateDao.queryApproveTemplateById(conn, id);
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
} catch (DataException e) {
log.error(e);
e.printStackTrace();
throw e;
}finally{
conn.close();
}
return map;
}
/**'
* 根据类型查询所有提醒类型
* @param pageBean
* @param notice_id
* @throws SQLException
* @throws DataException
*/
public void queryOrderRechargeRecords(PageBean<Map<String,Object>> pageBean,int notice_style,int id,int sid) throws SQLException, DataException{
StringBuffer table = new StringBuffer();
table.append(" t_approve_notice_template as t inner join t_approve_notice_style as s ");
table.append(" on t.notice_id = s.id ");
StringBuffer filed = new StringBuffer();
filed.append(" and s.notice_style = " + notice_style);
if(sid == 0){
filed.append(" and s.id = "+id);
}
else{
filed.append(" and t.id = "+id);
}
Connection conn = MySQL.getConnection();
try {
dataPage(conn, pageBean, table.toString(), " t.id,t.name,t.template,t.nid,t.sort,s.title,t.notice_id ,s.notice_style ,s.id as sid ", " order by t.sort asc ", filed.toString() );
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
} catch (DataException e) {
log.error(e);
e.printStackTrace();
throw e;
}finally{
conn.close();
}
}
public List<Map<String, Object>> queryAllInformTemplate() throws SQLException, DataException{
List<Map<String, Object>> list = null;
Connection conn = Database.getConnection();
try{
list =shoveApproveNoticeTemplateDao.queryAllInformTemplate(conn);
conn.commit();
}finally{
conn.close();
}
return list;
}
public void setShoveApproveNoticeTemplateDao(
ShoveApproveNoticeTemplateDao shoveApproveNoticeTemplateDao) {
this.shoveApproveNoticeTemplateDao = shoveApproveNoticeTemplateDao;
}
public ShoveApproveNoticeTemplateDao getShoveApproveNoticeTemplateDao() {
return shoveApproveNoticeTemplateDao;
}
}