WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBillList.html
@@ -1,4 +1,4 @@
<!DOCTYPE html>
    <!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
@@ -13,7 +13,8 @@
    <script src="../../../layuiadmin/scripts/jquery-1.4.1.min.js"></script>
    <script src="../../../layuiadmin/pubcustom.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/HideButton_New.js"></script>
    <script src="../../../layuiadmin/SetColumn.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
</head>
@@ -55,12 +56,12 @@
                                        <input type="text" class="layui-input ForFilteringSchemes" name="WorkCenter" id="WorkCenter">
                                    </div>
                                </div>
                                <div class="layui-row" style="margin-top:10px;margin-left:5%;">
                                <div class="layui-row" style="margin-top:10px;margin-left:4%;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料代码</label>
                                        <div class="layui-input-block">
                                            <input type="hidden" class="layui-input " lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                            <input type="text" class="layui-input ForFilteringSchemes" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;">
                                            <input type="text" class="layui-input ForFilteringSchemes" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="background-color:#efefef4d;width: 75%;display: inline-block;">
                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterID" id="btnHMaterID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                            </button>
@@ -77,6 +78,12 @@
                                        <label class="layui-form-label" style="width: 85px;">规格型号</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HModel" id="HModel">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label" style="width: 85px;">基准值</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HBenchmarkValue" id="HBenchmarkValue">
                                        </div>
                                    </div>
                                </div>
@@ -97,10 +104,10 @@
                                            </select>
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" style="display:none;" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding: 0 5px; display: none;">重置</button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding: 0 5px;">重置</button>
                                </div>
                                <!--显示当前过滤方案-->
                                <div class="layui-inline" style="margin-left:5px;">
@@ -135,7 +142,7 @@
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                    <div class="layui-row" style=" margin-top: 10px; ">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
@@ -163,7 +170,7 @@
                                        </div>
                                    </div>
                                    <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
                                    <div class="layui-row" style=" margin-top: 10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
@@ -196,14 +203,14 @@
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div id="page" style="position:relative;bottom:0;"></div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                            <div class="layui-btn-container" id="toolbarDemo_ButtonSet">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Excel"><i class="layui-icon layui-icon-delete"></i>Excel导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Copy" id="set_Copy"><i class="layui-icon layui-icon-form"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew" id="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNewSub" id="set_AddNewSub"><i class="layui-icon layui-icon-file-b"></i>新增子路线</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill" id="set_ShowBill"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Copy" id="set_Copy"><i class="layui-icon layui-icon-form"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill" id="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_defaultRoute" id="set_defaultRoute"><i class="layui-icon layui-icon-form"></i>启用默认</button>
@@ -216,16 +223,16 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_WithdrawCheck_Flow" id="WithdrawCheck_Flow"><i class="layui-icon layui-icon-form"></i>撤回</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CloseBill" id="set_CloseBill"><i class="layui-icon layui-icon-form"></i>关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CancelCloseBill" id="set_CancelCloseBill"><i class="layui-icon layui-icon-form"></i>反关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CancelCloseBillSetDate" id="set_CancelCloseBillSetDate"><i class="layui-icon layui-icon-form"></i>反关闭(设置时间)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Drop" id="btn-Drop"><i class="layui-icon layui-icon-radio"></i>作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeDrop" id="btn-DeDrop"><i class="layui-icon layui-icon-radio"></i>反作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-ProcPriceRequestBills" id="btn-ProcPriceRequestBills"><i class="layui-icon layui-icon-delete"></i>多行下推(定额申请单)</button>
                                <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-audit"><i class="layui-icon layui-icon-repeat"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Faudit"><i class="layui-icon layui-icon-refresh"></i>反审核</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideButton" id="set_HideButton"><i class="layui-icon layui-icon-form"></i>按钮设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_SaveScheme" id="btn_SaveScheme"><i class="layui-icon layui-icon-template"></i>保存方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_ReadScheme" id="btn_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_BulkEditWorkTime" id="btn_BulkEditWorkTime"><i class="layui-icon layui-icon-set"></i>批改小时产能</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_SourceWorkQty" id="btn_SourceWorkQty"><i class="layui-icon layui-icon-set"></i>产线产能</button>
                            </div>
@@ -257,11 +264,13 @@
            var sWhere = "";
            var option = [];
            var page = 1;//分页数据
            var size = 50;
            var HBillType = 3301;
            var size = 50;
            var ins;                        //用于导出excel
            var HModName = "Gy_RoutingBillList";
            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
            var HBillType = 3301;
            var set_HideButton_ID = "toolbarDemo_ButtonSet";//需要设置的按钮的父级节点的id
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["hmainid", "HMaterID", "HUnitID", "HOrgID", "hsubid", "HProcID", "HSupID", "HCenterID", "HMainCenterID", "HMainProcID", "HCenterID_S", "HProcID_S", "HItemID", "HPRDORGID", "HDayWorkQty", "HGroupID", "HWorkerID", "HSourceID", "HNextProcFlag", "HBadWHID", "HBadWHName", "HWasterWHID", "HWasterWHName", "HWhID", "HWHName", "HBillSubType", "HQCSchemeID_Fst", "HQCSchemeID_Proc","HQCSchemeID_Patrol"];
            //#region ã€è¿‡æ»¤æ–¹æ¡ˆã€‘
@@ -370,20 +379,31 @@
                    //反关闭
                    case 'set_CancelCloseBill': set_CloseBill(2);
                        break;
                    //反关闭设置时间
                    case 'set_CancelCloseBillSetDate': set_CloseBillSetDate(2);
                        break;
                    //作废按钮        ï¼ˆ1:作废、2:反作废)
                    case 'btn-Drop':set_DropBill(1);
                        break;
                    //反作废按钮
                    case 'btn-DeDrop':set_DropBill(2);
                        break;
                    //退出按钮
                    case 'get_Exit': Pub_Close(2);
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                        break;
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //导入
                    case 'set_Excel': set_Excel();
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option, get_FastQuery);
                        break;
                    //按钮设置
                    case 'set_HideButton':
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        get_HideButton(btns, "3301", HModName, sessionStorage["HUserName"]);
                        get_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);
                        break;
                    //保存方案
                    case 'btn_SaveScheme': set_SaveScheme();
@@ -433,6 +453,7 @@
                //获取登录页组织列
                $.ajax({
                    type: "get",
                    async: false,
                    url: GetWEBURL() + "/Web/GetOrganizations",
                    success: function (result) {
                        var Organization = "";
@@ -490,13 +511,18 @@
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化表格
                set_InitGrid();
                Organ();
                //查询
                //get_FastQuery(1);
                //获取项目号
                Get_HProject();
                //查询
                get_FastQuery(1);
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
                $("#HBenchmarkValue").val(localStorage["HBenchmarkValue"])
            }
            //#endregion
@@ -505,6 +531,7 @@
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-150'
                    , title: '工艺路线'
                    , page: false
                    , limit: 50
                    , done: function (res, curr, count) {
@@ -818,7 +845,7 @@
                                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: '单据号' });
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号'});
                                } else {
                                    switch (data[i].Type) {
                                        //int
@@ -871,8 +898,15 @@
                            option.data = result;
                            //刷新表格数据
                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData)
                            table.render(option);
                            //刷新按钮显示
                            Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);
                            layer.close(ajaxLoad);
                            DisPlay_HideColumn();
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }
@@ -971,7 +1005,7 @@
                            com2 = "not like''%" + ColContent2 + "%''";
                            break;
                        default:
                            com2 = "" + Comparator + "''" + ColContent + "''";
                            com2 = "" + Comparator2 + "''" + ColContent2 + "''";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
@@ -993,12 +1027,12 @@
                if (HProID != 0 && HProID != "undefined" && HProID != null) {
                    sWhere += " and HMainProcID = " + HProID;
                }
                if (number == 1) {
                    HOrgID = sessionStorage["OrganizationID"];
                }
                else {
                    HOrgID = $("#HOrgID").val();//组织
                }
                //if (number == 1) {
                //    HOrgID = sessionStorage["OrganizationID"];
                //}
                //else {
                //    HOrgID = $("#HOrgID").val();//组织
                //}
                if (HOrderProcNO) {
                    sWhere += " and å•据类型 like ''%" + HOrderProcNO + "%''";
@@ -1016,9 +1050,9 @@
                if (WorkCenter) {
                    sWhere += " and å•据号 like ''%" + WorkCenter + "%''";
                }
                if (HOrgID) {
                    sWhere += " and HOrgID = ''" + HOrgID + "''";
                }
                //if (HOrgID) {
                //    sWhere += " and HOrgID = ''" + HOrgID + "''";
                //}
                if (number == 2) {
                    if (HProject != '0') {
                        sWhere += " and é¡¹ç›®å· like ''%" + HProject + "%''";
@@ -1026,6 +1060,9 @@
                }
                sWhere += " and å·¥åºä»£ç  != ''9999'' and HBillSubType<>''SUB''"
                sWhere += getOrgIDByUser();//用户关联组织查询过滤
                //判断权限
                if (PermissionJudge() == true) {
                    get_DisplayPage(sWhere);
@@ -1041,6 +1078,7 @@
                $.ajax({
                    url: GetWEBURL() + '/Gy_RoutingBill/page',
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
@@ -1059,7 +1097,7 @@
                                if ($.inArray(data[i].name, titleData) > -1) {//检查data【i】.name是否在数组中  //计算列
                                    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: '单据号' });
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号', style:"color:blue; cursor: pointer;" });
                                } else {
                                    switch (data[i].Type) {
                                        //int
@@ -1097,16 +1135,22 @@
                                }
                            }
                            option.data = result;
                            laypage.render(optionPage);
                            debugger
                            //刷新表格数据
                            DisPlay_HideColumn();
                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData)
                            laypage.render(optionPage);
                            debugger
                            layer.close(ajaxLoad);
                            ins = table.render(option);
                            //刷新按钮显示
                            Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);
                            if ($("#ColName option").length < 1) {
                                ColFilter();
                            }
                            //layer.alert("查询成功", { icon: 1 });
                            layer.close(ajaxLoad);
                        } else {
                            //option.data = [[]]
                            //table.render(option);
@@ -1132,7 +1176,7 @@
                    , content: '../工艺路线/Gy_RoutingBill.html?OperationType=1&linterid=&HSouceBillType=3301&linteridSub=-1'
                    , end: function () {
                        //刷新页面,
                        location.reload();
                        get_FastQuery(2);
                    }
                })
            }
@@ -1149,7 +1193,7 @@
                    , content: '../工艺路线/Gy_RoutingBill.html?OperationType=1&linterid=&HSouceBillType=SUB&linteridSub=-1'
                    , end: function () {
                        //刷新页面,
                        location.reload();
                        get_FastQuery(2);
                    }
                })
            }
@@ -1161,8 +1205,6 @@
                if (checkStatus.data.length === 1) {
                    var linterid = data[0].HItemID;
                    //var linteridSub = data[0].hsubid;
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
@@ -1171,7 +1213,7 @@
                        , content: '../工艺路线/Gy_RoutingBill.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=3301'
                        , end: function () {
                            //刷新页面,
                            location.reload();
                            get_FastQuery(2);
                        }
                    })
                } else {
@@ -1203,7 +1245,7 @@
                                            //关闭当前frame
                                            layer.close(wait);
                                            //修改为功后刷新界面
                                            window.location.reload();
                                            get_FastQuery(2);
                                        });
                                    } else {
                                        layer.alert(result.code + result.Message, { icon: 5 });
@@ -1250,6 +1292,31 @@
                        layer.closeAll("loading");
                    }
                })
            }
            //#endregion
            //#region æ ¹æ®ç”¨æˆ·èŽ·å–ç”¨æˆ·å…³è”ç»„ç»‡çš„è¿‡æ»¤æ¡ä»¶
            function getOrgIDByUser() {
                var res = "";
                $.ajax({
                    type: "GET",
                    async: false,
                    url: GetWEBURL() + "/Xt_User/getOrgIDListByUser", //方法所在页面和方法名       ä¼ å‚ ç»„织必须是列表头部查询的组织  ä¸èƒ½ä½¿ç”¨ç”¨æˆ·é»˜è®¤
                    data: { "UserID": sessionStorage["Czybm"], "UserName": sessionStorage["HUserName"], HOrgID: $("#HOrgID").val() },
                    success: function (result) {
                        if (result.count == 1) {
                            if (result.data[0].sWhere == "1") {
                                res = " and HOrgID = ''" + $("#HOrgID").val() + "''";
                            } else {
                                res = result.data[0].sWhere;
                            }
                        }
                    }, error: function (err) {
                        res = " and 1 = 0";
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                return res;
            }
            //#endregion
@@ -1314,7 +1381,7 @@
                        , content: '../工艺路线/Gy_RoutingBill.html?OperationType=2&linterid=' + linterid + '&HSouceBillType=3301'
                        , end: function () {
                            //刷新页面,
                            location.reload();
                            get_FastQuery(2);
                        }
                    })
                } else {
@@ -1324,8 +1391,8 @@
            //#region åˆ·æ–°
            function get_Refresh() {
                set_ClearQuery();
                get_DisplayPage(sWhere);
                get_FastQuery(2);
            }
            //启用默认
@@ -1333,7 +1400,7 @@
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (data.length == 1) {
                if (data.length == 1 && data[0].状态!="关闭") {
                    layer.confirm("确认要启用该工艺路线为物料默认工艺路线吗?", function (index) {
                        var wait = layer.load();
                        var HInterID = data[0].hmainid;
@@ -1357,7 +1424,7 @@
                        });
                    })
                } else {
                    layer.msg("请选择一条数据!");
                    layer.msg("请选择一条未关闭的数据!");
                }
            }
@@ -1365,7 +1432,7 @@
            function set_closeOtherRoute() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1 && checkStatus.data[0]["审核人"]=="") {
                if (checkStatus.data.length === 1 && data[0].状态 != "关闭") {
                    var hmainid = data[0].hmainid.toString();
                    var HName = data[0]["工艺名称"].toString();
                    var HMaterID = data[0]["HMaterID"].toString();
@@ -1523,6 +1590,14 @@
                                layer.alert("接口请求失败!", { icon: 5 });
                                layer.close(wait);
                            }
                            , end: function () {
                                ////修改为功后刷新界面
                                //if (get_needClose_Bar == 0) {
                                $("#btnSearch").trigger('click');
                                //} else if (get_needClose_Bar == 1) {
                                //    $("#get_needClose").trigger('click');
                                //}
                            }
                        });
                    })
                }
@@ -1531,7 +1606,138 @@
                }
            }
            //关闭  [1 å…³é—­ã€2 åå…³é—­]
            function set_CloseBillSetDate(num) {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                var HInterID = data[0].hmainid;
                if (data.length == 1) {
                    // å¼¹å‡ºå±‚
                    layer.open({
                        type: 1,
                        title: '设置时间范围',
                        area: ['500px', '300px'],
                        content: `
                        <div class="layui-form" style="padding: 20px;">
                            <div class="layui-form-item">
                            <label class="layui-form-label">开始时间</label>
                            <div class="layui-input-block">
                                <input type="date" class="layui-input" id="startTime" placeholder="请选择开始时间">
                            </div>
                            </div>
                            <div class="layui-form-item">
                            <label class="layui-form-label">结束时间</label>
                            <div class="layui-input-block">
                                <input type="date" class="layui-input" id="endTime" placeholder="请选择结束时间">
                            </div>
                            </div>
                            <div class="layui-form-item">
                            <div class="layui-input-block" style="margin-left: 0; text-align: center;">
                                <button class="layui-btn" id="confirmTime">确定</button>
                                <button class="layui-btn layui-btn-primary" id="cancelTime">取消</button>
                            </div>
                            </div>
                        </div> `,
                        success: function (layero, index) {
                            $("#startTime").val(Format(new Date(), "yyyy-MM-dd"));
                            // èŽ·å–å½“å‰æ—¥æœŸ
                            const currentDate = new Date();
                            // åˆ›å»ºæ–°æ—¥æœŸå¯¹è±¡ï¼ˆé¿å…ä¿®æ”¹åŽŸæ—¥æœŸï¼‰
                            const after30Days = new Date(currentDate);
                            // è®¾ç½®æ—¥æœŸä¸ºå½“前日期 + 30天
                            after30Days.setDate(currentDate.getDate() + 30);
                            $("#endTime").val(Format(after30Days, "yyyy-MM-dd"));
                            // ç¡®å®šæŒ‰é’®ç‚¹å‡»äº‹ä»¶
                            $('#confirmTime').on('click', function () {
                                var startTime = $('#startTime').val();
                                var endTime = $('#endTime').val();
                                if (!startTime) {
                                    layer.msg('请选择开始时间', { icon: 2 });
                                    return;
                                }
                                if (!endTime) {
                                    layer.msg('请选择结束时间', { icon: 2 });
                                    return;
                                }
                                if (new Date(endTime) < new Date(startTime)) {
                                    layer.msg('结束时间不能早于开始时间', { icon: 2 });
                                    return;
                                }
                                $.ajax({
                                    url: GetWEBURL() + '/Gy_RoutingBill/CloseSetDate',
                                    type: "GET",
                                    data: { "HInterID": HInterID, "Type": num, "user": sessionStorage["HUserName"], "HBillSubType": "", "HBeginDate": startTime, "HEndDate": endTime},
                                    success: function (result) {
                                        if (result.count == 1) {
                                            // è¿™é‡Œå¯ä»¥å¤„理获取到的时间范围
                                            layer.msg('时间范围已设置:' + startTime + ' è‡³ ' + endTime, { icon: 1 });
                                            // å…³é—­å¼¹å±‚
                                            layer.close(index);
                                            $("#btnSearch").trigger('click');
                                        } else {
                                            layer.alert(result.code + result.Message, { icon: 5 });
                                            // å…³é—­å¼¹å±‚
                                            layer.close(index);
                                        }
                                    }, error: function () {
                                        layer.alert("接口请求失败!", { icon: 5 });
                                        // å…³é—­å¼¹å±‚
                                        layer.close(index);
                                    }
                                });
                            });
                            // å–消按钮点击事件
                            $('#cancelTime').on('click', function () {
                                layer.close(index);
                            });
                        },
                    })
                }
                else {
                    layer.msg("请选择一条数据!");
                }
            }
            //#region åä½œåºŸ/作废数据 [1 ä½œåºŸã€2 åä½œåºŸ]
            function set_DropBill(num) {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var InterID = data[0].hmainid.toString();
                    //逻辑审核方法
                    $.ajax({
                        type: "GET",
                        url: GetWEBURL() + "Gy_RoutingBill/DeleteGy_RoutingBill", //方法所在页面和方法名
                        data: { "HInterID": InterID, "IsAudit": num, "CurUserName": sessionStorage["HUserName"] },
                        success: function (result) {
                            if (result.count == 1) {
                                layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                    // å¾—到frame索引
                                    var index = layer.getFrameIndex(window.name);
                                    //关闭当前frame
                                    layer.close(index);
                                    //修改为功后刷新界面
                                    $("#btnSearch").trigger('click');
                                });
                            } else {
                                layer.alert(result.code + result.Message, { icon: 5 });
                            }
                        }, error: function () {
                            layer.alert("接口请求失败!", { icon: 5 });
                        }
                    });
                }
                else {
                    layer.msg('请选择一行数据审核!');
                }
            }
            //#endregion
            //#region å¯¼å‡ºExecel
            function get_Export() {
@@ -1553,11 +1759,21 @@
                                }
                                if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                    item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    item[itemobj] = item[itemobj].toString().replace(/,/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                                if (itemobj === '物料代码') {
                                    item[itemobj] = item[itemobj].replace(/,/g, ',');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                                }
                                if (itemobj === '物料名称') {
                                    item[itemobj] = item[itemobj].replace(/,/g, ',');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                                }
                                if (itemobj === '规格型号') {
                                    item[itemobj] = item[itemobj].replace(/,/g, ',');  // æ›¿æ¢è‹±æ–‡é€—号为中文逗号
                                }
                            }
                        });
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, data, "xls");
                            table.exportFile('mainTable', data, "xls");
                            layer.close(wait);
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
@@ -1570,6 +1786,22 @@
                });
            }
            //#endregion
            //导入
            function set_Excel() {
                layer.open({
                    type: 2
                    , skin: 'layui-layer-rim' //加上边框
                    , area: ['100%', '100%']
                    , title: '工艺路线列表-导入'
                    , shift: 0//弹出动画
                    , content: '../工艺路线/Gy_RoutingBillimport.html'
                    , end: function () {
                        //刷新页面,
                        get_FastQuery();
                    }
                })
            }
            //#region èŽ·å–å¯¼å‡ºæ•°æ®
            function getExportData() {
@@ -1654,7 +1886,7 @@
                            com2 = "not like'%" + ColContent2 + "%'";
                            break;
                        default:
                            com2 = "" + Comparator + "'" + ColContent + "'";
                            com2 = "" + Comparator2 + "'" + ColContent2 + "'";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
@@ -1974,41 +2206,45 @@
            }
            //#endregion
            $("#HBenchmarkValue").on("input", function (e) {
                localStorage["HBenchmarkValue"] = e.delegateTarget.value;//基准值,用于添康计算约当系数:基准值/小时产能
            });
            //#endregion
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                var contentUrl = "";
                for (var i = 1; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["field"] + ",";
                }
                var urlStr = window.document.location.pathname;//获取文件路径
                var urlLen = urlStr.split('/');
                for (var i = 0; i < urlLen.length - 4; i++) {
                    contentUrl += "../";
                }
                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
            ////隐藏列设置
            //function get_HideColumn() {
            //    var colName = "";
            //    var contentUrl = "";
            //    for (var i = 1; i < option.cols[0].length; i++) {
            //        colName += option.cols[0][i]["field"] + ",";
            //    }
            //    var urlStr = window.document.location.pathname;//获取文件路径
            //    var urlLen = urlStr.split('/');
            //    for (var i = 0; i < urlLen.length - 4; i++) {
            //        contentUrl += "../";
            //    }
            //    colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName;
            //    contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName;
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: [contentUrl, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }
            //    layer.open({
            //        type: 2
            //        , skin: "layui-layer-rim" //加上边框
            //        , title: "隐藏列设置"  //标题
            //        , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
            //        , shift: 2 //弹出动画
            //        , area: ["50%", "90%"] //窗体大小
            //        , maxmin: true //设置最大最小按钮是否显示
            //        , content: [contentUrl, "yes"]
            //        , btn: ["确定", "取消"]
            //        , btn1: function (index, laero) {
            //            //刷新表格数据
            //            DisPlay_HideColumn();
            //            //更新表格缓存的数据
            //            layer.close(index);//关闭弹窗
            //        }
            //    })
            //}
            //显示列数据
            //function DisPlay_HideColumn() {
@@ -2108,104 +2344,104 @@
            //}
            //#region æ˜¾ç¤ºåˆ—数据
            function DisPlay_HideColumn() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    async: false,
                    data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {
            //function DisPlay_HideColumn() {
            //    $.ajax({
            //        url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
            //        type: "GET",
            //        async: false,
            //        data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
            //        success: function (data1) {
            //            if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
                            var newCols = [[]];//对应数据库列顺序col
                            newCols[0].push(option.cols[0][0]);//放入第一个checkbox
                            dataCol = data1.data[0].HGridString.split(',');
                            //列设置列数与页面列数是否一致
                            if (dataCol.length == option.cols[0].length - 1) {
                                //遍历寻找列设置对应列按顺序插入
                                for (var j = 0; j < option.cols[0].length - 1; j++) {
                                    for (var i = 0; i < option.cols[0].length - 1; i++) {
                                        var dataCols = dataCol[j].split('|');
                                        //选择与datacols相应列进行修改
                                        if (option.cols[0][i + 1]["field"] == dataCols[5]) {
                                            //隐藏列
                                            if (dataCols[1] == 1) {
                                                option.cols[0][i + 1]["hide"] = true;
                                            }
                                            //设置列宽
                                            if (dataCols[3] > 0) {
                                                option.cols[0][i + 1]["width"] = dataCols[3];
                                            }
                                            //设置内容字体大小
                                            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[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                                option.cols[0][i + 1]["hide"] = false;
                                            }
                                            //统计列
                                            if (dataCols[6] == 1) {
                                                option.cols[0][i + 1]["totalRow"] = true;
                                            }
                                            //字体所在位置(å·¦ å±…中 å³)
                                            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;
                                            }
                                            //设置表格title属性显示别名
                                            if (dataCols[4] != null && dataCols[4] != "") {
                                                option.cols[0][i + 1]["title"] = dataCols[4];
                                            }
                                            newCols[0].push(option.cols[0][i + 1]);
                                        }
                                    }
                                }
                                //遍历循环后判断对应列数是否一致
                                if (dataCol.length == newCols[0].length - 1) {
                                    option.cols = newCols;
                                    //取消冻结列
                                    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";
                                        }
                                    }
                                }
                            }
                            ins=table.render(option);
                        } else {
                            ins=table.render(option);
                        }
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, "3301", HModName, sessionStorage["HUserName"]);
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
            }
            //                var dataCol = [];//数据库查询出的列数据
            //                var titleData = [];//不需要显示的字段 å¯æ‰©å±•
            //                var newCols = [[]];//对应数据库列顺序col
            //                newCols[0].push(option.cols[0][0]);//放入第一个checkbox
            //                dataCol = data1.data[0].HGridString.split(',');
            //                //列设置列数与页面列数是否一致
            //                if (dataCol.length == option.cols[0].length - 1) {
            //                    //遍历寻找列设置对应列按顺序插入
            //                    for (var j = 0; j < option.cols[0].length - 1; j++) {
            //                        for (var i = 0; i < option.cols[0].length - 1; i++) {
            //                            var dataCols = dataCol[j].split('|');
            //                            //选择与datacols相应列进行修改
            //                            if (option.cols[0][i + 1]["field"] == dataCols[5]) {
            //                                //隐藏列
            //                                if (dataCols[1] == 1) {
            //                                    option.cols[0][i + 1]["hide"] = true;
            //                                }
            //                                //设置列宽
            //                                if (dataCols[3] > 0) {
            //                                    option.cols[0][i + 1]["width"] = dataCols[3];
            //                                }
            //                                //设置内容字体大小
            //                                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[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
            //                                    option.cols[0][i + 1]["hide"] = false;
            //                                }
            //                                //统计列
            //                                if (dataCols[6] == 1) {
            //                                    option.cols[0][i + 1]["totalRow"] = true;
            //                                }
            //                                //字体所在位置(å·¦ å±…中 å³)
            //                                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;
            //                                }
            //                                //设置表格title属性显示别名
            //                                if (dataCols[4] != null && dataCols[4] != "") {
            //                                    option.cols[0][i + 1]["title"] = dataCols[4];
            //                                }
            //                                newCols[0].push(option.cols[0][i + 1]);
            //                            }
            //                        }
            //                    }
            //                    //遍历循环后判断对应列数是否一致
            //                    if (dataCol.length == newCols[0].length - 1) {
            //                        option.cols = newCols;
            //                        //取消冻结列
            //                        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";
            //                            }
            //                        }
            //                    }
            //                }
            //                ins=table.render(option);
            //            } else {
            //                ins=table.render(option);
            //            }
            //            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
            //            Display_HideButton(btns, "3301", HModName, sessionStorage["HUserName"]);
            //        }, error: function () {
            //            layer.alert("接口请求失败!", { icon: 5 });
            //        }
            //    })
            //}
            //#endregion
@@ -2280,7 +2516,7 @@
                            //隐藏显示过滤方案的标签信息
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            //执行查询方法
                            get_FastQuery()
                            //get_FastQuery()
                            form.render("select");
                        }
                    }, error: function () {