eb687aa5259c05e84cfc7bc332f66a3cb2942d6f.svn-base 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. package xin.glue.nui.G.G02;
  2. import java.math.BigDecimal;
  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.vo.PosParameter;
  7. import com.posdata.glue.dao.vo.PosRowSet;
  8. import com.posdata.glue.msg.PosMessage;
  9. /*
  10. * author:wangxiaoyan
  11. * Date:08-10-27
  12. * desc:把转炉LEVEL2中所发生的SCRAP装炉实绩电文接收过来录入到主.辅原料实绩表中 TBG03_MAINRAW
  13. */
  14. public class XinSaveScrapChargeResult extends PosActivity
  15. {
  16. public String runActivity(PosContext context)
  17. {
  18. PosMessage message = context.getMessage();
  19. // 从电文中获取的数据项
  20. String chargeNo = (String)message.get("CHARGE_NO");
  21. String scrapCd = (String)message.get("SCRAP_CD");
  22. BigDecimal scrapWgt = (BigDecimal)message.get("SCRAP_WGT");
  23. int chLth = chargeNo.trim().length();
  24. if (chLth < 10 ) {
  25. logger.logInfo("XinSaveScrapChargeResult CHARGE_NO ERROR !!!!-->"+chargeNo );
  26. return PosBizControlConstants.SUCCESS;
  27. }
  28. PosParameter param0 = new PosParameter();
  29. PosParameter param1 = new PosParameter();
  30. PosParameter param2 = new PosParameter();
  31. // 通过电文中的炉次号来判断 炼钢公共表中是否有此条记录 没有则不能进行操作
  32. param0.setWhereClauseParameter(0, chargeNo);
  33. PosRowSet rowset0 = this.getDao("mesdao").find("NIG020220_01.select",param0);
  34. if(rowset0.hasNext())
  35. {
  36. param1.setWhereClauseParameter(0, chargeNo);
  37. param1.setWhereClauseParameter(1, scrapCd);
  38. // 判断此条记录是否存在 从而确定插入或删除操作
  39. PosRowSet rowset1 = this.getDao("mesdao").find("NIG020220_02.select", param1);
  40. if(rowset1.hasNext())
  41. {
  42. param2.setWhereClauseParameter(0, scrapWgt);
  43. param2.setWhereClauseParameter(1, chargeNo);
  44. param2.setWhereClauseParameter(2, scrapCd);
  45. this.getDao("mesdao").update("NIG020220_01.update", param2);
  46. }
  47. else
  48. {
  49. param2.setValueParamter(0, chargeNo);
  50. param2.setValueParamter(1, scrapCd);
  51. param2.setValueParamter(2, scrapWgt);
  52. this.getDao("mesdao").insert("NIG020220_01.insert", param2);
  53. }
  54. }
  55. return PosBizControlConstants.SUCCESS;
  56. }
  57. }