MES-WEB-LayUI.git

parent: a1cc1415 | 补丁 | 提交 | ignore whitespace

wtt

2025-06-09 7c91fc11a8af30846d778e05c036992ef2e28fd1

三升添加发货计划平台

2个文件已修改

2个文件已添加

	WebTM/WebTM.csproj	5 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/WebTM.csproj.user	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/生产管理/发货计划平台（三升）/Xs_SendGoodsPlanForm.html	924 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/生产管理/发货计划平台（三升）/Xs_SendGoodsPlanImport.html	327 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebTM/WebTM.csproj

@@ -603,6 +603,8 @@
    <Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatForm.html" />
    <Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS_Sec.html" />
    <Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS.html" />
    <Content Include="views\çäº§ç®¡ç\åè´§è®¡åå¹³å°ï¼ä¸åï¼\Xs_SendGoodsPlanForm.html" />
    <Content Include="views\çäº§ç®¡ç\åè´§è®¡åå¹³å°ï¼ä¸åï¼\Xs_SendGoodsPlanImport.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Cg_PODemandPlanConfigBillReportForLack.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Gy_RoutingBillReportForLack.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_NeedMaterPlanConfigBillReportForLack.html" />
@@ -612,9 +614,6 @@
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_LockRequestBill.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_DayPlanPlatForm.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_LockRequestBillList.html" />
    <Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoExcel.html" />
    <Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoEdit.html" />
    <Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoList.html" />
    <Content Include="views\çäº§ç®¡ç\å¼å¸¸åé¦å\OA_ErrMsgBackSignBill_BrushCard.html" />
    <Content Include="views\çäº§ç®¡ç\å¼å¸¸åé¦å\Sc_MESExecptFeedBackBillResumeList.html" />
    <Content Include="views\çäº§ç®¡ç\å¼å¸¸åé¦å\Sc_MESExecptFeedBackBillType.html" />

 WebTM/WebTM.csproj.user

@@ -4,7 +4,7 @@
    <NameOfLastUsedPublishProfile>D:\æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\WorkBench\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <ProjectView>ShowAllFiles</ProjectView>
    <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>true</UseIISExpress>
    <Use64BitIISExpress />
    <IISExpressSSLPort />

 WebTM/views/Éú²ú¹ÜÀí/·¢»õ¼Æ»®Æ½Ì¨£¨ÈýÉý£©/Xs_SendGoodsPlanForm.html

New file
@@ -0,0 +1,924 @@
ï»¿<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>ä¸ååè´§è®¡åæäº§</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all">
    <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/soulTable.slim.js"></script>-->
    <script src="../../../layuiadmin/SetColumn.js"></script>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md13">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <div style="padding: 10px; ">
                            <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelImport" id="ExcelImport">Excelå¯¼å¥</button>-->
                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelDateImport" id="ExcelDateImport">å¯¼å¥</button>
                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnICMOBill" id="btnICMOBill">éå®è®¢åéå</button>
                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">ä¿å</button>
                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnTLYS" id="btnTLYS">ææè¿ç®</button>
                        </div>
                        <div class="layui-collapse resizable-container">
                            <div class="layui-colla-item">
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>æ´å¤</span>
                                    </div>
                                </div>
                                
                                <div class="layui-inline" style="display:none">
                                    <label class="layui-form-label" style="width: 85px;">ç»ç»</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                        <select name="HProdORGID" id="HProdORGID" lay-verify="HProdORGID">
                                            <!--å¨ææ¸²æç»ç»--> 
                                        </select>
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">æ¥è¯¢</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">éç½®</button>
                            </div>
                        </div>
                        <div id="HProgressBar"></div>
                        <div class="layui-row" style="padding:0px 0">
                            <table class="" id="mainTable" lay-filter="mainTable"></table>
                        </div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>å é¤è¡</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverUp"><i class="layui-icon layui-icon-delete"></i>ä¸ç§»</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverDown"><i class="layui-icon layui-icon-delete"></i>ä¸ç§»</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="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>
                            </div>
                        </script>
                        
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <!--<a class="layui-btn layui-btn-xs" lay-event="edit">ç¼è¾</a>-->
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">å é¤</a>
</script>
<script>
    var OptionData = [];
    var OptionData_Emp = [];
    layui.config({
        base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
    }).extend({
        index: 'lib/index', //ä¸»å¥å£æ¨¡å
        soulTable: 'soulTable'
    }).use(['index', 'form', 'table', 'element', 'laydate', 'util', 'soulTable','jquery'], function () {
        //#region å¬ç¨åé

        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , laydate = layui.laydate
            , soulTable = layui.soulTable
            , element = layui.element;
        var ins;
        var sWhere = "";
        var option = [];
        var HModName = "Xs_SendGoodsPlanBill";
        //ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±
        var titleData = [];
        var params = get_UrlVars();
        var HType = "";
        if (params[params[0]] != undefined) {
            HType = params[params[0]]; //ä»åæ°ä¸è·å
        }
        //#endregion

        //#region è¿å¥é¡µé¢å³å è½½


        //åå§åçé¢
        set_ClearBill();

        //#endregion

        //#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

        //è¡åé¼ æ ç¦»å¼äºä»¶
        table.on('edit(mainTable)', function (obj) {
            
        })


        //ç¹å»è¡éä¸æ°æ®
        table.on('row(mainTable)', 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('toolbar(mainTable)', function (obj) {
            var checkStatus = table.checkStatus('mainTable')
                , data = checkStatus.data;
            switch (obj.event) {
                //åè®¾ç½®
                case 'set_HideColumn':
                    get_HideColumnNoPage(HModName,'',option, get_FastQuery);
                    break;
                //å é¤è¡
                case 'set_DeleteBill':
                    set_DeleteBill();
                    break;
                //ä¸ç§»
                case 'set_MoverUp':
                    set_MoverUp(data);
                    break;
                //ä¸ç§»
                case 'set_MoverDown':
                    set_MoverDown(data);
                    break;
                //å¯¼åºexcel
                case 'get_export':
                    get_Export();
                    break;
            }
        });

        //å®å·¥å¯¼å¥
        form.on('submit(ExcelDateImport)', function () {
            btnExcelDateImport();
        });
        //ä¿å
        form.on('submit(btnSave)', function (data) {
            var HWorkShopID = $("#HWorkShopID").val();//çäº§è½¦é´
            if (HWorkShopID == 0) {
                return layer.msg("çäº§è½¦é´ä¸è½ä¸ºç©º!");
            } else if (table.cache["mainTable"].length == 0) {
                return layer.msg("æ æ°æ®,æ æ³ä¿å!");
            } else {
                var HYxjQty = 0;
                for (var i = 0; i < table.cache["mainTable"].length; i++) {
                    if (table.cache["mainTable"][i] != "") {
                        if (parseFloat(table.cache["mainTable"][i]["ä¼åçº§"]) == 0) {
                            HYxjQty++
                        }
                    }
                }
                if (HYxjQty > 0) {
                    layer.confirm('å½åæäº§é¡µé¢åå¨ä¼åçº§ä¸º0ççäº§è®¢åï¼æ¯å¦ç»§ç»è¿è¡ä¿åï¼', {
                        title: "æä½æç¤º",
                        icon: 0,
                        btn: ['ç¡®è®¤', 'åæ¶']
                    }, function (index, layero) {
                        //ç¡®è®¤
                        set_AddNew();
                    }, function (index) {
                        //åæ¶
                        return
                    });
                } else {
                    set_AddNew();
                }
            }
        });


        //å¿«éè¿æ»¤
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery(2);
        });

        //éç½®
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();
        });
        //ææè¿ç®
        form.on('submit(btnTLYS)', function (data) {
            if (set_ModCheck("Sc_WorkBillSortBill_tlys") == true) {
                layer.confirm('ä½ ç¡®å®è¦æ§è¡æä½åï¼è¯·åç¡®ä¿æäº§æ°æ®å·²ä¿åï¼', {
                    btn: ['ç¡®å®', 'åæ¶'] //æé®
                    , btn1: function (index, layero) {
                        get_btnTLYS();
                        layer.close(index);
                    }
                })
            }
            
        })



        //è¡åäºä»¶
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //è¡åå é¤
            set_GridCellCheck(obj); //è¡åå¿«æ·é®çé

            //#region ä¿®æ¹æ¶é´
            var data = obj.data;
            //æ¥è®¡åçäº§æ¥æ
            if (obj.event == 'HPlanEndDate') {
                var field = $(this).data('field');
                laydate.render({
                    elem: this.firstChild
                    , show: true //ç´æ¥æ¾ç¤º
                    , closeStop: this
                    , done: function (nowDate) {
                        //æ¶é´éæ©å®æï¼è¡æ°æ®æ´æ°
                        data[field] = nowDate;
                        obj.update(data);
                    }
                });
            }


            //#endregion
        });


        
        //#endregion

        //#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³
        //æéå¤å®
        function set_ModCheck(ModRightNameCheck) {
            var Permission = false;
            $.ajax({
                type: "GET",
                url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
                async: false,
                data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                success: function (result) {
                    if (result.count == 1) {
                        Permission = true;
                    } else {
                        layer.alert("å½åæ¨¡åæ²¡ææ¥è¯¢æé!", { icon: 5 });
                    }
                }, error: function () {
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
            return Permission;
        }

        //#region åå§åçé¢
        function set_ClearBill() {
            //ç»ç»
            Organ();
            //åå§åè¡¨æ ¼
            set_InitGrid();
            get_FastQuery();
        }
        //#endregion

        


        //è·åç»ç»
        function Organ() {
            //è·åç»å½é¡µç»ç»å
            $.ajax({
                type: "get",
                url: GetWEBURL() + "/Web/GetOrganizations",
                success: function (result) {
                    var Organization = "";
                    if (result.count == 1) { // è¯´æéªè¯æåäºï¼
                        var data = result.data;
                        for (var i = 0; i < data.length; i++) {
                            Organization += '<option  style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
                        }
                        $("#HProdORGID").append(Organization);
                        $("#HProdORGID").val(sessionStorage["OrganizationID"])
                        form.render('select');
                    }
                    layer.closeAll("loading");
                }
            })
        }

        //è¡¨æ ¼æ°æ®
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , title: "åè´§è®¡åæ¥è¡¨"
                , height: 'full-175'
                , page: false
                , cellMinWidth: 90
                , cols: [[]]
                , limit: Number.MAX_VALUE//é»è®¤æ¾ç¤ºå¨é¨
                , contextmenu: {
                    // è¡¨æ ¼åå®¹å³é®èåéç½®
                    body: [
                        {
                            name: 'å¤å¶',
                            icon: 'layui-icon layui-icon-template',
                            click: function (obj) {
                                soulTable.copy(obj.text)
                                layer.msg('å¤å¶æåï¼')
                            }
                        },
                        {
                            name: 'è¡-èè²',
                            click: function (obj) {
                                obj.trElem.css('background', '#01AAED')
                            }
                        },
                        {
                            name: 'çº¢è²',
                            click: function (obj) {
                                obj.elem.css('color', 'red')
                            }
                        }
                    ]
                }
                , even: true//è¡ææ½
                , rowDrag: {/*trigger: 'row',*/
                    done: function (obj) {
                        // å®ææ¶ï¼æ¾å¼æ¶ï¼è§¦å
                        // å¦ææå¨ååæå¨åæ ååï¼åä¸ä¼è§¦åæ¤æ¹æ³
                        console.log(obj.row) // å½åè¡æ°æ®
                        console.log(obj.cache) // æ¹å¨åå¨è¡¨æ°æ®
                        console.log(obj.oldIndex) // åæ¥çæ°æ®ç´¢å¼
                        console.log(obj.newIndex) // æ¹å¨åæ°æ®ç´¢å¼

                        console.log(table.cache["mainTable"]) // æ¹å¨åæ°æ®ç´¢å¼

                        option.data = table.cache["mainTable"];
                    }
                }
                , sort: function (obj) { // æåºäºä»¶
                    // è·åå½åæåºçåæ®µåæåºç±»å
                    var field = obj.field;
                    var type = obj.type;
                    data.sort(function (a, b) {
                        return type === 'asc' ? (a[field] - b[field]) : (b[field] - a[field]);
                    });
                    // éæ°æ¸²æè¡¨æ ¼
                    table.reload('test', {
                        data: data
                    });
                }
                , done: function (res, page, count) {
                    soulTable.render(this);
                    //$('.layui-table thead').on('click', 'th', function () {
                    //    // è·åç¹å»çè¡¨å¤´ç field å¼
                    //    var field = $(this).data('field');
                    //    set_InitGrid1(field);
                    //    sWhere = {
                    //        HORGID: sessionStorage["OrganizationID"]
                    //        , HBEGINDATE: field
                    //        , HENDDATE: field
                    //    }
                    //    //get_Display_3(JSON.stringify(sWhere));
                    //});
                    //res.data.forEach(function (item, index) {
                    //    if (data1.data.DataColor != undefined) {
                    //        var sj = data1.data.DataColor;
                    //        //ç¦ç¨å¤éæ¡ï¼è®¾ç½®ä¸å¯éä¸æ è¯ï¼å°è¯¥è¡è®¾ç½®ä¸ºé´å½±è²
                    //        var tr = $(".layui-table tr[data-index=" + index + "]");
                    //        var td = tr.children('td'); //è·åträ¸ææçtd
                    //        if (sj.length > index) {
                    //            for (var i = 1; i < td.length; i++) {
                    //                var title = option.cols[0][i].field;
                    //                if (sj[index][title] != "" && sj[index][title] != null) {
                    //                    td.eq(i).css("background-color", sj[index][title]);
                    //                }
                    //            }
                    //        }
                    //    }
                    //})
                }
            }
        }

        //æ¥è¯¢å è½½æ°æ®
        function get_Display(sql) {
            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/CommonModel/searchMethod',
                type: "GET",
                async: true,
                data: { "sql": sql, "user": sessionStorage["HUserName"],"ModRightNameCheck":"" },
                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 });
                            //è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çåä¸æ¾ç¤ºï¼
                            var patrn = new RegExp(/^h/i);
                            if (patrn.test(data1.list[key].ColmCols)) {
                                titleData[key] = data1.list[key].ColmCols;
                            }
                        }
                        //å¨åè¡¨å·¦è¾¹æ·»å å¾éæ¡
                        col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'åè®¡è¡' });
                        for (var i = 0; i < data.length; i++) {
                            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: 'HPlanEndDate', templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", filter: true
                                });
                            }
                            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: 200 });
                                        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, filter: true });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, filter: true });
                                }
                            }
                        }

                        option.cols = [col];
                        option.data = data1.data;
                        //åè®¾ç½®
                        DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData);
                        ins = table.render(option);
                        
                        layer.close(ajaxLoad);
                        

                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //Excelå®å·¥æ¥æå¯¼å¥
        function btnExcelDateImport() {
            layer.open({
                type: 2
                , skin: 'layui-layer-rim' //å ä¸è¾¹æ¡
                , area: ['100%', '100%']
                , title: 'åè´§è®¡åäº¤æå¯¼å¥'
                , shift: 0//å¼¹åºå¨ç»
                , content: '../åè´§è®¡åå¹³å°ï¼ä¸åï¼/Xs_SendGoodsPlanImport.html?OperationType=1'
                , end: function () {
                    //å·æ°é¡µé¢,
                    location.reload();
                }
            })
        }

        //å¿«éè¿æ»¤
        function get_FastQuery() {
            sWhere = "select * from h_v_Xs_SendGoodsPlanBillList where 1=1 and (éè´è®¢åå³éç¶æ='A' or éè´è®¢åå³éç¶æ is null) and éå®è®¢åå³éç¶æ='A'"
            get_Display(sWhere);
            sWhere = ""//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
        }

        //éç½®
        function set_ClearQuery() {
            
            form.render('select');
            sWhere = "";
        }
        //ææè¿ç®
        function get_btnTLYS() {
            var ajaxLoad = layer.load();
            var sql = "exec h_p_JIT_PODemandPlanBill_SendGoodsPlan " + sessionStorage["HUserName"] + ",'" + sessionStorage["OrganizationID"] + "'";
            $.ajax({
                url: GetWEBURL() + '/CommonModel/searchMethod',
                type: "GET",
                async: false,
                data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ""},
                success: function (data1) {
                    if (data1.count == 1) {
                        get_FastQuery(2);
                        layer.msg(data1.data[0]["Column1"]);
                        layer.close(ajaxLoad);
                    } else {
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //è¡åå é¤
        function set_GridDelete(obj) {
            var data = obj.data;
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('ççå é¤è¡åï¼', function (index) {
                    //if (rowIndex === '0' && table.cache["mainTable"].length==1) {
                    //    layer.msg('é¦è¡æ æ³å é¤ï¼ï¼ï¼');
                    //} else {
                    //    obj.del();
                    //    table.cache["mainTable"].splice(rowIndex, 1);  //â¡å½»åºç§»é¤åç´ ï¼ä»ç¼åéç§»é¤è¿ä¸è¡
                    //    option.data = table.cache["mainTable"];//å°æ°æ®ç»å®å°dataä¸
                    //    table.render(option);
                    //    //table.reload(option);
                    //    layer.close(index);
                    //}
                    //åå é¤
                    if (obj.data.hmainid == "" && obj.data.åæ®å· == "") {
                        obj.del();
                        table.cache["mainTable"].splice(rowIndex, 1);  //â¡å½»åºç§»é¤åç´ ï¼ä»ç¼åéç§»é¤è¿ä¸è¡
                        option.data = table.cache["mainTable"];//å°æ°æ®ç»å®å°dataä¸
                        table.render(option);
                        //table.reload(option);
                        layer.close(index);
                    } else {//çå é¤
                        var HInterID = [];
                        HInterID.push(obj.data.hmainid); //è·åç¼å·
                        $.ajax({
                            url: GetWEBURL() + '/Xs_SendGoodsPlanBill/Delete'
                            , type: "GET"
                            , data: { "HInterID": HInterID.toString(),"User": 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);
                                        //ä¿®æ¹ä¸ºååå·æ°çé¢
                                        get_FastQuery(2);
                                        ////éè½½tree
                                        //tree.reload('treeDepartment', {});

                                        setTimeout(function () {
                                            if (layuiTable != null && layuiTable.length > 0) {
                                                $('.layui-table-main').scrollTop(scrollTop)
                                            }
                                        }, 100)
                                    });
                                } else {
                                    layer.alert(result.code + result.Message, { icon: 5 });
                                }
                            }
                            , error: function (err) {
                                layer.alert("æ¥å£è¯·æ±å¤±è´¥!" + err, { icon: 5 });
                            }
                        })
                    }
                });
            }
        }

        //å é¤è¡
        function set_DeleteBill() {
            var CheckStatus = table.checkStatus("mainTable");
            var scrollTop = 0;
            var layuiTable = $('.layui-table-main');
            if (layuiTable != null && layuiTable.length > 0) {
                scrollTop = layuiTable[0].scrollTop;
            }
            if (CheckStatus.data.length == 0) {
                return layer.msg("è¯·éæ©æ°æ®!")
            } else {
                layer.confirm('æ¨ç¡®å®è¦å é¤åï¼', {
                    btn: ['ç¡®å®', 'åæ¶'] //æé®
                    , btn1: function () {
                        var HInterID = [];
                        for (var i = 0; i < CheckStatus.data.length; i++) {
                            HInterID.push(CheckStatus.data[i].hmainid); //è·åç¼å·
                        }
                        $.ajax({
                            url: GetWEBURL() + '/Xs_SendGoodsPlanBill/Delete'
                            , type: "GET"
                            , data: { "HInterID": HInterID.toString(), "User": 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);
                                        //ä¿®æ¹ä¸ºååå·æ°çé¢
                                        get_FastQuery(2);
                                        ////éè½½tree
                                        //tree.reload('treeDepartment', {});

                                        setTimeout(function () {
                                            if (layuiTable != null && layuiTable.length > 0) {
                                                $('.layui-table-main').scrollTop(scrollTop)
                                            }
                                        }, 100)
                                    });
                                } else {
                                    layer.alert(result.code + result.Message, { icon: 5 });
                                }
                            }
                            , error: function (err) {
                                layer.alert("æ¥å£è¯·æ±å¤±è´¥!" + err, { icon: 5 });
                            }
                        })
                    }
                })
            }
        }

        //ä¸ç§»
        function set_MoverUp(data) {
            if (data.length != 1) {
                layer.msg("è¯·éæ©ä¸è¡æ°æ®ï¼");
            } else if (option.data[0]["hmainid"] == data[0]["hmainid"]) {
                layer.msg("é¦è¡æ°æ®æ æ³ç§»å¨ï¼");
            } else {
                var scrollTop = 0;
                var layuiTable = $('.layui-table-main');
                if (layuiTable != null && layuiTable.length > 0) {
                    scrollTop = layuiTable[0].scrollTop;
                }
                var tables = [];
                for (var i = 0; i < option.data.length; i++) {
                    if (option.data[i]["hmainid"] == data[0]["hmainid"]) {
                        tables.push(option.data[i - 1]);
                        data[0].LAY_CHECKED = true;
                        option.data[i - 1] = data[0];
                        option.data[i] = tables[0];
                        table.render(option);
                        break;
                    }
                }
                setTimeout(function () {
                    if (layuiTable != null && layuiTable.length > 0) {
                        $('.layui-table-main').scrollTop(scrollTop)
                    }
                }, 100)
            }
        }

        //ä¸ç§»
        function set_MoverDown(data) {
            if (data.length != 1) {
                layer.msg("è¯·éæ©ä¸è¡æ°æ®ï¼");
            } else
            if (option.data[option.data.length - 1]["hmainid"] == data[0]["hmainid"]) {
                layer.msg("æ«è¡æ°æ®æ æ³ç§»å¨ï¼");
            } else {
                var scrollTop = 0;
                var layuiTable = $('.layui-table-main');
                if (layuiTable != null && layuiTable.length > 0) {
                    scrollTop = layuiTable[0].scrollTop;
                }
                var tables = [];
                for (var i = 0; i < option.data.length; i++) {
                    if (option.data[i]["hmainid"] == data[0]["hmainid"]) {
                        var len = data.length;
                        tables.push(option.data[i + len]);
                        for (var j = 0; j < len; j++) {
                            data[j].LAY_CHECKED = true;
                            option.data[i + 1 + j] = data[j];
                        }
                        option.data[i] = tables[0];
                        table.render(option);
                        break;
                    }
                }
                setTimeout(function () {
                    if (layuiTable != null && layuiTable.length > 0) {
                        $('.layui-table-main').scrollTop(scrollTop)
                    }
                }, 100)
            }
        }

        //ä¿å
        function set_AddNew() {

            //å é¤åè¡¨æ°æ® ä¼å ç¨æ°ç»çä½ç½®,éè¦éæ°æä¸ä¸é¡ºåº
            var num = [];
            for (var i = 0; i < table.cache["mainTable"].length; i++) {
                if (table.cache["mainTable"][i] != "") {
                    table.cache["mainTable"][i].LAY_TABLE_INDEX = i;
                    num.push(table.cache["mainTable"][i])
                }
            }

            //var sMainStr = JSON.stringify(data.field);
            var sSubStr = JSON.stringify(num);
            var sMainSub = sSubStr +"&å" + sessionStorage["HUserName"];

            var index = layer.load();
            $.ajax({
                type: "POST",
                url: GetWEBURL() + "/Xs_SendGoodsPlanBill/btnSave",
                async: true,
                data: { "sMainSub": sMainSub },
                dataType: "json",
                success: function (data) {
                    if (data.count == 1) {
                        
                        get_FastQuery(2);
                        
                        layer.close(index);
                        layer.msg("ä¿åæå");
                    }
                    else {
                        layer.close(index);
                        layer.msg(data.Message, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
                    }
                },
                error: function (err) {
                    layer.close(index);
                    layer.msg("éè¯¯:" + err, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
                }
            });
        }

        //è¡åå¿«æ·é®
        function set_GridCellCheck(obj) {
            $(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
                if (event.key == "F7") {
                    //çäº§èµæº
                    if (obj.event == "HSourceID") {
                        layer.open({
                            type: 2
                            , skin: "layui-layer-rim" //å ä¸è¾¹æ¡
                            , title: "çäº§èµæºåè¡¨"  //æ é¢
                            , closeBtn: 1  //çªä½å³ä¸è§å³é ç æ ·å¼
                            , shift: 2 //å¼¹åºå¨ç»
                            , area: ["90%", "90%"] //çªä½å¤§å°
                            , maxmin: true //è®¾ç½®æå¤§æå°æé®æ¯å¦æ¾ç¤º
                            , content: ["../../åºç¡èµæ/çäº§åºç¡èµæ/Gy_Source.html?Htype=çäº§çº¿", "yes"]
                            , btn: ["ç¡®å®", "åæ¶"]
                            , btn1: function (index, laero) {
                                //æé®ä¸  çåè°
                                var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢
                                var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ®

                                if (checkStatus.data.length != 1) {
                                    return layer.msg("è¯·éæ©ä¸æ¡æ°æ®");
                                }
                                OptionData[0] = checkStatus.data[0];
                                //æ´æ°è¡¨æ ¼ç¼åçæ°æ®
                                obj.update({
                                    "HSourceID": checkStatus.data[0].HItemID
                                    , "çäº§èµæº": checkStatus.data[0].çäº§èµæºåç§°
                                })
                                layer.close(index);//å³éå¼¹çª
                            }
                            , end: function () {
                                if (OptionData.length > 0) {
                                    obj.update({
                                        "HSourceID": OptionData[0].HItemID
                                        , "çäº§èµæº": OptionData[0].çäº§èµæºåç§°
                                    })
                                    OptionData = [];
                                }
                            }
                        })
                    }

                    //æä½å·¥
                    if (obj.event == "HEmpID") {
                        layer.open({
                            type: 2
                            , skin: "layui-layer-rim" //å ä¸è¾¹æ¡
                            , title: "åå·¥åè¡¨"  //æ é¢
                            , closeBtn: 1  //çªä½å³ä¸è§å³é ç æ ·å¼
                            , shift: 2 //å¼¹åºå¨ç»
                            , area: ["90%", "90%"] //çªä½å¤§å°
                            , maxmin: true //è®¾ç½®æå¤§æå°æé®æ¯å¦æ¾ç¤º
                            , content: ["../../åºç¡èµæ/å¬ç¨åºç¡èµæ/Gy_EmployeeList.html?Htype=HEmp", "yes"]
                            , btn: ["ç¡®å®", "åæ¶"]
                            , btn1: function (index, laero) {
                                //æé®ä¸  çåè°
                                var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢
                                var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ®

                                if (checkStatus.data.length != 1) {
                                    return layer.msg("è¯·éæ©ä¸æ¡æ°æ®");
                                }
                                OptionData_Emp[0] = checkStatus.data[0];
                                //æ´æ°è¡¨æ ¼ç¼åçæ°æ®
                                obj.update({
                                    "HEmpID": checkStatus.data[0].HItemID
                                    , "æä½å·¥": checkStatus.data[0].èååç§°
                                })
                                layer.close(index);//å³éå¼¹çª
                            }
                            , end: function () {
                                if (OptionData_Emp.length > 0) {
                                    obj.update({
                                        "HEmpID": OptionData_Emp[0].HItemID
                                        , "æä½å·¥": OptionData_Emp[0].èååç§°
                                    })
                                    OptionData_Emp = [];
                                }
                            }
                        })
                    }

                    obj.event = "";
                    return false;
                } else if (event.key == "F8") {
                    //çäº§èµæº
                    if (obj.event == "HSourceID") {
                        layer.open({
                            type: 2
                            , skin: "layui-layer-rim" //å ä¸è¾¹æ¡
                            , title: "çäº§èµæºåè¡¨"  //æ é¢
                            , closeBtn: 1  //çªä½å³ä¸è§å³é ç æ ·å¼
                            , shift: 2 //å¼¹åºå¨ç»
                            , area: ["90%", "90%"] //çªä½å¤§å°
                            , maxmin: true //è®¾ç½®æå¤§æå°æé®æ¯å¦æ¾ç¤º
                            , content: ["../../Baseset/åºç¡èµæ/Gy_Source.html?HMaterID=" + obj.data["HMaterID"], "yes"]
                            , btn: ["ç¡®å®", "åæ¶"]
                            , btn1: function (index, laero) {
                                //æé®ä¸  çåè°
                                var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢
                                var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ®

                                if (checkStatus.data.length != 1) {
                                    return layer.msg("è¯·éæ©ä¸æ¡æ°æ®");
                                }
                                OptionData[0] = checkStatus.data[0];
                                //æ´æ°è¡¨æ ¼ç¼åçæ°æ®
                                obj.update({
                                    "HSourceID": checkStatus.data[0].HItemID
                                    , "çäº§èµæº": checkStatus.data[0].HName
                                })
                                layer.close(index);//å³éå¼¹çª
                            }
                            , end: function () {
                                if (OptionData.length > 0) {
                                    obj.update({
                                        "HSourceID": OptionData[0].HItemID
                                        , "çäº§èµæº": OptionData[0].HName
                                    })
                                    OptionData = [];
                                }
                            }
                        })
                    }
                    obj.event = "";
                }
            })
        }


        function get_Export() {
            var data = option.data
            data.forEach((item) => {
                // å¦ææä¸ªåæ®µçå¼å¤ªé¿ï¼éè¦å»é¤æ¢è¡ç¬¦
                if (item.è§æ ¼åå·.length > 0) {  // åè®¾åæ®µåä¸ºfield
                    item.è§æ ¼åå· = item.è§æ ¼åå·.replace(/[\r\n]+/g, '');  // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
                    item.è§æ ¼åå· = item.è§æ ¼åå·.replace(/[,]+/g, 'ï¼');  // å°æ¢åå·æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
                }
            });
            table.exportFile(ins.config.id, data, "xls");
        }

        //#endregion
        //ä»¥ä¸æ¯layuiæ¨¡å
    });

    //åå»è¿åçäº§èµæº
    function GetGySource(data) {
        OptionData = data
    }

    //åå»è¿åæä½å·¥
    function GetHEmpValue(data) {
        OptionData_Emp = data
    }

</script>

 WebTM/views/Éú²ú¹ÜÀí/·¢»õ¼Æ»®Æ½Ì¨£¨ÈýÉý£©/Xs_SendGoodsPlanImport.html

New file
@@ -0,0 +1,327 @@
ï»¿<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>åè´§è®¡åäº¤æå¯¼å¥</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <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>
</head>
<body>
    <div class="layui-fluid" style="padding: 0;">
        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
            <div class="layui-card-body" style="padding: 1px;">
                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;">
                    <div style="padding: 10px; ">
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">å¯¼å¥æ°æ®</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">éåº</button>
                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">æä»¶ä¸ä¼ </button>
                    </div>
                    <div class="layui-tab" lay-filter="tab-POStockInBill">
                        <div class="layui-tab-content">
                            <!--åºæ¬ä¿¡æ¯-->
                            <div class="layui-tab-item layui-show">
                                <div class="layui-form-item" style="padding-top: 10px;">
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <div class="layui-inline">
                                                <label class="layui-form-label" style="width: 85px;">åæ®æ¥æ</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 75px;">
                                                </div>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">è®¢åç±»å</label>
                                            <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                                <select name="HOrderType" id="HOrderType" lay-verify="HOrderType">
                                                    <option value="éå®è®¢å">éå®è®¢å</option>
                                                    <!--<option value="å§å¤è®¢å">å§å¤è®¢å</option>-->
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <div class="layui-inline">
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="hidden" name="HPRDORGID" id="HPRDORGID" lay-verify="HPRDORGID">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <table class="" id="mainTable" lay-filter="mainTable"></table>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
<script type="text/html" id="barDemo">
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">å é¤</a>
</script>
<script>

    layui.config({
        base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
    }).extend({
        index: 'lib/index' //ä¸»å¥å£æ¨¡å
    }).use(['index', 'form', 'laydate', 'table', 'element', 'upload'], function () {

        //#region å¬å±åé

        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , laydate = layui.laydate
            , excel = layui.excel
            , upload = layui.upload
            , element = layui.element;

        var option = [];
        //#endregion

        //#region è¿å¥é¡µé¢å³å è½½

        var params = getUrlVars();
        var OperationType = params[params[0]]; //ä»åæ°ä¸è·å æ°æ®ç±»å  æ·»å  ä¿å

        //åå§åçé¢
        set_ClearBill();

        //#endregion

        //#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

        //è¡åäºä»¶
        table.on('tool(mainTable)', function (obj) {
            set_GridDelete(obj);   //è¡åå é¤
            set_GridCellCheck(obj);//è¡åå¿«æ·é®çé
            //#region ä¿®æ¹æ¶é´
            var data = obj.data;
            //æ¥è®¡åçäº§æ¥æ
            if (obj.event == 'HPlanEndDate') {
                var field = $(this).data('field');
                laydate.render({
                    elem: this.firstChild
                    , show: true //ç´æ¥æ¾ç¤º
                    , closeStop: this
                    , done: function (nowDate) {
                        //æ¶é´éæ©å®æï¼è¡æ°æ®æ´æ°
                        data[field] = nowDate;
                        obj.update(data);
                    }
                });
            }
            //#endregion

        });

        //æä»¶ä¸ä¼ 
        upload.render({
            elem: '#UpLoad',
            url: GetWEBURL() + '/Xs_SendGoodsPlanBill/ExcelImport',
            contentType: 'application/json',
            exts: 'xls|xlsx', //åè®¸ä¸ä¼ çç±»å
            before: function (data) {
                loadIndex = layer.load(2);
            },
            done: function (data1) {
                if (data1.count == 1) {
                    option.data = data1.data;
                    table.render(option);
                    layer.close(loadIndex);
                } else {
                    layer.close(loadIndex);
                    layer.alert(data1.code + data1.Message, { icon: 5 });
                }
            },
            error: function (err) {
                debugger
                layer.alert('å¯¼å¥åºç°å¼å¸¸', { icon: 2 });
            }
        });

        //éåº
        form.on('submit(Cancel)', function () {
            if (OperationType == 1) {
                Pub_Close(1);
            }
            else {
                Pub_Close(2);
            }
        })

        //å¯¼å¥  ä¿åæ°æ®
        form.on('submit(btnSave)', function (data) {
            if (table.cache["mainTable"] != null) {
                set_AddNew(data);
            }
            else {
                layer.msg("æ æ°æ®,è¯·åå¯¼å¥æ°æ®!");
            }
        })


        //#endregion

        //#region æ¤é¡µé¢ææçæ¹æ³

        //#region åå§åçé¢
        function set_ClearBill() {
            //åå§åæ¶é´
            $("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
            //åå§åè¡¨æ ¼
            set_InitGrid();
        }

         //#endregion

        //åå§åè¡¨æ ¼
        function set_InitGrid() {
            var columns = [];

            columns.push({ type: 'checkbox', fixed: 'left' });
            columns.push({ field: 'HMaterID', title: 'HMaterID', width: 150, hide: true });
            columns.push({ field: 'hmainid', title: 'hmainid', width: 150, hide: true });
            columns.push({ field: 'SeOrderHInterID', title: 'SeOrderHInterID', width: 150, hide: true });
            columns.push({ field: 'SeOrderHEntryID', title: 'SeOrderHEntryID', width: 150, hide: true });
            columns.push({ field: 'éå®è®¢åå·', title: 'éå®è®¢åå·', width: 150, edit: true, hide: true });
            columns.push({ field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 150, edit: true });
            columns.push({ field: 'å®¢æ·è®¢åå·', title: 'å®¢æ·è®¢åå·', width: 200, edit: true });
            columns.push({ field: 'åè´§æ¥æ', title: 'åè´§æ¥æ', width: 150, event: "HPlanEndDate", edit: true});

            columns.push({ fixed: 'right', title: 'æä½', toolbar: '#barDemo' });

            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-190'
                , page: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , loading: false
                , cols: [columns]
            };

            //æ¸²æé¡µé¢
            table.render(option);
        }      

        //å¯¼å¥(ä¿å)
        function set_AddNew(data) {

            var num = [];

            //å¤ææ¯å¦æå¯¼å¥æéï¼å¦ææåå°æ»è£è½¦é´ä¹åçæ¥è®¡åå·¥åä½åº
            //if (!set_ModCheck("")) {
            //    layer.msg("å¯¼å¥å¤±è´¥ï¼æ å¯¼å¥æéï¼", { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
            //    return;
            //} 

            var HDataSub = [];
            var index = layer.load();
            layer.msg("å¼å§å¯¼å¥");
            //JITå¯¼å¥è®¡åï¼æ¯æ¬¡å¯¼å¥100è¡æ°æ®,å¯ä¿®æ¹içèªå¢å¼å³å®æ¯æ¬¡å¾ªç¯å¯¼å¥çè¡æ°
            for (var i = 0; i < option.data.length; i += 100) {
                HDataSub = option.data.slice(i, i + 100)

                data.field.HPRDORGID = sessionStorage["OrganizationID"];//ç»ç»
                var sMainStr = JSON.stringify(data.field);
                var sSubStr = JSON.stringify(HDataSub);
                var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"];

                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "/Xs_SendGoodsPlanBill/ExcelSave",
                    async: false,
                    data: { "sMainSub": sMainSub },
                    dataType: "json",
                    success: function (data) {
                        if (data.count == 1) {
                            layer.close(index);
                            $('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
                            layer.msg("æäº¤æå");
                        }
                        else {
                            layer.close(index);
                            layer.msg(data.Message, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
                        }
                    },
                    error: function (err) {
                        layer.close(index);
                        layer.msg("éè¯¯:" + err, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
                    }
                });
            }
            layer.close(index);
        }

        //è¡åå é¤
        function set_GridDelete(obj) {
            var rowIndex = $(obj.tr).attr("data-index");
            if (obj.event === 'del') {
                layer.confirm('ççå é¤è¡åï¼', function (index) {
                    obj.del();
                    table.cache["mainTable"].splice(rowIndex, 1);  //â¡å½»åºç§»é¤åç´ ï¼ä»ç¼åéç§»é¤è¿ä¸è¡
                    option.data = table.cache["mainTable"];//å°æ°æ®ç»å®å°dataä¸
                    table.render(option);
                    layer.close(index);
                });
            }
        }

        //è¡åå é¤å¿«æ·é®
        function set_GridCellCheck(obj) {
            
        }

        //è·ååæ°
        function getUrlVars() {
            var vars = [], hash;
            var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
            for (var i = 0; i < hashes.length; i++) {
                hash = hashes[i].split('=');
                vars.push(hash[0]);
                vars[hash[0]] = hash[1];
            }
            return vars;
        }

        //#region æéå¤å®
        function set_ModCheck(ModRightNameCheck) {
            var Permission = false;
            $.ajax({
                type: "GET",
                url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
                async: false,
                data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                success: function (result) {
                    if (result.count == 1) {
                        Permission = true;
                    } else {
                        //layer.alert("å½åæ¨¡åæ²¡ææ¥è¯¢æé!", { icon: 5 });
                    }
                }, error: function (e) {
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
            return Permission;
        }
        //#endregion

        //#endregion

    });

</script>

			@@ -603,6 +603,8 @@
			<Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatForm.html" />
			<Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS_Sec.html" />
			<Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS.html" />
			<Content Include="views\çäº§ç®¡ç\åè´§è®¡åå¹³å°ï¼ä¸åï¼\Xs_SendGoodsPlanForm.html" />
			<Content Include="views\çäº§ç®¡ç\åè´§è®¡åå¹³å°ï¼ä¸åï¼\Xs_SendGoodsPlanImport.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Cg_PODemandPlanConfigBillReportForLack.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Gy_RoutingBillReportForLack.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_NeedMaterPlanConfigBillReportForLack.html" />
			@@ -612,9 +614,6 @@
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_LockRequestBill.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_DayPlanPlatForm.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_LockRequestBillList.html" />
			<Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoExcel.html" />
			<Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoEdit.html" />
			<Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoList.html" />
			<Content Include="views\çäº§ç®¡ç\å¼å¸¸åé¦å\OA_ErrMsgBackSignBill_BrushCard.html" />
			<Content Include="views\çäº§ç®¡ç\å¼å¸¸åé¦å\Sc_MESExecptFeedBackBillResumeList.html" />
			<Content Include="views\çäº§ç®¡ç\å¼å¸¸åé¦å\Sc_MESExecptFeedBackBillType.html" />

			@@ -4,7 +4,7 @@
			<NameOfLastUsedPublishProfile>D:\æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
			<NameOfLastUsedPublishProfile>D:\WorkBench\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
			<ProjectView>ShowAllFiles</ProjectView>
			<LastActiveSolutionConfig>Release\|Any CPU</LastActiveSolutionConfig>
			<LastActiveSolutionConfig>Debug\|Any CPU</LastActiveSolutionConfig>
			<UseIISExpress>true</UseIISExpress>
			<Use64BitIISExpress />
			<IISExpressSSLPort />

New file
			@@ -0,0 +1,327 @@
			ï»¿<!DOCTYPE html>
			<html>
			<head>
			<meta charset="utf-8" />
			<title>åè´§è®¡åäº¤æå¯¼å¥</title>
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
			<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>
			</head>
			<body>
			<div class="layui-fluid" style="padding: 0;">
			<div class="layui-card" style="padding: 2px;background-color: #efefef;">
			<div class="layui-card-body" style="padding: 1px;">
			<form class="layui-form" action="" lay-filter="formData" style="background-color:white;">
			<div style="padding: 10px; ">
			<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">å¯¼å¥æ°æ®</button>
			<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">éåº</button>
			<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">æä»¶ä¸ä¼ </button>
			</div>
			<div class="layui-tab" lay-filter="tab-POStockInBill">
			<div class="layui-tab-content">
			<!--åºæ¬ä¿¡æ¯-->
			<div class="layui-tab-item layui-show">
			<div class="layui-form-item" style="padding-top: 10px;">
			<div class="layui-row">
			<div class="layui-inline">
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">åæ®æ¥æ</label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 75px;">
			</div>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">è®¢åç±»å</label>
			<div class="layui-input-block" style="margin-left: 120px; width: 185px;">
			<select name="HOrderType" id="HOrderType" lay-verify="HOrderType">
			<option value="éå®è®¢å">éå®è®¢å</option>
			<!--<option value="å§å¤è®¢å">å§å¤è®¢å</option>-->
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<div class="layui-inline">
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="hidden" name="HPRDORGID" id="HPRDORGID" lay-verify="HPRDORGID">
			</div>
			</div>
			</div>
			</div>
			</div>
			</div>
			</div>
			</div>
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			</form>
			</div>
			</div>
			</div>
			</body>
			</html>
			<script type="text/html" id="barDemo">
			<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">å é¤</a>
			</script>
			<script>

			layui.config({
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index' //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'laydate', 'table', 'element', 'upload'], function () {

			//#region å¬å±åé

			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			, table = layui.table
			, form = layui.form
			, laydate = layui.laydate
			, excel = layui.excel
			, upload = layui.upload
			, element = layui.element;

			var option = [];
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½

			var params = getUrlVars();
			var OperationType = params[params[0]]; //ä»åæ°ä¸è·å æ°æ®ç±»å æ·»å ä¿å

			//åå§åçé¢
			set_ClearBill();

			//#endregion

			//#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

			//è¡åäºä»¶
			table.on('tool(mainTable)', function (obj) {
			set_GridDelete(obj); //è¡åå é¤
			set_GridCellCheck(obj);//è¡åå¿«æ·é®çé
			//#region ä¿®æ¹æ¶é´
			var data = obj.data;
			//æ¥è®¡åçäº§æ¥æ
			if (obj.event == 'HPlanEndDate') {
			var field = $(this).data('field');
			laydate.render({
			elem: this.firstChild
			, show: true //ç´æ¥æ¾ç¤º
			, closeStop: this
			, done: function (nowDate) {
			//æ¶é´éæ©å®æï¼è¡æ°æ®æ´æ°
			data[field] = nowDate;
			obj.update(data);
			}
			});
			}
			//#endregion

			});

			//æä»¶ä¸ä¼
			upload.render({
			elem: '#UpLoad',
			url: GetWEBURL() + '/Xs_SendGoodsPlanBill/ExcelImport',
			contentType: 'application/json',
			exts: 'xls\|xlsx', //åè®¸ä¸ä¼ çç±»å
			before: function (data) {
			loadIndex = layer.load(2);
			},
			done: function (data1) {
			if (data1.count == 1) {
			option.data = data1.data;
			table.render(option);
			layer.close(loadIndex);
			} else {
			layer.close(loadIndex);
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			},
			error: function (err) {
			debugger
			layer.alert('å¯¼å¥åºç°å¼å¸¸', { icon: 2 });
			}
			});

			//éåº
			form.on('submit(Cancel)', function () {
			if (OperationType == 1) {
			Pub_Close(1);
			}
			else {
			Pub_Close(2);
			}
			})

			//å¯¼å¥ ä¿åæ°æ®
			form.on('submit(btnSave)', function (data) {
			if (table.cache["mainTable"] != null) {
			set_AddNew(data);
			}
			else {
			layer.msg("æ æ°æ®,è¯·åå¯¼å¥æ°æ®!");
			}
			})


			//#endregion

			//#region æ¤é¡µé¢ææçæ¹æ³

			//#region åå§åçé¢
			function set_ClearBill() {
			//åå§åæ¶é´
			$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
			//åå§åè¡¨æ ¼
			set_InitGrid();
			}

			//#endregion

			//åå§åè¡¨æ ¼
			function set_InitGrid() {
			var columns = [];

			columns.push({ type: 'checkbox', fixed: 'left' });
			columns.push({ field: 'HMaterID', title: 'HMaterID', width: 150, hide: true });
			columns.push({ field: 'hmainid', title: 'hmainid', width: 150, hide: true });
			columns.push({ field: 'SeOrderHInterID', title: 'SeOrderHInterID', width: 150, hide: true });
			columns.push({ field: 'SeOrderHEntryID', title: 'SeOrderHEntryID', width: 150, hide: true });
			columns.push({ field: 'éå®è®¢åå·', title: 'éå®è®¢åå·', width: 150, edit: true, hide: true });
			columns.push({ field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 150, edit: true });
			columns.push({ field: 'å®¢æ·è®¢åå·', title: 'å®¢æ·è®¢åå·', width: 200, edit: true });
			columns.push({ field: 'åè´§æ¥æ', title: 'åè´§æ¥æ', width: 150, event: "HPlanEndDate", edit: true});

			columns.push({ fixed: 'right', title: 'æä½', toolbar: '#barDemo' });

			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-190'
			, page: true
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, loading: false
			, cols: [columns]
			};

			//æ¸²æé¡µé¢
			table.render(option);
			}

			//å¯¼å¥(ä¿å)
			function set_AddNew(data) {

			var num = [];

			//å¤ææ¯å¦æå¯¼å¥æéï¼å¦ææåå°æ»è£è½¦é´ä¹åçæ¥è®¡åå·¥åä½åº
			//if (!set_ModCheck("")) {
			// layer.msg("å¯¼å¥å¤±è´¥ï¼æ å¯¼å¥æéï¼", { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
			// return;
			//}

			var HDataSub = [];
			var index = layer.load();
			layer.msg("å¼å§å¯¼å¥");
			//JITå¯¼å¥è®¡åï¼æ¯æ¬¡å¯¼å¥100è¡æ°æ®,å¯ä¿®æ¹içèªå¢å¼å³å®æ¯æ¬¡å¾ªç¯å¯¼å¥çè¡æ°
			for (var i = 0; i < option.data.length; i += 100) {
			HDataSub = option.data.slice(i, i + 100)

			data.field.HPRDORGID = sessionStorage["OrganizationID"];//ç»ç»
			var sMainStr = JSON.stringify(data.field);
			var sSubStr = JSON.stringify(HDataSub);
			var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"];

			$.ajax({
			type: "POST",
			url: GetWEBURL() + "/Xs_SendGoodsPlanBill/ExcelSave",
			async: false,
			data: { "sMainSub": sMainSub },
			dataType: "json",
			success: function (data) {
			if (data.count == 1) {
			layer.close(index);
			$('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
			layer.msg("æäº¤æå");
			}
			else {
			layer.close(index);
			layer.msg(data.Message, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
			}
			},
			error: function (err) {
			layer.close(index);
			layer.msg("éè¯¯:" + err, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
			}
			});
			}
			layer.close(index);
			}

			//è¡åå é¤
			function set_GridDelete(obj) {
			var rowIndex = $(obj.tr).attr("data-index");
			if (obj.event === 'del') {
			layer.confirm('ççå é¤è¡åï¼', function (index) {
			obj.del();
			table.cache["mainTable"].splice(rowIndex, 1); //â¡å½»åºç§»é¤åç´ ï¼ä»ç¼åéç§»é¤è¿ä¸è¡
			option.data = table.cache["mainTable"];//å°æ°æ®ç»å®å°dataä¸
			table.render(option);
			layer.close(index);
			});
			}
			}

			//è¡åå é¤å¿«æ·é®
			function set_GridCellCheck(obj) {

			}

			//è·ååæ°
			function getUrlVars() {
			var vars = [], hash;
			var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
			for (var i = 0; i < hashes.length; i++) {
			hash = hashes[i].split('=');
			vars.push(hash[0]);
			vars[hash[0]] = hash[1];
			}
			return vars;
			}

			//#region æéå¤å®
			function set_ModCheck(ModRightNameCheck) {
			var Permission = false;
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			async: false,
			data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			Permission = true;
			} else {
			//layer.alert("å½åæ¨¡åæ²¡ææ¥è¯¢æé!", { icon: 5 });
			}
			}, error: function (e) {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			return Permission;
			}
			//#endregion

			//#endregion

			});

			</script>