获取本次流水序列号     select SQ_BLJK_YZJKB0_LSH000.Nextval from dual   序列号=77575
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.DataUtil.getSwitchCfgById(DataUtil.java:1689) 开关: SWITCH_CONTENT=Y;SWITCH_ID=cpoe_lcinfo_80671(提交医嘱数据直接写入中间表，步调用过程 SP_CPOE_ORDER_CHANGE ，其他医嘱操作不变。)
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.SqlFilter.execute(SqlFilter.java:234) >> 代替 SP_CPOE_ORDER_CHANGE 过程插入 BLJK_YZJKB0 中间表 BEGIN......
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.SqlFilter.execute(SqlFilter.java:238) >> 参数:1:17400145252920282349,2:17400145252920282349,3:940238,4:3180915,5:,6:ZCY,7:,8:Y,9:828,10:20250220092205,11:20250220092205,12:20250220092205,13:20250220092205,14:兰希,15:828,16:20250220092936,17:20250220092936,18:20250220092936,19:20250220092936,20:828,21:,22:,23:,24:,25:20250220092000,26:20250220092000,27:20250220092000,28:20250220092000,29:,30:,31:,32:,33:,34:ZCY,35:,36:,37:1198,38:1074,39:62,40:qd,41:ZCY,42:271,43:271,44:,45:ZCY,46:静脉输液,47:静脉输液,48:,49:,50:2,51:,52:,53:N,54:5281,55:40,56:ml,57:参麦注射液[基](中集采）,58:,59:5281,60:5281,61:参麦注射液[基](中集采）,62:,63:,64:,65:,66:IN,67:,68:,69:,70:,71:,72:,73:,74:,75:,76:,77:,78:77575,79:,80:828,81:兰希,82:,83:1,84:,85:,86:,;SQL=>insert into BLJK_YZJKB0( WBYZID,    WBZID0,    ZYID00,    BRID00,    ZYH000,  YEXM00,    YPLBBH,    DMBZ00,    CLBZ00,    KZYS00,  LRRQ00,    LRSJ00,    LRRXM0,    XGYS00,    XGRQ00,  XGSJ00,    XGRXM0,    YTZRQ0,    YTZSJ0,    HDRXM0,  QYRQ00,    QYSJ00,    TZRQ00,    TZSJ00,    TZYS00,  TZRXM0,    ZQS000,    ZQDW00,    ZQCD00,    ZQCYTS,  JYCS00,    BQH000,    KSH000,    YFBMBH,    PCID00,  PCMC00,    YFID00,    YPYFMC,    YYZF00,    YZZT00,  YZMXSM,    BZID00,    BZ0000,    SJQSRQ,    SJQSSJ,  YZLY00,    KFBZ00,    YPBM00,    MCSL00,    JLDW00,  YPMC00,    JZBZ00,    YPNM00,    ZLXMID,    YZMC00,  PSID00,    PSMC00,    PSTGBZ,    PSXGID,    XMYFMC,  YZCLLB,    LYL000,    ZYFYDW,    ZFBZ00,    PSRID0,  PSRXM0,    PSSJ00,    BBID00,    BBMC00,    ZXKS00,  CJKS00,    BWMC00,    YZLB00,    LSH000,    CYTS00,  SubmitID,  SubmitName,srcs00,    ZFFSBZ,    SFHZYZ, BRLXMC,    KSSYF0 )values( ?, ?, ?, ?, null,  ?, decode(?,'XY','0','ZCY','1','CY','2'), decode(nvl(?,'0'),'0','0','1'), decode(?,'Y','0','1'), ?,  substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), ?, ?, substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), ?, substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), null, substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), null, null, ?, ?, ?, ?, 1, nvl(?,1), decode(?,'CY',nvl(?,0),0), ?, ?, ?, nvl(?,0), ?, decode(?,'XY',trim(?),'ZCY',trim(?),trim(?)), decode(?,'XY',?,'ZCY',?,?), ?, ?, '2', ?, ?, null, null, '1', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, nvl(?,0), ?, ?, null, ?, ?, ?, ?, ?, nvl(?,0), ?, ?, ?, ?, ?, ?, to_number(nvl(?,'-1')), ?, decode(upper(?),'CONSCROSS','1','0'), ?, ?)
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.SqlFilter.execute(SqlFilter.java:247) >> 代替 SP_CPOE_ORDER_CHANGE 过程插入 BLJK_YZJKB0 中间表 END  ......
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.SqlFilter.execute(SqlFilter.java:234) >> 代替 SP_CPOE_ORDER_CHANGE 过程插入 BLJK_YZJKB0 中间表 BEGIN......
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.SqlFilter.execute(SqlFilter.java:238) >> 参数:1:17400145252920283985,2:17400145252920282349,3:940238,4:3180915,5:,6:XY,7:,8:Y,9:828,10:20250220092205,11:20250220092205,12:20250220092205,13:20250220092205,14:兰希,15:828,16:20250220092936,17:20250220092936,18:20250220092936,19:20250220092936,20:828,21:,22:,23:,24:,25:20250220092000,26:20250220092000,27:20250220092000,28:20250220092000,29:,30:,31:,32:,33:,34:XY,35:,36:,37:1198,38:1074,39:62,40:qd,41:XY,42:271,43:271,44:,45:XY,46:静脉输液,47:静脉输液,48:,49:,50:2,51:,52:,53:N,54:5740,55:250,56:ml,57:葡萄糖注射液[5%塑][基],58:,59:5740,60:5740,61:葡萄糖注射液[5%塑][基],62:,63:,64:,65:,66:IN,67:,68:,69:,70:,71:,72:,73:,74:,75:,76:,77:,78:77575,79:,80:828,81:兰希,82:,83:1,84:,85:,86:,;SQL=>insert into BLJK_YZJKB0( WBYZID,    WBZID0,    ZYID00,    BRID00,    ZYH000,  YEXM00,    YPLBBH,    DMBZ00,    CLBZ00,    KZYS00,  LRRQ00,    LRSJ00,    LRRXM0,    XGYS00,    XGRQ00,  XGSJ00,    XGRXM0,    YTZRQ0,    YTZSJ0,    HDRXM0,  QYRQ00,    QYSJ00,    TZRQ00,    TZSJ00,    TZYS00,  TZRXM0,    ZQS000,    ZQDW00,    ZQCD00,    ZQCYTS,  JYCS00,    BQH000,    KSH000,    YFBMBH,    PCID00,  PCMC00,    YFID00,    YPYFMC,    YYZF00,    YZZT00,  YZMXSM,    BZID00,    BZ0000,    SJQSRQ,    SJQSSJ,  YZLY00,    KFBZ00,    YPBM00,    MCSL00,    JLDW00,  YPMC00,    JZBZ00,    YPNM00,    ZLXMID,    YZMC00,  PSID00,    PSMC00,    PSTGBZ,    PSXGID,    XMYFMC,  YZCLLB,    LYL000,    ZYFYDW,    ZFBZ00,    PSRID0,  PSRXM0,    PSSJ00,    BBID00,    BBMC00,    ZXKS00,  CJKS00,    BWMC00,    YZLB00,    LSH000,    CYTS00,  SubmitID,  SubmitName,srcs00,    ZFFSBZ,    SFHZYZ, BRLXMC,    KSSYF0 )values( ?, ?, ?, ?, null,  ?, decode(?,'XY','0','ZCY','1','CY','2'), decode(nvl(?,'0'),'0','0','1'), decode(?,'Y','0','1'), ?,  substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), ?, ?, substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), ?, substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), null, substr(?,1,8), substr(?,9,2)||':'||substr(?,11,2)||':'||substr(?,13,2), null, null, ?, ?, ?, ?, 1, nvl(?,1), decode(?,'CY',nvl(?,0),0), ?, ?, ?, nvl(?,0), ?, decode(?,'XY',trim(?),'ZCY',trim(?),trim(?)), decode(?,'XY',?,'ZCY',?,?), ?, ?, '2', ?, ?, null, null, '1', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, nvl(?,0), ?, ?, null, ?, ?, ?, ?, ?, nvl(?,0), ?, ?, ?, ?, ?, ?, to_number(nvl(?,'-1')), ?, decode(upper(?),'CONSCROSS','1','0'), ?, ?)
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.SqlFilter.execute(SqlFilter.java:247) >> 代替 SP_CPOE_ORDER_CHANGE 过程插入 BLJK_YZJKB0 中间表 END  ......
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.CallProStringTool.prepareCall(CallProStringTool.java:46) 创建过程 CallableStatement [-723522555] 成功！
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.dao.his.def.DLocalInfoHISProDefDAO.orderChangeToHisCallSp(DLocalInfoHISProDefDAO.java:706) 过程SP_CPOE_ORDER_INSERT参数1：77575
2025-02-20 09:29:36,286 212  com.haitaiinc.localinpinfo.common.sql.CallProStringTool.execute(CallProStringTool.java:91) 调用过程 {call SP_CPOE_ORDER_INSERT(?,?,?,?)}; 过程入参：{1=77575}
2025-02-20 09:29:36,318 212  com.haitaiinc.localinpinfo.common.sql.CallProStringTool.execute(CallProStringTool.java:100) 调用过程出参：{2=1, 3=医嘱变更失败[ORA-20002: 52-没有新开未提交的医嘱!*还回信息:！*！*SP_BLJK_BQYZINSERT(77575],请联系管理员！, 4=医嘱变更失败[ORA-20002: 52-没有新开未提交的医嘱!*还回信息:！*！*SP_BLJK_BQYZINSERT(77575],请联系管理员！[P_LSH000=77575]ORA-20002: 52-没有新开未提交的医嘱!*还回信息:！*！*SP_BLJK_BQYZINSERT(77575}
2025-02-20 09:29:36,318 212  com.haitaiinc.localinpinfo.dao.his.def.DLocalInfoHISProDefDAO.orderChangeToHisCallSp(DLocalInfoHISProDefDAO.java:712) his过程SP_CPOE_ORDER_INSERT输出==>1;医嘱变更失败[ORA-20002: 52-没有新开未提交的医嘱!*还回信息:！*！*SP_BLJK_BQYZINSERT(77575],请联系管理员！
2025-02-20 09:29:36,318 212  com.haitaiinc.localinpinfo.common.sql.CallProStringTool.close(CallProStringTool.java:106) 关闭过程 CallableStatement[-723522555] 成功！
2025-02-20 09:29:36,318 212  com.haitaiinc.localinpinfo.dao.his.def.DLocalInfoHISProDefDAO.orderChangeToHisCallSp(DLocalInfoHISProDefDAO.java:717) resultStr=1;医嘱变更失败[ORA-20002: 52-没有新开未提交的医嘱!*还回信息:！*！*SP_BLJK_BQYZINSERT(77575],请联系管理员！
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.dao.his.def.DLocalInfoHISProDefDAO.orderChangeToHis(DLocalInfoHISProDefDAO.java:671)  (提交、撤销、停止、作废)操作医嘱信息发送给HIS   end...
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.rollBack(DBOManager.java:122) [EMR(-1176832135)] rollback Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.rollBack(DBOManager.java:122) [HIS(-1452765792)] rollback Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.rollBack(DBOManager.java:122) [EMR(-1176832135)] rollback Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.rollBack(DBOManager.java:122) [HIS(-1452765792)] rollback Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.service.localinterface.functionimpl.ordersubmit.OrderSubmitAction.orderSubmit(OrderSubmitAction.java:140) 返回XML=><MESSAGE><RESPONSE><SUCCESS>3</SUCCESS><DESCRIPTION>医嘱变更失败[ORA-20002: 52-没有新开未提交的医嘱!*还回信息:！*！*SP_BLJK_BQYZINSERT(77575],请联系管理员！</DESCRIPTION></RESPONSE></MESSAGE>
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.commit(DBOManager.java:112) [EMR(-1176832135)] commit Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.commit(DBOManager.java:112) [HIS(-1452765792)] commit Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.close(DBOManager.java:132) [EMR(-1176832135)] close Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.common.sql.DBOManager.close(DBOManager.java:132) [HIS(-1452765792)] close Success !
2025-02-20 09:29:36,333 212  com.haitaiinc.localinpinfo.service.localinterface.LocalInterfaceAction.localInterface(LocalInterfaceAction.java:196) =>==>>orderSubmit耗时：78ms