--银行类别-运营商机构名称 更新历史数据
--运营机构(10)：招商银行 工商银行 农业银行 中国银行 建设银行 财付通 网商银行 邮储银行 交通银行 兴业银行
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '招商银行股份有限公司' WHERE FID = 544782186595789011;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中国工商银行股份有限公司' WHERE FID = 544782186595789003;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中国农业银行股份有限公司' WHERE FID = 544782186595789004;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中国银行股份有限公司' WHERE FID = 544782186595789005;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中国建设银行股份有限公司' WHERE FID = 544782186595789006;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '浙江网商银行股份有限公司' WHERE FID = 544782186595789158;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中国邮政储蓄银行股份有限公司' WHERE FID = 544782186595789008;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '交通银行股份有限公司' WHERE FID = 544782186595789007;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '兴业银行股份有限公司' WHERE FID = 544782186595789016;
--合作银行(29)：重庆银行 资和信 北京银行 成都农商银行 城银清算 光大银行 广发银行 杭州银行 河北农信 华融湘江银行 江苏农信 江苏银行 泸州银行 民生银行 南京银行 宁波银行 农信银资金清算中心 平安银行 浦发银行 青岛银行 上海银行
--深圳农商银行 四川农信 苏州农商银行 苏州银行 西安银行 长沙银行 浙商银行 中信银行
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '重庆银行股份有限公司' WHERE FID = 544782186595789115;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '北京银行股份有限公司' WHERE FID = 544782186595789021;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '成都农村商业银行股份有限公司' WHERE FID = 544782186595790187;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中国光大银行股份有限公司' WHERE FID = 544782186595789010;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '广发银行股份有限公司' WHERE FID = 544782186595789017;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '杭州银行股份有限公司' WHERE FID = 544782186595789066;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '河北省农村信用社(农商银行)' WHERE FID = 544782186595790515;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '华融湘江银行股份有限公司' WHERE FID = 544782186595789101;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '江苏省农村信用社联合社' WHERE FID = 544782186595790829;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '江苏银行股份有限公司' WHERE FID = 544782186595789062;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '泸州银行股份有限公司' WHERE FID = 544782186595789121;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中国民生银行股份有限公司' WHERE FID = 544782186595789013;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '南京银行股份有限公司' WHERE FID = 544782186595789063;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '宁波银行股份有限公司' WHERE FID = 544782186595789148;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '平安银行股份有限公司' WHERE FID = 544782186595789015;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '上海浦东发展银行股份有限公司' WHERE FID = 544782186595789012;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '青岛银行股份有限公司' WHERE FID = 544782186595789153;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '上海银行股份有限公司' WHERE FID = 544782186595789061;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '深圳农村商业银行股份有限公司' WHERE FID = 544782186595790483;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '四川省农村信用社联合社' WHERE FID = 544782186595791108;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '苏州银行股份有限公司' WHERE FID = 544782186595789064;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '西安银行股份有限公司' WHERE FID = 544782186595789135;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '长沙银行股份有限公司' WHERE FID = 544782186595789102;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '浙商银行股份有限公司' WHERE FID = 544782186595789019;
UPDATE t_bd_bankcgsetting SET FINSTITUTIONNAME = '中信银行股份有限公司' WHERE FID = 544782186595789009;

DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789011';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789011,'招商银行股份有限公司','544782186595789011','zh_CN','招商银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789003';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789003,'中国工商银行股份有限公司','544782186595789003','zh_CN','工商银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789004';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789004,'中国农业银行股份有限公司','544782186595789004','zh_CN','农业银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789005';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789005,'中国银行股份有限公司','544782186595789005','zh_CN','中国银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789006';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789006,'中国建设银行股份有限公司','544782186595789006','zh_CN','建设银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789158';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789158,'浙江网商银行股份有限公司','544782186595789158','zh_CN','浙江网商银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789008';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789008,'中国邮政储蓄银行股份有限公司','544782186595789008','zh_CN','邮储银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789007';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789007,'交通银行股份有限公司','544782186595789007','zh_CN','交通银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789016';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789016,'兴业银行股份有限公司','544782186595789016','zh_CN','兴业银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789115';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789115,'重庆银行股份有限公司','544782186595789115','zh_CN','重庆银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789021';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789021,'北京银行股份有限公司','544782186595789021','zh_CN','北京银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595790187';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595790187,'成都农村商业银行股份有限公司','544782186595790187','zh_CN','成都农商行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789010';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789010,'中国光大银行股份有限公司','544782186595789010','zh_CN','光大银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789017';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789017,'广发银行股份有限公司','544782186595789017','zh_CN','广发银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789066';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789066,'杭州银行股份有限公司','544782186595789066','zh_CN','杭州银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595790515';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595790515,'河北省农村信用社(农商银行)','544782186595790515','zh_CN','河北省农信社'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789101';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789101,'华融湘江银行股份有限公司','544782186595789101','zh_CN','华融湘江银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595790829';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595790829,'江苏省农村信用社联合社','544782186595790829','zh_CN','江苏省农信社'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789062';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789062,'江苏银行股份有限公司','544782186595789062','zh_CN','江苏银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789121';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789121,'泸州银行股份有限公司','544782186595789121','zh_CN','泸州商行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789013';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789013,'中国民生银行股份有限公司','544782186595789013','zh_CN','民生银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789063';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789063,'南京银行股份有限公司','544782186595789063','zh_CN','南京银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789148';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789148,'宁波银行股份有限公司','544782186595789148','zh_CN','宁波银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789015';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789015,'平安银行股份有限公司','544782186595789015','zh_CN','平安银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789012';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789012,'上海浦东发展银行股份有限公司','544782186595789012','zh_CN','浦发银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789153';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789153,'青岛银行股份有限公司','544782186595789153','zh_CN','青岛银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789061';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789061,'上海银行股份有限公司','544782186595789061','zh_CN','上海银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595790483';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595790483,'深圳农村商业银行股份有限公司','544782186595790483','zh_CN','深圳农商行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595791108';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595791108,'四川省农村信用社联合社','544782186595791108','zh_CN','四川省农信社'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789064';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789064,'苏州银行股份有限公司','544782186595789064','zh_CN','苏州银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789135';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789135,'西安银行股份有限公司','544782186595789135','zh_CN','西安银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789102';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789102,'长沙银行股份有限公司','544782186595789102','zh_CN','长沙银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789019';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789019,'浙商银行股份有限公司','544782186595789019','zh_CN','浙商银行'); 
DELETE FROM t_bd_bankcgsetting_l WHERE FPKID = '544782186595789009';
INSERT INTO t_bd_bankcgsetting_l(FID,FINSTITUTIONNAME,FPKID,FLOCALEID,FNAME) VALUES (544782186595789009,'中信银行股份有限公司','544782186595789009','zh_CN','中信银行'); 
