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