package com.sp2p.dao.admin;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Map;
import org.apache.commons.lang.StringUtils;
import com.shove.data.DataException;
import com.shove.data.DataSet;
import com.shove.util.BeanMapUtils;
import com.sp2p.database.Dao;
/**
* 用户举报管理
*
* @author Administrator
*
*/
public class ReportDao {
/**
* 删除举报信息
*
* @param conn
* @param id
* @return
* @throws SQLException
* @throws DataException
*/
public Long deleteReport(Connection conn, Long id) throws SQLException,
DataException {
Dao.Tables.t_report report=new Dao().new Tables().new t_report();
return report.delete(conn, "id="+id);
}
/**
* 更新举报信息
*
* @param conn
* @param id
* @param sort
* @param title
* @param content
* @param publishTime
* @param publisher
* @param visits
* @return
* @throws SQLException
* @throws DataException
*/
public Long updateReport(Connection conn, Long id, String remark,
Integer status) throws SQLException, DataException {
Dao.Tables.t_report report=new Dao().new Tables().new t_report();
if (status!=null) {
report.status.setValue(status);
}
if (StringUtils.isNotBlank(remark)) {
report.remark.setValue(remark);
}
return report.update(conn, "id=" + id);
}
/**
* 获取举报详情
* @param conn
* @param id
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> getReportById(Connection conn, Long id)
throws SQLException, DataException {
Dao.Tables.t_report report=new Dao().new Tables().new t_report();
DataSet dataSet = report.open(conn, "*", " id=" + id,
"", -1, -1);
return BeanMapUtils.dataSetToMap(dataSet);
}
}