-- 修复组织管理关系策略根节点数据错误问题
update t_hbss_empstrentry set fstrategyid = 1780 where forgteamid = 100000 and FBUSSINESSFIELDID = '1010';
update t_hbss_empstrentry set fstrategyid = 1790 where forgteamid = 100000 and FBUSSINESSFIELDID = '1020';
update t_hbss_empstrentry set fstrategyid = 1800 where forgteamid = 100000 and FBUSSINESSFIELDID = '1030';
update t_hbss_empstrentry set fstrategyid = 1810 where forgteamid = 100000 and FBUSSINESSFIELDID = '1040';
update t_hbss_empstrentry set fstrategyid = 1820 where forgteamid = 100000 and FBUSSINESSFIELDID = '1050';
update t_hbss_empstrentry set fstrategyid = 1830 where forgteamid = 100000 and FBUSSINESSFIELDID = '1060';
update t_hbss_empstrentry set fstrategyid = 1840 where forgteamid = 100000 and FBUSSINESSFIELDID = '1070';
update t_hbss_empstrentry set fstrategyid = 1850 where forgteamid = 100000 and FBUSSINESSFIELDID = '1080';
update t_hbss_empstrentry set fstrategyid = 1860 where forgteamid = 100000 and FBUSSINESSFIELDID = '1090';
update t_hbss_empstrentryhis set fstrategyid = 1780 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1010';
update t_hbss_empstrentryhis set fstrategyid = 1790 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1020';
update t_hbss_empstrentryhis set fstrategyid = 1800 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1030';
update t_hbss_empstrentryhis set fstrategyid = 1810 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1040';
update t_hbss_empstrentryhis set fstrategyid = 1820 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1050';
update t_hbss_empstrentryhis set fstrategyid = 1830 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1060';
update t_hbss_empstrentryhis set fstrategyid = 1840 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1070';
update t_hbss_empstrentryhis set fstrategyid = 1850 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1080';
update t_hbss_empstrentryhis set fstrategyid = 1860 where fvid = (select fvid from t_hbss_empstrategyhis where forgteamid = 100000 and fdatastatus = '1') and FBUSSINESSFIELDID = '1090';