e817003d5371d3655fd189c4e2cf48bd03a5d474.svn-base 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. package xin.glue.ui.B.B02;
  2. import com.posdata.glue.biz.activity.PosActivity;
  3. import com.posdata.glue.biz.constants.PosBizControlConstants;
  4. import com.posdata.glue.context.PosContext;
  5. import com.posdata.glue.dao.PosGenericDao;
  6. import com.posdata.glue.dao.vo.PosParameter;
  7. /**
  8. *
  9. * @Description 复样实绩修改保存{界面ID:UIB020172}
  10. * @author 梅贵平{meiguiping}
  11. * @date 2008-12-31 上午11:07:21
  12. * @JDK Version jdk1.4.2
  13. */
  14. public class SaveReSMPValue extends PosActivity
  15. {
  16. public String runActivity(PosContext context)
  17. {
  18. //ready ? go
  19. PosParameter param = null;
  20. PosGenericDao dao = this.getDao("mesdao");
  21. //get request data(datagrid1 and datagrid2's data)
  22. //datagrid1's data
  23. String[] rowstatus1 = (String[])context.get("rowstatus1");
  24. String[] COIL_NO = (String[])context.get("COIL_NO");
  25. String[]MATLQLTY_DEC_GRD= (String[])context.get("MATLQLTY_DEC_GRD");//材质结果
  26. //datagrid2's data
  27. String[] rowstatus2 = (String[])context.get("rowstatus2");
  28. String[] SMPNO = (String[])context.get("SMPNO");//试样
  29. String[] COILNO = (String[])context.get("COILNO");//钢卷
  30. String[] SMPCUTLOC = (String[])context.get("SMPCUTLOC");//位置
  31. String[] QLTY_CD = (String[])context.get("QLTY_CD");//材质代码
  32. String[] QLTY_VAL_WK1 = (String[])context.get("QLTY_VAL_WK1");//实绩1,对应头部(T)
  33. String[] QLTY_TYPE_WK1 = (String[])context.get("QLTY_TYPE_WK1");//类型1
  34. String[] QLTY_VAL_WK2 = (String[])context.get("QLTY_VAL_WK2");//实绩2,对应尾部(B)
  35. String[] QLTY_TYPE_WK2 = (String[])context.get("QLTY_TYPE_WK2");//类型2
  36. String[] QLTY_DCS_RST = (String[])context.get("QLTY_DCS_RST");//某检验项目的判定结果
  37. //update datagrid1
  38. if(rowstatus1 != null)
  39. {
  40. int len1 = rowstatus1.length;
  41. for(int i = 0; i < len1; i++)
  42. {
  43. param = new PosParameter();
  44. param.setValueParamter(0, MATLQLTY_DEC_GRD[i]);
  45. param.setValueParamter(1, COIL_NO[i]);
  46. // update TBB02_DCS_QLTY set MATLQLTY_DEC_GRD = ? where COIL_NO = ?
  47. dao.update("UIB020172_01.UPDATE", param);
  48. }
  49. }
  50. //update datagrid2
  51. if(rowstatus2 != null)
  52. {
  53. int len2 = rowstatus2.length;
  54. for(int i = 0; i < len2; i++)
  55. {
  56. //update TBB02_DCS_QLTY
  57. param = new PosParameter();
  58. param.setValueParamter(0, QLTY_DCS_RST[i]);
  59. param.setValueParamter(1, COILNO[i]);
  60. param.setValueParamter(2, QLTY_CD[i]);
  61. dao.update("UIB020172_03.UPDATE", param);
  62. //update TBB02_WORK_QLTY
  63. if("W".equals(SMPCUTLOC[i]))
  64. {
  65. param = new PosParameter();
  66. param.setValueParamter(0, QLTY_VAL_WK1[i]);
  67. param.setValueParamter(1, QLTY_TYPE_WK1[i]);
  68. param.setValueParamter(2, SMPNO[i]);
  69. param.setValueParamter(3, "1");//头
  70. param.setValueParamter(4, QLTY_CD);
  71. dao.update("UIB020172_02.UPDATE", param);
  72. param = new PosParameter();
  73. param.setValueParamter(0, QLTY_VAL_WK2[i]);
  74. param.setValueParamter(1, QLTY_TYPE_WK2[i]);
  75. param.setValueParamter(2, SMPNO[i]);
  76. param.setValueParamter(3, "2");
  77. param.setValueParamter(4, QLTY_CD);
  78. dao.update("UIB020172_02.UPDATE", param);
  79. }
  80. else
  81. {
  82. param = new PosParameter();
  83. param.setValueParamter(0, QLTY_VAL_WK1[i]);
  84. param.setValueParamter(1, QLTY_TYPE_WK1[i]);
  85. param.setValueParamter(2, SMPNO[i]);
  86. param.setValueParamter(3, SMPCUTLOC[i]);//
  87. param.setValueParamter(4, QLTY_CD);
  88. dao.update("UIB020172_02.UPDATE", param);
  89. }
  90. }
  91. }
  92. return PosBizControlConstants.SUCCESS;
  93. }
  94. }