--## 2022.11.01 cherenhai 芜湖妇幼保健院  维护医保登录方式  MZSF13X-20220702-001

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', '0', '医保签到', null, null, 4.00, '医保登录方式(0 医保签到 1 医保签退 2 宣城医保签到 3 宣城医保签退 4 离休医保签到 5 离休医保签退)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'ybdlfs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='医保登录方式' and BH0000='0');


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', '1', '医保签退', null, null, 4.00, '医保登录方式(0 医保签到 1 医保签退 2 宣城医保签到 3 宣城医保签退 4 离休医保签到 5 离休医保签退)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'ybdlfs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='医保登录方式' and BH0000='1');


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', '2', '宣城医保签到', null, null, 4.00, '医保登录方式(0 医保签到 1 医保签退 2 宣城医保签到 3 宣城医保签退 4 离休医保签到 5 离休医保签退)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'ybdlfs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='医保登录方式' and BH0000='2');



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', '3', '宣城医保签退', null, null, 4.00, '医保登录方式(0 医保签到 1 医保签退 2 宣城医保签到 3 宣城医保签退 4 离休医保签到 5 离休医保签退)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'ybdlfs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='医保登录方式' and BH0000='3');


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', '4', '离休医保签到', null, null, 4.00, '医保登录方式(0 医保签到 1 医保签退 2 宣城医保签到 3 宣城医保签退 4 离休医保签到 5 离休医保签退)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'ybdlfs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='医保登录方式' and BH0000='4');


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', '5', '离休医保签退', null, null, 4.00, '医保登录方式(0 医保签到 1 医保签退 2 宣城医保签到 3 宣城医保签退 4 离休医保签到 5 离休医保签退)', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'ybdlfs', 'fwxggcco'
 from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='医保登录方式' and BH0000='5');

commit;