| | |
|---|
| | | " SELECT a.pro_id FROM tj_order_detail a WHERE !ISNULL(flowing_water_id) AND order_id=#{orderId})") |
|---|
| | | public List<TjProject> selectTjOrderDetailListByFlowingWaterIdIsNotNull(String orderId); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询未缴费项目 |
|---|
| | | */ |
|---|
| | |
|---|
| | | "(select pro_id from tj_project where pro_parent_id=#{proParentId})") |
|---|
| | | public List<TjOrderDetail> getDetailByOrderIdAndParId(@Param("orderId")Long orderId,@Param("proParentId")Long proParentId); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("call pro_lis_sqdbgd(1,#{tjnumber,mode=IN})") |
|---|
| | | // @Select("select * from test_detail") |
|---|
| | | List<TjOrderDetail> addHuaYanTable(@Param("tjnumber") String tjnumber); |
|---|
| | | } |
|---|
