43ae2fee746b5adb1c9197b95b699189b7bd5ae8.svn-base 8.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218
  1. package xin.glue.nui.F.F01;
  2. import xin.glue.user.common.LogGpError;
  3. import com.posdata.glue.PosException;
  4. import com.posdata.glue.biz.activity.PosActivity;
  5. import com.posdata.glue.biz.constants.PosBizControlConstants;
  6. import com.posdata.glue.biz.control.PosBizProvider;
  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. import com.posdata.glue.msg.PosMESMessageImpl;
  12. import com.posdata.glue.msg.PosMessage;
  13. /* Program Name SMSRhLfChange
  14. * Description SMS WORK INSTRUCTION RH, LF LINE CHANGING
  15. * Write By wxy
  16. * Date 2010-3-10
  17. */
  18. public class SMSRhLfVdChange extends PosActivity {
  19. public String runActivity(PosContext ctx) {
  20. String[] P_PRC_PATH = (String[])ctx.get("PRC_PATH");
  21. String[] P_REG_ID = (String[])ctx.get("REG_ID");
  22. String[] P_CHARGE_MANA_NO = (String[])ctx.get("CHARGE_MANA_NO");
  23. String[] P_CHK = (String[])ctx.get("CHK");
  24. long V_CHARGE_EDT_SEQ = 0 ;
  25. long V_RH_TEMP_TGT = 0 ;
  26. long V_LF_TEMP_TGT = 0 ;
  27. long V_VD_TEMP_TGT = 0 ;
  28. long V_CHG_SEQ = 0 ;
  29. String V_PRC_LINE = "" ;
  30. String V_PATH_PROC_CD = "";
  31. String V_TREAT_RT_CD = "" ;
  32. String V_LINE_PROC_CD = "" ;
  33. String V_L2_SEND = "" ;
  34. String V_CCM_CHG = "N" ;
  35. String V_TIME_RESCH = "N" ;
  36. String V_TABLE_ID = "" ;
  37. String V_TABLE_MODE = "" ;
  38. String V_ERR_DESC = "" ;
  39. String V_RTN_NAME = "" ;
  40. int rows = P_CHK.length;
  41. for(int i = 0 ; i < rows ; i++){
  42. if(P_CHK[i].equals("true")){
  43. //CHARGE_MANA_NO CHECK
  44. PosParameter param0 = new PosParameter();
  45. param0.setWhereClauseParameter(0, P_CHARGE_MANA_NO[i]);
  46. PosRowSet ChargeManaNoInfVO = getDao("mesdao").find("NIF012170_ChargeManaNoInf.select",param0);
  47. ChargeManaNoInfVO.reset();
  48. if (ChargeManaNoInfVO.hasNext()) {
  49. PosRow ChargeManaNoInfRow = ChargeManaNoInfVO.next();
  50. V_PATH_PROC_CD = (String)ChargeManaNoInfRow.getAttribute("PATH_PROC_CD");
  51. V_LINE_PROC_CD = (String)ChargeManaNoInfRow.getAttribute("LINE_PROC_CD");
  52. V_PRC_LINE = (String)ChargeManaNoInfRow.getAttribute("PRC_LINE");
  53. V_L2_SEND = (String)ChargeManaNoInfRow.getAttribute("L2_SEND");
  54. V_CHARGE_EDT_SEQ = Long.parseLong((ChargeManaNoInfRow.getAttribute("CHARGE_EDT_SEQ")==null? "0":ChargeManaNoInfRow.getAttribute("CHARGE_EDT_SEQ")).toString());
  55. V_RH_TEMP_TGT = Long.parseLong((ChargeManaNoInfRow.getAttribute("RH_TGT_TEMP")==null? "0":ChargeManaNoInfRow.getAttribute("RH_TGT_TEMP")).toString());
  56. V_LF_TEMP_TGT = Long.parseLong((ChargeManaNoInfRow.getAttribute("LF_TGT_TEMP")==null? "0":ChargeManaNoInfRow.getAttribute("LF_TGT_TEMP")).toString());
  57. V_VD_TEMP_TGT = Long.parseLong((ChargeManaNoInfRow.getAttribute("VD_TGT_TEMP")==null? "0":ChargeManaNoInfRow.getAttribute("VD_TGT_TEMP")).toString());
  58. V_CHG_SEQ = Long.parseLong((ChargeManaNoInfRow.getAttribute("CHG_SEQ")==null? "0":ChargeManaNoInfRow.getAttribute("CHG_SEQ")).toString());
  59. } else {
  60. //MESSAGE ERROR --> PROGRAM EXIT
  61. throw new PosException("SMSRhLfChange..NOT FOUND CHARGE_MANA_NO INFORMATION..");
  62. }
  63. String preCCMNo = V_LINE_PROC_CD.substring((V_LINE_PROC_CD.length() - 2), V_LINE_PROC_CD.length());
  64. String curCCMNo = P_PRC_PATH[0].substring((P_PRC_PATH[0].length() - 2), P_PRC_PATH[0].length());
  65. if(!preCCMNo.equals(curCCMNo)){
  66. V_CCM_CHG = "Y";
  67. }else{
  68. V_CCM_CHG = "N";
  69. }
  70. if(P_PRC_PATH[0].indexOf("R")>= 0){
  71. }else{
  72. V_RH_TEMP_TGT = 0;
  73. }
  74. if(P_PRC_PATH[0].indexOf("L")>= 0){
  75. }else{
  76. V_LF_TEMP_TGT = 0;
  77. }
  78. if(P_PRC_PATH[0].indexOf("V")>= 0){
  79. }else{
  80. V_VD_TEMP_TGT = 0;
  81. }
  82. //TREAT_RT_CD CHECK
  83. PosParameter param1 = new PosParameter();
  84. param1.setWhereClauseParameter(0, P_PRC_PATH[0]);
  85. PosRowSet TreatRtInfVO = getDao("mesdao").find("NIF012170_TreatRtInf.select",param1);
  86. TreatRtInfVO.reset();
  87. if (TreatRtInfVO.hasNext()) {
  88. PosRow TreatRtRow = TreatRtInfVO.next();
  89. V_TREAT_RT_CD = (String)TreatRtRow.getAttribute("SM_CD");
  90. } else {
  91. //MESSAGE ERROR --> PROGRAM EXIT
  92. throw new PosException("SMSRhLfChange..NOT FOUND TreatRtInf INFORMATION..");
  93. }
  94. //RH, LF LINE CHANGE --> TBF01_SPEC_CHARGE UPDATE
  95. PosParameter param2 = new PosParameter();
  96. param2.setWhereClauseParameter(0, P_PRC_PATH[0]);
  97. param2.setWhereClauseParameter(1, P_PRC_PATH[0]);
  98. param2.setWhereClauseParameter(2, V_TREAT_RT_CD);
  99. param2.setWhereClauseParameter(3, String.valueOf(V_RH_TEMP_TGT));
  100. param2.setWhereClauseParameter(4, String.valueOf(V_LF_TEMP_TGT));
  101. param2.setWhereClauseParameter(5, String.valueOf(V_VD_TEMP_TGT));
  102. param2.setWhereClauseParameter(6, String.valueOf(V_CHARGE_EDT_SEQ));
  103. int UpdCnt1 = getDao("mesdao").update("NIF012170_ChargeProcLineUpd.update",param2);
  104. if (UpdCnt1 == 0) {
  105. V_TABLE_ID = "TBF01_SPEC_CHARGE";
  106. V_TABLE_MODE = "U";
  107. V_ERR_DESC = "TBF01_SPEC_CHARGE UPDATE COUNT IS ZERO";
  108. V_RTN_NAME = "SMSRhLfChange TBF01_SPEC_CHARGE UPDATE1 " + String.valueOf(V_CHARGE_EDT_SEQ);
  109. LogGpError.logMessageToDB("SMSRhLfChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
  110. throw new PosException(V_RTN_NAME);
  111. }
  112. //CALL NIF012180_SMSSchTme
  113. //NIF012180_CALL(V_PRC_LINE, V_L2_SEND, P_REG_ID[0]);
  114. if(V_L2_SEND.equals("Y")){
  115. //TBG06_L2_CHARGE_INS INSERT 出钢指示 SEND_CLF = 'U'
  116. PosParameter param4 = new PosParameter();
  117. param4.setValueParamter(0, V_PRC_LINE);
  118. param4.setValueParamter(1, V_PRC_LINE);
  119. param4.setValueParamter(2, String.valueOf(V_CHARGE_EDT_SEQ));
  120. int InsCnt1 = getDao("mesdao").insert("NIF012170_L2Charge.insert",param4);
  121. if (InsCnt1 == 0) {
  122. V_TABLE_ID = "TBG06_L2_CHARGE_INS";
  123. V_TABLE_MODE = "I";
  124. V_ERR_DESC = "TBG06_L2_CHARGE_INS UPDATE COUNT IS ZERO";
  125. V_RTN_NAME = "SMSRhLfChange TBG06_L2_CHARGE_INS INSERTE1 " + String.valueOf(V_CHARGE_EDT_SEQ);
  126. LogGpError.logMessageToDB("SMSRhLfChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
  127. throw new PosException(V_RTN_NAME);
  128. }
  129. if (V_CCM_CHG.equals("Y")) {
  130. //TBG06_L2_CCM_INS INSERT 连铸指示 SEND_CLF = 'U'
  131. PosParameter param5 = new PosParameter();
  132. param5.setValueParamter(0, V_PRC_LINE);
  133. param5.setValueParamter(1, V_PRC_LINE);
  134. param5.setValueParamter(2, String.valueOf(V_CHARGE_EDT_SEQ));
  135. int InsCnt2 = getDao("mesdao").insert("NIF012170_L2Ccm.insert",param5);
  136. if (InsCnt2 == 0) {
  137. V_TABLE_ID = "TBG06_L2_CCM_INS";
  138. V_TABLE_MODE = "I";
  139. V_ERR_DESC = "TBG06_L2_CCM_INS UPDATE COUNT IS ZERO";
  140. V_RTN_NAME = "SMSRhLfChange TBG06_L2_CCM_INS INSERTE2 " + String.valueOf(V_CHARGE_EDT_SEQ);
  141. LogGpError.logMessageToDB("SMSRhLfChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
  142. throw new PosException(V_RTN_NAME);
  143. }
  144. }
  145. }
  146. } // end if(P_CHK[i].equals("true"))
  147. }// end for(int i = 0 ; i < rows ; i++)
  148. return PosBizControlConstants.SUCCESS;
  149. }
  150. public PosContext NIF012180_CALL(String V_PRC_LINE, String V_L2_SEND, String V_REG_ID)
  151. {
  152. PosContext context = new PosContext();
  153. PosMessage message = new PosMESMessageImpl();
  154. //SMSSchTme
  155. String TcId = "NIF012180";
  156. message.setTCID(TcId);
  157. message.setObject("MSG_ID", TcId);
  158. message.setObject("PRC_LINE", V_PRC_LINE);
  159. message.setObject("L2_SEND", V_L2_SEND);
  160. message.setObject("CHARGE_MANA_NO", "");
  161. message.setObject("REG_ID", V_REG_ID);
  162. context.setMessage(message);
  163. message.setTCID(TcId);
  164. String SERVICE_POSTFIX = "-service";
  165. context.put(PosBizControlConstants.SERVICE_NAME, TcId + SERVICE_POSTFIX);
  166. PosBizProvider.getController().doSubController(context, false);
  167. String SERVICE_ERR_MSG = (String) context.get("SERVICE_ERR_MSG");
  168. if (SERVICE_ERR_MSG != null)
  169. {
  170. throw new PosException(SERVICE_ERR_MSG);
  171. }
  172. return context;
  173. }
  174. }