0069aa51e5566c6b4ff2362b8a87cb7be77e59d1.svn-base 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
  1. package xin.glue.ui.B.B02;
  2. import java.sql.CallableStatement;
  3. import com.posdata.glue.biz.activity.PosActivity;
  4. import com.posdata.glue.biz.constants.PosBizControlConstants;
  5. import com.posdata.glue.context.PosContext;
  6. import com.posdata.glue.dao.PosGenericDao;
  7. import com.posdata.glue.dao.vo.PosParameter;
  8. /**
  9. *
  10. * @Description 炉次号成分实绩修改或增加保存{界面ID:UIB020030}
  11. * @author 梅贵平{meiguiping}
  12. * @date 2009-1-5 下午09:37:38
  13. * @JDK Version jdk1.4.2
  14. */
  15. public class SaveChargeAchievement extends PosActivity
  16. {
  17. public String runActivity(PosContext context)
  18. {
  19. ///ready
  20. PosGenericDao dao = this.getDao("mesdao");
  21. CallableStatement cstm = null;
  22. ///获取请求参数
  23. String[]REG_NM = (String[])context.get("REG_NM");
  24. String[]CHARGE_NO = (String[])context.get("CHARGE_NO");//炉次号,插入时其作用
  25. String[]PROC_CD = (String[])context.get("PROC_CD");//成分,插入时其作用
  26. String[]CHEM_SEQ = (String[])context.get("CHEM_SEQ");//工序,插入时其作用
  27. String[]CHEM_L2_PROC_CD=(String[])context.get("CHEM_L2_PROC_CD");//L2对应的工序代码
  28. String[]MOD_RMK = (String[])context.get("MOD_RMK");//备注
  29. //表格2、3、4、5
  30. String[]rowStuts2 = (String[])context.get("rowStuts2");//对应表格2、3、4、5修改的信息
  31. String[]CHEM_CD = (String[])context.get("CHEM_CD");//成分代码
  32. String[]CHEM_VAL = (String[])context.get("CHEM_VAL");//实绩值
  33. String[]rowStuts1 = (String[])context.get("rowStuts1");//针对datagrid1
  34. String[]rowStatusD = (String[])context.get("rowStatusD");//删除
  35. try
  36. {
  37. if(rowStuts2 != null)
  38. {
  39. int len = rowStuts2.length;
  40. cstm = dao.getCallableStatement("UIB020030_01.CALLSTATEMENT");
  41. int j = 1;
  42. for(int i = 0; i < len; i++)
  43. {
  44. j = 1;
  45. cstm.setString(j++, CHARGE_NO[0]);
  46. cstm.setString(j++, PROC_CD[0]);
  47. cstm.setString(j++, CHEM_SEQ[0]);
  48. cstm.setString(j++, CHEM_CD[i]);
  49. cstm.setString(j++, CHEM_VAL[i]);
  50. cstm.setString(j++, CHEM_L2_PROC_CD[0]);
  51. cstm.setString(j++, REG_NM[0]);
  52. cstm.setString(j++, MOD_RMK[0]);//备注
  53. cstm.setString(j++, Integer.toString(i));
  54. cstm.registerOutParameter(j++, java.sql.Types.VARCHAR);
  55. cstm.execute();
  56. }
  57. }
  58. else if(rowStatusD != null)
  59. {
  60. cstm = dao.getCallableStatement("UIB020030_02.CALLSTATEMENT");
  61. cstm.setString(1, CHARGE_NO[0]);
  62. cstm.setString(2, PROC_CD[0]);
  63. cstm.setString(3, CHEM_SEQ[0]);
  64. cstm.registerOutParameter(4, java.sql.Types.VARCHAR);
  65. cstm.execute();
  66. }
  67. else if(rowStuts1 != null)
  68. {
  69. // if("u".equals(rowStuts1[0]))
  70. // {
  71. // PosParameter param = new PosParameter();
  72. // param.setWhereClauseParameter(0, CHEM_L2_PROC_CD)
  73. // }
  74. }
  75. }catch(Exception ex)
  76. {
  77. ex.printStackTrace();
  78. }
  79. finally
  80. {
  81. try
  82. {
  83. if(cstm != null)
  84. {
  85. cstm.close();
  86. }
  87. }catch(Exception e)
  88. {
  89. e.printStackTrace();
  90. }
  91. }
  92. return PosBizControlConstants.SUCCESS;
  93. }
  94. }