--2022.12.02 chenrh by 	MZSF13X-20221202-001 门诊是否启用医信支付，Y,是;N,否,默认N 芜湖市第一人民医院为Y
insert into XT_XTCS00 (NAME00, VALUE0, FLAG00, BZ0000, FL0000, SYXT00, YYID00, BB0000, SFXS00, MRZ000, CJRQ00, ZTFL00, SSXT00, XTCDBH)
values ('SF_SFQYQYZF', 'N', '1', '门诊是否启用医信支付，Y,是;N,否,默认N', null, '14,15', null, null, 'Y', null, null, '门诊预交金管理', '门诊收费', 'X001002');

commit;

--2022.12.02 chenrh by 	MZSF13X-20221202-001 新增区域支付平台应用ID、密码、服务地址
insert into BM_TYZD00 (NBBH00, ZDMC00, LBBZ00, BH0000, MC0000, PYSM00, WBSM00, XSXH00, BZ0000, YXBZ00, XTBZ00, WHBZ00, DJ0000, MKDM00, BZDYBH, BH0001, MC0001, BH0002, CJRQSJ, XGRQSJ, CJR000, XGR000, ZDPYSM, ZDWBSM)
 select SQ_BM_TYZD00_NBBH00.nextval,'支付统一平台参数', '0', 'appId_QYZF', '1G3NI6SA40B80100007F0000109D5219', null, null, 4.00, '区域支付平台应用ID(userid)(接口平台提供)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'zftyptcs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='支付统一平台参数' and BH0000='appId_QYZF');
 
 
insert into BM_TYZD00 (NBBH00, ZDMC00, LBBZ00, BH0000, MC0000, PYSM00, WBSM00, XSXH00, BZ0000, YXBZ00, XTBZ00, WHBZ00, DJ0000, MKDM00, BZDYBH, BH0001, MC0001, BH0002, CJRQSJ, XGRQSJ, CJR000, XGR000, ZDPYSM, ZDWBSM)
 select SQ_BM_TYZD00_NBBH00.nextval,'支付统一平台参数', '0', 'appSecret_QYZF', '1G3NI76BILJ30100007F000059CC64EF', null, null, 4.00, '区域支付平台应用密码(接口平台提供)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'zftyptcs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='支付统一平台参数' and BH0000='appSecret_QYZF');


insert into BM_TYZD00 (NBBH00, ZDMC00, LBBZ00, BH0000, MC0000, PYSM00, WBSM00, XSXH00, BZ0000, YXBZ00, XTBZ00, WHBZ00, DJ0000, MKDM00, BZDYBH, BH0001, MC0001, BH0002, CJRQSJ, XGRQSJ, CJR000, XGR000, ZDPYSM, ZDWBSM)
 select SQ_BM_TYZD00_NBBH00.nextval,'支付统一平台参数', '0', 'onePayUrl_QYZF', 'http://60.167.58.158:9090/onepay-web', null, null, 4.00, '区域支付平台应用服务地址', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'zftyptcs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='支付统一平台参数' and BH0000='onePayUrl_QYZF'); 
 

commit;