예제 #1
0
        //Constructeur
        public Stock_OTF()
        {
            FieldAttributes fmtMonetaire = new FmtMonetaire().NumFormat;
            FieldAttributes fmtQuantite  = new FmtQuantite().NumFormat;

            Type    = "table";
            Options = new Options {
                title = "Modèle Stock"
            };
            Colonnes = new Object[] {
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=%CODESI"
                        }, FieldLabels = new List <string>()
                        {
                            "%CODESI"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=%SOURCE"
                        }, FieldLabels = new List <string>()
                        {
                            "Source"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Annee"
                        }, FieldLabels = new List <string>()
                        {
                            "Annee"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Mois"
                        }, FieldLabels = new List <string>()
                        {
                            "Mois"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Societe.Code"
                        }, FieldLabels = new List <string>()
                        {
                            "Societe"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=SocieteEtablissement.Code"
                        }, FieldLabels = new List <string>()
                        {
                            "Societe"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Count(%CODESI)", Label = "Nb lignes", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                //Entree-Sortie
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Stock.CodeMouvement"
                        }, FieldLabels = new List <string>()
                        {
                            "Societe"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(Stock.QuantiteMouvement)", Label = "Qt_Mvt", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                // Etat
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(Stock.Quantite)", Label = "Qt_Stock", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(Stock.MontantValorisation)", Label = "Mt_Valorisation", NumFormat = fmtMonetaire
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                //Calcul des besoins
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(Stock.QuantiteBesoinsSemainePlus1)", Label = "Qt_BesoinsSP1", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                }
            };
        }
예제 #2
0
        //Constructeur
        public Telephonie_OTF()
        {
            FieldAttributes fmtMonetaire = new FmtMonetaire().NumFormat;
            FieldAttributes fmtQuantite  = new FmtQuantite().NumFormat;

            Type    = "table";
            Options = new Options {
                title = "Modèle Telephonie"
            };
            Colonnes = new Object[] {
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=%CODESI"
                        }, FieldLabels = new List <string>()
                        {
                            "%CODESI"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Annee"
                        }, FieldLabels = new List <string>()
                        {
                            "Annee"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Mois"
                        }, FieldLabels = new List <string>()
                        {
                            "Mois"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Semaine"
                        }, FieldLabels = new List <string>()
                        {
                            "Semaine"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "date(Min(%DATE))", Label = "Du"
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "date(Max(%DATE))", Label = "Au"
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=POLE"
                        }, FieldLabels = new List <string>()
                        {
                            "Pôle"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "count(%SICLI)", Label = "Nb lignes", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(appel_traité)", Label = "Nb appels traités", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                }
            };
        }
예제 #3
0
        //Constructeur
        public Ventes_OTF()
        {
            FieldAttributes fmtMonetaire = new FmtMonetaire().NumFormat;
            FieldAttributes fmtQuantite  = new FmtQuantite().NumFormat;

            Type    = "table";
            Options = new Options {
                title = "Modèle Ventes"
            };
            Colonnes = new Object[] {
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=%CODESI"
                        }, FieldLabels = new List <string>()
                        {
                            "%CODESI"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=%SOURCE"
                        }, FieldLabels = new List <string>()
                        {
                            "Source"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Annee"
                        }, FieldLabels = new List <string>()
                        {
                            "Annee"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Mois"
                        }, FieldLabels = new List <string>()
                        {
                            "Mois"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxDimension {
                    Def = new NxInlineDimensionDef {
                        FieldDefs = new List <string>()
                        {
                            "=Societe.Code"
                        }, FieldLabels = new List <string>()
                        {
                            "Societe"
                        }
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Count(%CODESI)", Label = "Nb lignes", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                //Ventes facturées
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(Ventes.QuantiteFacturee)", Label = "Qt_Facturée", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(Ventes.CaBrut)", Label = "CaBrut", NumFormat = fmtMonetaire
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                //Ventes manque
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(VentesManquees.Quantite)", Label = "Qt_Manquées", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                },
                //Pharamml
                new NxMeasure {
                    Def = new NxInlineMeasureDef {
                        Def = "Sum(DemandesPharmaML.NonSatisfaite)", Label = "Qt_DIPNs", NumFormat = fmtQuantite
                    }, AttributeDimensions = null, AttributeExpressions = null
                }
            };
        }