PatientDao.java 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344
  1. package thyyxxk.webserver.dao.his.yibao;
  2. import org.apache.ibatis.annotations.*;
  3. import thyyxxk.webserver.entity.dictionary.CodeName;
  4. import thyyxxk.webserver.entity.yibao.dismiss.DisDiag;
  5. import thyyxxk.webserver.entity.yibao.patient.*;
  6. import java.util.Date;
  7. import java.util.List;
  8. @Mapper
  9. public interface PatientDao {
  10. @Select("select " +
  11. "RTRIM(a.bed_no) bedNo, " +
  12. "RTRIM(a.inpatient_no) inpatientNo, " +
  13. "a.admiss_times, " +
  14. "RTRIM(a.name) as name, " +
  15. "sex=isnull(a.sex, 9), " +
  16. "status=(select rtrim(b.status_flag) from yb_zy_review_record b where b.inpatient_no=a.inpatient_no " +
  17. "and b.admiss_times=a.admiss_times and b.ledger_sn=(select MAX(c.ledger_sn) from yb_zy_review_record c " +
  18. "where c.inpatient_no=b.inpatient_no and c.admiss_times=b.admiss_times)), " +
  19. "medType=a.med_type, " +
  20. "dismissOrder=(select count(1) from yz_act_order b where b.inpatient_no=a.inpatient_no " +
  21. "and b.admiss_times=a.admiss_times and status_flag > '1' and isnull(group_no,'00')='00' " +
  22. "and order_code in ('06026','06053','05973')) " +
  23. "from zy_actpatient a where a.ward like #{ward} and charindex('$',a.inpatient_no)=0 " +
  24. "ORDER BY cast(a.bed_no AS int)")
  25. List<Overview> getOverView(@Param("ward") String ward);
  26. @Select("select inpatient_no=rtrim(isnull(a.inpatient_no, b.inpatient_no)), " +
  27. "admiss_times=rtrim(isnull(a.admiss_times, b.admiss_times)), b.med_type, " +
  28. "social_no=rtrim(isnull(a.social_no, c.social_no)), " +
  29. "name=rtrim(isnull(a.name, b.name)), " +
  30. "sex=rtrim(isnull(a.sex, b.sex)), " +
  31. "birthDate=(convert(varchar(10), birth_date, 21)), " +
  32. "home_tel=rtrim(isnull(c.home_tel, c.employer_tel)), " +
  33. "admiss_physician=rtrim(isnull(b.admiss_physician, a.admiss_physician)), " +
  34. "admiss_physician_name=rtrim((select name FROM a_employee_mi WHERE code = b.admiss_physician)), " +
  35. "refer_physician=rtrim(b.refer_physician), " +
  36. "refer_physician_name=rtrim((select name FROM a_employee_mi WHERE code = b.refer_physician)), " +
  37. "admiss_diag_str=rtrim(isnull(b.admiss_diag_str,'')), " +
  38. "clinic_diag_str=rtrim(isnull(b.clinic_diag_str,'')), " +
  39. "admiss_ward=rtrim(isnull(b.ward,b.admiss_ward)), " +
  40. "admiss_ward_name=(select rtrim(name) from zd_unit_code where code=b.ward), " +
  41. "admiss_dept=rtrim(b.admiss_dept), b.matn_type, " +
  42. "small_dept=rtrim(b.small_dept), " +
  43. "small_dept_name=rtrim((select name from zd_unit_code where code=small_dept)), " +
  44. "admiss_date,yb_register_date=isnull(yb_register_date, admiss_date), " +
  45. "responce_type=rtrim(isnull(isnull(a.responce_type, b.responce_type), '')), " +
  46. "icd_code=rtrim(a.icd_code), " +
  47. "icd_text=rtrim(a.icd_text), " +
  48. "rtrim(b.zk_ward) as zk_ward, " +
  49. "yb_gs_no=rtrim(isnull(a.yb_gs_no, b.yb_gs_no)), " +
  50. "yb_card_no=rtrim(isnull((select yb_card_no from a_patient_mi where inpatient_no=#{inpatientNo}), a.yb_card_no)), " +
  51. "remark=rtrim(a.remark), " +
  52. "input_name=rtrim((select name FROM a_employee_mi WHERE code = input_id)), " +
  53. "input_date=isnull(a.input_date, getdate()), " +
  54. "yb_remark=rtrim(a.yb_remark), " +
  55. "pass_id=rtrim(a.pass_id), " +
  56. "pass_name=rtrim((select name FROM a_employee_mi WHERE code = a.pass_id)), " +
  57. "pass_date=a.pass_date," +
  58. "ward=(b.ward), b.latechb_flag, b.pret_flag," +
  59. "ledger_sn=rtrim(b.times_billed), " +
  60. "admiss_status=rtrim(b.admiss_status), " +
  61. "dismissOrder=(select count(1) from yz_act_order y where y.inpatient_no=b.inpatient_no " +
  62. "and y.admiss_times=b.admiss_times and status_flag > '1' and isnull(group_no,'00')='00' " +
  63. "and order_code in ('06026','06053','05973')), " +
  64. "dis_diag_status=RTRIM((select dis_diag_status from zy_dis_diag_yb where inpatient_no=#{inpatientNo} " +
  65. "and admiss_times=a.admiss_times and dis_diag_no=1))," +
  66. "operation=rtrim(b.operation), b.zy_serial_no," +
  67. "bed_no=rtrim(b.bed_no), b.admdvs, " +
  68. "charge_yb=(select rtrim(isnull(charge_yb, '0.00')) from zy_ledger_file where inpatient_no=#{inpatientNo} " +
  69. "and admiss_times=b.admiss_times and ledger_sn=a.ledger_sn), " +
  70. "status_flag=rtrim(isnull(a.status_flag, '-1')), " +
  71. "total_charge=(select rtrim(isnull(total_charge, '0.00')) from zy_ledger_file where inpatient_no=#{inpatientNo} " +
  72. "and admiss_times=b.admiss_times and ledger_sn=a.ledger_sn), " +
  73. "balance=RTRIM((select balance+charge_yb from zy_ledger_file where inpatient_no=#{inpatientNo} and " +
  74. "admiss_times=a.admiss_times and ledger_sn=a.ledger_sn))," +
  75. "hic_no=rtrim((select hic_no_new from a_patient_mi where inpatient_no = #{inpatientNo})), " +
  76. "card_iden=rtrim(isnull((select card_iden from a_patient_mi where inpatient_no = #{inpatientNo}), '')), " +
  77. "indi_id=rtrim((select isnull(indi_id, '') from a_patient_mi where inpatient_no = #{inpatientNo})), " +
  78. "yb_jlh=rtrim(b.yb_jlh) FROM a_patient_mi c, zy_actpatient b " +
  79. "LEFT JOIN yb_zy_review_record a ON b.inpatient_no = a.inpatient_no " +
  80. "AND b.admiss_times = a.admiss_times WHERE b.inpatient_no = #{inpatientNo} " +
  81. "AND b.inpatient_no = c.inpatient_no")
  82. Patient getPatientInfo(@Param("inpatientNo") String inpatientNo);
  83. @Select("select inpatient_no=rtrim(isnull(a.inpatient_no, b.inpatient_no)), " +
  84. " admiss_times=rtrim(isnull(a.admiss_times, b.admiss_times)), " +
  85. " social_no=rtrim(isnull(a.social_no, c.social_no)), " +
  86. " name=rtrim(isnull(a.name, b.name)), " +
  87. " sex=rtrim(isnull(a.sex, b.sex)), " +
  88. " birthDate=(convert(varchar(10), birth_date, 21)), " +
  89. " home_tel=rtrim(isnull(c.home_tel, c.employer_tel)), " +
  90. " admiss_physician=rtrim(isnull(b.admiss_physician, a.admiss_physician)), " +
  91. " admiss_physician_name=(select rtrim(name) FROM a_employee_mi WHERE code = b.admiss_physician), " +
  92. " refer_physician=rtrim(b.refer_physician), " +
  93. " refer_physician_name=(select rtrim(name) FROM a_employee_mi WHERE code = b.refer_physician), " +
  94. " admiss_diag_str=rtrim(isnull(b.admiss_diag_str,'')), " +
  95. " clinic_diag_str=rtrim(isnull(b.clinic_diag_str,'')), " +
  96. " admiss_ward=rtrim(b.admiss_ward), " +
  97. " admiss_ward_name=(select rtrim(name) from zd_unit_code where code=admiss_ward), " +
  98. " admiss_dept=rtrim(b.admiss_dept), " +
  99. " small_dept=rtrim(b.small_dept), " +
  100. " small_dept_name=(select rtrim(name) from zd_unit_code where code=small_dept), " +
  101. " admiss_date, " +
  102. " yb_register_date=isnull(yb_register_date, admiss_date), " +
  103. " responce_type=rtrim(isnull(isnull(a.responce_type, b.responce_type), '')), " +
  104. " icd_code=rtrim(a.icd_code), " +
  105. " icd_text=rtrim(a.icd_text), " +
  106. " yb_gs_no=rtrim(isnull(a.yb_gs_no, b.yb_gs_no)), " +
  107. " accident_flag=rtrim(isnull(a.accident_flag, 0)), " +
  108. " std_flag=rtrim(isnull(a.std_flag,0)), " +
  109. " yb_card_no=rtrim(isnull((select yb_card_no from a_patient_mi where inpatient_no=#{inpatientNo}), a.yb_card_no)), " +
  110. " remark=rtrim(a.remark), " +
  111. " input_name=(select rtrim(name) FROM a_employee_mi WHERE code = input_id), " +
  112. " input_date=isnull(a.input_date, getdate()), " +
  113. " yb_remark=rtrim(a.yb_remark), " +
  114. " pass_id=rtrim(a.pass_id), " +
  115. " pass_name=(select rtrim(name) FROM a_employee_mi WHERE code = a.pass_id), " +
  116. " pass_date=a.pass_date, b.zy_serial_no," +
  117. " ledger_sn=rtrim(b.times_billed), " +
  118. " admiss_status=rtrim(b.admiss_status), " +
  119. " dis_diag_status=(select rtrim(dis_diag_status) from zy_dis_diag_yb where inpatient_no=#{inpatientNo} " +
  120. " and admiss_times=#{admissTimes} and dis_diag_no=1), " +
  121. " operation=rtrim(b.operation), " +
  122. " bed_no=rtrim(b.bed_no), " +
  123. " charge_yb=(select rtrim(isnull(charge_yb, '0.00')) from zy_ledger_file where inpatient_no=#{inpatientNo} " +
  124. " and admiss_times=#{admissTimes} and ledger_sn=a.ledger_sn), " +
  125. " status_flag=rtrim(isnull(a.status_flag, '-1')), " +
  126. " total_charge=(select rtrim(isnull(total_charge, '0.00')) from zy_ledger_file where inpatient_no=#{inpatientNo} " +
  127. " and admiss_times=#{admissTimes} and ledger_sn=a.ledger_sn), " +
  128. " balance=(select balance+charge_yb from zy_ledger_file where inpatient_no=#{inpatientNo} and " +
  129. " admiss_times=#{admissTimes} and ledger_sn=a.ledger_sn), " +
  130. " hic_no=(select rtrim(hic_no_new) from a_patient_mi where inpatient_no = #{inpatientNo}), " +
  131. " card_iden=(select isnull(rtrim(card_iden),'') from a_patient_mi where inpatient_no = #{inpatientNo}), " +
  132. " indi_id=(select isnull(indi_id, '') from a_patient_mi where inpatient_no = #{inpatientNo}), " +
  133. " yb_jlh=rtrim(b.yb_jlh) FROM a_patient_mi c, ${table} b " +
  134. " LEFT JOIN yb_zy_review_record a ON " +
  135. " b.inpatient_no = a.inpatient_no " +
  136. " and a.admiss_times = b.admiss_times " +
  137. "WHERE b.inpatient_no = #{inpatientNo} " +
  138. " and b.admiss_times=#{admissTimes} " +
  139. " AND b.inpatient_no = c.inpatient_no ")
  140. Patient getPatientInfoForHrg(@Param("inpatientNo") String inpatientNo,
  141. @Param("admissTimes") Integer admissTimes,
  142. @Param("table") String table);
  143. @Select("select dis_diag_no, " +
  144. "rtrim(dis_diag) disDiag, " +
  145. "rtrim(dis_diag_comment) disDiagComment, " +
  146. "dis_diag_status, " +
  147. "opName=(select rtrim(name) from a_employee_mi where code=op_id_code) " +
  148. "from zy_dis_diag_yb where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
  149. List<DisDiag> getYibaoDisDiags(@Param("inpatientNo") String inpatientNo, @Param("admissTimes") Integer admissTimes);
  150. @Select("SELECT dis_diag_no, " +
  151. "rtrim(dis_diag) disDiag, " +
  152. "rtrim(dis_diag_comment) disDiagComment, " +
  153. "disDiagStatusName=(select rtrim(name) from zd_dis_diag_status WHERE code=dis_diag_status), " +
  154. "opName=(select rtrim(name) from a_employee_mi where code=op_id_code) " +
  155. "from ba_first_page1 where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
  156. List<DisDiag> getBingliDisDiags(@Param("inpatientNo") String inpatientNo, @Param("admissTimes") Integer admissTimes);
  157. @Select("select rtrim(inpatient_no) from a_patient_mi where social_no=#{idCard}")
  158. List<String> getInpatientNo(@Param("idCard") String idCard);
  159. @Select("SELECT item_no, inpatient_no, admiss_times, agency, expirestart, file_sfz " +
  160. "FROM zy_xnh_record_sfz WHERE inpatient_no=#{inpatientNo} AND admiss_times=#{admissTimes}")
  161. List<IdCard> getIdCard(@Param("inpatientNo") String inpatientNo, @Param("admissTimes") Integer admissTimes);
  162. @Select("SELECT item_no,inpatient_no,admiss_times,file_xnh AS file_sfz FROM zy_xnh_record " +
  163. "WHERE inpatient_no=#{inpatientNo} AND admiss_times=#{admissTimes}")
  164. List<IdCard> getScanFile(@Param("inpatientNo") String inpatientNo, @Param("admissTimes") Integer admissTimes);
  165. @Select("select settle_type from zy_ledger_file where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} " +
  166. "and ledger_sn=(select isnull(max ( ledger_sn ), min ( ledger_sn )) from zy_ledger_file where " +
  167. "inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes})")
  168. Integer getSettleType(@Param("inpatientNo") String inpatientNo, @Param("admissTimes") Integer admissTimes);
  169. @Select("select count(id) from zy_retract_yb where inpatientNo=#{inpatientNo} " +
  170. "and admissTimes=#{admissTimes} and requestType=#{requestType}")
  171. Integer getRequestCount(@Param("inpatientNo") String inpatientNo,
  172. @Param("admissTimes") Integer admissTimes,
  173. @Param("requestType") Integer requestType);
  174. @Select("select * from zy_retract_yb where inpatientNo=#{inpatientNo} and " +
  175. "admissTimes=#{admissTimes} and requestType=#{requestType}")
  176. List<ToYbkRequest> getRetractRequests(@Param("inpatientNo") String inpatientNo,
  177. @Param("admissTimes") Integer admissTimes,
  178. @Param("requestType") Integer requestType);
  179. @Insert("insert into zy_retract_yb (inpatientNo, admissTimes, name, sex, responceType, ybType, treatType, " +
  180. "remark, inputId, inputName, inputTimes, statusFlag, requestType) values (#{inpatientNo}, #{admissTimes}, " +
  181. "#{name}, #{sex}, #{responceType}, #{ybType}, #{treatType}, #{remark}, #{inputId}, #{inputName}," +
  182. "#{inputTimes}, 1, #{requestType})")
  183. void submitNewRequest(ToYbkRequest indata);
  184. @Select("select isnull(max ( ledger_sn ), isnull(min ( ledger_sn ), 1)) from zy_ledger_file where " +
  185. "inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
  186. Integer getLedgerSn(@Param("inpatientNo") String inpatientNo, @Param("admissTimes") Integer admissTimes);
  187. @Update("update zy_actpatient set responce_type='01', visit_type='01', yb_type='', treat_type='', med_type='' " +
  188. "where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
  189. void revokeYbsf1(@Param("inpatientNo") String inpatientNo, @Param("admissTimes") Integer admissTimes);
  190. @Delete("delete from yb_zy_review_record where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} and " +
  191. "ledger_sn=#{ledgerSn}")
  192. void revokeYbsf2(@Param("inpatientNo") String inpatientNo,
  193. @Param("admissTimes") Integer admissTimes,
  194. @Param("ledgerSn") Integer ledgerSn);
  195. @Delete("update zy_ledger_file set charge_yb=0 where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} and " +
  196. "ledger_sn=#{ledgerSn}")
  197. void revokeYbsf3(@Param("inpatientNo") String inpatientNo,
  198. @Param("admissTimes") Integer admissTimes,
  199. @Param("ledgerSn") Integer ledgerSn);
  200. @Select("select count(1) from yb_zy_review_record where inpatient_no=#{inpatientNo} and " +
  201. "admiss_times=#{admissTimes} and ledger_sn=#{ledgerSn}")
  202. int selectCountReview(Patient param);
  203. @Insert("insert into yb_zy_review_record (inpatient_no,admiss_times,ledger_sn,input_id,input_date,remark,status_flag) " +
  204. "values (#{inpatientNo}, #{admissTimes}, #{ledgerSn}, #{inputId}, #{inputDate}, #{remark}, 1)")
  205. void insertReviewRecord(Patient param);
  206. @Update("update yb_zy_review_record set status_flag=1 where " +
  207. "inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} and ledger_sn=#{ledgerSn}")
  208. void updateStatusFlag(Patient param);
  209. @Update("update zy_actpatient set yb_register_date=#{ybRegisterDate},med_type=#{medType}," +
  210. "admdvs=#{admdvs},refer_physician=#{referPhysician},matn_type=#{matnType},latechb_flag=#{latechbFlag}," +
  211. "pret_flag=#{pretFlag} where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
  212. void updateYbRegisterDate(Patient param);
  213. @Select("select * from zy_in_diag_yb where inpatient_no=#{inpatientNo} and admiss_times=#{times} order by diag_no")
  214. List<ZyInYbDiag> getZyInYbDiag(@Param("inpatientNo") String inpatientNo, @Param("times") Integer times);
  215. @Delete("delete from zy_in_diag_yb where inpatient_no=#{inpatientNo} and admiss_times=#{times}")
  216. void deleteOldZyInYbDiag(@Param("inpatientNo") String inpatientNo, @Param("times") Integer times);
  217. @Insert("<script>" +
  218. "insert into zy_in_diag_yb (inpatient_no, admiss_times, diag_no, " +
  219. "icd_code, icd_text, oper_id, op_date, diag_type) values " +
  220. "<foreach collection='list' item='diag' separator=','>" +
  221. "(#{diag.inpatientNo},#{diag.admissTimes},#{diag.diagNo}," +
  222. "#{diag.icdCode},#{diag.icdText},#{operId},getdate(),#{diag.diagType})" +
  223. "</foreach>" +
  224. "</script>")
  225. void insertNewZyInYbDiag(@Param("operId") String operId, @Param("list") List<ZyInYbDiag> list);
  226. @Insert("<script>" +
  227. "insert into zy_in_diag_yb (inpatient_no, admiss_times, diag_no, " +
  228. "icd_code, icd_text, oper_id, op_date, diag_type) values " +
  229. "<foreach collection='diags' item='diag' separator=','>" +
  230. "(#{inpatientNo},#{admissTimes},#{diag.diagNo},#{diag.icdCode}," +
  231. "#{diag.icdText},#{staffId},getdate(),#{diag.diagType})" +
  232. "</foreach>" +
  233. "</script>")
  234. void insertSiZyInYbDiag(SaveSiZyDiags param);
  235. @Select("select convert (varchar(12),dateadd (day,0,start_time),111) from yz_act_order where " +
  236. "inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} and status_flag > '1' " +
  237. "and isnull(group_no,'00')='00' and order_code in ('06026','06053','05973') ")
  238. String getActOrderDisDate(@Param("inpatientNo") String inpatientNo,
  239. @Param("admissTimes") Integer admissTimes);
  240. @Select("select act_order_no from yz_sequence")
  241. float getActOrderNo();
  242. @Update("update yz_sequence set act_order_no=#{no}")
  243. void updateActorOrderNo(float no);
  244. @Insert("insert into yz_act_order " +
  245. "(act_order_no, inpatient_no, admiss_times, order_code, order_time, frequ_code, enter_time, " +
  246. "enter_oper, start_time, end_time, infant_flag, drug_flag, performance_time, " +
  247. "physician, confirm_time, signer, status_flag, status_time,drug_specification,order_name,discription, " +
  248. "ward_code,dept_code,exec_unit) " +
  249. "values (#{actOrderNo}, #{inpatientNo}, #{admissTimes}, '06026', #{dismissOrderDate}, 'ONCE', #{dismissOrderDate}, " +
  250. "#{staffId}, #{dismissOrderDate}, #{dismissOrderDate}, 0, 0, #{dismissOrderDate}, #{staffId}, " +
  251. "#{dismissOrderDate}, #{staffId}, 5, #{dismissOrderDate},'诊疗项目','今日结账出院','0.00 本项目不包含费用'," +
  252. "#{admissWard},#{admissWard},#{admissWard})")
  253. void insertNewDismissActOrder(@Param("actOrderNo") float actOrderNo,
  254. @Param("inpatientNo") String inpatientNo,
  255. @Param("admissTimes") Integer admissTimes,
  256. @Param("dismissOrderDate") Date dismissOrderDate,
  257. @Param("staffId") String staffId,
  258. @Param("admissWard") String admissWard);
  259. @Select("select * from zy_dis_diag_yb where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
  260. List<DisDiag> getDisDiags(@Param("inpatientNo") String inpatientNo,
  261. @Param("admissTimes") Integer admissTimes);
  262. @Select("select rtrim(admiss_diag) code,rtrim(admiss_diag_str) name from zy_actpatient where " +
  263. "inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
  264. CodeName getAdmissDiag(@Param("inpatientNo") String inpatientNo,
  265. @Param("admissTimes") Integer admissTimes);
  266. @Insert("insert into zy_dis_diag_yb (inpatient_no, admiss_times, dis_diag_no, dis_diag_type, dis_diag, " +
  267. "dis_diag_comment, op_id_code, op_diag_date, dis_diag_bzfx, dis_diag_status) " +
  268. "values (#{inpatientNo}, #{admissTimes}, 1, 13, #{code}, #{name}, #{staffId}, getDate(), '普通', 0)")
  269. void insertDisDiag(@Param("inpatientNo") String inpatientNo,
  270. @Param("admissTimes") Integer admissTimes,
  271. @Param("code") String code,
  272. @Param("name") String name,
  273. @Param("staffId") String staffId);
  274. @Insert("<script>" +
  275. "insert into zy_dis_diag_yb (inpatient_no, admiss_times, dis_diag_no, dis_diag_type, dis_diag, " +
  276. "dis_diag_comment, op_id_code, op_diag_date, dis_diag_bzfx, dis_diag_status) values " +
  277. "<foreach collection='list' item='diag' separator=','>" +
  278. "(#{diag.inpatientNo},#{diag.admissTimes},#{diag.diagNo}, 13, " +
  279. "#{diag.icdCode},#{diag.icdText},#{staffId},getdate(), '普通', 0)" +
  280. "</foreach>" +
  281. "</script>")
  282. void insertDisDiags(@Param("staffId") String staffId, @Param("list") List<ZyInYbDiag> list);
  283. @Update("execute zy_receive_drug #{zyh},#{times},#{zyh},#{infant} ")
  284. void zyReceiveDrug(@Param("zyh") String zyh,
  285. @Param("times") int times,
  286. @Param("infant") int infant);
  287. @Update("execute zy_receive_one #{zyh},#{times},#{zyh},#{infant} ")
  288. void zyReceiveOne(@Param("zyh") String zyh,
  289. @Param("times") int times,
  290. @Param("infant") int infant);
  291. @Update("execute dbo.zy_cngl_fyjs_list_yz #{zyh},#{times} " )
  292. void zyCnglFyjsListYz(@Param("zyh") String zyh,
  293. @Param("times") int times);
  294. @Update("update zy_detail_charge set charge_status='2' where " +
  295. "inpatient_no=#{zyh} and admiss_times=#{times} and ledger_sn=#{ledger} ")
  296. void updateZyDetailCharge(@Param("zyh") String zyh,
  297. @Param("times") int times,
  298. @Param("ledger") int ledger);
  299. @Update("execute zy_calc_detail_again_new #{zyh},#{times},#{ledger},1,1")
  300. void zyCalcDetailAgainNew(@Param("zyh") String zyh,
  301. @Param("times") int times,
  302. @Param("ledger") int ledger);
  303. }