| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086 |
- <?xml version="1.0" encoding="UTF-8"?>
- <?xml-stylesheet type="text/css" href="../../css/body.css" ?>
- <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
- <xhtml:head>
- <xhtml:title>
- <![CDATA[热轧作业 >> 钢卷库管理 >> 板加移送实绩登录与查询(UIH070010) ]]>
- </xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <resData/>
- <reqData/>
- <searchData>
- <OLD_SAMPL_NO/>
- <MOVE_SHIFT/>
- <MOVE_GROUP/>
- <MOVE_TIME/>
- <TRANS_CAR_NO/>
- <SHIP_INVNO/>
- <MOVE_ST>0</MOVE_ST>
- <SHIP_INVNO_CR/>
- <SPEC_STL_GRD/>
- <ORDCUST_CD_DESC/>
- <ENTRY_REG/>
- <ENTRY_DTIME/>
- <ORD_NO/>
- </searchData>
- <datagrid1/>
- <datagrid2/>
- <EXCELHeadCAR>
- <ListResult_1_VO>
- <ListResult_1_Row>
- <col1>新余钢铁股份有限公司钢卷发货明细单(汽车)</col1>
- <col2/>
- <col3/>
- <col4/>
- <col5/>
- <col6/>
- <col7/>
- <col8/>
- </ListResult_1_Row>
- <ListResult_1_Row>
- <col1>合 同 号:</col1>
- <col2/>
- <col3/>
- <col4>发货单号:</col4>
- <col5/>
- <col6/>
- <col7/>
- <col8/>
- </ListResult_1_Row>
- <ListResult_1_Row>
- <col1>用户编码:</col1>
- <col2/>
- <col3/>
- <col4>发货日:</col4>
- <col5/>
- <col6/>
- <col7/>
- <col8/>
- </ListResult_1_Row>
- <ListResult_1_Row>
- <col1>用户名称:</col1>
- <col2/>
- <col3/>
- <col4>到站:</col4>
- <col5/>
- <col6>制表:</col6>
- <col7/>
- <col8/>
- </ListResult_1_Row>
- <ListResult_1_Row>
- <col1>计划单号:</col1>
- <col2/>
- <col3/>
- <col4>车号:</col4>
- <col5/>
- <col6>收货单位:</col6>
- <col7/>
- <col8/>
- </ListResult_1_Row>
- <ListResult_1_Row>
- <col1>发货备注:</col1>
- <col2/>
- <col3/>
- <col4>产品名称:</col4>
- <col5/>
- <col6>标准:</col6>
- <col7/>
- <col8/>
- </ListResult_1_Row>
- <ListResult_1_Row>
- <col1>轧批号</col1>
- <col2>钢号</col2>
- <col3>规格(厚*宽)mm</col3>
- <col4>重量(吨)</col4>
- <col5>钢卷号</col5>
- <col6>等级</col6>
- <col7>性能</col7>
- <col8>备注</col8>
- </ListResult_1_Row>
- </ListResult_1_VO>
- </EXCELHeadCAR>
- <gridData2/>
- </root>
- </instance>
- </model>
- <script type="javascript">
- <![CDATA[
- function Init(node) {
- InitParams(node);
- }
- //调用公共的初始化方法获得登录用户名
- function InitParams(node) {
- if (typeof node == "undefined" && typeof node != "object") return;
- model.removenode("/root/initData/rcvInfo");
- model.makeNode("/root/initData/rcvInfo");
- var nodeList = node.childNodes;
- node = model.instances(0).selectSingleNode("/root/initData/rcvInfo");
- for (var i = 0; i < nodeList.length; i++)
- node.appendChild(nodeList.item(i));
- }
-
- function excelExport(){
- return datagrid2;
- }
-
- //查询方法
- function find(){
- model.removenode("/root/reqData");
- model.makeNode("/root/reqData");
- //这里必须给出移送状态
- if(model.getValue("/root/searchData/MOVE_ST") == null){
- alert(" 移送状态选择项目不能为空,请选择后再进行查询操作!! ");
- return;
- }
-
- commSendReq("/root/searchData");
- commSubmit("UIH070010-service", "find", "glueAction.do");
-
- commAppendData("/root/datagrid1/TRANF_WAIT_VO","/root/resData/TRANF_WAIT_VO");
- commAppendData("/root/datagrid2/TRANF_COMPLETE_VO","/root/resData/TRANF_COMPLETE_VO");
-
- model.refresh();
-
- }
-
- //保存
- function save(){
- model.removenode("/root/reqData");
- model.makeNode("/root/reqData");
-
- if(model.getValue("/root/searchData/MOVE_SHIFT") == ""){
- alert(" 移送班次信息不能为空,请选择移送班次信息! ");
- return;
- }
-
- if(model.getValue("/root/searchData/MOVE_GROUP") == ""){
- alert(" 移送班组信息不能为空,请选择移送班组信息! ");
- return;
- }
- if(model.getValue("/root/searchData/ENTRY_REG") == ""){
- alert(" 移送人信息不能为空,请选择移送人信息! ");
- return;
- }
- if(model.getValue("/root/searchData/ENTRY_DTIME") == ""){
- alert(" 移送时间信息不能为空,请选择移送时间信息! ");
- return;
- }
- //这里给出行状态设置,避免出现数据不能提交的情况
- for(var i=0;i<datagrid1.rows;i++){
- datagrid1.rowStatus(i) = 2;
- }
- model.refresh();
- commMultiUpdate(datagrid1,"/root/reqData","A",true,"rowStatus");
- //这里加入登录用户名,会不会与已有的initData冲突
- model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
- model.makeValue("/root/reqData/MOVE_SHIFT",model.getValue("/root/searchData/MOVE_SHIFT"));
- model.makeValue("/root/reqData/MOVE_GROUP",model.getValue("/root/searchData/MOVE_GROUP"));
- model.makeValue("/root/reqData/ENTRY_REG",model.getValue("/root/searchData/ENTRY_REG"));
- model.makeValue("/root/reqData/ENTRY_DTIME",model.getValue("/root/searchData/ENTRY_DTIME"));
-
- commSubmit("UIH070010-service", "save", "glueAction.do");
-
- model.refresh();
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "ROUTE"){
- alert(" 钢卷移送目的地没有选择,请确认后重新输入!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "CUR_PROG_CD"){
- alert(" 选中的钢卷不为发货待机,不能进行移送操作!! ");
- return;
- }
-
- find();
- }
-
- //对从板加退回的板坯,返回我们自己仓库的保存按钮
- function SaveReturn(){
- //这里对板加退回的情况进行处理,允许回退到移送界面
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("CHK")) == "Y"){
- //如果是选中行,判断回退放置位置不为空和移送状态为板加退回的才能回退
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "3"){
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("RTN_CUR_STORE_LOC")) == ""){
- alert(" 钢卷回退垛位为空,不能进行移送回退操作!! ");
- return;
- }else{
- //进行回退操作,在后台判断输入的垛位是否符合要求
- model.removenode("/root/reqData");
- model.makeNode("/root/reqData");
-
- //这里给出行状态设置,避免出现数据不能提交的情况
- for(var i=0;i<datagrid2.rows;i++){
- datagrid2.rowStatus(i) = 2;
- }
- model.refresh();
- commMultiUpdate(datagrid2,"/root/reqData","A",true,"rowStatus");
- //这里加入登录用户名,会不会与已有的initData冲突
- model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
-
- commSubmit("UIH070010-service", "BJreturn", "glueAction.do");
-
- model.refresh();
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "CoilYard"){
- alert(" 钢卷退回位置输入不正确,请确认后重新输入!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "COIL_NO"){
- alert(" 钢卷退回位置已经存在钢卷,请确认后重新输入!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST"){
- alert(" 钢卷移送状态不为板加退回,不能进行板加退回入库操作!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST_TMP"){
- alert(" 钢卷移送状态不为板加退回,不能进行板加退回入库操作!! ");
- return;
- }
- find();
- }
- }else{
- alert(" 移送状态不为板加回退,不能进行板加回退入库操作! ");
- return;
- }
- }
- }
-
- //操作员手工录入错误的情况
- function SaveError(){
- //这里对误选择的情况进行处理,允许回退到移送界面
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("CHK")) == "Y"){
- //如果是选中行,判断回退放置位置不为空和移送状态为等待的才能回退
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "0" || datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "4"){
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("RTN_CUR_STORE_LOC")) == ""){
- alert(" 钢卷回退垛位为空,不能进行移送回退操作!! ");
- return;
- }else{
- //进行回退操作,在后台判断输入的垛位是否符合要求
- model.removenode("/root/reqData");
- model.makeNode("/root/reqData");
-
- //这里给出行状态设置,避免出现数据不能提交的情况
- for(var i=0;i<datagrid2.rows;i++){
- datagrid2.rowStatus(i) = 2;
- }
- model.refresh();
- commMultiUpdate(datagrid2,"/root/reqData","A",true,"rowStatus");
- //这里加入登录用户名,会不会与已有的initData冲突
- model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
-
- commSubmit("UIH070010-service", "YSreturn", "glueAction.do");
-
- model.refresh();
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "CoilYard"){
- alert(" 钢卷退回位置输入不正确,请确认后重新输入!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "COIL_NO"){
- alert(" 钢卷退回位置已经存在钢卷,请确认后重新输入!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST"){
- alert(" 钢卷移送状态不为等待,不能进行热轧退回入库操作!! ");
- return;
- }
-
- //这里为了避免打开界面不查询的情况,从界面获取的移送状态不对
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST_TMP"){
- alert(" 钢卷移送状态不为等待,不能进行热轧退回入库操作!! ");
- return;
- }
- find();
- }
- }else{
- alert(" 移送状态不为板加接收等待或者冷轧接收等待,不能进行热轧退回入库操作!!");
- return;
- }
- }
- }
-
- //对从冷轧退回的钢卷,返回热轧库的保存按钮
- function SaveCRReturn(){
- //这里对板加退回的情况进行处理,允许回退到移送界面
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("CHK")) == "Y"){
- //如果是选中行,判断回退放置位置不为空和移送状态为板加退回的才能回退
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "6"){
- if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("RTN_CUR_STORE_LOC")) == ""){
- alert(" 钢卷回退垛位为空,不能进行移送回退操作!! ");
- return;
- }else{
- //进行回退操作,在后台判断输入的垛位是否符合要求
- model.removenode("/root/reqData");
- model.makeNode("/root/reqData");
-
- //这里给出行状态设置,避免出现数据不能提交的情况
- for(var i=0;i<datagrid2.rows;i++){
- datagrid2.rowStatus(i) = 2;
- }
- model.refresh();
- commMultiUpdate(datagrid2,"/root/reqData","A",true,"rowStatus");
- //这里加入登录用户名,会不会与已有的initData冲突
- model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
-
- commSubmit("UIH070010-service", "CRreturn", "glueAction.do");
-
- model.refresh();
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "CoilYard"){
- alert(" 钢卷退回位置输入不正确,请确认后重新输入!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "COIL_NO"){
- alert(" 钢卷退回位置已经存在钢卷,请确认后重新输入!! ");
- return;
- }
-
- if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST"){
- alert(" 钢卷移送状态不为冷轧退回,不能进行冷轧退回入库操作!! ");
- return;
- }
-
- find();
- }
- }else{
- alert(" 移送状态不为冷轧回退,不能进行冷轧退回入库操作! ");
- return;
- }
- }
- }
-
-
- function saveExcelScript(sDGridName, sExcelSheetName, saveType) {
- var sExcelName = window.fileDialog( "save", "", false, "SaveFileName", "xls", "Excel Files(*.xls)|*.xls" );
- if ( sExcelName == "" ) {
- return;
- }
- //var sCSVName = "C:\\TFSmartUpdater\\" + sExcelName.lastIndexOf(".") +".csv";
- var sCSVName = sExcelName +".csv";
- //alert("sExcelName = ["+ sExcelName +"]\nsCSVName = ["+ sCSVName + "]");
- eval(sDGridName).saveText(sCSVName, "\n", ",", '\:', true); //DataGrid? ??? CSV??? ??
- ObjTFExcel.launchNewInstance(0); //Execute EXCEL
- ObjTFExcel.createWorkbook(); //Create new Workbook(for example:Sheet1,Sheet2,Sheet3) -- createWorkBook(Excel-TemplateFile)
- ObjTFExcel.loadCSV(sCSVName); //Loading Contents, from CSV to Excel
- //Setting up EXCEL Layout.
- var nRows = sDGridName.rows - sDGridName.fixedRows + 1; //Keep Careful !!!
- var nCols = sDGridName.cols;
-
- //Header
- //Line 1 : Sheet Title
- //行高的设置
- ObjTFExcel.rowheight( 01 ) = 50 ;
- ObjTFExcel.bold ( 01, 01, 01, nCols ) = true ;
- //改变字体大小
- ObjTFExcel.fontsize ( 01, 01, 01, nCols ) = 18;
- ObjTFExcel.underline( 01, 01, 01, nCols ) = 3 ;
- ObjTFExcel.halign ( 01, 01, 01, nCols ) ="center" ;
- ObjTFExcel.valign ( 01, 01, 01, nCols ) ="top" ;
- ObjTFExcel.mergeCell( 01, 01, 01, nCols ) ;
- ObjTFExcel.colwidth ( 01 ) = 200 ;
-
- //All of the range
- ObjTFExcel.fontcolor ( 01, 01, nRows, nCols ) = "#000000" ;
- ObjTFExcel.font ( 01, 01, nRows, nCols ) = "SimSun" ;
- //取消边框
- ObjTFExcel.setBorderColor( 07, 01, nRows, nCols, "#000000") ;
- ObjTFExcel.bold ( 01, 01, nRows, nCols ) = true ;
- //改变字体大小
- ObjTFExcel.fontsize ( 02, 01, nRows, nCols ) = 12 ;
- ObjTFExcel.underline ( 01, 01, nRows, nCols ) = 0 ;
- ObjTFExcel.valign ( 01, 01, nRows, nCols ) ="middle" ;
- //字体居中
- ObjTFExcel.halign ( 01, 01, nRows, nCols ) ="center" ;
-
- //字体左对齐的特殊定义
- ObjTFExcel.halign ( 01, 01, 02, nCols ) ="left" ;
- ObjTFExcel.halign ( 01, 01, 03, nCols ) ="left" ;
- ObjTFExcel.halign ( 01, 01, 04, nCols ) ="left" ;
- ObjTFExcel.halign ( 01, 01, 05, nCols ) ="left" ;
- ObjTFExcel.halign ( 01, 01, 06, nCols ) ="left" ;
- ObjTFExcel.halign ( 01, 01, 01, nCols ) ="center" ;
-
- //Query-Results Data
- var iRow = 1; // iRow = HeaderLine + 1;
- //这里设置字体的行宽
- // for(var i = iRow; i <= nRows; i++ ) {
- // if( (i%5) == 1 ) {
- // ObjTFExcel.rowHeight( i ) = 60;
- // ObjTFExcel.mergeCell( i, 01, i, nCols );
- // } else if( (i%5) == 0 ) {
- // ObjTFExcel.rowHeight( i ) = 45;
- // ObjTFExcel.mergeCell( i, 01, i, nCols );
- // } else {
- // ObjTFExcel.rowHeight( i ) = 40;
- // }
- // }
-
- //合并单元格
- ObjTFExcel.mergeCell(02,05,02,08);
- ObjTFExcel.mergeCell(02,02,02,03);
- ObjTFExcel.mergeCell(03,02,03,03);
- ObjTFExcel.mergeCell(04,02,04,03);
- ObjTFExcel.mergeCell(05,02,05,03);
- ObjTFExcel.mergeCell(06,02,06,03);
- ObjTFExcel.mergeCell(04,07,04,08);
- ObjTFExcel.mergeCell(05,07,05,08);
- ObjTFExcel.mergeCell(06,07,06,08);
-
- //改变文本格式的方法,未知
- //ObjTFExcel.setformat(02,02,02,03,'@');
-
- //设置列的宽度
- ObjTFExcel.colwidth ( 01 ) = 15 ;
- ObjTFExcel.colwidth ( 02 ) = 10 ;
- ObjTFExcel.colwidth ( 03 ) = 15 ;
- ObjTFExcel.colwidth ( 04 ) = 10 ;
- ObjTFExcel.colwidth ( 05 ) = 20 ;
- ObjTFExcel.colwidth ( 06 ) = 10 ;
- ObjTFExcel.colwidth ( 07 ) = 10 ;
- ObjTFExcel.colwidth ( 08 ) = 15 ;
-
- // ObjTFExcel.setFormat(iRow, 14, nRows, 14, "yyyy\"-\"mm\"-\"dd\"\" hh\":\"mm\":\"ss\"\";@");
- ObjTFExcel.sheetName(1) = sExcelSheetName;
- ObjTFExcel.save(sExcelName); //Saving EXCEL
- ObjTFExcel.close(); //Closing EXCEL. (You must be closed EXCEL !!!)
- window.exec("EXCEL.EXE", sExcelName); //Openning EXCEL
- }
- ]]>
- </script>
- <script type="javascript" src="../../js/boaMsg.js"/>
- <script type="javascript" src="../../js/boaCommon.js"/>
- </xhtml:head>
- <xhtml:body guideline="2,-3;">
- <caption id="caption3" class="cell" visibility="hidden" style="left:715px; top:285px; width:95px; height:20px; font-weight:bold; border-color:#000000; "/>
- <caption id="caption9" class="cell" style="left:810px; top:285px; width:80px; height:20px; font-weight:bold; border-color:#000000; "/>
- <caption id="caption8" class="cell" style="left:890px; top:285px; width:90px; height:20px; font-weight:bold; border-color:#000000; "/>
- <caption id="caption10" class="cell" style="left:0px; top:25px; width:65px; height:20px; font-weight:bold; border-color:#000000; ">移送对象</caption>
- <caption id="caption2" class="cell" style="left:390px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">班 次</caption>
- <select1 id="combo2" ref="/root/searchData/MOVE_GROUP" appearance="minimal" editmode="input" style="left:635px; top:25px; width:120px; height:20px; background-color:#ffff99; border-color:#000000; ">
- <choices>
- <item>
- <label>甲</label>
- <value>A</value>
- </item>
- <item>
- <label>乙</label>
- <value>B</value>
- </item>
- <item>
- <label>丙</label>
- <value>C</value>
- </item>
- <item>
- <label>丁</label>
- <value>D</value>
- </item>
- </choices>
- </select1>
- <caption id="caption1" class="cell" style="left:575px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">班 组</caption>
- <select1 id="combo1" ref="/root/searchData/MOVE_SHIFT" appearance="minimal" editmode="input" style="left:450px; top:25px; width:120px; height:20px; background-color:#ffff99; border-color:#000000; ">
- <choices>
- <item>
- <label>早班</label>
- <value>1</value>
- </item>
- <item>
- <label>中班</label>
- <value>2</value>
- </item>
- <item>
- <label>晚班</label>
- <value>3</value>
- </item>
- </choices>
- </select1>
- <datagrid id="datagrid1" nodeset="/root/datagrid1/TRANF_WAIT_VO/TRANF_WAIT_Row" scroll="both" caption="选择^钢卷号^钢码^合同号^订单号^板坯号^钢卷实际^钢卷实际^钢卷实际^钢卷实际^钢卷实际^钢卷实际^钢卷订单^钢卷订单^钢卷订单^^^^堆置位置^车辆号^移送货单^移送目的地^移送日期^交货期^^发货单位^客户单位^目的地^^产品代码^标准号^轧钢时间^钢卷进程状态^外观等级^成分等级^材质等级^尺寸等级^重量等级^综合等级^^^^^^MOVE_ST^|选择^钢卷号^钢码^合同号^订单号^板坯号^厚度^宽度^长度^重量^内径^外径^厚度^宽度^重量^^^^堆置位置^车辆号^移送货单^移送目的地^移送日期^交货期^^发货单位^客户单位^目的地^^产品代码^标准号^轧钢时间^钢卷进程状态^外观等级^成分等级^材质等级^尺寸等级^重量等级^综合等级^^^^^^MOVE_ST^" colsep="^" colwidth="31, 100, 75, 100, 32, 81, 39, 39, 38, 39, 39, 40, 34, 32, 32, 29, 23, 12, 70, 87, 83, 51, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 34, 33, 33, 33, 33, 33, 35, 35, 35, 35, 35, 100, 100, 100, 100, 100, 100, 100, 100" defaultrows="9" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:45px; width:980px; height:210px; border-color:#000000; ">
- <col checkvalue="Y,N" ref="CHK" type="checkbox"/>
- <col editable="false" ref="OLD_SAMPL_NO" type="input"/>
- <col editable="false" ref="SPEC_STL_GRD" type="input"/>
- <col editable="false" ref="ORD_NO" type="input"/>
- <col editable="false" ref="ORD_SEQ" type="input"/>
- <col editable="false" ref="SLAB_NO" type="input"/>
- <col editable="false" ref="COIL_THK" type="input"/>
- <col editable="false" ref="COIL_WTH" type="input"/>
- <col editable="false" ref="COIL_LEN" type="input" visibility="hidden"/>
- <col editable="false" ref="ACT_WGT" type="input"/>
- <col editable="false" ref="COIL_INDIA" type="input" visibility="hidden"/>
- <col editable="false" ref="COIL_OUTDIA" type="input" visibility="hidden"/>
- <col editable="false" ref="INSTR_COIL_THK" type="input"/>
- <col editable="false" ref="INSTR_COIL_WTH" type="input"/>
- <col editable="false" ref="INSTR_COIL_WGT" type="input"/>
- <col editable="false" ref="INSTR_COIL_LEN" type="input" visibility="hidden"/>
- <col editable="false" ref="INSTR_COIL_INDIA" type="input" visibility="hidden"/>
- <col editable="false" ref="INSTR_COIL_OUTDIA" type="input" visibility="hidden"/>
- <col editable="false" ref="CUR_LOAD_LOC" type="input"/>
- <col editmode="input" ref="TRANS_CAR_NO" type="combo" maxlength="20" style="background-color:#ffff99; ">
- <choices>
- <item>
- <label>01</label>
- <value>01</value>
- </item>
- </choices>
- </col>
- <col editable="false" ref="SHIP_INVNO" type="input" visibility="hidden"/>
- <col ref="ROUTE" type="combo" style="background-color:#ffff99; ">
- <choices>
- <item>
- <label>板加厂</label>
- <value>B</value>
- </item>
- <item>
- <label/>
- <value/>
- </item>
- </choices>
- </col>
- <col editable="false" ref="MOVE_TIME" type="input" format="yyyy-mm-dd"/>
- <col editable="false" ref="DEVLMT_DTIME" type="input" format="yyyy-mm-dd"/>
- <col editable="false" ref="ORDCUST_CD" type="input" visibility="hidden"/>
- <col editable="false" ref="ORDCUST_CD_DESC" type="input"/>
- <col editable="false" ref="CUST_CD_DESC" type="input"/>
- <col editable="false" ref="DEST_PCD_DESC" type="input"/>
- <col editable="false" ref="DEST_PCD" type="input" visibility="hidden"/>
- <col editable="false" ref="PRODNM_CD" type="input"/>
- <col editable="false" ref="SPEC_ABBSYM" type="input"/>
- <col editable="false" ref="MILL_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss"/>
- <col editable="false" ref="CUR_PROG_CD" type="input"/>
- <col editable="false" ref="EXTSHAPE_DEC_GRD_DESC" type="input"/>
- <col editable="false" ref="INGR_DEC_GRD_DESC" type="input"/>
- <col editable="false" ref="MATLQLTY_DEC_GRD_DESC" type="input"/>
- <col editable="false" ref="SIZE_DEC_RST_DESC" type="input"/>
- <col editable="false" ref="WGT_DEC_RST_DESC" type="input"/>
- <col editable="false" ref="TOT_DEC_GRD_DESC" type="input"/>
- <col ref="CRK_CD1" type="output" visibility="hidden"/>
- <col ref="CRK_CD2" type="output" visibility="hidden"/>
- <col ref="CRK_CD3" type="output" visibility="hidden"/>
- <col ref="CRK_CD4" type="output" visibility="hidden"/>
- <col ref="CRK_CD5" type="output" visibility="hidden"/>
- <col ref="MOVE_ST" visibility="hidden"/>
- <col editable="false" ref="EXTSHAPE_DEC_GRD" type="input" visibility="hidden"/>
- <col editable="false" ref="INGR_DEC_GRD" type="input" visibility="hidden"/>
- <col editable="false" ref="MATLQLTY_DEC_GRD" type="input" visibility="hidden"/>
- <col editable="false" ref="SIZE_DEC_RST" type="input" visibility="hidden"/>
- <col editable="false" ref="WGT_DEC_RST" type="input" visibility="hidden"/>
- <col editable="false" ref="TOT_DEC_GRD" type="input" visibility="hidden"/>
- <col editable="false" ref="COIL_NO" type="input" visibility="hidden"/>
- </datagrid>
- <caption id="caption4" class="cell" style="left:0px; top:285px; width:65px; height:20px; font-weight:bold; border-color:#000000; ">移送实绩</caption>
- <datagrid id="datagrid2" nodeset="/root/datagrid2/TRANF_COMPLETE_VO/TRANF_COMPLETE_Row" scroll="both" allowuserresize="true" caption="选择^钢卷号^钢码^合同号^订单号^钢卷^钢卷^钢卷^钢卷^车辆号^板加移送货单^冷轧移送货单^移送目的地^移送日期^钢卷退回放置位置^移送状态^接收人^接收时间^退回人^退回时间^退回原因^热轧退回入库人^热轧退回入库时间^板加退回入库人^板加退回入库时间^冷轧退回入库人^冷轧退回入库时间^移送人^移送时间^^^^^^^^^^^^|选择^钢卷号^钢码^合同号^订单号^厚度^宽度^长度^重量^车辆号^板加移送货单^冷轧移送货单^移送目的地^移送日期^钢卷退回放置位置^移送状态^接收人^接收时间^退回人^退回时间^退回原因^热轧退回入库人^热轧退回入库时间^板加退回入库人^板加退回入库时间^冷轧退回入库人^冷轧退回入库时间^移送人^移送时间^^^^^^^^^^^^" colsep="^" colwidth="31, 91, 84, 70, 41, 32, 33, 33, 31, 83, 65, 65, 52, 83, 76, 108, 45, 71, 70, 79, 100, 61, 78, 54, 70, 57, 67, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" defaultrows="18" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowsep="|" selectionmode="free" style="left:0px; top:305px; width:980px; height:295px; border-color:#000000; ">
- <col checkvalue="Y,N" ref="CHK" type="checkbox"/>
- <col editable="false" ref="OLD_SAMPL_NO" type="input"/>
- <col editable="false" ref="SPEC_STL_GRD" type="input"/>
- <col editable="false" ref="ORD_NO" type="input"/>
- <col editable="false" ref="ORD_SEQ" type="input"/>
- <col editable="false" ref="COIL_THK" type="input"/>
- <col editable="false" ref="COIL_WTH" type="input"/>
- <col editable="false" ref="COIL_LEN" type="input"/>
- <col editable="false" ref="ACT_WGT" type="input"/>
- <col editable="false" ref="TRANS_CAR_NO" type="input"/>
- <col editable="false" ref="SHIP_INVNO" type="input"/>
- <col editable="false" ref="SHIP_INVNO_CR" type="input"/>
- <col disabled="true" ref="ROUTE" type="combo">
- <choices>
- <item>
- <label>板加厂</label>
- <value>B</value>
- </item>
- <item>
- <label>冷轧厂</label>
- <value>C</value>
- </item>
- </choices>
- </col>
- <col editable="false" ref="MOVE_TIME" type="input" format="yyyy-mm-dd hh:nn:ss"/>
- <col ref="RTN_CUR_STORE_LOC" type="input" maxlength="10" style="background-color:#ffff99; "/>
- <col disabled="true" ref="MOVE_ST" type="combo">
- <choices>
- <item>
- <label>板加接收等待</label>
- <value>0</value>
- </item>
- <item>
- <label>板加接收</label>
- <value>1</value>
- </item>
- <item>
- <label>热轧移送退回卷重新入库</label>
- <value>2</value>
- </item>
- <item>
- <label>板加退回</label>
- <value>3</value>
- </item>
- <item>
- <label>冷轧接收等待</label>
- <value>4</value>
- </item>
- <item>
- <label>冷轧接收</label>
- <value>5</value>
- </item>
- <item>
- <label>冷轧退回</label>
- <value>6</value>
- </item>
- <item>
- <label>冷轧退回卷重新入库</label>
- <value>7</value>
- </item>
- <item>
- <label>板加退回卷重新入库</label>
- <value>8</value>
- </item>
- </choices>
- </col>
- <col editable="false" ref="CREATOR" type="input"/>
- <col editable="false" ref="CREATE_TIME" type="input"/>
- <col editable="false" ref="RETURN_REG" type="input"/>
- <col editable="false" ref="RETURN_DTIME" type="input"/>
- <col editable="false" ref="RTN_CAU_CD" type="input"/>
- <col editable="false" ref="YSRETURN_REG" type="input"/>
- <col editable="false" ref="YSRETURN_DTIME" type="input"/>
- <col editable="false" ref="BJRETURN_REG" type="input"/>
- <col editable="false" ref="BJRETURN_DTIME" type="input"/>
- <col editable="false" ref="CRRETURN_REG" type="input"/>
- <col editable="false" ref="CRRETURN_DTIME" type="input"/>
- <col editable="false" ref="ENTRY_REG" type="input"/>
- <col editable="false" ref="ENTRY_DTIME" type="input"/>
- <col editable="false" ref="MATLQLTY_DEC_GRD_DESC" type="input" visibility="hidden"/>
- <col editable="false" ref="TOT_DEC_GRD_DESC" type="input" visibility="hidden"/>
- <col editable="false" ref="ORDCUST_CD_DESC" type="input" visibility="hidden"/>
- <col editable="false" ref="ORDCUST_CD" type="input" visibility="hidden"/>
- <col editable="false" ref="CUST_CD_DESC" type="input" visibility="hidden"/>
- <col editable="false" ref="COIL_NO" type="input" visibility="hidden"/>
- <col editable="false" ref="INSTR_COIL_THK" type="input" visibility="hidden"/>
- <col editable="false" ref="INSTR_COIL_WTH" type="input" visibility="hidden"/>
- <col editable="false" ref="PRODNM_CD" type="input" visibility="hidden"/>
- <col editable="false" ref="SPEC_ABBSYM" type="input" visibility="hidden"/>
- <col editable="false" ref="DEST_PCD_DESC" type="input" visibility="hidden"/>
- <col editable="false" ref="DEST_PCD" type="input" visibility="hidden"/>
- </datagrid>
- <caption id="caption5" class="cell" style="left:70px; top:285px; width:85px; height:20px; font-weight:bold; border-color:#000000; ">移 送 日 期</caption>
- <caption id="caption6" class="cell" style="left:265px; top:285px; width:85px; height:20px; font-weight:bold; border-color:#000000; ">车 辆 号</caption>
- <input id="input2" ref="/root/searchData/MOVE_TIME" inputtype="date" style="left:155px; top:285px; width:100px; height:20px; background-color:#ffff99; "/>
- <input id="input1" ref="/root/searchData/TRANS_CAR_NO" style="left:350px; top:285px; width:120px; height:20px; background-color:#ffff99; "/>
- <input id="input3" ref="/root/searchData/SHIP_INVNO_CR" visibility="hidden" style="left:350px; top:260px; width:120px; height:20px; background-color:#ffff99; "/>
- <caption id="caption7" class="cell" visibility="hidden" style="left:265px; top:260px; width:85px; height:20px; font-weight:bold; border-color:#000000; ">冷轧移送货单</caption>
- <button id="button3" style="left:890px; top:285px; width:90px; height:20px; border-color:#000000; ">
- <caption>板加厂退回入库</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- SaveReturn();
- ]]>
- </script>
- </button>
- <button id="button4" style="left:810px; top:285px; width:80px; height:20px; border-color:#000000; ">
- <caption>热轧退回入库</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- SaveError();
- ]]>
- </script>
- </button>
- <input id="combo4" ref="/root/searchData/OLD_SAMPL_NO" editmode="input" appearance="minimal" style="left:130px; top:0px; width:90px; height:20px; background-color:#ffff99; border-color:#000000; "/>
- <caption id="caption11" class="cell" style="left:70px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">钢卷号</caption>
- <select1 id="combo5" ref="/root/searchData/MOVE_ST" appearance="minimal" editmode="input" style="left:540px; top:285px; width:135px; height:20px; background-color:#ffff99; border-color:#000000; ">
- <choices>
- <item>
- <label>板加接收等待</label>
- <value>0</value>
- </item>
- <item>
- <label>板加接收</label>
- <value>1</value>
- </item>
- <item>
- <label>热轧退回卷重新入库</label>
- <value>2</value>
- </item>
- <item>
- <label>板加退回</label>
- <value>3</value>
- </item>
- <item>
- <label>冷轧接收等待</label>
- <value>4</value>
- </item>
- <item>
- <label>冷轧接收</label>
- <value>5</value>
- </item>
- <item>
- <label>冷轧退回</label>
- <value>6</value>
- </item>
- <item>
- <label>冷轧退回卷重新入库</label>
- <value>7</value>
- </item>
- <item>
- <label>板加退回卷重新入库</label>
- <value>8</value>
- </item>
- <item>
- <label/>
- <value/>
- </item>
- </choices>
- </select1>
- <caption id="caption12" class="cell" style="left:480px; top:285px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">移送状态</caption>
- <button id="button1" visibility="hidden" style="left:715px; top:285px; width:90px; height:20px; border-color:#000000; ">
- <caption>冷轧厂退回入库</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- SaveCRReturn();
- ]]>
- </script>
- </button>
- <caption id="caption13" class="cell" style="left:70px; top:260px; width:90px; height:20px; font-weight:bold; border-color:#000000; ">板加移送货单</caption>
- <input id="input4" ref="/root/searchData/SHIP_INVNO" style="left:155px; top:260px; width:100px; height:20px; background-color:#ffff99; "/>
- <caption id="caption14" class="cell" style="left:225px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">钢 码</caption>
- <input id="input5" ref="/root/searchData/SPEC_STL_GRD" editmode="input" appearance="minimal" style="left:285px; top:0px; width:95px; height:20px; background-color:#ffff99; border-color:#000000; "/>
- <caption id="caption15" class="cell" style="left:390px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">发货单位</caption>
- <input id="input6" ref="/root/searchData/ORDCUST_CD_DESC" editmode="input" appearance="minimal" style="left:450px; top:0px; width:120px; height:20px; background-color:#ffff99; border-color:#000000; "/>
- <button id="button2" style="left:885px; top:260px; width:95px; height:20px; background-color:#c0c0c0; ">
- <caption>打印</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- //这里发货明细的打印应该是同一客户同一运输指示号下的
- var nodeSet1 = datagrid2.nodeset;
- var SHIP_INVNO1 = null;
- //不同合同号的需要打印不同的明细
- var ORD_NO_TMP = null;
- //运输方式
- var DLIV_TP = null;
-
- //清空表格dg2
- model.removenode("/root/gridData2");
- model.makeNode("/root/gridData2");
-
- dg2.refresh();
-
- for(var i=1;i<=datagrid2.rows;i++){
-
- var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
-
- if(chk1 == "Y"){
- SHIP_INVNO1 = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
- DLIV_TP = model.getValue(nodeSet1+"["+i+"]/DLIV_TP");
- ORD_NO_TMP = model.getValue(nodeSet1+"["+i+"]/ORD_NO");
-
- break;
- }
-
-
- }
-
- //再次循环datagrid1,如果发现车厢号不同的就给出提示。并且打印不成功
- for(var i=1;i<=datagrid2.rows;i++){
- var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
-
- if(chk1 == "Y"){
- var SHIP_INVNO = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
- while(SHIP_INVNO1 != SHIP_INVNO){
- alert(" 不同运输指示号下的卷不能生成同一张发货明细,请确认后重新选择! ");
- return;
- }
- }
- }
- //取出第一个合同号
- var ORD_NO_TMP1 = null;
- //这里合同号不一样的,需要单独提示
- for(var i=1;i<=datagrid2.rows;i++){
- var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
-
- while(chk1 == "Y"){
- ORD_NO_TMP1 = model.getValue(nodeSet1+"["+i+"]/ORD_NO");
- break;
- }
-
- if(ORD_NO_TMP != ORD_NO_TMP1 && ORD_NO_TMP != null && ORD_NO_TMP1 !=null){
- alert(" 同运输指示号下的卷,合同号不一样需要分开打印发货明细! ");
- return;
- }
- }
-
- //送板加只有汽车的方式
- commAppendData ("/root/gridData2/ListResult_1_VO" ,"/root/EXCELHeadCAR/ListResult_1_VO" );
-
-
- //把表头数据放入后还需要放入主题数据
- //这里表头数据就占用了前8行,主体数据从第9行开始有一个加一个
-
- var num_row = 8;
- //这里通过运输方式来区分
- var DLIV_TP = null;
- //合同号
- var ORD_NO = null;
- //发货单号,对应表单的发货清单号
- var SHIP_INVNO = null;
- //运输指示号
- var DLIV_DIRNO = null;
- //用户编码,对应合同单位
- var CUST_NM = null;
- //用户编码,对应收货单位
- var ORD_NM = null;
- //到站
- var DEST_PCD_DESC = null;
- //制表,这里使用登录人
- var REG_ID = null;
- //车号
- var TRANS_CAR_NO = null;
- //收货单位,对应用户编码
- //产品名称
- var PRODNM_CD = null;
- //标准
- var SPEC_ABBSYM = null;
- //钢卷个数
- var coil_num_tmp = null;
- //钢卷重量
- var coil_wgt_tmp = null;
- //草支垫重量
- var CZD = null;
- //合同备注,新加入的
- var HCOLOUR_REM = null;
-
- for(var i=1;i<=datagrid2.rows;i++){
- var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
-
- if(chk1 == "Y"){
-
- ///alert("num_row : "+num_row);
- coil_num_tmp = coil_num_tmp +1;
-
- ///alert("coil_num_tmp : "+coil_num_tmp);
-
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col1");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col2");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col3");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col4");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col5");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col6");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col7");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col8");
-
- //轧批号//钢卷号,真实钢卷号
- var COIL_NO = model.getValue(nodeSet1+"["+i+"]/OLD_SAMPL_NO");
- //钢号
- var SPEC_STL_GRD = model.getValue(nodeSet1+"["+i+"]/SPEC_STL_GRD");
-
- //规格,没有
- var T_W = model.getValue(nodeSet1+"["+i+"]/INSTR_COIL_THK")+"*"+model.getValue(nodeSet1+"["+i+"]/INSTR_COIL_WTH");
- //重量(吨)
- var COIL_WGT = model.getValue(nodeSet1+"["+i+"]/ACT_WGT");
- //等级,这里使用表述字段
- var TOT_DEC_GRD = model.getValue(nodeSet1+"["+i+"]/TOT_DEC_GRD_DESC");
- //性能 MATLQLTY_DEC_GRD。这里使用表述字段
- var MATLQLTY_DEC_GRD = model.getValue(nodeSet1+"["+i+"]/MATLQLTY_DEC_GRD_DESC");
- //备注
- //这里循环获取表格主体数据
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col1",COIL_NO.substr(0,10));
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col2",SPEC_STL_GRD);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col3",T_W);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col4",(COIL_WGT/1000));
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col5",COIL_NO);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col6",TOT_DEC_GRD);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col7",MATLQLTY_DEC_GRD);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col8","");
-
- //这里获取表头数据
- //这里把需要的值放入特定的位置,写死并且需要区分火运和汽运的情况。
- //这里通过运输方式来区分
- //DLIV_TP = model.getValue(nodeSet1+"["+i+"]/DLIV_TP");
- //合同号
- ORD_NO = model.getValue(nodeSet1+"["+i+"]/ORD_NO");
- //发货单号,对应表单的发货清单号
- SHIP_INVNO = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
- //运输指示号
- DLIV_DIRNO = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
- //用户编码,对应客户公司
- CUST_NM = model.getValue(nodeSet1+"["+i+"]/CUST_CD_DESC");
- ORD_NM = model.getValue(nodeSet1+"["+i+"]/ORDCUST_CD_DESC");
-
- //发货日,这里取出库时间
- var SYS_TIME = model.getValue(nodeSet1+"["+i+"]/ENTRY_DTIME");
- //编号,这里新钢有自己的编号规则。所以先空着确认后再处理
-
- //计划单号,这里新钢没有填入。暂时空着
-
- //到站
- DEST_PCD_DESC = model.getValue(nodeSet1+"["+i+"]/DEST_PCD_DESC");
- //制表,这里使用出库人
- REG_ID = model.getValue(nodeSet1+"["+i+"]/ENTRY_REG");
- //计划单号
-
- //车号
- TRANS_CAR_NO = model.getValue(nodeSet1+"["+i+"]/TRANS_CAR_NO");
- //收货单位
-
- //发货备注,这里为空
-
- //产品名称
- PRODNM_CD = model.getValue(nodeSet1+"["+i+"]/PRODNM_CD");
- //标准
- SPEC_ABBSYM = model.getValue(nodeSet1+"["+i+"]/SPEC_ABBSYM");
-
- //钢卷重量累加
- coil_wgt_tmp = Number(COIL_WGT) + Number(coil_wgt_tmp);
-
- //草支垫重量
- //CZD = model.getValue("/root/CZD");
-
- //外贸合同颜色备注栏
- //HCOLOUR_REM = model.getValue(nodeSet1+"["+i+"]/HCOLOUR_REM");
-
- //alert("coil_wgt_tmp : "+coil_wgt_tmp);
- //先赋值再增加行
- num_row = num_row+1;
- }
- }
-
- //alert("dg2.rows : "+dg2.rows);
- //这里能不能在添加几个空行,以便后面合计使用
- for(var j=dg2.rows;j<=20;j++){
-
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col1");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col2");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col3");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col4");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col5");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col6");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col7");
- model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col8");
- }
-
- //汽运的情况
- //合同号和发货单号,第二行
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[2]/col2","'"+ORD_NO);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[2]/col5",DLIV_DIRNO);
- //第三行,用户编码
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[3]/col2","");
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[3]/col5",SYS_TIME);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[3]/col6","第"+SHIP_INVNO+"号");
- //第四行,用户名称
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[4]/col2",CUST_NM);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[4]/col5",DEST_PCD_DESC.substr(0,9));
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[4]/col7",REG_ID);
- //第五行,计划单号
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[5]/col2","");
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[5]/col5",TRANS_CAR_NO);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[5]/col7",ORD_NM);
- //第六行,发货备注
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[6]/col2","");
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[6]/col5",PRODNM_CD);
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[6]/col7",SPEC_ABBSYM);
-
- //第20行,总计
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col1","小计");
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col3",coil_num_tmp+"卷");
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col4",Number(coil_wgt_tmp/1000));
- model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col8","");
-
- model.refresh();
-
- //导出EXCEL方法
- saveExcelScript(dg2, "Sheet1");
-
- find();
- ]]>
- </script>
- <hint>
- <![CDATA[打印的发货明细请保存在C盘]]>
- </hint>
- </button>
- <object id="ObjTFExcel" clsid="{fe8d1001-6a9d-424d-ae2a-301493bb12da}" style="left:715px; top:260px; width:155px; height:25px; "/>
- <datagrid id="dg2" nodeset="/root/gridData2/ListResult_1_VO/ListResult_1_Row" visibility="hidden" caption="cols_1^cols_2^cols_3^cols_4^cols_5^cols_6^cols_7^cols_8" colsep="^" colwidth="100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:305px; width:805px; height:290px; ">
- <col ref="col1"/>
- <col ref="col2"/>
- <col ref="col3"/>
- <col ref="col4"/>
- <col ref="col5"/>
- <col ref="col6"/>
- <col ref="col7"/>
- <col ref="col8"/>
- </datagrid>
- <caption id="caption16" class="cell" style="left:225px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">移送时间</caption>
- <caption id="caption17" class="cell" style="left:70px; top:25px; width:60px; height:20px; font-weight:bold; vertical-align:middle; border-color:#000000; ">移送人</caption>
- <select1 id="combo7" ref="/root/searchData/ENTRY_REG" appearance="minimal" editmode="input" style="left:130px; top:25px; width:90px; height:20px; background-color:#ffff99; ">
- <choices>
- <item>
- <label>刘文</label>
- <value>刘文</value>
- </item>
- <item>
- <label>蔡伟平</label>
- <value>蔡伟平</value>
- </item>
- <item>
- <label>廖林敏</label>
- <value>廖林敏</value>
- </item>
- <item>
- <label>李斌</label>
- <value>李斌</value>
- </item>
- <item>
- <label>吴贤峰</label>
- <value>吴贤峰</value>
- </item>
- <item>
- <label>敖艳敏</label>
- <value>敖艳敏</value>
- </item>
- <item>
- <label>林珑</label>
- <value>林珑</value>
- </item>
- <item>
- <label>成武</label>
- <value>成武</value>
- </item>
- <item>
- <label>安凡能</label>
- <value>安凡能</value>
- </item>
- <item>
- <label>陈小勇</label>
- <value>陈小勇</value>
- </item>
- <item>
- <label>刘忠华</label>
- <value>刘忠华</value>
- </item>
- </choices>
- </select1>
- <input id="input7" ref="/root/searchData/ENTRY_DTIME" inputtype="date" format="yyyy-mm-dd" style="left:285px; top:25px; width:100px; height:20px; background-color:#ffff99; "/>
- <caption id="caption18" class="cell" style="left:575px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">合同号</caption>
- <input id="input8" ref="/root/searchData/ORD_NO" editmode="input" appearance="minimal" style="left:635px; top:0px; width:120px; height:20px; background-color:#ffff99; border-color:#000000; "/>
- </xhtml:body>
- </xhtml:html>
|