| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481 |
- package xin.glue.ui.H.H01;
- /********
- 这里为卷板移送板加单独做个类处理 TL 091223
- ************/
- import java.math.BigDecimal;
- 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;
- public class saveBJTransf extends PosActivity{
- public String runActivity(PosContext context)
- {
- // 从页面获取参数数据,供更新页面使用
- //行状态
- String[] rowStuts = (String[])context.get("rowStatus");
- //选择标志
- String[] CHK = (String[])context.get("CHK");
- //钢卷号
- String[] OLD_SAMPL_NO = (String[])context.get("OLD_SAMPL_NO");
- //钢号
- String[] SPEC_STL_GRD = (String[])context.get("SPEC_STL_GRD");
- //合同号
- String[] ORD_NO = (String[])context.get("ORD_NO");
- //订单号
- String[] ORD_SEQ = (String[])context.get("ORD_SEQ");
- //板坯号
- String[] SLAB_NO = (String[])context.get("SLAB_NO");
- //钢卷厚度
- String[] COIL_THK = (String[])context.get("COIL_THK");
- //钢卷宽度
- String[] COIL_WTH = (String[])context.get("COIL_WTH");
- //钢卷长度
- String[] COIL_LEN = (String[])context.get("COIL_LEN");
- //钢卷重量
- String[] ACT_WGT = (String[])context.get("ACT_WGT");
- //钢卷内径
- String[] COIL_INDIA = (String[])context.get("COIL_INDIA");
- //钢卷外径
- String[] COIL_OUTDIA = (String[])context.get("COIL_OUTDIA");
- //车号
- String[] TRANS_CAR_NO = (String[])context.get("TRANS_CAR_NO");
- //移送单号
- //String[] SHIP_INVNO = (String[])context.get("SHIP_INVNO");
- //移送目的地
- String[] ROUTE = (String[])context.get("ROUTE");
- //移送状态
- //String[] MOVE_ST = (String[])context.get("MOVE_ST");
- //交货期
- String[] DEVLMT_DTIME = (String[])context.get("DEVLMT_DTIME");
- //客户
- String[] ORDCUST_CD = (String[])context.get("ORDCUST_CD");
- //目的地
- String[] DEST_PCD = (String[])context.get("DEST_PCD");
- //产品代码
- String[] PRODNM_CD = (String[])context.get("PRODNM_CD");
- //标准号
- String[] SPEC_ABBSYM = (String[])context.get("SPEC_ABBSYM");
- //轧制时间
- String[] MILL_DTIME = (String[])context.get("MILL_DTIME");
- //订单厚度
- String[] INSTR_COIL_THK = (String[])context.get("INSTR_COIL_THK");
- //订单宽度
- String[] INSTR_COIL_WTH = (String[])context.get("INSTR_COIL_WTH");
- //订单长度
- String[] INSTR_COIL_LEN = (String[])context.get("INSTR_COIL_LEN");
- //订单重量
- String[] INSTR_COIL_WGT = (String[])context.get("INSTR_COIL_WGT");
- //订单内径
- String[] INSTR_COIL_INDIA = (String[])context.get("INSTR_COIL_INDIA");
- //订单外径
- String[] INSTR_COIL_OUTDIA = (String[])context.get("INSTR_COIL_OUTDIA");
- //外观等级
- String[] EXTSHAPE_DEC_GRD = (String[])context.get("EXTSHAPE_DEC_GRD");
- //成份等级
- String[] INGR_DEC_GRD = (String[])context.get("INGR_DEC_GRD");
- //材质等级
- String[] MATLQLTY_DEC_GRD = (String[])context.get("MATLQLTY_DEC_GRD");
- //尺寸判定
- String[] SIZE_DEC_RST = (String[])context.get("SIZE_DEC_RST");
- //重量判定
- String[] WGT_DEC_RST = (String[])context.get("WGT_DEC_RST");
- //综合判定
- String[] TOT_DEC_GRD = (String[])context.get("TOT_DEC_GRD");
- //暇疵代码1
- String[] CRK_CD1 = (String[])context.get("CRK_CD1");
- //暇疵代码2
- String[] CRK_CD2 = (String[])context.get("CRK_CD2");
- //暇疵代码3
- String[] CRK_CD3 = (String[])context.get("CRK_CD3");
- //暇疵代码4
- String[] CRK_CD4 = (String[])context.get("CRK_CD4");
- //暇疵代码5
- String[] CRK_CD5 = (String[])context.get("CRK_CD5");
- //登录人
- String[] REG_ID = (String[])context.get("REG_ID");
- //移送班次
- String[] MOVE_SHIFT = (String[])context.get("MOVE_SHIFT");
- //移送班组
- String[] MOVE_GROUP = (String[])context.get("MOVE_GROUP");
- //移送人
- String[] ENTRY_REG = (String[])context.get("ENTRY_REG");
- //移送时间
- String[] ENTRY_DTIME = (String[])context.get("ENTRY_DTIME");
- //流水号,整理进程用
- String[] COIL_NO = (String[])context.get("COIL_NO");
-
- String SHIP_INVNO = null;
- //这里需要获取移送板加的发运明细编号
- PosParameter param0 = new PosParameter();
-
- PosRowSet SHIP_INVNOVo = getDao("mesdao").find("UIH070010_03.select", param0);
-
- if(SHIP_INVNOVo.hasNext()){
- PosRow SHIP_INVNORow = SHIP_INVNOVo.next();
-
- SHIP_INVNO = (String) SHIP_INVNORow.getAttribute("SHIP_INVNO");
- logger.logInfo("saveBJTransf 移送板加的发货明细编号为"+SHIP_INVNO);
- }
-
-
- String SHIP_INVNO_CR = null;
- //这里需要获取移送冷轧的发运明细编号
- PosParameter paramA = new PosParameter();
-
- PosRowSet SHIP_INVNO_CRVo = getDao("mesdao").find("UIH070010_05.select", paramA);
-
- if(SHIP_INVNO_CRVo.hasNext()){
- PosRow SHIP_INVNO_CRRow = SHIP_INVNO_CRVo.next();
-
- SHIP_INVNO_CR = (String) SHIP_INVNO_CRRow.getAttribute("SHIP_INVNO_CR");
- logger.logInfo("saveBJTransf 移送板加的发货明细编号为"+SHIP_INVNO_CR);
- }
-
- for(int i=0;i<rowStuts.length;i++){
- //选中的情况,才能够把需要移送的卷迁入移送接口表
- if(CHK[i].equals("Y")){
- if(null != ROUTE[i] && ROUTE[i].equals("B")){
- //这里在进行移送操作前需要进行卷的下车状态效验,如果此卷已经做了发运计划不能进行移送操作
- PosParameter param00 = new PosParameter();
-
- param00.setWhereClauseParameter(0, OLD_SAMPL_NO[i]);
- PosRowSet CUR_PROG_CDVo = getDao("mesdao").find("UIH070010_06.select", param00);
-
- String CUR_PROG_CD = null;
-
- if(CUR_PROG_CDVo.hasNext()){
- PosRow CUR_PROG_CDRow = CUR_PROG_CDVo.next();
-
- CUR_PROG_CD = (String) CUR_PROG_CDRow.getAttribute("CUR_PROG_CD");
-
- if(null != CUR_PROG_CD && CUR_PROG_CD.equals("SFA")){
- //这里做效验,只有是发货待机的才能进行移送操作
-
- //这里进行的是板加的移送操作
- PosParameter param1 = new PosParameter();
-
- param1.setValueParamter(0, OLD_SAMPL_NO[i]);
- param1.setValueParamter(1, SPEC_STL_GRD[i]);
- param1.setValueParamter(2, ORD_NO[i]);
- param1.setValueParamter(3, ORD_SEQ[i]);
- param1.setValueParamter(4, SLAB_NO[i]);
- param1.setValueParamter(5, COIL_THK[i]);
- param1.setValueParamter(6, COIL_WTH[i]);
- param1.setValueParamter(7, COIL_LEN[i]);
- param1.setValueParamter(8, ACT_WGT[i]);
- param1.setValueParamter(9, COIL_INDIA[i]);
- param1.setValueParamter(10, COIL_OUTDIA[i]);
- param1.setValueParamter(11, TRANS_CAR_NO[i]);
- //这里每保存一次做为一次移送,生成一次发运明细号
- param1.setValueParamter(12, SHIP_INVNO);
- param1.setValueParamter(13, ROUTE[i]);
- //这里板加移送的,默认接收状态都为0
- param1.setValueParamter(14, "0");
- param1.setValueParamter(15, DEVLMT_DTIME[i]);
- param1.setValueParamter(16, ORDCUST_CD[i]);
- param1.setValueParamter(17, DEST_PCD[i]);
- param1.setValueParamter(18, PRODNM_CD[i]);
- param1.setValueParamter(19, SPEC_ABBSYM[i]);
- param1.setValueParamter(20, MILL_DTIME[i]);
- param1.setValueParamter(21, INSTR_COIL_THK[i]);
- param1.setValueParamter(22, INSTR_COIL_WTH[i]);
- param1.setValueParamter(23, INSTR_COIL_LEN[i]);
- param1.setValueParamter(24, INSTR_COIL_WGT[i]);
- param1.setValueParamter(25, INSTR_COIL_INDIA[i]);
- param1.setValueParamter(26, INSTR_COIL_OUTDIA[i]);
- param1.setValueParamter(27, EXTSHAPE_DEC_GRD[i]);
- param1.setValueParamter(28, INGR_DEC_GRD[i]);
- param1.setValueParamter(29, MATLQLTY_DEC_GRD[i]);
- param1.setValueParamter(30, SIZE_DEC_RST[i]);
- param1.setValueParamter(31, WGT_DEC_RST[i]);
- param1.setValueParamter(32, TOT_DEC_GRD[i]);
- param1.setValueParamter(33, CRK_CD1[i]);
- param1.setValueParamter(34, CRK_CD2[i]);
- param1.setValueParamter(35, CRK_CD3[i]);
- param1.setValueParamter(36, CRK_CD4[i]);
- param1.setValueParamter(37, CRK_CD5[i]);
- param1.setValueParamter(38, REG_ID[0]);
- //执行标准,板加使用
- param1.setValueParamter(39, SPEC_ABBSYM[i]);
- //轧批号
- param1.setValueParamter(40, OLD_SAMPL_NO[i].substring(0, 9));
- //炉号
- param1.setValueParamter(41, SLAB_NO[i].substring(0, 9));
- //移送产线
- param1.setValueParamter(42, "热轧");
- //到达产线
- param1.setValueParamter(43, "板加");
- //移送班次
- param1.setValueParamter(44, MOVE_SHIFT[0]);
- //移送班组
- param1.setValueParamter(45, MOVE_GROUP[0]);
- //移送人
- param1.setValueParamter(46, ENTRY_REG[0]);
- //移送时间
- param1.setValueParamter(47, ENTRY_DTIME[0]);
- //钢卷流水号
- param1.setValueParamter(48, COIL_NO[i]);
-
- getDao("mesdao").insert("UIH070010_01.insert", param1);
-
- logger.logInfo("saveBJTransf 数据迁移到接口表"+param1);
-
- //更新钢卷公共表, 这里需要结束钢卷的状态。
- PosParameter param2 = new PosParameter();
-
- param2.setWhereClauseParameter(0,SHIP_INVNO);
- param2.setWhereClauseParameter(1,TRANS_CAR_NO[i]);
- param2.setWhereClauseParameter(2,ROUTE[i]);
- param2.setWhereClauseParameter(3,OLD_SAMPL_NO[i]);
-
- getDao("mesdao").update("UIH070010_01.update", param2);
-
- //更新钢卷垛位表
- PosParameter param3 = new PosParameter();
-
- param3.setWhereClauseParameter(0,OLD_SAMPL_NO[i]);
-
- getDao("mesdao").update("UIH070010_05.update", param3);
-
- //String - BigDecimal
- BigDecimal bd =new BigDecimal(ACT_WGT[i]);
- SendProg_NIE012070( COIL_NO[i] ,ORD_NO[i],ORD_SEQ[i],"SFF","SFA","AR",bd);
-
- //进行进程整理,这里改变了进程状态
- SendProg_NIE012080();
- }else{
- //给出提示,此卷的状态不为发货待机。不能进行移送操作
- logger.logDebug("saveYSreturn 此卷的状态不为SFA,不能进行移送操作 "+CUR_PROG_CD);
- String vtemp="CUR_PROG_CD";
- context.put("rs", vtemp);
- //有一个不符合条件的,全体不能移送
- this.rollbackTransaction("tx1");
- }
- }
- }else if(null != ROUTE[i] && ROUTE[i].equals("C")){
- // //这里在进行移送操作前需要进行卷的下车状态效验,如果此卷已经做了发运计划不能进行移送操作
- // PosParameter param00 = new PosParameter();
- //
- // param00.setWhereClauseParameter(0, OLD_SAMPL_NO[i]);
- // PosRowSet CUR_PROG_CDVo = getDao("mesdao").find("UIH070010_06.select", param00);
- //
- // String CUR_PROG_CD = null;
- //
- // if(CUR_PROG_CDVo.hasNext()){
- // PosRow CUR_PROG_CDRow = CUR_PROG_CDVo.next();
- //
- // CUR_PROG_CD = (String) CUR_PROG_CDRow.getAttribute("CUR_PROG_CD");
- //
- // if(null != CUR_PROG_CD && CUR_PROG_CD.equals("SFA")){
- // //这里是对冷轧移送进行的处理,只在移送表记录一条记录。冷轧原料库与热轧成品库公用钢卷公共表
- //
- // //这里进行的是板加的移送操作
- // PosParameter param1 = new PosParameter();
- //
- // param1.setValueParamter(0, OLD_SAMPL_NO[i]);
- // param1.setValueParamter(1, SPEC_STL_GRD[i]);
- // param1.setValueParamter(2, ORD_NO[i]);
- // param1.setValueParamter(3, ORD_SEQ[i]);
- // param1.setValueParamter(4, SLAB_NO[i]);
- // param1.setValueParamter(5, COIL_THK[i]);
- // param1.setValueParamter(6, COIL_WTH[i]);
- // param1.setValueParamter(7, COIL_LEN[i]);
- // param1.setValueParamter(8, ACT_WGT[i]);
- // param1.setValueParamter(9, COIL_INDIA[i]);
- // param1.setValueParamter(10, COIL_OUTDIA[i]);
- // param1.setValueParamter(11, TRANS_CAR_NO[i]);
- // //这里每保存一次做为一次移送,生成一次发运明细号
- // param1.setValueParamter(12, SHIP_INVNO_CR);
- // param1.setValueParamter(13, ROUTE[i]);
- // //这里冷轧移送的,默认接收状态都为4
- // param1.setValueParamter(14, "4");
- // param1.setValueParamter(15, DEVLMT_DTIME[i]);
- // param1.setValueParamter(16, ORDCUST_CD[i]);
- // param1.setValueParamter(17, DEST_PCD[i]);
- // param1.setValueParamter(18, PRODNM_CD[i]);
- // param1.setValueParamter(19, SPEC_ABBSYM[i]);
- // param1.setValueParamter(20, MILL_DTIME[i]);
- // param1.setValueParamter(21, INSTR_COIL_THK[i]);
- // param1.setValueParamter(22, INSTR_COIL_WTH[i]);
- // param1.setValueParamter(23, INSTR_COIL_LEN[i]);
- // param1.setValueParamter(24, INSTR_COIL_WGT[i]);
- // param1.setValueParamter(25, INSTR_COIL_INDIA[i]);
- // param1.setValueParamter(26, INSTR_COIL_OUTDIA[i]);
- // param1.setValueParamter(27, EXTSHAPE_DEC_GRD[i]);
- // param1.setValueParamter(28, INGR_DEC_GRD[i]);
- // param1.setValueParamter(29, MATLQLTY_DEC_GRD[i]);
- // param1.setValueParamter(30, SIZE_DEC_RST[i]);
- // param1.setValueParamter(31, WGT_DEC_RST[i]);
- // param1.setValueParamter(32, TOT_DEC_GRD[i]);
- // param1.setValueParamter(33, CRK_CD1[i]);
- // param1.setValueParamter(34, CRK_CD2[i]);
- // param1.setValueParamter(35, CRK_CD3[i]);
- // param1.setValueParamter(36, CRK_CD4[i]);
- // param1.setValueParamter(37, CRK_CD5[i]);
- // param1.setValueParamter(38, REG_ID[0]);
- // //执行标准,板加使用
- // param1.setValueParamter(39, SPEC_ABBSYM[i]);
- // //轧批号
- // param1.setValueParamter(40, OLD_SAMPL_NO[i].substring(0, 9));
- // //炉号
- // param1.setValueParamter(41, SLAB_NO[i].substring(0, 9));
- // //移送产线
- // param1.setValueParamter(42, "热轧");
- // //到达产线
- // param1.setValueParamter(43, "冷轧");
- // //移送班次
- // param1.setValueParamter(44, MOVE_SHIFT[0]);
- // //移送班组
- // param1.setValueParamter(45, MOVE_GROUP[0]);
- // //移送人
- // param1.setValueParamter(46, ENTRY_REG[0]);
- // //移送时间
- // param1.setValueParamter(47, ENTRY_DTIME[0]);
- // //钢卷流水号
- // param1.setValueParamter(48, COIL_NO[i]);
- //
- // getDao("mesdao").insert("UIH070010_02.insert", param1);
- //
- // logger.logInfo("saveBJTransf 数据迁移到接口表"+param1);
- //
- // //更新钢卷公共表, 这里需要结束钢卷的状态。
- // PosParameter param2 = new PosParameter();
- //
- // param2.setWhereClauseParameter(0,SHIP_INVNO_CR);
- // param2.setWhereClauseParameter(1,TRANS_CAR_NO[i]);
- // param2.setWhereClauseParameter(2,ROUTE[i]);
- // param2.setWhereClauseParameter(3,OLD_SAMPL_NO[i]);
- //
- // getDao("mesdao").update("UIH070010_08.update", param2);
- //
- // //更新钢卷垛位表
- // PosParameter param3 = new PosParameter();
- //
- // param3.setWhereClauseParameter(0,OLD_SAMPL_NO[i]);
- //
- // getDao("mesdao").update("UIH070010_05.update", param3);
- //
- // //进行进程整理,这里改变了进程状态
- // SendProg_NIE012080();
- // }else{
- // //给出提示,此卷的状态不为发货待机。不能进行移送操作
- // logger.logDebug("saveYSreturn 此卷的状态不为SFA,不能进行移送操作 "+CUR_PROG_CD);
- // String vtemp="CUR_PROG_CD";
- // context.put("rs", vtemp);
- // }
- // }
- }else{
- //给出提示,没有选中移送目的地。不能进行移送操作
- //这个垛位实际不存在,在界面给出提示
- logger.logDebug("saveYSreturn 移送目的地没有选中,不能进行移送操作 "+ROUTE[i]);
- String vtemp="ROUTE";
- context.put("rs", vtemp);
- }
- }
- }
-
- return PosBizControlConstants.SUCCESS;
- }
-
- public void SendProg_NIE012070(String MatNo,String sOrdNo,String sOrdSeq,String sProgCd,String sBefProgCd,String sKind,BigDecimal wgt )
- {
-
- logger.logDebug("saveBJTransf SendProg_NIE012070 " );
-
- PosContext context = new PosContext();
- PosMessage message = new PosMESMessageImpl();
-
- String TcId = "NIE012070";
-
-
- message.setTCID(TcId);
- message.setObject("MSG_ID",TcId);
- message.setObject("BEF_ORD_NO",null);
- message.setObject("BEF_ORD_SEQ",null);
- message.setObject("ORD_NO",sOrdNo);
- message.setObject("ORD_SEQ",sOrdSeq);
- message.setObject("BEF_PROG_CD",sBefProgCd);
- message.setObject("PROG_CD",sProgCd);
- message.setObject("MAT_TYPE",sKind);
- message.setObject("MAT_NO",MatNo);
- message.setObject("WGT", wgt );
- message.setObject("PGMID","saveBJTransf");
- message.setObject("REG_ID", "UIH070010");
- context.setMessage(message);
- this.processComponent(PosConstants.CREATE_MESSAGE, context);
- String transactionCode = context.getMessage().getTC();
-
-
- message.setTCID(TcId);
-
- String serviceName = "NIE012070";
-
- String SERVICE_POSTFIX = "-service";
-
-
- context.put(PosBizControlConstants.SERVICE_NAME, serviceName + SERVICE_POSTFIX);
-
-
- context.setMessage(message);
-
-
- PosBizControlIF controller = PosBizProvider.getController();
-
- controller.doSubController(context,false);
-
- }
-
- public void SendProg_NIE012080(){
-
- PosContext context = new PosContext();
- PosMessage message = new PosMESMessageImpl();
-
-
- String TcId = "NIE012080";
-
-
-
- message.setTCID(TcId);
- message.setObject("MSG_ID",TcId);
- message.setObject("AA",null);
-
- context.setMessage(message);
- this.processComponent(PosConstants.CREATE_MESSAGE, context);
- String transactionCode = context.getMessage().getTC();
-
-
- message.setTCID(TcId);
-
- String serviceName = "NIE012080";
-
- String SERVICE_POSTFIX = "-service";
-
-
- context.put(PosBizControlConstants.SERVICE_NAME, serviceName + SERVICE_POSTFIX);
-
-
- context.setMessage(message);
-
-
- PosBizControlIF controller = PosBizProvider.getController();
-
- controller.doSubController(context,false);
-
-
-
-
- }
- }
|