DK-MES-2.0
/
HEGII.ss.mes.web


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310
							<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta name="keywords" content="dongke,mes,ibossmes">
    <meta name="description" content="制造企业生产过程执行管理系统">
    <meta name="author" content="xuwei">
    <title>东科软件</title>
    <script src="/plugins/xeasyui/xeasyui.min.js"></script>
    <link href="/plugins/xeasyui/toolbar.min.css" rel="stylesheet" />
</head>
<body class="easyui-layout">

    <!--上部工具条-->
    <div id="toolbarLayout" data-options="border:false,region:'north',title:'',iconCls:'icon-grid'">
        <div class="i-toolbar">
            <a href="javascript:void(0)" id="btnSearch" title="搜索" class="easyui-linkbutton" iconcls="icon-search" plain="true" toggle="true" onclick="tbSearch()">搜索</a>
            <a href="javascript:void(0)" id="btnExport" title="导出" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbExport()">导出</a>
            <!--<a href="javascript:void(0)" id="btnColumn" class="easyui-menubutton" data-options="menu:'#btnColumnMenu',iconCls:'icon-undo'">列显示</a>-->
            <!--<div id="btnColumnMenu" style="width:150px;" ></div>-->
            <a href="javascript:void(0)" id="btnReload" title="刷新" class="easyui-linkbutton" iconcls="icon-reload" plain="true" onclick="tbReload()">刷新</a>

            <a href="javascript:void(0)" id="btnHelp" title="帮助" class="easyui-linkbutton" iconcls="icon-help" plain="true" onclick="tbHelp()">帮助</a>

            <div id="tbSearchDiv" style="display:block;padding:10px;">
                <form id="ffMaster">
                    <div>   
                        开始日期：
                        <input class="easyui-datebox" id="datebeginMaster" name="datebeginMaster" data-options="required:true,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
                        截止日期：
                        <input class="easyui-datebox" id="dateendMaster" name="dateendMaster" data-options="required:true,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
                        高压标识：
                        <input class="easyui-combobox" id="highFlagMaster" name="highFlagMaster" data-options="required:false,valueField:'value',textField:'text',
                               data:[{'text': '普通', 'value': '0'}, {'text': '高压', 'value': '1'}]" style=" width: 120px; height: 32px;">
                        统计方式：
                        <input class="easyui-combobox" id="totalMaster" name="totalMaster" data-options="required:true,value:'YYYYMMDD',valueField:'value',textField:'text',
                               data:[{'text': '按月统计', 'value': 'YYYYMM'}, {'text': '按日统计', 'value': 'YYYYMMDD'}]" style=" width: 120px; height: 32px;">
                    </div>
                    <div style="padding-top:10px;">
                        产品编码：
                        <input class="easyui-combobox" id="goodsMaster" name="goodsMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getGoods&select=1',method:'get',valueField:'GOODSID',textField:'GOODSCODE',panelHeight:'300px',editable:true,multiple:true" style="width:325px;height:32px;">
                        成型线号：
                        <input class="easyui-combobox" id="groutinglineMaster" name="groutinglineMaster" data-options="required:false,prompt:'',tipPosition:'top',url:'../../rpt/rpt.ashx?m=getLine&select=1',method:'get',valueField:'GROUTINGLINEID',textField:'GROUTINGLINECODE',panelHeight:'300px',editable:true,multiple:true" style="width: 322px; height: 32px;">
                        试验：
                        <input class="easyui-combobox" id="testMaster" name="testMaster" data-options="required:false,valueField:'value',textField:'text',editable:false,value:'-1',
                               data:[{'text': '正常', 'value': '0'}, {'text': '试验', 'value': '1'}, {'text': '全部', 'value': '-1'}]" style=" width: 120px; height: 32px;">
                        试验线：
                        <input class="easyui-combobox" id="testFlagMaster" name="testFlagMaster" data-options="required:false,valueField:'value',textField:'text',editable:false,value:'-1',
                               data:[{'text': '普通线', 'value': '0'}, {'text': '试验线', 'value': '1'}, {'text': '全部', 'value': '-1'}]" style=" width: 120px; height: 32px;">
                        <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="tbSearchReset()">清空</a>
                        <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
                        差异标识
                        <input class="easyui-checkbox" id="chkStar" name="chkStar" data-options="onChange:createChange" checked>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <!--中部-->
    <div data-options="region:'center',title:'',split:true" style="width:30%; height: 100%">

        <div id="tableTabs" class="easyui-tabs" data-options="border:false,region:'east',split:true" style="width:100%; height: 100%">
            <div title="生产数据统计">
                <table class="easyui-datagrid"
                       id="DataGrid0"
                       data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
                    <thead>
                    </thead>
                </table>
            </div>
            <div title="差异明细表">
                <table class="easyui-datagrid"
                       id="DataGrid01"
                       data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
                    <thead>
                    </thead>
                </table>
            </div>
        </div>
    </div>
    <!--表格右面-->
    <div data-options="region:'west',title:''" style="width:20%; height: 100%" id="cydiv">
        <div id="tableTabs1" class="easyui-tabs" data-options="border:false,region:'center'" style="width:100%; height: 100%">
            <div title="差异">
                <table class="easyui-datagrid"
                       id="difference1"
                       data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true,onDblClickRow: dgDblclickrow">
                    <thead>
                    </thead>
                </table>
            </div>
        </div>
    </div>

    <script type="text/javascript">
        var checke = false;
        function formatterUA(value, row, index) {
            return Math.round(value * 10000) / 100 + '%';
        }

        $(document).ready(function () {
            createChange();
            var ctime = new Date();
            var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
            var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
            $("#datebeginMaster").datebox("setValue", beginDate);
            $("#dateendMaster").datebox("setValue", endDate);

            //tbSearchSubmit();
        });

        //帮助事件
        function tbHelp() {
            $('#DataGrid0').datagridDialog({
                title: '帮助',
                width: 640,
                height: 480,
                url: 'rpt_help.html'
            });
        }

        //主表双击事件
        function dgDblclickrow(index, row) {
            $("#tableTabs").tabs("select", 1);
            LoadDataGridDetail(index, row);
        }

        //加载子表数据
        function LoadDataGridDetail(index, row) {
            //加载子表1
            var a = row["差异量"];
            var shorname = a.replace(/[^\u4e00-\u9fa5]/gi, "");

            var WORKSHOP = 0
            if (index < 14)
            {
                WORKSHOP = 1
            }
            else if (index < 27)
            {
                WORKSHOP = 2
            }
            else
            {
                WORKSHOP = 3
            }

            if ($('#ffMaster').form("validate")) {
                $('#DataGrid01').datagridLoad({
                    idField: '差异明细条码',
                    queryParams: $('#ffMaster').serializeJson(),
                    url: 'rpt.ashx?m=1&shorname=' + shorname + '&WORKSHOP=' + WORKSHOP,
                    pageSize: 10,
                    fixWidth: 100,
                    mergeWidth: 80,
                    splitChar: '_'
                });
            }
        }

        function stylerEditor(value, row, index) {
                return 'background-color:yellow;color:black';
        }

        //清空条件
        function tbSearchReset() {
            $('#highFlagMaster').combobox('clear');
            $('#goodsMaster').combobox('clear');
            $('#groutinglineMaster').combobox('clear');
            $('#testMaster').combobox('clear');
            $('#testFlagMaster').combobox('clear');
        }

        function createChange(checked) {

            if (checked == true)
            {
                checked = false
            }
            else if (checked == undefined)
            {
                checked = false
            }
            else
            {
                checked = true
            }
            $('#goodsMaster').setDateboxDisable(checked);
            $('#groutinglineMaster').setDateboxDisable(checked);
            $('#testMaster').setDateboxDisable(checked);
            $('#testFlagMaster').setDateboxDisable(checked);
            $('#totalMaster').setDateboxDisable(checked);
            $('#highFlagMaster').setDateboxDisable(checked);
            checke = checked;
        }

        //搜索提交
        function tbSearchSubmit() {
            var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));

            if (index == 0) {
                if ($('#ffMaster').form("validate")) {
                    $('#DataGrid' + index).datagridLoadRpt({
                        title: '',
                        idField: 'SID',
                        queryParams: $('#ffMaster').serializeJson(),
                        url: 'rpt.ashx?m=' + index + '&id=' + request('id') + '&checke=' + checke,
                        pageSize: 10,
                        fixWidth: 120,
                        mergeWidth: 120,
                        splitChar: '_',
                        onLoadSuccess: function (data) {
                            $('#DataGrid' + index).datagrid("autoMergeCells", ["部门"]);
                        }
                    });
                }
                $('#difference1').datagridLoadRpt({
                    idField: '差异',
                    queryParams: $('#ffMaster').serializeJson(),
                    url: 'rpt.ashx?m=cy',
                    pageSize: 10,
                    fixWidth: 120,
                    mergeWidth: 100,
                    splitChar: '_',
                    onLoadSuccess: function (data) {
                        $('#difference1').datagrid("autoMergeCells", ["差异量"]);
                    }
                });
            }

            if (index == 1) {
                $('#difference1').datagridLoadRpt({
                    idField: '差异',
                    queryParams: $('#ffMaster').serializeJson(),
                    url: 'rpt.ashx?m=cy',
                    pageSize: 10,
                    fixWidth: 120,
                    mergeWidth: 100,
                    splitChar: '_',
                    onLoadSuccess: function (data) {
                        $('#difference1').datagrid("autoMergeCells", ["差异量"]);
                    }
                });
            }

            if (index == 2) {
                if ($('#ffMaster').form("validate")) {
                    $('#DataGrid' + index).datagridLoad({
                        idField: '测试列1',
                        url: 'rpt.ashx?m=' + index,
                        pageSize: 10,
                        fixWidth: 100,
                        mergeWidth: 80,
                        splitChar: '_'
                    });
                }
            }
        }

        //导出
        function tbExport() {
            var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));

            //加载表头
            var fields1 = $('#DataGrid' + index).datagrid('getColumnFields');
            var fields2 = $('#DataGrid' + index).datagrid('getColumnFields', true);
            var fields = fields2.concat(fields1);
            var headers = [];
            for (var i = 0; i < fields.length; i++) {
                //headers.push($('#DataGridMaster').datagrid('getColumnOption', fields[i])['title']);
                headers.push(fields[i]);
            }
            $('#DataGrid' + index).datagridExport({
                headers: headers,
                fileName: '导出数据(年度生产数据统计表).xls',
                workSheet: '导出数据(年度生产数据统计表)'
            });

            //$('#DataGridMaster').datagridExport({
            //    headers: headers,
            //    fileName: '导出数据(表名).xls',
            //    workSheet: '导出数据(表名)'
            //});

            //导出多sheet
            //$.dataGridToExcel(
            //    ['DataGridMaster', 'DataGridDetail1', 'DataGridDetail2'],
            //    ['表名','表名明细表1', '表名明细表2'],
            //    "导出数据（表名).xls"
            //);
        }

        //搜索按钮
        function tbSearch() {
            $('#tbSearchDiv').toggle();
            //$('#DataGridMaster').datagrid('resize');
            $('#toolbarLayout').panel('resize', { height: 'auto' });
            $('body').layout('resize');
            $('#tableTabs').tabs('resize');
        }

        //刷新
        function tbReload() {
            tbSearchSubmit();
        }

    </script>
</body>
</html>