MES-WEB-LayUI.git

parent: 4537b4f7 | 补丁 | 提交 | ignore whitespace

wtt

2025-05-15 c4c531fac0ff55969628d4497135252c7c1d0905

三升排产导入功能

1个文件已添加

4个文件已修改

	WebTM/WebTM.csproj	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/WebTM.csproj.user	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/生产管理/三升排产/JIT_DayPlanPlatForm.html	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/生产管理/三升排产/JIT_DayPlanPlatFormImport_SS.html	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/生产管理/三升排产/JIT_DayPlanPlatFormImport_SS_Sec.html	397 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebTM/WebTM.csproj

@@ -578,6 +578,7 @@
    <Content Include="views\æ¨¡æ²»å·ç®¡ç\æ¨¡æ²»å·ç®¡ç\Sc_MouldMaintainRuleBill_Excel.html" />
    <Content Include="views\æ¨¡æ²»å·ç®¡ç\æ¨¡æ²»å·ç®¡ç\Sc_MouldMaintainRuleBillList_PDA.html" />
    <Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatForm.html" />
    <Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS_Sec.html" />
    <Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Cg_PODemandPlanConfigBillReportForLack.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Gy_RoutingBillReportForLack.html" />

 WebTM/WebTM.csproj.user

@@ -3,7 +3,7 @@
  <PropertyGroup>
    <NameOfLastUsedPublishProfile>D:\æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\å·¥ä½ä»£ç \æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\LAYUI.pubxml</NameOfLastUsedPublishProfile>
    <ProjectView>ProjectFiles</ProjectView>
    <ProjectView>ShowAllFiles</ProjectView>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>true</UseIISExpress>
    <Use64BitIISExpress />

 WebTM/views/Éú²ú¹ÜÀí/ÈýÉýÅÅ²ú/JIT_DayPlanPlatForm.html

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

 WebTM/views/Éú²ú¹ÜÀí/ÈýÉýÅÅ²ú/JIT_DayPlanPlatFormImport_SS.html

@@ -2,7 +2,7 @@
<html>
<head>
    <meta charset="utf-8" />
    <title>çäº§æ¥è®¡åå¯¼å¥</title>
    <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>

 WebTM/views/Éú²ú¹ÜÀí/ÈýÉýÅÅ²ú/JIT_DayPlanPlatFormImport_SS_Sec.html

New file
@@ -0,0 +1,397 @@
ï»¿<!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;" disabled>
                                                </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() + '/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_SS_Sec',
            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 myDate = new Date();
            var yyyy = myDate.getFullYear();
            var MM = myDate.getMonth() + 1;
            var dd = myDate.getDate();
            var SumMonth = 31; //å¨æä¸¤æä¹å·® new Date(yyyy, MM, 0).getDate()
            var columns = [];
            var HBEGINDATE = new Date(new Date($("#HDate").val())).getDate(); //è·åå¼å§æ¥æå¤©æ°

            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: 'ICMOBillHInterID', title: 'ICMOBillHInterID', width: 150, hide: true });
            columns.push({ field: 'ICMOBillHEntryID', title: 'ICMOBillHEntryID', width: 150, hide: true });
            columns.push({ field: 'å®¢æ·è®¢åå·', title: 'å®¢æ·è®¢åå·', width: 200, edit: true });
            columns.push({ field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 150, edit: true });
            columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', edit: 'text' });
            columns.push({ field: 'ä¼åçº§', title: 'ä¼åçº§' });
            columns.push({ field: 'HSourceID', title: 'HSourceID', hide: true });
            columns.push({ field: 'çäº§èµæºç¼ç ', title: 'çäº§èµæº', edit: 'text', event: "HSourceID" });
            columns.push({ field: 'è®¡åç»ææ¥æ', title: 'è®¡åç»ææ¥æ', width: 150, event: "HPlanEndDate", edit: true });

            var k = 0;//æ¶éå¾ªç¯æ¬¡æ°
            var Days = 45;
            for (var j = 0; j <= (Days - k); j++) {
                columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true })
                //è·¨å¹´çè¯ ä¼ä»ä¸æä¸å·å¼å§
                if (MM == 12 && (HBEGINDATE + j) == 31) {
                    yyyy += 1;
                    MM = 1;
                    SumMonth = new Date(yyyy, MM, 0).getDate();
                    HBEGINDATE = 0;
                    k += j;
                    j = 0;
                } else if ((HBEGINDATE + j) == SumMonth) { //è·¨æ ææ°å ä¸  å¤©æ°ä»ä¸å¼å§
                    HBEGINDATE = 0;
                    MM += 1;
                    SumMonth = new Date(yyyy, MM, 0).getDate();
                    k += j;
                    j = 0;
                }
            }

            //for (var i = 0; i <= (SumMonth - dd); i++) {
            //    columns.push({ field: Format(yyyy + '/' + MM + '/' + (dd + i), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (dd + i), 'MM.dd'), edit: 'text', width:80 })
            //}
            //for (var i = 1; i <= dd; i++) {
            //    columns.push({ field: Format(yyyy + '/' + (MM + 1) + '/' + i, 'yyyy-MM-dd'), title: Format(yyyy + '/' + (MM + 1) + '/' + i, 'MM.dd'), edit: 'text', width: 80 })
            //}
            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("Sc_WorkBillSortBill_Edit")) {
                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() + "/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_btnSave_SS_Sec",
                    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.reload(option);
                    layer.close(index);
                });
            }
        }

        //è¡åå é¤å¿«æ·é®
        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", "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("è¯·éæ©ä¸æ¡æ°æ®");
                                }
                                //æ´æ°è¡¨æ ¼ç¼åçæ°æ®
                                obj.update({
                                    "HSourceID": checkStatus.data[0].HItemID
                                    , "çäº§èµæºç¼ç ": checkStatus.data[0].çäº§èµæºä»£ç 
                                })
                                layer.close(index);//å³éå¼¹çª
                            }
                        })
                    }
                    obj.event = "";
                    return false;
                }

            })
        }

        //è·ååæ°
        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>

			@@ -578,6 +578,7 @@
			<Content Include="views\æ¨¡æ²»å·ç®¡ç\æ¨¡æ²»å·ç®¡ç\Sc_MouldMaintainRuleBill_Excel.html" />
			<Content Include="views\æ¨¡æ²»å·ç®¡ç\æ¨¡æ²»å·ç®¡ç\Sc_MouldMaintainRuleBillList_PDA.html" />
			<Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatForm.html" />
			<Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS_Sec.html" />
			<Content Include="views\çäº§ç®¡ç\ä¸åæäº§\JIT_DayPlanPlatFormImport_SS.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Cg_PODemandPlanConfigBillReportForLack.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\Gy_RoutingBillReportForLack.html" />

			@@ -3,7 +3,7 @@
			<PropertyGroup>
			<NameOfLastUsedPublishProfile>D:\æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
			<NameOfLastUsedPublishProfile>D:\å·¥ä½ä»£ç \æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\LAYUI.pubxml</NameOfLastUsedPublishProfile>
			<ProjectView>ProjectFiles</ProjectView>
			<ProjectView>ShowAllFiles</ProjectView>
			<LastActiveSolutionConfig>Debug\|Any CPU</LastActiveSolutionConfig>
			<UseIISExpress>true</UseIISExpress>
			<Use64BitIISExpress />

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

			@@ -2,7 +2,7 @@
			<html>
			<head>
			<meta charset="utf-8" />
			<title>çäº§æ¥è®¡åå¯¼å¥</title>
			<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>

New file
			@@ -0,0 +1,397 @@
			ï»¿<!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;" disabled>
			</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() + '/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_SS_Sec',
			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 myDate = new Date();
			var yyyy = myDate.getFullYear();
			var MM = myDate.getMonth() + 1;
			var dd = myDate.getDate();
			var SumMonth = 31; //å¨æä¸¤æä¹å·® new Date(yyyy, MM, 0).getDate()
			var columns = [];
			var HBEGINDATE = new Date(new Date($("#HDate").val())).getDate(); //è·åå¼å§æ¥æå¤©æ°

			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: 'ICMOBillHInterID', title: 'ICMOBillHInterID', width: 150, hide: true });
			columns.push({ field: 'ICMOBillHEntryID', title: 'ICMOBillHEntryID', width: 150, hide: true });
			columns.push({ field: 'å®¢æ·è®¢åå·', title: 'å®¢æ·è®¢åå·', width: 200, edit: true });
			columns.push({ field: 'ç©æç¼ç ', title: 'ç©æç¼ç ', width: 150, edit: true });
			columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', edit: 'text' });
			columns.push({ field: 'ä¼åçº§', title: 'ä¼åçº§' });
			columns.push({ field: 'HSourceID', title: 'HSourceID', hide: true });
			columns.push({ field: 'çäº§èµæºç¼ç ', title: 'çäº§èµæº', edit: 'text', event: "HSourceID" });
			columns.push({ field: 'è®¡åç»ææ¥æ', title: 'è®¡åç»ææ¥æ', width: 150, event: "HPlanEndDate", edit: true });

			var k = 0;//æ¶éå¾ªç¯æ¬¡æ°
			var Days = 45;
			for (var j = 0; j <= (Days - k); j++) {
			columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true })
			//è·¨å¹´çè¯ ä¼ä»ä¸æä¸å·å¼å§
			if (MM == 12 && (HBEGINDATE + j) == 31) {
			yyyy += 1;
			MM = 1;
			SumMonth = new Date(yyyy, MM, 0).getDate();
			HBEGINDATE = 0;
			k += j;
			j = 0;
			} else if ((HBEGINDATE + j) == SumMonth) { //è·¨æ ææ°å ä¸ å¤©æ°ä»ä¸å¼å§
			HBEGINDATE = 0;
			MM += 1;
			SumMonth = new Date(yyyy, MM, 0).getDate();
			k += j;
			j = 0;
			}
			}

			//for (var i = 0; i <= (SumMonth - dd); i++) {
			// columns.push({ field: Format(yyyy + '/' + MM + '/' + (dd + i), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (dd + i), 'MM.dd'), edit: 'text', width:80 })
			//}
			//for (var i = 1; i <= dd; i++) {
			// columns.push({ field: Format(yyyy + '/' + (MM + 1) + '/' + i, 'yyyy-MM-dd'), title: Format(yyyy + '/' + (MM + 1) + '/' + i, 'MM.dd'), edit: 'text', width: 80 })
			//}
			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("Sc_WorkBillSortBill_Edit")) {
			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() + "/JIT_DayPlanPlatFormImport/JIT_DayPlanPlatFormImport_btnSave_SS_Sec",
			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.reload(option);
			layer.close(index);
			});
			}
			}

			//è¡åå é¤å¿«æ·é®
			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", "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("è¯·éæ©ä¸æ¡æ°æ®");
			}
			//æ´æ°è¡¨æ ¼ç¼åçæ°æ®
			obj.update({
			"HSourceID": checkStatus.data[0].HItemID
			, "çäº§èµæºç¼ç ": checkStatus.data[0].çäº§èµæºä»£ç
			})
			layer.close(index);//å³éå¼¹çª
			}
			})
			}
			obj.event = "";
			return false;
			}

			})
			}

			//è·ååæ°
			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>