| | |
| | | "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" + |