package xin.glue.nui.F.F01; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Date; import xin.glue.user.common.DateUtils; import xin.glue.user.common.GlobalConstants; import xin.glue.user.common.LogGpError; import xin.glue.user.common.StringUtils; import com.posdata.glue.PosException; import com.posdata.glue.biz.activity.PosActivity; import com.posdata.glue.biz.constants.PosBizControlConstants; import com.posdata.glue.context.PosContext; import com.posdata.glue.dao.vo.PosParameter; import com.posdata.glue.dao.vo.PosRow; import com.posdata.glue.dao.vo.PosRowSet; import com.posdata.glue.msg.PosMessage; /* Program Name SMSSchTme (NIF012180) * Description SMS WORK TIME RESCHEDULE * Write By KIM SUNG HO * Date 2008-10-30 */ public class SMSSchTme extends PosActivity implements GlobalConstants { public String runActivity(PosContext context) { long V_CHG_SEQ = 0 ; long V_ORG_SEQ = 0 ; long V_BC_MOVE_TME = 0 ; long V_CR_MOVE_TME = 0 ; long V_CL_MOVE_TME = 0 ; long V_CJ_MOVE_TME = 0 ; long V_RL_MOVE_TME = 0 ; long V_RJ_MOVE_TME = 0 ; long V_LJ_MOVE_TME = 0 ; long V_LADLE_MOVE_TME = 0 ; long V_CCM_CAN_STR_TME = 0 ; long V_NEED_TME = 0 ; long V_BOF_NEED_TME = 0 ; long V_CAS_NEED_TME = 0 ; long V_RH_NEED_TME = 0 ; long V_LF_NEED_TME = 0 ; long V_CCM_NEED_TME = 0 ; long V_SHIFT_TME = 0 ; long V_SLAB_CCM_CUT = 0 ; long V_SLAB_CNT = 0 ; long V_MAX_CCM_TME = 0 ; long V_CHARGE_EDT_SEQ = 0 ; long V_CHARGE_SLAB_SEQ = 0 ; long V_SLAB_EDT_SEQ = 0 ; long C_TAKE_HM = 5 ; long C_GIVE_LD = 5 ; long C_TD_CHG_GAP = 5 ; String V_PROC_CD = "" ; String V_STR_PROC_CD = "" ; String V_END_PROC_CD = "" ; String V_PRC_LINE = "" ; String V_STL_GRD_CD = "" ; String V_TMP_STL_GRD_CD = "" ; String V_PATH_PROC_CD = "" ; String V_BOF_STR = "" ; String V_BLOW_STR = "" ; String V_BOF_LD_STR = "" ; String V_BOF_END = "" ; String V_CAS_STR = "" ; String V_CAS_END = "" ; String V_LF_STR = "" ; String V_LF_END = "" ; String V_RH_STR = "" ; String V_RH_END = "" ; String V_CCM_STR = "" ; String V_CCM_END = "" ; String V_BEF_PROC_END = "" ; String V_LF_FL = "" ; String V_RH_FL = "" ; String V_CHARGE_MANA_IC = "" ; String V_CHARGE_MANA_TM = "" ; String V_START_FL = "" ; String V_TABLE_ID = "" ; String V_TABLE_MODE = "" ; String V_ERR_DESC = "" ; String V_RTN_NAME = "" ; PosMessage message = context.getMessage(); String P_PRC_LINE = (String)message.get("PRC_LINE"); String P_L2_SEND = (String)message.get("L2_SEND"); // try { //SELECT START PROC_CD, END PROC_CD, LADLE_MOVE_TIME PosRowSet ldlMoveTmeVO = getDao("mesdao").find("NIF012180_LadleMvTme.select"); ldlMoveTmeVO.reset(); while(ldlMoveTmeVO.hasNext()) { PosRow ldlMoveTmeRow = ldlMoveTmeVO.next(); V_STR_PROC_CD = (String)ldlMoveTmeRow.getAttribute("STR_PROC_CD"); V_END_PROC_CD = (String)ldlMoveTmeRow.getAttribute("END_PROC_CD"); V_LADLE_MOVE_TME = Long.parseLong((ldlMoveTmeRow.getAttribute("LADLE_MOVE_TME")==null? "0":ldlMoveTmeRow.getAttribute("LADLE_MOVE_TME")).toString()); if ((V_STR_PROC_CD+V_END_PROC_CD).equals("JBJC")) { //BOF --> CAS V_BC_MOVE_TME = V_LADLE_MOVE_TME; } else if ((V_STR_PROC_CD+V_END_PROC_CD).equals("JCJR")) { //CAS --> RH V_CR_MOVE_TME = V_LADLE_MOVE_TME; } else if ((V_STR_PROC_CD+V_END_PROC_CD).equals("JCJL")) { //CAS --> LH V_CL_MOVE_TME = V_LADLE_MOVE_TME; } else if ((V_STR_PROC_CD+V_END_PROC_CD).equals("JCJJ")) { //CAS --> CCM V_CJ_MOVE_TME = V_LADLE_MOVE_TME; } else if ((V_STR_PROC_CD+V_END_PROC_CD).equals("JRJL")) { //RH --> LF V_RL_MOVE_TME = V_LADLE_MOVE_TME; } else if ((V_STR_PROC_CD+V_END_PROC_CD).equals("JRJJ")) { //RH --> CCM V_RJ_MOVE_TME = V_LADLE_MOVE_TME; } else if ((V_STR_PROC_CD+V_END_PROC_CD).equals("JLJJ")) { //LF --> CCM V_LJ_MOVE_TME = V_LADLE_MOVE_TME; } } //ldlMoveTmeVO while END DateFormat formatter = new SimpleDateFormat("yyyyMMddHHmmss"); String currDate = (String)formatter.format(new Date()); //BOF LINE Setting int j, k; if (P_PRC_LINE == null) { P_PRC_LINE = "3"; } if (P_PRC_LINE.equals("1")) { //BOF LINE #1 j = 1; k = 1; } else if (P_PRC_LINE.equals("2")) { //BOF LINE #2 j = 2; k = 2; } else { //BOF LINE #1, #2 j = 1; k = 2; } V_TMP_STL_GRD_CD = ""; V_CHARGE_MANA_TM = "0000000000"; V_CHG_SEQ = 0; //BOF LINE #1, #2 for (int i = j; i <= k; i++) { V_CCM_STR = ""; V_CCM_END = ""; V_TMP_STL_GRD_CD = ""; V_START_FL = "Y"; V_PRC_LINE = String.valueOf(i); if (P_L2_SEND.equals("Y")) { //SELECT LAST CHARGE WORK TIME PosParameter paramA = new PosParameter(); paramA.setWhereClauseParameter(0, V_PRC_LINE); PosRowSet LastChargeInfVO = getDao("mesdao").find("NIF012180_LastChargeTme1.select",paramA); LastChargeInfVO.reset(); if (LastChargeInfVO.hasNext()) { PosRow LastChargeInfRow = LastChargeInfVO.next(); V_CCM_STR = (String)LastChargeInfRow.getAttribute("CCM_STR"); V_CCM_END = (String)LastChargeInfRow.getAttribute("CCM_END"); V_TMP_STL_GRD_CD = (String)LastChargeInfRow.getAttribute("STL_GRP_CD"); V_CHARGE_MANA_TM = (String)LastChargeInfRow.getAttribute("CHARGE_MANA_NO"); V_CHG_SEQ = Long.parseLong((LastChargeInfRow.getAttribute("CHG_SEQ")==null? "0":LastChargeInfRow.getAttribute("CHG_SEQ")).toString()); } } else { //SELECT LAST CHARGE WORK TIME PosParameter paramA = new PosParameter(); paramA.setWhereClauseParameter(0, V_PRC_LINE); paramA.setWhereClauseParameter(1, V_PRC_LINE); PosRowSet LastChargeInfVO = getDao("mesdao").find("NIF012180_LastChargeTme2.select",paramA); LastChargeInfVO.reset(); if (LastChargeInfVO.hasNext()) { PosRow LastChargeInfRow = LastChargeInfVO.next(); V_CCM_STR = (String)LastChargeInfRow.getAttribute("CCM_STR"); V_CCM_END = (String)LastChargeInfRow.getAttribute("CCM_END"); V_TMP_STL_GRD_CD = (String)LastChargeInfRow.getAttribute("STL_GRP_CD"); V_CHARGE_MANA_TM = (String)LastChargeInfRow.getAttribute("CHARGE_MANA_NO"); V_CHG_SEQ = Long.parseLong((LastChargeInfRow.getAttribute("CHG_SEQ")==null? "0":LastChargeInfRow.getAttribute("CHG_SEQ")).toString()); } } if (V_CCM_END == null || (V_CCM_END.compareTo(currDate) < 0)) { V_CCM_END = currDate; V_CCM_END = DateUtils.getStringDateAddedTime(V_CCM_END, 0, 0, 120, 0); V_CCM_STR = DateUtils.getStringDateAddedTime(V_CCM_END, 0, 0, -30, 0); } //SELECT TBF01_SPEC_CHARGE A, TBF01_CHARGE_IDX B WHERE > V_CHARGE_MANA_NO PosParameter param1 = new PosParameter(); param1.setWhereClauseParameter(0, V_PRC_LINE); param1.setWhereClauseParameter(1, String.valueOf(V_CHG_SEQ)); PosRowSet ChargeInfVO = getDao("mesdao").find("NIF012180_ChargeInf.select",param1); ChargeInfVO.reset(); while(ChargeInfVO.hasNext()) { PosRow ChargeInfRow = ChargeInfVO.next(); V_STL_GRD_CD = (String)ChargeInfRow.getAttribute("STL_GRP_CD"); V_PATH_PROC_CD = (String)ChargeInfRow.getAttribute("PATH_PROC_CD"); V_CHARGE_EDT_SEQ = Long.parseLong((ChargeInfRow.getAttribute("CHARGE_EDT_SEQ")==null? "0":ChargeInfRow.getAttribute("CHARGE_EDT_SEQ")).toString()); V_ORG_SEQ = Long.parseLong((ChargeInfRow.getAttribute("ORG_SEQ")==null? "0":ChargeInfRow.getAttribute("ORG_SEQ")).toString()); if (V_START_FL.equals("Y") || V_TMP_STL_GRD_CD.equals("") || !V_STL_GRD_CD.equals(V_TMP_STL_GRD_CD)) { //TUNDISH CHANGE if (!V_STL_GRD_CD.equals(V_TMP_STL_GRD_CD)) { V_CCM_END = DateUtils.getStringDateAddedTime(V_CCM_END, 0, 0, (int)C_TD_CHG_GAP, 0); V_CCM_STR = DateUtils.getStringDateAddedTime(V_CCM_STR, 0, 0, (int)C_TD_CHG_GAP, 0); } V_TMP_STL_GRD_CD = V_STL_GRD_CD; V_START_FL = "N"; V_BOF_NEED_TME = 0; V_CAS_NEED_TME = 0; V_RH_NEED_TME = 0; V_LF_NEED_TME = 0; V_CCM_NEED_TME = 0; //SELECT TBF01_SMS_TTT SMS WORK NEED TIME PosParameter param2 = new PosParameter(); param2.setWhereClauseParameter(0, V_TMP_STL_GRD_CD); PosRowSet ProcNeedTMEVO = getDao("mesdao").find("NIF012180_ProcNeedTME.select",param2); ProcNeedTMEVO.reset(); while(ProcNeedTMEVO.hasNext()) { PosRow ProcNeedTMERow = ProcNeedTMEVO.next(); V_PROC_CD = (String)ProcNeedTMERow.getAttribute("PROC_CD"); V_NEED_TME = Long.parseLong((ProcNeedTMERow.getAttribute("NEED_STD_TME")==null? "0":ProcNeedTMERow.getAttribute("NEED_STD_TME")).toString()); if (V_PROC_CD.equals("JB")) { V_BOF_NEED_TME = V_NEED_TME; } else if (V_PROC_CD.equals("JC")) { V_CAS_NEED_TME = V_NEED_TME; } else if (V_PROC_CD.equals("JR")) { V_RH_NEED_TME = V_NEED_TME; } else if (V_PROC_CD.equals("JL")) { V_LF_NEED_TME = V_NEED_TME; } else if (V_PROC_CD.equals("JJ")) { V_CCM_NEED_TME = V_NEED_TME; } } //ProcNeedTMEVO while END } V_RH_FL = "N"; V_LF_FL = "N"; if (V_PATH_PROC_CD.indexOf("JR") > 0) { V_RH_FL = "Y"; } if (V_PATH_PROC_CD.indexOf("JL") > 0) { V_LF_FL = "Y"; } //SELECT SUM(CCM_CUT_TME) FROM TBF01_SPEC_SLAB PosParameter param3 = new PosParameter(); param3.setWhereClauseParameter(0, String.valueOf(V_CHARGE_EDT_SEQ)); PosRowSet CcmCutTmeVO = getDao("mesdao").find("NIF012180_CcmCutTme.select",param3); CcmCutTmeVO.reset(); if (CcmCutTmeVO.hasNext()) { PosRow CcmCutTmeRow = CcmCutTmeVO.next(); V_CCM_NEED_TME = Long.parseLong((CcmCutTmeRow.getAttribute("CCM_CUT_TME")==null? "0":CcmCutTmeRow.getAttribute("CCM_CUT_TME")).toString()); V_SLAB_CNT = Long.parseLong((CcmCutTmeRow.getAttribute("SLAB_CNT")==null? "0":CcmCutTmeRow.getAttribute("SLAB_CNT")).toString()); V_MAX_CCM_TME = Long.parseLong((CcmCutTmeRow.getAttribute("MAX_CUT_TME")==null? "0":CcmCutTmeRow.getAttribute("MAX_CUT_TME")).toString()); if (V_SLAB_CNT % 2 == 0) { V_CCM_NEED_TME = V_CCM_NEED_TME / 2; } else { V_CCM_NEED_TME = (V_CCM_NEED_TME / 2) + V_MAX_CCM_TME; } } else { V_CCM_NEED_TME = 0; } //CCM PROCESS TIME V_CCM_CAN_STR_TME = DateUtils.getDurationByMinute(V_CCM_STR, V_CCM_END) / 5; V_CCM_STR = DateUtils.getStringDateAddedTime(V_CCM_END, 0, 0, (int)-V_CCM_CAN_STR_TME, 0); V_CCM_END = DateUtils.getStringDateAddedTime(V_CCM_STR, 0, 0, (int)V_CCM_NEED_TME, 0); V_BEF_PROC_END = V_CCM_STR; //LF PROCESS TIME if (V_LF_FL.equals("Y")) { V_LF_END = DateUtils.getStringDateAddedTime(V_BEF_PROC_END, 0, 0, (int)-V_LJ_MOVE_TME, 0); V_LF_STR = DateUtils.getStringDateAddedTime(V_LF_END, 0, 0, (int)-V_LF_NEED_TME, 0); V_BEF_PROC_END = V_LF_STR; } else { V_LF_STR = V_BEF_PROC_END; V_LF_END = V_BEF_PROC_END; } //RH PROCESS TIME if (V_RH_FL.equals("Y")) { if (V_LF_FL.equals("Y")) { V_RH_END = DateUtils.getStringDateAddedTime(V_BEF_PROC_END, 0, 0, (int)-V_RL_MOVE_TME, 0); } else { V_RH_END = DateUtils.getStringDateAddedTime(V_BEF_PROC_END, 0, 0, (int)-V_RJ_MOVE_TME, 0); } V_RH_STR = DateUtils.getStringDateAddedTime(V_RH_END, 0, 0, (int)-V_RH_NEED_TME, 0); V_BEF_PROC_END = V_RH_STR; } else { V_RH_STR = V_BEF_PROC_END; V_RH_END = V_BEF_PROC_END; } //CAS PROCESS TIME if (V_RH_FL.equals("Y")) { V_CAS_END = DateUtils.getStringDateAddedTime(V_BEF_PROC_END, 0, 0, (int)-V_CR_MOVE_TME, 0); } else if (V_LF_FL.equals("Y")) { V_CAS_END = DateUtils.getStringDateAddedTime(V_BEF_PROC_END, 0, 0, (int)-V_CL_MOVE_TME, 0); } else { V_CAS_END = DateUtils.getStringDateAddedTime(V_BEF_PROC_END, 0, 0, (int)-V_CJ_MOVE_TME, 0); } V_CAS_STR = DateUtils.getStringDateAddedTime(V_CAS_END, 0, 0, (int)-V_CAS_NEED_TME, 0); V_BEF_PROC_END = V_CAS_STR; //BOF PROCESS TIME V_BOF_END = DateUtils.getStringDateAddedTime(V_BEF_PROC_END, 0, 0, (int)-V_BC_MOVE_TME, 0); V_BOF_LD_STR = DateUtils.getStringDateAddedTime(V_BOF_END, 0, 0, (int)-C_GIVE_LD, 0); V_BOF_STR = DateUtils.getStringDateAddedTime(V_BOF_END, 0, 0, (int)-V_BOF_NEED_TME, 0); V_BLOW_STR = DateUtils.getStringDateAddedTime(V_BOF_STR, 0, 0, (int)C_TAKE_HM, 0); //BOF_STR TIME AMD CURRENT TIME CHECK if (V_BOF_STR.compareTo(currDate) <= 0) { V_SHIFT_TME = DateUtils.getDurationByMinute(V_BOF_STR, currDate) + 5; V_BOF_STR = DateUtils.getStringDateAddedTime(V_BOF_STR, 0, 0, (int)V_SHIFT_TME, 0); V_BLOW_STR = DateUtils.getStringDateAddedTime(V_BLOW_STR, 0, 0, (int)V_SHIFT_TME, 0); V_BOF_LD_STR = DateUtils.getStringDateAddedTime(V_BOF_LD_STR, 0, 0, (int)V_SHIFT_TME, 0); V_BOF_END = DateUtils.getStringDateAddedTime(V_BOF_END, 0, 0, (int)V_SHIFT_TME, 0); V_CAS_STR = DateUtils.getStringDateAddedTime(V_CAS_STR, 0, 0, (int)V_SHIFT_TME, 0); V_CAS_END = DateUtils.getStringDateAddedTime(V_CAS_END, 0, 0, (int)V_SHIFT_TME, 0); V_RH_STR = DateUtils.getStringDateAddedTime(V_RH_STR, 0, 0, (int)V_SHIFT_TME, 0); V_RH_END = DateUtils.getStringDateAddedTime(V_RH_END, 0, 0, (int)V_SHIFT_TME, 0); V_LF_STR = DateUtils.getStringDateAddedTime(V_LF_STR, 0, 0, (int)V_SHIFT_TME, 0); V_LF_END = DateUtils.getStringDateAddedTime(V_LF_END, 0, 0, (int)V_SHIFT_TME, 0); V_CCM_STR = DateUtils.getStringDateAddedTime(V_CCM_STR, 0, 0, (int)V_SHIFT_TME, 0); V_CCM_END = DateUtils.getStringDateAddedTime(V_CCM_END, 0, 0, (int)V_SHIFT_TME, 0); } //DIFF YEAR CHARGE_MANA_NO //V_BOF_STR="201700020201"; /*if (V_CHARGE_MANA_TM.equals("0000000000") || !V_CHARGE_MANA_TM.substring(1, 2).equals(V_BOF_STR.substring(3, 4))) { if(currDate.substring(3, 4).equals(V_BOF_STR.substring(3, 4))) { if(V_PRC_LINE.equals("2")) V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(V_BOF_STR.substring(3, 4)).append(V_PRC_LINE).append("-00500A").toString(); //二号炉跨年加500 else V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(V_BOF_STR.substring(3, 4)).append(V_PRC_LINE).append("-00000A").toString(); } }*/ //百年则改为!V_CHARGE_MANA_TM.substring(1, 3).equals(currDate.substring(2, 4) if (V_CHARGE_MANA_TM.equals("0000000000") || !V_CHARGE_MANA_TM.substring(1, 2).equals(currDate.substring(3, 4))) { if(V_PRC_LINE.equals("1")) V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(currDate.substring(3, 4)).append(V_PRC_LINE).append("-00500A").toString(); //一号炉跨年加500 20191231 //数智化部要求炼钢厂将坯号改为如J22201409A 此类第2-3位代表具体百年年份的新坯号并去掉"-" jiangxin 20220427 //V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(currDate.substring(2, 4)).append(V_PRC_LINE).append("00500A").toString(); else V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(currDate.substring(3, 4)).append(V_PRC_LINE).append("-00000A").toString(); //V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(currDate.substring(2, 4)).append(V_PRC_LINE).append("00000A").toString(); } /*if(V_CHARGE_MANA_TM.equals(new StringBuffer(10).append("3").append(V_BOF_STR.substring(3, 4)).append("2-00001A"))) { V_CHARGE_MANA_TM= new StringBuffer(10).append("3").append(V_BOF_STR.substring(3, 4)).append(V_PRC_LINE).append("-00500A").toString(); } if (V_CHARGE_MANA_TM.equals("0000000000")) { if(V_PRC_LINE.equals("2")) V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(V_BOF_STR.substring(3, 4)).append(V_PRC_LINE).append("-00500A").toString(); //二号炉跨年加500 else V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(V_BOF_STR.substring(3, 4)).append(V_PRC_LINE).append("-00001A").toString(); }*/ //CHG_SEQ + 1, CHARGE_MANA_NO + 1 ---------------------------------------------- V_CHARGE_MANA_IC = StringUtils.calculateIntegerStringValue(V_CHARGE_MANA_TM.substring(4, 9), 1); //数智化部要求炼钢厂将坯号改为如J22201409A 此类第2-3位代表具体百年年份的新坯号并去掉"-" jiangxin 20220427 V_CHARGE_MANA_TM = new StringBuffer(10).append(V_CHARGE_MANA_TM.substring(0, 4)).append(V_CHARGE_MANA_IC).append(V_CHARGE_MANA_TM.substring(9, 10)).toString(); //V_CHARGE_MANA_TM = new StringBuffer(10).append("3").append(currDate.substring(2,4)).append(V_PRC_LINE).append(V_CHARGE_MANA_IC).append(V_CHARGE_MANA_TM.substring(9, 10)).toString(); ++V_CHG_SEQ; //UPDATE TBF01_CHARGE_IDX PosParameter param13 = new PosParameter(); param13.setWhereClauseParameter(0, String.valueOf(V_CHG_SEQ)); param13.setWhereClauseParameter(1, V_CHARGE_MANA_TM); param13.setWhereClauseParameter(2, V_CHARGE_MANA_TM); param13.setWhereClauseParameter(3, String.valueOf(V_ORG_SEQ)); int UpdCnt5 = getDao("mesdao").update("NIF012180_ChgIdxBefUpd.update",param13); if (UpdCnt5 == 0) { V_TABLE_ID = "TBF01_CHARGE_IDX"; V_TABLE_MODE = "U"; V_ERR_DESC = "TBF01_CHARGE_IDX UPDATE COUNT IS ZERO"; V_RTN_NAME = "SMSSchTme TBF01_CHARGE_IDX UPDATE5 " + String.valueOf(V_ORG_SEQ); LogGpError.logMessageToDB("SMSSchTme", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); throw new PosException(V_RTN_NAME); } //UPDATE TBF01_SPEC_SLAB PosParameter param15 = new PosParameter(); param15.setWhereClauseParameter(0, V_CHARGE_MANA_TM); param15.setWhereClauseParameter(1, V_CHARGE_MANA_TM); param15.setWhereClauseParameter(2, String.valueOf(V_CHARGE_EDT_SEQ)); int UpdCnt7 = getDao("mesdao").update("NIF012180_SpecSlabBefUpd.update",param15); if (UpdCnt7 == 0) { V_TABLE_ID = "TBF01_SPEC_SLAB"; V_TABLE_MODE = "U"; V_ERR_DESC = "TBF01_SPEC_SLAB UPDATE COUNT IS ZERO"; V_RTN_NAME = "SMSSchTme TBF01_SPEC_SLAB UPDATE7 ChargeEdtSeq = [" + String.valueOf(V_CHARGE_EDT_SEQ) + "]"; LogGpError.logMessageToDB("SMSSchTme", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); throw new PosException(V_RTN_NAME); } //UPDATE TBF01_SPEC_CHARGE SMS WORK NEED TIME PosParameter param4 = new PosParameter(); param4.setWhereClauseParameter(0 , V_BOF_STR); param4.setWhereClauseParameter(1 , V_BLOW_STR); param4.setWhereClauseParameter(2 , V_BOF_LD_STR); param4.setWhereClauseParameter(3 , V_BOF_END); param4.setWhereClauseParameter(4 , V_CAS_STR); param4.setWhereClauseParameter(5 , V_CAS_END); param4.setWhereClauseParameter(6 , V_RH_STR); param4.setWhereClauseParameter(7 , V_RH_END); param4.setWhereClauseParameter(8 , V_LF_STR); param4.setWhereClauseParameter(9 , V_LF_END); param4.setWhereClauseParameter(10, V_CCM_STR); param4.setWhereClauseParameter(11, V_CCM_END); param4.setWhereClauseParameter(12, String.valueOf(V_CCM_NEED_TME)); param4.setWhereClauseParameter(13, V_CHARGE_MANA_TM); param4.setWhereClauseParameter(14, String.valueOf(V_CHARGE_EDT_SEQ)); int UpdCnt1 = getDao("mesdao").update("NIF012180_SMSWorkTmeCharge.update",param4); if (UpdCnt1 == 0) { V_TABLE_ID = "TBF01_SPEC_CHARGE"; V_TABLE_MODE = "U"; V_ERR_DESC = "TBF01_SPEC_CHARGE UPDATE COUNT IS ZERO"; V_RTN_NAME = "SMSSchTme TBF01_SPEC_CHARGE UPDATE1 " + String.valueOf(V_CHARGE_EDT_SEQ); LogGpError.logMessageToDB("SMSSchTme", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); throw new PosException(V_RTN_NAME); } //2009.03.06 MODIFY KIM // //SELECT TBF01_SPEC_SLAB A (UNIT SLAB CCM_CUT_TME) // PosParameter param5 = new PosParameter(); // param5.setWhereClauseParameter(0, String.valueOf(V_CHARGE_EDT_SEQ)); // PosRowSet SlabInfVO = getDao("mesdao").find("NIF012180_SlabInf.select",param5); // SlabInfVO.reset(); // // while(SlabInfVO.hasNext()) { // // PosRow SlabInfRow = SlabInfVO.next(); // V_CHARGE_SLAB_SEQ = Long.parseLong((SlabInfRow.getAttribute("CHARGE_SLAB_SEQ")==null? "0":SlabInfRow.getAttribute("CHARGE_SLAB_SEQ")).toString()); // V_SLAB_EDT_SEQ = Long.parseLong((SlabInfRow.getAttribute("SLAB_EDT_SEQ")==null? "0":SlabInfRow.getAttribute("SLAB_EDT_SEQ")).toString()); // V_SLAB_CCM_CUT = Long.parseLong((SlabInfRow.getAttribute("CCM_CUT_TME")==null? "0":SlabInfRow.getAttribute("CCM_CUT_TME")).toString()); // // if (V_CHARGE_SLAB_SEQ == 1) { // // V_CCM_END = (String)SlabInfRow.getAttribute("PRE_CCM_STR_DTIME"); // } // // V_CCM_END = DateUtils.getStringDateAddedTime(V_CCM_END, 0, 0, (int)V_SLAB_CCM_CUT, 0); // // //UPDATE TBF01_SPEC_SLAB CCM_CUT_PRE_TME // PosParameter param6 = new PosParameter(); // param6.setWhereClauseParameter(0 , V_CCM_END); // param6.setWhereClauseParameter(1 , String.valueOf(V_SLAB_EDT_SEQ)); // int UpdCnt2 = getDao("mesdao").update("NIF012180_SMSWorkTmeSlab.update",param6); // // if (UpdCnt2 == 0) { // // V_TABLE_ID = "TBF01_SPEC_SLAB"; // V_TABLE_MODE = "U"; // V_ERR_DESC = "TBF01_SPEC_SLAB UPDATE COUNT IS ZERO"; // V_RTN_NAME = "SMSSchTme TBF01_SPEC_SLAB UPDATE2 " + String.valueOf(V_SLAB_EDT_SEQ); // // LogGpError.logMessageToDB("SMSSchTme", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); // throw new PosException(V_RTN_NAME); // } // // } //SlabInfVO while END // MODIFY END } //ChargeInfVO while END } //for END // } // catch (PosException ex) // { // context.put(SERVICE_ERR_MSG, ex.getMessage()); // throw ex; // } // catch (Throwable t) // { // context.put(SERVICE_ERR_MSG, t.getMessage()); // throw new PosException(t.getMessage(), t); // } return PosBizControlConstants.SUCCESS; } }