◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 15:47:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13931594554</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_生殖科许春月</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130229199606251829</patientidcard><patientname>王平</patientname><patientsex>女</patientsex><patientbirthday>1996-06-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13931594554</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 15:47:48
记录内容：select * from  pat_master_index where id_no='130229199606251829' and name='王平' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/6/25 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 15:47:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '生殖科许春月' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 15:47:48
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6812,'生殖科许春月','上午','11','Z00227606','王平','','女','30','一般人员','自费','','副主任号','1','0371','XUCY','1',to_date('2026/01/27 15:47:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601286812','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 15:47:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6812,'生殖科许春月','上午','11','Z00227606','王平','','女','30','一般人员','自费','','副主任号','1','0371','XUCY','1',to_date('2026/01/27 15:47:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601286812','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '生殖科许春月' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6812,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '生殖科许春月' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601286812</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601286812</pinkey><ordertime>2026-01-27 15:47:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 15:58:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18600995988</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_下午_耳鼻喉科吴胜杰</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082198703045872</patientidcard><patientname>赵森</patientname><patientsex>男</patientsex><patientbirthday>1987-03-04</patientbirthday><medicalrecord></medicalrecord><contactphone>18600995988</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 15:58:29
记录内容：select * from  pat_master_index where id_no='131082198703045872' and name='赵森' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/3/4 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 15:58:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 15:58:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6958,'耳鼻喉科吴胜杰','下午','2','100160448','赵森','ZHAO SEN ','男','39','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/01/27 15:58:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601286958','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 15:58:29
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6958,'耳鼻喉科吴胜杰','下午','2','100160448','赵森','ZHAO SEN ','男','39','一般人员','自费','','普通号','1','0306','WSJ01','1',to_date('2026/01/27 15:58:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601286958','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科吴胜杰' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6958,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科吴胜杰' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202601286958</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601286958</pinkey><ordertime>2026-01-27 15:58:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 16:00:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>16600090009</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_下午_儿科刘婕</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082201608170434</patientidcard><patientname>赵圣雄</patientname><patientsex>男</patientsex><patientbirthday>2016-08-17</patientbirthday><medicalrecord></medicalrecord><contactphone>16600090009</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 16:00:17
记录内容：select * from  pat_master_index where id_no='131082201608170434' and name='赵圣雄' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2016/8/17 0:00:0010
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:00:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:00:17
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6982,'儿科刘婕','下午','1','100530725','赵圣雄','ZHAO SHENG XIONG ','男','10','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/01/27 16:00:27','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601286982','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 16:00:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6982,'儿科刘婕','下午','1','100530725','赵圣雄','ZHAO SHENG XIONG ','男','10','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/01/27 16:00:27','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601286982','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6982,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '儿科刘婕' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202601286982</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601286982</pinkey><ordertime>2026-01-27 16:00:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 16:18:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18601343347</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_产科王振燕</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220112199203271429</patientidcard><patientname>王雪</patientname><patientsex>女</patientsex><patientbirthday>1992-03-27</patientbirthday><medicalrecord></medicalrecord><contactphone>18601343347</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 16:18:11
记录内容：select * from  pat_master_index where id_no='220112199203271429' and name='王雪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/3/27 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:18:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:18:11
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7227,'产科王振燕','上午','8','100372860','王雪','WANG XUE ','女','34','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2026/01/27 16:18:21','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601287227','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 16:18:11
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7227,'产科王振燕','上午','8','100372860','王雪','WANG XUE ','女','34','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2026/01/27 16:18:21','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601287227','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7227,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287227</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202601287227</pinkey><ordertime>2026-01-27 16:18:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 16:36:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15901193404</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_普通外科牛朋军</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232324197908032744</patientidcard><patientname>孟祥红</patientname><patientsex>女</patientsex><patientbirthday>1979-08-03</patientbirthday><medicalrecord></medicalrecord><contactphone>15901193404</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 16:36:46
记录内容：select * from  pat_master_index where id_no='232324197908032744' and name='孟祥红' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/8/3 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:36:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '普通外科牛朋军' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:36:46
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7507,'普通外科牛朋军','上午','2','100534556','孟祥红','MENG XIANG HONG ','女','47','一般人员','自费','','普通号','1','0335','NPJ','1',to_date('2026/01/27 16:36:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601287507','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 16:36:46
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7507,'普通外科牛朋军','上午','2','100534556','孟祥红','MENG XIANG HONG ','女','47','一般人员','自费','','普通号','1','0335','NPJ','1',to_date('2026/01/27 16:36:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601287507','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科牛朋军' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7507,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '普通外科牛朋军' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287507</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601287507</pinkey><ordertime>2026-01-27 16:36:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 16:57:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13701236386</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_呼吸内科高立静普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>512322197110048514</patientidcard><patientname>石绍兵</patientname><patientsex>男</patientsex><patientbirthday>1971-10-04</patientbirthday><medicalrecord></medicalrecord><contactphone>13701236386</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 16:57:31
记录内容：select * from  pat_master_index where id_no='512322197110048514' and name='石绍兵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/10/4 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:57:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 16:57:31
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7702,'呼吸内科高立静普','上午','10','100245728','石绍兵','SHI SHAO BING','男','55','一般人员','自费','','普通号','1','0317','GLJ','1',to_date('2026/01/27 16:57:40','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601287702','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 16:57:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7702,'呼吸内科高立静普','上午','10','100245728','石绍兵','SHI SHAO BING','男','55','一般人员','自费','','普通号','1','0317','GLJ','1',to_date('2026/01/27 16:57:40','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601287702','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7702,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287702</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601287702</pinkey><ordertime>2026-01-27 16:57:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 17:35:34
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15932165668</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_白天_妇科邓宏文</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>13108219820328202X</patientidcard><patientname>尹洪杰</patientname><patientsex>女</patientsex><patientbirthday>1982-03-28</patientbirthday><medicalrecord></medicalrecord><contactphone>15932165668</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 17:35:34
记录内容：select * from  pat_master_index where id_no='13108219820328202X' and name='尹洪杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/3/28 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 17:35:34
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '妇科邓宏文' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 17:35:34
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7781,'妇科邓宏文','白天','3','100390465','尹洪杰','YIN HONG JIE ','女','44','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2026/01/27 17:35:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601287781','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 17:35:35
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7781,'妇科邓宏文','白天','3','100390465','尹洪杰','YIN HONG JIE ','女','44','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2026/01/27 17:35:44','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601287781','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科邓宏文' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7781,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '妇科邓宏文' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202601287781</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601287781</pinkey><ordertime>2026-01-27 17:35:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 17:58:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18647360012</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_妇科李广太主任号</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>152101198601210947</patientidcard><patientname>刘欣</patientname><patientsex>女</patientsex><patientbirthday>1986-01-21</patientbirthday><medicalrecord></medicalrecord><contactphone>18647360012</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 17:58:04
记录内容：select * from  pat_master_index where id_no='152101198601210947' and name='刘欣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/1/21 0:00:0040
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 17:58:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '妇科李广太主任号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 17:58:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7815,'妇科李广太主任号','上午','2','100534789','刘欣','LIU XIN ','女','40','一般人员','自费','','主任号','1','0316','LGT01','1',to_date('2026/01/27 17:58:14','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601287815','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 17:58:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7815,'妇科李广太主任号','上午','2','100534789','刘欣','LIU XIN ','女','40','一般人员','自费','','主任号','1','0316','LGT01','1',to_date('2026/01/27 17:58:14','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601287815','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科李广太主任号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7815,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '妇科李广太主任号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287815</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202601287815</pinkey><ordertime>2026-01-27 17:58:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 18:31:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18846215678</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_肛肠门诊赵磊</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230822200003136810</patientidcard><patientname>王伟屹</patientname><patientsex>男</patientsex><patientbirthday>2000-03-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18846215678</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 18:31:27
记录内容：select * from  pat_master_index where id_no='230822200003136810' and name='王伟屹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/3/13 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 18:31:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '肛肠门诊赵磊' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 18:31:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7867,'肛肠门诊赵磊','上午','3','100534790','王伟屹','WANG WEI YI ','男','26','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2026/01/27 18:31:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601287867','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 18:31:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>失败，插入订单表失败1 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7867,'肛肠门诊赵磊','上午','3','100534790','王伟屹','WANG WEI YI ','男','26','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2026/01/27 18:31:36','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601287867','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '肛肠门诊赵磊' AND TIME_DESC = '上午'select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '肛肠门诊赵磊' and visit_time_desc = '上午'</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 18:35:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18846215678</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_普通外科李基业</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230822200003136810</patientidcard><patientname>王伟屹</patientname><patientsex>男</patientsex><patientbirthday>2000-03-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18846215678</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 18:35:16
记录内容：select * from  pat_master_index where id_no='230822200003136810' and name='王伟屹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/3/13 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 18:35:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '普通外科李基业' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 18:35:16
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7877,'普通外科李基业','上午','4','100534790','王伟屹','WANG WEI YI ','男','26','一般人员','自费','','知名专家','1','0335','LIJIYE','1',to_date('2026/01/27 18:35:25','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601287877','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 18:35:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7877,'普通外科李基业','上午','4','100534790','王伟屹','WANG WEI YI ','男','26','一般人员','自费','','知名专家','1','0335','LIJIYE','1',to_date('2026/01/27 18:35:25','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601287877','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科李基业' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7877,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '普通外科李基业' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287877</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202601287877</pinkey><ordertime>2026-01-27 18:35:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 19:21:37
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18515666667</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/29 0:00:00_上午_晕厥门诊谭琛</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220324195803050214</patientidcard><patientname>田永权</patientname><patientsex>男</patientsex><patientbirthday>1958-03-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18515666667</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 19:21:38
记录内容：select * from  pat_master_index where id_no='220324195803050214' and name='田永权' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1958/3/5 0:00:0068
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:21:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '晕厥门诊谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:21:38
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),7992,'晕厥门诊谭琛','上午','1','100534802','田永权','TIAN YONG QUAN ','男','68','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2026/01/27 19:21:46','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601297992','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 19:21:38
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),7992,'晕厥门诊谭琛','上午','1','100534802','田永权','TIAN YONG QUAN ','男','68','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2026/01/27 19:21:46','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601297992','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/29', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '晕厥门诊谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/29','YYYY/MM/DD'),7992,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '晕厥门诊谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601297992</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202601297992</pinkey><ordertime>2026-01-27 19:21:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 19:22:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18296366989</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_消化内科冯连静</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>362330198104195493</patientidcard><patientname>黄重财</patientname><patientsex>男</patientsex><patientbirthday>1981-04-19</patientbirthday><medicalrecord></medicalrecord><contactphone>18296366989</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 19:22:05
记录内容：select * from  pat_master_index where id_no='362330198104195493' and name='黄重财' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1981/4/19 0:00:0045
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:22:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '消化内科冯连静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:22:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7993,'消化内科冯连静','上午','2','10773799','黄重财','','男','45','一般人员','自费','','副主任号','1','0302','FLJ','1',to_date('2026/01/27 19:22:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601287993','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 19:22:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7993,'消化内科冯连静','上午','2','10773799','黄重财','','男','45','一般人员','自费','','副主任号','1','0302','FLJ','1',to_date('2026/01/27 19:22:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601287993','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科冯连静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7993,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '消化内科冯连静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287993</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601287993</pinkey><ordertime>2026-01-27 19:22:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 19:32:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13521388325</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/29 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>410422198201014330</patientidcard><patientname>常志刚</patientname><patientsex>男</patientsex><patientbirthday>1982-01-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13521388325</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 19:32:21
记录内容：select * from  pat_master_index where id_no='410422198201014330' and name='常志刚' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/1/1 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:32:21
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:32:21
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),7996,'骨科刘海峰','上午','2','10600166','常志刚','','男','44','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 19:32:30','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601297996','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 19:32:22
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),7996,'骨科刘海峰','上午','2','10600166','常志刚','','男','44','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 19:32:30','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601297996','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/29', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/29','YYYY/MM/DD'),7996,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601297996</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202601297996</pinkey><ordertime>2026-01-27 19:32:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 19:34:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13719747095</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_消化内科梁毅</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>440224197212121628</patientidcard><patientname>唐永兰</patientname><patientsex>女</patientsex><patientbirthday>1972-12-12</patientbirthday><medicalrecord></medicalrecord><contactphone>13719747095</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 19:34:22
记录内容：select * from  pat_master_index where id_no='440224197212121628' and name='唐永兰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1972/12/12 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:34:22
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:34:22
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7997,'消化内科梁毅','上午','5','100534807','唐永兰','TANG YONG LAN ','女','54','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2026/01/27 19:34:30','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601287997','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 19:34:22
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7997,'消化内科梁毅','上午','5','100534807','唐永兰','TANG YONG LAN ','女','54','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2026/01/27 19:34:30','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601287997','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科梁毅' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7997,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287997</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202601287997</pinkey><ordertime>2026-01-27 19:34:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 19:34:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18401787752</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_神经内科周衡</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>211221198603094528</patientidcard><patientname>高立敏</patientname><patientsex>女</patientsex><patientbirthday>1986-03-09</patientbirthday><medicalrecord></medicalrecord><contactphone>18401787752</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 19:34:43
记录内容：select * from  pat_master_index where id_no='211221198603094528' and name='高立敏' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/3/9 0:00:0040
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:34:43
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '神经内科周衡' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:34:43
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7999,'神经内科周衡','上午','6','100534808','高立敏','GAO LI MIN ','女','40','一般人员','自费','','副主任号','1','0303','TTZH','1',to_date('2026/01/27 19:34:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601287999','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 19:34:43
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7999,'神经内科周衡','上午','6','100534808','高立敏','GAO LI MIN ','女','40','一般人员','自费','','副主任号','1','0303','TTZH','1',to_date('2026/01/27 19:34:52','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601287999','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科周衡' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),7999,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '神经内科周衡' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601287999</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601287999</pinkey><ordertime>2026-01-27 19:34:43</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 19:57:53
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13103264334</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_内分泌科张金环</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>232301196804286820</patientidcard><patientname>庄艳红</patientname><patientsex>女</patientsex><patientbirthday>1968-04-28</patientbirthday><medicalrecord></medicalrecord><contactphone>13103264334</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 19:57:53
记录内容：select * from  pat_master_index where id_no='232301196804286820' and name='庄艳红' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/4/28 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:57:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 19:57:53
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8052,'内分泌科张金环','上午','2','Z00327413','庄艳红','','女','58','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/01/27 19:58:02','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288052','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 19:57:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8052,'内分泌科张金环','上午','2','Z00327413','庄艳红','','女','58','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/01/27 19:58:02','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288052','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8052,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288052</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601288052</pinkey><ordertime>2026-01-27 19:57:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 20:02:07
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17692627686</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_泌尿外科杨云波</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>500231200603143415</patientidcard><patientname>彭炫智</patientname><patientsex>男</patientsex><patientbirthday>2006-03-14</patientbirthday><medicalrecord></medicalrecord><contactphone>17692627686</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 20:02:07
记录内容：select * from  pat_master_index where id_no='500231200603143415' and name='彭炫智' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/3/14 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:02:07
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:02:07
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8057,'泌尿外科杨云波','上午','5','100534809','彭炫智','PENG  ZHI ','男','20','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/01/27 20:02:16','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601288057','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 20:02:08
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8057,'泌尿外科杨云波','上午','5','100534809','彭炫智','PENG  ZHI ','男','20','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2026/01/27 20:02:16','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601288057','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科杨云波' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8057,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '泌尿外科杨云波' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288057</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202601288057</pinkey><ordertime>2026-01-27 20:02:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 20:05:06
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17319457532</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_内分泌科张金环</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370304199108016220</patientidcard><patientname>阎白雪</patientname><patientsex>女</patientsex><patientbirthday>1991-08-01</patientbirthday><medicalrecord></medicalrecord><contactphone>17319457532</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 20:05:07
记录内容：select * from  pat_master_index where id_no='370304199108016220' and name='阎白雪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/8/1 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:05:07
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:05:07
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8076,'内分泌科张金环','上午','3','Z00084997','阎白雪','','女','35','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/01/27 20:05:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288076','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 20:05:07
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8076,'内分泌科张金环','上午','3','Z00084997','阎白雪','','女','35','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/01/27 20:05:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288076','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8076,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288076</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601288076</pinkey><ordertime>2026-01-27 20:05:07</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 20:09:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18034060980</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_眼科张仲臣</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130302195209133121</patientidcard><patientname>史秀玲</patientname><patientsex>女</patientsex><patientbirthday>1952-09-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18034060980</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 20:09:17
记录内容：select * from  pat_master_index where id_no='130302195209133121' and name='史秀玲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1952/9/13 0:00:0074
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:09:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '眼科张仲臣' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:09:17
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8079,'眼科张仲臣','上午','13','100534812','史秀玲','SHI XIU LING ','女','74','一般人员','自费','','知名专家','1','0327','ZHANGZC','1',to_date('2026/01/27 20:09:26','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601288079','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 20:09:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8079,'眼科张仲臣','上午','13','100534812','史秀玲','SHI XIU LING ','女','74','一般人员','自费','','知名专家','1','0327','ZHANGZC','1',to_date('2026/01/27 20:09:26','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601288079','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科张仲臣' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8079,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '眼科张仲臣' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288079</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202601288079</pinkey><ordertime>2026-01-27 20:09:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 20:11:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13964418255</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_内分泌科张金环</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>370304196803126217</patientidcard><patientname>阎炳亮</patientname><patientsex>男</patientsex><patientbirthday>1968-03-12</patientbirthday><medicalrecord></medicalrecord><contactphone>13964418255</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 20:11:09
记录内容：select * from  pat_master_index where id_no='370304196803126217' and name='阎炳亮' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1968/3/12 0:00:0058
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:11:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:11:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8081,'内分泌科张金环','上午','4','100534821','阎炳亮','YAN BING LIANG ','男','58','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/01/27 20:11:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288081','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 20:11:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8081,'内分泌科张金环','上午','4','100534821','阎炳亮','YAN BING LIANG ','男','58','一般人员','自费','','副主任号','1','0315','ZJH01','1',to_date('2026/01/27 20:11:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288081','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科张金环' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8081,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '内分泌科张金环' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288081</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601288081</pinkey><ordertime>2026-01-27 20:11:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 20:22:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13501324426</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/5 0:00:00_上午_骨质疏松张国栋</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>222402197505190612</patientidcard><patientname>崔承赫</patientname><patientsex>男</patientsex><patientbirthday>1975-05-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13501324426</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 20:22:09
记录内容：select * from  pat_master_index where id_no='222402197505190612' and name='崔承赫' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1975/5/19 0:00:0051
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:22:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/05','yyyy/mm/dd')
                    and clinic_label = '骨质疏松张国栋' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:22:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/05','YYYY/MM/DD'),8096,'骨质疏松张国栋','上午','1','Z00255048','崔承赫','CUI CHENG HE','男','51','一般人员','自费','','副主任号','1','0312','ZGD','1',to_date('2026/01/27 20:22:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602058096','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 20:22:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/05','YYYY/MM/DD'),8096,'骨质疏松张国栋','上午','1','Z00255048','崔承赫','CUI CHENG HE','男','51','一般人员','自费','','副主任号','1','0312','ZGD','1',to_date('2026/01/27 20:22:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602058096','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/05', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨质疏松张国栋' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/05','YYYY/MM/DD'),8096,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/05','yyyy/mm/dd')
                    and clinic_label = '骨质疏松张国栋' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602058096</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602058096</pinkey><ordertime>2026-01-27 20:22:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 20:45:12
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13393262499</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/29 0:00:00_上午_眼科苗恒</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230225198607143233</patientidcard><patientname>孙庆雨</patientname><patientsex>男</patientsex><patientbirthday>1986-07-14</patientbirthday><medicalrecord></medicalrecord><contactphone>13393262499</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 20:45:12
记录内容：select * from  pat_master_index where id_no='230225198607143233' and name='孙庆雨' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/7/14 0:00:0040
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:45:12
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '眼科苗恒' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:45:12
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),8136,'眼科苗恒','上午','1','100534829','孙庆雨','SUN QING YU ','男','40','一般人员','自费','','副主任号','1','0327','MH01','1',to_date('2026/01/27 20:45:20','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601298136','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 20:45:12
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),8136,'眼科苗恒','上午','1','100534829','孙庆雨','SUN QING YU ','男','40','一般人员','自费','','副主任号','1','0327','MH01','1',to_date('2026/01/27 20:45:20','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601298136','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/29', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科苗恒' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/29','YYYY/MM/DD'),8136,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '眼科苗恒' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601298136</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601298136</pinkey><ordertime>2026-01-27 20:45:12</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 20:46:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17692627686</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_泌尿外科刘桂迁</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>500231200603143415</patientidcard><patientname>彭炫智</patientname><patientsex>男</patientsex><patientbirthday>2006-03-14</patientbirthday><medicalrecord></medicalrecord><contactphone>17692627686</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 20:46:31
记录内容：select * from  pat_master_index where id_no='500231200603143415' and name='彭炫智' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/3/14 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:46:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '泌尿外科刘桂迁' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 20:46:31
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8141,'泌尿外科刘桂迁','上午','1','100534809','彭炫智','PENG  ZHI ','男','20','一般人员','自费','','普通号','1','0311','LIUGQ','1',to_date('2026/01/27 20:46:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288141','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 20:46:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8141,'泌尿外科刘桂迁','上午','1','100534809','彭炫智','PENG  ZHI ','男','20','一般人员','自费','','普通号','1','0311','LIUGQ','1',to_date('2026/01/27 20:46:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288141','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科刘桂迁' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8141,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '泌尿外科刘桂迁' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288141</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601288141</pinkey><ordertime>2026-01-27 20:46:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 21:19:36
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19930260788</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_心理咨询张晶晶</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>110113201206056821</patientidcard><patientname>侯芷菡</patientname><patientsex>女</patientsex><patientbirthday>2012-06-05</patientbirthday><medicalrecord></medicalrecord><contactphone>19930260788</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 21:19:36
记录内容：select * from  pat_master_index where id_no='110113201206056821' and name='侯芷菡' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2012/6/5 0:00:0014
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 21:19:36
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 21:19:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8200,'心理咨询张晶晶','上午','1','100380784','侯芷菡','HOU   ','女','14','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2026/01/27 21:19:45','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288200','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 21:19:37
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8200,'心理咨询张晶晶','上午','1','100380784','侯芷菡','HOU   ','女','14','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2026/01/27 21:19:45','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288200','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8200,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288200</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601288200</pinkey><ordertime>2026-01-27 21:19:37</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 21:30:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13700348705</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/29 0:00:00_上午_骨科刘清和</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>622701194709230314</patientidcard><patientname>刘成刚</patientname><patientsex>男</patientsex><patientbirthday>1947-09-23</patientbirthday><medicalrecord></medicalrecord><contactphone>13700348705</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 21:30:15
记录内容：select * from  pat_master_index where id_no='622701194709230314' and name='刘成刚' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1947/9/23 0:00:0079
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 21:30:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '骨科刘清和' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 21:30:15
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),8219,'骨科刘清和','上午','14','M00049669','刘成刚','LIU CHENG GANG','男','79','一般人员','自费','','知名专家','1','0312','CYLQH','1',to_date('2026/01/27 21:30:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601298219','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 21:30:15
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),8219,'骨科刘清和','上午','14','M00049669','刘成刚','LIU CHENG GANG','男','79','一般人员','自费','','知名专家','1','0312','CYLQH','1',to_date('2026/01/27 21:30:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601298219','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/29', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘清和' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/29','YYYY/MM/DD'),8219,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/29','yyyy/mm/dd')
                    and clinic_label = '骨科刘清和' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601298219</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202601298219</pinkey><ordertime>2026-01-27 21:30:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 21:31:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13700348705</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_风湿免疫科罗昆</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>622701194709230314</patientidcard><patientname>刘成刚</patientname><patientsex>男</patientsex><patientbirthday>1947-09-23</patientbirthday><medicalrecord></medicalrecord><contactphone>13700348705</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 21:31:57
记录内容：select * from  pat_master_index where id_no='622701194709230314' and name='刘成刚' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1947/9/23 0:00:0079
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 21:31:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科罗昆' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 21:31:57
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8220,'风湿免疫科罗昆','上午','1','M00049669','刘成刚','LIU CHENG GANG','男','79','一般人员','自费','','副主任号','1','0337','LK','1',to_date('2026/01/27 21:32:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288220','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 21:31:57
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8220,'风湿免疫科罗昆','上午','1','M00049669','刘成刚','LIU CHENG GANG','男','79','一般人员','自费','','副主任号','1','0337','LK','1',to_date('2026/01/27 21:32:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601288220','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '风湿免疫科罗昆' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8220,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科罗昆' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288220</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601288220</pinkey><ordertime>2026-01-27 21:31:57</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 21:58:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13947588595</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_泌尿外科杨云波</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152301196308222131</patientidcard><patientname>崔凯峰</patientname><patientsex>男</patientsex><patientbirthday>1963-08-22</patientbirthday><medicalrecord></medicalrecord><contactphone>13947588595</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2026-01-27 21:58:31
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2026/01/28','YYYY-MM-DD')
            AND CLINIC_LABEL='泌尿外科杨云波' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='152301196308222131' and name='崔凯峰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 21:58:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 22:04:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13947588595</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_泌尿外科杨云波</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152301196308222131</patientidcard><patientname>崔凯峰</patientname><patientsex>男</patientsex><patientbirthday>1963-08-22</patientbirthday><medicalrecord></medicalrecord><contactphone>13947588595</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2026-01-27 22:04:57
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2026/01/28','YYYY-MM-DD')
            AND CLINIC_LABEL='泌尿外科杨云波' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='152301196308222131' and name='崔凯峰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 22:04:57
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 22:14:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13849943294</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/1 0:00:00_上午_口腔科赵子墨</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>410302200805160020</patientidcard><patientname>张千骄</patientname><patientsex>女</patientsex><patientbirthday>2008-05-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13849943294</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 22:14:48
记录内容：select * from  pat_master_index where id_no='410302200805160020' and name='张千骄' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2008/5/16 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 22:14:48
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/01','yyyy/mm/dd')
                    and clinic_label = '口腔科赵子墨' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 22:14:48
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/01','YYYY/MM/DD'),8279,'口腔科赵子墨','上午','2','100531718','张千骄','ZHANG QIAN JIAO ','女','18','一般人员','自费','','普通号','1','0319','ZZM','1',to_date('2026/01/27 22:14:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602018279','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 22:14:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/02/01','YYYY/MM/DD'),8279,'口腔科赵子墨','上午','2','100531718','张千骄','ZHANG QIAN JIAO ','女','18','一般人员','自费','','普通号','1','0319','ZZM','1',to_date('2026/01/27 22:14:56','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602018279','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/01', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '口腔科赵子墨' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/01','YYYY/MM/DD'),8279,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/01','yyyy/mm/dd')
                    and clinic_label = '口腔科赵子墨' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602018279</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602018279</pinkey><ordertime>2026-01-27 22:14:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 22:40:00
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13733266565</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_心血管内科陶林森</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028198703303511</patientidcard><patientname>韩青松</patientname><patientsex>男</patientsex><patientbirthday>1987-03-30</patientbirthday><medicalrecord></medicalrecord><contactphone>13733266565</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 22:40:00
记录内容：select * from  pat_master_index where id_no='131028198703303511' and name='韩青松' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/3/30 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 22:40:00
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '心血管内科陶林森' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 22:40:00
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8292,'心血管内科陶林森','上午','1','100534840','韩青松','HAN QING SONG ','男','39','一般人员','自费','','主任号','1','0359','TAOLS','1',to_date('2026/01/27 22:40:08','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601288292','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 22:40:00
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8292,'心血管内科陶林森','上午','1','100534840','韩青松','HAN QING SONG ','男','39','一般人员','自费','','主任号','1','0359','TAOLS','1',to_date('2026/01/27 22:40:08','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601288292','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科陶林森' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8292,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '心血管内科陶林森' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288292</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202601288292</pinkey><ordertime>2026-01-27 22:40:00</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 23:23:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19119669026</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/31 0:00:00_上午_生殖男科富鹤</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>622427199404091616</patientidcard><patientname>文爱斌</patientname><patientsex>男</patientsex><patientbirthday>1994-04-09</patientbirthday><medicalrecord></medicalrecord><contactphone>19119669026</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 23:23:55
记录内容：select * from  pat_master_index where id_no='622427199404091616' and name='文爱斌' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/4/9 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:23:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/31','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:23:55
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/31','YYYY/MM/DD'),8337,'生殖男科富鹤','上午','1','100534845','文爱斌','WEN AI BIN ','男','32','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2026/01/27 23:24:03','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601318337','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 23:23:55
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/31','YYYY/MM/DD'),8337,'生殖男科富鹤','上午','1','100534845','文爱斌','WEN AI BIN ','男','32','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2026/01/27 23:24:03','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601318337','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/31', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '生殖男科富鹤' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/31','YYYY/MM/DD'),8337,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/31','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601318337</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202601318337</pinkey><ordertime>2026-01-27 23:23:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 23:32:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13522481132</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_下午_心理咨询张晶晶</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230306198203225722</patientidcard><patientname>初丹</patientname><patientsex>女</patientsex><patientbirthday>1982-03-22</patientbirthday><medicalrecord></medicalrecord><contactphone>13522481132</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 23:32:45
记录内容：select * from  pat_master_index where id_no='230306198203225722' and name='初丹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/3/22 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:32:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:32:45
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8345,'心理咨询张晶晶','下午','1','00235312','初丹','','女','44','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2026/01/27 23:32:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288345','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 23:32:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8345,'心理咨询张晶晶','下午','1','00235312','初丹','','女','44','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2026/01/27 23:32:52','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288345','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8345,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202601288345</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601288345</pinkey><ordertime>2026-01-27 23:32:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 23:37:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17793252710</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/31 0:00:00_白天_妇科刘冬梅</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>622427199708281689</patientidcard><patientname>师亮亮</patientname><patientsex>女</patientsex><patientbirthday>1997-08-28</patientbirthday><medicalrecord></medicalrecord><contactphone>17793252710</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 23:37:25
记录内容：select * from  pat_master_index where id_no='622427199708281689' and name='师亮亮' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/8/28 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:37:25
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/31','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:37:25
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/31','YYYY/MM/DD'),8349,'妇科刘冬梅','白天','1','100534851','师亮亮','SHI LIANG LIANG ','女','29','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2026/01/27 23:37:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601318349','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 23:37:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/31','YYYY/MM/DD'),8349,'妇科刘冬梅','白天','1','100534851','师亮亮','SHI LIANG LIANG ','女','29','一般人员','自费','','普通号','1','0316','LDM','1',to_date('2026/01/27 23:37:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601318349','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/31', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科刘冬梅' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/31','YYYY/MM/DD'),8349,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/31','yyyy/mm/dd')
                    and clinic_label = '妇科刘冬梅' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202601318349</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601318349</pinkey><ordertime>2026-01-27 23:37:26</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 23:38:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17710458926</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_全科医学吴春明</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>232126199205181234</patientidcard><patientname>王召付</patientname><patientsex>男</patientsex><patientbirthday>1992-05-18</patientbirthday><medicalrecord></medicalrecord><contactphone>17710458926</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 23:38:04
记录内容：select * from  pat_master_index where id_no='232126199205181234' and name='王召付' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/5/18 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:38:04
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '全科医学吴春明' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:38:04
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8351,'全科医学吴春明','上午','2','100534854','王召付','WANG ZHAO FU ','男','34','一般人员','自费','','普通号','1','0396','WCM','1',to_date('2026/01/27 23:38:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288351','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 23:38:04
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8351,'全科医学吴春明','上午','2','100534854','王召付','WANG ZHAO FU ','男','34','一般人员','自费','','普通号','1','0396','WCM','1',to_date('2026/01/27 23:38:12','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288351','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '全科医学吴春明' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8351,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '全科医学吴春明' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288351</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601288351</pinkey><ordertime>2026-01-27 23:38:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-01-27 23:46:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18032643179</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/1/28 0:00:00_上午_消化内科张然</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>13108219870907552X</patientidcard><patientname>张秋丽</patientname><patientsex>女</patientsex><patientbirthday>1987-09-07</patientbirthday><medicalrecord></medicalrecord><contactphone>18032643179</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-01-27 23:46:42
记录内容：select * from  pat_master_index where id_no='13108219870907552X' and name='张秋丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/9/7 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:46:42
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '消化内科张然' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-01-27 23:46:42
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8355,'消化内科张然','上午','4','100534855','张秋丽','ZHANG QIU LI ','女','39','一般人员','自费','','普通号','1','0302','ZHANGR2','1',to_date('2026/01/27 23:46:49','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288355','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-01-27 23:46:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8355,'消化内科张然','上午','4','100534855','张秋丽','ZHANG QIU LI ','女','39','一般人员','自费','','普通号','1','0302','ZHANGR2','1',to_date('2026/01/27 23:46:49','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601288355','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/01/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科张然' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),8355,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/01/28','yyyy/mm/dd')
                    and clinic_label = '消化内科张然' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202601288355</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202601288355</pinkey><ordertime>2026-01-27 23:46:42</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆