7780588ca3d249fe7743c627bc5717755616e2e7.svn-base 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. package xin.glue.ui.H.H05;
  2. import java.math.BigDecimal;
  3. import xin.glue.ui.common.PosGridSave;
  4. import xin.glue.ui.common.component.PosSiteLog;
  5. import com.posdata.glue.biz.activity.PosActivity;
  6. import com.posdata.glue.biz.constants.PosBizControlConstants;
  7. import com.posdata.glue.context.PosContext;
  8. import com.posdata.glue.dao.vo.PosParameter;
  9. import com.posdata.glue.dao.vo.PosRow;
  10. import com.posdata.glue.dao.vo.PosRowSet;
  11. /*
  12. * 钢卷移动处理,为了方便业务使用
  13. * @author TangLiang 唐亮
  14. * @data 2009.07.11
  15. */
  16. public class XinSaveMoveYard extends PosActivity{
  17. public String runActivity(PosContext context)
  18. {
  19. //表格的状态
  20. String[] rowStuts = (String[]) context.get("rowStuts");
  21. //库存位置
  22. String[] COIL_YARD = (String[]) context.get("COIL_YARD");
  23. //钢卷号
  24. String[] COIL_NO = (String[]) context.get("COIL_NO");
  25. //录入人
  26. String[] REG_ID = (String[]) context.get("REG_ID");
  27. String user = null;
  28. for(int j=0;j<REG_ID.length;j++){
  29. if(!REG_ID[j].equals("") && REG_ID[j] != null){
  30. user = REG_ID[j];
  31. }
  32. }
  33. for(int i=0;i<rowStuts.length;i++){
  34. PosParameter param0 = new PosParameter();
  35. param0.setWhereClauseParameter(0, COIL_YARD[i]);
  36. PosRowSet rows = getDao("mesdao").find("UIH050600_05.select", param0);
  37. if(!rows.hasNext()){
  38. logger.logInfo("垛位不存在!");
  39. String vtemp = "COIL_NO";
  40. context.put("rs", vtemp);
  41. return PosBizControlConstants.SUCCESS;
  42. }
  43. //更新库存位置表
  44. PosParameter param1 = new PosParameter();
  45. param1.setWhereClauseParameter(0, COIL_NO[i]);
  46. param1.setWhereClauseParameter(1, user);
  47. param1.setWhereClauseParameter(2, COIL_YARD[i].substring(0, 5));
  48. param1.setWhereClauseParameter(3, COIL_YARD[i].substring(5, 7));
  49. param1.setWhereClauseParameter(4, COIL_YARD[i].substring(7, 8));
  50. param1.setWhereClauseParameter(5, COIL_YARD[i].substring(8, 9));
  51. getDao("mesdao").update("UIH050700_04.update", param1);
  52. //更新钢卷公共表
  53. PosParameter param2 = new PosParameter();
  54. param2.setWhereClauseParameter(0, COIL_YARD[i]);
  55. param2.setWhereClauseParameter(1, COIL_NO[i]);
  56. getDao("mesdao").update("UIH050700_05.update", param2);
  57. }
  58. return PosBizControlConstants.SUCCESS;
  59. }
  60. }