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; /** * * @Description 复样实绩修改保存{界面ID:UIB020172} * @author 梅贵平{meiguiping} * @date 2008-12-31 上午11:07:21 * @JDK Version jdk1.4.2 */ public class SaveReSMPValue extends PosActivity { public String runActivity(PosContext context) { //ready ? go PosParameter param = null; PosGenericDao dao = this.getDao("mesdao"); //get request data(datagrid1 and datagrid2's data) //datagrid1's data String[] rowstatus1 = (String[])context.get("rowstatus1"); String[] COIL_NO = (String[])context.get("COIL_NO"); String[]MATLQLTY_DEC_GRD= (String[])context.get("MATLQLTY_DEC_GRD");//材质结果 //datagrid2's data String[] rowstatus2 = (String[])context.get("rowstatus2"); String[] SMPNO = (String[])context.get("SMPNO");//试样 String[] COILNO = (String[])context.get("COILNO");//钢卷 String[] SMPCUTLOC = (String[])context.get("SMPCUTLOC");//位置 String[] QLTY_CD = (String[])context.get("QLTY_CD");//材质代码 String[] QLTY_VAL_WK1 = (String[])context.get("QLTY_VAL_WK1");//实绩1,对应头部(T) String[] QLTY_TYPE_WK1 = (String[])context.get("QLTY_TYPE_WK1");//类型1 String[] QLTY_VAL_WK2 = (String[])context.get("QLTY_VAL_WK2");//实绩2,对应尾部(B) String[] QLTY_TYPE_WK2 = (String[])context.get("QLTY_TYPE_WK2");//类型2 String[] QLTY_DCS_RST = (String[])context.get("QLTY_DCS_RST");//某检验项目的判定结果 //update datagrid1 if(rowstatus1 != null) { int len1 = rowstatus1.length; for(int i = 0; i < len1; i++) { param = new PosParameter(); param.setValueParamter(0, MATLQLTY_DEC_GRD[i]); param.setValueParamter(1, COIL_NO[i]); // update TBB02_DCS_QLTY set MATLQLTY_DEC_GRD = ? where COIL_NO = ? dao.update("UIB020172_01.UPDATE", param); } } //update datagrid2 if(rowstatus2 != null) { int len2 = rowstatus2.length; for(int i = 0; i < len2; i++) { //update TBB02_DCS_QLTY param = new PosParameter(); param.setValueParamter(0, QLTY_DCS_RST[i]); param.setValueParamter(1, COILNO[i]); param.setValueParamter(2, QLTY_CD[i]); dao.update("UIB020172_03.UPDATE", param); //update TBB02_WORK_QLTY if("W".equals(SMPCUTLOC[i])) { param = new PosParameter(); param.setValueParamter(0, QLTY_VAL_WK1[i]); param.setValueParamter(1, QLTY_TYPE_WK1[i]); param.setValueParamter(2, SMPNO[i]); param.setValueParamter(3, "1");//头 param.setValueParamter(4, QLTY_CD); dao.update("UIB020172_02.UPDATE", param); param = new PosParameter(); param.setValueParamter(0, QLTY_VAL_WK2[i]); param.setValueParamter(1, QLTY_TYPE_WK2[i]); param.setValueParamter(2, SMPNO[i]); param.setValueParamter(3, "2"); param.setValueParamter(4, QLTY_CD); dao.update("UIB020172_02.UPDATE", param); } else { param = new PosParameter(); param.setValueParamter(0, QLTY_VAL_WK1[i]); param.setValueParamter(1, QLTY_TYPE_WK1[i]); param.setValueParamter(2, SMPNO[i]); param.setValueParamter(3, SMPCUTLOC[i]);// param.setValueParamter(4, QLTY_CD); dao.update("UIB020172_02.UPDATE", param); } } } return PosBizControlConstants.SUCCESS; } }