e3bd9f7e73162dee3ef1627cc12f2087d3bd20b4.svn-base 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. package xin.glue.ui.F.F02;
  2. import java.sql.CallableStatement;
  3. import java.sql.SQLException;
  4. import java.sql.Types;
  5. import kr.co.comsquare.rwXmlLib.RwXml;
  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.context.PosContext;
  10. import com.posdata.glue.dao.vo.PosParameter;
  11. import com.posdata.glue.dao.vo.PosRowSet;
  12. import com.posdata.glue.transaction.PosDataSourceTransactionManager;
  13. import com.posdata.glue.transaction.PosTransactionManager;
  14. public class SaveMIllSch extends PosActivity {
  15. public String runActivity(PosContext ctx) {
  16. String[] OPERATE = (String[]) ctx.get("OPERATE");
  17. String[] FIRSTPOSITION = (String[]) ctx.get("FIRSTPOSITION");
  18. String[] AIMPOSITION = (String[]) ctx.get("AIMPOSITION");
  19. String[] LASTPOSITION = (String[]) ctx.get("LASTPOSITION");
  20. String[] POSITION = (String[]) ctx.get("POSITION");
  21. String P_RTN_MSG = "";
  22. // tx.clearTransactionStatus();
  23. CallableStatement cStmt = null;
  24. try {
  25. cStmt = this.getDao("mesdao").getCallableStatement("callUIF023020");
  26. cStmt.setString(1, FIRSTPOSITION[0]);
  27. cStmt.setString(2, LASTPOSITION[0]);
  28. cStmt.setString(3, AIMPOSITION[0]);
  29. cStmt.setString(4, POSITION[0]);
  30. cStmt.setString(5, OPERATE[0]);
  31. cStmt.registerOutParameter(6, Types.VARCHAR);
  32. cStmt.execute();
  33. P_RTN_MSG = cStmt.getString(6);
  34. } catch (SQLException e) {
  35. // e.printStackTrace();
  36. throw new PosException(e.getMessage());
  37. } finally {
  38. if (cStmt != null) {
  39. try {
  40. cStmt.close();
  41. } catch (SQLException e) {
  42. logger.logWarn(e.getMessage(), e);
  43. }
  44. }
  45. }
  46. if (P_RTN_MSG == null || "".equals(P_RTN_MSG)) {
  47. } else {
  48. throw new PosException(P_RTN_MSG);
  49. }
  50. return PosBizControlConstants.SUCCESS;
  51. }
  52. }