| | |
|---|
| | | " 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 #{tjNum},b.cus_id,b.cus_name,'1633660948860522619','纯音听阈'," + |
|---|
| | | "#{userName},SYSDATE(),#{userId} FROM tb_transition a LEFT JOIN tj_customer b " + |
|---|
| | | "ON a.cus_id=b.cus_idcard WHERE a.cus_id=#{cusId} AND a.parent_pro_id IN('1633660948860522619') GROUP BY a.cus_id") |
|---|
| | | boolean saveTjPureToneTesByCusId(String cusId,String tjNum,String userName, String userId); |
|---|
| | | boolean saveTjPureToneTesByCusId(@Param("cusId")String cusId,@Param("tjNum")String tjNum,@Param("userName")String userName,@Param("userId") String userId); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update("UPDATE tj_order_detail a SET\n" + |
|---|
| | |
|---|
| | | "(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); |
|---|
| | | } |
|---|
