72433421274198506aaf32995b8cfa4e142adeab.svn-base 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. package xin.glue.ui.B.common;
  2. import java.sql.CallableStatement;
  3. import java.sql.SQLException;
  4. import com.posdata.glue.biz.activity.PosActivity;
  5. import com.posdata.glue.biz.constants.PosBizControlConstants;
  6. import com.posdata.glue.context.PosContext;
  7. import com.posdata.glue.dao.PosGenericDao;
  8. import com.posdata.glue.dao.vo.PosParameter;
  9. /**
  10. *
  11. * @Description 人工判定次品或者正常流转{界面ID:}
  12. * @author 梅贵平{meiguiping}
  13. * @date 2009-9-8 下午02:41:40
  14. * @JDK Version jdk1.4.2
  15. */
  16. public class SaveSlabPersonDcs extends PosActivity
  17. {
  18. public String runActivity(PosContext context)
  19. {
  20. ///ready
  21. PosGenericDao dao = this.getDao("mesdao");
  22. CallableStatement cstm= dao.getCallableStatement("UIB030202_05.CALLSTATEMENT");
  23. ///get request data
  24. String[]DCS_FLAG = (String[])context.get("DCS_FLAG");
  25. String[]rowStatus = (String[])context.get("rowStatus");
  26. String[]DCS_DETAIL = (String[])context.get("DCS_DETAIL");
  27. String[]REG_NM = (String[])context.get("REG_NM");
  28. String[]SLAB_NO = (String[])context.get("SLAB_NO");
  29. if(rowStatus == null)
  30. return PosBizControlConstants.SUCCESS;
  31. int len = rowStatus.length;
  32. try
  33. {
  34. for(int i = 0; i < len; i++)
  35. {
  36. cstm.setString(1, SLAB_NO[i]);//板坯号
  37. cstm.setString(2, REG_NM[0]);//操作人
  38. cstm.setString(3, DCS_FLAG[0]);//为L或者为F,L为正常流转,F为判废
  39. cstm.setString(4, DCS_DETAIL[0]);//说明(备注)
  40. cstm.registerOutParameter(5, java.sql.Types.VARCHAR);
  41. cstm.execute();
  42. }
  43. }catch(Exception ex)
  44. {
  45. logger.logWarn(ex.getMessage(), ex);
  46. }
  47. finally
  48. {
  49. if (cstm != null)
  50. {
  51. try
  52. {
  53. cstm.close();
  54. }
  55. catch (SQLException e)
  56. {
  57. logger.logWarn(e.getMessage(), e);
  58. }
  59. }
  60. }
  61. return PosBizControlConstants.SUCCESS;
  62. }
  63. }