添加采购订单查询页面

wtt

2024-06-19 3aafef42569351299112562dc2a6e5e925dbe910

添加采购订单查询页面

 WebTM/WebTM.csproj

@@ -416,6 +416,7 @@
    <Content Include="views\采购管理\采购报表\Cg_POInStockBillSumReport.html" />
    <Content Include="views\采购管理\采购报表\Cg_POMaterialPriceReport.html" />
    <Content Include="views\采购管理\采购报表\Cg_POOrderBillProcessSumReport.html" />
    <Content Include="views\采购管理\采购订单\Cg_POOrderBillCheckQuery.html" />
    <Content Include="views\销售管理\销售合同\Add_Edit_Xs_ContractBillList.html" />
    <Content Include="views\销售管理\销售合同\Xs_ContractBillList.html" />
    <Content Include="views\项目管理\基础建模\Add_Edit_Gy_TaskClass.html" />

 WebTM/WebTM.csproj.user

@@ -3,7 +3,7 @@
  <PropertyGroup>
    <NameOfLastUsedPublishProfile>D:\智云迈思\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <ProjectView>ProjectFiles</ProjectView>
    <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>true</UseIISExpress>
    <Use64BitIISExpress />
    <IISExpressSSLPort />

 WebTM/layuiadmin/Scripts/webConfig.js

@@ -9,7 +9,7 @@
    var WEBURL = "http://localhost:81/API/";    //王彬本地配置
    /*var WEBURL = "http://localhost:8083/API/";  //陈雯静本地配置*/
   // var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置
    var WEBURL = "http://localhost:8082/API/";   //张瑞广本地配置
    /*var WEBURL = "http://localhost:8082/API/";   //张瑞广本地配置*/
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //余思杰本地配置
    //var WEBURL = "http://localhost:8088/ARAPI/";    //余思杰本地配置(安瑞)
    //var WEBURL = "http://10.1.4.155/API/";   //江丰客户NEW

 WebTM/views/ϵͳ¹ÜÀí/¶à¼¶ÉóÅú/ÉóºËÁ÷³Ìµ¥/Xt_CheckFlowEdit.html

@@ -381,11 +381,11 @@
                $(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
                    if (event.key == "F7") {
                        if (obj.event == "HCheckItemID") {
                            //打开维修项目小窗体
                            //打开审批项目小窗体
                            layer.open({
                                type: 2
                                , skin: "layui-layer-rim" //加上边框
                                , title: "维修项目列表"  //标题
                                , title: "审批项目列表"  //标题
                                , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                                , shift: 2 //弹出动画
                                , area: ["90%", "90%"] //窗体大小
@@ -410,7 +410,7 @@
                                }
                            })
                        }

                        obj.event = "";
                    }
                })
            }

 WebTM/views/ÖÊÁ¿¹ÜÀí/¹¤×÷ÁªÏµµ¥/OA_WorkLinkSelfQuery.html

@@ -509,27 +509,32 @@
            function get_Description(tableName) {
                var checkStatus = table.checkStatus(tableName)
                    , data = checkStatus.data;
                layer.open({
                    type: 2,
                    skin: 'layui-layer-rim', //加上边框
                    title: '阅读明细 ',
                    closeBtn: false,
                    shift: 2,
                    area: ['100%', '100%'],
                    maxmin: true,
                    content: '../../生产管理/异常反馈单/EXecptFeedMessage.html',
                    end: function () {
                        //刷新页面,
                        /*location.reload();*/
                    },
                    success: function (dom) {
                        var a = $(dom[0]).find("iframe").eq(0).contents();
                        a.find("h1").html(data[0].主题);
                        a.find("span").html(data[0].日期);
                        a.find(".layadmin-text").html(data[0].内容);
                        UpdateMessage(data[0].hmainid, data[0].HEntryID);
                    },
                });
                if (checkStatus.data.length === 1) {
                    layer.open({
                        type: 2,
                        skin: 'layui-layer-rim', //加上边框
                        title: '阅读明细 ',
                        closeBtn: false,
                        shift: 2,
                        area: ['100%', '100%'],
                        maxmin: true,
                        content: '../../生产管理/异常反馈单/EXecptFeedMessage.html',
                        end: function () {
                            //刷新页面,
                            /*location.reload();*/
                        },
                        success: function (dom) {
                            var a = $(dom[0]).find("iframe").eq(0).contents();
                            a.find("h1").html(data[0].主题);
                            a.find("span").html(data[0].日期);
                            a.find(".layadmin-text").html(data[0].内容);
                            UpdateMessage(data[0].hmainid, data[0].HEntryID);
                        },
                    });
                } else {
                    layer.msg('请选择一行数据查看！');
                }
                
            }
            
            //#endregion

 WebTM/views/²É¹º¹ÜÀí/²É¹º¶©µ¥/Cg_POOrderBillCheckQuery.html

New file
@@ -0,0 +1,756 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>采购订单查询</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <!--引用layui样式文件-->
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <!--引用layui js文件-->
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <style type="text/css">
        .layui-form-label {
            width: 85px;
        }

        .maintitle {
            background-color: #1492ff;
            color: #fff;
            padding: 5px 10px;
            border: none;
            border-radius: 4px;
        }

        .title {
            border-left: 4px solid #1492ff;
            padding-left: 6px;
            margin: 20px 10px 4px;
            font-size: 16px;
            color: #333;
        }

        .buttom_box_little {
            width: 60px;
            height: 36px;
            color: #fff;
            background-color: #1492ff;
            border-radius: 4px;
            border: none;
            margin: 10px;
        }

        .layui-input {
            width: 93%;
        }

        .layui-inline, img {
            display: block;
            vertical-align: middle
        }

        .layui-input, .layui-textarea {
            display: inline-block;
            width: 100%;
            padding-left: 10px;
        }

        .laydate-time-list ol {
            overflow-x: hidden !important;
            overflow-y: auto !important;
        }

        .layui-form-label {
            padding: 9px 5px;
        }

        .layui-input-block {
            margin-left: 85px;
            min-height: 36px;
        }
    </style>
</head>
<body>

    <div id="layout1" class="layui-fluid">
        <div class="layui-row layui-col-space15">
            <div class="layui-col-md12">
                <div class="layui-card">
                    <form id="form0" class="layui-form" lay-filter="component-form-group" action="">
                        <!--<div class="layui-card-header">
                            <div class="layui-btn-group">
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-event="set_HideColumn" lay-filter="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">退出</button>
                            </div>
                        </div>-->
                        <div class="layui-card-body">
                            <div class="layui-tab layui-tab-brief" lay-filter="docDemoTabBrief">
                                <h1 style="text-align:center;"><b>采购订单查询</b></h1>
                                    <div class="layui-tab layui-tab-card" lay-filter ="table"> 
                                        <ul class="layui-tab-title">
                                            <li class="layui-this">我发起的</li>
                                            <li>需要我审核的</li>
                                            <li>我已审核的 </li>
                                        </ul>
                                        <div class="layui-tab-content" style="height: 700px;">
                                            <div class="layui-tab-item layui-show">
                                                <script type="text/html" id="toolbarDemoSend">
                                                    <div class="layui-btn-container">
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" ><i class="layui-icon layui-icon-form"></i>列设置</button>
                                                    </div>
                                                </script>
                                                <table class="" id="mainTableSend" lay-filter="mainTableSend"></table>
                                            </div>
                                            <div class="layui-tab-item layui-show">
                                                <script type="text/html" id="toolbarDemoNeedCheck">
                                                    <div class="layui-btn-container">
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" ><i class="layui-icon layui-icon-form"></i>列设置</button>
                                                    </div>
                                                </script>
                                                <table class="" id="mainTableNeedCheck" lay-filter="mainTableNeedCheck"></table>
                                            </div>
                                            <div class="layui-tab-item layui-show">
                                                <script type="text/html" id="toolbarDemoChecked">
                                                    <div class="layui-btn-container">
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                                    </div>
                                                </script>
                                                <table class="" id="mainTableChecked" lay-filter="mainTableChecked"></table>
                                            </div>
                                        </div>
                                    </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <script>
        layui.config({
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'table', 'element'], function () {
             //#region å…¬ç”¨å˜é‡
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , table = layui.table
                , form = layui.form
                , laydate = layui.laydate
                , element = layui.element;

            window.HDeptType = 0;
            var tabIndex = 1;//页签索引
            var option = [];
            var optionNeedCheck = [];
            var optionSend = [];
            var optionChecked = [];
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["hmainid", "HBillType", "HSupID", "HPSStyleID", "HSSID", "HCurID", "HDeptID", "HManagerID", "HEmpID", "hsubid", "HMaterID", "HUnitID",
                "HFeedback", "HPriority", "HUserID", "币别代码", "采购方式代码", "结算方式代码", "部门代码", "主管代码", "业务员代码", "计量单位代码", "HCheckFlowStatusID", "HCheckFlowID","HCheckItemID"];
            //#endregion
            //#endregion
            var HModName = "Cg_POOrderBillCheckQuery";

            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            //初始化表格
            set_InitGrid();
            //查询
            get_Display(1);
            //get_Display(2);
            //get_Display(3);
            //#endregion

            //#region ç‚¹å‡»äº‹ä»¶åŒ…括on form事件等
            //#region头工具栏事件
            table.on('toolbar(mainTableSend)', function (obj) {
                switch (obj.event) {
                    //编辑
                    case 'btn-Edit': get_ShowBill('mainTableSend');
                        break;
                    //刷新
                    case 'get_Refresh': get_Display(1);
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                };
            });
            table.on('toolbar(mainTableNeedCheck)', function (obj) {
                switch (obj.event) {
                    //编辑
                    case 'btn-Edit': get_ShowBill('mainTableNeedCheck');
                        break;
                    //刷新
                    case 'get_Refresh': get_Display(2);
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                };
            });
            table.on('toolbar(mainTableChecked)', function (obj) {
                switch (obj.event) {
                    //编辑
                    case 'btn-Edit': get_ShowBill('mainTableChecked');
                        break;
                    //刷新
                    case 'get_Refresh': get_Display(3);
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                };
            });

            table.on('tool(mainTableChecked)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var linterid = data.hmainid.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑采购订单' 
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: './Cg_POOrderBillEdit.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=0&closeType=1'
                        , resize: false,
                        end: function () {
                           
                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                }
            });
            table.on('tool(mainTableNeedCheck)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var linterid = data.hmainid.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑采购订单'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: './Cg_POOrderBillEdit.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=0&closeType=1'
                        , resize: false,
                        end: function () {

                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                }
            });
            table.on('tool(mainTableSend)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var linterid = data.hmainid.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑采购订单'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: './Cg_POOrderBillEdit.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=0&closeType=1'
                        , resize: false,
                        end: function () {

                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                }
            });
            //#endregion

            //#region ç›‘听Tab切换，切换时触发
            element.on('tab(table)', function (data) {
                // èŽ·å–被切换到的面板的索引
                var index = data.index;
                // æ‰§è¡Œä¸€äº›æ“ä½œï¼Œä¾‹å¦‚改变页面内容
                tabIndex = index + 1;
                get_Display(index+1);
            });
            //#endregion

            //#region ç‚¹å‡»è¡Œé€‰ä¸­é«˜äº®
            table.on('row(mainTableChecked)', function (obj) {
                //选中行改变颜色
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            table.on('row(mainTableSend)', function (obj) {
                //选中行改变颜色
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            table.on('row(mainTableNeedCheck)', function (obj) {
                //选中行改变颜色
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            //#endregion

            //#region æŽ’序
            table.on('sort(mainTableChecked)', function (obj) { //注：sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"
                table.reload('mainTableReceive', {
                    initSort: obj //记录初始排序，如果不设的话，将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                optionNeedCheck.data = layui.table.cache["mainTableReceive"];
                table.render(optionNeedCheck);
            });
            table.on('sort(mainTableSend)', function (obj) { //注：sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"
                table.reload('mainTableSend', {
                    initSort: obj //记录初始排序，如果不设的话，将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                optionSend.data = layui.table.cache["mainTableSend"];
                table.render(optionSend);
            });
            table.on('sort(mainTableNeedCheck)', function (obj) { //注：sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"
                table.reload('mainTableSendCopy', {
                    initSort: obj //记录初始排序，如果不设的话，将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                optionChecked.data = layui.table.cache["mainTableSendCopy"];
                table.render(optionChecked);
            });
            //#endregion

            //#endregion

            //#region è¯¥é¡µé¢æ‰€æœ‰æ–¹æ³•
            //#region åˆå§‹åŒ–表格
            function set_InitGrid() {
                optionNeedCheck = {
                    elem: '#mainTableNeedCheck'
                    , toolbar: '#toolbarDemoNeedCheck'
                    , totalRow: true
                    , page: true
                    , cellMinWidth: 120
                    , height: 'full-50'
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , data : []
                };
                optionSend = {
                    elem: '#mainTableSend'
                    , toolbar: '#toolbarDemoSend'
                    , totalRow: true
                    , page: true
                    , cellMinWidth: 120
                    , height: 'full-50'
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    
                };
                optionChecked = {
                    elem: '#mainTableChecked'
                    , toolbar: '#toolbarDemoChecked'
                    , totalRow: true
                    , page: true
                    , cellMinWidth: 120
                    , height: 'full-50'
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    
                };
                option = optionSend;//初始化列设置option
            }
            //#endregion

            //#region åŠ è½½è¡¨æ ¼1为我发起的2我需要审核的3我已审核的
            function get_Display(type) {
                var ajaxLoad = layer.load();//遮罩
                var url = "";
                var user = sessionStorage["HUserName"];
                if (type == 1) {
                    var sWhere = "and åˆ¶å•äºº = '" + user + "'"
                    $.ajax({
                        url: GetWEBURL() + '/Cg_POOrderBill/list',
                        type: "GET",
                        data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                        success: function (data1) {
                            if (data1.count == 1) {
                                var data = [];//列字段数据
                                var col = [];
                                var totalArray = ["数量", "关联数量", "未关联数量", "打印条码数量", "未打印条码数量", "实收数量", "金额"];
                                //给空的数组赋值
                                for (var key in data1.list) {
                                    data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                }
                                //在列表左边添加勾选框
                                col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                                for (var i = 0; i < data.length; i++) {
                                    // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                    if ($.inArray(data[i].name, titleData) > -1) {
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                    }
                                    else if ($.inArray(data[i].name, totalArray) > -1) { //计算列
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                    } else if (data[i].name == '单据号') {//添加超链接
                                        col.push({
                                            field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号', templet: function (d) {
                                                return '<span style="color: blue;">' + d.单据号 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    } else {
                                        switch (data[i].Type) {
                                            //int
                                            case 'DateTime':
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + (data[i].name == "行关闭日期" ? "行关闭人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                                break;
                                            default:
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                        }
                                    }
                                }
                                optionSend.cols = [col];
                                optionSend.data = data1.data;
                                table.render(optionSend);
                                option = optionSend;
                                DisPlay_HideColumn();
                                layer.close(ajaxLoad);
                                //layer.alert("查询成功", { icon: 1 });
                            } else {
                                layer.close(ajaxLoad);
                                layer.alert(data1.code + data1.Message, { icon: 5 });
                            }
                        }, error: function () {
                            layer.close(ajaxLoad);
                            layer.alert("接口请求失败!", { icon: 5 });
                        }
                    });
                    return;
                } else if (type == 2) {
                    url = '/Cg_POOrderBill/NeedChecklist';
                }
                else if (type == 3) {
                    url = '/Cg_POOrderBill/Checkedlist';
                } else {
                    var url = "";
                }
                $.ajax({
                    url: GetWEBURL() + url,
                    type: "GET",
                    async: false,
                    data: { "user": user },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计行' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                } else if (data[i].name == '单据号') {//添加超链接
                                    col.push({
                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号', templet: function (d) {
                                            return '<span style="color: blue;">' + d.单据号 + '</span>'
                                        }, style: 'cursor: pointer;'
                                    });
                                } else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
                                            break;
                                        case 'long':
                                        case 'Int32':
                                        case 'Int64':
                                        case 'double':
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 });
                                    }
                                }
                            }
                            optionNeedCheck.cols = [col];
                            optionChecked.cols = [col];
                            if (type == 1) {
                                optionSend.data = data1.data;
                                table.render(optionSend);
                                option = optionSend;
                            } else if (type == 2) {
                                optionNeedCheck.data = data1.data;;
                                table.render(optionNeedCheck);
                                option = optionNeedCheck;
                            }
                            else if (type == 3) {
                                optionChecked.data = data1.data;
                                table.render(optionChecked);
                                option = optionChecked;
                            } else {
                                /*table.render(optionSend);*/
                            }
                            DisPlay_HideColumn();
                            layer.close(ajaxLoad);
                            
                            //layer.alert("查询成功", { icon: 1 });
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
             }
            //#endregion

            //#region éšè—åˆ—设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }
            //#endregion

            //#region æ˜¾ç¤ºåˆ—数据
            function DisPlay_HideColumn() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {

                            var dataCol = [];//数据库查询出的列数据
                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
                                }
                                //设置内容字体大小
                                if (data1.data[0].HFontSize != 0) {
                                    option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                } else {
                                    option.cols[0][i + 1]["style"] = "font-size:100%";
                                }
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    option.cols[0][i + 1]["width"] = dataCols[3];
                                }
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                    option.cols[0][i + 1]["hide"] = false;
                                }
                                //字体所在位置(å·¦ å±…中 å³)
                                switch (dataCols[2]) {
                                    case "L":
                                        option.cols[0][i + 1]["align"] = "left";
                                        break;
                                    case "M":
                                        option.cols[0][i + 1]["align"] = "center";
                                        break;
                                    case "R":
                                        option.cols[0][i + 1]["align"] = "right";
                                        break;
                                }
                            }

                            //取消冻结列
                            for (var i = 1; i < option.cols[0].length - 1; i++) {
                                if (option.cols[0][i]["fixed"] != null) {
                                    option.cols[0][i]["fixed"] = null;
                                }
                                else {
                                    break;
                                }
                            }
                            //冻结列
                            if (data1.data[0].HFixCols != 0) {
                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                    if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                        data1.data[0].HFixCols += 1;
                                    }
                                    option.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            table.render(option);
                            var HBillType = "1102";
                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
                        } else {
                            table.render(option);
                            var HBillType = "1102";
                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
            }
            //#endregion

            //#region ç¼–辑
            function get_ShowBill(tableName) {
                var checkStatus = table.checkStatus(tableName)
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var HInterID = data[0].hmainid.toString();
                    //if (data[0].HEntryID == null || HEntryID == '') {
                    //    var HEntryID = '';
                    //} else {
                    //    var HEntryID = data[0].HEntryID.toString();
                    //}
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑采购订单'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: './Cg_POOrderBillEdit.html?OperationType=3&linterid=' + HInterID + '&HSouceBillType=0&closeType=1'
                        , resize: false,
                        end: function () {
                            /*get_FastQuery(table, option);*/
                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                } else {
                    layer.msg('请选择一行数据编辑！');
                }
            }
            //#endregion


            //#endregion


            //以上为layui模块
        });

        function formatDate(date) {
            var d = new Date(date),
                month = '' + (d.getMonth() + 1),
                day = '' + d.getDate(),
                year = d.getFullYear();

            if (month.length < 2) month = '0' + month;
            if (day.length < 2) day = '0' + day;

            return [year, month, day].join('-');
        }
    </script>
</body>
</html>