| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 |
- 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;
- }
- }
|