From 6b22424e3f99de6a979da2c08a43b60ee124ff2e Mon Sep 17 00:00:00 2001 From: renhao <renhui.hao@capgemini.com> Date: 星期三, 18 十月 2023 10:33:35 +0800 Subject: [PATCH] Merge branch 'dev' --- /dev/null | 11 ----------- 1 files changed, 0 insertions(+), 11 deletions(-) diff --git a/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgeBusinessTypeString.qbl b/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgeBusinessTypeString.qbl deleted file mode 100644 index 717a4f8..0000000 --- a/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgeBusinessTypeString.qbl +++ /dev/null @@ -1,11 +0,0 @@ -Quintiq file version 2.0 -#parent: #root -Method CapacityAndSaleBudgeBusinessTypeString () as owning String -{ - TextBody: - [* - // yypsybs Sep-19-2023 (created) - result := selectuniquevalues( this, MappingCapacityAndSaleBudge, item, true, item.BusinessType() ); - return result.Concatenate( ";" ) ; - *] -} diff --git a/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgeExport.qbl b/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgeExport.qbl deleted file mode 100644 index 0048b94..0000000 --- a/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgeExport.qbl +++ /dev/null @@ -1,143 +0,0 @@ -Quintiq file version 2.0 -#parent: #root -Method CapacityAndSaleBudgeExport () as BinaryValue -{ - Description: '瀵煎嚭姣旇緝缁撴灉' - TextBody: - [* - // generate by generate_export.py - info( "export start" ); - text:= '<?xml version="1.0" encoding="utf-8" standalone="yes"?><table><name>骞村害浜ч攢棰勭畻</name> - <column><name>鍒犻櫎鏍囪</name><type>String</type></column> - <column><name>骞翠唤</name><type>Number</type></column> - <column><name>涓氬姟閮ㄩ棬</name><type>String</type></column> - <column><name>鏄剧ず鎶�鏈垎绫�</name><type>String</type></column> - <column><name>涓氬姟鍒嗙被</name><type>String</type></column> - <column><name>浜у搧绾�/浜у搧瑙勬牸</name><type>String</type></column> - <column><name>浜у搧鏂欏彿</name><type>String</type></column> - <column><name>Array浜у湴</name><type>String</type></column> - <column><name>钂搁晙浜у湴</name><type>String</type></column> - <column><name>鍒嗚鲸鐜�</name><type>String</type></column> - <column><name>鍑鸿揣褰㈡��</name><type>String</type></column> - <column><name>鍒囧壊鏁�</name><type>String</type></column> - <column><name>浜ц兘褰撻噺</name><type>String</type></column> - <column><name>mask鏁�</name><type>String</type></column> - <column><name>1鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>2鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>3鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>4鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>5鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>6鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>7鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>8鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>9鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>10鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>11鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>12鏈堜骇鑳�(PCS)</name><type>Real</type></column> - <column><name>骞翠骇鑳�(PCS)</name><type>Real</type></column> - <column><name>1鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>2鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>3鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>4鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>5鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>6鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>7鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>8鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>9鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>10鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>11鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>12鏈堜骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>骞翠骇鑳�(瀹炴暟澶у紶)</name><type>Real</type></column> - <column><name>1鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>2鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>3鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>4鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>5鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>6鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>7鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>8鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>9鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>10鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>11鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>12鏈堥攢鍞(W)</name><type>Real</type></column> - <column><name>骞撮攢鍞(W)</name><type>Real</type></column> - </table>'; - xmlDOMImplementation := XMLDOMImplementation::Create(); - xmlDOMDocument := xmlDOMImplementation.CreateDocumentFromString( text ); - - tableElement:= xmlDOMDocument.GetElementByTagName( "table", 0 ); - - toExportList := selectsortedset( this, MappingCapacityAndSaleBudge, item, true, item.OrgCode() + "_" + item.PlaceOfProductionOfArray() ); - info( "export size : " + [String]toExportList.Size() ); - nowNo := 1; - traverse ( toExportList, Elements, toExport ) { - info( "nowNo : " + [String]nowNo ); - nowNo := nowNo + 1; - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, ifexpr( toExport.Deleted(), "Y", "N"), "鍒犻櫎鏍囪" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.YearNo(), "骞翠唤" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.OrgCode(), "涓氬姟閮ㄩ棬" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.DisplayTechnology(), "鏄剧ず鎶�鏈垎绫�" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.BusinessType(), "涓氬姟鍒嗙被" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.LineAndSpecification(), "浜у搧绾�/浜у搧瑙勬牸" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.ProductCode(), "浜у搧鏂欏彿" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.PlaceOfProductionOfArray(), "Array浜у湴" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.PlaceOfProductionOfEvaporation(), "钂搁晙浜у湴" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.Resolution(), "鍒嗚鲸鐜�" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.ShippingForm(), "鍑鸿揣褰㈡��" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.NumberOfCut(), "鍒囧壊鏁�" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.CapacityEquivalent(), "浜ц兘褰撻噺" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.NumberOfMask(), "mask鏁�" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth1(), "1鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth2(), "2鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth3(), "3鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth4(), "4鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth5(), "5鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth6(), "6鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth7(), "7鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth8(), "8鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth9(), "9鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth10(), "10鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth11(), "11鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSInMonth12(), "12鏈堜骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInPCSTotal(), "骞翠骇鑳�(PCS)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth1(), "1鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth2(), "2鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth3(), "3鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth4(), "4鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth5(), "5鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth6(), "6鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth7(), "7鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth8(), "8鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth9(), "9鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth10(), "10鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth11(), "11鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetInMonth12(), "12鏈堜骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.CapacityInSheetTotal(), "骞翠骇鑳�(瀹炴暟澶у紶)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth1(), "1鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth2(), "2鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth3(), "3鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth5(), "4鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth4(), "5鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth6(), "6鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth7(), "7鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth8(), "8鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth9(), "9鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth10(), "10鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth11(), "11鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountInMonth12(), "12鏈堥攢鍞(W)" ); - ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.SaleAmountTotal(), "骞撮攢鍞(W)" ); - } - - xmlDOMSerializer := xmlDOMImplementation.CreateSerializer(); - xmlTableString := xmlDOMSerializer.WriteToString( xmlDOMDocument ); - - tableHandle := TableHandle::ImportXML( BinaryValue::Construct( xmlTableString ) ); - tableGroupHandle := TableGroupHandle::Create( "骞村害浜ч攢棰勭畻" ); - tableGroupHandle.Add( tableHandle ); - tableBinaryData := XLS::SaveTableGroupToBinaryData( tableGroupHandle, true ); - - info( "export end" ); - - return tableBinaryData.AsBinaryValue(); - *] -} diff --git a/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgePlaceOfProductionOfArrayString.qbl b/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgePlaceOfProductionOfArrayString.qbl deleted file mode 100644 index 2612296..0000000 --- a/_Main/BL/Type_MPSync/Method_CapacityAndSaleBudgePlaceOfProductionOfArrayString.qbl +++ /dev/null @@ -1,11 +0,0 @@ -Quintiq file version 2.0 -#parent: #root -Method CapacityAndSaleBudgePlaceOfProductionOfArrayString () as owning String -{ - TextBody: - [* - // yypsybs Sep-19-2023 (created) - result := selectuniquevalues( this, MappingCapacityAndSaleBudge, item, true, item.PlaceOfProductionOfArray() ); - return result.Concatenate( ";" ) ; - *] -} -- Gitblit v1.9.3