日期:2014-05-18 浏览次数:20897 次
public void cancelYuyue(Long id) { getHibernateTemplate().delete (getHibernateTemplate().find("from OrderInstrumentReservation where id="+id+"and status='待审核'")); //getHibernateTemplate().find("from OrderInstrumentReservation where adminId="+id+"and status='待审核'"); }
Hibernate: select orderinstr0_.id as id1_, orderinstr0_.instrumentId as instrume2_1_, orderinstr0_.adminId as adminId1_, orderinstr0_.userId as userId1_, orderinstr0_.name as name1_, orderinstr0_.unit as unit1_, orderinstr0_.startTime as startTime1_, orderinstr0_.endTime as endTime1_, orderinstr0_.applyTime as applyTime1_, orderinstr0_.actualStartTime as actualS10_1_, orderinstr0_.actualEndTime as actualE11_1_, orderinstr0_.actualCost as actualCost1_, orderinstr0_.status as status1_, orderinstr0_.useNumber as useNumber1_, orderinstr0_.actualUseNumber as actualU15_1_, orderinstr0_.remark as remark1_, orderinstr0_.sysTime as sysTime1_, orderinstr0_.timeA as timeA1_, orderinstr0_.timeB as timeB1_, orderinstr0_.timeC as timeC1_, orderinstr0_.timeD as timeD1_, orderinstr0_.timeE as timeE1_, orderinstr0_.timeF as timeF1_, orderinstr0_.timeG as timeG1_, orderinstr0_.timeH as timeH1_, orderinstr0_.timeI as timeI1_, orderinstr0_.timeJ as timeJ1_, orderinstr0_.timeK as timeK1_, orderinstr0_.timeL as timeL1_, orderinstr0_.timeM as timeM1_, orderinstr0_.timeN as timeN1_ from orderSys.dbo.order_instrumentReservation orderinstr0_ where orderinstr0_.id=53 and orderinstr0_.status='待审核'