71d8191fe87cddda2e2bc09206fe81cafe133219.svn-base 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. package xin.glue.ui.common;
  2. import java.math.BigDecimal;
  3. import java.sql.CallableStatement;
  4. import java.sql.SQLException;
  5. import xin.glue.ui.common.PosDateFormat;
  6. import com.posdata.glue.PosException;
  7. import com.posdata.glue.biz.activity.PosActivity;
  8. import com.posdata.glue.biz.constants.PosBizControlConstants;
  9. import com.posdata.glue.biz.control.PosBizControlIF;
  10. import com.posdata.glue.biz.control.PosBizProvider;
  11. import com.posdata.glue.component.PosConstants;
  12. import com.posdata.glue.context.PosContext;
  13. import com.posdata.glue.dao.PosGenericDao;
  14. import com.posdata.glue.dao.vo.PosParameter;
  15. import com.posdata.glue.dao.vo.PosRow;
  16. import com.posdata.glue.dao.vo.PosRowSet;
  17. import com.posdata.glue.msg.PosMESMessageImpl;
  18. import com.posdata.glue.msg.PosMessage;
  19. public class ProduceFactory extends PosActivity
  20. {
  21. public String runActivity(PosContext context)
  22. {
  23. logger.logInfo("XinSaveSlabReject START " );
  24. return PosBizControlConstants.SUCCESS;
  25. }
  26. public void ErpDataCover(String PLINE ,String P_COILNO ,String PRDACTION
  27. ,String ISCP,String TypeIdx,String REGID,String refinfo )
  28. {
  29. //调用存货异动点存储过程
  30. CallableStatement PlRtn = getDao("mesdao").getCallableStatement("ERPPDOSLAB");//NIH020020
  31. try {
  32. if(PlRtn != null) {
  33. PlRtn.setString(1,PLINE);
  34. PlRtn.setString(2,P_COILNO);
  35. PlRtn.setString(3,PRDACTION);
  36. PlRtn.setString(4,ISCP);
  37. PlRtn.setString(5,TypeIdx);
  38. PlRtn.setString(6,REGID);
  39. PlRtn.setString(7,refinfo);
  40. PlRtn.execute();
  41. }
  42. } catch (SQLException e) {
  43. throw new PosException(e.getMessage());
  44. }finally
  45. {
  46. if (PlRtn != null)
  47. {
  48. try
  49. {
  50. PlRtn.close();
  51. }
  52. catch (SQLException e)
  53. {
  54. logger.logWarn(e.getMessage(), e);
  55. }
  56. }
  57. }
  58. }
  59. public void ErpDataCoverFJ(String PLINE, String P_COILNO,
  60. String PRDACTION,String ISCP,String TypeIdx,String DFLAG, String TMPWGT, String ORICOILNO, String REGID, String refinfo )
  61. {
  62. //调用存货异动点存储过程
  63. CallableStatement PlRtn = getDao("mesdao").getCallableStatement("ERPPDOSLABFJ");//NIH020020
  64. try {
  65. if(PlRtn != null) {
  66. PlRtn.setString(1,PLINE);
  67. PlRtn.setString(2,P_COILNO);
  68. PlRtn.setString(3,PRDACTION);
  69. PlRtn.setString(4,ISCP);
  70. PlRtn.setString(5,TypeIdx);
  71. PlRtn.setString(6,DFLAG);
  72. PlRtn.setString(7,TMPWGT);
  73. PlRtn.setString(8,ORICOILNO);
  74. PlRtn.setString(9,REGID);
  75. PlRtn.setString(10,refinfo);
  76. PlRtn.execute();
  77. }
  78. } catch (SQLException e) {
  79. throw new PosException(e.getMessage());
  80. }finally
  81. {
  82. if (PlRtn != null)
  83. {
  84. try
  85. {
  86. PlRtn.close();
  87. }
  88. catch (SQLException e)
  89. {
  90. logger.logWarn(e.getMessage(), e);
  91. }
  92. }
  93. }
  94. }
  95. }