901c69d2c3e0478896ec2cc97e9a937623ebf913.svn-base 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. package xin.glue.ui.K.K01;
  2. import java.sql.CallableStatement;
  3. import xin.glue.ui.common.ProduceFactory;
  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. import com.posdata.glue.dao.vo.PosRowSet;
  10. public class FJHSaveBJBack extends PosActivity {
  11. public String runActivity(PosContext context) {
  12. String[] rowStatus = (String[]) context.get("rowStatus");
  13. //发运指示号
  14. String[] DLIV_DIRNO = (String[]) context.get("DLIV_DIRNO");
  15. //录入人
  16. String[] REG_ID = (String[]) context.get("REG_ID");
  17. String[] OLD_SAMPL_NO = (String[]) context.get("OLD_SAMPL_NO");
  18. PosParameter param1 = new PosParameter();
  19. PosParameter param2 = new PosParameter();
  20. param1.setWhereClauseParameter(0, REG_ID[0]);
  21. param1.setWhereClauseParameter(1, DLIV_DIRNO[0]);
  22. getDao("mesdao").update("UIH052201_01.update", param1);
  23. param2.setWhereClauseParameter(0, DLIV_DIRNO[0]);
  24. getDao("mesdao").update("UIH052201_01.delete", param2);
  25. //调用存货异动点存储过程
  26. //SENDERP(OLD_SAMPL_NO,REG_ID[0]); 20220513由于开平板不发送发货信息,所以取消此处的取消发货异动点
  27. return PosBizControlConstants.SUCCESS;
  28. }
  29. public void SENDERP(String[] OLD_SAMPL_NO,String REGID) {
  30. int iCnt = 0;
  31. if (OLD_SAMPL_NO != null) {
  32. iCnt = OLD_SAMPL_NO.length;
  33. }
  34. CallableStatement cstm = null;
  35. for (int i = 0; i < iCnt; i++) {
  36. try {
  37. //调用存货异动点存储过程
  38. ProduceFactory PD= new ProduceFactory();
  39. PD.ErpDataCover("HCOIL",OLD_SAMPL_NO[i],"69A","1","N",REGID,"热轧非计划退货");
  40. PD.ErpDataCover("HCOIL",OLD_SAMPL_NO[i],"11AC","0","N",REGID ,"非计划退货取消判定");
  41. } catch (Exception ex) {
  42. ex.printStackTrace();
  43. System.out.println("明细数据发送到一体化失败*******");
  44. } finally {
  45. if (cstm != null)
  46. try {
  47. cstm.close();
  48. System.out.println("明细数据发送到一体化成功*------------------");
  49. } catch (Exception e) {
  50. e.printStackTrace();
  51. }
  52. }
  53. }
  54. }
  55. }