| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596 |
- 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;
-
- }
- }
|