乔一：客户物料即时库存报表、客户手工抄包报表

duhe

2025-09-01 e57b2edbffff5a653ba9eda65eae100ceb2e7822

 WebTM/views/生产管理/日计划报表/ReportWorkDemandPlanBillList.html

@@ -49,6 +49,7 @@
                                </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>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnGetWorkBill" id="btnGetWorkBill">鐢熸垚鎺掍骇璁″垝</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin: 10px 0 10px;">
                                        <div class="layui-inline">
@@ -236,6 +237,13 @@
        });
        //#endregion

        //#region 鐢熶骇杞﹂棿
        form.on('submit(btnGetWorkBill)', function (data) {
            btnGetWorkBill();
        });
        //#endregion


        //#region 閲嶇疆鎸夐挳
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();
@@ -321,9 +329,9 @@
                , toolbar: '#toolbarDemo'
                , height: 'full-50'
                , title: "瑕佹枡璁″垝鎶ヨ〃"
                , page: false
                , page: true
                , cellMinWidth: 90
                , limit: 20000
                , limit: 500
                , totalRow: true
                , limits: [50, 500, 5000, 20000]
                , loading: false
@@ -529,6 +537,32 @@
        }
        //#endregion

        //#region 瑕佹枡璁″垝鐢熸垚鎺掍骇璁″垝
        function btnGetWorkBill() {
            var ajaxLoad = layer.load();
            var sql = "exec h_p_JIT_WorkBillSortBill_WorkDemandPlan_sansheng " + $("#HDeptID").val()+",'" +sessionStorage["HUserName"] + "','" + sessionStorage["OrganizationID"] + "'";
            $.ajax({
                url: GetWEBURL() + '/CommonModel/searchMethod',
                type: "GET",
                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 });
                        layer.close(ajaxLoad);
                    }
                }, error: function () {
                    layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
                    layer.close(ajaxLoad);
                }
            });
        }
        //#endregion


        //鐗╂枡鍒楄〃
        function btnHMATERIALID() {
            layer.open({