| | |
|---|
| | | @Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND pro_id=#{proParentId} AND deleted='0'") |
|---|
| | | TjOrderRemark getTjOrderRemarkByTjNumAndProParentId(@Param("tjNumber") String tjNumber,@Param("proParentId") String proParentId); |
|---|
| | | |
|---|
| | | @Select("SELECT COUNT(*) a FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type=3 or type=0 AND deleted=0") |
|---|
| | | @Select("SELECT COUNT(*) a FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type IN (0,3) AND deleted=0") |
|---|
| | | int getTjYqOrderRemarkByTjNum(String tjNumber); |
|---|
| | | |
|---|
| | | @Delete("DELETE FROM tj_order_remark WHERE tj_number=#{tjNumber}") |
|---|
