◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 01:18:25 记录内容：cyys_2017@123cyys_2017@1231829474297010012026/1/28 0:00:00_上午_妇科李广太主任号10:00-10:301622628200103182947贾彦玲女2001-03-18182947429701 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 01:18:25 记录内容：select * from pat_master_index where id_no='622628200103182947' and name='贾彦玲' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2001/3/18 0:00:0025 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 01:18:25 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '妇科李广太主任号' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 01:18:25 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6292,'妇科李广太主任号','上午','1','100534634','贾彦玲','JIA YAN LING ','女','25','一般人员','自费','','主任号','1','0316','LGT01','1',to_date('2026/01/27 01:18:31','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601286292','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 01:18:25 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6292,'妇科李广太主任号','上午','1','100534634','贾彦玲','JIA YAN LING ','女','25','一般人员','自费','','主任号','1','0316','LGT01','1',to_date('2026/01/27 01:18:31','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601286292','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/28', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科李广太主任号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6292,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '妇科李广太主任号' and visit_time_desc = '上午'）2026012862920.003002026012862922026-01-27 01:18:250 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 01:23:16 记录内容：cyys_2017@123cyys_2017@1231803366583210012026/1/27 0:00:00_上午_内分泌科马伟杰普8:30-9:001511226198204218020刘雪莲女1982-04-21180336658321 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 01:23:16 记录内容：select * from pat_master_index where id_no='511226198204218020' and name='刘雪莲' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1982/4/21 0:00:0044 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 01:23:16 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 01:23:16 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6294,'内分泌科马伟杰普','上午','3','10565954','刘雪莲','LIU XUE LIAN','女','44','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/01/27 01:23:22','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601276294','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 01:23:16 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6294,'内分泌科马伟杰普','上午','3','10565954','刘雪莲','LIU XUE LIAN','女','44','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/01/27 01:23:22','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601276294','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6294,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）2026012762940.001502026012762942026-01-27 01:23:160 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 04:28:53 记录内容：cyys_2017@123cyys_2017@1231933168642910012026/1/27 0:00:00_上午_皮肤科常庆华9:00-9:301131028200105026825蔡心雨女2001-05-02193316864291 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 04:28:53 记录内容：select * from pat_master_index where id_no='131028200105026825' and name='蔡心雨' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2001/5/2 0:00:0025 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 04:28:53 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 04:28:53 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6341,'皮肤科常庆华','上午','11','100534635','蔡心雨','CAI XIN YU ','女','25','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/01/27 04:29:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601276341','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 04:28:53 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6341,'皮肤科常庆华','上午','11','100534635','蔡心雨','CAI XIN YU ','女','25','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/01/27 04:29:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601276341','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6341,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）2026012763410.002002026012763412026-01-27 04:28:530 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 07:47:14 记录内容：cyys_2017@123cyys_2017@1231323162071210012026/1/27 0:00:00_上午_便民门诊常辰8:30-9:001230281198707121323常新秋女1987-07-12132316207121 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 07:47:14 记录内容：select * from pat_master_index where id_no='230281198707121323' and name='常新秋' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1987/7/12 0:00:0039 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 07:47:14 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '便民门诊常辰' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 07:47: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/01/27','YYYY/MM/DD'),6536,'便民门诊常辰','上午','2','Z00300568','常新秋','','女','39','一般人员','自费','','便民号','1','0396','CC01','1',to_date('2026/01/27 07:47:26','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202601276536','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 07:47:14 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6536,'便民门诊常辰','上午','2','Z00300568','常新秋','','女','39','一般人员','自费','','便民号','1','0396','CC01','1',to_date('2026/01/27 07:47:26','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202601276536','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '便民门诊常辰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6536,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '便民门诊常辰' and visit_time_desc = '上午'）2026012765360.00102026012765362026-01-27 07:47:140 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 08:03:31 记录内容：cyys_2017@123cyys_2017@1231861051078410012026/1/27 0:00:00_白天_妇科王兰13:00-13:301370722195608122843魏加英女1956-08-12186105107841 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 08:03:32 记录内容：select * from pat_master_index where id_no='370722195608122843' and name='魏加英' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1956/8/12 0:00:0070 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:03:32 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科王兰' and visit_time_desc = '白天' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:03: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/01/27','YYYY/MM/DD'),6678,'妇科王兰','白天','11','100056241','魏加英','','女','70','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/01/27 08:03:43','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601276678','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 08:03:32 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6678,'妇科王兰','白天','11','100056241','魏加英','','女','70','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2026/01/27 08:03:43','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601276678','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6678,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科王兰' and visit_time_desc = '白天'）2026012766780.002002026012766782026-01-27 08:03:320 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 08:09:27 记录内容：cyys_2017@123cyys_2017@1231501071899310012026/1/27 0:00:00_上午_甲状腺乳腺王新远8:30-9:001130828198203253522魏春梅女1982-03-25150107189931 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 08:09:27 记录内容：select * from pat_master_index where id_no='130828198203253522' and name='魏春梅' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1982/3/25 0:00:0044 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:09:27 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '甲状腺乳腺王新远' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:09:27 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6794,'甲状腺乳腺王新远','上午','8','100534648','魏春梅','WEI CHUN MEI ','女','44','一般人员','自费','','主任号','1','0335','WXY001','1',to_date('2026/01/27 08:09:39','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601276794','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 08:09:27 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6794,'甲状腺乳腺王新远','上午','8','100534648','魏春梅','WEI CHUN MEI ','女','44','一般人员','自费','','主任号','1','0335','WXY001','1',to_date('2026/01/27 08:09:39','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601276794','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '甲状腺乳腺王新远' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),6794,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '甲状腺乳腺王新远' and visit_time_desc = '上午'）2026012767940.003002026012767942026-01-27 08:09:270 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 08:36:27 记录内容：cyys_2017@123cyys_2017@1231361110903610012026/1/27 0:00:00_上午_消化内科王玲9:00-9:301130731199210202026张月女1992-10-20136111090361 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 08:36:27 记录内容：select * from pat_master_index where id_no='130731199210202026' and name='张月' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1992/10/20 0:00:0034 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:36:27 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科王玲' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:36:27 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),7646,'消化内科王玲','上午','39','10524608','张月','','女','34','一般人员','自费','','副主任号','1','0302','WL01','1',to_date('2026/01/27 08:36:38','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601277646','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 08:36:27 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),7646,'消化内科王玲','上午','39','10524608','张月','','女','34','一般人员','自费','','副主任号','1','0302','WL01','1',to_date('2026/01/27 08:36:38','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601277646','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '消化内科王玲' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),7646,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科王玲' and visit_time_desc = '上午'）2026012776460.002002026012776462026-01-27 08:36:270 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 08:45:53 记录内容：cyys_2017@123cyys_2017@1231475534258010012026/1/27 0:00:00_白天_妇科陈海霞9:30-10:001342623200208282320季芳宇女2002-08-28147553425801 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 08:45:53 记录内容：select * from pat_master_index where id_no='342623200208282320' and name='季芳宇' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2002/8/28 0:00:0024 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:45:53 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 08:45:53 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),7960,'妇科陈海霞','白天','14','100454817','季芳宇','JI FANG YU ','女','24','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 08:46:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601277960','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 08:45:53 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),7960,'妇科陈海霞','白天','14','100454817','季芳宇','JI FANG YU ','女','24','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 08:46:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601277960','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),7960,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）2026012779600.002002026012779602026-01-27 08:45:530 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 09:19:17 记录内容：cyys_2017@123cyys_2017@1231329269966110012026/1/27 0:00:00_下午_耳鼻喉科王慎祥13:00-13:301132628198005074524陈东女1980-05-07132926996611 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 09:19:17 记录内容：select * from pat_master_index where id_no='132628198005074524' and name='陈东' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1980/5/7 0:00:0046 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:19:17 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:19:17 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9123,'耳鼻喉科王慎祥','下午','1','100533413','陈东','CHEN DONG ','女','46','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 09:19:28','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601279123','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 09:19:17 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9123,'耳鼻喉科王慎祥','下午','1','100533413','陈东','CHEN DONG ','女','46','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 09:19:28','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601279123','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9123,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午'）2026012791230.001502026012791232026-01-27 09:19:170 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 09:23:01 记录内容：cyys_2017@123cyys_2017@1231330117552910012026/1/27 0:00:00_上午_康复医学科王张立9:30-10:001110223196805142339王建民男1968-05-14133011755291 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 09:23:01 记录内容：select * from pat_master_index where id_no='110223196805142339' and name='王建民' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1968/5/14 0:00:0058 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:23:01 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '康复医学科王张立' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:23:01 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9237,'康复医学科王张立','上午','1','100534685','王建民','WANG JIAN MIN ','男','58','一般人员','自费','','副主任号','1','0314','WANGZL','1',to_date('2026/01/27 09:23:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601279237','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 09:23:01 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9237,'康复医学科王张立','上午','1','100534685','王建民','WANG JIAN MIN ','男','58','一般人员','自费','','副主任号','1','0314','WANGZL','1',to_date('2026/01/27 09:23:12','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601279237','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '康复医学科王张立' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9237,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '康复医学科王张立' and visit_time_desc = '上午'）2026012792370.002002026012792372026-01-27 09:23:010 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 09:29:05 记录内容：cyys_2017@123cyys_2017@1231860024359310012026/1/27 0:00:00_上午_消化内科吴东方10:30-11:001232130196609221926翟桂兰女1966-09-22186002435931 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 09:29:05 记录内容：select * from pat_master_index where id_no='232130196609221926' and name='翟桂兰' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1966/9/22 0:00:0060 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:29:05 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科吴东方' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:29:05 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9455,'消化内科吴东方','上午','19','100534686','翟桂兰','DI GUI LAN ','女','60','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2026/01/27 09:29:16','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601279455','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','24') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 09:29:05 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9455,'消化内科吴东方','上午','19','100534686','翟桂兰','DI GUI LAN ','女','60','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2026/01/27 09:29:16','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601279455','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','24') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '消化内科吴东方' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9455,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'）2026012794550.0010002026012794552026-01-27 09:29:050 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 09:39:15 记录内容：cyys_2017@123cyys_2017@1231803517496710012026/1/27 0:00:00_上午_神经外科杨明琪11:00-11:301142727199411270091许慰慰男1994-11-27180351749671 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 09:39:15 记录内容：select * from pat_master_index where id_no='142727199411270091' and name='许慰慰' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1994/11/27 0:00:0032 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:39:15 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '神经外科杨明琪' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:39:15 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9778,'神经外科杨明琪','上午','9','100477984','许慰慰','XU WEI WEI','男','32','一般人员','自费','','主任号','1','0313','TTYMQ','1',to_date('2026/01/27 09:39:26','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601279778','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 09:39:15 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9778,'神经外科杨明琪','上午','9','100477984','许慰慰','XU WEI WEI','男','32','一般人员','自费','','主任号','1','0313','TTYMQ','1',to_date('2026/01/27 09:39:26','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601279778','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '神经外科杨明琪' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),9778,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '神经外科杨明琪' and visit_time_desc = '上午'）2026012797780.003002026012797782026-01-27 09:39:150 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 09:42:10 记录内容：cyys_2017@123cyys_2017@1231368141487610012026/1/27 0:00:00_上午_心血管内安立敏普10:00-10:301321119196904025461常金花女1969-04-02136814148761 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：没有找到患者或号源为0 记录时间：2026-01-27 09:42:10 记录内容：=!=挂号失败：号源：！1;人员：0select * from clinic_for_regist where clinic_date=to_date('2026/01/27','YYYY-MM-DD') AND CLINIC_LABEL='心血管内安立敏普' AND TIME_DESC='上午'0select * from pat_master_index where id_no='321119196904025461' and name='常金花' and CHARGE_TYPE='自费' order by CREATE_DATE desc ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 09:42:10 记录内容：0挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号! ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 09:53:40 记录内容：cyys_2017@123cyys_2017@1231533427428610012026/1/27 0:00:00_上午_颈肩腰腿痛刘海峰10:00-10:301360425198707052013熊辉男1987-07-05153342742861 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 09:53:40 记录内容：select * from pat_master_index where id_no='360425198707052013' and name='熊辉' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1987/7/5 0:00:0039 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:53:40 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09: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/01/27','YYYY/MM/DD'),236,'颈肩腰腿痛刘海峰','上午','14','10627135','熊辉','','男','39','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 09:53:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601270236','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','15') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 09:53:40 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),236,'颈肩腰腿痛刘海峰','上午','14','10627135','熊辉','','男','39','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 09:53:51','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601270236','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','15') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '颈肩腰腿痛刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),236,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'）202601272360.00300202601272362026-01-27 09:53:400 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 09:59:22 记录内容：cyys_2017@123cyys_2017@1231854702156910012026/1/28 0:00:00_上午_生殖科李丹丹8:00-8:301152126199102120949周琪女1991-02-12185470215691 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 09:59:22 记录内容：select * from pat_master_index where id_no='152126199102120949' and name='周琪' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1991/2/12 0:00:0035 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:59:22 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '生殖科李丹丹' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 09:59:22 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),429,'生殖科李丹丹','上午','1','100368401','周琪','ZHOU ','女','35','一般人员','自费','','普通号','1','0371','LDD','1',to_date('2026/01/27 09:59:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601280429','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 09:59:22 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),429,'生殖科李丹丹','上午','1','100368401','周琪','ZHOU ','女','35','一般人员','自费','','普通号','1','0371','LDD','1',to_date('2026/01/27 09:59:33','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601280429','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/28', 'YYYY-MM-DD') AND CLINIC_LABEL = '生殖科李丹丹' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),429,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '生殖科李丹丹' and visit_time_desc = '上午'）202601284290.00150202601284292026-01-27 09:59:220 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:00:52 记录内容：cyys_2017@123cyys_2017@1231773161703110012026/1/27 0:00:00_上午_风湿免疫科薛利敏10:30-11:001130724199201012817魏学强男1992-01-01177316170311 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:00:53 记录内容：select * from pat_master_index where id_no='130724199201012817' and name='魏学强' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1992/1/1 0:00:0034 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:00:53 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '风湿免疫科薛利敏' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:00:53 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),470,'风湿免疫科薛利敏','上午','19','Z00435180','魏学强','','男','34','一般人员','自费','','副主任号','1','0337','XUELM','1',to_date('2026/01/27 10:01:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601270470','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','19') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:00:53 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),470,'风湿免疫科薛利敏','上午','19','Z00435180','魏学强','','男','34','一般人员','自费','','副主任号','1','0337','XUELM','1',to_date('2026/01/27 10:01:04','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601270470','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','19') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '风湿免疫科薛利敏' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),470,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '风湿免疫科薛利敏' and visit_time_desc = '上午'）202601274700.00200202601274702026-01-27 10:00:530 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:15:47 记录内容：cyys_2017@123cyys_2017@1231891094880910012026/1/27 0:00:00_上午_皮肤科常庆华10:30-11:001230107198404110011王超男1984-04-11189109488091 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:15:47 记录内容：select * from pat_master_index where id_no='230107198404110011' and name='王超' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1984/4/11 0:00:0042 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:15:47 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:15:47 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),975,'皮肤科常庆华','上午','22','10438834','王超','WANG CHAO','男','42','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/01/27 10:15:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601270975','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','22') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:15:47 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),975,'皮肤科常庆华','上午','22','10438834','王超','WANG CHAO','男','42','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/01/27 10:15:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601270975','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','22') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),975,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）202601279750.00200202601279752026-01-27 10:15:470 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:17:17 记录内容：cyys_2017@123cyys_2017@1231879426327710012026/1/29 0:00:00_下午_生殖男科富鹤13:00-13:30162242719891002709X王军平男1989-10-02187942632771 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:17:17 记录内容：select * from pat_master_index where id_no='62242719891002709X' and name='王军平' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1989/10/2 0:00:0037 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:17:17 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/29','yyyy/mm/dd') and clinic_label = '生殖男科富鹤' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:17:17 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),1022,'生殖男科富鹤','下午','1','10722802','王军平','','男','37','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2026/01/27 10:17:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601291022','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:17:17 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),1022,'生殖男科富鹤','下午','1','10722802','王军平','','男','37','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2026/01/27 10:17:28','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601291022','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/29', 'YYYY-MM-DD') AND CLINIC_LABEL = '生殖男科富鹤' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/29','YYYY/MM/DD'),1022,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/29','yyyy/mm/dd') and clinic_label = '生殖男科富鹤' and visit_time_desc = '下午'）2026012910220.002002026012910222026-01-27 10:17:170 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:17:44 记录内容：cyys_2017@123cyys_2017@1231550114076910012026/1/27 0:00:00_上午_消化内科吴东方10:30-11:001410222196402171527张现霞女1964-02-17155011407691 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:17:44 记录内容：select * from pat_master_index where id_no='410222196402171527' and name='张现霞' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1964/2/17 0:00:0062 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:17:44 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科吴东方' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:17:44 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1040,'消化内科吴东方','上午','24','100534695','张现霞','ZHANG XIAN XIA ','女','62','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2026/01/27 10:17:55','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601271040','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','29') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:17:44 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1040,'消化内科吴东方','上午','24','100534695','张现霞','ZHANG XIAN XIA ','女','62','一般人员','自费','','知名专家','1','0302','CYWDF','1',to_date('2026/01/27 10:17:55','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601271040','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','29') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '消化内科吴东方' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1040,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科吴东方' and visit_time_desc = '上午'）2026012710400.0010002026012710402026-01-27 10:17:440 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:20:14 记录内容：cyys_2017@123cyys_2017@1231879426327710012026/1/29 0:00:00_下午_便民门诊吴春明13:30-14:00162242719891002709X王军平男1989-10-02187942632771 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:20:14 记录内容：select * from pat_master_index where id_no='62242719891002709X' and name='王军平' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1989/10/2 0:00:0037 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:20:14 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/29','yyyy/mm/dd') and clinic_label = '便民门诊吴春明' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:20: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/01/29','YYYY/MM/DD'),1124,'便民门诊吴春明','下午','1','10722802','王军平','','男','37','一般人员','自费','','便民号','1','0396','WCM','1',to_date('2026/01/27 10:20:26','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202601291124','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:20:15 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),1124,'便民门诊吴春明','下午','1','10722802','王军平','','男','37','一般人员','自费','','便民号','1','0396','WCM','1',to_date('2026/01/27 10:20:26','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202601291124','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/29', 'YYYY-MM-DD') AND CLINIC_LABEL = '便民门诊吴春明' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/29','YYYY/MM/DD'),1124,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/29','yyyy/mm/dd') and clinic_label = '便民门诊吴春明' and visit_time_desc = '下午'）2026012911240.00102026012911242026-01-27 10:20:150 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:21:38 记录内容：cyys_2017@123cyys_2017@1231781031734210012026/1/27 0:00:00_上午_便民门诊吴春明10:30-11:001230206198904111116肖明儒男1989-04-11178103173421 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:21:38 记录内容：select * from pat_master_index where id_no='230206198904111116' and name='肖明儒' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1989/4/11 0:00:0037 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:21:38 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '便民门诊吴春明' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:21:38 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1190,'便民门诊吴春明','上午','13','Z00281391','肖明儒','','男','37','一般人员','自费','','便民号','1','0396','WCM','1',to_date('2026/01/27 10:21:49','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202601271190','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','13') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:21:38 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1190,'便民门诊吴春明','上午','13','Z00281391','肖明儒','','男','37','一般人员','自费','','便民号','1','0396','WCM','1',to_date('2026/01/27 10:21:49','yyyy/mm/dd hh24:mi:ss'),'0','1','0.00','1','202601271190','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','13') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '便民门诊吴春明' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1190,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '便民门诊吴春明' and visit_time_desc = '上午'）2026012711900.00102026012711902026-01-27 10:21:380 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:22:57 记录内容：cyys_2017@123cyys_2017@1231338106185910012026/1/30 0:00:00_上午_头晕门诊杨春景8:00-8:30122040319640603055X常万林男1964-06-03133810618591 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:22:57 记录内容：select * from pat_master_index where id_no='22040319640603055X' and name='常万林' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1964/6/3 0:00:0062 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:22:57 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/30','yyyy/mm/dd') and clinic_label = '头晕门诊杨春景' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:22:57 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/30','YYYY/MM/DD'),1227,'头晕门诊杨春景','上午','1','Z00427161','常万林','CHANG WAN LIN','男','62','一般人员','自费','','副主任号','1','0303','YCJ','1',to_date('2026/01/27 10:23:08','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601301227','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:22:57 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/30','YYYY/MM/DD'),1227,'头晕门诊杨春景','上午','1','Z00427161','常万林','CHANG WAN LIN','男','62','一般人员','自费','','副主任号','1','0303','YCJ','1',to_date('2026/01/27 10:23:08','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601301227','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/30', 'YYYY-MM-DD') AND CLINIC_LABEL = '头晕门诊杨春景' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/30','YYYY/MM/DD'),1227,'8:00-8:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/30','yyyy/mm/dd') and clinic_label = '头晕门诊杨春景' and visit_time_desc = '上午'）2026013012270.002002026013012272026-01-27 10:22:570 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:32:10 记录内容：cyys_2017@123cyys_2017@1231532159078510012026/1/27 0:00:00_上午_耳鼻喉科王慎祥11:00-11:301410482196408175024郭彦芳女1964-08-17153215907851 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:32:10 记录内容：select * from pat_master_index where id_no='410482196408175024' and name='郭彦芳' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1964/8/17 0:00:0062 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:32:10 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:32:10 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1499,'耳鼻喉科王慎祥','上午','22','100534263','郭彦芳','GUO YAN FANG ','女','62','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 10:32:21','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601271499','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','20') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:32:10 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1499,'耳鼻喉科王慎祥','上午','22','100534263','郭彦芳','GUO YAN FANG ','女','62','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 10:32:21','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601271499','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','20') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1499,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'）2026012714990.001502026012714992026-01-27 10:32:100 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:35:32 记录内容：cyys_2017@123cyys_2017@1231883264300610012026/1/27 0:00:00_上午_产科周雪静副主任11:30-12:001131082198802161027王立军女1988-02-16188326430061 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:35:32 记录内容：select * from pat_master_index where id_no='131082198802161027' and name='王立军' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1988/2/16 0:00:0038 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:35:32 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '产科周雪静副主任' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:35: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/01/27','YYYY/MM/DD'),1594,'产科周雪静副主任','上午','20','10104303','王立军','','女','38','一般人员','自费','','副主任号','1','0330','ZHOUXJ','1',to_date('2026/01/27 10:35:43','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601271594','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','21') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:35:32 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1594,'产科周雪静副主任','上午','20','10104303','王立军','','女','38','一般人员','自费','','副主任号','1','0330','ZHOUXJ','1',to_date('2026/01/27 10:35:43','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601271594','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','21') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '产科周雪静副主任' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1594,'11:30-12:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '产科周雪静副主任' and visit_time_desc = '上午'）2026012715940.002002026012715942026-01-27 10:35:320 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:37:52 记录内容：cyys_2017@123cyys_2017@1231330135658210012026/1/27 0:00:00_上午_颈肩腰腿痛刘海峰11:00-11:301150426195402286082吴玉芝女1954-02-28133013565821 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:37:52 记录内容：select * from pat_master_index where id_no='150426195402286082' and name='吴玉芝' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1954/2/28 0:00:0072 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:37:52 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:37:52 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1664,'颈肩腰腿痛刘海峰','上午','18','100529360','吴玉芝','WU YU ZHI ','女','72','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 10:38:03','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601271664','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','19') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:37:52 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1664,'颈肩腰腿痛刘海峰','上午','18','100529360','吴玉芝','WU YU ZHI ','女','72','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 10:38:03','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601271664','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','19') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '颈肩腰腿痛刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1664,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'）2026012716640.003002026012716642026-01-27 10:37:520 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:42:22 记录内容：cyys_2017@123cyys_2017@1231393165052510012026/1/27 0:00:00_下午_放射介入富孝晨14:30-15:001132822196211141218杨光远男1962-11-14139316505251 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:42:22 记录内容：select * from pat_master_index where id_no='132822196211141218' and name='杨光远' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1962/11/14 0:00:0064 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:42:22 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '放射介入富孝晨' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:42:22 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1779,'放射介入富孝晨','下午','1','10509023','杨光远','','男','64','一般人员','自费','','副主任号','1','0384','FXC','1',to_date('2026/01/27 10:42:33','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601271779','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:42:22 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1779,'放射介入富孝晨','下午','1','10509023','杨光远','','男','64','一般人员','自费','','副主任号','1','0384','FXC','1',to_date('2026/01/27 10:42:33','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601271779','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '放射介入富孝晨' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1779,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '放射介入富孝晨' and visit_time_desc = '下午'）2026012717790.002002026012717792026-01-27 10:42:220 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:42:48 记录内容：cyys_2017@123cyys_2017@1231891094880910012026/1/27 0:00:00_上午_耳鼻喉科韩仲明11:30-12:001230107198404110011王超男1984-04-11189109488091 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:42:48 记录内容：select * from pat_master_index where id_no='230107198404110011' and name='王超' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1984/4/11 0:00:0042 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:42:48 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科韩仲明' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:42:48 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1788,'耳鼻喉科韩仲明','上午','10','10438834','王超','WANG CHAO','男','42','一般人员','自费','','知名专家','1','0306','HANZM','1',to_date('2026/01/27 10:42:59','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601271788','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:42:48 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1788,'耳鼻喉科韩仲明','上午','10','10438834','王超','WANG CHAO','男','42','一般人员','自费','','知名专家','1','0306','HANZM','1',to_date('2026/01/27 10:42:59','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601271788','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '耳鼻喉科韩仲明' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),1788,'11:30-12:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科韩仲明' and visit_time_desc = '上午'）2026012717880.0010002026012717882026-01-27 10:42:480 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:46:34 记录内容：cyys_2017@123cyys_2017@1231593160674410012026/1/31 0:00:00_上午_中医科陈光献9:30-10:00113108219861202411X杨文明男1986-12-02159316067441 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:46:34 记录内容：select * from pat_master_index where id_no='13108219861202411X' and name='杨文明' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1986/12/2 0:00:0040 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:46:34 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/31','yyyy/mm/dd') and clinic_label = '中医科陈光献' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:46:34 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/31','YYYY/MM/DD'),1893,'中医科陈光献','上午','1','00118503','杨文明','','男','40','一般人员','自费','','中副主任','1','0301','CGXIAN','1',to_date('2026/01/27 10:46:45','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601311893','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:46:35 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/31','YYYY/MM/DD'),1893,'中医科陈光献','上午','1','00118503','杨文明','','男','40','一般人员','自费','','中副主任','1','0301','CGXIAN','1',to_date('2026/01/27 10:46:45','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601311893','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/31', 'YYYY-MM-DD') AND CLINIC_LABEL = '中医科陈光献' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/31','YYYY/MM/DD'),1893,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/31','yyyy/mm/dd') and clinic_label = '中医科陈光献' and visit_time_desc = '上午'）2026013118930.003002026013118932026-01-27 10:46:350 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:52:45 记录内容：cyys_2017@123cyys_2017@1231732028097310012026/1/27 0:00:00_上午_颈肩腰腿痛刘海峰11:00-11:301152201198206051064金美玲女1982-06-05173202809731 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:52:46 记录内容：select * from pat_master_index where id_no='152201198206051064' and name='金美玲' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1982/6/5 0:00:0044 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:52:46 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:52:46 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2093,'颈肩腰腿痛刘海峰','上午','20','Z00421424','金美玲','','女','44','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 10:52:57','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601272093','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','21') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:52:46 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2093,'颈肩腰腿痛刘海峰','上午','20','Z00421424','金美玲','','女','44','一般人员','自费','','主任号','1','0312','LIUHF','1',to_date('2026/01/27 10:52:57','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601272093','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','21') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '颈肩腰腿痛刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2093,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '颈肩腰腿痛刘海峰' and visit_time_desc = '上午'）2026012720930.003002026012720932026-01-27 10:52:460 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:57:42 记录内容：cyys_2017@123cyys_2017@1231521051927810012026/1/27 0:00:00_上午_内分泌科马伟杰普11:00-11:301341221198610205811薛强男1986-10-20152105192781 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:57:42 记录内容：select * from pat_master_index where id_no='341221198610205811' and name='薛强' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1986/10/20 0:00:0040 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:57:42 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:57:42 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2250,'内分泌科马伟杰普','上午','31','100533931','薛强','XUE QIANG ','男','40','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/01/27 10:57:53','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601272250','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','33') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:57:42 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2250,'内分泌科马伟杰普','上午','31','100533931','薛强','XUE QIANG ','男','40','一般人员','自费','','普通号','1','0315','MAWJ','1',to_date('2026/01/27 10:57:53','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601272250','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','33') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '内分泌科马伟杰普' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2250,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '内分泌科马伟杰普' and visit_time_desc = '上午'）2026012722500.001502026012722502026-01-27 10:57:420 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 10:59:47 记录内容：cyys_2017@123cyys_2017@1231663063719610012026/1/27 0:00:00_白天_妇科陈海霞11:30-12:001131028199611201221胡新爽女1996-11-20166306371961 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 10:59:48 记录内容：select * from pat_master_index where id_no='131028199611201221' and name='胡新爽' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1996/11/20 0:00:0030 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:59:48 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 10:59:48 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2300,'妇科陈海霞','白天','24','100534703','胡新爽','HU XIN SHUANG ','女','30','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 10:59:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601272300','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','22') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 10:59:48 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2300,'妇科陈海霞','白天','24','100534703','胡新爽','HU XIN SHUANG ','女','30','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 10:59:58','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601272300','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','22') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2300,'11:30-12:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）2026012723000.002002026012723002026-01-27 10:59:480 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:22:07 记录内容：cyys_2017@123cyys_2017@1231840149720810012026/1/29 0:00:00_上午_皮肤科常庆华9:30-10:001440804199012100220别晨玮女1990-12-10184014972081 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:22:07 记录内容：select * from pat_master_index where id_no='440804199012100220' and name='别晨玮' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1990/12/10 0:00:0036 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:22:07 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/29','yyyy/mm/dd') and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:22:07 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),2870,'皮肤科常庆华','上午','1','00296354','别晨玮','','女','36','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/01/27 11:22:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601292870','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:22:08 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/29','YYYY/MM/DD'),2870,'皮肤科常庆华','上午','1','00296354','别晨玮','','女','36','一般人员','自费','','副主任号','1','0318','CQH','1',to_date('2026/01/27 11:22:18','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601292870','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/29', 'YYYY-MM-DD') AND CLINIC_LABEL = '皮肤科常庆华' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/29','YYYY/MM/DD'),2870,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/29','yyyy/mm/dd') and clinic_label = '皮肤科常庆华' and visit_time_desc = '上午'）2026012928700.002002026012928702026-01-27 11:22:080 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:22:29 记录内容：cyys_2017@123cyys_2017@1231855127216410012026/1/27 0:00:00_下午_肿瘤科于平15:00-15:30115210419630615126X姜杰女1963-06-15185512721641 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:22:29 记录内容：select * from pat_master_index where id_no='15210419630615126X' and name='姜杰' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1963/6/15 0:00:0063 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:22:29 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '肿瘤科于平' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:22:29 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2878,'肿瘤科于平','下午','1','10762663','姜杰','JIANG JIE','女','63','一般人员','自费','','副主任号','1','0338','CYYP','1',to_date('2026/01/27 11:22:40','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601272878','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:22:29 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2878,'肿瘤科于平','下午','1','10762663','姜杰','JIANG JIE','女','63','一般人员','自费','','副主任号','1','0338','CYYP','1',to_date('2026/01/27 11:22:40','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601272878','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '肿瘤科于平' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),2878,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '肿瘤科于平' and visit_time_desc = '下午'）2026012728780.002002026012728782026-01-27 11:22:290 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:26:28 记录内容：cyys_2017@123cyys_2017@1231332327580610012026/1/30 0:00:00_上午_耳鼻喉科王慎祥11:30-12:001130982200112316122冯晓惠女2001-12-31133232758061 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:26:28 记录内容：select * from pat_master_index where id_no='130982200112316122' and name='冯晓惠' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2001/12/31 0:00:0025 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:26:28 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/30','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:26:28 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/30','YYYY/MM/DD'),2983,'耳鼻喉科王慎祥','上午','1','100534345','冯晓惠','FENG XIAO HUI ','女','25','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 11:26:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601302983','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:26:28 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/30','YYYY/MM/DD'),2983,'耳鼻喉科王慎祥','上午','1','100534345','冯晓惠','FENG XIAO HUI ','女','25','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 11:26:39','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601302983','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/30', 'YYYY-MM-DD') AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/30','YYYY/MM/DD'),2983,'11:30-12:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/30','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '上午'）2026013029830.001502026013029832026-01-27 11:26:280 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:33:13 记录内容：cyys_2017@123cyys_2017@1231510153558310012026/1/27 0:00:00_下午_肾病科刘航13:00-13:301512501194410147421刘衍照女1944-10-14151015355831 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:33:13 记录内容：select * from pat_master_index where id_no='512501194410147421' and name='刘衍照' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1944/10/14 0:00:0082 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:33:13 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '肾病科刘航' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:33:13 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3127,'肾病科刘航','下午','4','100534706','刘衍照','LIU YAN ZHAO ','女','82','一般人员','自费','','主任号','1','0333','LIUH','1',to_date('2026/01/27 11:33:24','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601273127','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:33:13 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3127,'肾病科刘航','下午','4','100534706','刘衍照','LIU YAN ZHAO ','女','82','一般人员','自费','','主任号','1','0333','LIUH','1',to_date('2026/01/27 11:33:24','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601273127','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '肾病科刘航' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3127,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '肾病科刘航' and visit_time_desc = '下午'）2026012731270.003002026012731272026-01-27 11:33:130 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:34:32 记录内容：cyys_2017@123cyys_2017@1231521026404710012026/1/27 0:00:00_下午_心理咨询张晶晶16:00-16:301231223201005240098贾慧铧男2010-05-24152102640471 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:34:32 记录内容：select * from pat_master_index where id_no='231223201005240098' and name='贾慧铧' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2010/5/24 0:00:0016 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:34:32 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:34: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/01/27','YYYY/MM/DD'),3152,'心理咨询张晶晶','下午','4','M00114978','贾慧铧','GU HUI HUA','男','16','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2026/01/27 11:34:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601273152','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:34:32 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3152,'心理咨询张晶晶','下午','4','M00114978','贾慧铧','GU HUI HUA','男','16','一般人员','自费','','普通号','1','0360','ZJJ01','1',to_date('2026/01/27 11:34:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601273152','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '心理咨询张晶晶' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3152,'16:00-16:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '心理咨询张晶晶' and visit_time_desc = '下午'）2026012731520.001502026012731522026-01-27 11:34:320 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:39:12 记录内容：cyys_2017@123cyys_2017@1231510153558310012026/1/27 0:00:00_下午_皮肤科杨维玲14:00-14:30113073320120425122X宋紫涵女2012-04-25151015355831 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:39:13 记录内容：select * from pat_master_index where id_no='13073320120425122X' and name='宋紫涵' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2012/4/25 0:00:0014 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:39:13 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '皮肤科杨维玲' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:39:13 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3216,'皮肤科杨维玲','下午','1','100534707','宋紫涵','SONG ZI HAN ','女','14','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/01/27 11:39:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601273216','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:39:13 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3216,'皮肤科杨维玲','下午','1','100534707','宋紫涵','SONG ZI HAN ','女','14','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2026/01/27 11:39:23','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601273216','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3216,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '皮肤科杨维玲' and visit_time_desc = '下午'）2026012732160.0010002026012732162026-01-27 11:39:130 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:55:51 记录内容：cyys_2017@123cyys_2017@1231581122402810012026/1/27 0:00:00_下午_甲状腺乳腺王新远13:00-13:301222405194812173228李今兰女1948-12-17158112240281 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:55:51 记录内容：select * from pat_master_index where id_no='222405194812173228' and name='李今兰' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1948/12/17 0:00:0078 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:55:51 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '甲状腺乳腺王新远' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:55:51 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3433,'甲状腺乳腺王新远','下午','1','10412746','李今兰','LI JIN LAN','女','78','一般人员','自费','','主任号','1','0335','WXY001','1',to_date('2026/01/27 11:56:01','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601273433','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:55:51 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3433,'甲状腺乳腺王新远','下午','1','10412746','李今兰','LI JIN LAN','女','78','一般人员','自费','','主任号','1','0335','WXY001','1',to_date('2026/01/27 11:56:01','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601273433','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '甲状腺乳腺王新远' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3433,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '甲状腺乳腺王新远' and visit_time_desc = '下午'）2026012734330.003002026012734332026-01-27 11:55:510 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 11:59:39 记录内容：cyys_2017@123cyys_2017@1231771652197210012026/1/27 0:00:00_下午_神经内科杨志华13:00-13:301230231200102124958费宏坤男2001-02-12177165219721 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 11:59:39 记录内容：select * from pat_master_index where id_no='230231200102124958' and name='费宏坤' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2001/2/12 0:00:0025 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:59:39 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '神经内科杨志华' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 11:59: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/01/27','YYYY/MM/DD'),3470,'神经内科杨志华','下午','1','100058874','费宏坤','FEI HONG KUN','男','25','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/01/27 11:59:50','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601273470','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 11:59:39 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3470,'神经内科杨志华','下午','1','100058874','费宏坤','FEI HONG KUN','男','25','一般人员','自费','','普通号','1','0303','YANGZHIH','1',to_date('2026/01/27 11:59:50','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601273470','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '神经内科杨志华' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3470,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '神经内科杨志华' and visit_time_desc = '下午'）2026012734700.001502026012734702026-01-27 11:59:390 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 12:38:42 记录内容：cyys_2017@123cyys_2017@1231873260509110012026/1/31 0:00:00_上午_消化内科梁毅8:30-9:001132822196905142020张崇秀女1969-05-14187326050911 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：没有找到患者或号源为0 记录时间：2026-01-27 12:38:42 记录内容：=!=挂号失败：号源：！1;人员：0select * from clinic_for_regist where clinic_date=to_date('2026/01/31','YYYY-MM-DD') AND CLINIC_LABEL='消化内科梁毅' AND TIME_DESC='上午'0select * from pat_master_index where id_no='132822196905142020' and name='张崇秀' and CHARGE_TYPE='自费' order by CREATE_DATE desc ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 12:38:42 记录内容：0挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号! ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 12:40:28 记录内容：cyys_2017@123cyys_2017@1231873260509110012026/1/31 0:00:00_上午_消化内科梁毅9:00-9:301132822196905142020张崇秀女1969-05-14187326050911 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：没有找到患者或号源为0 记录时间：2026-01-27 12:40:29 记录内容：=!=挂号失败：号源：！1;人员：0select * from clinic_for_regist where clinic_date=to_date('2026/01/31','YYYY-MM-DD') AND CLINIC_LABEL='消化内科梁毅' AND TIME_DESC='上午'0select * from pat_master_index where id_no='132822196905142020' and name='张崇秀' and CHARGE_TYPE='自费' order by CREATE_DATE desc ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 12:40:29 记录内容：0挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号! ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 12:50:38 记录内容：cyys_2017@123cyys_2017@1231522669649810012026/1/27 0:00:00_下午_耳鼻喉科王慎祥13:00-13:301131082199912102567张婷女1999-12-10152266964981 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 12:50:38 记录内容：select * from pat_master_index where id_no='131082199912102567' and name='张婷' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1999/12/10 0:00:0027 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 12:50:38 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 12:50:38 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3653,'耳鼻喉科王慎祥','下午','3','100139374','张婷','ZHANG TING','女','27','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 12:50:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601273653','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','29') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 12:50:38 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3653,'耳鼻喉科王慎祥','下午','3','100139374','张婷','ZHANG TING','女','27','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 12:50:48','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601273653','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','29') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3653,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午'）2026012736530.001502026012736532026-01-27 12:50:380 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 12:58:56 记录内容：cyys_2017@123cyys_2017@1231312693800410012026/1/27 0:00:00_下午_呼吸内科王莉13:30-14:00122240120021112217X朴振铭男2002-11-12131269380041 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 12:58:56 记录内容：select * from pat_master_index where id_no='22240120021112217X' and name='朴振铭' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2002/11/12 0:00:0024 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 12:58:56 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '呼吸内科王莉' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 12:58: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/01/27','YYYY/MM/DD'),3678,'呼吸内科王莉','下午','2','100534629','朴振铭','PU ZHEN MING ','男','24','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/01/27 12:59:07','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601273678','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 12:58:56 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3678,'呼吸内科王莉','下午','2','100534629','朴振铭','PU ZHEN MING ','男','24','一般人员','自费','','主任号','1','0317','WANGLI1','1',to_date('2026/01/27 12:59:07','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601273678','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '呼吸内科王莉' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3678,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '呼吸内科王莉' and visit_time_desc = '下午'）2026012736780.003002026012736782026-01-27 12:58:560 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:00:03 记录内容：cyys_2017@123cyys_2017@1231358264897010012026/1/27 0:00:00_下午_消化内科王玲13:00-13:301612321197112146115肖兴华男1971-12-14135826489701 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 13:00:03 记录内容：select * from pat_master_index where id_no='612321197112146115' and name='肖兴华' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1971/12/14 0:00:0055 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:00:03 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科王玲' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:00: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/01/27','YYYY/MM/DD'),3681,'消化内科王玲','下午','1','Z00534077','肖兴华','','男','55','一般人员','自费','','副主任号','1','0302','WL01','1',to_date('2026/01/27 13:00:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601273681','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:00:04 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3681,'消化内科王玲','下午','1','Z00534077','肖兴华','','男','55','一般人员','自费','','副主任号','1','0302','WL01','1',to_date('2026/01/27 13:00:14','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601273681','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '消化内科王玲' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3681,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '消化内科王玲' and visit_time_desc = '下午'）2026012736810.002002026012736812026-01-27 13:00:040 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:02:14 记录内容：cyys_2017@123cyys_2017@1231879476134810012026/1/27 0:00:00_下午_中医男科乔晋琳14:00-14:301420881198507244052刘容男1985-07-24187947613481 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 13:02:14 记录内容：select * from pat_master_index where id_no='420881198507244052' and name='刘容' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1985/7/24 0:00:0041 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:02:14 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '中医男科乔晋琳' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:02: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/01/27','YYYY/MM/DD'),3695,'中医男科乔晋琳','下午','1','10615117','刘容','','男','41','一般人员','自费','','知名专家','1','0301','QJL','1',to_date('2026/01/27 13:02:25','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601273695','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:02:15 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3695,'中医男科乔晋琳','下午','1','10615117','刘容','','男','41','一般人员','自费','','知名专家','1','0301','QJL','1',to_date('2026/01/27 13:02:25','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601273695','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '中医男科乔晋琳' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3695,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '中医男科乔晋琳' and visit_time_desc = '下午'）2026012736950.0010002026012736952026-01-27 13:02:150 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:08:30 记录内容：cyys_2017@123cyys_2017@1231521051927810012026/2/2 0:00:00_下午_神经外科米杜秋13:00-13:301341221198610205811薛强男1986-10-20152105192781 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 13:08:30 记录内容：select * from pat_master_index where id_no='341221198610205811' and name='薛强' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1986/10/20 0:00:0040 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:08:30 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/02/02','yyyy/mm/dd') and clinic_label = '神经外科米杜秋' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:08:30 记录内容： 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/02','YYYY/MM/DD'),3801,'神经外科米杜秋','下午','1','100533931','薛强','XUE QIANG ','男','40','一般人员','自费','','副主任号','1','0313','MDQ','1',to_date('2026/01/27 13:08:40','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602023801','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:08:30 记录内容：1成功（影响条数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/02','YYYY/MM/DD'),3801,'神经外科米杜秋','下午','1','100533931','薛强','XUE QIANG ','男','40','一般人员','自费','','副主任号','1','0313','MDQ','1',to_date('2026/01/27 13:08:40','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202602023801','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/02', 'YYYY-MM-DD') AND CLINIC_LABEL = '神经外科米杜秋' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/02/02','YYYY/MM/DD'),3801,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/02/02','yyyy/mm/dd') and clinic_label = '神经外科米杜秋' and visit_time_desc = '下午'）2026020238010.002002026020238012026-01-27 13:08:300 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:08:53 记录内容：cyys_2017@123cyys_2017@1231873260509110012026/1/31 0:00:00_上午_消化内科梁毅8:30-9:001132822196905142020张崇秀女1969-05-14187326050911 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：没有找到患者或号源为0 记录时间：2026-01-27 13:08:53 记录内容：=!=挂号失败：号源：！1;人员：0select * from clinic_for_regist where clinic_date=to_date('2026/01/31','YYYY-MM-DD') AND CLINIC_LABEL='消化内科梁毅' AND TIME_DESC='上午'0select * from pat_master_index where id_no='132822196905142020' and name='张崇秀' and CHARGE_TYPE='自费' order by CREATE_DATE desc ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:08:53 记录内容：0挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号! ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:11:30 记录内容：cyys_2017@123cyys_2017@1231521051927810012026/1/27 0:00:00_下午_肿瘤微创刘亚宁14:00-14:301341221198610205811薛强男1986-10-20152105192781 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 13:11:30 记录内容：select * from pat_master_index where id_no='341221198610205811' and name='薛强' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1986/10/20 0:00:0040 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:11:30 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '肿瘤微创刘亚宁' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:11:30 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3853,'肿瘤微创刘亚宁','下午','3','100533931','薛强','XUE QIANG ','男','40','一般人员','自费','','副主任号','1','0338','LIUYN1','1',to_date('2026/01/27 13:11:41','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601273853','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:11:30 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3853,'肿瘤微创刘亚宁','下午','3','100533931','薛强','XUE QIANG ','男','40','一般人员','自费','','副主任号','1','0338','LIUYN1','1',to_date('2026/01/27 13:11:41','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601273853','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '肿瘤微创刘亚宁' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3853,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '肿瘤微创刘亚宁' and visit_time_desc = '下午'）2026012738530.002002026012738532026-01-27 13:11:300 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:18:54 记录内容：cyys_2017@123cyys_2017@1231891124245910012026/1/27 0:00:00_白天_妇科陈海霞14:30-15:001110102199212181523鹿宇婷女1992-12-18189112424591 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 13:18:54 记录内容：select * from pat_master_index where id_no='110102199212181523' and name='鹿宇婷' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1992/12/18 0:00:0034 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:18:54 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:18:54 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3993,'妇科陈海霞','白天','28','100534737','鹿宇婷','LU YU ','女','34','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 13:19:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601273993','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','28') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:18:54 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3993,'妇科陈海霞','白天','28','100534737','鹿宇婷','LU YU ','女','34','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 13:19:05','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601273993','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/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),3993,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）2026012739930.002002026012739932026-01-27 13:18:540 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:42:16 记录内容：cyys_2017@123cyys_2017@1231590148373110012026/1/27 0:00:00_下午_心血管内郭晓光普14:00-14:301222401198603021239金雄豪男1986-03-02159014837311 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 13:42:17 记录内容：select * from pat_master_index where id_no='222401198603021239' and name='金雄豪' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1986/3/2 0:00:0040 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:42:17 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '心血管内郭晓光普' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:42:17 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),4463,'心血管内郭晓光普','下午','7','Z00219427','金雄豪','','男','40','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2026/01/27 13:42:27','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601274463','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','29') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:42:17 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),4463,'心血管内郭晓光普','下午','7','Z00219427','金雄豪','','男','40','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2026/01/27 13:42:27','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601274463','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','29') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '心血管内郭晓光普' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),4463,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '心血管内郭晓光普' and visit_time_desc = '下午'）2026012744630.001502026012744632026-01-27 13:42:170 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 13:45:03 记录内容：cyys_2017@123cyys_2017@1231891124245910012026/1/27 0:00:00_白天_妇科陈海霞14:00-14:301230204199302280010苏云峰男1993-02-28189112424591 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 13:45:03 记录内容：select * from pat_master_index where id_no='230204199302280010' and name='苏云峰' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1993/2/28 0:00:0033 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:45:03 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 13:45: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/01/27','YYYY/MM/DD'),4524,'妇科陈海霞','白天','31','10780606','苏云峰','','男','33','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 13:45:13','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601274524','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','31') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 13:45:03 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),4524,'妇科陈海霞','白天','31','10780606','苏云峰','','男','33','一般人员','自费','','副主任号','1','0316','CHX','1',to_date('2026/01/27 13:45:13','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601274524','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','31') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科陈海霞' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),4524,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '妇科陈海霞' and visit_time_desc = '白天'）2026012745240.002002026012745242026-01-27 13:45:030 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 14:12:40 记录内容：cyys_2017@123cyys_2017@1231312693800410012026/1/27 0:00:00_下午_耳鼻喉科王慎祥14:30-15:00122240120021112217X朴振铭男2002-11-12131269380041 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 14:12:40 记录内容：select * from pat_master_index where id_no='22240120021112217X' and name='朴振铭' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2002/11/12 0:00:0024 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 14:12:40 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 14:12: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/01/27','YYYY/MM/DD'),5066,'耳鼻喉科王慎祥','下午','17','100534629','朴振铭','PU ZHEN MING ','男','24','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 14:12:50','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601275066','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','43') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 14:12:40 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/27','YYYY/MM/DD'),5066,'耳鼻喉科王慎祥','下午','17','100534629','朴振铭','PU ZHEN MING ','男','24','一般人员','自费','','普通号','1','0306','WSX01','1',to_date('2026/01/27 14:12:50','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601275066','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','43') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/27', 'YYYY-MM-DD') AND CLINIC_LABEL = '耳鼻喉科王慎祥' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/27','YYYY/MM/DD'),5066,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/27','yyyy/mm/dd') and clinic_label = '耳鼻喉科王慎祥' and visit_time_desc = '下午'）2026012750660.001502026012750662026-01-27 14:12:400 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 14:20:01 记录内容：cyys_2017@123cyys_2017@1231751518818710012026/1/28 0:00:00_上午_眼科张仲臣10:00-10:30137240219760111601X贾明喜男1976-01-11175151881871 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 14:20:01 记录内容：select * from pat_master_index where id_no='37240219760111601X' and name='贾明喜' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1976/1/11 0:00:0050 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 14:20:01 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '眼科张仲臣' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 14:20:01 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5210,'眼科张仲臣','上午','12','DP029490','贾明喜','GU MING XI','男','50','一般人员','自费','','知名专家','1','0327','ZHANGZC','1',to_date('2026/01/27 14:20:11','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601285210','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 14:20:01 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5210,'眼科张仲臣','上午','12','DP029490','贾明喜','GU MING XI','男','50','一般人员','自费','','知名专家','1','0327','ZHANGZC','1',to_date('2026/01/27 14:20:11','yyyy/mm/dd hh24:mi:ss'),'0','100','0.00','100','202601285210','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/28', 'YYYY-MM-DD') AND CLINIC_LABEL = '眼科张仲臣' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5210,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '眼科张仲臣' and visit_time_desc = '上午'）2026012852100.0010002026012852102026-01-27 14:20:010 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 14:36:55 记录内容：cyys_2017@123cyys_2017@1231851175912010012026/1/28 0:00:00_白天_妇科李二雷8:30-9:001510603198611265947何苗女1986-11-26185117591201 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 14:36:56 记录内容：select * from pat_master_index where id_no='510603198611265947' and name='何苗' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日1986/11/26 0:00:0040 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 14:36:56 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '妇科李二雷' and visit_time_desc = '白天' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 14:36: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/01/28','YYYY/MM/DD'),5496,'妇科李二雷','白天','3','100492196','何苗','HE MIAO ','女','40','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2026/01/27 14:37:05','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601285496','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 14:36:56 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5496,'妇科李二雷','白天','3','100492196','何苗','HE MIAO ','女','40','一般人员','自费','','主任号','1','0316','LIEL','1',to_date('2026/01/27 14:37:05','yyyy/mm/dd hh24:mi:ss'),'0','30','0.00','30','202601285496','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/28', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科李二雷' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5496,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '妇科李二雷' and visit_time_desc = '白天'）2026012854960.003002026012854962026-01-27 14:36:560 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 15:01:07 记录内容：cyys_2017@123cyys_2017@1231366135645510012026/1/28 0:00:00_上午_儿科刘婕11:00-11:301231283201906030027卢湘宜女2019-06-03136613564551 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 15:01:07 记录内容：select * from pat_master_index where id_no='231283201906030027' and name='卢湘宜' and CHARGE_TYPE='自费' order by CREATE_DATE desc获取的生日2019/6/3 0:00:007 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 15:01:07 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '儿科刘婕' and visit_time_desc = '上午' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 15:01:07 记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5906,'儿科刘婕','上午','1','100534412','卢湘宜','LU XIANG YI ','女','7','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/01/27 15:01:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601285906','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 15:01:08 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5906,'儿科刘婕','上午','1','100534412','卢湘宜','LU XIANG YI ','女','7','一般人员','自费','','副主任号','1','0304','LIUJ','1',to_date('2026/01/27 15:01:17','yyyy/mm/dd hh24:mi:ss'),'0','20','0.00','20','202601285906','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/28', 'YYYY-MM-DD') AND CLINIC_LABEL = '儿科刘婕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),5906,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '儿科刘婕' and visit_time_desc = '上午'）2026012859060.002002026012859062026-01-27 15:01:080 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：新建订单并锁号的入参记录时间：2026-01-27 15:20:33 记录内容：cyys_2017@123cyys_2017@1231833163768010012026/1/28 0:00:00_白天_妇科邓宏文10:00-10:301131082196411051024孟宪月女1964-11-05183316376801 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：入参记录时间：2026-01-27 15:20:33 记录内容：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-01-27 15:20:33 记录内容：select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '妇科邓宏文' and visit_time_desc = '白天' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：预约语句记录时间：2026-01-27 15:20: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/01/28','YYYY/MM/DD'),6202,'妇科邓宏文','白天','2','100527818','孟宪月','MENG XIAN YUE','女','62','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2026/01/27 15:20:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601286202','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回参数记录时间：2026-01-27 15:20:33 记录内容：1成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6202,'妇科邓宏文','白天','2','100527818','孟宪月','MENG XIAN YUE','女','62','一般人员','自费','','普通号','1','0316','DENGHW','1',to_date('2026/01/27 15:20:43','yyyy/mm/dd hh24:mi:ss'),'0','15','0.00','15','202601286202','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1 where clinic_date = to_date('2026/01/28', 'YYYY-MM-DD') AND CLINIC_LABEL = '妇科邓宏文' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2026/01/28','YYYY/MM/DD'),6202,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master where visit_date=to_date('2026/01/28','yyyy/mm/dd') and clinic_label = '妇科邓宏文' and visit_time_desc = '白天'）2026012862020.001502026012862022026-01-27 15:20:330 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆