package xin.glue.nui.F.F02; import java.math.BigDecimal; import xin.glue.user.common.GlobalConstants; import xin.glue.user.common.LogGpError; import com.posdata.glue.PosException; import com.posdata.glue.biz.activity.PosActivity; import com.posdata.glue.biz.constants.PosBizControlConstants; import com.posdata.glue.biz.control.PosBizProvider; 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.PosMESMessageImpl; import com.posdata.glue.msg.PosMessage; //import java.lang.Long; /* Program Name MILLLvlCan (NIF024060) * Description MILL WORK INSTRUCTION LEVEL2 CANCEL * Write By KIM SUNG HO * Date 2008-11-12 */ public class MILLLvlCan extends PosActivity implements GlobalConstants { public String runActivity(PosContext context) { long V_ROLL_SLAB_SEQ_ST = 0 ; long V_ROLL_SLAB_SEQ_EN = 0 ; long V_PRC_CNT = 0 ; long V_CCR_CNT = 0 ; long V_STATUS_CNT = 0 ; long V_COIL_STAT_CNT = 0 ; long V_SLAB_WGT = 0 ; long V_ROLL_SLAB_CNT = 0 ; long V_ROLL_SLAB_WGT = 0 ; long V_HCR_CNT = 0 ; long V_MILL_LEN = 0 ; long V_SPM_CNT = 0 ; String V_ROLL_MANA_NO = "" ; String V_ROLL_MANA_ST = "" ; String V_ROLL_MANA_EN = "" ; String V_CHARGE_MANA_ST = "" ; String V_CHARGE_MANA_EN = "" ; String V_SLAB_NO = "" ; String V_HCR_CLF = "" ; String V_ORD_NO = "" ; String V_ORD_SEQ = "" ; String V_SEND_CLF = "" ; String V_PGMID = "" ; String V_TABLE_ID = "" ; String V_TABLE_MODE = "" ; String V_ERR_DESC = "" ; String V_RTN_NAME = "" ; PosMessage message = context.getMessage(); //P_TYPE : "R" --> ROLL (FROM/TO ROLL NO) 轧辊指示取消 // "S" --> SLAB (FROM/TO SLAB NO) 板坯指示取消 // "C" --> RHT-OUT (FROM/TO SLAB NO) 板坯吊销 // "M" --> CCM CANCEL (FROM/TO SLAB NO) 成分异常指示取消 // "Z" --> SIZE DEC (FROM/TO SLAB NO) 尺寸异常取消 // "E" --> External DEC (FROM/TO SLAB NO) 表面异常取消 String P_TYPE = (String)message.get("TYPE"); String P_ST = (String)message.get("FROM"); String P_EN = (String)message.get("TO"); String P_REG_ID = (String)message.get("REG_ID"); // try { if (P_TYPE.equals("C")) { V_PGMID = "MILLLvlCanRHT" ; } else if (P_TYPE.equals("M")) { V_PGMID = "MILLLvlCanCcm"; } else if (P_TYPE.equals("Z")) { V_PGMID = "MILLLvlCanSize"; } else if (P_TYPE.equals("E")) { V_PGMID = "MILLLvlCanExternal"; } else { //P_TYPE "R" --> ROLL, "S" --> SLAB V_PGMID = "MILLLvlCan"; } //V_PGMID赋值 if (P_TYPE.equals("R")) { if (P_ST.compareTo(P_EN) > 0) { //MESSAGE ERROR --> PROGRAM EXIT throw new PosException("MILLLvlCan..ROLL_MANA_NO ST > EN.."); } } else { if (P_ST.length() != 13 || P_EN.length() != 13) { //MESSAGE ERROR --> PROGRAM EXIT throw new PosException("MILLLvlCan..SLAB_NO ERROR.."); } }//位置和长度检查 if (P_TYPE.equals("R")) { //ROLL UNIT //FIRST/LAST ROLL_MANA_NO FIRST/LAST ROLL_SLAB_SEQ CHECK PosParameter paramA = new PosParameter(); paramA.setWhereClauseParameter(0, P_ST); paramA.setWhereClauseParameter(1, P_EN); PosRowSet RollSlabVO = getDao("mesdao").find("NIF024060_RollSlab.select",paramA); RollSlabVO.reset(); if (RollSlabVO.hasNext()) { PosRow RollSlabRow = RollSlabVO.next(); V_ROLL_MANA_ST = P_ST; V_ROLL_MANA_EN = P_EN; V_ROLL_SLAB_SEQ_ST = Long.parseLong((RollSlabRow.getAttribute("ROLL_SLAB_SEQ_ST")==null? "0":RollSlabRow.getAttribute("ROLL_SLAB_SEQ_ST")).toString()); V_ROLL_SLAB_SEQ_EN = Long.parseLong((RollSlabRow.getAttribute("ROLL_SLAB_SEQ_EN")==null? "0":RollSlabRow.getAttribute("ROLL_SLAB_SEQ_EN")).toString()); } else { V_ROLL_MANA_ST = ""; V_ROLL_MANA_EN = ""; V_ROLL_SLAB_SEQ_ST = 0; V_ROLL_SLAB_SEQ_EN = 0; } } else { //SLAB UNIT //ROLL_SLAB_SEQ CHECK PosParameter param0 = new PosParameter(); param0.setWhereClauseParameter(0, P_ST); param0.setWhereClauseParameter(1, P_EN); PosRowSet RollSlabSeqVO = getDao("mesdao").find("NIF024060_RollSlabSeq.select",param0); RollSlabSeqVO.reset(); if (RollSlabSeqVO.hasNext()) { PosRow RollSlabSeqRow = RollSlabSeqVO.next(); V_ROLL_MANA_ST = (String)RollSlabSeqRow.getAttribute("ROLL_MANA_ST"); V_ROLL_MANA_EN = (String)RollSlabSeqRow.getAttribute("ROLL_MANA_EN"); V_ROLL_SLAB_SEQ_ST = Long.parseLong((RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_ST")==null? "0":RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_ST")).toString()); V_ROLL_SLAB_SEQ_EN = Long.parseLong((RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_EN")==null? "0":RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_EN")).toString()); } else { V_ROLL_MANA_ST = ""; V_ROLL_MANA_EN = ""; V_ROLL_SLAB_SEQ_ST = 0; V_ROLL_SLAB_SEQ_EN = 0; } if (!V_ROLL_MANA_ST.equals(V_ROLL_MANA_EN)) { //MESSAGE ERROR --> PROGRAM EXIT throw new PosException("MILLLvlCan..ROLL_MANA_NO ST/EN DIFFERENCE.."); } } if (V_ROLL_SLAB_SEQ_ST == 0 || V_ROLL_SLAB_SEQ_EN == 0){ //MESSAGE ERROR --> PROGRAM EXIT throw new PosException("MILLLvlCan..ROLL_SLAB_SEQ ST/EN IS ZERO.."); } //热装HCR 删除 HCR 由HCR_CCR add by sunjiawang 090624 // this.updMillHCR(P_TYPE, P_ST, P_EN); //SELECT TBF02_SPEC_MILL JOB START CHECK if (!P_TYPE.equals("C")) { // "C" --> RHT-OUT PosParameter param1 = new PosParameter(); param1.setWhereClauseParameter(0, V_ROLL_MANA_ST); param1.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param1.setWhereClauseParameter(2, V_ROLL_MANA_EN); param1.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); PosRowSet MILLStatusChkVO = getDao("mesdao").find("NIF024060_MILLStatusChk.select",param1); MILLStatusChkVO.reset(); if (MILLStatusChkVO.hasNext()) { PosRow MILLStatusChkRow = MILLStatusChkVO.next(); V_STATUS_CNT = Long.parseLong((MILLStatusChkRow.getAttribute("STATUS_CNT")==null? "0":MILLStatusChkRow.getAttribute("STATUS_CNT")).toString()); V_COIL_STAT_CNT = Long.parseLong((MILLStatusChkRow.getAttribute("COIL_STAT_CNT")==null? "0":MILLStatusChkRow.getAttribute("COIL_STAT_CNT")).toString()); } if (V_STATUS_CNT != 0){ //MESSAGE ERROR --> PROGRAM EXIT throw new PosException("MILLLvlCan..STATUS_CD = 'B'.."); } if (V_COIL_STAT_CNT != 0) { //MESSAGE ERROR --> PROGRAM EXIT throw new PosException("板坯已上料 MILLLvlCan..COIL_STAT = '0'.."); } } //------------------------------------------------------------------------------- //INSERT MILL INSTRUCTION LEVEL2 CANCEL PROCESS --------------------------------- if (!P_TYPE.equals("C")) { // "C" --> RHT-OUT //TBH06_L2_RHT_INS CANCEL PROCESS PosParameter paramC = new PosParameter(); paramC.setValueParamter(0, V_ROLL_MANA_ST); paramC.setValueParamter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); paramC.setValueParamter(2, V_ROLL_MANA_EN); paramC.setValueParamter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int InsertC = getDao("mesdao").insert("NIF024060_L2RHTCancel.insert",paramC); if (InsertC == 0) { V_TABLE_ID = "TBH06_L2_RHT_INS"; V_TABLE_MODE = "I"; V_ERR_DESC = "TBH06_L2_RHT_INS INSERT COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBH06_L2_RHT_INS INSERTC " + String.valueOf(V_ROLL_SLAB_SEQ_ST); LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } } //TBH06_L2_MILL_INS CANCEL PROCESS PosParameter paramD = new PosParameter(); paramD.setValueParamter(0, V_ROLL_MANA_ST); paramD.setValueParamter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); paramD.setValueParamter(2, V_ROLL_MANA_EN); paramD.setValueParamter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int InsertD = getDao("mesdao").insert("NIF024060_L2MILLCancel.insert",paramD); if (InsertD == 0) { V_TABLE_ID = "TBH06_L2_MILL_INS"; V_TABLE_MODE = "I"; V_ERR_DESC = "TBH06_L2_MILL_INS INSERT COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBH06_L2_MILL_INS INSERTD " + String.valueOf(V_ROLL_SLAB_SEQ_ST); LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } //TBH06_L2_COIL_NO_INS CANCEL PROCESS if (P_TYPE.equals("R")) { //ROLL UNIT PosParameter paramE = new PosParameter(); paramE.setWhereClauseParameter(0, V_ROLL_MANA_ST); paramE.setWhereClauseParameter(1, V_ROLL_MANA_EN); PosRowSet L2RollCoilVO = getDao("mesdao").find("NIF024060_L2RollCoil.select",paramE); L2RollCoilVO.reset(); while (L2RollCoilVO.hasNext()) { PosRow L2RollCoilRow = L2RollCoilVO.next(); V_ROLL_MANA_NO = (String)L2RollCoilRow.getAttribute("ROLL_MANA_NO"); //SELECT NXET SET SEQUEANCE String nextSeqQr = "SELECT L2_COIL_NO_SET_SEQ.NEXTVAL SET_SEQ FROM DUAL "; PosRowSet nextSeqVO = getDao("mesdao").findByQueryStatement(nextSeqQr); nextSeqVO.reset(); PosRow nextSeqRow = nextSeqVO.next(); Number V_SET_SEQ = (Number)nextSeqRow.getAttribute("SET_SEQ"); PosParameter paramF = new PosParameter(); paramF.setValueParamter(0, V_SET_SEQ); paramF.setValueParamter(1, V_ROLL_MANA_NO); int InsertF = getDao("mesdao").insert("NIF024060_L2ROLLCOILCancel.insert",paramF); if (InsertF == 0) { V_TABLE_ID = "TBH06_L2_COIL_NO_INS"; V_TABLE_MODE = "I"; V_ERR_DESC = "TBH06_L2_COIL_NO_INS INSERT COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBH06_L2_COIL_NO_INS INSERTF " + V_ROLL_MANA_NO; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } } //L2RollCoilVO while END } else { //SLAB_UNIT //SELECT NXET SET SEQUEANCE String nextSeqQr = "SELECT L2_COIL_NO_SET_SEQ.NEXTVAL SET_SEQ FROM DUAL "; PosRowSet nextSeqVO = getDao("mesdao").findByQueryStatement(nextSeqQr); nextSeqVO.reset(); PosRow nextSeqRow = nextSeqVO.next(); Number V_SET_SEQ = (Number)nextSeqRow.getAttribute("SET_SEQ"); PosParameter paramG = new PosParameter(); paramG.setValueParamter(0, V_SET_SEQ); paramG.setValueParamter(1, V_ROLL_MANA_ST); paramG.setValueParamter(2, String.valueOf(V_ROLL_SLAB_SEQ_ST)); paramG.setValueParamter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int InsertG = getDao("mesdao").insert("NIF024060_L2SLABCOILCancel.insert",paramG); if (InsertG == 0) { V_TABLE_ID = "TBH06_L2_COIL_NO_INS"; V_TABLE_MODE = "I"; V_ERR_DESC = "TBH06_L2_COIL_NO_INS INSERT COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBH06_L2_COIL_NO_INS INSERTG " + V_ROLL_MANA_NO; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); throw new PosException(V_RTN_NAME); } } if (P_TYPE.equals("R") || P_TYPE.equals("S") || P_TYPE.equals("M")) { //HCR --> MILL INSTRUCTION CANCEL CHECK CHARGE_MANA_NO FROM/TO PosParameter paramH = new PosParameter(); paramH.setWhereClauseParameter(0, V_ROLL_MANA_ST); paramH.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); paramH.setWhereClauseParameter(2, V_ROLL_MANA_EN); paramH.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); PosRowSet ChargeManaNoVO = getDao("mesdao").find("NIF024060_ChargeManaNo.select",paramH); ChargeManaNoVO.reset(); while(ChargeManaNoVO.hasNext()) { PosRow ChargeManaNoRow = ChargeManaNoVO.next(); V_CHARGE_MANA_ST = (String)ChargeManaNoRow.getAttribute("CHARGE_MANA_ST"); V_CHARGE_MANA_EN = (String)ChargeManaNoRow.getAttribute("CHARGE_MANA_EN"); } //ChargeManaNoVO while END if (V_CHARGE_MANA_ST != "0") { //HCR --> MILL INSTRUCTION CANCEL TBF01_SPEC_SLAB(MILL_SLAB_EDT_SEQ --> 0, MILL_FL --> 'N') //CCM COMPLETE --> NO MODIFY PosParameter param3 = new PosParameter(); param3.setWhereClauseParameter(0, V_ROLL_MANA_ST); param3.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param3.setWhereClauseParameter(2, V_ROLL_MANA_EN); param3.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); V_HCR_CNT = getDao("mesdao").update("NIF024060_HCRCancel.update",param3); //HCR --> MILL INSTRUCTION CANCEL TBF01_SPEC_CHARGE(MILL_FL --> 'N') //CHARGE COMPLETE --> NO MODIFY PosParameter paramS = new PosParameter(); paramS.setWhereClauseParameter(0, V_CHARGE_MANA_ST); paramS.setWhereClauseParameter(1, V_CHARGE_MANA_EN); getDao("mesdao").update("NIF024060_ChargeHCRCancel.update",paramS); } } if (P_TYPE.equals("R") || P_TYPE.equals("S") || P_TYPE.equals("C")) { //CCR --> SLAB MASTER TBG02_SLAB_COMM (PROG_CD, BEF_PROG_CD, HCR_CLF) PosParameter param4 = new PosParameter(); param4.setWhereClauseParameter(0, V_ROLL_MANA_ST); param4.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param4.setWhereClauseParameter(2, V_ROLL_MANA_EN); param4.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); V_CCR_CNT = getDao("mesdao").update("NIF024060_SlabMaster.update",param4); //SELECT TBF02_SPEC_MILL ORDER_NO, ORD_SEQ PosParameter param2 = new PosParameter(); param2.setWhereClauseParameter(0, V_ROLL_MANA_ST); param2.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param2.setWhereClauseParameter(2, V_ROLL_MANA_EN); param2.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); PosRowSet MILLLvlCanVO = getDao("mesdao").find("NIF024060_MILLLvlCan.select",param2); MILLLvlCanVO.reset(); while(MILLLvlCanVO.hasNext()) { PosRow MILLLvlCanRow = MILLLvlCanVO.next(); V_SLAB_NO = (String)MILLLvlCanRow.getAttribute("SLAB_NO"); V_ORD_NO = (String)MILLLvlCanRow.getAttribute("ORD_NO"); V_ORD_SEQ = (String)MILLLvlCanRow.getAttribute("ORD_SEQ"); V_SLAB_WGT = Long.parseLong((MILLLvlCanRow.getAttribute("SLAB_WGT")==null? "0":MILLLvlCanRow.getAttribute("SLAB_WGT")).toString()); //CALL NIE012070_ NIE012070_CALL(V_ORD_NO, V_ORD_SEQ, V_SLAB_NO, V_SLAB_WGT, V_PGMID, P_REG_ID); ++V_PRC_CNT; } //MILLLvlCanVO while END } if (P_TYPE.equals("C")) { //RHT-OUT INSTRUCTION MARKING "D" //UPDATE TBF02_MILL_IDX (STATUS_CD = 'D') PosParameter paramI = new PosParameter(); paramI.setWhereClauseParameter(0, V_ROLL_MANA_ST); paramI.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); paramI.setWhereClauseParameter(2, V_ROLL_MANA_EN); paramI.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int UpdCntI = getDao("mesdao").delete("NIF024060_MillIdx.update",paramI); if (UpdCntI == 0) { V_TABLE_ID = "TBF02_MILL_IDX"; V_TABLE_MODE = "U"; V_ERR_DESC = "TBF02_MILL_IDX STATUS_CD = 'D' UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_MILL_IDX UpdCntI " + V_ROLL_MANA_ST; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); throw new PosException(V_RTN_NAME); } //UPDATE TBF02_SPEC_MILL_D (STATUS_CD = 'D') PosParameter paramJ = new PosParameter(); paramJ.setWhereClauseParameter(0, V_ROLL_MANA_ST); paramJ.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); paramJ.setWhereClauseParameter(2, V_ROLL_MANA_EN); paramJ.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int UpdCntJ = getDao("mesdao").delete("NIF024060_SpecMillD.update",paramJ); if (UpdCntJ == 0) { V_TABLE_ID = "TBF02_SPEC_MILL_D"; V_TABLE_MODE = "U"; V_ERR_DESC = "TBF02_SPEC_MILL_D STATUS_CD = 'D' UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_SPEC_MILL_D UpdCntJ " + V_ROLL_MANA_ST; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } //UPDATE TBF02_SPEC_MILL (STATUS_CD = 'D') PosParameter paramK = new PosParameter(); paramK.setWhereClauseParameter(0, V_ROLL_MANA_ST); paramK.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); paramK.setWhereClauseParameter(2, V_ROLL_MANA_EN); paramK.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int UpdCntK = getDao("mesdao").delete("NIF024060_SpecMill.update",paramK); if (UpdCntK == 0) { V_TABLE_ID = "TBF02_SPEC_MILL"; V_TABLE_MODE = "U"; V_ERR_DESC = "TBF02_SPEC_MILL STATUS_CD = 'D' UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_SPEC_MILL UpdCntK " + V_ROLL_MANA_ST; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } } else { //INSTRUCTION DELETE //DELETE TBF02_MILL_IDX PosParameter param5 = new PosParameter(); param5.setWhereClauseParameter(0, V_ROLL_MANA_ST); param5.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param5.setWhereClauseParameter(2, V_ROLL_MANA_EN); param5.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int DelCnt5 = getDao("mesdao").delete("NIF024060_MillIdx.delete",param5); if (DelCnt5 == 0) { V_TABLE_ID = "TBF02_MILL_IDX"; V_TABLE_MODE = "D"; V_ERR_DESC = "TBF02_MILL_IDX UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_MILL_IDX DELETE5 " + V_ROLL_MANA_ST; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); throw new PosException(V_RTN_NAME); } //DELETE TBF02_SPEC_MILL_DET PosParameter param6 = new PosParameter(); param6.setWhereClauseParameter(0, V_ROLL_MANA_ST); param6.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param6.setWhereClauseParameter(2, V_ROLL_MANA_EN); param6.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int DelCnt6 = getDao("mesdao").delete("NIF024060_SpecMillDet.delete",param6); if (DelCnt6 == 0) { V_TABLE_ID = "TBF02_SPEC_MILL_DET"; V_TABLE_MODE = "D"; V_ERR_DESC = "TBF02_SPEC_MILL_DET UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_SPEC_MILL_DET DELETE6 " + V_ROLL_MANA_ST; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } //DELETE TBF02_SPEC_MILL_D PosParameter param7 = new PosParameter(); param7.setWhereClauseParameter(0, V_ROLL_MANA_ST); param7.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param7.setWhereClauseParameter(2, V_ROLL_MANA_EN); param7.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int DelCnt7 = getDao("mesdao").delete("NIF024060_SpecMillD.delete",param7); if (DelCnt7 == 0) { V_TABLE_ID = "TBF02_SPEC_MILL_D"; V_TABLE_MODE = "D"; V_ERR_DESC = "TBF02_SPEC_MILL_D UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_SPEC_MILL_D DELETE7 " + V_ROLL_MANA_ST; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } //DELETE TBF02_SPEC_MILL PosParameter param8 = new PosParameter(); param8.setWhereClauseParameter(0, V_ROLL_MANA_ST); param8.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); param8.setWhereClauseParameter(2, V_ROLL_MANA_EN); param8.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); int DelCnt8 = getDao("mesdao").delete("NIF024060_SpecMill.delete",param8); if (DelCnt8 == 0) { V_TABLE_ID = "TBF02_SPEC_MILL"; V_TABLE_MODE = "D"; V_ERR_DESC = "TBF02_SPEC_MILL UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_SPEC_MILL DELETE8 " + V_ROLL_MANA_ST; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } } //PROESS COUNT != 0 if ((V_HCR_CNT + V_CCR_CNT) != 0) { //SELECT TBF02_SPEC_MILL LEVEL2 CANCEL PosParameter param9 = new PosParameter(); param9.setWhereClauseParameter(0, V_ROLL_MANA_ST); param9.setWhereClauseParameter(1, V_ROLL_MANA_EN); PosRowSet RollManaNoVO = getDao("mesdao").find("NIF024060_RollManaNo.select",param9); RollManaNoVO.reset(); while(RollManaNoVO.hasNext()) { PosRow RollManaNoRow = RollManaNoVO.next(); V_ROLL_MANA_NO = (String)RollManaNoRow.getAttribute("ROLL_MANA_NO"); V_ROLL_SLAB_CNT = Long.parseLong((RollManaNoRow.getAttribute("ROLL_SLAB_CNT")==null? "0":RollManaNoRow.getAttribute("ROLL_SLAB_CNT")).toString()); V_ROLL_SLAB_WGT = Long.parseLong((RollManaNoRow.getAttribute("ROLL_SLAB_WGT")==null? "0":RollManaNoRow.getAttribute("ROLL_SLAB_WGT")).toString()); V_HCR_CNT = Long.parseLong((RollManaNoRow.getAttribute("HCR_CNT")==null? "0":RollManaNoRow.getAttribute("HCR_CNT")).toString()); V_MILL_LEN = Long.parseLong((RollManaNoRow.getAttribute("MILL_LEN")==null? "0":RollManaNoRow.getAttribute("MILL_LEN")).toString()); V_SPM_CNT = Long.parseLong((RollManaNoRow.getAttribute("SPM_CNT")==null? "0":RollManaNoRow.getAttribute("SPM_CNT")).toString()); if (V_HCR_CNT == 0){ V_HCR_CLF = "C"; } else { V_HCR_CLF = "H"; } //TBF02_SPEC_ROLL RE-ARRANGE UPDATE PosParameter paramR = new PosParameter(); paramR.setWhereClauseParameter(0, String.valueOf(V_ROLL_SLAB_CNT)); paramR.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_WGT)); paramR.setWhereClauseParameter(2, String.valueOf(V_HCR_CLF)); paramR.setWhereClauseParameter(3, String.valueOf(V_MILL_LEN)); paramR.setWhereClauseParameter(4, String.valueOf(V_SPM_CNT)); paramR.setWhereClauseParameter(5, V_ROLL_MANA_NO); int UpdCntR = getDao("mesdao").update("NIF024060_SpecRoll.update",paramR); if (UpdCntR == 0) { V_TABLE_ID = "TBF02_SPEC_ROLL"; V_TABLE_MODE = "U"; V_ERR_DESC = "TBF02_SPEC_ROLL UPDATE COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBF02_SPEC_ROLL UPDATER " + V_ROLL_MANA_NO; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } if (V_ROLL_SLAB_CNT == 0) { V_SEND_CLF = "3"; //SEND_CLF = DELETE } else { V_SEND_CLF = "2"; //SEND_CLF = UPDATE } //TBH06_L2_ROLL_UNIT_INS CANCEL PROCESS PosParameter paramQ = new PosParameter(); paramQ.setValueParamter(0, V_SEND_CLF); paramQ.setValueParamter(1, V_ROLL_MANA_NO); int InsertQ = getDao("mesdao").insert("NIF024060_L2ROLLCancel.insert",paramQ); if (InsertQ == 0) { V_TABLE_ID = "TBH06_L2_ROLL_UNIT_INS"; V_TABLE_MODE = "I"; V_ERR_DESC = "TBH06_L2_ROLL_UNIT_INS INSERT COUNT IS ZERO"; V_RTN_NAME = "MILLLvlCan TBH06_L2_ROLL_UNIT_INS INSERTQ " + V_ROLL_MANA_NO; LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME); //throw new PosException(V_RTN_NAME); } } //RollManaNoVO while END //TBF02_SPEC_ROLL RE-ARRANGE (ROLL_SLAB_CNT = 0 DELETE) getDao("mesdao").delete("NIF024060_SpecRollDel.delete"); if (V_PRC_CNT != 0) { //CALL NIE012080_ NIE012080_CALL(); } } //END if V_PRC_CNT != 0 // } // 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; } public PosContext NIE012070_CALL(String V_ORD_NO, String V_ORD_SEQ, String V_SLAB_NO, long V_SLAB_WGT, String V_PGMID, String V_REG_ID) { PosContext context = new PosContext(); PosMessage message = new PosMESMessageImpl(); // String TcId = "NIE012070"; message.setTCID(TcId); message.setObject("MSG_ID", TcId); message.setObject("BEF_ORD_NO", ""); message.setObject("BEF_ORD_SEQ", ""); message.setObject("ORD_NO", V_ORD_NO); message.setObject("ORD_SEQ", V_ORD_SEQ); message.setObject("BEF_PROG_CD", "RBB"); message.setObject("PROG_CD", "RBA"); message.setObject("MAT_TYPE", "TM"); message.setObject("MAT_NO", V_SLAB_NO); message.setObject("WGT", new BigDecimal(V_SLAB_WGT)); message.setObject("PGMID", V_PGMID); message.setObject("REG_ID", V_REG_ID); context.setMessage(message); message.setTCID(TcId); String SERVICE_POSTFIX = "-service"; context.put(PosBizControlConstants.SERVICE_NAME, TcId + SERVICE_POSTFIX); PosBizProvider.getController().doSubController(context, false); String SERVICE_ERR_MSG = (String) context.get("SERVICE_ERR_MSG"); if (SERVICE_ERR_MSG != null) { throw new PosException(SERVICE_ERR_MSG); } return context; } public void updMillHCR(String p_type,String p_st ,String p_en) { String p_sql_id = ""; PosParameter p_param = new PosParameter(); p_sql_id = (p_type.equals("S")) ? "NIF024060_SLAB_HCR.UPDATE" : "NIF024060_ROLL_HCR.UPDATE"; p_param.setWhereClauseParameter(0, p_st); p_param.setWhereClauseParameter(1, p_en); this.getDao("mesdao").update(p_sql_id, p_param); } public PosContext NIE012080_CALL() { PosContext context = new PosContext(); PosMessage message = new PosMESMessageImpl(); // String TcId = "NIE012080"; message.setTCID(TcId); message.setObject("MSG_ID", TcId); message.setObject("AA", ""); context.setMessage(message); message.setTCID(TcId); String SERVICE_POSTFIX = "-service"; context.put(PosBizControlConstants.SERVICE_NAME, TcId + SERVICE_POSTFIX); PosBizProvider.getController().doSubController(context, false); String SERVICE_ERR_MSG = (String) context.get("SERVICE_ERR_MSG"); if (SERVICE_ERR_MSG != null) { throw new PosException(SERVICE_ERR_MSG); } return context; } }