DK-MES-2.0
/
IMEX.mes.web


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
							<!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>
    <!--工具条-->
    <div id="tb" class="i-toolbar">
        <a href="javascript:void(0)" style="display:none" id="btnInsert" title="添加" class="easyui-linkbutton" iconcls="icon-add" plain="true" onclick="tbAdd()">添加</a>
        <a href="javascript:void(0)" style="display:none" id="btnUpdate" title="编辑" class="easyui-linkbutton" iconcls="icon-edit" plain="true" onclick="tbEdit()">修改</a>
        <a href="javascript:void(0)" style="display:none" id="btnDelete" title="删除" class="easyui-linkbutton" iconcls="icon-remove" plain="true" onclick="tbDelete()">删除</a>
        <a href="javascript:void(0)" style="display:none" id="btnDetail" title="详细" class="easyui-linkbutton" iconcls="icon-detail" plain="true" onclick="tbDetail()">详细</a>
        <a href="javascript:void(0)" style="display:none" id="btnCheckbox" title="显示复选框" class="easyui-linkbutton" iconcls="icon-ok" plain="true" toggle="true" onclick="tbCheck()">复选</a>
        <a href="javascript:void(0)" style="display:none" id="btnSearch" title="搜索" class="easyui-linkbutton" iconcls="icon-search" plain="true" toggle="true" onclick="tbSearch()">搜索</a>
        <a href="javascript:void(0)" style="display:none" 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:none;padding:10px;">
            <form id="ff">
                <div>
                    GUID：
                    <input class="easyui-textbox" id="GUID" name="GUID" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
                    结转表名：
                    <input class="easyui-textbox" id="RPTNAME" name="RPTNAME" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
                    结转类型：
                    <input class="easyui-textbox" id="EXECUTETYPE" name="EXECUTETYPE" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
                    API地址：
                    <input class="easyui-textbox" id="APIURL" name="APIURL" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
                    结转周期：
                    <input class="easyui-textbox" id="EXECUTECYC" name="EXECUTECYC" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
                    <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="$('#ff').form('clear')">清空</a>
                    <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
                </div>
            </form>
        </div>
    </div>
    <!--表格-->
    <table id="dg" data-options="toolbar: '#tb',onDblClickRow: dgDblclickrow,showFooter:false">
<!--
        <thead data-options="frozen:true">
            <tr>
                <th data-options="field:'标识',align:'left',sortable:true">标识</th>
            </tr>
        </thead>
-->
        <thead>
            <tr>
                <th data-options="field:'SID',title:'SID',width:220,align:'left',checkbox:true,hidden:true">SID</th>
                <th data-options="field:'GUID',title:'GUID',align:'left',sortable:true,hidden:true"></th>
                <th data-options="field:'RPTNAME',title:'结转表名',align:'left',sortable:true"></th>
                <th data-options="field:'EXECUTETYPE',title:'结转类型',align:'left',sortable:true"></th>
                <th data-options="field:'SQLCODE',title:'SQL结转脚本',align:'left',sortable:true"></th>
                <th data-options="field:'APIURL',title:'API地址',align:'left',sortable:true"></th>
                <th data-options="field:'EXECUTECYC',title:'结转周期',align:'left',sortable:true"></th>
                <th data-options="field:'EXECUTEDATE',title:'结转时间',align:'left',sortable:true"></th>
                <th data-options="field:'BEGINDATE',title:'开始时间',align:'left',sortable:true"></th>
                <th data-options="field:'ENDDATE',title:'截止时间',align:'left',sortable:true"></th>
            </tr>
        </thead>
    </table>
    <script type="text/javascript">

        //加载完成
        $(function () {
            //加载按钮
            $('#tb').buttonLoad({
                url:'jzsetting.ashx?m=b'
            });
            //加载表格数据
            tbSearchSubmit()
        });

        //添加按钮
        function tbAdd() {
            $('#dg').datagridDialog({
                title: '添加数据',
                width: 640,
                height: 480,
                url: 'jzsetting_add.html'
            });
        }

        //修改按钮
        function tbEdit() {
            $('#dg').datagridDialog({
                title: '修改数据',
                width: 640,
                height: 480,
                url: 'jzsetting_edit.html',
                requireSelect: true
            });
        }

        //删除按钮
        function tbDelete() {
            $('#dg').datagridPost({
                title:'删除操作',
                url: 'jzsetting.ashx?m=d',
                onValidate: function (r) { return true; }
            });
        }

        //详细按钮
        function tbDetail() {
            $('#dg').datagridDialog({
                title: '详细数据',
                width: 640,
                height: 480,
                url: 'jzsetting_detail.html',
                requireSelect: true
            });
        }

        //复选按钮
        function tbCheck() {
            $('#dg').datagridCheckbox({
                buttonid: 'btnCheckbox',
                valuefield: 'SID'
            });
        }

        //搜索按钮
        function tbSearch() {
            $('#tbSearchDiv').toggle();
            $('#dg').datagrid('resize');
        }

        //搜索提交
        function tbSearchSubmit() {
            $('#dg').datagridLoad({
                title: '结转配置',
                idField: 'SID',
                queryParams: $('#ff').serializeJson(),
                url: 'jzsetting.ashx?m=s',
                columnMenu: '#btnColumnMenu',
                columnMoving: false
            });
        }

        //导出
        function tbExport() {
            //加载表头
            var fields = $('#dg').datagrid('getColumnFields');
            var headers = [];
            for (var i = 0; i < fields.length; i++) {
                headers.push($('#dg').datagrid('getColumnOption', fields[i])['title']);
                //headers.push(fields[i]);
            }
            $('#dg').datagridExport({
                headers: headers,
                fileName: '导出数据(结转配置).xls',
                workSheet: '导出数据(结转配置)'
            });
        }

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

        //表格双击
        function dgDblclickrow(rowIndex, rowData) {
            tbDetail();
        }

        function formatterTrueFalse(value, row, index) { return value == 'True' ? '是' : '否'; }
        function stylerTrueFalse(value, row, index) { return value == 'True' ? 'color:black' : 'color:red'; }

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