-- 升级历史数据 
-- 订单状态    条件     			 	投放状态
--  已关闭		订单数量=投放数量		已投放
update t_mrp_planorder set fdropstatus ='D' where fdropqty = forderqty and fbillstatus ='D' and fdropstatus <>'D';
--  已审核		订单数量>投放数量>0		部分投放
update t_mrp_planorder set fdropstatus ='C' where fdropqty < forderqty and fbillstatus ='C' and fdropqty>0 and fdropstatus <>'C';
--   	 		投放数量=0					未投放
update t_mrp_planorder set fdropstatus ='A' where fdropqty =0 and fdropstatus <>'A';
