public static float queryProportionByPlanID(String planID) {
String sql = "SELECT nvl(R.FPROPORTION, 0) as FPROPORTION FROM VM_MG_PROCESSROUTE R JOIN MG_ORDERPLAN O ON R.FORDER=O.FORDER AND R.FMATCODE=O.FMATCODE AND R.FWORKMODE=O.FPRODUCTWAY AND R.FFACTORYCODE=O.FFACTORYCODE AND R.FWORKSHOPCODE=O.FWORKSHOPCODE WHERE O.FID='" + planID + "'";
Table table = ExecSqlReturnTable(Biz_MODEL, sql);
return (0 == table.size()) ? 0 : table.iterator().next().getDecimal("FPROPORTION").floatValue();
}