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


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276
							<!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 id="tb" style="overflow: hidden;" class="i-toolbar" data-options="border:false,region:'north',title:'',iconCls:'icon-grid',height:210">
            <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="btnReload" title="刷新" class="easyui-linkbutton" iconcls="icon-reload" plain="true" onclick="tbReload()">刷新</a>
            <div id="tbSearchDiv" style="display: block; padding: 10px;">
                <form id="ffMaster">
                    <div>
                        产成品交接时间：
                        <input class="easyui-datetimebox" id="datebeginMasterS" name="datebeginMasterS" data-options="required:false,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
                        -
                        <input class="easyui-datetimebox" id="datebeginMasterD" name="datebeginMasterD" data-options="required:false,prompt:'',tipPosition:'top'" style="width:165px; height:32px;">
                        注浆日期：
                        <input class="easyui-datebox" id="datebeginMasterG" name="datebeginMasterG" data-options="required:false,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
                        - <input class="easyui-datebox" id="dateendMasterG" name="dateendMasterG" data-options="required:false,prompt:'',tipPosition:'top'" style="width:120px; height:32px;">
                        车间：
                        <input class="easyui-combobox" id="workshop" name="workshop" data-options="required:false,valueField:'value',textField:'text',editable:true,multiple:true,
                               data:[{'text': '1车间', 'value': '1'},{'text': '2车间', 'value': '2'},{'text': '3车间', 'value': '3'}]"
                               style=" width: 160px; height: 32px;">产品类型：
                        <input class="easyui-combotree" id="goodstypecode" name="goodstypecode" data-options="required:false,prompt:'',tipPosition:'top',url:'../../list.ashx?m=getGoodsType',method:'get',panelHeight:'200px',editable:true" style="width: 160px; height: 32px;"></span>
                        <span class="labelspan">产品条码<input class="easyui-textbox" id="barcode" name="barcode" data-options="required:false,prompt:'',tipPosition:'top',required:false" style="width: 120px; height: 32px;"></span>
                        <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="$('#ffMaster').form('clear')">清空</a>
                        <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <div data-options="border:false,region:'center',title:'',iconCls:'icon-grid'">
        <div id="tableTabs" class="easyui-tabs" data-options="border:false" style="width: 100%; height: 100%">
            <div title="产成品交接表">
                <!--表格-->
                <table class="easyui-datagrid"
                       id="DataGrid"
                       data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true,onDblClickRow: dgDblclickrow">
                    <thead>
                        <tr>
                            <th data-options="field:'注浆日期',title:'注浆日期',align:'center',sortable:false"></th>
                            <th data-options="field:'交接时间',title:'交接时间',align:'center',sortable:false"></th>
                            <th data-options="field:'车间',title:'车间',align:'center',sortable:false"></th>
                            <th data-options="field:'产品类型',title:'产品类型',align:'center',sortable:false"></th>
                            <th data-options="field:'产品编码',title:'产品编码',align:'center',sortable:false"></th>
                            <th data-options="field:'产品名称',title:'产品名称',align:'center',sortable:false"></th>
                            <th data-options="field:'产品条码',title:'产品条码',align:'center',sortable:false"></th>
                        </tr>
                    </thead>
                </table>
            </div>
            <div title="产品跟踪表">
                <!--表格-->
                <table class="easyui-datagrid"
                       id="DataGridMaster"
                       data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">

                    <thead>
                        <tr>
                            <th data-options="field:'公司',title:'公司',align:'center',sortable:false"></th>
                            <th data-options="field:'工厂',title:'工厂',align:'center',sortable:false"></th>
                            <th data-options="field:'车间',title:'车间',align:'center',sortable:false"></th>
                            <th data-options="field:'工作中心',title:'工作中心',align:'center',sortable:false"></th>
                            <th data-options="field:'产线',title:'产线',align:'center',sortable:false"></th>
                            <th data-options="field:'工序',title:'工序',align:'center',sortable:false"></th>
                            <th data-options="field:'生产工号',title:'生产工号',align:'center',sortable:false"></th>
                            <th data-options="field:'产品分级',title:'产品分级',align:'center',sortable:false"></th>
                            <th data-options="field:'操作者',title:'操作者',align:'center',sortable:false"></th>
                            <th data-options="field:'操作时间',title:'操作时间',align:'center',sortable:false"></th>
                        </tr>
                    </thead>
                </table>
            </div>
            <div title="产品信息表">
                <table class="easyui-datagrid"
                       id="PropertyGridDetail"
                       data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
                </table>
            </div>
            <div title="物料信息表">
                <!--表格-->
                <table class="easyui-datagrid"
                       id="DataGridMateriel"
                       data-options="method:'get',border:false,singleSelect:true,fit:true,fitColumns:true">
                    <thead>
                    </thead>
                </table>
            </div>
        </div>
    </div>
    <script type="text/javascript">

        var pgColumns = [[
            { field: 'name', title: '属性', width: '150px', sortable: true, align: 'left' },
            { field: 'value', title: '值', width: '150px', resizable: false, align: 'left' }
        ]];

        function formatterUA(value, row, index) {
            return Math.round(value * 10000) / 100 + '%';
        }

        $(document).ready(function () {
            var ctime = new Date();
            var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate() + " 00:00:00";
            var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + (ctime.getDate()) + " 23:59:59";
            $("#datebeginMasterS").datetimebox("setValue", beginDate);
            $("#datebeginMasterD").datetimebox("setValue", endDate);

            //var beginDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
            //var endDate = ctime.getFullYear() + "-" + (ctime.getMonth() + 1) + "-" + ctime.getDate();
            //$("#datebeginMasterG").datebox("setValue", beginDate);
            //$("#dateendMasterG").datebox("setValue", endDate);

            tbSearchSubmit();

        });
        //主表双击事件
        function dgDblclickrow(index, row) {
            $("#tableTabs").tabs("select", 1);
            LoadDataGridDetail(index, row);
        }
        //加载子表数据
        function LoadDataGridDetail(index, row) {
            var barcode = row["产品条码"];
            //产品追踪表
            $('#DataGridMaster').datagridLoad({
                title: '',
                idField: 'SID',
                queryParams: $('#ffMaster').serializeJson(),
                url: 'rpt.ashx?m=master&id=' + request('id') + '&barcodeDB=' + barcode,
                fixWidth: 160,
                mergeWidth: 100,
                splitChar: '_',
                columnMenu: '#btnColumnMenu',
                columnMoving: true
            });
            //产品属性表
            $('#PropertyGridDetail').propertygrid({
                queryParams: $('#ffMaster').serializeJson(),
                url: 'rpt.ashx?m=property&barcodeDB=' + barcode,
                method: 'get',
                columns: pgColumns,
                border: false,
                showGroup: false,
                scrollbarSize: 0
            });
            //物料信息表
            $('#DataGridMateriel').datagridLoad({
                title: '',
                idField: 'SID',
                queryParams: $('#ffMaster').serializeJson(),
                url: 'rpt.ashx?m=materiel&id=' + request('id') + '&barcodeDB=' + barcode,
                fixWidth: 160,
                mergeWidth: 100,
                splitChar: '_',
                columnMenu: '#btnColumnMenu',
                columnMoving: true
            });
        }

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

            if ($('#ffMaster').form("validate")) {

                if (index == 0) {
                    $('#DataGrid').datagridLoad({
                        title: '',
                        idField: 'SID',
                        queryParams: $('#ffMaster').serializeJson(),
                        url: 'rpt.ashx?m=goods&id=' + request('id'),
                        fixWidth: 160,
                        mergeWidth: 100,
                        splitChar: '_',
                        columnMenu: '#btnColumnMenu',
                        columnMoving: true
                    });
                }
                if ((index == 1 || index == 2 || index == 3) && barcode.length > 0) {
                    //产品追踪表
                    $('#DataGridMaster').datagridLoad({
                        title: '',
                        idField: 'SID',
                        queryParams: $('#ffMaster').serializeJson(),
                        url: 'rpt.ashx?m=master&id=' + request('id'),
                        fixWidth: 160,
                        mergeWidth: 100,
                        splitChar: '_',
                        columnMenu: '#btnColumnMenu',
                        columnMoving: true
                    });
                    //产品属性表
                    $('#PropertyGridDetail').propertygrid({
                        queryParams: $('#ffMaster').serializeJson(),
                        url: 'rpt.ashx?m=property',
                        method: 'get',
                        columns: pgColumns,
                        border: false,
                        showGroup: false,
                        scrollbarSize: 0
                    });
                    //物料信息表
                    $('#DataGridMateriel').datagridLoad({
                        title: '',
                        idField: 'SID',
                        queryParams: $('#ffMaster').serializeJson(),
                        url: 'rpt.ashx?m=materiel&id=' + request('id'),
                        fixWidth: 160,
                        mergeWidth: 100,
                        splitChar: '_',
                        columnMenu: '#btnColumnMenu',
                        columnMoving: true
                    });
                }

            }
        }

        //导出
        function tbExport() {
            var index = $('#tableTabs').tabs('getTabIndex', $('#tableTabs').tabs('getSelected'));
            var title = $('#tableTabs').tabs('getTab', index).panel('options').title;//表格名称
            var id = "DataGridMaster";
            if (index == 1) {
                id = "PropertyGridDetail";
            }
            //加载表头
            var fields = $('#' + id).datagrid('getColumnFields');
            var headers = [];
            for (var i = 0; i < fields.length; i++) {
                //headers.push($('#DataGridMaster').datagrid('getColumnOption', fields[i])['title']);
                headers.push(fields[i]);
            }
            $('#' + id).datagridExport({
                headers: headers,
                fileName: '导出数据(' + title + ').xls',
                workSheet: '导出数据(' + title + ')'
            });
            //导出多sheet
            //$.dataGridToExcel(
            //    ['DataGridMaster', 'PropertyGridDetail'],
            //    ['产品跟踪表', '产品信息'],
            //    "导出数据（产品跟踪表).xls"
            //);
        }

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

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

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