已添加40个文件
已修改37个文件
已删除4个文件
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation H_MaterialInfo_MacroPlan_MacroPlan_H_MaterialInfo |
| | | { |
| | | #keys: '1[414724.0.142347478]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide MacroPlan |
| | | { |
| | | #keys: '3[414724.0.142347480][414724.0.142347479][414724.0.142347481]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: H_MaterialInfo |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide H_MaterialInfo |
| | | { |
| | | #keys: '3[414724.0.142347483][414724.0.142347482][414724.0.142347484]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: MacroPlan |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
| | |
| | | priorityName, salesSegmentName, currencyId, unitOfMeasureName, |
| | | false, customerName, customerId, orderId, orderLineId, true, true, true ); |
| | | } else { |
| | | result.Update( product, stockingPoint, orderDate, quantity, price, |
| | | priorityName, salesSegmentName, currencyId, unitOfMeasureName, |
| | | false, customerName, customerId, orderId, orderLineId, true, true, true ); |
| | | if( result.ProductID() = productId |
| | | and result.StockingPointID() = stockingPointId |
| | | and result.StartDate() = orderDate |
| | | and result.Quantity() = quantity |
| | | and result.Price() = price |
| | | and result.PriorityName() = priorityName |
| | | and result.SalesSegmentName() = salesSegmentName |
| | | and result.CurrencyID() = currencyId |
| | | and result.UnitOfMeasureName() = unitOfMeasureName |
| | | and result.CustomerName() = customerName |
| | | and result.CustomerID() = customerId |
| | | and result.OrderID() = orderId |
| | | and result.OrderLineID() = orderLineId ){ |
| | | info( "No need to update this order: " + id ); |
| | | }else{ |
| | | if( result.IsLocked() = true ){ |
| | | pispips := selectset( result, ProductInStockingPoint_MP.ProductInStockingPointInPeriod, pispip, true ); |
| | | pispipLeafs := selectset( pispips, |
| | | Elements.astype( ProductInStockingPointInPeriodPlanningLeaf ), |
| | | pispip, |
| | | true ); |
| | | ProductInStockingPointInPeriod::LockUnlockPlanning( pispipLeafs, false, true ); |
| | | } |
| | | result.Update( product, stockingPoint, orderDate, quantity, price, |
| | | priorityName, salesSegmentName, currencyId, unitOfMeasureName, |
| | | false, customerName, customerId, orderId, orderLineId, true, true, true ); |
| | | result.IsLocked( false ); |
| | | } |
| | | } |
| | | return result; |
| | | *] |
| | |
| | | owner.OrderLockLog( relnew, |
| | | CustomerName := order.CustomerName(), |
| | | End := order.First().AsPlanningBaseSalesDemandInPeriod().End().Date(), |
| | | EndDate := order.EndDate(), |
| | | EndDate := order.StartDate(), |
| | | IsLocked := order.IsLocked(), |
| | | LastModify := order.LastModify(), |
| | | LastModifyTime := order.LastModifyTime(), |
| | |
| | | owner.OrderLockLog( relnew, |
| | | CustomerName := order.CustomerName(), |
| | | End := order.First().AsPlanningBaseSalesDemandInPeriod().End().Date(), |
| | | EndDate := order.EndDate(), |
| | | EndDate := order.StartDate(), |
| | | IsLocked := order.IsLocked(), |
| | | LastModify := order.LastModify(), |
| | | LastModifyTime := order.LastModifyTime(), |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute StockingPointID |
| | | { |
| | | #keys: '3[414724.0.149657552][414724.0.149657551][414724.0.149657553]' |
| | | Description: 'åºåç¹' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SM_GetALlBOM ( |
| | | MacroPlan Owner, |
| | | MappingBOM Material |
| | | ) as Number |
| | | { |
| | | Description: 'æ ¹æ®SKUè·åææ ¹é¨æææ°æ®' |
| | | TextBody: |
| | | [* |
| | | AllMaterials := selectset( Owner,MappingBOM,Obj,Obj.ComponentCode()=Material.ProductCode()) |
| | | if( AllMaterials.Size()>0) |
| | | { |
| | | traverse( AllMaterials,Elements,Obj,not isnull( Obj)) |
| | | { |
| | | H_FunctionClass::SM_GetALlBOM( Owner,Obj); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | Owner.H_MaterialInfo(relnew,ID := H_FunctionClass::SM_GenerateID( "BM") |
| | | ,MaterialName := Material.ComponentType() ); |
| | | |
| | | } |
| | | return 0; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SM_GetBOMBySKU ( |
| | | MacroPlan Owner, |
| | | String SKU |
| | | ) as MappingBOM |
| | | { |
| | | Description: 'æ ¹æ®SKUè·åBOM' |
| | | TextBody: |
| | | [* |
| | | Obj :=null( MappingBOM,constcontent ); |
| | | if( not isnull( Owner) and SKU.Length()>0) |
| | | { |
| | | Obj := select( Owner,MappingBOM,ObjM,ObjM.ProductCode()=SKU); |
| | | } |
| | | return Obj; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SM_GetMaterialData ( |
| | | MacroPlan Owner, |
| | | String ParentSKU, |
| | | Number ProductQty, |
| | | String ForecastId, |
| | | String VCode, |
| | | Date NDate |
| | | ) as owning JSON |
| | | { |
| | | Description: 'è·åç©æä¿¡æ¯' |
| | | TextBody: |
| | | [* |
| | | /**********************************åå§åç©æä¿¡æ¯*************************************** |
| | | *å建人ï¼yunying |
| | | *åå»ºæ¥æï¼2023-09-21 |
| | | *æè¿°ï¼æ ¹æ®SKUè·åä¸ä¸å±ç©ææ°æ®,è¿é䏿¯éåå¾å°ææï¼æ¶è§¦å䏿¬¡å¾å°ä¸å±ï¼å¹¶ç´¯è®¡ |
| | | *åæ°ï¼ |
| | | *****************************************************************************************/ |
| | | // åå§åç»æ |
| | | bStatus := false; |
| | | strMsg :=""; |
| | | |
| | | try{ |
| | | if( Owner.MappingBOM(relsize )>0) |
| | | { |
| | | // å¾å°ä¸ä¸çº§æ°æ® |
| | | AllData:= selectset( Owner, MappingBOM,object,object.ComponentCode()=ParentSKU); |
| | | ObjProduct := null( MappingProduct,constcontent ); |
| | | ObjUnit := null( Unit,constcontent ); |
| | | MaterialType:=""; |
| | | MaterialName:="-"; |
| | | StockPoint := ""; |
| | | NRate:=1.0; |
| | | NComponentsUsed :=0.0; |
| | | ObjBOM := H_FunctionClass::SM_GetBOMBySKU( Owner,ParentSKU); |
| | | if(not isnull( ObjBOM)) |
| | | { |
| | | NRate := ObjBOM.ComponentOutputRate(); |
| | | NComponentsUsed := ObjBOM.UnitUsageOfComponents(); |
| | | // äº§åºæ¯å¼å¸¸æ 100%产åºè®¡ç® |
| | | if( NRate <=0.0) |
| | | { |
| | | NRate :=1.0; |
| | | } |
| | | } |
| | | if( AllData.Size()>0) |
| | | { |
| | | traverse( AllData,Elements,Obj,not isnull( Obj)) |
| | | { |
| | | // å¾å°å½åå·²åå¨çç©æä¿¡æ¯ï¼è®¢åID + SKUï¼ |
| | | ObjMaterial := select( Owner,H_MaterialInfo,ObjM,ObjM.ForecastID()=ForecastId and ObjM.SKU()=Obj.ProductCode()); |
| | | if( isnull( ObjMaterial)) |
| | | { |
| | | // ç©æç±»å |
| | | MaterialType := Obj.ProductType(); |
| | | // å¾å°ç©æä¿¡æ¯ |
| | | ObjProduct:= H_FunctionClass::SM_GetProductInfo(Owner, Obj.ProductCode()); |
| | | if( not isnull( ObjProduct)) |
| | | { |
| | | MaterialType:= ObjProduct.ProductMajorType(); |
| | | MaterialName:=ObjProduct.Name(); |
| | | } |
| | | ObjUnit:= H_FunctionClass::SM_GetUnitBySKU( Owner,Obj.ProductCode()); |
| | | if( not isnull( ObjUnit)) |
| | | { |
| | | StockPoint:= ObjUnit.Name(); |
| | | } |
| | | Owner.H_MaterialInfo(relnew,ParentSKU := Obj.ComponentCode(),SKU := Obj.ProductCode(),ForecastID := ForecastId,OrgCode := Obj.OrganCode(),VCode := VCode |
| | | ,ID := H_FunctionClass::SM_GenerateID( "MI"),MaterialType := MaterialType,NeedDate := NDate |
| | | ,NeedQty := [Number](ProductQty/NRate*NComponentsUsed).Round( 0),Unit := Obj.UnitOfMeasureName() |
| | | ,StockPoint :=StockPoint,MaterialName := MaterialName ); |
| | | } |
| | | else |
| | | { |
| | | // èèæ¯å¦è¦æ´æ°æ°æ®ï¼æä¸å¤ç |
| | | } |
| | | } |
| | | } |
| | | } |
| | | // 没æBOM æ·»å æµè¯æ°æ® |
| | | else |
| | | { |
| | | nCount :=Owner.H_MaterialInfo(relsize ); |
| | | Owner.H_MaterialInfo(relnew,ParentSKU := ParentSKU,SKU := "SKU"+ nCount.AsQUILL() ,ForecastID := ForecastId,OrgCode := "ORG_000",VCode := VCode |
| | | ,ID := H_FunctionClass::SM_GenerateID( "MI"),MaterialType := "åææ",NeedDate := NDate |
| | | ,NeedQty := [Number](ProductQty*0.8).Round( 0),Unit := "PCS" |
| | | ,StockPoint :="æµè¯",MaterialName := "æµè¯æ°æ®" ); |
| | | } |
| | | bStatus := true; |
| | | strMsg :=""; |
| | | } |
| | | onerror |
| | | { |
| | | strMsg :="å è½½ç©æå¤±è´¥ï¼è¯·è系系ç»ç®¡çåï¼"; |
| | | Owner.H_ErrorLogs(relnew,EClassName := "H_FunctionClass",EDateTime := DateTime::ActualGMTTime(),EFunctionName := "SM_InitialForcastData", |
| | | DeveloperInformation := e.DeveloperInformation(),ErrorNr := e.ErrorNr(),DetailedInformation := e.DetailedInformation(), |
| | | GeneralInformation := e.GeneralInformation()); |
| | | } |
| | | return JSON::Object().Add( "Status",bStatus) |
| | | .Add( "Msg",strMsg).Build(); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SM_GetProductInfo ( |
| | | MacroPlan Owner, |
| | | String SKU |
| | | ) as MappingProduct |
| | | { |
| | | Description: 'æ ¹æ®SKUè·åç©æä¿¡æ¯' |
| | | TextBody: |
| | | [* |
| | | // æ ¹æ®SKUè·åç©æä¿¡æ¯ |
| | | Obj := null( MappingProduct,constcontent ); |
| | | if( not isnull( Owner) and SKU.Length()>0) |
| | | { |
| | | Obj:= select( Owner,MappingProduct,ObjMP,ObjMP.ID()=SKU); |
| | | } |
| | | return Obj; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SM_GetUnitBySKU ( |
| | | MacroPlan Owner, |
| | | String SKU |
| | | ) as Unit |
| | | { |
| | | Description: 'éè¿SKUè·ååºåç¹ä¿¡æ¯' |
| | | TextBody: |
| | | [* |
| | | Obj :=null( Unit,constcontent ); |
| | | if( not isnull( Owner) and SKU.Length()>0) |
| | | { |
| | | OrgCode := select( Owner,MappingBOM,ObjM,ObjM.ProductCode()=SKU); |
| | | if( not isnull( OrgCode)) |
| | | { |
| | | Obj := select( Owner,Unit,ObjU,ObjU.ID()= OrgCode.OrganCode()); |
| | | } |
| | | } |
| | | return Obj; |
| | | *] |
| | | } |
| | |
| | | strMsg :=""; |
| | | |
| | | try{ |
| | | // 颿µæ°æ®2æ¤å¤çï¼çé+客æ·åç§°æåï¼ |
| | | // æ¸
餿§æ°æ®ï¼éæ°æå |
| | | if(Owner.H_Forecast(relget ).Size()>0) |
| | | { |
| | | traverse( Owner,H_Forecast,Obj,not isnull( Obj)) |
| | |
| | | Owner.H_Forecast(reldelete, Obj); |
| | | } |
| | | } |
| | | |
| | | // è·å颿µè®¢åï¼å½æåä¹åç3个æé¢æµæ°æ® ä¸é¢æµæ°é>0ç |
| | | AllData:= selectset( Owner, Product_MP.SalesDemand.astype( Forecast ),object,object.EndDate().DateTime().Date() >= Date::ActualDate().StartOfMonth() |
| | | and object.EndDate().DateTime().Date() <= Date::ActualDate().StartOfNextMonth().StartOfNextMonth().StartOfNextMonth().StartOfNextMonth() |
| | | and object.Quantity()>0 ); |
| | |
| | | CustomName:=""; |
| | | DepartMent:=""; |
| | | idx:=0; |
| | | strOrderCode:=""; |
| | | RQty:=0; |
| | | ObjOrderRealQty:=null( H_OrderForecastRealQty,constcontent ); |
| | | // ObjPruduct :=null( MappingProduct,constcontent ); |
| | | traverse( AllData,Elements,Obj,not isnull(Obj)) |
| | | { |
| | | // è¿éç¨æ¥æ¾åæªåï¼å 为ä¸ç¡®å®æå 个横线ï¼ä»¥ç¬¬ä¸ä¸ªä¸ºå |
| | | idx:=Obj.SalesSegmentName().FindString( "-",0); |
| | | if(idx>0) |
| | | { |
| | |
| | | else |
| | | { |
| | | CustomName :=Obj.SalesSegmentName(); |
| | | DepartMent := Obj.SalesSegmentName(); |
| | | DepartMent := "é¨é¨æ°æ®è·å失败ï¼" |
| | | } |
| | | |
| | | Owner.H_Forecast(relnew,OrderCode := H_FunctionClass::SM_GenerateID( "OF"), |
| | | // // ä»ç©æè¡¨è·åç©æä¿¡æ¯ |
| | | // ObjPruduct := H_FunctionClass::SM_GetProductInfo( Owner,Obj.ProductID()); |
| | | // if( not isnull( ObjPruduct)) |
| | | // { |
| | | // |
| | | // } |
| | | // åå
¥é¢æµè®¢åä¿¡æ¯è¡¨ |
| | | strOrderCode:=H_FunctionClass::SM_GenerateID( "OF"); |
| | | Owner.H_Forecast(relnew,OrderCode := strOrderCode, |
| | | SKU := Obj.ProductID(), |
| | | CustomCode := CustomName, |
| | | CustomCode := CustomName, |
| | | CustomName := CustomName, |
| | | Util:=Obj.UnitOfMeasureName(), |
| | | NeedTime:=Obj.EndDate(), |
| | | ForecastQty:=[Number]Obj.Quantity().Round( 0), |
| | | StockingPointID := Obj.StockingPointID(), |
| | | Department:=DepartMent); |
| | | // åå
¥é¢æµå®æ¶ä¿¡æ¯ |
| | | ObjOrderRealQty := select( Owner,H_OrderForecastRealQty,ObjO,ObjO.CustomID()=CustomName and ObjO.SKU()=Obj.ProductID() |
| | | and ObjO.Month().StartOfMonth() = Obj.EndDate().StartOfMonth() ) |
| | | if( isnull( ObjOrderRealQty)) |
| | | { |
| | | Owner.H_OrderForecastRealQty(relnew,CustomID := CustomName,CustomName := CustomName,ForecatsQty := [Number]Obj.Quantity().Round( 0) |
| | | ,ForecatsRealQty := [Number]Obj.Quantity().Round( 0),ID := H_FunctionClass::SM_GenerateID( "OR") |
| | | ,Month := Obj.EndDate(),OrderCode := strOrderCode,SKU := Obj.ProductID(),Unit := Obj.UnitOfMeasureName()); |
| | | } |
| | | else |
| | | { |
| | | if( [Number]Obj.Quantity().Round( 0)<> ObjOrderRealQty.ForecatsQty()) |
| | | { |
| | | RQty := [Number]Obj.Quantity().Round( 0) - ObjOrderRealQty.ForecatsQty(); |
| | | RQty := ObjOrderRealQty.ForecatsRealQty() + RQty; |
| | | if( RQty<0) |
| | | { |
| | | RQty :=0; |
| | | } |
| | | ObjOrderRealQty.ForecatsQty([Number]Obj.Quantity().Round( 0)); |
| | | ObjOrderRealQty.ForecatsRealQty(RQty); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | bStatus := true; |
| | | strMsg :="订å颿µåå§åæå!"; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SM_InitialForcastDataEx ( |
| | | MacroPlan Owner, |
| | | Boolean IsNew |
| | | ) as owning JSON |
| | | { |
| | | Description: 'åå§å订å颿µä¿¡æ¯' |
| | | TextBody: |
| | | [* |
| | | /**********************************åå§å订å颿µä¿¡æ¯*************************************** |
| | | *æ³¨ï¼æªç¡®å®ä¸æ¸¸é¢æµè®¢åæ´æ°é»è¾åæ°æ®æææ§ï¼è¿éè¿è¡äºæ¬¡å¤çï¼æ°çæä¸ä¸ªå表ï¼é¿å
䏿¸¸ä¿¡æ¯åå¨ä¸¥é |
| | | * å½±ååè½ |
| | | * |
| | | *****************************************************************************************/ |
| | | // åå§åç»æ |
| | | bStatus := false; |
| | | strMsg :=""; |
| | | |
| | | try{ |
| | | // æ¸
餿§æ°æ®ï¼éæ°æå |
| | | if(Owner.H_Forecast(relget ).Size()>0) |
| | | { |
| | | traverse( Owner,H_Forecast,Obj,not isnull( Obj)) |
| | | { |
| | | Owner.H_Forecast(reldelete, Obj); |
| | | } |
| | | } |
| | | |
| | | // è·å颿µè®¢åï¼å½æåä¹åç3个æé¢æµæ°æ® ä¸é¢æµæ°é>0ç |
| | | AllData:= selectset( Owner, Product_MP.SalesDemand.astype( Forecast ),object,object.EndDate().DateTime().Date() >= Date::ActualDate().StartOfMonth() |
| | | and object.EndDate().DateTime().Date() <= Date::ActualDate().StartOfNextMonth().StartOfNextMonth().StartOfNextMonth().StartOfNextMonth() |
| | | and object.Quantity()>0 ); |
| | | |
| | | CustomName:=""; |
| | | DepartMent:=""; |
| | | idx:=0; |
| | | strOrderCode:=""; |
| | | RQty:=0; |
| | | ObjOrderRealQty:=null( H_OrderForecastRealQty,constcontent ); |
| | | // ObjPruduct :=null( MappingProduct,constcontent ); |
| | | traverse( AllData,Elements,Obj,not isnull(Obj)) |
| | | { |
| | | // è¿éç¨æ¥æ¾åæªåï¼å 为ä¸ç¡®å®æå 个横线ï¼ä»¥ç¬¬ä¸ä¸ªä¸ºå |
| | | idx:=Obj.SalesSegmentName().FindString( "-",0); |
| | | if(idx>0) |
| | | { |
| | | DepartMent:=Obj.SalesSegmentName().SubString( 0,idx); |
| | | CustomName := Obj.SalesSegmentName().SubString( idx+1, Obj.SalesSegmentName().Length() - (idx+1)); |
| | | } |
| | | else |
| | | { |
| | | CustomName :=Obj.SalesSegmentName(); |
| | | DepartMent := "é¨é¨æ°æ®è·å失败ï¼" |
| | | } |
| | | // // ä»ç©æè¡¨è·åç©æä¿¡æ¯ |
| | | // ObjPruduct := H_FunctionClass::SM_GetProductInfo( Owner,Obj.ProductID()); |
| | | // if( not isnull( ObjPruduct)) |
| | | // { |
| | | // |
| | | // } |
| | | // åå
¥é¢æµè®¢åä¿¡æ¯è¡¨ |
| | | strOrderCode:=H_FunctionClass::SM_GenerateID( "OF"); |
| | | Owner.H_Forecast(relnew,OrderCode := strOrderCode, |
| | | SKU := Obj.ProductID(), |
| | | CustomCode := CustomName, |
| | | CustomName := CustomName, |
| | | Util:=Obj.UnitOfMeasureName(), |
| | | NeedTime:=Obj.EndDate(), |
| | | ForecastQty:=[Number]Obj.Quantity().Round( 0), |
| | | StockingPointID := Obj.StockingPointID(), |
| | | Department:=DepartMent); |
| | | // åå
¥é¢æµå®æ¶ä¿¡æ¯ |
| | | ObjOrderRealQty := select( Owner,H_OrderForecastRealQty,ObjO,ObjO.CustomID()=CustomName and ObjO.SKU()=Obj.ProductID() |
| | | and ObjO.Month().StartOfMonth() = Obj.EndDate().StartOfMonth() ) |
| | | if( isnull( ObjOrderRealQty)) |
| | | { |
| | | Owner.H_OrderForecastRealQty(relnew,CustomID := CustomName,CustomName := CustomName,ForecatsQty := [Number]Obj.Quantity().Round( 0) |
| | | ,ForecatsRealQty := [Number]Obj.Quantity().Round( 0),ID := H_FunctionClass::SM_GenerateID( "OR") |
| | | ,Month := Obj.EndDate(),OrderCode := strOrderCode,SKU := Obj.ProductID(),Unit := Obj.UnitOfMeasureName()); |
| | | } |
| | | else |
| | | { |
| | | if( IsNew) |
| | | { |
| | | ObjOrderRealQty.ForecatsQty([Number]Obj.Quantity().Round( 0)); |
| | | ObjOrderRealQty.ForecatsRealQty([Number]Obj.Quantity().Round( 0)); |
| | | } |
| | | else |
| | | { |
| | | if( [Number]Obj.Quantity().Round( 0)<> ObjOrderRealQty.ForecatsQty()) |
| | | { |
| | | RQty := [Number]Obj.Quantity().Round( 0) - ObjOrderRealQty.ForecatsQty(); |
| | | RQty := ObjOrderRealQty.ForecatsRealQty() + RQty; |
| | | if( RQty<0) |
| | | { |
| | | RQty :=0; |
| | | } |
| | | ObjOrderRealQty.ForecatsQty([Number]Obj.Quantity().Round( 0)); |
| | | ObjOrderRealQty.ForecatsRealQty(RQty); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | bStatus := true; |
| | | strMsg :="订å颿µåå§åæå!"; |
| | | } |
| | | onerror |
| | | { |
| | | strMsg :="订å颿µåå§å失败ï¼å¯è½å½±åå²å计ç®ï¼è¯·è系系ç»ç®¡çåï¼"; |
| | | Owner.H_ErrorLogs(relnew,EClassName := "H_FunctionClass",EDateTime := DateTime::ActualGMTTime(),EFunctionName := "SM_InitialForcastData", |
| | | DeveloperInformation := e.DeveloperInformation(),ErrorNr := e.ErrorNr(),DetailedInformation := e.DetailedInformation(), |
| | | GeneralInformation := e.GeneralInformation()); |
| | | } |
| | | return JSON::Object().Add( "Status",bStatus) |
| | | .Add( "Msg",strMsg).Build(); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod SM_OrderHedging ( |
| | | MacroPlan Owner, |
| | | Boolean IsNew, |
| | | String Operator, |
| | | String OperatorType |
| | | ) as owning JSON |
| | | { |
| | | Description: '订åå²åè°ç¨å½æ°' |
| | | TextBody: |
| | | [* |
| | | /************************************订åå²åè°ç¨****************************** |
| | | *彿°åï¼SM_OrderHedging |
| | | *å建人ï¼yunying |
| | | *å建æ¶é´ï¼20230-09-24 |
| | | *æè¿°ï¼ç³»ç»å
订åå²åè°ç¨å½æ°ï¼IsNew=trueæ¶ï¼éæ°å¤ç颿µä¿¡æ¯ï¼IsNew=falseæ¶ï¼ç¨é¢æµç´¯è®¡ä¿¡æ¯ã |
| | | *****************************************************************************/ |
| | | // åå§åç»æ |
| | | bStatus := false; |
| | | strMsg :=""; |
| | | // è·åçæ¬å·,è¿éæ¯å¦éè¦åçæ¬å·åè½å¯¹æ¥ |
| | | VCode :=H_FunctionClass::SM_GenerateID("VC"); |
| | | |
| | | try{ |
| | | if( not isnull( Owner)) |
| | | { |
| | | // åå§å颿µä¿¡æ¯ |
| | | JResult := H_FunctionClass::SM_InitialForcastDataEx( Owner,IsNew); |
| | | if( JResult.Get( "Status").GetBoolean()) |
| | | { |
| | | traverse( Owner,SalesDemand.astype( CustomerOrder ),ObjOrder,not isnull( ObjOrder)) |
| | | { |
| | | //----------------------------------------以ä¸åå»é¢æµ åç¾ æææ°æ®ä¿¡æ¯---------------- |
| | | nForecastQtyOld := 0; //å颿µæ°é |
| | | nReverseQtyOld :=0; //ååç¾æ°é |
| | | nAuthorizeQtyOld :=0; //åæææ°é |
| | | nForecastQtyNew :=0; //计ç®åç颿µæ°é |
| | | nReverseQtyNew :=0; //计ç®åçåç¾æ°é |
| | | nAuthorizeQtyNew :=0; //计ç®åçæææ°é |
| | | nHaveForecastQty :=0; //æé¢æµæ°é |
| | | nNoHaveForecastQty:=0;//äºé¢æµæ°é |
| | | OrderQuantity := 0; //å©ä½è®¢åæ°é |
| | | |
| | | // è·å颿µæ°éï¼å®¢æ·+SKU+æä»½ çè®ºæ¯æ²¡æç©æé¢æµï¼ |
| | | OrderForecast := select(Owner, H_OrderForecastRealQty , Obj, Obj.SKU() = ObjOrder.ProductID() |
| | | and Obj.CustomID() = ObjOrder.CustomerName() |
| | | and Obj.Month().Format( "YM2") =ObjOrder.EndDate().Format( "YM2")); |
| | | if ( not isnull(OrderForecast)) |
| | | { |
| | | nForecastQtyOld := OrderForecast.ForecatsRealQty(); |
| | | nForecastQtyNew := nForecastQtyOld; |
| | | } |
| | | |
| | | // è·ååç¾æ°éï¼åªå¤æSKUï¼ |
| | | ObjReverse := select(Owner, H_ReverseRealQty , Obj, Obj.SKU() = ObjOrder.ProductID()); |
| | | if ( not isnull(ObjReverse)) |
| | | { |
| | | nReverseQtyOld := ObjReverse.ReverseRealQty(); |
| | | nReverseQtyNew := nReverseQtyOld; |
| | | } |
| | | |
| | | // è·åæææ°éï¼å®¢æ·ID+SKUï¼ |
| | | ObjAuthorize := select(Owner, H_AuthorizeRealQty , Obj, Obj.SKU() = ObjOrder.ProductID() |
| | | and Obj.CustomID() = ObjOrder.CustomerName()); |
| | | if ( not isnull(ObjAuthorize)) |
| | | { |
| | | nAuthorizeQtyOld := ObjAuthorize.AuthorizeRealQty(); |
| | | nAuthorizeQtyNew :=nAuthorizeQtyOld; |
| | | } |
| | | //-----------------------------以ä¸è®¢åå²å-------------------- |
| | | // ææè®°å½ID |
| | | AQID := H_FunctionClass::SM_GenerateID( "AQ"); |
| | | // 订åå©ä½æ°é |
| | | OrderQuantity := [Number]ObjOrder.Quantity().Round( 0); |
| | | // 1 å
岿æ |
| | | if( OrderQuantity>0 and nAuthorizeQtyOld>0) |
| | | { |
| | | OrderQuantity := OrderQuantity-nAuthorizeQtyOld; |
| | | nAuthorizeQtyNew :=0; |
| | | if( OrderQuantity<0) |
| | | { |
| | | nAuthorizeQtyNew := abs(OrderQuantity); |
| | | OrderQuantity :=0; |
| | | } |
| | | } |
| | | // 2 åå²åç¾ |
| | | if( OrderQuantity>0 and nReverseQtyOld>0) |
| | | { |
| | | OrderQuantity := OrderQuantity-nReverseQtyOld; |
| | | nReverseQtyNew :=0; |
| | | if( OrderQuantity<0) |
| | | { |
| | | nReverseQtyNew := abs(OrderQuantity); |
| | | OrderQuantity :=0; |
| | | } |
| | | } |
| | | // 3 æåå²é¢æµ |
| | | if( OrderQuantity>0 and nForecastQtyOld>0) |
| | | { |
| | | //é»è®¤è®¢åæ°é>颿µæ°é |
| | | OrderQuantity := OrderQuantity-nForecastQtyOld; |
| | | nForecastQtyNew :=0; |
| | | nHaveForecastQty := nForecastQtyOld; |
| | | nNoHaveForecastQty := OrderQuantity; |
| | | if( OrderQuantity<0) |
| | | { |
| | | nForecastQtyNew := abs(OrderQuantity); |
| | | OrderQuantity :=0; |
| | | nHaveForecastQty := nForecastQtyOld - nForecastQtyNew; |
| | | nNoHaveForecastQty := 0; |
| | | } |
| | | } |
| | | // è®°å½å¨ä½ |
| | | Owner.H_OrderRecord(relnew, |
| | | ID := AQID, |
| | | VCode:=VCode, |
| | | SKU:=ObjOrder.ProductID(), |
| | | ReverseQty := nReverseQtyNew, |
| | | CustomerCode := ObjOrder.CustomerName(), |
| | | CustomerName := ObjOrder.CustomerName(), |
| | | ForecastQty := nForecastQtyNew, |
| | | OrderDateTime := ObjOrder.EndDate(), |
| | | OrderQty := [Number]ObjOrder.Quantity().Round( 0), |
| | | OrderCode:=ObjOrder.OrderID(), |
| | | AuthorizeQty := nAuthorizeQtyNew, |
| | | ReverseDeductQty := nReverseQtyOld - nReverseQtyNew, |
| | | AuthorizeDeductQty := 0, |
| | | ForecastHitQty :=nHaveForecastQty, |
| | | ForecastNoHitQty :=nNoHaveForecastQty, |
| | | OperateType := OperatorType, |
| | | Operator := Operator, |
| | | Unit := ObjOrder.UnitOfMeasureName(), |
| | | OperateQty := [Number]ObjOrder.Quantity().Round( 0), |
| | | OperateTime := DateTime::ActualTime()); |
| | | |
| | | // æ´æ°å½ååç¾æ°é |
| | | if( not isnull( ObjReverse)) |
| | | { |
| | | ObjReverse.ReverseRealQty(nReverseQtyNew); |
| | | } |
| | | else |
| | | { |
| | | Owner.H_ReverseRealQty(relnew,ID := H_FunctionClass::SM_GenerateID( "RQ"),SKU := ObjOrder.ProductID(),Unit := ObjOrder.UnitOfMeasureName() |
| | | ,ReverseRealQty := nReverseQtyNew); |
| | | } |
| | | // æ´æ°ææ |
| | | if( not isnull( ObjAuthorize)) |
| | | { |
| | | ObjAuthorize.AuthorizeRealQty(nAuthorizeQtyNew); |
| | | } |
| | | else |
| | | { |
| | | Owner.H_AuthorizeRealQty(relnew,ID := H_FunctionClass::SM_GenerateID( "AR"),SKU := ObjOrder.ProductID(), |
| | | Month := ObjOrder.EndDate(), |
| | | CustomID := ObjOrder.CustomerName(), |
| | | CustomName := ObjOrder.CustomerName(), |
| | | OrderCode := "-", |
| | | AuthorizeRealQty :=nAuthorizeQtyNew, |
| | | Unit := ObjOrder.UnitOfMeasureName()); |
| | | } |
| | | // æ´æ°é¢æµ |
| | | if( not isnull( OrderForecast)) |
| | | { |
| | | OrderForecast.ForecatsRealQty(nForecastQtyNew); |
| | | } |
| | | else |
| | | { |
| | | Owner.H_OrderForecastRealQty(relnew,ID := H_FunctionClass::SM_GenerateID( "OF"),SKU := ObjOrder.ProductID(), |
| | | Month := ObjOrder.EndDate(), |
| | | CustomID := ObjOrder.CustomerName(), |
| | | CustomName := ObjOrder.CustomerName(), |
| | | OrderCode := "-", |
| | | ForecatsQty :=0, |
| | | ForecatsRealQty :=nForecastQtyNew, |
| | | Unit := ObjOrder.UnitOfMeasureName()); |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | strMsg:="颿µè®¢åä¿¡æ¯å 载失败ï¼è¯·è系系ç»ç®¡çåï¼"; |
| | | } |
| | | } |
| | | } |
| | | onerror |
| | | { |
| | | strMsg :="订åå²ååçé误ï¼è¯·è系系ç»ç®¡çåï¼"; |
| | | // è¿éæ¯å¦è¦å é¤å·²åå»ºçæ°æ®ï¼å¾
å®ï¼å¦ææçæ¬å·å¯ä»¥ä¸å é¤ |
| | | |
| | | // è®°å½é误æ¥å¿ |
| | | Owner.H_ErrorLogs(relnew,EClassName := "H_FunctionClass",EDateTime := DateTime::ActualGMTTime(),EFunctionName := "SM_InitialForcastData", |
| | | DeveloperInformation := e.DeveloperInformation(),ErrorNr := e.ErrorNr(),DetailedInformation := e.DetailedInformation(), |
| | | GeneralInformation := e.GeneralInformation()); |
| | | } |
| | | return JSON::Object().Add( "Status",bStatus) |
| | | .Add( "VersionCode",VCode) |
| | | .Add( "Msg",strMsg).Build(); |
| | | *] |
| | | } |
| | |
| | | { |
| | | #keys: '5[414724.0.53669729][414724.0.53669727][0.0.0][414724.0.53669728][414724.0.53669730]' |
| | | BaseType: Object |
| | | Description: 'å²åæä½ç±»' |
| | | Description: 'å²åæä½å
¬ç¨ç±»' |
| | | StructuredName: 'H_FunctionClasss' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ForecastID |
| | | { |
| | | #keys: '3[414724.0.150662643][414724.0.150662642][414724.0.150662644]' |
| | | Description: '颿µID' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ID |
| | | { |
| | | #keys: '3[414724.0.142347495][414724.0.142347494][414724.0.142347496]' |
| | | Description: '主é®ID' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute MaterialName |
| | | { |
| | | #keys: '3[414724.0.142347535][414724.0.142347534][414724.0.142347536]' |
| | | Description: 'ç©æåç§°' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute MaterialType |
| | | { |
| | | #keys: '3[414724.0.142347525][414724.0.142347524][414724.0.142347526]' |
| | | Description: 'ç©æç±»åï¼æåãåæåãåææï¼ï¼ï¼ï¼' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute NeedDate |
| | | { |
| | | #keys: '3[414724.0.143344655][414724.0.143344654][414724.0.143344656]' |
| | | Description: 'éæ±æ¶é´' |
| | | ValueType: Date |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute NeedQty |
| | | { |
| | | #keys: '3[414724.0.142347555][414724.0.142347554][414724.0.142347556]' |
| | | Description: 'éæ±æ°é' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute OrgCode |
| | | { |
| | | #keys: '3[414724.0.142347565][414724.0.142347564][414724.0.142347566]' |
| | | Description: 'ç»ç»ä»£ç ' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ParentSKU |
| | | { |
| | | #keys: '3[414724.0.142347515][414724.0.142347514][414724.0.142347516]' |
| | | Description: 'ç¶ç©æSKU' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute SKU |
| | | { |
| | | #keys: '3[414724.0.142347505][414724.0.142347504][414724.0.142347506]' |
| | | Description: 'SKU(产åãåæåãç©æï¼' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute StockPoint |
| | | { |
| | | #keys: '3[414724.0.142347575][414724.0.142347574][414724.0.142347576]' |
| | | Description: 'åºåç¹' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Unit |
| | | { |
| | | #keys: '3[414724.0.142347545][414724.0.142347544][414724.0.142347546]' |
| | | Description: 'åä½' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute VCode |
| | | { |
| | | #keys: '3[414724.0.142347585][414724.0.142347584][414724.0.142347586]' |
| | | Description: 'çæ¬å·' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type H_MaterialInfo |
| | | { |
| | | #keys: '5[414724.0.142347475][414724.0.142347473][0.0.0][414724.0.142347474][414724.0.142347476]' |
| | | BaseType: Object |
| | | Description: 'ç©æä¿¡æ¯' |
| | | StructuredName: 'H_MaterialInfos' |
| | | } |
| | |
| | | info( "dealing 颿¿åé
é" ) |
| | | if( CapacityAndSaleBudgeFilterItem::Contains( items, "颿¿åé
é" ) ) { |
| | | traverse( years, Elements, year ) { |
| | | info( "颿¿åé
é" + [String]year.YearNo() + "å¹´" ); |
| | | // å岿°æ® |
| | | info( "颿¿åé
é" + [String]year.YearNo() + "å¹´å岿°æ®" ); |
| | | traverse( months, Elements, month ) { |
| | | columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "颿¿åé
é-" + [String]year.YearNo() + "å¹´-" + [String]month.MonthNo() + "æ-年度é¢ç®" ); |
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
| | |
| | | cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal ); |
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
| | | } |
| | | info( "颿¿åé
é" + [String]year.YearNo() + "å¹´S&OPæ°æ®" ); |
| | | // S&OPæ°æ® |
| | | traverse( macroPlans, Elements, macroPlan ) { |
| | | traverse( months, Elements, month ) { |
| | |
| | | info( "dealing éå®é¢" ) |
| | | if( CapacityAndSaleBudgeFilterItem::Contains( items, "éå®é¢" ) ) { |
| | | traverse( years, Elements, year ) { |
| | | info( "éå®é¢" + [String]year.YearNo() + "å¹´" ); |
| | | // å岿°æ® |
| | | info( "éå®é¢" + [String]year.YearNo() + "å¹´å岿°æ®" ); |
| | | traverse( months, Elements, month ) { |
| | | columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "对å¤éå®é¢-" + [String]year.YearNo() + "å¹´-" + [String]month.MonthNo() + "æ-年度é¢ç®" ); |
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
| | |
| | | cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal ); |
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
| | | } |
| | | info( "éå®é¢" + [String]year.YearNo() + "å¹´å岿°æ®S&OPæ°æ®" ); |
| | | // S&OPæ°æ® |
| | | traverse( macroPlans, Elements, macroPlan ) { |
| | | traverse( months, Elements, month ) { |
| | |
| | | info( "dealing å¤§å¼ çå©é¢" ) |
| | | traverse( years, Elements, year ) { |
| | | // å岿°æ® |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "å¤§å¼ çå©é¢-年度é¢ç®" ); |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "å¤§å¼ çå©é¢-" + [String]year.YearNo() + "å¹´-年度é¢ç®" ); |
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
| | | // todo |
| | | // QID 23 |
| | |
| | | } |
| | | // S&OPæ°æ® |
| | | traverse( macroPlans, Elements, macroPlan ) { |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "å¤§å¼ çå©é¢-" + [String]year.YearNo() + "å¹´" ); |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "å¤§å¼ çå©é¢-" + [String]year.YearNo() + "å¹´-" + macroPlan.ScenarioName() ); |
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
| | | cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]Number::Random( 0, 0 ) ); |
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
| | |
| | | info( "dealing 产åçå©é¢" ) |
| | | traverse( years, Elements, year ) { |
| | | // å岿°æ® |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "产åçå©é¢-年度é¢ç®" ); |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "产åçå©é¢-" + [String]year.YearNo() + "å¹´-年度é¢ç®" ); |
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
| | | // todo |
| | | // QID 23 |
| | | cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]Number::Random( 0, 0 ) ); |
| | | cell.CapacityAndSaleBudgeCompareItemRow( relset, row ); |
| | | } |
| | | // S&OPæ°æ® |
| | | traverse( macroPlans, Elements, macroPlan ) { |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "产åçå©é¢-" + [String]year.YearNo() + "å¹´" ); |
| | | columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "产åçå©é¢-" + [String]year.YearNo() + "å¹´-" + macroPlan.ScenarioName() ); |
| | | traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) { |
| | | // todo |
| | | cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]Number::Random( 0, 0 ) ); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method CapacityAndSaleBudgeCompareExport () as BinaryValue |
| | | { |
| | | Description: 'å¯¼åºæ¯è¾ç»æ' |
| | | TextBody: |
| | | [* |
| | | // yypsybs Sep-22-2023 (created) |
| | | tableName := "年度产éé¢ç®å¯¹æ¯"; |
| | | |
| | | text:= '<?xml version="1.0" encoding="utf-8" standalone="yes"?><table><name>' + tableName + '</name>'; |
| | | |
| | | // å¤çcolumn <column><name>ç©æç¼ç </name><type>String</type></column> |
| | | columnXml := "" |
| | | traverse( this, CapacityAndSaleBudgeCompareItemColumn, column ) { |
| | | info( "columnName : " + column.ColumnName() ); |
| | | columnXml := columnXml + "<column><name>" + column.ColumnName() + "</name><type>String</type></column>"; |
| | | } |
| | | text := text + columnXml + "</table>" |
| | | |
| | | // å¡å
容 |
| | | xmlDOMImplementation := XMLDOMImplementation::Create(); |
| | | xmlDOMDocument := xmlDOMImplementation.CreateDocumentFromString( text ); |
| | | tableElement:= xmlDOMDocument.GetElementByTagName( "table", 0 ); |
| | | rows := selectsortedset( this, CapacityAndSaleBudgeCompareItemRow, row, row.PlaceOfProductionOfArray() + "_" + row.BusinessType() ); |
| | | traverse ( rows, Elements, row ) { |
| | | info( "rowNo : " + [String]row.RowNo() ); |
| | | traverse( row, CapacityAndSaleBudgeCompareItemCell, cell ) { |
| | | ScenarioManager::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, cell.CellContent(), cell.CapacityAndSaleBudgeCompareItemColumn().ColumnName() ); |
| | | } |
| | | } |
| | | xmlDOMSerializer := xmlDOMImplementation.CreateSerializer(); |
| | | xmlTableString := xmlDOMSerializer.WriteToString( xmlDOMDocument ); |
| | | |
| | | tableHandle := TableHandle::ImportXML( BinaryValue::Construct( xmlTableString ) ); |
| | | tableGroupHandle := TableGroupHandle::Create( tableName ); |
| | | tableGroupHandle.Add( tableHandle ); |
| | | tableBinaryData := XLS::SaveTableGroupToBinaryData( tableGroupHandle, true ); |
| | | |
| | | return tableBinaryData.AsBinaryValue(); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GeneratesTheSpecifiedXMLColumn ( |
| | | XMLDOMDocument xmlDOMDocument, |
| | | XMLDOMElement tableElement, |
| | | String value, |
| | | String columnName |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | columnElements := tableElement.GetElementsByTagName( "column" ); |
| | | |
| | | traverse ( columnElements, Elements, ce ) { |
| | | nameElement := ce.GetElementByTagName( "name", 0 ); |
| | | if ( nameElement.TextContent() = columnName ) { |
| | | cell := xmlDOMDocument.CreateElement( "cell" ); |
| | | cell.SetAttribute( "value", value ); |
| | | ce.AppendChild( cell ); |
| | | } |
| | | } |
| | | *] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderCode","title":"OrderCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKU","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderDateTime","title":"OrderDateTime","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderDateTime"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderQty","title":"OrderQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastHitQty","title":"ForecastHitQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastNoHitQty","title":"ForecastNoHitQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastNoHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"Unit","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"CustomerName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerCode","title":"CustomerCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerCode"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderCode","title":"订åç¼å·","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKUç¼ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderQty","title":"æ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderDateTime","title":"éæ±æ¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderDateTime"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastHitQty","title":"æé¢æµ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastNoHitQty","title":"æ 颿µ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastNoHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"åä½","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"客æ·åç§°","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerCode","title":"客æ·ID","subtotals":"","tooltip":"","width":-1,"display":"hidden","editable":false,"attribute":"CustomerCode"}}]' |
| | | ContextMenu: 'listContextMenu108' |
| | | SortCriteria: 'OperateTime' |
| | | Taborder: 2 |
| | |
| | | ContextMenu: 'matrixeditorContextMenuCapacityAndSaleBudgeCompare' |
| | | Editable: false |
| | | Rows: 'MatrixEditorRowsCapacityAndSaleBudgeCompare' |
| | | Taborder: 1 |
| | | Taborder: 2 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ButtonExportCompare |
| | | Response OnClick () id:Response_FormCapacityAndSaleBudgeCompare_ButtonExportCompare_OnClick |
| | | { |
| | | #keys: '[414384.0.881345276]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( GlobalOTDTable ); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | tableBinaryData := ScenarioManager.CapacityAndSaleBudgeCompareExport().AsBinaryData(); |
| | | Application.Download( "年度产éé¢ç®å¯¹æ¯.xlsx", tableBinaryData ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component ButtonExportCompare |
| | | { |
| | | #keys: '[414384.0.881345277]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'EXPORT1' |
| | | Label: '导åº' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Serial","title":"Serial","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Serial"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastQty","title":"ForecastQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReverseQty","title":"ReverseQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReverseQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"AuthorizeQty","title":"AuthorizeQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"AuthorizeQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OperateQty","title":"OperateQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OperateQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OperateType","title":"OperateType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OperateType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Operator","title":"Operator","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Operator"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OperateTime","title":"OperateTime","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OperateTime"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Serial","title":"åºå·","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Serial"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKUç¼å·","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastQty","title":"颿µæ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReverseQty","title":"åç¾æ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReverseQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"AuthorizeQty","title":"æææ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"AuthorizeQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OperateQty","title":"å¨ä½æ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OperateQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OperateType","title":"å¨ä½ç±»å","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OperateType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Operator","title":"æä½äºº","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Operator"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OperateTime","title":"æä½æ¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OperateTime"}}]' |
| | | ContextMenu: 'listContextMenuHedgingOfLog' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 3 |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | #child: ListHedgingOfLog |
| | | #child: PanelHedgingOfLog761 |
| | | #child: PanelHedgingOfLog593 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | Taborder: 2 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelHedgingOfLog221 |
| | | { |
| | | #keys: '[414724.0.149787927]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component LabelHedgingOfLog id:LabelHedgingOfLog_298 |
| | | { |
| | | #keys: '[414724.0.149788086]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | | FixedSize: false |
| | | Taborder: 0 |
| | | Text: 'æ¥å¿é¡µé¢' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Border: true |
| | | FixedSize: true |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelHedgingOfLog593 id:PanelHedgingOfLog593_93 |
| | | { |
| | | #keys: '[414724.0.152989129]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component txt_QueryContent_FHO |
| | | { |
| | | #keys: '[414724.0.152989222]' |
| | | BaseType: 'WebEditField' |
| | | Properties: |
| | | [ |
| | | PlaceHolder: 'æ¨¡ç³æç´¢' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component btn_Query_FHO |
| | | { |
| | | #keys: '[414724.0.152920619]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | ButtonSize: 'compact' |
| | | Image: 'VIEW' |
| | | Label: 'æ¥è¯¢' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Alignment: 'trailing' |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelHedgingOfLog593_93/btn_Query_FHO |
| | | Response OnClick () id:Response_PanelHedgingOfLog593_93_btn_Query_FHO_OnClick |
| | | { |
| | | #keys: '[414724.0.152920798]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | DataExtractorHedgingOfLog.FixedFilter( "object.SKU().LikeUserLocale( " + txt_QueryContent_FHO.Text().AsQUILL() + " )" |
| | | + " or " + "object.OperateType().LikeUserLocale( " + txt_QueryContent_FHO.Text().AsQUILL() + " )" |
| | | + " or " + "object.Operator().LikeUserLocale( " + txt_QueryContent_FHO.Text().AsQUILL() + " )" |
| | | ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | Children: |
| | | [ |
| | | #child: PanelHedgingOfLog |
| | | Component lb_ForecastQty |
| | | { |
| | | #keys: '[414724.0.31031550]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | Text: 'åææç颿µæ°éï¼0' |
| | | ] |
| | | } |
| | | #child: PanelHedgingOfLog221 |
| | | #child: PanelHedgingOfLog593_93 |
| | | ] |
| | | Properties: |
| | | [ |
| | |
| | | Properties: |
| | | [ |
| | | DataType: 'structured[H_MaterialPurchase]' |
| | | FixedFilter: 'object.Status()="æªåå¸"' |
| | | Source: 'DataHolderMaterialPurchase' |
| | | Taborder: 0 |
| | | Transformation: 'Elements' |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKU","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductSubclassType","title":"ProductSubclassType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductSubclassType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Qty","title":"Qty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Qty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"Unit","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrgCode","title":"OrgCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrgCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"WarehouseCode","title":"WarehouseCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"WarehouseCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DemandTime","title":"DemandTime","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DemandTime"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKUç¼ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductSubclassType","title":"ç±»å","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductSubclassType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Qty","title":"æ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Qty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"åä½","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrgCode","title":"ç»ç»ä»£ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrgCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"WarehouseCode","title":"ä»åºä»£ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"WarehouseCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DemandTime","title":"éæ±æ¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DemandTime"}}]' |
| | | ContextMenu: 'listContextMenuMaterialPurchase' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | | NumberOfColumns: 50 |
| | | NumberOfColumns: 30 |
| | | Taborder: 0 |
| | | Text: 'å¼å§æ¶é´ï¼2023-03-26 12:24:46' |
| | | Visible: false |
| | | ] |
| | | } |
| | | #child: PanelMaterialPurchase613 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Alignment: 'trailing' |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 1 |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelMaterialPurchase354 |
| | | { |
| | | #keys: '[414724.0.149784759]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component lb_Title208 |
| | | { |
| | | #keys: '[414724.0.149784840]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | | Description: 'ææ/åç¾ç©æéè´æç»éæ¾' |
| | | Taborder: 0 |
| | | Text: 'ææ/åç¾ç©æéè´æç»éæ¾' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Border: true |
| | | FixedSize: true |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | Component lb_Title |
| | | { |
| | | #keys: '[414724.0.32644779]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | | Description: 'ææ/åç¾ç©æéè´æç»éæ¾' |
| | | Taborder: 0 |
| | | Text: 'ææ/åç¾ç©æéè´æç»éæ¾' |
| | | ] |
| | | } |
| | | #child: PanelMaterialPurchase |
| | | Component DataHolderMaterialPurchase |
| | | { |
| | |
| | | ] |
| | | } |
| | | #child: ListMaterialPurchase |
| | | #child: PanelMaterialPurchase354 |
| | | ] |
| | | Properties: |
| | | [ |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderID","title":"OrderID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SalesSegmentName","title":"SalesSegmentName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SalesSegmentName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"CustomerName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UnitOfMeasureName","title":"UnitOfMeasureName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UnitOfMeasureName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Price","title":"Price","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Price"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"EndDate","title":"EndDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"EndDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsLocked","title":"IsLocked","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsLocked"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"First.AsPlanningBaseSalesDemandInPeriod.End","title":"End","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"First.AsPlanningBaseSalesDemandInPeriod.End"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"LastModify","title":"LastModify","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"LastModify"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"LastModifyTime","title":"LastModifyTime","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"LastModifyTime"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderID","title":"OrderID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SalesSegmentName","title":"SalesSegmentName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SalesSegmentName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"CustomerName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UnitOfMeasureName","title":"UnitOfMeasureName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UnitOfMeasureName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Price","title":"Price","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Price"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StartDate","title":"StartDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StartDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsLocked","title":"IsLocked","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsLocked"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"First.AsPlanningBaseSalesDemandInPeriod.End","title":"End","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"First.AsPlanningBaseSalesDemandInPeriod.End"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"LastModify","title":"LastModify","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"LastModify"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"LastModifyTime","title":"LastModifyTime","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"LastModifyTime"}}]' |
| | | ContextMenu: 'listContextMenuOrderLock' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | ButtonSize: 'compact' |
| | | Description: '订åéå®' |
| | | Label: 'éå®' |
| | | Taborder: 7 |
| | | Taborder: 8 |
| | | ] |
| | | } |
| | | Component ButtonOrderLockHeaderUnlock |
| | |
| | | ButtonSize: 'compact' |
| | | Description: '订åè§£é' |
| | | Label: 'è§£é' |
| | | Taborder: 8 |
| | | Taborder: 9 |
| | | ] |
| | | } |
| | | Component ButtonOrderLockHeaderClear |
| | |
| | | Taborder: 6 |
| | | ] |
| | | } |
| | | Component ButtonOrderLockHeaderFresh |
| | | { |
| | | #keys: '[412960.0.259721852]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | ButtonSize: 'compact' |
| | | Description: '仿°æ®æºå·æ°è®¢åæ°æ®' |
| | | Label: 'éæ°è·å订å' |
| | | Taborder: 7 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelOrderLockHeader_545/ButtonOrderLockHeaderFresh |
| | | Response OnClick () id:Response_PanelOrderLockHeader_545_ButtonOrderLockHeaderFresh_OnClick |
| | | { |
| | | #keys: '[412960.0.259721886]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | macroplan := MacroPlan; |
| | | businesstypes := DataHolderOrderLockGlobal.Data().BusinessType().Tokenize( ',' ); |
| | | CustomerOrder::DoSync( macroplan, businesstypes ); |
| | | *] |
| | | } |
| | | } |
| | |
| | | newfilter := ""; |
| | | findcount := 0; |
| | | traverse( existfilterlist, Elements, filter ){ |
| | | if( filter.FindString( "EndDate()", 0 ) >= 0 ){ |
| | | if( filter.FindString( "StartDate()", 0 ) >= 0 ){ |
| | | if( newfilter = "" ){ |
| | | newfilter := "( object.EndDate() = " + this.Date().AsQUILL() + " )"; |
| | | newfilter := "( object.StartDate() = " + this.Date().AsQUILL() + " )"; |
| | | }else{ |
| | | newfilter := newfilter + " and " + "( object.EndDate() = " + this.Date().AsQUILL() + " )"; |
| | | newfilter := newfilter + " and " + "( object.StartDate() = " + this.Date().AsQUILL() + " )"; |
| | | } |
| | | findcount := 1; |
| | | }else{ |
| | |
| | | |
| | | if( findcount = 0 ){ |
| | | if( newfilter = "" ){ |
| | | newfilter := "( object.EndDate() = " + this.Date().AsQUILL() + " )"; |
| | | newfilter := "( object.StartDate() = " + this.Date().AsQUILL() + " )"; |
| | | }else{ |
| | | newfilter := newfilter + " and " + "( object.EndDate() = " + this.Date().AsQUILL() + " )"; |
| | | newfilter := newfilter + " and " + "( object.StartDate() = " + this.Date().AsQUILL() + " )"; |
| | | } |
| | | } |
| | | |
| | |
| | | newfilter := ""; |
| | | findcount := 0; |
| | | traverse( existfilterlist, Elements, filter ){ |
| | | if( filter.FindString( "End()", 0 ) >= 0 and filter.FindString( "EndDate()", 0 ) < 0 ){ |
| | | if( filter.FindString( "End()", 0 ) >= 0 ){ |
| | | if( newfilter = "" ){ |
| | | newfilter := "( object.First().AsPlanningBaseSalesDemandInPeriod().End().Date() = " + this.Date().AsQUILL() + " )"; |
| | | }else{ |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ID","title":"ID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Issuer","title":"Issuer","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Issuer"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IssuingDate","title":"IssuingDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IssuingDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"FinishDate","title":"FinishDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"FinishDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Status","title":"Status","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Status"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"VCode","title":"VCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"VCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Serial","title":"Serial","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Serial"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ID","title":"ID","subtotals":"","tooltip":"","width":-1,"display":"hidden","editable":false,"attribute":"ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Serial","title":"åºå·","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Serial"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IssuingDate","title":"å叿¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IssuingDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"FinishDate","title":"ç»ææ¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"FinishDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Issuer","title":"åå¸äºº","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Issuer"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Status","title":"ç¶æ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Status"}}]' |
| | | ContextMenu: 'listContextMenuReleaseRecord' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"H_ReleaseRecord_ID","title":"H_ReleaseRecord_ID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"H_ReleaseRecord_ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"H_HedgingRecord_ID","title":"H_HedgingRecord_ID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"H_HedgingRecord_ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ID","title":"ID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Qty","title":"Qty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Qty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Status","title":"Status","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Status"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IssuingDate","title":"IssuingDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IssuingDate"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"ç©æç¼å·","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductSubclassType","title":"ç±»å","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductSubclassType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Qty","title":"æ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Qty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"åä½","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrgCode","title":"ç»ç»ä»£ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrgCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"WarehouseCode","title":"ä»åºä»£ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"WarehouseCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DemandTime","title":"éæ±æ¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DemandTime"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IssuingDate","title":"å叿¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IssuingDate"}}]' |
| | | ContextMenu: 'listContextMenuReleaseRecord690' |
| | | Taborder: 2 |
| | | ] |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelReleaseRecord423 |
| | | { |
| | | #keys: '[414724.0.149784904]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component LabelReleaseRecord id:LabelReleaseRecord_296 |
| | | { |
| | | #keys: '[414724.0.149784974]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | | NumberOfColumns: 20 |
| | | Taborder: 0 |
| | | Text: 'åç¾/ææç©æåå¸çæ¬æç»' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Border: true |
| | | FixedSize: true |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | |
| | | { |
| | | Body: |
| | | [* |
| | | DataExtractorReleaseRecord661.FixedFilter( "object.H_ReleaseRecord_ID() = " + selection.ID().AsQUILL()); |
| | | // åå¸ID |
| | | H_ReleaseRecord_ID := "-1"; |
| | | H_Status:="å·²åå¸"; |
| | | if( not isnull( selection)) |
| | | { |
| | | H_ReleaseRecord_ID := selection.ID(); |
| | | } |
| | | DataExtractorReleaseRecord661.FixedFilter( "object.H_ReleaseRecord_ID() = " + H_ReleaseRecord_ID.AsQUILL() |
| | | + " and " + "object.Status() = " + H_Status.AsQUILL()); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | |
| | | #keys: '[414724.0.37110847]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebComponent_OnCreated' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | dtMonth.Date(Date::Today()); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | Component LabelReleaseRecord |
| | | { |
| | | #keys: '[414724.0.36933216]' |
| | | BaseType: 'WebLabel' |
| | | Properties: |
| | | [ |
| | | NumberOfColumns: 20 |
| | | Taborder: 0 |
| | | Text: 'åç¾/ææç©æåå¸çæ¬æç»' |
| | | ] |
| | | } |
| | | #child: PanelReleaseRecord |
| | | #child: PanelReleaseRecord108 |
| | | #child: PanelReleaseRecord527 |
| | | #child: PanelReleaseRecord423 |
| | | ] |
| | | Properties: |
| | | [ |
| | |
| | | SelectItem := select( MacroPlan,H_MessagePassing,Obj,Obj.FKey()="FrmMaterial" and Obj.ItemKey()="ListSelect"); |
| | | if(not isnull( SelectItem)) |
| | | { |
| | | if(SelectItem.Value().Length()>0) |
| | | if(SelectItem.ValueJsonString().Length()>0) |
| | | { |
| | | StrValue := SelectItem.Value().Tokenize( ";"); |
| | | lb_SUK_FAACM.Text(StrValue.Element( 0)); |
| | | lb_MaterialCode_FAACM.Text(StrValue.Element( 1)); |
| | | lb_Unit_FAACM.Text(StrValue.Element( 2)); |
| | | JInfo := JSON::Parse( SelectItem.ValueJsonString()); |
| | | lb_SUK_FAACM.Text(JInfo.Get( "ParentSKU").GetString()); |
| | | lb_MaterialCode_FAACM.Text(JInfo.Get( "SKU").GetString()); |
| | | lb_Unit_FAACM.Text(JInfo.Get( "Unit").GetString()); |
| | | lb_Operator_FAACM.Text(ApplicationMacroPlanner.GetUserName()); |
| | | txt_CustomID_FAACM.Text(JInfo.Get( "CustomCode").GetString()); |
| | | txt_CustomName_FAACM.Text(JInfo.Get( "CustomName").GetString()); |
| | | } |
| | | } |
| | | // è·åéæ©åçSKU |
| | | SelectItem := select( MacroPlan,H_MessagePassing,Obj,Obj.FKey()="FrmOrderForecast" and Obj.ItemKey()="ListSelect"); |
| | | if(not isnull( SelectItem) and SelectItem.Value().Length()>0) |
| | | { |
| | | StrValue := SelectItem.Value().Tokenize( ";"); |
| | | txt_CustomID_FAACM.Text(StrValue.Element( 2)); |
| | | txt_CustomName_FAACM.Text(StrValue.Element( 3)); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'structured[Product_MP]' |
| | | DataType: 'structured[H_MaterialInfo]' |
| | | Source: 'dh_FM_PruductMP' |
| | | Taborder: 0 |
| | | Transformation: 'Elements' |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ID","title":"ID","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"TotalInventoryLevels","title":"TotalInventoryLevels","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"TotalInventoryLevels"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Level","title":"Level","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"Level"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsProductCategory","title":"IsProductCategory","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"IsProductCategory"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"ç©æç¼ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MaterialType","title":"ç©æç±»å","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MaterialType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MaterialName","title":"ç©æåç§°","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MaterialName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"åä½","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"NeedQty","title":"éæ±æ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"NeedQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"NeedDate","title":"éæ±æ¶é´","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"NeedDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrgCode","title":"ç»ç»ä»£ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrgCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockPoint","title":"åºåç¹","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockPoint"}}]' |
| | | ContextMenu: 'listContextMenu892' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | [ |
| | | NumberOfColumns: 15 |
| | | PlaceHolder: 'æ¨¡ç³æç´¢' |
| | | Taborder: 1 |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component btn_Query_FM |
| | |
| | | [ |
| | | Image: 'VIEW' |
| | | Label: 'æ¥è¯¢' |
| | | Taborder: 2 |
| | | Taborder: 3 |
| | | ] |
| | | } |
| | | Component btn_Add_FM |
| | |
| | | [ |
| | | Image: 'ADD2' |
| | | Label: 'æ°å¢åç¾/ææ' |
| | | Taborder: 3 |
| | | Taborder: 4 |
| | | ] |
| | | ResponseDefinitions: |
| | | [ |
| | |
| | | } |
| | | ] |
| | | } |
| | | Component ds_Month_FM |
| | | { |
| | | #keys: '[414724.0.148121614]' |
| | | BaseType: 'WebDateSelector' |
| | | Properties: |
| | | [ |
| | | DateFormat: 'YMM' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: List832 |
| | | Response OnDoubleClick ( |
| | | H_MaterialInfo selection |
| | | ) id:Response_List832_OnDoubleClick |
| | | { |
| | | #keys: '[414724.0.160542461]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebList_OnDoubleClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | if( not isnull( selection)) |
| | | { |
| | | if(selection.MaterialType()="åæå") |
| | | { |
| | | OrderCode:=""; |
| | | if( txtSaveForecastData_FM.Text().Length()>0) |
| | | { |
| | | JForecast := JSON::Parse( txtSaveForecastData_FM.Text()); |
| | | OrderCode := JForecast.Get( "OrderCode").GetString(); |
| | | } |
| | | jResult := H_FunctionClass::SM_GetMaterialData( MacroPlan,selection.SKU(),selection.NeedQty(), OrderCode,"-",selection.NeedDate()); |
| | | if(jResult.Get( "Status").GetBoolean()) |
| | | { |
| | | de_dh_FM_ProductMP.FixedFilter( "object.ParentSKU() = " + selection.SKU().AsQUILL() |
| | | + " and object.ForecastID() = " + OrderCode.AsQUILL() |
| | | ); |
| | | } |
| | | else |
| | | { |
| | | WebMessageBox::Warning( jResult.Get( "Msg").GetString()); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | // å¼¹åºç©æåç¾ææ |
| | | } |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | { |
| | | Body: |
| | | [* |
| | | ds_Month_FM.Date(Date::ActualDate()); |
| | | txtSaveForecastData_FM.Text(""); |
| | | // è·åéæ©åçSKU |
| | | SelectItem := select( MacroPlan,H_MessagePassing,Obj,Obj.FKey()="FrmOrderForecast" and Obj.ItemKey()="ListSelect"); |
| | |
| | | txtSaveForecastData_FM.Text( SelectItem.ValueJsonString()); |
| | | JSelect := JSON::Parse( SelectItem.ValueJsonString()); |
| | | lb_SUK_FM.Text(JSelect.Get( "SKU").GetString()); |
| | | de_dh_FM_ProductMP.FixedFilter( "object.ID() = " + JSelect.Get( "SKU").GetString().AsQUILL()); |
| | | de_dh_FM_ProductMP.FixedFilter( "object.ParentSKU() = " + JSelect.Get( "SKU").GetString().AsQUILL() |
| | | + " and object.ForecastID() = " + JSelect.Get( "OrderCode").GetString().AsQUILL() |
| | | ); |
| | | } |
| | | } |
| | | *] |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: Panel418/btn_Add_FM |
| | | Response OnClick () id:Response_Panel418_btn_Add_FM_OnClick_975 |
| | | Response OnClick ( |
| | | H_MaterialInfo selection |
| | | ) id:Response_Panel418_btn_Add_FM_OnClick_975 |
| | | { |
| | | #keys: '[414724.0.145238844]' |
| | | CanBindMultiple: false |
| | |
| | | Body: |
| | | [* |
| | | SelectItem := select( MacroPlan,H_MessagePassing,Obj,Obj.FKey()="FrmMaterial" and Obj.ItemKey()="ListSelect"); |
| | | CustomCode:=""; |
| | | CustomName:=""; |
| | | SValue:=""; |
| | | SValueJsonString:=""; |
| | | // è·å客æ·åç§°å客æ·ID |
| | | if(txtSaveForecastData_FM.Text().Length()>0) |
| | | { |
| | | jForecast := JSON::Parse( txtSaveForecastData_FM.Text()); |
| | | CustomCode := jForecast.Get( "CustomCode").GetString(); |
| | | CustomName := jForecast.Get( "CustomName").GetString(); |
| | | } |
| | | if(not isnull(selection)) |
| | | { |
| | | SValueJsonString:= JSON::Object().Add( "SKU",selection.SKU()) |
| | | .Add( "MaterialName",selection.MaterialName()) |
| | | .Add( "MaterialType",selection.MaterialType()) |
| | | .Add( "OrgCode",selection.OrgCode()) |
| | | .Add( "Unit",selection.Unit()) |
| | | .Add( "CustomCode",CustomCode) |
| | | .Add( "ParentSKU",lb_SUK_FM.Text()) |
| | | .Add( "CustomName",CustomName).Build().AsString(); |
| | | } |
| | | if( isnull( SelectItem)) |
| | | { |
| | | MacroPlan.H_MessagePassing(relnew,FKey :="FrmMaterial",ItemKey := "ListSelect",Value := ""); |
| | | MacroPlan.H_MessagePassing(relnew,FKey := "FrmMaterial",ItemKey := "ListSelect", Value:=SValue,ValueJsonString:=SValueJsonString); |
| | | } |
| | | else |
| | | { |
| | | //SelectItem.ValueJsonString() |
| | | SelectItem.Value(SValue); |
| | | SelectItem.ValueJsonString( SValueJsonString); |
| | | } |
| | | Application.OpenForm( "FrmAuthorizeAndCountersign_Material","modal"); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | |
| | | { |
| | | Body: |
| | | [* |
| | | de_dh_FM_ProductMP.FixedFilter( "object.ID().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" ); |
| | | // + " or " + "object.SKU().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | // + " or " + "object.CustomerCode().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | // + " or " + "object.CustomerName().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" ); |
| | | de_dh_FM_ProductMP.FixedFilter( "( object.SKU().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | + " or " + "object.MaterialType().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | + " or " + "object.MaterialName().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | + " or " + "object.Unit().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | + " or " + "object.OrgCode().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | + " or " + "object.StockPoint().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " )" |
| | | + " or " + "object.Unit().LikeUserLocale( " + txt_QueryContent_FM.Text().AsQUILL() + " ))" |
| | | + " and " + "( object.NeedDate() < " + ds_Month_FM.Date().StartOfNextMonth().AsQUILL() |
| | | + " and " + "object.NeedDate() >= " + ds_Month_FM.Date().StartOfMonth().AsQUILL() + " )" |
| | | |
| | | ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | |
| | | { |
| | | #keys: '[414724.0.53475285]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[Product_MP]*' |
| | | Databinding: 'structured[H_MaterialInfo]*' |
| | | Children: |
| | | [ |
| | | Component de_dh_FM_ProductMP |
| | |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'Product_MP' |
| | | Transformation: 'H_MaterialInfo' |
| | | ] |
| | | } |
| | | ] |
| | |
| | | [ |
| | | Description: 'åæå表页' |
| | | Image: 'NAV_REDO_LIGHT_BLUE' |
| | | MinimumRows: 50 |
| | | MinimumColumns: 80 |
| | | MinimumRows: 40 |
| | | Title: 'åæå表页' |
| | | ] |
| | | } |
| | |
| | | Visible: false |
| | | ] |
| | | } |
| | | Component btn_OrderH_FOF |
| | | { |
| | | #keys: '[414724.0.165490408]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Description: 'ERO订åå²å' |
| | | Image: 'AMMUNITION_BOX_CLOSED' |
| | | Label: 'ERP订åå²å' |
| | | Taborder: 3 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | |
| | | ValueJsonString := JSON::Object().Add( "SKU",selection.SKU()) |
| | | .Add( "Util",selection.Util()) |
| | | .Add( "CustomCode",selection.CustomCode()) |
| | | .Add( "CustomName",selection.CustomName()).Build().AsString()); |
| | | .Add( "CustomName",selection.CustomName()) |
| | | .Add( "ForecastQty",selection.ForecastQty()) |
| | | .Add( "NeedTime",selection.NeedTime().AsQUILL()) |
| | | .Add( "OrderCode",selection.OrderCode()).Build().AsString()); |
| | | } |
| | | else |
| | | { |
| | |
| | | SelectItem.ValueJsonString(JSON::Object().Add( "SKU",selection.SKU()) |
| | | .Add( "Util",selection.Util()) |
| | | .Add( "CustomCode",selection.CustomCode()) |
| | | .Add( "CustomName",selection.CustomName()).Build().AsString()); |
| | | .Add( "CustomName",selection.CustomName()) |
| | | .Add( "ForecastQty",selection.ForecastQty()) |
| | | .Add( "NeedTime",selection.NeedTime().AsQUILL()) |
| | | .Add( "OrderCode",selection.OrderCode()).Build().AsString()); |
| | | } |
| | | Application.OpenForm( "FrmMaterial","popout"); |
| | | |
| | | jResult := H_FunctionClass::SM_GetMaterialData( MacroPlan,selection.SKU(),selection.ForecastQty(),selection.OrderCode(),"-",selection.NeedTime()); |
| | | if(jResult.Get( "Status").GetBoolean()) |
| | | { |
| | | Application.OpenForm( "FrmMaterial","popout"); |
| | | } |
| | | else |
| | | { |
| | | WebMessageBox::Warning( jResult.Get( "Msg").GetString()); |
| | | } |
| | | } |
| | | else |
| | | { |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: Panel351/btn_OrderH_FOF |
| | | Response OnClick () id:Response_Panel351_btn_OrderH_FOF_OnClick |
| | | { |
| | | #keys: '[414724.0.166610329]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | H_FunctionClass::SM_OrderHedging( MacroPlan,true,"System","ERP订å"); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | ValueJsonString := JSON::Object().Add( "SKU",selection.SKU()) |
| | | .Add( "Util",selection.Util()) |
| | | .Add( "CustomCode",selection.CustomCode()) |
| | | .Add( "CustomName",selection.CustomName()).Build().AsString()); |
| | | .Add( "CustomName",selection.CustomName()) |
| | | .Add( "ForecastQty",selection.ForecastQty()) |
| | | .Add( "NeedTime",selection.NeedTime().AsQUILL()) |
| | | .Add( "OrderCode",selection.OrderCode()).Build().AsString()); |
| | | } |
| | | else |
| | | { |
| | |
| | | SelectItem.ValueJsonString(JSON::Object().Add( "SKU",selection.SKU()) |
| | | .Add( "Util",selection.Util()) |
| | | .Add( "CustomCode",selection.CustomCode()) |
| | | .Add( "CustomName",selection.CustomName()).Build().AsString()); |
| | | .Add( "CustomName",selection.CustomName()) |
| | | .Add( "ForecastQty",selection.ForecastQty()) |
| | | .Add( "NeedTime",selection.NeedTime().AsQUILL()) |
| | | .Add( "OrderCode",selection.OrderCode()).Build().AsString()); |
| | | } |
| | | Application.OpenForm( "FrmMaterial","popout"); |
| | | |
| | | jResult := H_FunctionClass::SM_GetMaterialData( MacroPlan,selection.SKU(),selection.ForecastQty(),selection.OrderCode(),"-",selection.NeedTime()); |
| | | if(jResult.Get( "Status").GetBoolean()) |
| | | { |
| | | Application.OpenForm( "FrmMaterial","popout"); |
| | | } |
| | | else |
| | | { |
| | | WebMessageBox::Warning( jResult.Get( "Msg").GetString()); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderCode","title":"OrderCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKU","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderQty","title":"OrderQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReverseQty","title":"ReverseQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReverseQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"AuthorizeQty","title":"AuthorizeQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"AuthorizeQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastQty","title":"ForecastQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastHitQty","title":"ForecastHitQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastNoHitQty","title":"ForecastNoHitQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastNoHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"CustomerName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerCode","title":"CustomerCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerCode"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderCode","title":"订åç¼å·","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKUç¼ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrderQty","title":"æ°å¢è®¢å","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrderQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReverseQty","title":"åç¾","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReverseQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"AuthorizeQty","title":"ææ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"AuthorizeQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastQty","title":"颿µ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastHitQty","title":"æé¢æµ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ForecastNoHitQty","title":"æ 颿µ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ForecastNoHitQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"客æ·åç§°","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerCode","title":"客æ·ID","subtotals":"","tooltip":"","width":-1,"display":"hidden","editable":false,"attribute":"CustomerCode"}}]' |
| | | ContextMenu: 'listContextMenu526' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKU","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MType","title":"MType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReverseQty","title":"ReverseQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReverseQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"AuthorizeQty","title":"AuthorizeQty","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"AuthorizeQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"Unit","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"CustomerName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SKU","title":"SKUç¼ç ","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SKU"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MType","title":"ç±»å","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReverseQty","title":"颿µæ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReverseQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"AuthorizeQty","title":"æææ°é","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"AuthorizeQty"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Unit","title":"åä½","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Unit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CustomerName","title":"客æ·åç§°","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CustomerName"}}]' |
| | | ContextMenu: 'listContextMenu660' |
| | | Taborder: 2 |
| | | ] |
| | |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | ButtonSize: 'compact' |
| | | Image: 'VIEW' |
| | | Label: 'æ¥è¯¢' |
| | | Taborder: 2 |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component List212 |
| | | { |
| | | #keys: '[414724.0.153225431]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractor924 |
| | | { |
| | | #keys: '[414724.0.153225432]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'MappingProduct' |
| | | ] |
| | | } |
| | | #child: listActionBarPage441 |
| | | Component DataSetLevel622 |
| | | { |
| | | #keys: '[414724.0.153225437]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | | #child: listContextMenu182 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessType","title":"BusinessType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CommonBusiness","title":"CommonBusiness","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CommonBusiness"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"EndDate","title":"EndDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"EndDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ID","title":"ID","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsCommon","title":"IsCommon","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsCommon"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"KeyProduct","title":"KeyProduct","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"KeyProduct"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Name","title":"Name","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Name"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Notes","title":"Notes","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Notes"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductMajorType","title":"ProductMajorType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductMajorType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductSubclassType","title":"ProductSubclassType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductSubclassType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ShelfLife","title":"ShelfLife","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ShelfLife"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UnitOfMeasureName","title":"UnitOfMeasureName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UnitOfMeasureName"}}]' |
| | | ContextMenu: 'listContextMenu182' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPage441 |
| | | { |
| | | #keys: '[414724.0.153225434]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenu182 |
| | | { |
| | | #keys: '[414724.0.153225439]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: Button593 |
| | | Response OnClick () id:Response_Frm_TEST_Button593_OnClick |
| | | { |
| | | #keys: '[414724.0.153411735]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | HObj := H_FunctionClass::SM_GetProductInfo( MacroPlan,""); |
| | | if( not isnull( HObj)) |
| | | { |
| | | WebMessageBox::Information( HObj.BusinessType()); |
| | | } |
| | | else |
| | | { |
| | | WebMessageBox::Information( "å¾å°ç空å¼"); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: Button687 |
| | | Response OnClick () id:Response_Frm_TEST_Button687_OnClick |
| | | { |
| | | #keys: '[414724.0.164341791]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | H_FunctionClass::SM_OrderHedging( MacroPlan,true,"System","ERP订å"); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: MacroPlannerWebApp |
| | | OrphanComponent Frm_TEST |
| | | { |
| | | #keys: '[414724.0.153225415]' |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | #child: List212 |
| | | Component DataHolder417 |
| | | { |
| | | #keys: '[414724.0.153253171]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[MappingProduct]*' |
| | | Children: |
| | | [ |
| | | Component DataExtractor742 |
| | | { |
| | | #keys: '[414724.0.153253184]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'MappingProduct' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component Button593 |
| | | { |
| | | #keys: '[414724.0.153411711]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'MONITOR_RGB' |
| | | Label: 'æµè¯' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component Button687 |
| | | { |
| | | #keys: '[414724.0.164341716]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Taborder: 3 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Title: 'æµè¯é¡µé¢' |
| | | ] |
| | | } |
| | |
| | | { |
| | | forms |
| | | { |
| | | form_legacy_1 |
| | | form_FormOrderLockLog |
| | | { |
| | | title: 'Scenario manager' |
| | | title: 'QTIANMA_JITUAN::FormOrderLockLog' |
| | | shown: true |
| | | componentID: 'FormScenarioManager' |
| | | componentID: 'QTIANMA_JITUAN::FormOrderLockLog' |
| | | layout |
| | | { |
| | | mode: 'open' |
| | | rowPosition: 1 |
| | | rowPosition: 14 |
| | | rowSpan: 8 |
| | | columnPosition: 1 |
| | | columnSpan: 5 |
| | | columnSpan: 12 |
| | | } |
| | | components |
| | | { |
| | | FormScenarioManager_ListScenario |
| | | FormOrderLockLog_PanelOrderLockLog |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormOrderLockLog_ListOrderLockLog |
| | | { |
| | | } |
| | | FormScenarioManager_DataSetLevelScenario |
| | | FormOrderLockLog_DataSetLevelOrderLockLog |
| | | { |
| | | groupDepth: -1 |
| | | column_All_constraints |
| | | sort: 'DESC:Notes' |
| | | column_OrderID |
| | | { |
| | | columnId: 'All constraints' |
| | | dataPath: 'All constraints' |
| | | columnId: 'OrderID' |
| | | dataPath: 'OrderID' |
| | | dataType: 'string' |
| | | title: 'All constraints' |
| | | title: '订åå·' |
| | | index: 0 |
| | | subtotals: '' |
| | | width: 90 |
| | | width: 150 |
| | | } |
| | | column_Name |
| | | column_ProductID |
| | | { |
| | | columnId: 'Name' |
| | | dataPath: 'Name' |
| | | columnId: 'ProductID' |
| | | dataPath: 'ProductID' |
| | | dataType: 'string' |
| | | title: 'åç§°' |
| | | title: 'ç©æå·' |
| | | index: 1 |
| | | subtotals: '' |
| | | width: 277 |
| | | width: 150 |
| | | } |
| | | column_ChangedBy |
| | | column_SalesSegmentName |
| | | { |
| | | columnId: 'ChangedBy' |
| | | dataPath: 'ChangedBy' |
| | | columnId: 'SalesSegmentName' |
| | | dataPath: 'SalesSegmentName' |
| | | dataType: 'string' |
| | | title: 'Changed by' |
| | | title: 'éå®é¨é¨' |
| | | index: 2 |
| | | subtotals: '' |
| | | width: 106 |
| | | width: 150 |
| | | } |
| | | column_ChangedOn |
| | | column_StockingPointID |
| | | { |
| | | columnId: 'ChangedOn' |
| | | dataPath: 'ChangedOn' |
| | | dataType: 'datetime' |
| | | title: 'Changed on' |
| | | index: 3 |
| | | subtotals: '' |
| | | width: 99 |
| | | } |
| | | column_StorageMode |
| | | { |
| | | columnId: 'StorageMode' |
| | | dataPath: 'StorageMode' |
| | | columnId: 'StockingPointID' |
| | | dataPath: 'StockingPointID' |
| | | dataType: 'string' |
| | | title: 'StorageMode' |
| | | index: 4 |
| | | subtotals: '' |
| | | width: 40 |
| | | } |
| | | } |
| | | } |
| | | } |
| | | form_legacy_2 |
| | | { |
| | | title: 'Assumptions' |
| | | shown: true |
| | | componentID: 'FormAssumptions' |
| | | layout |
| | | { |
| | | mode: 'open' |
| | | rowPosition: 9 |
| | | rowSpan: 8 |
| | | columnPosition: 1 |
| | | columnSpan: 5 |
| | | } |
| | | components |
| | | { |
| | | FormAssumptions_ListAssumptions |
| | | { |
| | | } |
| | | FormAssumptions_DataSetLevelAssumptions |
| | | { |
| | | groupDepth: -1 |
| | | column_All_constraints |
| | | { |
| | | columnId: 'All constraints' |
| | | dataPath: 'All constraints' |
| | | dataType: 'string' |
| | | title: 'All constraints' |
| | | index: 0 |
| | | subtotals: '' |
| | | width: 32 |
| | | } |
| | | column_Category |
| | | { |
| | | columnId: 'Category' |
| | | dataPath: 'Category' |
| | | dataType: 'string' |
| | | title: 'ç±»å«' |
| | | index: 1 |
| | | subtotals: '' |
| | | width: 108 |
| | | } |
| | | column_Importance |
| | | { |
| | | columnId: 'Importance' |
| | | dataPath: 'Importance' |
| | | dataType: 'string' |
| | | title: 'éè¦æ§' |
| | | index: 2 |
| | | subtotals: '' |
| | | width: 110 |
| | | } |
| | | column_Title |
| | | { |
| | | columnId: 'Title' |
| | | dataPath: 'Title' |
| | | dataType: 'string' |
| | | title: 'æ é¢' |
| | | title: 'åºåç¹' |
| | | index: 3 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_ChangedBy |
| | | column_CustomerName |
| | | { |
| | | columnId: 'ChangedBy' |
| | | dataPath: 'ChangedBy' |
| | | columnId: 'CustomerName' |
| | | dataPath: 'CustomerName' |
| | | dataType: 'string' |
| | | title: 'Changed by' |
| | | title: '客æ·åç§°' |
| | | index: 4 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_CreatedOn |
| | | column_Quantity |
| | | { |
| | | columnId: 'CreatedOn' |
| | | dataPath: 'CreatedOn' |
| | | dataType: 'datetime' |
| | | title: 'Created on' |
| | | columnId: 'Quantity' |
| | | dataPath: 'Quantity' |
| | | dataType: 'real' |
| | | index: 5 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_UnitOfMeasureName |
| | | { |
| | | columnId: 'UnitOfMeasureName' |
| | | dataPath: 'UnitOfMeasureName' |
| | | dataType: 'string' |
| | | title: 'åä½' |
| | | index: 6 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_Price |
| | | { |
| | | columnId: 'Price' |
| | | dataPath: 'Price' |
| | | dataType: 'real' |
| | | title: 'éå®é¢' |
| | | index: 7 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_EndDate |
| | | { |
| | | columnId: 'EndDate' |
| | | dataPath: 'EndDate' |
| | | dataType: 'date' |
| | | title: '客æ·éæ±æ¶é´' |
| | | index: 8 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_IsLocked |
| | | { |
| | | columnId: 'IsLocked' |
| | | dataPath: 'IsLocked' |
| | | dataType: 'boolean' |
| | | title: 'ç¶æ' |
| | | index: 9 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_End |
| | | { |
| | | columnId: 'End' |
| | | dataPath: 'End' |
| | | dataType: 'date' |
| | | title: '计åäº¤ä»æ¶é´' |
| | | index: 10 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_LastModify |
| | | { |
| | | columnId: 'LastModify' |
| | | dataPath: 'LastModify' |
| | | dataType: 'string' |
| | | title: 'æåæä½äºº' |
| | | index: 11 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_LastModifyTime |
| | | { |
| | | columnId: 'LastModifyTime' |
| | | dataPath: 'LastModifyTime' |
| | | dataType: 'datetime' |
| | | title: 'æåæä½æ¶é´' |
| | | index: 12 |
| | | subtotals: '' |
| | | width: 145 |
| | | } |
| | | column_Notes |
| | | { |
| | | columnId: 'Notes' |
| | | dataPath: 'Notes' |
| | | dataType: 'string' |
| | | title: 'æä½è¯¦æ
' |
| | | index: 13 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | } |
| | | } |
| | | } |
| | | form_FormScenariosKPIsComparison |
| | | form_FormOrderLock |
| | | { |
| | | title: 'QLibMacroPlannerWebUI::FormScenariosKPIsComparison' |
| | | title: 'QTIANMA_JITUAN::FormOrderLock' |
| | | shown: true |
| | | componentID: 'QLibMacroPlannerWebUI::FormScenariosKPIsComparison' |
| | | componentID: 'QTIANMA_JITUAN::FormOrderLock' |
| | | layout |
| | | { |
| | | mode: 'open' |
| | | rowPosition: 1 |
| | | rowSpan: 16 |
| | | columnPosition: 6 |
| | | columnSpan: 7 |
| | | rowSpan: 13 |
| | | columnPosition: 1 |
| | | columnSpan: 12 |
| | | } |
| | | components |
| | | { |
| | | FormScenariosKPIsComparison_MatrixEditorFinancialKPIs |
| | | FormOrderLock_PanelOrderLock |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormOrderLock_PanelOrderLockHeader |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormOrderLock_PanelOrderLockOrder |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormOrderLock_ListOrderLock |
| | | { |
| | | } |
| | | FormOrderLock_DataSetLevelOrderLock |
| | | { |
| | | groupDepth: -1 |
| | | sort: 'StartDate' |
| | | column_OrderID |
| | | { |
| | | columnId: 'OrderID' |
| | | dataPath: 'OrderID' |
| | | dataType: 'string' |
| | | title: '订åå·' |
| | | index: 0 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_ProductID |
| | | { |
| | | columnId: 'ProductID' |
| | | dataPath: 'ProductID' |
| | | dataType: 'string' |
| | | title: 'ç©æå·' |
| | | index: 1 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_SalesSegmentName |
| | | { |
| | | columnId: 'SalesSegmentName' |
| | | dataPath: 'SalesSegmentName' |
| | | dataType: 'string' |
| | | title: 'éå®é¨é¨' |
| | | index: 2 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_StockingPointID |
| | | { |
| | | columnId: 'StockingPointID' |
| | | dataPath: 'StockingPointID' |
| | | dataType: 'string' |
| | | title: 'åºåç¹' |
| | | index: 3 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_CustomerName |
| | | { |
| | | columnId: 'CustomerName' |
| | | dataPath: 'CustomerName' |
| | | dataType: 'string' |
| | | title: '客æ·åç§°' |
| | | index: 4 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_Quantity |
| | | { |
| | | columnId: 'Quantity' |
| | | dataPath: 'Quantity' |
| | | dataType: 'real' |
| | | index: 5 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_UnitOfMeasureName |
| | | { |
| | | columnId: 'UnitOfMeasureName' |
| | | dataPath: 'UnitOfMeasureName' |
| | | dataType: 'string' |
| | | title: 'åä½' |
| | | index: 6 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_Price |
| | | { |
| | | columnId: 'Price' |
| | | dataPath: 'Price' |
| | | dataType: 'real' |
| | | title: 'éå®é¢' |
| | | index: 7 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_StartDate |
| | | { |
| | | columnId: 'StartDate' |
| | | dataPath: 'StartDate' |
| | | dataType: 'date' |
| | | title: '客æ·éæ±æ¶é´' |
| | | index: 8 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_IsLocked |
| | | { |
| | | columnId: 'IsLocked' |
| | | dataPath: 'IsLocked' |
| | | dataType: 'boolean' |
| | | title: 'ç¶æ' |
| | | index: 9 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_First_AsPlanningBaseSalesDemandInPeriod_End |
| | | { |
| | | columnId: 'First.AsPlanningBaseSalesDemandInPeriod.End' |
| | | dataPath: 'First.AsPlanningBaseSalesDemandInPeriod.End' |
| | | dataType: 'datetime' |
| | | title: '计åäº¤ä»æ¶é´' |
| | | index: 10 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_LastModify |
| | | { |
| | | columnId: 'LastModify' |
| | | dataPath: 'LastModify' |
| | | dataType: 'string' |
| | | title: 'æåæä½äºº' |
| | | index: 11 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | column_LastModifyTime |
| | | { |
| | | columnId: 'LastModifyTime' |
| | | dataPath: 'LastModifyTime' |
| | | dataType: 'datetime' |
| | | title: 'æåæä½æ¶é´' |
| | | index: 12 |
| | | subtotals: '' |
| | | width: 150 |
| | | } |
| | | } |
| | | FormOrderLock_PanelOrderLockPlanning |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormOrderLock_PanelMatrix |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormOrderLock_MatrixEditorProductPlanning |
| | | { |
| | | gridColor: '#c4c4c4' |
| | | totalHeaderWidth: 200 |
| | | attributeHeaderWidthRatio: 0.6 |
| | | nameHeaderWidthRatio: 0.4 |
| | | totalHeaderWidth: 427 |
| | | attributeHeaderWidthRatio: 0.325989701966572 |
| | | nameHeaderWidthRatio: 0.674010298033429 |
| | | columnWidth: 100 |
| | | horizontalGrid: true |
| | | verticalGrid: true |
| | | backendState |
| | | { |
| | | componentId: 'QLibMacroPlannerWebUI::FormScenariosKPIsComparison.MatrixEditorFinancialKPIs' |
| | | componentId: 'QTIANMA_JITUAN::FormOrderLock.MatrixEditorProductPlanning' |
| | | state |
| | | { |
| | | cells |
| | | { |
| | | attributes |
| | | { |
| | | attribute_DisplayValue |
| | | attribute_DisplaySupplyQuantity |
| | | { |
| | | type: 'MatrixEditorWebApiCellDataModelInterest' |
| | | index: 0 |
| | | rowsubtotal: '' |
| | | columnsubtotal: '' |
| | | attribute: 'DisplayValue' |
| | | attribute: 'DisplaySupplyQuantity' |
| | | } |
| | | attribute_DependentDemandAndSalesDemandQuantity |
| | | { |
| | | type: 'MatrixEditorWebApiCellDataModelInterest' |
| | | index: 1 |
| | | rowsubtotal: '' |
| | | columnsubtotal: '' |
| | | attribute: 'DependentDemandAndSalesDemandQuantity' |
| | | } |
| | | attribute_TargetInventoryLevel |
| | | { |
| | | type: 'MatrixEditorWebApiCellDataModelInterest' |
| | | index: 2 |
| | | rowsubtotal: '' |
| | | columnsubtotal: '' |
| | | attribute: 'TargetInventoryLevel' |
| | | } |
| | | attribute_InventoryLevelEnd |
| | | { |
| | | type: 'MatrixEditorWebApiCellDataModelInterest' |
| | | index: 3 |
| | | rowsubtotal: '' |
| | | columnsubtotal: '' |
| | | attribute: 'InventoryLevelEnd' |
| | | } |
| | | attribute_StockLevelInDays |
| | | { |
| | | type: 'MatrixEditorWebApiCellDataModelInterest' |
| | | index: 4 |
| | | rowsubtotal: '' |
| | | columnsubtotal: '' |
| | | attribute: 'StockLevelInDays' |
| | | } |
| | | } |
| | | } |
| | |
| | | { |
| | | sorting |
| | | { |
| | | criteria: '' |
| | | criteria: "datamember:'Start'" |
| | | } |
| | | } |
| | | rows |
| | | { |
| | | sorting |
| | | { |
| | | criteria: "datamember:'KPISetting.DisplayIndex'" |
| | | criteria: "datamember:'Product_MP.DisplayIndex';datamember:'Name'" |
| | | } |
| | | } |
| | | } |
| | |
| | | userconfigurableinformation |
| | | { |
| | | } |
| | | index: 2 |
| | | image: 'DOCUMENT_LOCK' |
| | | page: 'applicationDevelopmentActionBarPageDef' |
| | | group: '' |
| | | index: 2 |
| | | image: 'DOCUMENT_LOCK' |
| | | description: '' |
| | | } |
| | | formatversion: 2 |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | { |
| | | SelectableAttributes |
| | | { |
| | | ID |
| | | { |
| | | attribute: 'ID' |
| | | isactive: true |
| | | } |
| | | IsLocked |
| | | { |
| | | attribute: 'IsLocked' |
| | | isactive: true |
| | | } |
| | | } |
| | | meta_ |
| | | { |
| | | type: 'CustomerOrder' |
| | | } |
| | | } |