/**
* 根据orderid删除发送失败后存储到表or_order_sms和or_orderextinfo中的记录
*
* @param orderid
*/
public void delOrderSMS(long orderid) {
String sql1 = "delete from or_order_sms m where m.orderid=" + orderid;
String sql2 = "delete from or_orderextinfo f where f.orderid=" + orderid + " and f.type='03' ";
log.info("清空or_order_sms对应的数据，orderid=" + orderid);
super.getSession().createSQLQuery(sql1).executeUpdate();
log.info("清空or_orderextinfo对应的数据，orderid=" + orderid);
super.getSession().createSQLQuery(sql2).executeUpdate();
}
/** 插入表extinfo随机码 */
public void addCheckcodeToExtInfoBySql(String checkcode, long orderid) {
String sql =
"insert into or_orderextinfo(id,orderid,type,context) values(seq_order_extinfo.nextval,"
+ orderid
+ ",'03','"
+ checkcode
+ "') ";
super.getSession().createSQLQuery(sql).executeUpdate();
}
