UIH070010.xrw 47 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <?xml-stylesheet type="text/css" href="../../css/body.css" ?>
  3. <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">
  4. <xhtml:head>
  5. <xhtml:title>
  6. <![CDATA[热轧作业 >> 钢卷库管理 >> 板加移送实绩登录与查询(UIH070010) ]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <resData/>
  12. <reqData/>
  13. <searchData>
  14. <OLD_SAMPL_NO/>
  15. <MOVE_SHIFT/>
  16. <MOVE_GROUP/>
  17. <MOVE_TIME/>
  18. <TRANS_CAR_NO/>
  19. <SHIP_INVNO/>
  20. <MOVE_ST>0</MOVE_ST>
  21. <SHIP_INVNO_CR/>
  22. <SPEC_STL_GRD/>
  23. <ORDCUST_CD_DESC/>
  24. <ENTRY_REG/>
  25. <ENTRY_DTIME/>
  26. <ORD_NO/>
  27. </searchData>
  28. <datagrid1/>
  29. <datagrid2/>
  30. <EXCELHeadCAR>
  31. <ListResult_1_VO>
  32. <ListResult_1_Row>
  33. <col1>新余钢铁股份有限公司钢卷发货明细单(汽车)</col1>
  34. <col2/>
  35. <col3/>
  36. <col4/>
  37. <col5/>
  38. <col6/>
  39. <col7/>
  40. <col8/>
  41. </ListResult_1_Row>
  42. <ListResult_1_Row>
  43. <col1>合 同 号:</col1>
  44. <col2/>
  45. <col3/>
  46. <col4>发货单号:</col4>
  47. <col5/>
  48. <col6/>
  49. <col7/>
  50. <col8/>
  51. </ListResult_1_Row>
  52. <ListResult_1_Row>
  53. <col1>用户编码:</col1>
  54. <col2/>
  55. <col3/>
  56. <col4>发货日:</col4>
  57. <col5/>
  58. <col6/>
  59. <col7/>
  60. <col8/>
  61. </ListResult_1_Row>
  62. <ListResult_1_Row>
  63. <col1>用户名称:</col1>
  64. <col2/>
  65. <col3/>
  66. <col4>到站:</col4>
  67. <col5/>
  68. <col6>制表:</col6>
  69. <col7/>
  70. <col8/>
  71. </ListResult_1_Row>
  72. <ListResult_1_Row>
  73. <col1>计划单号:</col1>
  74. <col2/>
  75. <col3/>
  76. <col4>车号:</col4>
  77. <col5/>
  78. <col6>收货单位:</col6>
  79. <col7/>
  80. <col8/>
  81. </ListResult_1_Row>
  82. <ListResult_1_Row>
  83. <col1>发货备注:</col1>
  84. <col2/>
  85. <col3/>
  86. <col4>产品名称:</col4>
  87. <col5/>
  88. <col6>标准:</col6>
  89. <col7/>
  90. <col8/>
  91. </ListResult_1_Row>
  92. <ListResult_1_Row>
  93. <col1>轧批号</col1>
  94. <col2>钢号</col2>
  95. <col3>规格(厚*宽)mm</col3>
  96. <col4>重量(吨)</col4>
  97. <col5>钢卷号</col5>
  98. <col6>等级</col6>
  99. <col7>性能</col7>
  100. <col8>备注</col8>
  101. </ListResult_1_Row>
  102. </ListResult_1_VO>
  103. </EXCELHeadCAR>
  104. <gridData2/>
  105. </root>
  106. </instance>
  107. </model>
  108. <script type="javascript">
  109. <![CDATA[
  110. function Init(node) {
  111. InitParams(node);
  112. }
  113. //调用公共的初始化方法获得登录用户名
  114. function InitParams(node) {
  115. if (typeof node == "undefined" && typeof node != "object") return;
  116. model.removenode("/root/initData/rcvInfo");
  117. model.makeNode("/root/initData/rcvInfo");
  118. var nodeList = node.childNodes;
  119. node = model.instances(0).selectSingleNode("/root/initData/rcvInfo");
  120. for (var i = 0; i < nodeList.length; i++)
  121. node.appendChild(nodeList.item(i));
  122. }
  123. function excelExport(){
  124. return datagrid2;
  125. }
  126. //查询方法
  127. function find(){
  128. model.removenode("/root/reqData");
  129. model.makeNode("/root/reqData");
  130. //这里必须给出移送状态
  131. if(model.getValue("/root/searchData/MOVE_ST") == null){
  132. alert(" 移送状态选择项目不能为空,请选择后再进行查询操作!! ");
  133. return;
  134. }
  135. commSendReq("/root/searchData");
  136. commSubmit("UIH070010-service", "find", "glueAction.do");
  137. commAppendData("/root/datagrid1/TRANF_WAIT_VO","/root/resData/TRANF_WAIT_VO");
  138. commAppendData("/root/datagrid2/TRANF_COMPLETE_VO","/root/resData/TRANF_COMPLETE_VO");
  139. model.refresh();
  140. }
  141. //保存
  142. function save(){
  143. model.removenode("/root/reqData");
  144. model.makeNode("/root/reqData");
  145. if(model.getValue("/root/searchData/MOVE_SHIFT") == ""){
  146. alert(" 移送班次信息不能为空,请选择移送班次信息! ");
  147. return;
  148. }
  149. if(model.getValue("/root/searchData/MOVE_GROUP") == ""){
  150. alert(" 移送班组信息不能为空,请选择移送班组信息! ");
  151. return;
  152. }
  153. if(model.getValue("/root/searchData/ENTRY_REG") == ""){
  154. alert(" 移送人信息不能为空,请选择移送人信息! ");
  155. return;
  156. }
  157. if(model.getValue("/root/searchData/ENTRY_DTIME") == ""){
  158. alert(" 移送时间信息不能为空,请选择移送时间信息! ");
  159. return;
  160. }
  161. //这里给出行状态设置,避免出现数据不能提交的情况
  162. for(var i=0;i<datagrid1.rows;i++){
  163. datagrid1.rowStatus(i) = 2;
  164. }
  165. model.refresh();
  166. commMultiUpdate(datagrid1,"/root/reqData","A",true,"rowStatus");
  167. //这里加入登录用户名,会不会与已有的initData冲突
  168. model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
  169. model.makeValue("/root/reqData/MOVE_SHIFT",model.getValue("/root/searchData/MOVE_SHIFT"));
  170. model.makeValue("/root/reqData/MOVE_GROUP",model.getValue("/root/searchData/MOVE_GROUP"));
  171. model.makeValue("/root/reqData/ENTRY_REG",model.getValue("/root/searchData/ENTRY_REG"));
  172. model.makeValue("/root/reqData/ENTRY_DTIME",model.getValue("/root/searchData/ENTRY_DTIME"));
  173. commSubmit("UIH070010-service", "save", "glueAction.do");
  174. model.refresh();
  175. if(model.getValue("/root/resData/rs_VO/rs_Row") == "ROUTE"){
  176. alert(" 钢卷移送目的地没有选择,请确认后重新输入!! ");
  177. return;
  178. }
  179. if(model.getValue("/root/resData/rs_VO/rs_Row") == "CUR_PROG_CD"){
  180. alert(" 选中的钢卷不为发货待机,不能进行移送操作!! ");
  181. return;
  182. }
  183. find();
  184. }
  185. //对从板加退回的板坯,返回我们自己仓库的保存按钮
  186. function SaveReturn(){
  187. //这里对板加退回的情况进行处理,允许回退到移送界面
  188. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("CHK")) == "Y"){
  189. //如果是选中行,判断回退放置位置不为空和移送状态为板加退回的才能回退
  190. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "3"){
  191. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("RTN_CUR_STORE_LOC")) == ""){
  192. alert(" 钢卷回退垛位为空,不能进行移送回退操作!! ");
  193. return;
  194. }else{
  195. //进行回退操作,在后台判断输入的垛位是否符合要求
  196. model.removenode("/root/reqData");
  197. model.makeNode("/root/reqData");
  198. //这里给出行状态设置,避免出现数据不能提交的情况
  199. for(var i=0;i<datagrid2.rows;i++){
  200. datagrid2.rowStatus(i) = 2;
  201. }
  202. model.refresh();
  203. commMultiUpdate(datagrid2,"/root/reqData","A",true,"rowStatus");
  204. //这里加入登录用户名,会不会与已有的initData冲突
  205. model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
  206. commSubmit("UIH070010-service", "BJreturn", "glueAction.do");
  207. model.refresh();
  208. if(model.getValue("/root/resData/rs_VO/rs_Row") == "CoilYard"){
  209. alert(" 钢卷退回位置输入不正确,请确认后重新输入!! ");
  210. return;
  211. }
  212. if(model.getValue("/root/resData/rs_VO/rs_Row") == "COIL_NO"){
  213. alert(" 钢卷退回位置已经存在钢卷,请确认后重新输入!! ");
  214. return;
  215. }
  216. if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST"){
  217. alert(" 钢卷移送状态不为板加退回,不能进行板加退回入库操作!! ");
  218. return;
  219. }
  220. if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST_TMP"){
  221. alert(" 钢卷移送状态不为板加退回,不能进行板加退回入库操作!! ");
  222. return;
  223. }
  224. find();
  225. }
  226. }else{
  227. alert(" 移送状态不为板加回退,不能进行板加回退入库操作! ");
  228. return;
  229. }
  230. }
  231. }
  232. //操作员手工录入错误的情况
  233. function SaveError(){
  234. //这里对误选择的情况进行处理,允许回退到移送界面
  235. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("CHK")) == "Y"){
  236. //如果是选中行,判断回退放置位置不为空和移送状态为等待的才能回退
  237. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "0" || datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "4"){
  238. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("RTN_CUR_STORE_LOC")) == ""){
  239. alert(" 钢卷回退垛位为空,不能进行移送回退操作!! ");
  240. return;
  241. }else{
  242. //进行回退操作,在后台判断输入的垛位是否符合要求
  243. model.removenode("/root/reqData");
  244. model.makeNode("/root/reqData");
  245. //这里给出行状态设置,避免出现数据不能提交的情况
  246. for(var i=0;i<datagrid2.rows;i++){
  247. datagrid2.rowStatus(i) = 2;
  248. }
  249. model.refresh();
  250. commMultiUpdate(datagrid2,"/root/reqData","A",true,"rowStatus");
  251. //这里加入登录用户名,会不会与已有的initData冲突
  252. model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
  253. commSubmit("UIH070010-service", "YSreturn", "glueAction.do");
  254. model.refresh();
  255. if(model.getValue("/root/resData/rs_VO/rs_Row") == "CoilYard"){
  256. alert(" 钢卷退回位置输入不正确,请确认后重新输入!! ");
  257. return;
  258. }
  259. if(model.getValue("/root/resData/rs_VO/rs_Row") == "COIL_NO"){
  260. alert(" 钢卷退回位置已经存在钢卷,请确认后重新输入!! ");
  261. return;
  262. }
  263. if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST"){
  264. alert(" 钢卷移送状态不为等待,不能进行热轧退回入库操作!! ");
  265. return;
  266. }
  267. //这里为了避免打开界面不查询的情况,从界面获取的移送状态不对
  268. if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST_TMP"){
  269. alert(" 钢卷移送状态不为等待,不能进行热轧退回入库操作!! ");
  270. return;
  271. }
  272. find();
  273. }
  274. }else{
  275. alert(" 移送状态不为板加接收等待或者冷轧接收等待,不能进行热轧退回入库操作!!");
  276. return;
  277. }
  278. }
  279. }
  280. //对从冷轧退回的钢卷,返回热轧库的保存按钮
  281. function SaveCRReturn(){
  282. //这里对板加退回的情况进行处理,允许回退到移送界面
  283. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("CHK")) == "Y"){
  284. //如果是选中行,判断回退放置位置不为空和移送状态为板加退回的才能回退
  285. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("MOVE_ST")) == "6"){
  286. if(datagrid2.valueMatrix(datagrid2.row,datagrid2.colRef("RTN_CUR_STORE_LOC")) == ""){
  287. alert(" 钢卷回退垛位为空,不能进行移送回退操作!! ");
  288. return;
  289. }else{
  290. //进行回退操作,在后台判断输入的垛位是否符合要求
  291. model.removenode("/root/reqData");
  292. model.makeNode("/root/reqData");
  293. //这里给出行状态设置,避免出现数据不能提交的情况
  294. for(var i=0;i<datagrid2.rows;i++){
  295. datagrid2.rowStatus(i) = 2;
  296. }
  297. model.refresh();
  298. commMultiUpdate(datagrid2,"/root/reqData","A",true,"rowStatus");
  299. //这里加入登录用户名,会不会与已有的initData冲突
  300. model.makeValue("/root/reqData/REG_ID",model.getValue("/root/initData/rcvInfo/REG_ID"));
  301. commSubmit("UIH070010-service", "CRreturn", "glueAction.do");
  302. model.refresh();
  303. if(model.getValue("/root/resData/rs_VO/rs_Row") == "CoilYard"){
  304. alert(" 钢卷退回位置输入不正确,请确认后重新输入!! ");
  305. return;
  306. }
  307. if(model.getValue("/root/resData/rs_VO/rs_Row") == "COIL_NO"){
  308. alert(" 钢卷退回位置已经存在钢卷,请确认后重新输入!! ");
  309. return;
  310. }
  311. if(model.getValue("/root/resData/rs_VO/rs_Row") == "MOVE_ST"){
  312. alert(" 钢卷移送状态不为冷轧退回,不能进行冷轧退回入库操作!! ");
  313. return;
  314. }
  315. find();
  316. }
  317. }else{
  318. alert(" 移送状态不为冷轧回退,不能进行冷轧退回入库操作! ");
  319. return;
  320. }
  321. }
  322. }
  323. function saveExcelScript(sDGridName, sExcelSheetName, saveType) {
  324. var sExcelName = window.fileDialog( "save", "", false, "SaveFileName", "xls", "Excel Files(*.xls)|*.xls" );
  325. if ( sExcelName == "" ) {
  326. return;
  327. }
  328. //var sCSVName = "C:\\TFSmartUpdater\\" + sExcelName.lastIndexOf(".") +".csv";
  329. var sCSVName = sExcelName +".csv";
  330. //alert("sExcelName = ["+ sExcelName +"]\nsCSVName = ["+ sCSVName + "]");
  331. eval(sDGridName).saveText(sCSVName, "\n", ",", '\:', true); //DataGrid? ??? CSV??? ??
  332. ObjTFExcel.launchNewInstance(0); //Execute EXCEL
  333. ObjTFExcel.createWorkbook(); //Create new Workbook(for example:Sheet1,Sheet2,Sheet3) -- createWorkBook(Excel-TemplateFile)
  334. ObjTFExcel.loadCSV(sCSVName); //Loading Contents, from CSV to Excel
  335. //Setting up EXCEL Layout.
  336. var nRows = sDGridName.rows - sDGridName.fixedRows + 1; //Keep Careful !!!
  337. var nCols = sDGridName.cols;
  338. //Header
  339. //Line 1 : Sheet Title
  340. //行高的设置
  341. ObjTFExcel.rowheight( 01 ) = 50 ;
  342. ObjTFExcel.bold ( 01, 01, 01, nCols ) = true ;
  343. //改变字体大小
  344. ObjTFExcel.fontsize ( 01, 01, 01, nCols ) = 18;
  345. ObjTFExcel.underline( 01, 01, 01, nCols ) = 3 ;
  346. ObjTFExcel.halign ( 01, 01, 01, nCols ) ="center" ;
  347. ObjTFExcel.valign ( 01, 01, 01, nCols ) ="top" ;
  348. ObjTFExcel.mergeCell( 01, 01, 01, nCols ) ;
  349. ObjTFExcel.colwidth ( 01 ) = 200 ;
  350. //All of the range
  351. ObjTFExcel.fontcolor ( 01, 01, nRows, nCols ) = "#000000" ;
  352. ObjTFExcel.font ( 01, 01, nRows, nCols ) = "SimSun" ;
  353. //取消边框
  354. ObjTFExcel.setBorderColor( 07, 01, nRows, nCols, "#000000") ;
  355. ObjTFExcel.bold ( 01, 01, nRows, nCols ) = true ;
  356. //改变字体大小
  357. ObjTFExcel.fontsize ( 02, 01, nRows, nCols ) = 12 ;
  358. ObjTFExcel.underline ( 01, 01, nRows, nCols ) = 0 ;
  359. ObjTFExcel.valign ( 01, 01, nRows, nCols ) ="middle" ;
  360. //字体居中
  361. ObjTFExcel.halign ( 01, 01, nRows, nCols ) ="center" ;
  362. //字体左对齐的特殊定义
  363. ObjTFExcel.halign ( 01, 01, 02, nCols ) ="left" ;
  364. ObjTFExcel.halign ( 01, 01, 03, nCols ) ="left" ;
  365. ObjTFExcel.halign ( 01, 01, 04, nCols ) ="left" ;
  366. ObjTFExcel.halign ( 01, 01, 05, nCols ) ="left" ;
  367. ObjTFExcel.halign ( 01, 01, 06, nCols ) ="left" ;
  368. ObjTFExcel.halign ( 01, 01, 01, nCols ) ="center" ;
  369. //Query-Results Data
  370. var iRow = 1; // iRow = HeaderLine + 1;
  371. //这里设置字体的行宽
  372. // for(var i = iRow; i <= nRows; i++ ) {
  373. // if( (i%5) == 1 ) {
  374. // ObjTFExcel.rowHeight( i ) = 60;
  375. // ObjTFExcel.mergeCell( i, 01, i, nCols );
  376. // } else if( (i%5) == 0 ) {
  377. // ObjTFExcel.rowHeight( i ) = 45;
  378. // ObjTFExcel.mergeCell( i, 01, i, nCols );
  379. // } else {
  380. // ObjTFExcel.rowHeight( i ) = 40;
  381. // }
  382. // }
  383. //合并单元格
  384. ObjTFExcel.mergeCell(02,05,02,08);
  385. ObjTFExcel.mergeCell(02,02,02,03);
  386. ObjTFExcel.mergeCell(03,02,03,03);
  387. ObjTFExcel.mergeCell(04,02,04,03);
  388. ObjTFExcel.mergeCell(05,02,05,03);
  389. ObjTFExcel.mergeCell(06,02,06,03);
  390. ObjTFExcel.mergeCell(04,07,04,08);
  391. ObjTFExcel.mergeCell(05,07,05,08);
  392. ObjTFExcel.mergeCell(06,07,06,08);
  393. //改变文本格式的方法,未知
  394. //ObjTFExcel.setformat(02,02,02,03,'@');
  395. //设置列的宽度
  396. ObjTFExcel.colwidth ( 01 ) = 15 ;
  397. ObjTFExcel.colwidth ( 02 ) = 10 ;
  398. ObjTFExcel.colwidth ( 03 ) = 15 ;
  399. ObjTFExcel.colwidth ( 04 ) = 10 ;
  400. ObjTFExcel.colwidth ( 05 ) = 20 ;
  401. ObjTFExcel.colwidth ( 06 ) = 10 ;
  402. ObjTFExcel.colwidth ( 07 ) = 10 ;
  403. ObjTFExcel.colwidth ( 08 ) = 15 ;
  404. // ObjTFExcel.setFormat(iRow, 14, nRows, 14, "yyyy\"-\"mm\"-\"dd\"\" hh\":\"mm\":\"ss\"\";@");
  405. ObjTFExcel.sheetName(1) = sExcelSheetName;
  406. ObjTFExcel.save(sExcelName); //Saving EXCEL
  407. ObjTFExcel.close(); //Closing EXCEL. (You must be closed EXCEL !!!)
  408. window.exec("EXCEL.EXE", sExcelName); //Openning EXCEL
  409. }
  410. ]]>
  411. </script>
  412. <script type="javascript" src="../../js/boaMsg.js"/>
  413. <script type="javascript" src="../../js/boaCommon.js"/>
  414. </xhtml:head>
  415. <xhtml:body guideline="2,-3;">
  416. <caption id="caption3" class="cell" visibility="hidden" style="left:715px; top:285px; width:95px; height:20px; font-weight:bold; border-color:#000000; "/>
  417. <caption id="caption9" class="cell" style="left:810px; top:285px; width:80px; height:20px; font-weight:bold; border-color:#000000; "/>
  418. <caption id="caption8" class="cell" style="left:890px; top:285px; width:90px; height:20px; font-weight:bold; border-color:#000000; "/>
  419. <caption id="caption10" class="cell" style="left:0px; top:25px; width:65px; height:20px; font-weight:bold; border-color:#000000; ">移送对象</caption>
  420. <caption id="caption2" class="cell" style="left:390px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">班 次</caption>
  421. <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; ">
  422. <choices>
  423. <item>
  424. <label>甲</label>
  425. <value>A</value>
  426. </item>
  427. <item>
  428. <label>乙</label>
  429. <value>B</value>
  430. </item>
  431. <item>
  432. <label>丙</label>
  433. <value>C</value>
  434. </item>
  435. <item>
  436. <label>丁</label>
  437. <value>D</value>
  438. </item>
  439. </choices>
  440. </select1>
  441. <caption id="caption1" class="cell" style="left:575px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">班 组</caption>
  442. <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; ">
  443. <choices>
  444. <item>
  445. <label>早班</label>
  446. <value>1</value>
  447. </item>
  448. <item>
  449. <label>中班</label>
  450. <value>2</value>
  451. </item>
  452. <item>
  453. <label>晚班</label>
  454. <value>3</value>
  455. </item>
  456. </choices>
  457. </select1>
  458. <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; ">
  459. <col checkvalue="Y,N" ref="CHK" type="checkbox"/>
  460. <col editable="false" ref="OLD_SAMPL_NO" type="input"/>
  461. <col editable="false" ref="SPEC_STL_GRD" type="input"/>
  462. <col editable="false" ref="ORD_NO" type="input"/>
  463. <col editable="false" ref="ORD_SEQ" type="input"/>
  464. <col editable="false" ref="SLAB_NO" type="input"/>
  465. <col editable="false" ref="COIL_THK" type="input"/>
  466. <col editable="false" ref="COIL_WTH" type="input"/>
  467. <col editable="false" ref="COIL_LEN" type="input" visibility="hidden"/>
  468. <col editable="false" ref="ACT_WGT" type="input"/>
  469. <col editable="false" ref="COIL_INDIA" type="input" visibility="hidden"/>
  470. <col editable="false" ref="COIL_OUTDIA" type="input" visibility="hidden"/>
  471. <col editable="false" ref="INSTR_COIL_THK" type="input"/>
  472. <col editable="false" ref="INSTR_COIL_WTH" type="input"/>
  473. <col editable="false" ref="INSTR_COIL_WGT" type="input"/>
  474. <col editable="false" ref="INSTR_COIL_LEN" type="input" visibility="hidden"/>
  475. <col editable="false" ref="INSTR_COIL_INDIA" type="input" visibility="hidden"/>
  476. <col editable="false" ref="INSTR_COIL_OUTDIA" type="input" visibility="hidden"/>
  477. <col editable="false" ref="CUR_LOAD_LOC" type="input"/>
  478. <col editmode="input" ref="TRANS_CAR_NO" type="combo" maxlength="20" style="background-color:#ffff99; ">
  479. <choices>
  480. <item>
  481. <label>01</label>
  482. <value>01</value>
  483. </item>
  484. </choices>
  485. </col>
  486. <col editable="false" ref="SHIP_INVNO" type="input" visibility="hidden"/>
  487. <col ref="ROUTE" type="combo" style="background-color:#ffff99; ">
  488. <choices>
  489. <item>
  490. <label>板加厂</label>
  491. <value>B</value>
  492. </item>
  493. <item>
  494. <label/>
  495. <value/>
  496. </item>
  497. </choices>
  498. </col>
  499. <col editable="false" ref="MOVE_TIME" type="input" format="yyyy-mm-dd"/>
  500. <col editable="false" ref="DEVLMT_DTIME" type="input" format="yyyy-mm-dd"/>
  501. <col editable="false" ref="ORDCUST_CD" type="input" visibility="hidden"/>
  502. <col editable="false" ref="ORDCUST_CD_DESC" type="input"/>
  503. <col editable="false" ref="CUST_CD_DESC" type="input"/>
  504. <col editable="false" ref="DEST_PCD_DESC" type="input"/>
  505. <col editable="false" ref="DEST_PCD" type="input" visibility="hidden"/>
  506. <col editable="false" ref="PRODNM_CD" type="input"/>
  507. <col editable="false" ref="SPEC_ABBSYM" type="input"/>
  508. <col editable="false" ref="MILL_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss"/>
  509. <col editable="false" ref="CUR_PROG_CD" type="input"/>
  510. <col editable="false" ref="EXTSHAPE_DEC_GRD_DESC" type="input"/>
  511. <col editable="false" ref="INGR_DEC_GRD_DESC" type="input"/>
  512. <col editable="false" ref="MATLQLTY_DEC_GRD_DESC" type="input"/>
  513. <col editable="false" ref="SIZE_DEC_RST_DESC" type="input"/>
  514. <col editable="false" ref="WGT_DEC_RST_DESC" type="input"/>
  515. <col editable="false" ref="TOT_DEC_GRD_DESC" type="input"/>
  516. <col ref="CRK_CD1" type="output" visibility="hidden"/>
  517. <col ref="CRK_CD2" type="output" visibility="hidden"/>
  518. <col ref="CRK_CD3" type="output" visibility="hidden"/>
  519. <col ref="CRK_CD4" type="output" visibility="hidden"/>
  520. <col ref="CRK_CD5" type="output" visibility="hidden"/>
  521. <col ref="MOVE_ST" visibility="hidden"/>
  522. <col editable="false" ref="EXTSHAPE_DEC_GRD" type="input" visibility="hidden"/>
  523. <col editable="false" ref="INGR_DEC_GRD" type="input" visibility="hidden"/>
  524. <col editable="false" ref="MATLQLTY_DEC_GRD" type="input" visibility="hidden"/>
  525. <col editable="false" ref="SIZE_DEC_RST" type="input" visibility="hidden"/>
  526. <col editable="false" ref="WGT_DEC_RST" type="input" visibility="hidden"/>
  527. <col editable="false" ref="TOT_DEC_GRD" type="input" visibility="hidden"/>
  528. <col editable="false" ref="COIL_NO" type="input" visibility="hidden"/>
  529. </datagrid>
  530. <caption id="caption4" class="cell" style="left:0px; top:285px; width:65px; height:20px; font-weight:bold; border-color:#000000; ">移送实绩</caption>
  531. <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; ">
  532. <col checkvalue="Y,N" ref="CHK" type="checkbox"/>
  533. <col editable="false" ref="OLD_SAMPL_NO" type="input"/>
  534. <col editable="false" ref="SPEC_STL_GRD" type="input"/>
  535. <col editable="false" ref="ORD_NO" type="input"/>
  536. <col editable="false" ref="ORD_SEQ" type="input"/>
  537. <col editable="false" ref="COIL_THK" type="input"/>
  538. <col editable="false" ref="COIL_WTH" type="input"/>
  539. <col editable="false" ref="COIL_LEN" type="input"/>
  540. <col editable="false" ref="ACT_WGT" type="input"/>
  541. <col editable="false" ref="TRANS_CAR_NO" type="input"/>
  542. <col editable="false" ref="SHIP_INVNO" type="input"/>
  543. <col editable="false" ref="SHIP_INVNO_CR" type="input"/>
  544. <col disabled="true" ref="ROUTE" type="combo">
  545. <choices>
  546. <item>
  547. <label>板加厂</label>
  548. <value>B</value>
  549. </item>
  550. <item>
  551. <label>冷轧厂</label>
  552. <value>C</value>
  553. </item>
  554. </choices>
  555. </col>
  556. <col editable="false" ref="MOVE_TIME" type="input" format="yyyy-mm-dd hh:nn:ss"/>
  557. <col ref="RTN_CUR_STORE_LOC" type="input" maxlength="10" style="background-color:#ffff99; "/>
  558. <col disabled="true" ref="MOVE_ST" type="combo">
  559. <choices>
  560. <item>
  561. <label>板加接收等待</label>
  562. <value>0</value>
  563. </item>
  564. <item>
  565. <label>板加接收</label>
  566. <value>1</value>
  567. </item>
  568. <item>
  569. <label>热轧移送退回卷重新入库</label>
  570. <value>2</value>
  571. </item>
  572. <item>
  573. <label>板加退回</label>
  574. <value>3</value>
  575. </item>
  576. <item>
  577. <label>冷轧接收等待</label>
  578. <value>4</value>
  579. </item>
  580. <item>
  581. <label>冷轧接收</label>
  582. <value>5</value>
  583. </item>
  584. <item>
  585. <label>冷轧退回</label>
  586. <value>6</value>
  587. </item>
  588. <item>
  589. <label>冷轧退回卷重新入库</label>
  590. <value>7</value>
  591. </item>
  592. <item>
  593. <label>板加退回卷重新入库</label>
  594. <value>8</value>
  595. </item>
  596. </choices>
  597. </col>
  598. <col editable="false" ref="CREATOR" type="input"/>
  599. <col editable="false" ref="CREATE_TIME" type="input"/>
  600. <col editable="false" ref="RETURN_REG" type="input"/>
  601. <col editable="false" ref="RETURN_DTIME" type="input"/>
  602. <col editable="false" ref="RTN_CAU_CD" type="input"/>
  603. <col editable="false" ref="YSRETURN_REG" type="input"/>
  604. <col editable="false" ref="YSRETURN_DTIME" type="input"/>
  605. <col editable="false" ref="BJRETURN_REG" type="input"/>
  606. <col editable="false" ref="BJRETURN_DTIME" type="input"/>
  607. <col editable="false" ref="CRRETURN_REG" type="input"/>
  608. <col editable="false" ref="CRRETURN_DTIME" type="input"/>
  609. <col editable="false" ref="ENTRY_REG" type="input"/>
  610. <col editable="false" ref="ENTRY_DTIME" type="input"/>
  611. <col editable="false" ref="MATLQLTY_DEC_GRD_DESC" type="input" visibility="hidden"/>
  612. <col editable="false" ref="TOT_DEC_GRD_DESC" type="input" visibility="hidden"/>
  613. <col editable="false" ref="ORDCUST_CD_DESC" type="input" visibility="hidden"/>
  614. <col editable="false" ref="ORDCUST_CD" type="input" visibility="hidden"/>
  615. <col editable="false" ref="CUST_CD_DESC" type="input" visibility="hidden"/>
  616. <col editable="false" ref="COIL_NO" type="input" visibility="hidden"/>
  617. <col editable="false" ref="INSTR_COIL_THK" type="input" visibility="hidden"/>
  618. <col editable="false" ref="INSTR_COIL_WTH" type="input" visibility="hidden"/>
  619. <col editable="false" ref="PRODNM_CD" type="input" visibility="hidden"/>
  620. <col editable="false" ref="SPEC_ABBSYM" type="input" visibility="hidden"/>
  621. <col editable="false" ref="DEST_PCD_DESC" type="input" visibility="hidden"/>
  622. <col editable="false" ref="DEST_PCD" type="input" visibility="hidden"/>
  623. </datagrid>
  624. <caption id="caption5" class="cell" style="left:70px; top:285px; width:85px; height:20px; font-weight:bold; border-color:#000000; ">移 送 日 期</caption>
  625. <caption id="caption6" class="cell" style="left:265px; top:285px; width:85px; height:20px; font-weight:bold; border-color:#000000; ">车 辆 号</caption>
  626. <input id="input2" ref="/root/searchData/MOVE_TIME" inputtype="date" style="left:155px; top:285px; width:100px; height:20px; background-color:#ffff99; "/>
  627. <input id="input1" ref="/root/searchData/TRANS_CAR_NO" style="left:350px; top:285px; width:120px; height:20px; background-color:#ffff99; "/>
  628. <input id="input3" ref="/root/searchData/SHIP_INVNO_CR" visibility="hidden" style="left:350px; top:260px; width:120px; height:20px; background-color:#ffff99; "/>
  629. <caption id="caption7" class="cell" visibility="hidden" style="left:265px; top:260px; width:85px; height:20px; font-weight:bold; border-color:#000000; ">冷轧移送货单</caption>
  630. <button id="button3" style="left:890px; top:285px; width:90px; height:20px; border-color:#000000; ">
  631. <caption>板加厂退回入库</caption>
  632. <script type="javascript" ev:event="DOMActivate">
  633. <![CDATA[
  634. SaveReturn();
  635. ]]>
  636. </script>
  637. </button>
  638. <button id="button4" style="left:810px; top:285px; width:80px; height:20px; border-color:#000000; ">
  639. <caption>热轧退回入库</caption>
  640. <script type="javascript" ev:event="DOMActivate">
  641. <![CDATA[
  642. SaveError();
  643. ]]>
  644. </script>
  645. </button>
  646. <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; "/>
  647. <caption id="caption11" class="cell" style="left:70px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">钢卷号</caption>
  648. <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; ">
  649. <choices>
  650. <item>
  651. <label>板加接收等待</label>
  652. <value>0</value>
  653. </item>
  654. <item>
  655. <label>板加接收</label>
  656. <value>1</value>
  657. </item>
  658. <item>
  659. <label>热轧退回卷重新入库</label>
  660. <value>2</value>
  661. </item>
  662. <item>
  663. <label>板加退回</label>
  664. <value>3</value>
  665. </item>
  666. <item>
  667. <label>冷轧接收等待</label>
  668. <value>4</value>
  669. </item>
  670. <item>
  671. <label>冷轧接收</label>
  672. <value>5</value>
  673. </item>
  674. <item>
  675. <label>冷轧退回</label>
  676. <value>6</value>
  677. </item>
  678. <item>
  679. <label>冷轧退回卷重新入库</label>
  680. <value>7</value>
  681. </item>
  682. <item>
  683. <label>板加退回卷重新入库</label>
  684. <value>8</value>
  685. </item>
  686. <item>
  687. <label/>
  688. <value/>
  689. </item>
  690. </choices>
  691. </select1>
  692. <caption id="caption12" class="cell" style="left:480px; top:285px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">移送状态</caption>
  693. <button id="button1" visibility="hidden" style="left:715px; top:285px; width:90px; height:20px; border-color:#000000; ">
  694. <caption>冷轧厂退回入库</caption>
  695. <script type="javascript" ev:event="DOMActivate">
  696. <![CDATA[
  697. SaveCRReturn();
  698. ]]>
  699. </script>
  700. </button>
  701. <caption id="caption13" class="cell" style="left:70px; top:260px; width:90px; height:20px; font-weight:bold; border-color:#000000; ">板加移送货单</caption>
  702. <input id="input4" ref="/root/searchData/SHIP_INVNO" style="left:155px; top:260px; width:100px; height:20px; background-color:#ffff99; "/>
  703. <caption id="caption14" class="cell" style="left:225px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">钢 码</caption>
  704. <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; "/>
  705. <caption id="caption15" class="cell" style="left:390px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">发货单位</caption>
  706. <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; "/>
  707. <button id="button2" style="left:885px; top:260px; width:95px; height:20px; background-color:#c0c0c0; ">
  708. <caption>打印</caption>
  709. <script type="javascript" ev:event="DOMActivate">
  710. <![CDATA[
  711. //这里发货明细的打印应该是同一客户同一运输指示号下的
  712. var nodeSet1 = datagrid2.nodeset;
  713. var SHIP_INVNO1 = null;
  714. //不同合同号的需要打印不同的明细
  715. var ORD_NO_TMP = null;
  716. //运输方式
  717. var DLIV_TP = null;
  718. //清空表格dg2
  719. model.removenode("/root/gridData2");
  720. model.makeNode("/root/gridData2");
  721. dg2.refresh();
  722. for(var i=1;i<=datagrid2.rows;i++){
  723. var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
  724. if(chk1 == "Y"){
  725. SHIP_INVNO1 = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
  726. DLIV_TP = model.getValue(nodeSet1+"["+i+"]/DLIV_TP");
  727. ORD_NO_TMP = model.getValue(nodeSet1+"["+i+"]/ORD_NO");
  728. break;
  729. }
  730. }
  731. //再次循环datagrid1,如果发现车厢号不同的就给出提示。并且打印不成功
  732. for(var i=1;i<=datagrid2.rows;i++){
  733. var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
  734. if(chk1 == "Y"){
  735. var SHIP_INVNO = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
  736. while(SHIP_INVNO1 != SHIP_INVNO){
  737. alert(" 不同运输指示号下的卷不能生成同一张发货明细,请确认后重新选择! ");
  738. return;
  739. }
  740. }
  741. }
  742. //取出第一个合同号
  743. var ORD_NO_TMP1 = null;
  744. //这里合同号不一样的,需要单独提示
  745. for(var i=1;i<=datagrid2.rows;i++){
  746. var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
  747. while(chk1 == "Y"){
  748. ORD_NO_TMP1 = model.getValue(nodeSet1+"["+i+"]/ORD_NO");
  749. break;
  750. }
  751. if(ORD_NO_TMP != ORD_NO_TMP1 && ORD_NO_TMP != null && ORD_NO_TMP1 !=null){
  752. alert(" 同运输指示号下的卷,合同号不一样需要分开打印发货明细! ");
  753. return;
  754. }
  755. }
  756. //送板加只有汽车的方式
  757. commAppendData ("/root/gridData2/ListResult_1_VO" ,"/root/EXCELHeadCAR/ListResult_1_VO" );
  758. //把表头数据放入后还需要放入主题数据
  759. //这里表头数据就占用了前8行,主体数据从第9行开始有一个加一个
  760. var num_row = 8;
  761. //这里通过运输方式来区分
  762. var DLIV_TP = null;
  763. //合同号
  764. var ORD_NO = null;
  765. //发货单号,对应表单的发货清单号
  766. var SHIP_INVNO = null;
  767. //运输指示号
  768. var DLIV_DIRNO = null;
  769. //用户编码,对应合同单位
  770. var CUST_NM = null;
  771. //用户编码,对应收货单位
  772. var ORD_NM = null;
  773. //到站
  774. var DEST_PCD_DESC = null;
  775. //制表,这里使用登录人
  776. var REG_ID = null;
  777. //车号
  778. var TRANS_CAR_NO = null;
  779. //收货单位,对应用户编码
  780. //产品名称
  781. var PRODNM_CD = null;
  782. //标准
  783. var SPEC_ABBSYM = null;
  784. //钢卷个数
  785. var coil_num_tmp = null;
  786. //钢卷重量
  787. var coil_wgt_tmp = null;
  788. //草支垫重量
  789. var CZD = null;
  790. //合同备注,新加入的
  791. var HCOLOUR_REM = null;
  792. for(var i=1;i<=datagrid2.rows;i++){
  793. var chk1 = model.getValue(nodeSet1+"["+i+"]/CHK");
  794. if(chk1 == "Y"){
  795. ///alert("num_row : "+num_row);
  796. coil_num_tmp = coil_num_tmp +1;
  797. ///alert("coil_num_tmp : "+coil_num_tmp);
  798. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col1");
  799. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col2");
  800. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col3");
  801. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col4");
  802. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col5");
  803. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col6");
  804. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col7");
  805. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col8");
  806. //轧批号//钢卷号,真实钢卷号
  807. var COIL_NO = model.getValue(nodeSet1+"["+i+"]/OLD_SAMPL_NO");
  808. //钢号
  809. var SPEC_STL_GRD = model.getValue(nodeSet1+"["+i+"]/SPEC_STL_GRD");
  810. //规格,没有
  811. var T_W = model.getValue(nodeSet1+"["+i+"]/INSTR_COIL_THK")+"*"+model.getValue(nodeSet1+"["+i+"]/INSTR_COIL_WTH");
  812. //重量(吨)
  813. var COIL_WGT = model.getValue(nodeSet1+"["+i+"]/ACT_WGT");
  814. //等级,这里使用表述字段
  815. var TOT_DEC_GRD = model.getValue(nodeSet1+"["+i+"]/TOT_DEC_GRD_DESC");
  816. //性能 MATLQLTY_DEC_GRD。这里使用表述字段
  817. var MATLQLTY_DEC_GRD = model.getValue(nodeSet1+"["+i+"]/MATLQLTY_DEC_GRD_DESC");
  818. //备注
  819. //这里循环获取表格主体数据
  820. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col1",COIL_NO.substr(0,10));
  821. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col2",SPEC_STL_GRD);
  822. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col3",T_W);
  823. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col4",(COIL_WGT/1000));
  824. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col5",COIL_NO);
  825. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col6",TOT_DEC_GRD);
  826. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col7",MATLQLTY_DEC_GRD);
  827. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+num_row+"]/col8","");
  828. //这里获取表头数据
  829. //这里把需要的值放入特定的位置,写死并且需要区分火运和汽运的情况。
  830. //这里通过运输方式来区分
  831. //DLIV_TP = model.getValue(nodeSet1+"["+i+"]/DLIV_TP");
  832. //合同号
  833. ORD_NO = model.getValue(nodeSet1+"["+i+"]/ORD_NO");
  834. //发货单号,对应表单的发货清单号
  835. SHIP_INVNO = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
  836. //运输指示号
  837. DLIV_DIRNO = model.getValue(nodeSet1+"["+i+"]/SHIP_INVNO");
  838. //用户编码,对应客户公司
  839. CUST_NM = model.getValue(nodeSet1+"["+i+"]/CUST_CD_DESC");
  840. ORD_NM = model.getValue(nodeSet1+"["+i+"]/ORDCUST_CD_DESC");
  841. //发货日,这里取出库时间
  842. var SYS_TIME = model.getValue(nodeSet1+"["+i+"]/ENTRY_DTIME");
  843. //编号,这里新钢有自己的编号规则。所以先空着确认后再处理
  844. //计划单号,这里新钢没有填入。暂时空着
  845. //到站
  846. DEST_PCD_DESC = model.getValue(nodeSet1+"["+i+"]/DEST_PCD_DESC");
  847. //制表,这里使用出库人
  848. REG_ID = model.getValue(nodeSet1+"["+i+"]/ENTRY_REG");
  849. //计划单号
  850. //车号
  851. TRANS_CAR_NO = model.getValue(nodeSet1+"["+i+"]/TRANS_CAR_NO");
  852. //收货单位
  853. //发货备注,这里为空
  854. //产品名称
  855. PRODNM_CD = model.getValue(nodeSet1+"["+i+"]/PRODNM_CD");
  856. //标准
  857. SPEC_ABBSYM = model.getValue(nodeSet1+"["+i+"]/SPEC_ABBSYM");
  858. //钢卷重量累加
  859. coil_wgt_tmp = Number(COIL_WGT) + Number(coil_wgt_tmp);
  860. //草支垫重量
  861. //CZD = model.getValue("/root/CZD");
  862. //外贸合同颜色备注栏
  863. //HCOLOUR_REM = model.getValue(nodeSet1+"["+i+"]/HCOLOUR_REM");
  864. //alert("coil_wgt_tmp : "+coil_wgt_tmp);
  865. //先赋值再增加行
  866. num_row = num_row+1;
  867. }
  868. }
  869. //alert("dg2.rows : "+dg2.rows);
  870. //这里能不能在添加几个空行,以便后面合计使用
  871. for(var j=dg2.rows;j<=20;j++){
  872. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col1");
  873. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col2");
  874. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col3");
  875. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col4");
  876. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col5");
  877. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col6");
  878. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col7");
  879. model.makeNode("/root/gridData2/ListResult_1_VO/ListResult_1_Row["+j+"]/col8");
  880. }
  881. //汽运的情况
  882. //合同号和发货单号,第二行
  883. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[2]/col2","'"+ORD_NO);
  884. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[2]/col5",DLIV_DIRNO);
  885. //第三行,用户编码
  886. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[3]/col2","");
  887. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[3]/col5",SYS_TIME);
  888. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[3]/col6","第"+SHIP_INVNO+"号");
  889. //第四行,用户名称
  890. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[4]/col2",CUST_NM);
  891. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[4]/col5",DEST_PCD_DESC.substr(0,9));
  892. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[4]/col7",REG_ID);
  893. //第五行,计划单号
  894. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[5]/col2","");
  895. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[5]/col5",TRANS_CAR_NO);
  896. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[5]/col7",ORD_NM);
  897. //第六行,发货备注
  898. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[6]/col2","");
  899. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[6]/col5",PRODNM_CD);
  900. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[6]/col7",SPEC_ABBSYM);
  901. //第20行,总计
  902. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col1","小计");
  903. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col3",coil_num_tmp+"卷");
  904. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col4",Number(coil_wgt_tmp/1000));
  905. model.setValue("/root/gridData2/ListResult_1_VO/ListResult_1_Row[20]/col8","");
  906. model.refresh();
  907. //导出EXCEL方法
  908. saveExcelScript(dg2, "Sheet1");
  909. find();
  910. ]]>
  911. </script>
  912. <hint>
  913. <![CDATA[打印的发货明细请保存在C盘]]>
  914. </hint>
  915. </button>
  916. <object id="ObjTFExcel" clsid="{fe8d1001-6a9d-424d-ae2a-301493bb12da}" style="left:715px; top:260px; width:155px; height:25px; "/>
  917. <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; ">
  918. <col ref="col1"/>
  919. <col ref="col2"/>
  920. <col ref="col3"/>
  921. <col ref="col4"/>
  922. <col ref="col5"/>
  923. <col ref="col6"/>
  924. <col ref="col7"/>
  925. <col ref="col8"/>
  926. </datagrid>
  927. <caption id="caption16" class="cell" style="left:225px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">移送时间</caption>
  928. <caption id="caption17" class="cell" style="left:70px; top:25px; width:60px; height:20px; font-weight:bold; vertical-align:middle; border-color:#000000; ">移送人</caption>
  929. <select1 id="combo7" ref="/root/searchData/ENTRY_REG" appearance="minimal" editmode="input" style="left:130px; top:25px; width:90px; height:20px; background-color:#ffff99; ">
  930. <choices>
  931. <item>
  932. <label>刘文</label>
  933. <value>刘文</value>
  934. </item>
  935. <item>
  936. <label>蔡伟平</label>
  937. <value>蔡伟平</value>
  938. </item>
  939. <item>
  940. <label>廖林敏</label>
  941. <value>廖林敏</value>
  942. </item>
  943. <item>
  944. <label>李斌</label>
  945. <value>李斌</value>
  946. </item>
  947. <item>
  948. <label>吴贤峰</label>
  949. <value>吴贤峰</value>
  950. </item>
  951. <item>
  952. <label>敖艳敏</label>
  953. <value>敖艳敏</value>
  954. </item>
  955. <item>
  956. <label>林珑</label>
  957. <value>林珑</value>
  958. </item>
  959. <item>
  960. <label>成武</label>
  961. <value>成武</value>
  962. </item>
  963. <item>
  964. <label>安凡能</label>
  965. <value>安凡能</value>
  966. </item>
  967. <item>
  968. <label>陈小勇</label>
  969. <value>陈小勇</value>
  970. </item>
  971. <item>
  972. <label>刘忠华</label>
  973. <value>刘忠华</value>
  974. </item>
  975. </choices>
  976. </select1>
  977. <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; "/>
  978. <caption id="caption18" class="cell" style="left:575px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">合同号</caption>
  979. <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; "/>
  980. </xhtml:body>
  981. </xhtml:html>