scripts/miniui/themes/blue/skin.css" rel="stylesheet" type="text/css" /> c_miniui 列合计">
devbox
笔触狂放9
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

miniui合计一列与编辑备忘_miniui 列合计

作者：笔触狂放9 | 2024-03-01 05:02:48

赞

踩

miniui 列合计
供自己看；
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Frm_ProductDayReport.aspx.cs" Inherits="VegooPM.report.product.Frm_ProductDayReport" %>
  2.  
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4.  
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head id="Head1" runat="server">
  7.     <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
  8.     <meta name="renderer" content="webkit|ie-comp|ie-stand" />
  9.     <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
  10.     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  11.     <title></title>
  12.     <link href="<%=this.ResolveUrl("~") %>scripts/miniui/themes/default/miniui.css" rel="stylesheet" type="text/css" />
  13.     <link href="<%=this.ResolveUrl("~") %>scripts/miniui/themes/blue/skin.css" rel="stylesheet" type="text/css" />
  14.     <link href="<%=this.ResolveUrl("~") %>css/main.css" rel="stylesheet" type="text/css" />
  15.     <script src="<%=this.ResolveUrl("~") %>scripts/jquery/jquery-1.6.2.min.js" type="text/javascript"></script>
  16.     <script src="<%=this.ResolveUrl("~") %>scripts/miniui/miniui.js" type="text/javascript"></script>
  17.     <script src="<%=this.ResolveUrl("~") %>scripts/js/HDB.js" type="text/javascript"></script>
  18. </head>
  19. <body>
  20.      <div class="mini-splitter" style="width:100%;height:100%;"  borderStyle="border-left:0;border-right:0; border-bottom:0;">
  21.     <div size="180" maxsize="250" minsize="100" showcollapsebutton="true" borderStyle="border:0;" style=" width :200px; height :100%; background:#fff;  float :left;  height:23px;">
  22.     
  23.         <div class="mini-toolbar" style="border-right: 0;border-left: 0;border-top: 0; padding: 0px; height:23px; text-align:left; padding-left:10px; padding-top:3px; ">
  24.             <span style="font-size:13px;"> 
  25.             <input name="treeFactory" id="treeFactory" class="mini-treeselect"  onbeforenodeselect="beforenodeselect"
  26.                 textField="Text" valueField="ID" parentField="Pid" showTreeIcon="false" showFolderCheckBox="false" style="width:100%" ondrawnode="onDrawNode"
  27.                iconfield="Icon" expandOnLoad="true" onvaluechanged="onMillTreeChanged"  url="<%=this.ResolveUrl("~") %>data/product/productServer.aspx?method=getFactoryNameList"  />
  28.           </span>
  29.         </div>
  30.              <ul id="treeMill" name="treeMill" class="mini-tree" style="width: 100%; height: 100%; padding: 0px;"
  31.                 showtreeicon="true" textfield="Text" onnodeselect="onNodeSelect" valuefield="ID" parentfield="Pid" expandοnlοad="true" resultastree="true" iconField="Icon">
  32.             </ul>
  33.     </div>
  34.      <div borderStyle="border-left:0;border-right:0; border-bottom:0;">
  35.         <div id="toolBarBox" class="toolBarBox" style="border-top:0;">
  36.             <div id="ToolBar" class="ToolBar" style="border-top:0;">
  37.                 <ul class="mini-toolbar" style="border-top:0;">
  38.                     <li class="toolbar-searchbtn">
  39.                         <span>主机：</span>
  40.                         <input name="MainMachine" id="MainMachine" class="mini-combobox"
  41.                          style="width:140px;" allowinput="false"/>
  42.                         <span>日期：</span>
  43.                             <input id="InsertDate" class="mini-monthpicker" showOkButton="false" allowinput="false"/>
  44.                         <a class="mini-button"  plain="true" iconCls="icon-403" οnclick="search()">查询</a>                        
  45.                     </li>
  46.                 </ul>   
  47.             </div>
  48.         </div>
  49.     <div class="mini-fit" style=" border:0;">
  50.         <div id="center" style="width: 100%;height:100%; border: 0px solid;">
  51.             <div id="datagrid1" class="mini-datagrid" style="width:100%;height:100%;" allowresize="false"showpager="false"allowHeaderWrap="true"allowCellWrap="true"
  52.                 url="<%=this.ResolveUrl("~") %>data/product/productServer.aspx?method=getRunMachineGrid" οnlοad="onLoad">
  53.                     <div property="columns">
  54.                     <div field="InsertTime" renderer="onBirthdayRenderer" headerAlign="center" width="40" align="center">日期</div>
  55.                     <div field="OverallTime" headerAlign="center" width="40" align="center">总时间(h)</div>
  56.                     <div field="RunTime" headerAlign="center" width="40" dataType="float" align="center">运行时间(h)</div>
  57.                     
  58.                     <div headerAlign="center">计划停机
  59.                         <div property="columns">
  60.                         <div field="bHours" headerAlign="center" width="40" dataType="float" align="center">停机时间(h)</div>
  61.                         <div field="TimeSlot" headerAlign="center" width="80" align="center">停机时段</div>
  62.                         <div field="Remark" headerAlign="center" width="130">停机原因</div>
  63.                         <div field="ND" headerAlign="center" width="40" align="center">停机次数</div>
  64.                         </div>
  65.                     </div>
  66.                     <div field="CTOR" headerAlign="center" align="center" width="40" renderer="onRenderer">综合运转率(%)</div>
  67.                     <div field="CR" headerAlign="center" align="center" width="40" renderer="onRenderer">综合可靠性(%)</div>
  68.                     <div headerAlign="center">停机分类
  69.                         <div property="columns">
  70.                             <div headerAlign="center">计划停机
  71.                                 <div property="columns">
  72.                                     <div field="jhxtj" headerAlign="center" width="40" align="center" dataType="float">计划性停机</div>
  73.                                     <div field="bfdtj" headerAlign="center" width="40" align="center" dataType="float">避峰电停机</div>
  74.                                     <div field="xcxtj" headerAlign="center" width="40" align="center" dataType="float">限产性停机</div>
  75.                                     <div field="jhtjcs" headerAlign="center" width="40" align="center" dataType="float">停机次数</div>
  76.                                 </div>
  77.                             </div>
  78.                             <div headerAlign="center">故障停机
  79.                                 <div property="columns">
  80.                                     <div headerAlign="center">工艺
  81.                                         <div property="columns">
  82.                                             <div field="gysbgztj" headerAlign="center" width="40" align="center" dataType="float">工艺设备故障停机</div>
  83.                                             <div field="wldltj" headerAlign="center" width="40" align="center" dataType="float">物料堵料停机</div>
  84.                                             <div field="gytjcs" headerAlign="center" width="40" align="center" dataType="float">停机次数</div>
  85.                                             <div field="PR" headerAlign="center" align="center" width="40"  renderer="onRenderer">可靠性(%)</div>
  86.                                         </div>
  87.                                     </div>
  88.                                     <div headerAlign="center">电器
  89.                                         <div property="columns">
  90.                                             <div field="dqsbgztj" headerAlign="center" align="center" width="40" dataType="float">电器设备故障停机(h)</div>
  91.                                             <div field="dqcs" headerAlign="center" align="center" width="40" dataType="float">停机次数</div>
  92.                                             <div field="ROEA" headerAlign="center" align="center" width="40" renderer="onRenderer">可靠性(%)</div>
  93.                                         </div>
  94.                                     </div>
  95.                                     <div headerAlign="center">设备
  96.                                         <div property="columns">
  97.                                             <div field="jxsbgz" headerAlign="center" align="center" width="40" dataType="float">机械设备故障(h)</div>
  98.                                             <div field="sbtj" headerAlign="center" align="center" width="40" dataType="float">停机次数</div>
  99.                                             <div field="TROTE" headerAlign="center" align="center" width="40" renderer="onRenderer">可靠性(%)</div>
  100.                                         </div>
  101.                                     </div>
  102.                                     <div headerAlign="center">非本系统原因的停机
  103.                                         <div property="columns">
  104.                                             <div field="fbtjsj" headerAlign="center" align="center" width="40" dataType="float">停机时间</div>
  105.                                             <div field="fbxtyytj" headerAlign="center" align="center" width="40" dataType="float">停机次数</div>
  106.                                             <div field="TNSR" headerAlign="center" align="center" width="40" renderer="onRenderer">可靠性(%)</div>
  107.                                         </div>
  108.                                     </div>
  109.                                     <div headerAlign="center">不可控停机
  110.                                         <div property="columns">
  111.                                             <div field="bkktjsj" headerAlign="center" align="center" width="40" dataType="float">停机时间（h)</div>
  112.                                             <div field="bkktj" headerAlign="center" align="center" width="40" dataType="float">停机次数</div>
  113.                                         </div>
  114.                                     </div>
  115.                                 </div>
  116.                             </div>
  117.                         </div>
  118.                     </div>
  119.                 </div>
  120.             </div>
  121.         </div>
  122.     </div>
  123.     </div>
  124.     </div>
  125.      
  126.  
  127.     <script type="text/javascript">
  128.         mini.parse();
  129.         var path = '<%=this.ResolveUrl("~") %>';
  130.         var grid = mini.get("datagrid1");
  131.         var treeselect = mini.get("treeFactory");
  132.         var tree = mini.get("treeMill");
  133.         $(function () {
  134.             mini.get("InsertDate").setValue(new Date());
  135.         });
  136.         var moren = 1;
  137.         var morenText;
  138.         function onDrawNode(e) {
  139.             if (e.isLeaf != false && moren == 1) {
  140.                 morenText = e.node; moren = 0;
  141.                 treeselect.setValue(morenText.ID);
  142.                 onMillTreeChanged(morenText);
  143.                 tree.selectNode(tree.getRootNode());
  144.             }
  145.         }
  146.         //禁止选中父节点
  147.         function beforenodeselect(e) {
  148.             if (e.isLeaf == false) e.cancel = true;
  149.         }
  150.  
  151.         //加载系统树
  152.         function onMillTreeChanged(e) {
  153.             var node = treeselect.getSelectedNode();
  154.             var data = { FactoryCode: node.ID };
  155.             var url = path + 'data/product/productServer.aspx?method=getMillTreeList&submitData=' + JSON.stringify(data);
  156.             tree.load(url);
  157.         }
  158.  
  159.         //点击节点的时候获取主机
  160.         function onNodeSelect(e) {
  161.             $.ajax({
  162.                 url: path + "data/product/productServer.aspx?method=getDMainMachineGrid",
  163.                 type: 'post',
  164.                 data: { submitData: tree.getSelectedNode().ID },
  165.                 success: function (text) {
  166.                     var datas;
  167.                     if (text.length > 10) {
  168.                         datas = mini.decode(text);
  169.                     } else {
  170.                         return;
  171.                     }
  172.                     mini.get("MainMachine").setData(null);
  173.                     if (datas.data.length > 0) {
  174.                         mini.get("MainMachine").setData(datas.data);
  175.                     } else {
  176.                         grid.setData("");
  177.                         return;
  178.                     }
  179.                     mini.get("MainMachine").setValue(datas.data[0].id);
  180.                     loadData();
  181.                 },
  182.                 error: function (jqXHR, textStatus, errorThrown) {
  183.                     alert(jqXHR.responseText);
  184.                     CloseWindow();
  185.                 }
  186.             });
  187.         }
  188.         //系统树传值
  189.         function loadData() {
  190.             var node = tree.getSelectedNode(); //系统树
  191.             var node1 = treeselect.getSelectedNode(); //工厂树
  192.             if (node != null && node != undefined) {
  193.                 if (node._id == -1) {
  194.                     return;
  195.                 }
  196.             } else {
  197.                 return;
  198.             }
  199.             if (mini.get("InsertDate").getValue() == null || mini.get("InsertDate").getValue() == "") {
  200.                 return;
  201.             }
  202.             if (mini.get("MainMachine").getValue() == null || mini.get("MainMachine").getValue() == "") {
  203.                 return;
  204.             }
  205.             var data = mini.encode({ MillCode: node.ID, FactoryCode: node1.ID,InsertDate: mini.get("InsertDate").getValue(), MainMachine: mini.get("MainMachine").getValue() });
  206.             grid.load({ submitData: data });
  207.         }
  208.         function search() {
  209.             var node = tree.getSelectedNode(); //系统树
  210.             var node1 = treeselect.getSelectedNode(); //工厂树
  211.             if (node != null && node != undefined) {
  212.                 if (node._id == -1) {
  213.                     mini.alert("请选择左侧菜单目录！");
  214.                     return;
  215.                 }
  216.             } else {
  217.                 mini.alert("请选择左侧菜单目录！");
  218.                 return;
  219.             }
  220.             if (mini.get("InsertDate").getValue() == null || mini.get("InsertDate").getValue() == "") {
  221.                 mini.alert("请选择日期！");
  222.                 return;
  223.             }
  224.             if (mini.get("MainMachine").getValue() == null || mini.get("MainMachine").getValue() == "") {
  225.                 mini.alert("请选择主机！");
  226.                 return;
  227.             }
  228.             var data = mini.encode({ MillCode: node.ID, FactoryCode: node1.ID, InsertDate: mini.get("InsertDate").getValue(), MainMachine: mini.get("MainMachine").getValue() });
  229.             grid.load({ submitData: data });
  230.         }
  231.         function onBirthdayRenderer(e) {
  232.             if (e.value != "合计") {
  233.                 var value = new Date(e.value);
  234.                 if (value) return mini.formatDate(value, 'dd');
  235.             }
  236.             else {
  237.                 return e.value;
  238.             }
  239.         }
  240.         function onRenderer(e) {
  241.             return toDecimal(e.value);
  242.         }
  243.         function onLoad(e) {
  244.             var index = grid.getData().length;
  245.             var row = { "InsertTime": "合计",
  246.                 "OverallTime": "",
  247.                 "RunTime": "",
  248.                 "bHours": 0,
  249.                 "TimeSlot": "",
  250.                 "Remark": "",
  251.                 "ND": "",
  252.                 "CTOR": "",
  253.                 "CR": "",
  254.                 "jhxtj": "",
  255.                 "bfdtj": "",
  256.                 "xcxtj": "",
  257.                 "jhtjcs": "",
  258.                 "gysbgztj": "",
  259.                 "wldltj": "",
  260.                 "gytjcs": "",
  261.                 "PR": "",
  262.                 "dqsbgztj": "",
  263.                 "dqcs": "", "ROEA": "",
  264.                 "jxsbgz": "", "sbtj": "",
  265.                 "TROTE": "",
  266.                 "fbtjsj": "",
  267.                 "fbxtyytj": "",
  268.                 "TNSR": "",
  269.                 "bkktjsj": "",
  270.                 "bkktj": ""
  271.             };
  272.             grid.addRow(row, index);
  273.             var grids = e.sender;
  274.             var s1 = 0; //存储号
  275.             var a1 = 0; //rowIndex
  276.             var a2 = 0; //rowSpan
  277.             var b = ""; //分组区分值
  278.             var qq = "";
  279.             var OverallTime = 0; var RunTime = 0;
  280.             var bHours = 0; var ND = 0;
  281.             var jhxtj = 0; var bfdtj = 0;
  282.             var xcxtj = 0; var jhtjcs = 0;
  283.             var gysbgztj = 0; var wldltj = 0;
  284.             var gytjcs = 0; 
  285.             var dqsbgztj = 0; var dqcs = 0;
  286.             var jxsbgz = 0;
  287.             var sbtj = 0;
  288.             var fbtjsj = 0; var fbxtyytj = 0;
  289.             var bkktjsj = 0; var bkktj = 0;
  290.             for (var i = 0; i < grids.data.length; i++) {
  291.                 OverallTime = OverallTime + grids.data[i].OverallTime;
  292.                 RunTime = RunTime + grids.data[i].RunTime;
  293.                 bHours = bHours + (grids.data[i].bHours =="" ? 0 : parseFloat(grids.data[i].bHours));
  294.                 ND = ND + (grids.data[i].ND =="" ? 0 : parseFloat(grids.data[i].ND));
  295.                 jhxtj = jhxtj +( grids.data[i].jhxtj =="" ? 0 : parseFloat(grids.data[i].jhxtj));
  296.                 bfdtj = bfdtj +( grids.data[i].bfdtj =="" ? 0 : parseFloat(grids.data[i].bfdtj));
  297.                 xcxtj = xcxtj +( grids.data[i].xcxtj =="" ? 0 : parseFloat(grids.data[i].xcxtj));
  298.                 jhtjcs = jhtjcs +( grids.data[i].jhtjcs =="" ? 0 : parseFloat(grids.data[i].jhtjcs));
  299.                 gysbgztj = gysbgztj +( grids.data[i].gysbgztj =="" ? 0 : parseFloat(grids.data[i].gysbgztj));
  300.                 wldltj = wldltj +( grids.data[i].wldltj =="" ? 0 : parseFloat(grids.data[i].wldltj));
  301.                 gytjcs = gytjcs +( grids.data[i].gytjcs =="" ? 0 : parseFloat(grids.data[i].gytjcs));
  302.                 dqsbgztj = dqsbgztj +( grids.data[i].dqsbgztj =="" ? 0 : parseFloat(grids.data[i].dqsbgztj));
  303.                 dqcs = dqcs +( grids.data[i].dqcs =="" ? 0 : parseFloat(grids.data[i].dqcs));
  304.                 jxsbgz = jxsbgz +( grids.data[i].jxsbgz =="" ? 0 : parseFloat(grids.data[i].jxsbgz));
  305.                 sbtj = sbtj +( grids.data[i].sbtj =="" ? 0 : parseFloat(grids.data[i].sbtj));
  306.                 fbtjsj = fbtjsj +( grids.data[i].fbtjsj =="" ? 0 : parseFloat(grids.data[i].fbtjsj));
  307.                 fbxtyytj = fbxtyytj +( grids.data[i].fbxtyytj =="" ? 0 : parseFloat(grids.data[i].fbxtyytj));
  308.                 bkktjsj = bkktjsj +( grids.data[i].bkktjsj =="" ? 0 : parseFloat(grids.data[i].bkktjsj));
  309.                 bkktj = bkktj +( grids.data[i].bkktj =="" ? 0 : parseFloat(grids.data[i].bkktj));
  310.                 if (grids.data.length == i) {
  311.                     a2 += 1;
  312.                     qq += "{ rowIndex: " + a1 + ", columnIndex: 0, rowSpan: " + a2 + ", colSpan: 1 },";
  313.                     qq += "{ rowIndex: " + a1 + ", columnIndex: 1, rowSpan: " + a2 + ", colSpan: 1 },";
  314.                     qq += "{ rowIndex: " + a1 + ", columnIndex: 2, rowSpan: " + a2 + ", colSpan: 1 },";
  315.                 } else {
  316.                     if (grids.data[i].InsertTime != b) {
  317.                         if (i == 0) {
  318.                             b = grids.data[i].InsertTime;
  319.                             a2 += 1;
  320.                         } else {
  321.                             s1 = i - 1;
  322.                             qq += "{ rowIndex: " + a1 + ", columnIndex: 0, rowSpan: " + a2 + ", colSpan: 1 },"
  323.                             qq += "{ rowIndex: " + a1 + ", columnIndex: 1, rowSpan: " + a2 + ", colSpan: 1 },";
  324.                             qq += "{ rowIndex: " + a1 + ", columnIndex: 2, rowSpan: " + a2 + ", colSpan: 1 },";
  325.                             a1 = s1 + 1
  326.                             a2 = 1;
  327.                             b = grids.data[i].InsertTime;
  328.                         }
  329.                     }
  330.                     else {
  331.                         OverallTime = OverallTime - grids.data[i].OverallTime;
  332.                         RunTime = RunTime - grids.data[i].RunTime;
  333.                         bHours = bHours - (grids.data[i].bHours == "" ? 0 : parseFloat(grids.data[i].bHours));
  334.                         a2 += 1;
  335.                     }
  336.                 }
  337.             }
  338.             marges = eval("[" + qq + "]");
  339.             grid.margeCells(marges); 
  340.             grid.updateRow(row, { "OverallTime": OverallTime,
  341.                 "RunTime": RunTime,
  342.                 "bHours": bHours,
  343.                 "ND": ND,
  344.                 "jhxtj": jhxtj,
  345.                 "bfdtj": bfdtj,
  346.                 "xcxtj": xcxtj,
  347.                 "jhtjcs": jhtjcs,
  348.                 "gysbgztj": gysbgztj,
  349.                 "wldltj": wldltj,
  350.                 "gytjcs": gytjcs,
  351.                 "dqsbgztj": dqsbgztj,
  352.                 "jxsbgz": jxsbgz, "sbtj": sbtj,
  353.                 "fbtjsj": fbtjsj,
  354.                 "fbxtyytj": fbxtyytj,
  355.                 "bkktjsj": bkktjsj,
  356.                 "bkktj": bkktj
  357.             });
  358.         }
  359. </script>
  360. </body>
  361. </html>

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/笔触狂放9/article/detail/171155
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号