| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549 |
- package xin.glue.nui.H.H02;
- import java.math.BigDecimal;
- import java.text.DateFormat;
- import java.text.SimpleDateFormat;
- import java.util.Date;
- import xin.glue.ui.common.PosDateFormat;
- import com.posdata.glue.biz.activity.PosActivity;
- import com.posdata.glue.biz.constants.PosBizControlConstants;
- import com.posdata.glue.biz.control.PosBizControlIF;
- import com.posdata.glue.biz.control.PosBizProvider;
- import com.posdata.glue.component.PosConstants;
- 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;
- /*
- * author:王小炎
- * date:2008-10-12
- * desc:接收在加热炉LEVEL2中所发生的加热炉装炉实绩录入到板坯装炉出炉实绩TABLE中
- */
- public class XinSaveRhfCharging extends PosActivity
- {
- public String runActivity(PosContext context)
- {
- logger.logInfo("XinSaveRhfCharging START !!! ");
-
- // 获取从二级接收过来的数据
- PosMessage message = context.getMessage();
-
- String coilNo_L2 = (String)message.get("COIL_NO");
- String slabNo = (String)message.get("SLAB_NO");
- String devno = (String)message.get("DEVNO");
- String RowNum = (String)message.get("ROW_NUM");
- String chargingDtime = (String)message.get("CHARGING_DTIME");
- //改为String 与接口表对应
- String chrgingBefWgt = (String)message.get("CHRGING_BEF_WGT");
- String chrgingBefTemp = (String)message.get("CHRGING_BEF_TEMP");
-
-
-
- Number SlabWgt = null;
- String BefProgCd = null;
- String OrdNo = null;
- String OrdSeq = null;
-
- String sShift = null;
-
- //这里需要进行卷号的转换,发给加热炉二级的变成了实际卷号。所以收到的电文也是实际卷号,转换成计划卷号就可以了。
- // 计划钢卷号
- String coilNo = null;
-
- // 在执行相应的程序,把数据写入表中
- PosParameter paramAA = new PosParameter();
- paramAA.setWhereClauseParameter(0, coilNo_L2);
-
- //这里是实际钢卷号
- logger.logInfo("XinSaveRhfCharging OLD_SAMPL_NO !!! "+coilNo_L2);
-
- PosRowSet CoilNoVo = getDao("mesdao").find("NIH020050_06.select", paramAA);
-
- // 查询出计划卷号的情况下,处理相应的业务类数据
- if(CoilNoVo.hasNext()){
- PosRow CoilNoRow = CoilNoVo.next();
- coilNo = (String) CoilNoRow.getAttribute("COIL_NO");
- //这里是计划钢卷号
- logger.logInfo("XinSaveRhfCharging COIL_NO !!! "+coilNo);
-
- if ( chargingDtime.equals("") || chargingDtime == null ) {
- DateFormat formatter = new SimpleDateFormat("yyyyMMddHHmmss");
- chargingDtime = formatter.format(new Date());
- }
-
- // 这里的班次的时间段就由基础表维护。可能存在2班或者3班的情况,那么就是有值的就进行判断没有的就是没有设定的。
- PosParameter paramSA = new PosParameter();
- PosParameter paramSB = new PosParameter();
- PosParameter paramSC = new PosParameter();
-
- //这里获取三个班次相应的时间
- String sqlA = "SELECT to_number(A.SM_EFNM) SM_EFNM,to_number(A.SM_ESNM) SM_ESNM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'H07001' AND A.SM_CD = '1'";
- String sqlB = "SELECT to_number(A.SM_EFNM) SM_EFNM,to_number(A.SM_ESNM) SM_ESNM,A.SHRXM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'H07001' AND A.SM_CD = '2'";
- String sqlC = "SELECT to_number(A.SM_EFNM) SM_EFNM,to_number(A.SM_ESNM) SM_ESNM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'H07001' AND A.SM_CD = '3'";
-
- PosRowSet ShiftA = getDao("mesdao").findByQueryStatement(sqlA, paramSA);
- PosRowSet ShiftB = getDao("mesdao").findByQueryStatement(sqlB, paramSB);
- PosRowSet ShiftC = getDao("mesdao").findByQueryStatement(sqlC, paramSC);
-
- BigDecimal SM_EFNMA = null;
- BigDecimal SM_ESNMA = null;
-
- BigDecimal SM_EFNMB = null;
- BigDecimal SM_ESNMB = null;
-
- //这里是中班是否超过0点指标。如果超过0点就判断早班和晚班的情况,其它为中班。如果不超过0点就判断早班和中班的情况,其它为晚班
- String SHRXM = null;
-
- BigDecimal SM_EFNMC = null;
- BigDecimal SM_ESNMC = null;
-
- if(ShiftA.hasNext()){
- PosRow ShiftAA = ShiftA.next();
- SM_EFNMA = (BigDecimal) ShiftAA.getAttribute("SM_EFNM");
- SM_ESNMA = (BigDecimal) ShiftAA.getAttribute("SM_ESNM");
- }
-
- if(ShiftB.hasNext()){
- PosRow ShiftBB = ShiftB.next();
- SM_EFNMB = (BigDecimal) ShiftBB.getAttribute("SM_EFNM");
- SM_ESNMB = (BigDecimal) ShiftBB.getAttribute("SM_ESNM");
- SHRXM = (String) ShiftBB.getAttribute("SHRXM");
- }
-
- if(ShiftC.hasNext()){
- PosRow ShiftCC = ShiftC.next();
- SM_EFNMC = (BigDecimal) ShiftCC.getAttribute("SM_EFNM");
- SM_ESNMC = (BigDecimal) ShiftCC.getAttribute("SM_ESNM");
- }
-
- int SM_EFNMAA;
- int SM_ESNMAA;
-
- int SM_EFNMBB;
- int SM_ESNMBB;
-
- int SM_EFNMCC;
- int SM_ESNMCC;
-
- int hhmi = Integer.parseInt(chargingDtime.substring(8, 12));
-
- if(SM_EFNMA == null){
- SM_EFNMAA = 0;
- }else{
- SM_EFNMAA = SM_EFNMA.intValue();
- }
-
- if(SM_ESNMA == null){
- SM_ESNMAA = 0;
- }else{
- SM_ESNMAA = SM_ESNMA.intValue();
- }
-
- if(SM_EFNMB == null){
- SM_EFNMBB = 0;
- }else{
- SM_EFNMBB = SM_EFNMB.intValue();
- }
-
- if(SM_ESNMB == null){
- SM_ESNMBB = 0;
- }else{
- SM_ESNMBB = SM_ESNMB.intValue();
- }
-
- if(SM_EFNMC == null){
- SM_EFNMCC = 0;
- }else{
- SM_EFNMCC = SM_EFNMC.intValue();
- }
-
- if(SM_ESNMC == null){
- SM_ESNMCC = 0;
- }else{
- SM_ESNMCC = SM_ESNMC.intValue();
- }
-
- //如果出现中班输入为空的情况,说明是三班两倒。就一定会存在早班和晚班,那么只要判断早班即可
- if(SM_EFNMB == null || SM_ESNMB == null){
- //两班的产量是前天的晚班加今天的早班
- if(hhmi > SM_EFNMAA && hhmi < SM_ESNMAA){
- //早班,这里只要判断符合不符合早班的情况即可
- sShift = "1";
- }else{
- sShift = "3";
- }
- }else{
- //三班的情况产量是当天三个班的和
- if(null != SHRXM && SHRXM.equals("Y")){
- //如果标志为Y,说明中班的结束时间超过0点,这时判断早班和晚班的情况。
- if(hhmi > SM_EFNMAA && hhmi < SM_ESNMAA){
- sShift = "1";
- }else if(hhmi > SM_EFNMCC && hhmi < SM_ESNMCC){
- sShift = "3";
- }else{
- sShift = "2";
- }
- }else{
- //如果标志不为Y,说明中班的结束时间没有超过0点,这时判断早班和中班的情况。
- if(hhmi > SM_EFNMAA && hhmi < SM_ESNMAA){
- sShift = "1";
- }else if(hhmi > SM_EFNMBB && hhmi < SM_ESNMBB){
- sShift = "2";
- }else{
- sShift = "3";
- }
- }
- }
-
- //这里需要用到天数前移一天和后退一天的共用方法,因为对三班和两班而言中班和晚班都可能存在跨天的情况。跨天后取班组时就要把时间前移
- PosDateFormat dateFormat = new PosDateFormat();
- // sShift = dateFormat.getShiftT(dc_off_dtime);
- // 这里需要获取昨天和明天的时间
- String ZDate = null;
- String MDate = null;
- // 当前时间加一天
- MDate = dateFormat.AddDateFunc(chargingDtime,1);
- //当前时间减一天
- ZDate = dateFormat.AddDateFunc(chargingDtime,-1);
-
- String sGroup = null;
-
- //判断,跨天的班组需要前移时间,这样才能对得上班组
- if(SM_EFNMB == null || SM_ESNMB == null){
- //两班的情况,这里需要对时间进行前移。把产量计算的昨天晚班的产量
- if(null != sShift && sShift.equals("3")){
- //这里还需要判断,当前时间是大于晚班开始时间小于2400还是大于0000小于结束时间
- if(hhmi >= SM_EFNMCC && hhmi <= 2400){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 两班早班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
- }else if(hhmi >= 0000 && hhmi <= SM_ESNMCC){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, ZDate.substring(0,6));
- paramA.setWhereClauseParameter(1, ZDate.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
- logger.logInfo(" 两班晚班当前的班次班组!! "+sShift+":"+sGroup+"入炉前移时间:"+ZDate);
- }
- }else if(null != sShift && sShift.equals("1")){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 两班早班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
- }else{
- //不存在
- logger.logInfo(" 两班班次班组不存在的情况!! ");
- }
- }else{
- //三班的情况,产量是从当天零点开始到次日零点
- if(null != SHRXM && SHRXM.equals("Y")){
- if(null != sShift && sShift.equals("1")){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 三班早班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
- }else if(null != sShift && sShift.equals("2")){
- if(hhmi >= SM_EFNMBB && hhmi <= 2400){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 三班中班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
- }else if(hhmi >= 0000 && hhmi <= SM_ESNMBB){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, ZDate.substring(0,6));
- paramA.setWhereClauseParameter(1, ZDate.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
- logger.logInfo(" 三班中班当前的班次班组!! "+sShift+":"+sGroup+"入炉前移时间:"+ZDate);
- }
- }else if(null != sShift && sShift.equals("3")){
- //中班超过0点,所以晚班就是从当天的凌晨开始的。
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 三班晚班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
- }
- }else{
- if(null != sShift && sShift.equals("1")){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 三班早班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
- }else if(null != sShift && sShift.equals("2")){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 三班中班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
- }else if(null != sShift && sShift.equals("3")){
- //因为是晚班从昨天开始到今天凌晨,所以今天凌晨的算今天的晚班
- if(hhmi >= 0000 && hhmi <= SM_ESNMCC){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, chargingDtime.substring(0,6));
- paramA.setWhereClauseParameter(1, chargingDtime.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 三班晚班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+chargingDtime);
-
- }else if(hhmi >= SM_EFNMCC && hhmi <= 2400){
- PosParameter paramA = new PosParameter();
- paramA.setWhereClauseParameter(0, MDate.substring(0,6));
- paramA.setWhereClauseParameter(1, MDate.substring(6,8));
- paramA.setWhereClauseParameter(2, sShift);
- paramA.setWhereClauseParameter(3, "H");
- PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
-
-
- if (groupVO.hasNext()){
- PosRow groupROW = groupVO.next();
- sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
- }
-
- logger.logInfo(" 三班晚班当前的班次班组!! "+sShift+":"+sGroup+"入炉时间:"+MDate);
- }
- }
- }
- }
-
-
- PosParameter param3 = new PosParameter();
- param3.setWhereClauseParameter(0, slabNo );
- param3.setWhereClauseParameter(1, coilNo );
- PosRowSet specVo = getDao("mesdao").find("NIH020020_SPEC_MILL.select", param3);
- if (specVo.hasNext()) {
- PosRow specROW = specVo.next();
- Number SLAB_EDT_SEQ = (Number)specROW.getAttribute("SLAB_EDT_SEQ");
- String STATUS_CD = (String)specROW.getAttribute("STATUS_CD");
-
- if(STATUS_CD.equals("A") || STATUS_CD.equals("B")) {
-
- PosParameter param4 = new PosParameter();
- param4.setWhereClauseParameter(0, "B" );
- param4.setWhereClauseParameter(1, slabNo );
- param4.setWhereClauseParameter(2, coilNo );
- getDao("mesdao").update("NIH020020_SPEC_MILL.update", param4);
-
- PosParameter param5 = new PosParameter();
- param5.setWhereClauseParameter(0, "B" );
- param5.setWhereClauseParameter(1, SLAB_EDT_SEQ );
- getDao("mesdao").update("NIH020020_SPEC_MILL_D.update", param5);
-
- PosParameter param6 = new PosParameter();
- param6.setWhereClauseParameter(0, "B" );
- param6.setWhereClauseParameter(1, SLAB_EDT_SEQ );
- getDao("mesdao").update("NIH020020_MILL_IDX.update", param6);
-
- logger.logInfo(" jihua !! ");
-
- PosParameter param0 = new PosParameter();
- param0.setWhereClauseParameter(0,slabNo );
- //这里查询板坯公共表,看看板坯公共表中是否存在此板坯信息
- PosRowSet rowset5 = getDao("mesdao").find("UIH020020_05.select", param0);
- if(rowset5.hasNext())
- {
-
- PosRow row1 = rowset5.next();
- SlabWgt = (Number)row1.getAttribute("SLAB_WGT");
- BefProgCd = (String)row1.getAttribute("CUR_PROG_CD");
- OrdNo = (String)row1.getAttribute("ORD_NO");
- OrdSeq = (String)row1.getAttribute("ORD_SEQ");
-
-
- String ROLL_MANA_NO = null;
- Number ROLL_SLAB_SEQ = null;
- PosParameter paramB = new PosParameter();
- paramB.setWhereClauseParameter(0,coilNo );
- PosRowSet specMillVO = getDao("mesdao").find("NIH020020_02.select", paramB);
- if(specMillVO.hasNext()) {
- PosRow specMillROW = specMillVO.next();
- ROLL_MANA_NO = (String)specMillROW.getAttribute("ROLL_MANA_NO");
- ROLL_SLAB_SEQ = (Number)specMillROW.getAttribute("ROLL_SLAB_SEQ");
- }
-
- /*
- * 以板坯号为条件查询加热炉装炉出口实绩table,如果有记录则加热炉装炉出口实绩table update处理
- * 否则加热炉装炉出口实绩table insert处理
- */
- PosParameter param = new PosParameter();
- PosParameter param1 = new PosParameter();
- param.setWhereClauseParameter(0, slabNo);
- param.setWhereClauseParameter(1, coilNo);
- //这里已板坯号和钢卷号作为联合主键,处理板坯回送的状态情况 TL
- PosRowSet rowset = this.getDao("mesdao").find("NIH020010.select", param);
-
- if(rowset.hasNext())
- {
- param1.setWhereClauseParameter(0, devno);
- param1.setWhereClauseParameter(1, chargingDtime);
- param1.setWhereClauseParameter(2, chrgingBefWgt);
- param1.setWhereClauseParameter(3, chrgingBefTemp);
- param1.setWhereClauseParameter(4, RowNum);
- param1.setWhereClauseParameter(5, sShift);
- param1.setWhereClauseParameter(6, sGroup);
- param1.setWhereClauseParameter(7, ROLL_MANA_NO);
- param1.setWhereClauseParameter(8, ROLL_SLAB_SEQ);
- param1.setWhereClauseParameter(9, slabNo);
- param1.setWhereClauseParameter(10, coilNo);
-
- int updateRowCount = this.getDao("mesdao").update("NIH020010.update", param1);
- }
- else
- {
-
- param1.setValueParamter(0, slabNo);
- param1.setValueParamter(1, coilNo);
- param1.setValueParamter(2, devno);
- param1.setValueParamter(3, chargingDtime);
- param1.setValueParamter(4, chrgingBefWgt);
- param1.setValueParamter(5, chrgingBefTemp);
- param1.setValueParamter(6, RowNum);
- param1.setValueParamter(7, sShift);
- param1.setValueParamter(8, sGroup);
- param1.setValueParamter(9, ROLL_MANA_NO);
- param1.setValueParamter(10, ROLL_SLAB_SEQ);
-
- int insertRowCount = this.getDao("mesdao").insert("NIH020010.insert", param1);
-
-
- }
-
-
-
-
- // TBG02_SLAB_COMM UPDATE CUR_PROG_CD = 'RBB'
- PosParameter param2 = new PosParameter();
- param2.setWhereClauseParameter(0, slabNo );
-
- getDao("mesdao").update("UIH020020_02.update", param2);
-
- // RHF ENTRY slab is cleared in Roller table address
- PosParameter param9 = new PosParameter();
- param9.setWhereClauseParameter(0, slabNo );
- PosRowSet rollerVo = getDao("mesdao").find("NIH020010_ROLLER.select", param9);
- while(rollerVo.hasNext()) {
- PosRow rollerROW = rollerVo.next();
- String YardAddr = (String)rollerROW.getAttribute("YARD_ADDR");
- PosParameter paramD = new PosParameter();
- paramD.setWhereClauseParameter(0, YardAddr );
-
- getDao("mesdao").update("NIH020010_ROLLER.update", paramD);
-
- logger.logInfo(" GGGGGGGGGGGGGGGGGGGGGGGGGG !! ");
- }
- } else {
-
- logger.logInfo("XinSaveRhfCharging---> Slab No is not cutting SLAB_NO==> "+slabNo );
-
- }
- } else {
- logger.logInfo("PosSaveInHeatFurnace Failed TBF02_SPEC_MILL STATUS_CD:("+STATUS_CD+")");
- }
- }
- }else{
- // 通过实际钢卷号没有获得计划钢卷号的信息
- logger.logInfo("XinSaveRhfCharging OLD_SAMPL_NO - > COIL_NO ERROR ");
- }
-
- logger.logInfo(" ENDDDDDDD !! ");
-
- return PosBizControlConstants.SUCCESS;
- }
-
- }
|