From 0b288e121e532eacae485608cd8f2ae497977faa Mon Sep 17 00:00:00 2001 From: yypsybs <yypsybs@foxmail.com> Date: 星期一, 18 九月 2023 17:02:36 +0800 Subject: [PATCH] Merge branch 'dev' into dev_yx --- _Main/BL/Type_MatAttrSettingAndPlanStrategyDataTable/Method_CreateOrUpdateData.qbl | 89 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 88 insertions(+), 1 deletions(-) diff --git a/_Main/BL/Type_MatAttrSettingAndPlanStrategyDataTable/Method_CreateOrUpdateData.qbl b/_Main/BL/Type_MatAttrSettingAndPlanStrategyDataTable/Method_CreateOrUpdateData.qbl index 6d76f0a..15d22df 100644 --- a/_Main/BL/Type_MatAttrSettingAndPlanStrategyDataTable/Method_CreateOrUpdateData.qbl +++ b/_Main/BL/Type_MatAttrSettingAndPlanStrategyDataTable/Method_CreateOrUpdateData.qbl @@ -30,10 +30,97 @@ // finishedProductDeliveryMinLTDays := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "鎴愬搧浜や粯Min-LT锛堝ぉ锛�" ).value(); longAndShortCycleLabels := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "闀跨煭鍛ㄦ湡鏍囩" ).value(); genericSpecialLabels := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "閫氱敤涓撶敤鏍囩" ).value(); - // automaticMaterialPlanningPolicies := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "鑷姩鐗╂枡璁″垝绛栫暐" ).value(); + automaticMaterialPlanningPolicies := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "鑷姩鐗╂枡璁″垝绛栫暐" ).value(); usersManuallySchedulePolicies := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "鐢ㄦ埛鎵嬪姩璁″垝绛栫暐" ).value(); minimumNumberOfDaysInStock := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "搴撳瓨鏈�灏忓ぉ鏁�" ).value(); maximumNumberOfDaysInInventory := select( masapsdr, MatAttrSettingAndPlanStrategyDataCell, tempMASAPSDC, tempMASAPSDC.MatAttrSettingAndPlanStrategyDataColumn().name() = "搴撳瓨鏈�澶уぉ鏁�" ).value(); + if ( businessType = "闆嗗洟闈㈡澘" ) { + if ( createItemCode.StartsWith( "103" ) ) { + if( longAndShortCycleLabels = "闀垮懆鏈�" ) { + if ( genericSpecialLabels = "涓撶敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else if ( genericSpecialLabels = "閫氱敤" ) { + if ( automaticMaterialPlanningPolicies <> "瀹夊叏搴撳瓨" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else { + error( "涓撻�氱敤鏍囩鐨勫�煎嚭閿欙細", createItemCode ); + } + } else if ( longAndShortCycleLabels = "鐭懆鏈�" ) { + if ( genericSpecialLabels = "涓撶敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else if ( genericSpecialLabels = "閫氱敤" ) { + if ( automaticMaterialPlanningPolicies <> "瀹夊叏搴撳瓨" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else { + error( "涓撻�氱敤鏍囩鐨勫�煎嚭閿欙細", createItemCode ); + } + } else { + error( "闀跨煭鍛ㄦ湡鐨勫�煎嚭閿欙細", createItemCode ); + } + } else { + if( longAndShortCycleLabels = "闀垮懆鏈�" ) { + if ( genericSpecialLabels = "涓撶敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else if ( genericSpecialLabels = "閫氱敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else { + error( "涓撻�氱敤鏍囩鐨勫�煎嚭閿欙細", createItemCode ); + } + } else if ( longAndShortCycleLabels = "鐭懆鏈�" ) { + if ( genericSpecialLabels = "涓撶敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else if ( genericSpecialLabels = "閫氱敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else { + error( "涓撻�氱敤鏍囩鐨勫�煎嚭閿欙細", createItemCode ); + } + } else { + error( "闀跨煭鍛ㄦ湡鐨勫�煎嚭閿欙細", createItemCode ); + } + } + } else { + if( longAndShortCycleLabels = "闀垮懆鏈�" ) { + if ( genericSpecialLabels = "涓撶敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else if ( genericSpecialLabels = "閫氱敤" ) { + if ( automaticMaterialPlanningPolicies <> "瀹夊叏搴撳瓨" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else { + error( "涓撻�氱敤鏍囩鐨勫�煎嚭閿欙細", createItemCode ); + } + } else if ( longAndShortCycleLabels = "鐭懆鏈�" ) { + if ( genericSpecialLabels = "涓撶敤" ) { + if ( automaticMaterialPlanningPolicies <> "JIT" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else if ( genericSpecialLabels = "閫氱敤" ) { + if ( automaticMaterialPlanningPolicies <> "VMI" ) { + error( "瀵煎叆鐨勮嚜鍔ㄨ鍒掔瓥鐣ュ�煎嚭閿欙細", createItemCode ); + } + } else { + error( "涓撻�氱敤鏍囩鐨勫�煎嚭閿欙細", createItemCode ); + } + } else { + error( "闀跨煭鍛ㄦ湡鐨勫�煎嚭閿欙細", createItemCode ); + } + } try { matAttrSettingAndPlanStrategy := globalOTDTable.MatAttrSettingAndPlanStrategy( relnew, BusinessType := businessType, -- Gitblit v1.9.3