32661a8fbd9055da05b017a468cb57637c1375e0.svn-base 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. package xin.glue.ui.B.B02;
  2. import java.sql.CallableStatement;
  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.PosGenericDao;
  7. import com.posdata.glue.dao.vo.PosParameter;
  8. public class ShenBao extends PosActivity{
  9. public String runActivity(PosContext context)
  10. {
  11. PosParameter param = null;
  12. String []SLAB_NO = (String [])context.get("SLAB_NO"); //板坯号
  13. String []REG_NM = (String[])context.get("REG_NM");
  14. int iCount=SLAB_NO.length;
  15. PosGenericDao dao = this.getDao("mesdao");
  16. CallableStatement cstm = dao.getCallableStatement("UIB030202_07.CALLSTATEMENT");
  17. try{
  18. for(int i=0;i<iCount;i++)
  19. {
  20. /*param = new PosParameter();
  21. param.setValueParamter( 0, SLAB_NO[i] );
  22. getDao("mesdao").update("UIB030202_06.UPDATE",param);*/
  23. cstm.setString(1, SLAB_NO[i]);//板坯号
  24. cstm.setString(2, REG_NM[0]);//操作人
  25. cstm.setString(3, "Add");//为L或者为F,L为正常流转,F为判废
  26. cstm.registerOutParameter(5, java.sql.Types.VARCHAR);
  27. cstm.execute();
  28. }
  29. }catch(Exception e){
  30. e.printStackTrace();
  31. }
  32. return PosBizControlConstants.SUCCESS;
  33. }
  34. }