/* 组织形态删除省公司、子公司 */ 
delete from T_ORG_PATTERN where FID in (5,8);
delete from T_ORG_PATTERN_l where FID in (5,8);

/* 更新编码，用于排序 */
update T_ORG_PATTERN set fnumber = 'Orgform01' where fid = 7;
update T_ORG_PATTERN set fnumber = 'Orgform02' where fid = 1;
update T_ORG_PATTERN set fnumber = 'Orgform03' where fid = 2;
update T_ORG_PATTERN set fnumber = 'Orgform04' where fid = 3;
update T_ORG_PATTERN set fnumber = 'Orgform05' where fid = 6;
update T_ORG_PATTERN set fnumber = 'Orgform06' where fid = 4;
