1

yusijie

2025-09-13 8c839f638e97f2e8487c64bfe92cc31e0a8979cb

 WebTM/views/Éú²ú¹ÜÀí/Ç·ÁÏÔËËã/JIT_MaterialLevelShorAnalysisDetailReport.html

@@ -134,6 +134,7 @@
        var HMaterID = 0;
        var HWorkShopID = 0;
        var HOrgID = 0;
        var HIDentificat = "";
        var HExportData = "";//导出数据
        var HExportData2 = "";//导出数据
        //#endregion
@@ -372,7 +373,12 @@
            var HBEGINDATE = $("#HBEGINDATE").val();
            var HENDDATE = $("#HENDDATE").val();
            //下查
            var sql = "exec h_p_JIT_MaterialLevelShorDetailsList " + HOrgID + "," + HMaterID + "," + HWorkShopID + ",'" + HBEGINDATE + "','" + HENDDATE + "'," + "1";
            var sql = "";
            if (HIDentificat != "" && typeof (HIDentificat) != "undefined") {
                sql = "exec h_p_JIT_MaterialLevelShorDetailsList " + HOrgID + "," + HMaterID + "," + HWorkShopID + ",'" + HBEGINDATE + "','" + HENDDATE + "'," + "1" + ",'" + HIDentificat + "'";
            } else {
                sql = "exec h_p_JIT_MaterialLevelShorDetailsList " + HOrgID + "," + HMaterID + "," + HWorkShopID + ",'" + HBEGINDATE + "','" + HENDDATE + "'," + "1";
            }
            $.ajax({
                url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
                type: "GET",
@@ -471,7 +477,11 @@
                    layer.close(ajaxLoad);
                }
            });
            var sql = "exec h_p_JIT_MaterialLevelShorDetailsList " + HOrgID + "," + HMaterID + "," + HWorkShopID + ",'" + HBEGINDATE + "','" + HENDDATE + "'," + "2";
            if (HIDentificat != "" && typeof (HIDentificat) != "undefined") {
                sql = "exec h_p_JIT_MaterialLevelShorDetailsList " + HOrgID + "," + HMaterID + "," + HWorkShopID + ",'" + HBEGINDATE + "','" + HENDDATE + "'," + "2" + ",'" + HIDentificat + "'";
            } else {
                sql = "exec h_p_JIT_MaterialLevelShorDetailsList " + HOrgID + "," + HMaterID + "," + HWorkShopID + ",'" + HBEGINDATE + "','" + HENDDATE + "'," + "2";
            }
            $.ajax({
                url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
                type: "GET",
@@ -627,7 +637,13 @@
                HMaterID2 = HMaterID;
            }
            //明细列表
            var sql = "select * from h_v_Jit_MaterialLevelShorAnalysisDetailReport_StockOccupyingAnalysis where  å­é¡¹ç‰©æ–™ID = " + HMaterID2 + " order by å±‚级,日计划日期";
            var sql = ""; 
            if (HIDentificat != "" && typeof (HIDentificat) != "undefined") {
                sql = "select * from h_v_Jit_MaterialLevelShorAnalysisDetailReport_StockOccupyingAnalysis_His where  å­é¡¹ç‰©æ–™ID = " + HMaterID2 + " and è¿ç®—标识 = '" + HIDentificat + "' order by å±‚级,日计划日期";
            } else {
                sql = "select * from h_v_Jit_MaterialLevelShorAnalysisDetailReport_StockOccupyingAnalysis where  å­é¡¹ç‰©æ–™ID = " + HMaterID2 + " order by å±‚级,日计划日期";
            }

            $.ajax({
                url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
                type: "GET",
@@ -820,6 +836,7 @@
            var HWorkShopID2 = params[params[3]];
            var HBEGINDATE2 = params[params[4]];//欠料日期
            var HENDDATE2 = params[params[5]];//至
            var HIDentificat2 = params[params[6]];//运算标识
            var addSWhere = "";
            if (openType == 2) {
                HMaterID = HMaterID2;
@@ -827,6 +844,10 @@
                HOrgID = HOrgID2;
                $("#HBEGINDATE").val(HBEGINDATE2);
                $("#HENDDATE").val(HENDDATE2);

                if (HIDentificat2 && typeof (HIDentificat2) != "undefined") {
                    HIDentificat = HIDentificat2;
                }
            }
            return addSWhere;
        }