◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 07:35:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>16631619985</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/18 0:00:00_白天_妇科谢菲菲</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>32108119970120604X</patientidcard><patientname>朱雅</patientname><patientsex>女</patientsex><patientbirthday>1997-01-20</patientbirthday><medicalrecord></medicalrecord><contactphone>16631619985</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 07:35:03
记录内容：select * from  pat_master_index where id_no='32108119970120604X' and name='朱雅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/1/20 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 07:35:03
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '妇科谢菲菲' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 07:35:03
记录内容： 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/18','YYYY/MM/DD'),9157,'妇科谢菲菲','白天','3','Z00243034','朱雅','ZHU YA','女','29','一般人员','自费','','普通号','1','0316','XFF1','1',to_date('2026/02/18 07:35:10','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602189157','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 07:35: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/02/18','YYYY/MM/DD'),9157,'妇科谢菲菲','白天','3','Z00243034','朱雅','ZHU YA','女','29','一般人员','自费','','普通号','1','0316','XFF1','1',to_date('2026/02/18 07:35:10','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602189157','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/02/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科谢菲菲' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/18','YYYY/MM/DD'),9157,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '妇科谢菲菲' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602189157</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602189157</pinkey><ordertime>2026-02-18 07:35:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 08:38:53
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15210503610</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_心脏康复安立敏</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>372922196601210514</patientidcard><patientname>夏保民</patientname><patientsex>男</patientsex><patientbirthday>1966-01-21</patientbirthday><medicalrecord></medicalrecord><contactphone>15210503610</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 08:38:53
记录内容：select * from  pat_master_index where id_no='372922196601210514' and name='夏保民' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1966/1/21 0:00:0060
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 08:38:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '心脏康复安立敏' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 08:38: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/02/20','YYYY/MM/DD'),9495,'心脏康复安立敏','上午','1','00203932','夏保民','','男','60','一般人员','自费','','主任号','1','0359','ALM','1',to_date('2026/02/18 08:38:59','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602209495','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 08:38: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/02/20','YYYY/MM/DD'),9495,'心脏康复安立敏','上午','1','00203932','夏保民','','男','60','一般人员','自费','','主任号','1','0359','ALM','1',to_date('2026/02/18 08:38:59','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602209495','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/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心脏康复安立敏' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),9495,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '心脏康复安立敏' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602209495</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602209495</pinkey><ordertime>2026-02-18 08:38:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 08:42:41
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18284334934</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/18 0:00:00_上午_普通外科马洪艳</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>511181200711264426</patientidcard><patientname>周姿羽</patientname><patientsex>女</patientsex><patientbirthday>2007-11-26</patientbirthday><medicalrecord></medicalrecord><contactphone>18284334934</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 08:42:41
记录内容：select * from  pat_master_index where id_no='511181200711264426' and name='周姿羽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/11/26 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 08:42:41
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '普通外科马洪艳' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 08:42:41
记录内容： 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/18','YYYY/MM/DD'),9533,'普通外科马洪艳','上午','4','100538497','周姿羽','ZHOU ZI YU ','女','19','一般人员','自费','','普通号','1','0335','MAHY','1',to_date('2026/02/18 08:42:47','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602189533','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 08:42:41
记录内容：<?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/18','YYYY/MM/DD'),9533,'普通外科马洪艳','上午','4','100538497','周姿羽','ZHOU ZI YU ','女','19','一般人员','自费','','普通号','1','0335','MAHY','1',to_date('2026/02/18 08:42:47','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602189533','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/02/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科马洪艳' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/18','YYYY/MM/DD'),9533,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '普通外科马洪艳' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602189533</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602189533</pinkey><ordertime>2026-02-18 08:42:41</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 08:49:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18632694937</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/18 0:00:00_上午_产科王振燕</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131125200110041823</patientidcard><patientname>赵京晓</patientname><patientsex>女</patientsex><patientbirthday>2001-10-04</patientbirthday><medicalrecord></medicalrecord><contactphone>18632694937</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 08:49:22
记录内容：select * from  pat_master_index where id_no='131125200110041823' and name='赵京晓' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/10/4 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 08:49:22
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 08:49: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/02/18','YYYY/MM/DD'),9596,'产科王振燕','上午','13','100512876','赵京晓','ZHAO JING XIAO ','女','25','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2026/02/18 08:49:28','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602189596','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','14') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 08:49: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/02/18','YYYY/MM/DD'),9596,'产科王振燕','上午','13','100512876','赵京晓','ZHAO JING XIAO ','女','25','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2026/02/18 08:49:28','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602189596','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','14') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/18','YYYY/MM/DD'),9596,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602189596</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602189596</pinkey><ordertime>2026-02-18 08:49:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 09:22:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13911888073</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_肿瘤科于平</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230703193608280017</patientidcard><patientname>王明志</patientname><patientsex>男</patientsex><patientbirthday>1936-08-28</patientbirthday><medicalrecord></medicalrecord><contactphone>13911888073</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 09:22:17
记录内容：select * from  pat_master_index where id_no='230703193608280017' and name='王明志' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1936/8/28 0:00:0090
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 09:22:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '肿瘤科于平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 09:22: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/02/22','YYYY/MM/DD'),9885,'肿瘤科于平','上午','1','100538164','王明志','WANG MING ZHI ','男','90','一般人员','自费','','副主任号','1','0338','CYYP','1',to_date('2026/02/18 09:22:23','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602229885','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 09:22: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/02/22','YYYY/MM/DD'),9885,'肿瘤科于平','上午','1','100538164','王明志','WANG MING ZHI ','男','90','一般人员','自费','','副主任号','1','0338','CYYP','1',to_date('2026/02/18 09:22:23','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602229885','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/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '肿瘤科于平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9885,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '肿瘤科于平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602229885</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602229885</pinkey><ordertime>2026-02-18 09:22:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 09:37:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13466549636</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/22 0:00:00_上午_神经内科潘瑞春</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822195709292019</patientidcard><patientname>胡少民</patientname><patientsex>男</patientsex><patientbirthday>1957-09-29</patientbirthday><medicalrecord></medicalrecord><contactphone>13466549636</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 09:37:27
记录内容：select * from  pat_master_index where id_no='132822195709292019' and name='胡少民' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1957/9/29 0:00:0069
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 09:37:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科潘瑞春' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 09:37: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/02/22','YYYY/MM/DD'),9,'神经内科潘瑞春','上午','1','100538501','胡少民','HU SHAO MIN ','男','69','一般人员','自费','','副主任号','1','0303','PANRC','1',to_date('2026/02/18 09:37:33','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602220009','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 09:37:27
记录内容：<?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/22','YYYY/MM/DD'),9,'神经内科潘瑞春','上午','1','100538501','胡少民','HU SHAO MIN ','男','69','一般人员','自费','','副主任号','1','0303','PANRC','1',to_date('2026/02/18 09:37:33','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602220009','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/22', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科潘瑞春' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/22','YYYY/MM/DD'),9,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/22','yyyy/mm/dd')
                    and clinic_label = '神经内科潘瑞春' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602229</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602229</pinkey><ordertime>2026-02-18 09:37:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 09:46:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18284334934</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/18 0:00:00_上午_耳鼻喉科王慎祥</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>511181200711264426</patientidcard><patientname>周姿羽</patientname><patientsex>女</patientsex><patientbirthday>2007-11-26</patientbirthday><medicalrecord></medicalrecord><contactphone>18284334934</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 09:46:02
记录内容：select * from  pat_master_index where id_no='511181200711264426' and name='周姿羽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/11/26 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 09:46:02
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 09:46:02
记录内容： 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/18','YYYY/MM/DD'),70,'耳鼻喉科王慎祥','上午','12','100538497','周姿羽','ZHOU ZI YU ','女','19','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/02/18 09:46:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602180070','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','11') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 09:46:02
记录内容：<?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/18','YYYY/MM/DD'),70,'耳鼻喉科王慎祥','上午','12','100538497','周姿羽','ZHOU ZI YU ','女','19','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/02/18 09:46:08','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602180070','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','11') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/18','YYYY/MM/DD'),70,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>2026021870</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>2026021870</pinkey><ordertime>2026-02-18 09:46:02</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 10:44:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13716199441</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/18 0:00:00_上午_骨科张晓刚</scheduleid><parttimeid>11:30-12:00</parttimeid><certtypeno>1</certtypeno><patientidcard>110102199801161918</patientidcard><patientname>张续昊</patientname><patientsex>男</patientsex><patientbirthday>1998-01-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13716199441</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 10:44:17
记录内容：select * from  pat_master_index where id_no='110102199801161918' and name='张续昊' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1998/1/16 0:00:0028
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 10:44:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '骨科张晓刚' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 10:44: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/02/18','YYYY/MM/DD'),571,'骨科张晓刚','上午','18','100537749','张续昊','ZHANG XU  ','男','28','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2026/02/18 10:44:22','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602180571','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','18') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 10:44: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/02/18','YYYY/MM/DD'),571,'骨科张晓刚','上午','18','100537749','张续昊','ZHANG XU  ','男','28','一般人员','自费','','副主任号','1','0312','ZHANGXG','1',to_date('2026/02/18 10:44:22','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602180571','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','18') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科张晓刚' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/18','YYYY/MM/DD'),571,'11:30-12:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '骨科张晓刚' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20260218571</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>20260218571</pinkey><ordertime>2026-02-18 10:44:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 10:53: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/2/19 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-02-18 10:53: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-02-18 10:53:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '普通外科王进' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 10:53: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/02/19','YYYY/MM/DD'),654,'普通外科王进','上午','1','100534556','孟祥红','MENG XIANG HONG ','女','47','一般人员','自费','','副主任号','1','0335','WJ01','1',to_date('2026/02/18 10:53:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602190654','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 10:53: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/02/19','YYYY/MM/DD'),654,'普通外科王进','上午','1','100534556','孟祥红','MENG XIANG HONG ','女','47','一般人员','自费','','副主任号','1','0335','WJ01','1',to_date('2026/02/18 10:53:51','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602190654','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/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科王进' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),654,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '普通外科王进' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>20260219654</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>20260219654</pinkey><ordertime>2026-02-18 10:53:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 12:14:59
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15732644055</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132821196309233325</patientidcard><patientname>李宝荣</patientname><patientsex>女</patientsex><patientbirthday>1963-09-23</patientbirthday><medicalrecord></medicalrecord><contactphone>15732644055</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 12:14:59
记录内容：select * from  pat_master_index where id_no='132821196309233325' and name='李宝荣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1963/9/23 0:00:0063
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 12:14:59
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 12:14:59
记录内容： 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/19','YYYY/MM/DD'),1006,'内分泌科马伟杰普','上午','1','100538512','李宝荣','LI BAO RONG ','女','63','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/18 12:15:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602191006','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 12:14:59
记录内容：<?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/19','YYYY/MM/DD'),1006,'内分泌科马伟杰普','上午','1','100538512','李宝荣','LI BAO RONG ','女','63','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/18 12:15:04','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602191006','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/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),1006,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602191006</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602191006</pinkey><ordertime>2026-02-18 12:14:59</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 12:37:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13784476849</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/18 0:00:00_下午_呼吸内科高立静普</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132821195211022525</patientidcard><patientname>徐广英</patientname><patientsex>女</patientsex><patientbirthday>1952-11-02</patientbirthday><medicalrecord></medicalrecord><contactphone>13784476849</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 12:37:40
记录内容：select * from  pat_master_index where id_no='132821195211022525' and name='徐广英' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1952/11/2 0:00:0074
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 12:37:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静普' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 12:37:40
记录内容： 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/18','YYYY/MM/DD'),1014,'呼吸内科高立静普','下午','1','100538513','徐广英','XU GUANG YING ','女','74','一般人员','自费','','普通号','1','0317','GLJ','1',to_date('2026/02/18 12:37:45','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602181014','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 12:37:40
记录内容：<?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/18','YYYY/MM/DD'),1014,'呼吸内科高立静普','下午','1','100538513','徐广英','XU GUANG YING ','女','74','一般人员','自费','','普通号','1','0317','GLJ','1',to_date('2026/02/18 12:37:45','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602181014','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/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/18','YYYY/MM/DD'),1014,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静普' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602181014</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602181014</pinkey><ordertime>2026-02-18 12:37:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 15:12:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17611401391</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/28 0:00:00_上午_神经内科王卫</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>142725195408127234</patientidcard><patientname>闫满全</patientname><patientsex>男</patientsex><patientbirthday>1954-08-12</patientbirthday><medicalrecord></medicalrecord><contactphone>17611401391</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 15:12:06
记录内容：select * from  pat_master_index where id_no='142725195408127234' and name='闫满全' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1954/8/12 0:00:0072
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:12:06
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/28','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:12:06
记录内容： 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/28','YYYY/MM/DD'),1676,'神经内科王卫','上午','2','00093423','闫满全','YAN MAN QUAN','男','72','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2026/02/18 15:12:10','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602281676','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 15:12:06
记录内容：<?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/28','YYYY/MM/DD'),1676,'神经内科王卫','上午','2','00093423','闫满全','YAN MAN QUAN','男','72','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2026/02/18 15:12:10','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602281676','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/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科王卫' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/28','YYYY/MM/DD'),1676,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/28','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602281676</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202602281676</pinkey><ordertime>2026-02-18 15:12:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 15:25:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18331637680</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_白天_妇科丁圆</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082196411051024</patientidcard><patientname>孟宪月</patientname><patientsex>女</patientsex><patientbirthday>1964-11-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18331637680</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 15:25:39
记录内容：select * from  pat_master_index where id_no='131082196411051024' and name='孟宪月' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1964/11/5 0:00:0062
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:25:39
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:25:39
记录内容： 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/19','YYYY/MM/DD'),1811,'妇科丁圆','白天','2','100527818','孟宪月','MENG XIAN YUE','女','62','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2026/02/18 15:25:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602191811','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 15:25:39
记录内容：<?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/19','YYYY/MM/DD'),1811,'妇科丁圆','白天','2','100527818','孟宪月','MENG XIAN YUE','女','62','一般人员','自费','','普通号','1','0316','DINGY','1',to_date('2026/02/18 15:25:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602191811','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/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科丁圆' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),1811,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '妇科丁圆' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602191811</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602191811</pinkey><ordertime>2026-02-18 15:25:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 15:33:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17778029286</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/18 0:00:00_下午_耳鼻喉科王慎祥</scheduleid><parttimeid>16:00-16:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230221200402205212</patientidcard><patientname>胡名芳</patientname><patientsex>男</patientsex><patientbirthday>2004-02-20</patientbirthday><medicalrecord></medicalrecord><contactphone>17778029286</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 15:33:57
记录内容：select * from  pat_master_index where id_no='230221200402205212' and name='胡名芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2004/2/20 0:00:0022
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:33:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:33: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/02/18','YYYY/MM/DD'),1863,'耳鼻喉科王慎祥','下午','12','100537753','胡名芳','HU MING FANG ','男','22','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/02/18 15:34:01','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602181863','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','28') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 15:33: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/02/18','YYYY/MM/DD'),1863,'耳鼻喉科王慎祥','下午','12','100537753','胡名芳','HU MING FANG ','男','22','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/02/18 15:34:01','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602181863','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','28') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2026/02/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/18','YYYY/MM/DD'),1863,'16:00-16:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/18','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602181863</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602181863</pinkey><ordertime>2026-02-18 15:33:57</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 15:34:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17330161811</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_白天_妇科王兰</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152223200006192223</patientidcard><patientname>李美娜</patientname><patientsex>女</patientsex><patientbirthday>2000-06-19</patientbirthday><medicalrecord></medicalrecord><contactphone>17330161811</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 15:34:33
记录内容：select * from  pat_master_index where id_no='152223200006192223' and name='李美娜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/6/19 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:34:33
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:34:33
记录内容： 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/19','YYYY/MM/DD'),1868,'妇科王兰','白天','3','10249482','李美娜','LI MEI NA','女','26','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/02/18 15:34:37','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602191868','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 15:34:33
记录内容：<?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/19','YYYY/MM/DD'),1868,'妇科王兰','白天','3','10249482','李美娜','LI MEI NA','女','26','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/02/18 15:34:37','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602191868','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),1868,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602191868</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602191868</pinkey><ordertime>2026-02-18 15:34:33</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 15:41:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13290656516</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_神经外科包双喜</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130221196911137649</patientidcard><patientname>王凤玲</patientname><patientsex>女</patientsex><patientbirthday>1969-11-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13290656516</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 15:41:46
记录内容：select * from  pat_master_index where id_no='130221196911137649' and name='王凤玲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/11/13 0:00:0057
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:41:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '神经外科包双喜' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 15:41: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/02/19','YYYY/MM/DD'),1924,'神经外科包双喜','上午','2','100538562','王凤玲','WANG FENG LING ','女','57','一般人员','自费','','副主任号','1','0313','BSX','1',to_date('2026/02/18 15:41:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602191924','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 15:41: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/02/19','YYYY/MM/DD'),1924,'神经外科包双喜','上午','2','100538562','王凤玲','WANG FENG LING ','女','57','一般人员','自费','','副主任号','1','0313','BSX','1',to_date('2026/02/18 15:41:50','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602191924','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经外科包双喜' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),1924,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '神经外科包双喜' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602191924</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602191924</pinkey><ordertime>2026-02-18 15:41:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 16:16:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18745163842</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>16:30-17:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230127200204052828</patientidcard><patientname>吴可欣</patientname><patientsex>女</patientsex><patientbirthday>2002-04-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18745163842</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2026-02-18 16:16:44
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2026/02/19','YYYY-MM-DD')
            AND CLINIC_LABEL='皮肤科常庆华' AND TIME_DESC='下午'0select * from  pat_master_index where id_no='230127200204052828' and name='吴可欣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 16:16:44
记录内容：<?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-02-18 16:34:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15601331114</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/23 0:00:00_上午_疼痛科刘金龙</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>110105194509160017</patientidcard><patientname>秦惟永</patientname><patientsex>男</patientsex><patientbirthday>1945-09-16</patientbirthday><medicalrecord></medicalrecord><contactphone>15601331114</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 16:34:29
记录内容：select * from  pat_master_index where id_no='110105194509160017' and name='秦惟永' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1945/9/16 0:00:0081
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 16:34:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '疼痛科刘金龙' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 16:34: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/02/23','YYYY/MM/DD'),2221,'疼痛科刘金龙','上午','2','100528210','秦惟永','QIN WEI YONG ','男','81','一般人员','自费','','副主任号','1','0332','LJL1','1',to_date('2026/02/18 16:34:33','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602232221','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 16:34: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/02/23','YYYY/MM/DD'),2221,'疼痛科刘金龙','上午','2','100528210','秦惟永','QIN WEI YONG ','男','81','一般人员','自费','','副主任号','1','0332','LJL1','1',to_date('2026/02/18 16:34:33','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602232221','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/23', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '疼痛科刘金龙' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/23','YYYY/MM/DD'),2221,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/23','yyyy/mm/dd')
                    and clinic_label = '疼痛科刘金龙' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602232221</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602232221</pinkey><ordertime>2026-02-18 16:34:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 17:43:11
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17807603720</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_泌尿外科张家兴专</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>440514200209211321</patientidcard><patientname>陈燕旋</patientname><patientsex>女</patientsex><patientbirthday>2002-09-21</patientbirthday><medicalrecord></medicalrecord><contactphone>17807603720</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 17:43:11
记录内容：select * from  pat_master_index where id_no='440514200209211321' and name='陈燕旋' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/9/21 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 17:43:11
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '泌尿外科张家兴专' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 17:43: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/02/20','YYYY/MM/DD'),2348,'泌尿外科张家兴专','上午','2','100518053','陈燕旋','CHEN YAN XUAN ','女','24','一般人员','自费','','副主任号','1','0311','ZHANGJX','1',to_date('2026/02/18 17:43:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602202348','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 17:43: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/02/20','YYYY/MM/DD'),2348,'泌尿外科张家兴专','上午','2','100518053','陈燕旋','CHEN YAN XUAN ','女','24','一般人员','自费','','副主任号','1','0311','ZHANGJX','1',to_date('2026/02/18 17:43:15','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602202348','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/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科张家兴专' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),2348,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '泌尿外科张家兴专' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602202348</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602202348</pinkey><ordertime>2026-02-18 17:43:11</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 18:53:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18633777567</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220283199111221927</patientidcard><patientname>林佰竹</patientname><patientsex>女</patientsex><patientbirthday>1991-11-22</patientbirthday><medicalrecord></medicalrecord><contactphone>18633777567</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 18:53:40
记录内容：select * from  pat_master_index where id_no='220283199111221927' and name='林佰竹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/11/22 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 18:53:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 18:53:40
记录内容： 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/19','YYYY/MM/DD'),2435,'内分泌科马伟杰普','上午','2','10369229','林佰竹','','女','35','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/18 18:53:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192435','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 18:53:40
记录内容：<?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/19','YYYY/MM/DD'),2435,'内分泌科马伟杰普','上午','2','10369229','林佰竹','','女','35','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/18 18:53:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192435','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2435,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192435</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602192435</pinkey><ordertime>2026-02-18 18:53:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 19:08:23
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17731679446</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_白天_妇科王兰</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082199602220787</patientidcard><patientname>王婉钰</patientname><patientsex>女</patientsex><patientbirthday>1996-02-22</patientbirthday><medicalrecord></medicalrecord><contactphone>17731679446</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 19:08:23
记录内容：select * from  pat_master_index where id_no='131082199602220787' and name='王婉钰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/2/22 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 19:08:23
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 19:08:23
记录内容： 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/19','YYYY/MM/DD'),2452,'妇科王兰','白天','5','100538568','王婉钰','WANG WAN  ','女','30','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/02/18 19:08:27','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192452','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 19:08:23
记录内容：<?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/19','YYYY/MM/DD'),2452,'妇科王兰','白天','5','100538568','王婉钰','WANG WAN  ','女','30','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/02/18 19:08:27','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192452','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2452,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202602192452</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602192452</pinkey><ordertime>2026-02-18 19:08:23</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 20:11:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15146691520</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_内分泌科马伟杰普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230230197012172322</patientidcard><patientname>孔祥杰</patientname><patientsex>女</patientsex><patientbirthday>1970-12-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15146691520</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 20:11:32
记录内容：select * from  pat_master_index where id_no='230230197012172322' and name='孔祥杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/12/17 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:11:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:11:32
记录内容： 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/19','YYYY/MM/DD'),2522,'内分泌科马伟杰普','上午','3','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/18 20:11:35','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192522','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 20:11:32
记录内容：<?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/19','YYYY/MM/DD'),2522,'内分泌科马伟杰普','上午','3','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/02/18 20:11:35','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192522','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2522,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192522</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602192522</pinkey><ordertime>2026-02-18 20:11:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 20:13:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15146691520</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_风湿免疫科王沛然</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230230197012172322</patientidcard><patientname>孔祥杰</patientname><patientsex>女</patientsex><patientbirthday>1970-12-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15146691520</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 20:13:04
记录内容：select * from  pat_master_index where id_no='230230197012172322' and name='孔祥杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/12/17 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:13:04
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科王沛然' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:13: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/02/19','YYYY/MM/DD'),2523,'风湿免疫科王沛然','上午','1','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0337','WPR01','1',to_date('2026/02/18 20:13:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192523','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 20:13: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/02/19','YYYY/MM/DD'),2523,'风湿免疫科王沛然','上午','1','100538317','孔祥杰','KONG XIANG JIE ','女','56','一般人员','自费','','普通号','1','0337','WPR01','1',to_date('2026/02/18 20:13:07','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192523','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/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '风湿免疫科王沛然' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2523,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科王沛然' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192523</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602192523</pinkey><ordertime>2026-02-18 20:13:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 20:27:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13853711136</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_心血管内科郭晓光</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>372927195305160011</patientidcard><patientname>栾忠云</patientname><patientsex>男</patientsex><patientbirthday>1953-05-16</patientbirthday><medicalrecord></medicalrecord><contactphone>13853711136</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 20:27:53
记录内容：select * from  pat_master_index where id_no='372927195305160011' and name='栾忠云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1953/5/16 0:00:0073
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:27:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '心血管内科郭晓光' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:27: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/02/19','YYYY/MM/DD'),2541,'心血管内科郭晓光','上午','1','100538569','栾忠云',' ZHONG YUN ','男','73','一般人员','自费','','副主任号','1','0359','GXG','1',to_date('2026/02/18 20:27:55','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192541','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 20:27: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/02/19','YYYY/MM/DD'),2541,'心血管内科郭晓光','上午','1','100538569','栾忠云',' ZHONG YUN ','男','73','一般人员','自费','','副主任号','1','0359','GXG','1',to_date('2026/02/18 20:27:55','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192541','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/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心血管内科郭晓光' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2541,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '心血管内科郭晓光' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192541</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602192541</pinkey><ordertime>2026-02-18 20:27:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 20:36:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19931604399</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/20 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230221200111020226</patientidcard><patientname>刘静怡</patientname><patientsex>女</patientsex><patientbirthday>2001-11-02</patientbirthday><medicalrecord></medicalrecord><contactphone>19931604399</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 20:36:59
记录内容：select * from  pat_master_index where id_no='230221200111020226' and name='刘静怡' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/11/2 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:36:59
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:36:59
记录内容： 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/20','YYYY/MM/DD'),2542,'骨科刘兴超','上午','1','100538570','刘静怡','LIU JING  ','女','25','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/18 20:37:01','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602202542','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 20:36:59
记录内容：<?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/20','YYYY/MM/DD'),2542,'骨科刘兴超','上午','1','100538570','刘静怡','LIU JING  ','女','25','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/18 20:37:01','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602202542','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/20', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/20','YYYY/MM/DD'),2542,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/20','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602202542</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602202542</pinkey><ordertime>2026-02-18 20:36:59</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 20:38:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15731622782</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/21 0:00:00_上午_骨科刘兴超</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130133197001200332</patientidcard><patientname>李东华</patientname><patientsex>男</patientsex><patientbirthday>1970-01-20</patientbirthday><medicalrecord></medicalrecord><contactphone>15731622782</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 20:38:31
记录内容：select * from  pat_master_index where id_no='130133197001200332' and name='李东华' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/1/20 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:38:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:38: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/02/21','YYYY/MM/DD'),2543,'骨科刘兴超','上午','1','100538571','李东华','LI DONG HUA ','男','56','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/18 20:38:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602212543','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 20:38: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/02/21','YYYY/MM/DD'),2543,'骨科刘兴超','上午','1','100538571','李东华','LI DONG HUA ','男','56','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2026/02/18 20:38:34','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602212543','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/21', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘兴超' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/21','YYYY/MM/DD'),2543,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/21','yyyy/mm/dd')
                    and clinic_label = '骨科刘兴超' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602212543</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602212543</pinkey><ordertime>2026-02-18 20:38:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 20:56:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19931604399</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230221200111020226</patientidcard><patientname>刘静怡</patientname><patientsex>女</patientsex><patientbirthday>2001-11-02</patientbirthday><medicalrecord></medicalrecord><contactphone>19931604399</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 20:56:14
记录内容：select * from  pat_master_index where id_no='230221200111020226' and name='刘静怡' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/11/2 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:56:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 20:56:14
记录内容： 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/19','YYYY/MM/DD'),2558,'骨科刘海峰','上午','2','100538570','刘静怡','LIU JING  ','女','25','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/18 20:56:17','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602192558','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 20:56:14
记录内容：<?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/19','YYYY/MM/DD'),2558,'骨科刘海峰','上午','2','100538570','刘静怡','LIU JING  ','女','25','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/02/18 20:56:17','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602192558','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2558,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192558</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602192558</pinkey><ordertime>2026-02-18 20:56:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 21:14:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15076677995</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/24 0:00:00_上午_儿童内分泌陈树新</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>341221201308144872</patientidcard><patientname>张子阳</patientname><patientsex>男</patientsex><patientbirthday>2013-08-14</patientbirthday><medicalrecord></medicalrecord><contactphone>15076677995</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 21:14:24
记录内容：select * from  pat_master_index where id_no='341221201308144872' and name='张子阳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2013/8/14 0:00:0013
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 21:14:24
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '儿童内分泌陈树新' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 21:14:24
记录内容： 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/24','YYYY/MM/DD'),2578,'儿童内分泌陈树新','上午','1','100425944','张子阳','ZHANG ZI YANG ','男','13','一般人员','自费','','知名专家','1','0304','EYCSX','1',to_date('2026/02/18 21:14:27','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602242578','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 21:14:24
记录内容：<?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/24','YYYY/MM/DD'),2578,'儿童内分泌陈树新','上午','1','100425944','张子阳','ZHANG ZI YANG ','男','13','一般人员','自费','','知名专家','1','0304','EYCSX','1',to_date('2026/02/18 21:14:27','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202602242578','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/24', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿童内分泌陈树新' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/24','YYYY/MM/DD'),2578,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/24','yyyy/mm/dd')
                    and clinic_label = '儿童内分泌陈树新' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602242578</orderid><reservefee>0.00</reservefee><clinicfee>100</clinicfee><registrationfee>0</registrationfee><pinkey>202602242578</pinkey><ordertime>2026-02-18 21:14:24</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 21:19:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17611302511</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_耳鼻喉科郭庆  普</scheduleid><parttimeid>8:00-8:30</parttimeid><certtypeno>1</certtypeno><patientidcard>231083197911213661</patientidcard><patientname>张桂敏</patientname><patientsex>女</patientsex><patientbirthday>1979-11-21</patientbirthday><medicalrecord></medicalrecord><contactphone>17611302511</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 21:19:40
记录内容：select * from  pat_master_index where id_no='231083197911213661' and name='张桂敏' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1979/11/21 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 21:19:40
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 21:19:40
记录内容： 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/19','YYYY/MM/DD'),2580,'耳鼻喉科郭庆  普','上午','8','100343983','张桂敏','ZHANG GUI MIN ','女','47','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/18 21:19:42','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192580','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 21:19:40
记录内容：<?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/19','YYYY/MM/DD'),2580,'耳鼻喉科郭庆  普','上午','8','100343983','张桂敏','ZHANG GUI MIN ','女','47','一般人员','自费','','普通号','1','0306','GQ','1',to_date('2026/02/18 21:19:42','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202602192580','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科郭庆  普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2580,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科郭庆  普' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192580</orderid><reservefee>0.00</reservefee><clinicfee>15</clinicfee><registrationfee>0</registrationfee><pinkey>202602192580</pinkey><ordertime>2026-02-18 21:19:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 22:16:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17774913200</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_呼吸内科王莉</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>152122195504110328</patientidcard><patientname>孙秀红</patientname><patientsex>女</patientsex><patientbirthday>1955-04-11</patientbirthday><medicalrecord></medicalrecord><contactphone>17774913200</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 22:16:55
记录内容：select * from  pat_master_index where id_no='152122195504110328' and name='孙秀红' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1955/4/11 0:00:0071
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 22:16:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 22:16: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/02/19','YYYY/MM/DD'),2592,'呼吸内科王莉','上午','1','Z00487792','孙秀红','','女','71','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/02/18 22:16:58','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602192592','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 22:16: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/02/19','YYYY/MM/DD'),2592,'呼吸内科王莉','上午','1','Z00487792','孙秀红','','女','71','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/02/18 22:16:58','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202602192592','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/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科王莉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2592,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '呼吸内科王莉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192592</orderid><reservefee>0.00</reservefee><clinicfee>30</clinicfee><registrationfee>0</registrationfee><pinkey>202602192592</pinkey><ordertime>2026-02-18 22:16:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 22:23:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13521066786</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_上午_皮肤科常庆华</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130633198812045462</patientidcard><patientname>李园园</patientname><patientsex>女</patientsex><patientbirthday>1988-12-04</patientbirthday><medicalrecord></medicalrecord><contactphone>13521066786</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 22:23:57
记录内容：select * from  pat_master_index where id_no='130633198812045462' and name='李园园' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1988/12/4 0:00:0038
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 22:23:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 22:23: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/02/19','YYYY/MM/DD'),2596,'皮肤科常庆华','上午','7','100534429','李园园','LI YUAN YUAN ','女','38','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/18 22:23:59','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192596','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 22:23: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/02/19','YYYY/MM/DD'),2596,'皮肤科常庆华','上午','7','100534429','李园园','LI YUAN YUAN ','女','38','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/18 22:23:59','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192596','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2596,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202602192596</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602192596</pinkey><ordertime>2026-02-18 22:23:57</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2026-02-18 22:36:59
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17333563107</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_白天_妇科王兰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200005210527</patientidcard><patientname>窦晓飞</patientname><patientsex>女</patientsex><patientbirthday>2000-05-21</patientbirthday><medicalrecord></medicalrecord><contactphone>17333563107</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2026-02-18 22:36:59
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2026/02/19','YYYY-MM-DD')
            AND CLINIC_LABEL='妇科王兰' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='131082200005210527' and name='窦晓飞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 22:36:59
记录内容：<?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-02-18 22:47:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15622522539</reservemobile><hospitalid>1001</hospitalid><scheduleid>2026/2/19 0:00:00_下午_皮肤科常庆华</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>622725199102100330</patientidcard><patientname>张博强</patientname><patientsex>男</patientsex><patientbirthday>1991-02-10</patientbirthday><medicalrecord></medicalrecord><contactphone>15622522539</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2026-02-18 22:47:56
记录内容：select * from  pat_master_index where id_no='622725199102100330' and name='张博强' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/2/10 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 22:47:56
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2026-02-18 22:47:56
记录内容： 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/19','YYYY/MM/DD'),2605,'皮肤科常庆华','下午','3','Z00480714','张博强','','男','35','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/18 22:47:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192605','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2026-02-18 22:47:56
记录内容：<?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/19','YYYY/MM/DD'),2605,'皮肤科常庆华','下午','3','Z00480714','张博强','','男','35','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/02/18 22:47:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602192605','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/02/19', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/19','YYYY/MM/DD'),2605,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2026/02/19','yyyy/mm/dd')
                    and clinic_label = '皮肤科常庆华' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202602192605</orderid><reservefee>0.00</reservefee><clinicfee>20</clinicfee><registrationfee>0</registrationfee><pinkey>202602192605</pinkey><ordertime>2026-02-18 22:47:56</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆