2d523cf5713364f0f217f75ca7b0745e548c5dc5.svn-base 3.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192
  1. package xin.glue.ui.B.B01;
  2. import com.posdata.glue.biz.activity.PosActivity;
  3. import com.posdata.glue.biz.constants.PosBizControlConstants;
  4. import com.posdata.glue.context.PosContext;
  5. import com.posdata.glue.dao.PosGenericDao;
  6. import com.posdata.glue.dao.vo.PosParameter;
  7. /**
  8. *
  9. * @Description 插入、删除、修改替代钢号信息{界面ID:UIB010060}
  10. * @author 梅贵平{meiguiping}
  11. * @date 2008-9-23 上午08:46:23
  12. * @JDK Version jdk1.4.2
  13. */
  14. public class SaveModeStlGrdStatus extends PosActivity
  15. {
  16. public String runActivity(PosContext context)
  17. {
  18. String[] rowStuts = (String[])context.get("rowStuts");//删除计划钢号的信息(对行)
  19. PosGenericDao dao = this.getDao("mesdao");
  20. PosParameter param = null;
  21. String[] STL_GRD = (String[])context.get("STL_GRD");//获得计划钢号
  22. String[] STL_GRD1 = (String[])context.get("STL_GRD1");//用于更新,无其他作用
  23. String[] STL_GRD_YN = (String[])context.get("STL_GRD_YN");//区分标准钢号或者厂内钢号,F表厂内钢号,S表标准钢号
  24. int dLength = rowStuts.length;//总记录条数
  25. int COUNT = 10;//替代钢号共有10种
  26. String[][] MOD_STL_GRD = new String[COUNT][];
  27. MOD_STL_GRD[0] = (String[])context.get("MOD_STL_GRD1");//获得替代钢号1
  28. MOD_STL_GRD[1] = (String[])context.get("MOD_STL_GRD2");//获得替代钢号2
  29. MOD_STL_GRD[2] = (String[])context.get("MOD_STL_GRD3");//获得替代钢号3
  30. MOD_STL_GRD[3] = (String[])context.get("MOD_STL_GRD4");//获得替代钢号4
  31. MOD_STL_GRD[4] = (String[])context.get("MOD_STL_GRD5");//获得替代钢号5
  32. MOD_STL_GRD[5] = (String[])context.get("MOD_STL_GRD6");//获得替代钢号6
  33. MOD_STL_GRD[6] = (String[])context.get("MOD_STL_GRD7");//获得替代钢号7
  34. MOD_STL_GRD[7] = (String[])context.get("MOD_STL_GRD8");//获得替代钢号8
  35. MOD_STL_GRD[8] = (String[])context.get("MOD_STL_GRD9");//获得替代钢号9
  36. MOD_STL_GRD[9] = (String[])context.get("MOD_STL_GRD10");//获得替代钢号10
  37. for(int i= 0; i < dLength; i++)//第几个计划钢号
  38. {
  39. if("u".equals(rowStuts[i]))//更新替代钢号信息
  40. {
  41. if(STL_GRD1 !=null&&!(STL_GRD1.equals(STL_GRD)))
  42. {
  43. param = new PosParameter();
  44. param.setWhereClauseParameter(0, STL_GRD[i]); //更新的计划钢号
  45. param.setWhereClauseParameter(1, STL_GRD1[i]); //原计划钢号
  46. dao.update("UIB010060_02.UPDATE", param);
  47. }
  48. for(int j=0; j < COUNT; j++)
  49. {
  50. param = new PosParameter();
  51. param.setWhereClauseParameter(0, ( "".equals(MOD_STL_GRD[j][i]) )?" ": MOD_STL_GRD[j][i] );//替代钢号
  52. param.setWhereClauseParameter(1, STL_GRD[i]); //计划钢号
  53. param.setWhereClauseParameter(2, new Integer(j+1)); //替代钢号的序号
  54. int changeCount = dao.update("UIB010060_01.UPDATE", param); //更新替代钢号
  55. if(changeCount == 0)
  56. {
  57. param = new PosParameter();
  58. param.setValueParamter(0, STL_GRD[i]);
  59. param.setValueParamter(1, new Integer(j+1));//替代钢号的序号
  60. param.setValueParamter(2, ( "".equals(MOD_STL_GRD[j][i]) )?" ": MOD_STL_GRD[j][i] );//替代钢号
  61. param.setValueParamter(3, STL_GRD_YN[0]);
  62. dao.insert("UIB010060_01.INSERT", param);
  63. }
  64. }
  65. }
  66. if("d".equals(rowStuts[i]))//删除某计划钢号信息
  67. {
  68. param = new PosParameter();
  69. param.setWhereClauseParameter(0, STL_GRD[i]);
  70. dao.delete("UIB010060_01.DELETE", param);
  71. }
  72. if("i".equals(rowStuts[i]))//增加计划钢号信息
  73. {
  74. for(int j=0; j < COUNT; j++)
  75. {
  76. param = new PosParameter();
  77. param.setValueParamter(0, STL_GRD[i]);
  78. param.setValueParamter(1, new Integer(j+1));//替代钢号的序号
  79. param.setValueParamter(2, ( "".equals(MOD_STL_GRD[j][i]) )?" ": MOD_STL_GRD[j][i] );//替代钢号
  80. param.setValueParamter(3, STL_GRD_YN[0]);
  81. dao.insert("UIB010060_01.INSERT", param);
  82. }//for end
  83. }//if "i" end
  84. }//for rowStuts end
  85. return PosBizControlConstants.SUCCESS;
  86. }//runActivity method end
  87. }