◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 12:58:06
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),3357,'妇科王振燕','白天','3','Z00034966','孙娜','','女','39','一般人员','自费','','主任号','1','0316','WZY','1',to_date('2020/05/11 12:58:03','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005123357','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 12:58:06
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),3357,'妇科王振燕','白天','3','Z00034966','孙娜','','女','39','一般人员','自费','','主任号','1','0316','WZY','1',to_date('2020/05/11 12:58:03','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005123357','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王振燕' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),3357,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '妇科王振燕' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005123357</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005123357</pinkey><ordertime>2020-05-11 12:58:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 13:03: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('2020/05/18','YYYY/MM/DD'),3386,'心理咨询张庆彬','白天','3','100121474','王子祺','WANG ZI  ','男','17','一般人员','自费','','副主任号','1','0360','ZHANGQB','1',to_date('2020/05/11 13:03:37','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005183386','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 13:03:40
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/18','YYYY/MM/DD'),3386,'心理咨询张庆彬','白天','3','100121474','王子祺','WANG ZI  ','男','17','一般人员','自费','','副主任号','1','0360','ZHANGQB','1',to_date('2020/05/11 13:03:37','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005183386','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/18', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询张庆彬' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/18','YYYY/MM/DD'),3386,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/18','yyyy/mm/dd')
                    and clinic_label = '心理咨询张庆彬' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005183386</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005183386</pinkey><ordertime>2020-05-11 13:03:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 13:44: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('2020/05/12','YYYY/MM/DD'),3798,'血管外科朱广昌','白天','3','100120236','王凤珍','WANG FENG ZHEN ','女','57','一般人员','自费','','副主任号','1','0394','ZGC1','1',to_date('2020/05/11 13:44:07','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005123798','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 13:44:10
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),3798,'血管外科朱广昌','白天','3','100120236','王凤珍','WANG FENG ZHEN ','女','57','一般人员','自费','','副主任号','1','0394','ZGC1','1',to_date('2020/05/11 13:44:07','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005123798','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '血管外科朱广昌' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),3798,'14:00-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '血管外科朱广昌' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005123798</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005123798</pinkey><ordertime>2020-05-11 13:44:10</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 14:05:21
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),4040,'助产士咨询门诊','白天','1','10367711','王芬','','女','33','一般人员','自费','','普通号','1','0330','','1',to_date('2020/05/11 14:05:18','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005124040','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 14:05:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),4040,'助产士咨询门诊','白天','1','10367711','王芬','','女','33','一般人员','自费','','普通号','1','0330','','1',to_date('2020/05/11 14:05:18','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005124040','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '助产士咨询门诊' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),4040,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '助产士咨询门诊' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005124040</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005124040</pinkey><ordertime>2020-05-11 14:05:21</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 14:07:24
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/16','YYYY/MM/DD'),4065,'妇科董秀华','白天','3','10308162','刘欣','','女','33','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/11 14:07:21','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005164065','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 14:07:24
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/16','YYYY/MM/DD'),4065,'妇科董秀华','白天','3','10308162','刘欣','','女','33','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/11 14:07:21','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005164065','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科董秀华' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/16','YYYY/MM/DD'),4065,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/16','yyyy/mm/dd')
                    and clinic_label = '妇科董秀华' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005164065</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005164065</pinkey><ordertime>2020-05-11 14:07:24</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 14:43: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('2020/05/13','YYYY/MM/DD'),4597,'风湿免疫科王雁','白天','1','100120489','李瑛','LI  ','女','34','一般人员','自费','','知名专家','1','0337','WANGY1','1',to_date('2020/05/11 14:43:13','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005134597','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 14:43:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),4597,'风湿免疫科王雁','白天','1','100120489','李瑛','LI  ','女','34','一般人员','自费','','知名专家','1','0337','WANGY1','1',to_date('2020/05/11 14:43:13','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202005134597','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '风湿免疫科王雁' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),4597,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '风湿免疫科王雁' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005134597</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202005134597</pinkey><ordertime>2020-05-11 14:43:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 15:51:31
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/14','YYYY/MM/DD'),5381,'普通外科杜俊东','白天','2','DP018273','万彬','WAN BIN','女','34','一般人员','自费','','副主任号','1','0335','DUJD','1',to_date('2020/05/11 15:51:27','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005145381','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 15:51:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/14','YYYY/MM/DD'),5381,'普通外科杜俊东','白天','2','DP018273','万彬','WAN BIN','女','34','一般人员','自费','','副主任号','1','0335','DUJD','1',to_date('2020/05/11 15:51:27','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005145381','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '普通外科杜俊东' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/14','YYYY/MM/DD'),5381,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/14','yyyy/mm/dd')
                    and clinic_label = '普通外科杜俊东' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005145381</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005145381</pinkey><ordertime>2020-05-11 15:51:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 16:37: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('2020/05/16','YYYY/MM/DD'),5721,'产科郑红','白天','6','Z00114306','胡丽','','女','33','一般人员','自费','','普通号','1','0330','ZH11','1',to_date('2020/05/11 16:37:31','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005165721','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 16:37:35
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/16','YYYY/MM/DD'),5721,'产科郑红','白天','6','Z00114306','胡丽','','女','33','一般人员','自费','','普通号','1','0330','ZH11','1',to_date('2020/05/11 16:37:31','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005165721','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科郑红' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/16','YYYY/MM/DD'),5721,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/16','yyyy/mm/dd')
                    and clinic_label = '产科郑红' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005165721</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005165721</pinkey><ordertime>2020-05-11 16:37:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 17:47:36
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),5875,'妇科王振燕','白天','4','Z00063183','李维玉','LI WEI YU','女','27','一般人员','自费','','主任号','1','0316','WZY','1',to_date('2020/05/11 17:47:32','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005125875','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 17:47:36
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),5875,'妇科王振燕','白天','4','Z00063183','李维玉','LI WEI YU','女','27','一般人员','自费','','主任号','1','0316','WZY','1',to_date('2020/05/11 17:47:32','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005125875','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王振燕' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),5875,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '妇科王振燕' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005125875</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005125875</pinkey><ordertime>2020-05-11 17:47:36</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 18:07: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('2020/05/16','YYYY/MM/DD'),5899,'妇科董秀华','白天','5','00349431','杨书仿','YANG SHU FANG','女','58','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/11 18:07:03','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005165899','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 18:07:08
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/16','YYYY/MM/DD'),5899,'妇科董秀华','白天','5','00349431','杨书仿','YANG SHU FANG','女','58','一般人员','自费','','主任号','1','0316','DONGXH','1',to_date('2020/05/11 18:07:03','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005165899','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/16', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科董秀华' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/16','YYYY/MM/DD'),5899,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/16','yyyy/mm/dd')
                    and clinic_label = '妇科董秀华' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005165899</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005165899</pinkey><ordertime>2020-05-11 18:07:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-11 18:53:26
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/19','YYYY-MM-DD')
            AND CLINIC_LABEL='口腔科王涵' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='131028198711301233' and name='王家兴' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 18:53:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 19:40: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('2020/05/12','YYYY/MM/DD'),5974,'中医科李国强','白天','1','100119107','张洪旭','ZHANG HONG XU ','男','33','一般人员','自费','','副主任号','1','0301','LIGQ','1',to_date('2020/05/11 19:40:12','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005125974','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 19:40:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),5974,'中医科李国强','白天','1','100119107','张洪旭','ZHANG HONG XU ','男','33','一般人员','自费','','副主任号','1','0301','LIGQ','1',to_date('2020/05/11 19:40:12','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005125974','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '中医科李国强' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),5974,'9:30-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '中医科李国强' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005125974</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005125974</pinkey><ordertime>2020-05-11 19:40:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2020-05-11 19:55:17
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2020/05/19','YYYY-MM-DD')
            AND CLINIC_LABEL='口腔科王涵' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='131028198711301233' and name='王家兴' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 19:55:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 20:24:35
记录内容： 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('2020/05/12','YYYY/MM/DD'),5996,'骨科徐卫东','白天','5','100121511','宋午平','SONG WU PING ','女','54','一般人员','自费','','副主任号','1','0312','XUWD','1',to_date('2020/05/11 20:24:30','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005125996','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 20:24:35
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),5996,'骨科徐卫东','白天','5','100121511','宋午平','SONG WU PING ','女','54','一般人员','自费','','副主任号','1','0312','XUWD','1',to_date('2020/05/11 20:24:30','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005125996','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科徐卫东' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),5996,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '骨科徐卫东' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005125996</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005125996</pinkey><ordertime>2020-05-11 20:24:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 20:26: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('2020/05/14','YYYY/MM/DD'),5999,'皮肤科陈凯','白天','1','100121510','夏春晓','XIA CHUN XIAO ','女','17','一般人员','自费','','副主任号','1','0318','CK01','1',to_date('2020/05/11 20:26:26','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005145999','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 20:26:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/14','YYYY/MM/DD'),5999,'皮肤科陈凯','白天','1','100121510','夏春晓','XIA CHUN XIAO ','女','17','一般人员','自费','','副主任号','1','0318','CK01','1',to_date('2020/05/11 20:26:26','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005145999','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/14', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科陈凯' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/14','YYYY/MM/DD'),5999,'14:00-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/14','yyyy/mm/dd')
                    and clinic_label = '皮肤科陈凯' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005145999</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005145999</pinkey><ordertime>2020-05-11 20:26:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 20:46: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('2020/05/12','YYYY/MM/DD'),6006,'骨科徐卫东','白天','6','10446967','田艳杰','','男','33','一般人员','自费','','副主任号','1','0312','XUWD','1',to_date('2020/05/11 20:46:09','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005126006','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 20:46:14
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),6006,'骨科徐卫东','白天','6','10446967','田艳杰','','男','33','一般人员','自费','','副主任号','1','0312','XUWD','1',to_date('2020/05/11 20:46:09','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202005126006','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科徐卫东' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),6006,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '骨科徐卫东' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005126006</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202005126006</pinkey><ordertime>2020-05-11 20:46:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 21:02: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('2020/05/13','YYYY/MM/DD'),6017,'耳鼻喉科胡琦','白天','3','10174094','胡述锐','','女','46','一般人员','自费','','主任号','1','0306','HUQI01','1',to_date('2020/05/11 21:01:56','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005136017','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 21:02:01
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6017,'耳鼻喉科胡琦','白天','3','10174094','胡述锐','','女','46','一般人员','自费','','主任号','1','0306','HUQI01','1',to_date('2020/05/11 21:01:56','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005136017','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科胡琦' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6017,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科胡琦' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005136017</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005136017</pinkey><ordertime>2020-05-11 21:02:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 21:09:08
记录内容： 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('2020/05/12','YYYY/MM/DD'),6019,'耳鼻喉科普通号','白天','2','100034391','徐梓恒','','男','4','一般人员','自费','','普通号','1','0306','','1',to_date('2020/05/11 21:09:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005126019','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 21:09:08
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),6019,'耳鼻喉科普通号','白天','2','100034391','徐梓恒','','男','4','一般人员','自费','','普通号','1','0306','','1',to_date('2020/05/11 21:09:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202005126019','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科普通号' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),6019,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科普通号' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005126019</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202005126019</pinkey><ordertime>2020-05-11 21:09:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 21:37: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('2020/05/13','YYYY/MM/DD'),6027,'眼科张仲臣特需号','上午','5','100121512','杨耕','YANG GENG ','女','2','一般人员','自费','','特需号2','1','0327','ZHANGZC','1',to_date('2020/05/11 21:37:49','yyyy/mm/dd hh24:mi:ss'),'96','4','0.00','100','202005136027','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 21:37:54
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6027,'眼科张仲臣特需号','上午','5','100121512','杨耕','YANG GENG ','女','2','一般人员','自费','','特需号2','1','0327','ZHANGZC','1',to_date('2020/05/11 21:37:49','yyyy/mm/dd hh24:mi:ss'),'96','4','0.00','100','202005136027','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科张仲臣特需号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6027,'10:30-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '眼科张仲臣特需号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202005136027</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>96</registrationfee><pinkey>202005136027</pinkey><ordertime>2020-05-11 21:37:54</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 22:29:58
记录内容： 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('2020/05/13','YYYY/MM/DD'),6051,'耳鼻喉科胡琦','白天','4','100121513','李帅','LI SHUAI ','男','30','一般人员','自费','','主任号','1','0306','HUQI01','1',to_date('2020/05/11 22:29:53','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005136051','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 22:29:59
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6051,'耳鼻喉科胡琦','白天','4','100121513','李帅','LI SHUAI ','男','30','一般人员','自费','','主任号','1','0306','HUQI01','1',to_date('2020/05/11 22:29:53','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005136051','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/13', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科胡琦' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/13','YYYY/MM/DD'),6051,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/13','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科胡琦' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005136051</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005136051</pinkey><ordertime>2020-05-11 22:29:59</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2020-05-11 22:43:45
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),6053,'消化内科梁毅','白天','1','00204873','孙丹丹','','女','35','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2020/05/11 22:43:39','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005126053','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2020-05-11 22:43:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2020/05/12','YYYY/MM/DD'),6053,'消化内科梁毅','白天','1','00204873','孙丹丹','','女','35','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2020/05/11 22:43:39','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202005126053','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2020/05/12', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科梁毅' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2020/05/12','YYYY/MM/DD'),6053,'8:30-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2020/05/12','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202005126053</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202005126053</pinkey><ordertime>2020-05-11 22:43:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆