From ae9e8bebf79b54a003ce474d82a942f6a58433fa Mon Sep 17 00:00:00 2001
From: hongjli <3117313295@qq.com>
Date: 星期四, 14 九月 2023 12:30:45 +0800
Subject: [PATCH] 物料标签
---
_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