/**
* 查询充值详细表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);
}
/**
* 根据ID获充值详细表信息
*
* @param conn
* @param id
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> getRechargeDetail(Connection conn, long id)
throws SQLException, DataException {
Dao.Tables.t_recharge_detail t_recharge_detail = new Dao().new Tables().new t_recharge_detail();
DataSet ds = t_recharge_detail.open(conn, "*", "id=" + id, "", -1, -1);
return DataSetHelper.dataSetToMap(ds);
}
