_Main/BL/Type_PRData/StaticMethod_ExportTheFileStream.qbl | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
_Main/BL/Type_PRData/StaticMethod_GeneratesTheSpecifiedXMLColumn#56.qbl | 补丁 | 查看 | 原始文档 | blame | 历史 | |
_Main/UI/MacroPlannerWebApp/Component_Form633/Component_PanelPRDataButton.def | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
_Main/UI/MacroPlannerWebApp/Component_Form633/Response_DataHolderChecked_OnDataChanged#774.def | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
_Main/UI/MacroPlannerWebApp/Component_Form633/Response_ListPRData_844_OnUserCheckedChanged#613.def | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
_Main/UI/MacroPlannerWebApp/Component_Form633/Response_ListPRData_844_OnUserCheckedChanged.def | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
_Main/UI/MacroPlannerWebApp/Component_Form633/Response_PanelPRDataButton_ButtonExportPR_OnClick.def | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
_Main/UI/MacroPlannerWebApp/Views/PR_DATA.vw | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
_Main/BL/Type_PRData/StaticMethod_ExportTheFileStream.qbl
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,53 @@ Quintiq file version 2.0 #parent: #root StaticMethod ExportTheFileStream ( PRDatas toExportList ) as BinaryValue { TextBody: [* text:= '<?xml version="1.0" encoding="utf-8" standalone="yes"?><table><name>PR</name><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>PRå»ºè®®æ¥æ</name><type>String</type></column><column><name>交货æ°é</name><type>Number</type></column><column><name>MRP计ç®çæ¬å·</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>æåæ</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>PRæ°æ®åéç¶æ</name><type>String</type></column><column><name>åéæ¶é´</name><type>String</type></column><column><name>åé人</name><type>String</type></column></table>'; sc := DateToString::StandardConverter(); sc.SetCustomConversion(); sc.CustomFormatString( 'yyyy-MM-dd' ); xmlDOMImplementation := XMLDOMImplementation::Create(); xmlDOMDocument := xmlDOMImplementation.CreateDocumentFromString( text ); tableElement:= xmlDOMDocument.GetElementByTagName( "table", 0 ); traverse ( toExportList, Elements, prd ) { PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.ProductID(), "ç©æç¼ç " ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.ProductName(), "ç©æåç§°" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.IsPanelMaterial(), "颿¿ç©ææ è¯" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, sc.Convert( prd.DeliveryDate() ), "äº¤è´§æ¥æ" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, sc.Convert( prd.PRSuggestionDate() ), "PRå»ºè®®æ¥æ" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]( prd.Quantity().Round( 0 ) ), "交货æ°é" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.MRPCalverNo(), "MRP计ç®çæ¬å·" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.BusinessType(), "ä¸å¡ç±»å" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.OrganCode(), "ç»ç»ç¼ç " ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.IsLongLeadItem(), "æ¯å¦é¿å¨æ" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.IsGenericMaterial(), "æ¯å¦ä¸ç¨æ" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.MaterialMRPType(), "ç©æè®¡åçç¥" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]prd.LeadTime(), "æåæ" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.ProviderCode(), "ä¾åºå代ç " ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.ProviderName(), "ä¾åºååç§°" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.StockingPointID(), "æ¶è´§åºåç¹" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.UnitOfMeasure(), "计éåä½" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.PRReleaseStatus(), "PRæ°æ®åéç¶æ" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.CreateTimeString(), "åéæ¶é´" ); PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, prd.CreateBy(), "åé人" ); } xmlDOMSerializer := xmlDOMImplementation.CreateSerializer(); xmlTableString := xmlDOMSerializer.WriteToString( xmlDOMDocument ); tableHandle := TableHandle::ImportXML( BinaryValue::Construct( xmlTableString ) ); tableGroupHandle := TableGroupHandle::Create( "PR" ); tableGroupHandle.Add( tableHandle ); tableBinaryData := XLS::SaveTableGroupToBinaryData( tableGroupHandle, true ); return tableBinaryData.AsBinaryValue(); *] } _Main/BL/Type_PRData/StaticMethod_GeneratesTheSpecifiedXMLColumn#56.qbl
_Main/UI/MacroPlannerWebApp/Component_Form633/Component_PanelPRDataButton.def
@@ -41,6 +41,8 @@ ] Properties: [ FixedSize: true Orientation: 'horizontal' Taborder: 0 ] } _Main/UI/MacroPlannerWebApp/Component_Form633/Response_DataHolderChecked_OnDataChanged#774.def
ÎļþÒÑɾ³ý _Main/UI/MacroPlannerWebApp/Component_Form633/Response_ListPRData_844_OnUserCheckedChanged#613.def
@@ -5,13 +5,12 @@ #keys: '[414384.0.798051611]' CanBindMultiple: false DefinitionID: 'Responsedef_WebList_OnUserCheckedChanged' GroupServerCalls: true QuillAction { Body: [* info( "checked 0 PRs" ); DataHolderChecked.Data().Flush(); *] GroupServerCalls: false } } _Main/UI/MacroPlannerWebApp/Component_Form633/Response_ListPRData_844_OnUserCheckedChanged.def
@@ -7,13 +7,12 @@ #keys: '[414384.0.798051163]' CanBindMultiple: false DefinitionID: 'Responsedef_WebList_OnUserCheckedChanged' GroupServerCalls: true QuillAction { Body: [* info( "checked " + [String]checkeditems.Size() + " PRs" ); DataHolderChecked.Data( checkeditems.Copy() ); *] GroupServerCalls: false } } _Main/UI/MacroPlannerWebApp/Component_Form633/Response_PanelPRDataButton_ButtonExportPR_OnClick.def
@@ -13,7 +13,7 @@ { Body: [* Application.Download( "PRData.xlsx", PRData::Export( MacroPlan ) ); Application.Download( "PRData.xlsx", PRData::ExportTheFileStream( DataHolderChecked.Data() ).AsBinaryData() ); *] GroupServerCalls: false } _Main/UI/MacroPlannerWebApp/Views/PR_DATA.vw
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,204 @@ Quintiq file version 2.0 { viewcontents { forms { form_FormPRHistoryData { title: 'QTIANMA_JITUAN::FormPRHistoryData' shown: true componentID: 'QTIANMA_JITUAN::FormPRHistoryData' layout { mode: 'open' rowPosition: 1 rowSpan: 15 columnPosition: 5 columnSpan: 8 } components { FormPRHistoryData_PanelPRHistoryButton { sizeRatio: 1 } FormPRHistoryData_ListPRHistoryData { } FormPRHistoryData_DataSetLevelPRHistoryData { groupDepth: -1 column_BusinessType { columnId: 'BusinessType' dataPath: 'BusinessType' dataType: 'string' index: 0 subtotals: '' width: 150 } column_MRPCalverNo { columnId: 'MRPCalverNo' dataPath: 'MRPCalverNo' dataType: 'string' index: 1 subtotals: '' width: 150 } column_OrganCode { columnId: 'OrganCode' dataPath: 'OrganCode' dataType: 'string' index: 2 subtotals: '' width: 150 } column_ProductID { columnId: 'ProductID' dataPath: 'ProductID' dataType: 'string' index: 3 subtotals: '' width: 150 } column_StockingPointID { columnId: 'StockingPointID' dataPath: 'StockingPointID' dataType: 'string' index: 4 subtotals: '' width: 150 } column_Quantity { columnId: 'Quantity' dataPath: 'Quantity' dataType: 'real' index: 5 subtotals: '' width: 150 } column_SendStatus { columnId: 'SendStatus' dataPath: 'SendStatus' dataType: 'string' index: 6 subtotals: '' width: 150 } column_ReleaseBy { columnId: 'ReleaseBy' dataPath: 'ReleaseBy' dataType: 'string' index: 7 subtotals: '' width: 150 } column_ReceiveStatus { columnId: 'ReceiveStatus' dataPath: 'ReceiveStatus' dataType: 'string' index: 8 subtotals: '' width: 150 } column_ReceiveError { columnId: 'ReceiveError' dataPath: 'ReceiveError' dataType: 'string' index: 9 subtotals: '' width: 150 } } } } form_FormPRData { title: 'QTIANMA_JITUAN::FormPRData' shown: true componentID: 'QTIANMA_JITUAN::FormPRData' layout { mode: 'open' rowPosition: 1 rowSpan: 15 columnPosition: 1 columnSpan: 4 } components { FormPRData_PanelPRDataButton { sizeRatio: 1 } FormPRData_ListPRData { } FormPRData_DataSetLevelPRData { groupDepth: -1 column_MRPCalverNo { columnId: 'MRPCalverNo' dataPath: 'MRPCalverNo' dataType: 'string' index: 0 subtotals: '' width: 150 } column_ProductID { columnId: 'ProductID' dataPath: 'ProductID' dataType: 'string' index: 1 subtotals: '' width: 150 } column_StockingPointID { columnId: 'StockingPointID' dataPath: 'StockingPointID' dataType: 'string' index: 2 subtotals: '' width: 150 } column_Quantity { columnId: 'Quantity' dataPath: 'Quantity' dataType: 'real' index: 3 subtotals: '' width: 150 } } } } } userconfigurableinformation { } page: 'ActionBarPageData' group: '' index: 0 image: 'BEAR' description: 'PRç³è¯·' } formatversion: 2 id: 'PR_DATA' name: 'PR_DATA' isglobal: false isroot: true }