package xin.glue.ui.B.B02; import com.posdata.glue.biz.activity.PosActivity; import com.posdata.glue.biz.constants.PosBizControlConstants; import com.posdata.glue.context.PosContext; import com.posdata.glue.dao.PosGenericDao; import com.posdata.glue.dao.vo.PosParameter; import com.posdata.glue.dao.vo.PosRowSet; /** * * @Description 复试样号材质检验判定实绩录入{界面ID:UIB020172} * @author 梅贵平{meiguiping} * @date 2009-2-21 下午04:21:37 * @JDK Version jdk1.4.2 */ public class SaveRESampAchievement extends PosActivity { public String runActivity(PosContext context) { ///ready PosGenericDao dao = this.getDao("mesdao"); PosRowSet rowset = null; PosParameter param = null; ///get request data String[] rowStatus1 = (String[])context.get("rowStatus1"); String[] rowStatus2 = (String[])context.get("rowStatus2"); String[] QLTY_CD = (String[])context.get("QLTY_CD");//检验项目 String[] QLTY_SEQ = (String[])context.get("QLTY_SEQ");// String[] SMPNO = (String[])context.get("SMPNO");//式样号 String[] SMPCUTLOC = (String[])context.get("SMPCUTLOC");//位置 ///exec String[] QLTY_VAL_WK1 = (String[])context.get("QLTY_VAL_WK1");//头实绩,若取样位置非W,则为尾位置 String[] QLTY_UNIT_WK1 = (String[])context.get("QLTY_UNIT_WK1");//头单位,同上 String[] QLTY_VAL_WK2 = (String[])context.get("QLTY_VAL_WK2");//尾实绩,若取样位置为W,则无 String[] QLTY_UNIT_WK2 = (String[])context.get("QLTY_UNIT_WK2");//尾单位,同上 String[] COILNO = (String[])context.get("COILNO"); String[] QLTY_DCS_RST = (String[])context.get("QLTY_DCS_RST"); if(rowStatus2==null) return PosBizControlConstants.SUCCESS; int len2 = rowStatus2.length; for(int i = 0; i < len2; i++) { if("W".equals(SMPCUTLOC[i]))//取样位置为两头取 { if("".equals(QLTY_SEQ[i]))//update work_qlty { param = new PosParameter(); param.setWhereClauseParameter(0, QLTY_VAL_WK1[i]); param.setWhereClauseParameter(1, QLTY_UNIT_WK1[i]); param.setWhereClauseParameter(2, SMPNO[i]); param.setWhereClauseParameter(3, "1");//头样 param.setWhereClauseParameter(4, QLTY_CD[i]); dao.update("UIB020172_02.UPDATE" , param); param = new PosParameter(); param.setWhereClauseParameter(0, QLTY_VAL_WK2[i]); param.setWhereClauseParameter(1, QLTY_UNIT_WK2[i]); param.setWhereClauseParameter(2, SMPNO[i]); param.setWhereClauseParameter(3, "2");//尾样 param.setWhereClauseParameter(4, QLTY_CD[i]); dao.update("UIB020172_02.UPDATE" , param); } else//update rework_qlty { param = new PosParameter(); param.setWhereClauseParameter(0, QLTY_VAL_WK1[i]); param.setWhereClauseParameter(1, QLTY_UNIT_WK1[i]); param.setWhereClauseParameter(2, SMPNO[i]); param.setWhereClauseParameter(3, "1");//头 param.setWhereClauseParameter(4, QLTY_CD[i]); param.setWhereClauseParameter(5, QLTY_SEQ[i]); dao.update("UIB020172_01.UPDATE" , param); param = new PosParameter(); param.setWhereClauseParameter(0, QLTY_VAL_WK2[i]); param.setWhereClauseParameter(1, QLTY_UNIT_WK2[i]); param.setWhereClauseParameter(2, SMPNO[i]); param.setWhereClauseParameter(3, "2");//头 param.setWhereClauseParameter(4, QLTY_CD[i]); param.setWhereClauseParameter(5, QLTY_SEQ[i]); dao.update("UIB020172_01.UPDATE" , param); } } else//B或T取样 { if("".equals(QLTY_SEQ[i]))//update tbb02_work_qlty { param = new PosParameter(); param.setWhereClauseParameter(0, QLTY_VAL_WK1[i]); param.setWhereClauseParameter(1, QLTY_UNIT_WK1[i]); param.setWhereClauseParameter(2, SMPNO[i]); param.setWhereClauseParameter(3, SMPCUTLOC[i]);//位置 param.setWhereClauseParameter(4, QLTY_CD[i]); dao.update("UIB020172_02.UPDATE" , param); } else//update tbb02_rework_qlty { param = new PosParameter(); param.setWhereClauseParameter(0, QLTY_VAL_WK1[i]); param.setWhereClauseParameter(1, QLTY_UNIT_WK1[i]); param.setWhereClauseParameter(2, SMPNO[i]); param.setWhereClauseParameter(3, SMPCUTLOC[i]);//位置 param.setWhereClauseParameter(4, QLTY_CD[i]); param.setWhereClauseParameter(5, QLTY_SEQ[i]); dao.update("UIB020172_01.UPDATE" , param); } param = new PosParameter(); param.setWhereClauseParameter(0, QLTY_DCS_RST[i]); param.setWhereClauseParameter(1, COILNO[i]); param.setWhereClauseParameter(2, QLTY_CD[i]); dao.update("UIB020172_03.UPDATE", param); } } return PosBizControlConstants.SUCCESS; } }