--升级计算方向字段值
update t_bd_materialinvinfo_x set fcaldirection='3' where fcalculationforenddate in ('0','1');
update t_bd_materialinvinfo_x set fcaldirection='1' where fcalculationforenddate = '2';

--升级生产日期计算方式字段值
update t_bd_materialinvinfo_x set fstartdatecaltype ='1' where fcalculationforenddate in ('0','2');
update t_bd_materialinvinfo_x set fstartdatecaltype ='2' where fcalculationforenddate = '1';
