| | |
|---|
| | | @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 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}") |
|---|
| | |
|---|
| | | "\tLEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" + |
|---|
| | | "\tLEFT JOIN sys_user us ON us.user_id = re.doctor_name \n" + |
|---|
| | | "WHERE\n" + |
|---|
| | | "\tre.type != 2 \n" + |
|---|
| | | "\tre.type != 2 and pro.need_report='Y' \n" + |
|---|
| | | "\tAND re.tj_number =#{tjNumber}") |
|---|
| | | List<CsProVo> cSWebGetProByTjNumAndOrderId(String tjNumber); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("call pro_lis_sqdbgd(0,#{tjnumber,mode=IN})") |
|---|
| | | // @Select("select * from test_remark") |
|---|
| | | List<TjOrderRemark> addHuaYanTable(@Param("tjnumber") String tjnumber); |
|---|
| | | } |
|---|
