public void queryRechargebanklist(PageBean<Map<String, Object>> pageBean) throws Exception {
StringBuffer condition = new StringBuffer();
/*
* if (StringUtils.isNotBlank(username)) {
* condition.append(" AND uername LIKE CONCAT('%','" +
* StringEscapeUtils.escapeSql(username.trim()) + "','%')"); } if
* (StringUtils.isNotBlank(starttime)) {
* condition.append(" and applyTime >= '" +
* StringEscapeUtils.escapeSql(starttime.trim()) + "'"); } if
* (StringUtils.isNotBlank(endTime)) {
* condition.append(" and applyTime <= '" +
* StringEscapeUtils.escapeSql(endTime.trim()) + "'"); } if (autiStatus
* != null && autiStatus != -1) { condition.append(" AND applystatus = "
* + autiStatus); }
*/
Connection conn = MySQL.getConnection();
try {
dataPage(conn, pageBean, "t_rechargebank", "*", "", condition.toString());
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
}
public long updaterechargeBankById(
long id,
String bankname,
String Account,
String accountbank,
String bankimage,
String accountname)
throws Exception {
long result = -1;
Connection conn = MySQL.getConnection();
try {
result =
rechargebankDao.updaterechargeBankById(
conn, id, bankname, Account, accountbank, bankimage, accountname);
conn.commit();
} catch (Exception e) {
log.error(e);
e.printStackTrace();
conn.rollback();
throw e;
} finally {
conn.close();
}
return result;
}
/**
* 增加支付方式
*
* @param conn
* @param name
* @param nid
* @param status
* @param litpic
* @param style
* @param config
* @param description
* @param order
* @return
* @throws SQLException
* @throws SQLException
*/
public long addAccountPayment(
String name,
String nid,
long status,
String litpic,
int style,
String config,
String description,
int order)
throws Exception {
Connection conn = MySQL.getConnection();
long result = -1L;
try {
result =
accountPaymentDao.addAccountPayment(
conn, name, nid, status, litpic, style, config, description, order);
conn.commit();
} catch (Exception e) {
log.error(e);
e.printStackTrace();
conn.rollback();
throw e;
} finally {
conn.close();
}
return result;
}
/**
* 查询证件主表的审核状态
*
* @param conn
* @param tmid
* @param status
* @param content
* @param sro
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> querydateMa1(Connection conn, Long tmid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(
" select tm.auditStatus as auditStatus from t_materialsauth tm where tm.id = " + tmid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 查询用户名称
*
* @param conn
* @param tmdid
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> queryuser(Connection conn, Long id)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tuser.username as username ");
sql.append(" from t_user tuser ");
sql.append(" where tuser.id = " + id);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/** 查询materaldetal的id */
public Map<String, String> querytmid(Connection conn, Long typeid, Long userId)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tm.id as id ");
sql.append(" from t_materialsauth tm ");
sql.append(" where tm.userId = " + userId);
sql.append(" and tm.materAuthTypeId = " + typeid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 查询充值详细表by id
*
* @return
* @throws DataException
* @throws SQLException
*/
public Map<String, String> queryupdateRechargeDetailById(Connection conn, long id)
throws SQLException, DataException {
DataSet dataSet =
MySQL.executeQuery(
conn,
" select a.award as award,a.userId as userId,a.id as id,a.rechargeMoney as rechargeMoney,a.result as result,a.rechargeNumber as rechargeNumber,a.rechargeTime as rechargeTime,"
+ " a.rechargeType as rechargeType,a.remark as remark,b.username as username, c.cellPhone as mobilePhone,c.realName as realName,c.idNo as idNo"
+ " from t_recharge_detail a left join t_user b on a.userId = b.id left join t_person c on a.userId = c.userId where a.id = "
+ id
+ " and a.rechargeType = 4 ");
return DataSetHelper.dataSetToMap(dataSet);
}
/**
* 分页查询所有
*
* @param conn
* @param pageBean
* @throws DataException
* @throws Exception
*/
public void queryAccountPaymentPage(PageBean<Map<String, Object>> pageBean) throws Exception {
Connection conn = MySQL.getConnection();
try {
accountPaymentDao.queryAccountPaymentPage(conn, pageBean);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
}
/**
* 查询图片信息和审核情况
*
* @param conn
* @param tmdid
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> queryonemsg(Connection conn, Long tmdid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tmd.`option` as tmdoption, ");
sql.append(" tmd.auditStatus as auditStatus, ");
sql.append(" tmd.imagePath as imagePath,");
sql.append(" tmd.visiable as visiable ");
sql.append(" from t_materialimagedetal tmd where tmd.id = " + tmdid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 资料认证统计图片类表
*
* @param conn
* @param typeid
* @param userId
* @return
* @throws SQLException
* @throws DataException
*/
public List<Map<String, Object>> queryCountPictureList(Connection conn, Long tmid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tmd.id as tmdid, ");
sql.append(" tmd.imagePath as imagePath ");
sql.append(" from t_materialimagedetal tmd ");
sql.append(" WHERE tmd.materialsauthid = " + tmid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
dataSet.tables.get(0).rows.genRowsMap();
sql = null;
return dataSet.tables.get(0).rows.rowsMap;
}
/**
* 查询视频资料审核明细表中
*
* @param tmid 资料主表id
* @return
* @throws DataException
* @throws SQLException
*/
public Map<String, String> queryMade(Connection conn, Long tmid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tmd.id as tmdid ");
sql.append(" from ");
sql.append(" t_materialimagedetal tmd ");
sql.append(" where tmd.materialsauthid = " + tmid);
sql.append(" LIMIT 0 , 1 ");
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
dataSet.tables.get(0).rows.genRowsMap();
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 查询所有支付信息
*
* @return
* @throws Exception
* @throws DataException
*/
public List<Map<String, Object>> queryAccountPaymentList() throws Exception {
Connection conn = MySQL.getConnection();
List<Map<String, Object>> mapList = new ArrayList<Map<String, Object>>();
try {
mapList = accountPaymentDao.queryAccountPaymentList(conn);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return mapList;
}
/**
* 根据ID 查询
*
* @param conn
* @param id
* @return
* @throws DataException
* @throws Exception
*/
public Map<String, String> queryAccountPaymentById(String nid) throws Exception {
Connection conn = MySQL.getConnection();
Map<String, String> map = null;
try {
map = accountPaymentDao.queryAccountPaymentById(conn, nid);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return map;
}
public List<Map<String, Object>> queryrechargeBanklist() throws Exception {
Connection conn = MySQL.getConnection();
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
try {
list = rechargebankDao.queryrechargeBanklist(conn);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return list;
}
public Map<String, String> queryrechargeBank() throws Exception {
Map<String, String> map = new HashMap<String, String>();
Connection conn = MySQL.getConnection();
try {
map = rechargebankDao.queryrechargeBank(conn);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return map;
}
public Map<String, String> queryFundRecordTypeAmount(
long userId, String startTime, String endTime, Map<String, String> typeMap) throws Exception {
Map<String, String> map = new HashMap<String, String>();
Connection conn = MySQL.getConnection();
try {
map = rechargebankDao.queryFundRecordTypeAmount(conn, userId, startTime, endTime, typeMap);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return map;
}
public List<Map<String, Object>> getRegistCode() throws Exception {
Connection conn = MySQL.getConnection();
List<Map<String, Object>> map = new ArrayList<Map<String, Object>>();
try {
map = getSEOConfigOnUpDao.queryRegistCode(conn);
} catch (Exception e) {
log.error(e);
e.printStackTrace();
throw e;
} finally {
conn.close();
}
return map;
}
/** 当项目加载时候读取数据库 */
public Map<String, String> getSEOConfig() throws Exception {
Map<String, String> map = null;
Connection conn = MySQL.getConnection();
try {
map = getSEOConfigOnUpDao.getSEOConfig(conn);
conn.commit();
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
conn.rollback();
throw e;
} finally {
conn.close();
}
return map;
}
/**
* 资料认证统计查询
*
* @param conn
* @param typeid 类型种类
* @param userId 用户id
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> queryCountMsg(Connection conn, Long typeid, Long userId)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tuser.id as id, ");
sql.append(" tuser.username as username, ");
sql.append(" ty.`name` as tyname, ");
sql.append(" tm.`option` as tmoption ");
sql.append(" from t_user tuser ");
sql.append(" left join t_materialsauth tm on tm.userId = tuser.id ");
sql.append(" left join t_materialsauthtype ty on tm.materAuthTypeId = ty.id ");
sql.append(" where tuser.id = " + userId);
sql.append(" and tm.materAuthTypeId = " + typeid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 删除
*
* @param conn
* @param id
* @return
* @throws Exception
* @throws Exception
*/
public long deleteAccountPaymentPage(long id, long status) throws Exception {
Connection conn = MySQL.getConnection();
long result = -1L;
try {
result = accountPaymentDao.deleteAccountPaymentPage(conn, id, status);
conn.commit();
} catch (Exception e) {
log.error(e);
e.printStackTrace();
conn.rollback();
throw e;
} finally {
conn.close();
}
return result;
}
/**
* 修改
*
* @param conn
* @param id
* @param name
* @param nid
* @param status
* @param litpic
* @param style
* @param config
* @param description
* @param order
* @return
* @throws Exception
*/
public long updateAccountPaymentPage(
long id, String name, String litpic, String config, String description, int order)
throws Exception {
Connection conn = MySQL.getConnection();
long result = -1L;
try {
result =
accountPaymentDao.updateAccountPaymentPage(
conn, id, name, litpic, config, description, order);
conn.commit();
} catch (Exception e) {
log.error(e);
e.printStackTrace();
conn.rollback();
throw e;
} finally {
conn.close();
}
return result;
}