Пример #1
0
        public static void ExportToExcel()
        {
            var visitedAttrs = new List <string>();
            var csvFile      = new CSVFile()
            {
                FileName = "Formulas.csv"
            };

            foreach (var en in App.MigEntities)
            {
                foreach (var f in en.Formulas)
                {
                    var bloc = new CSVBloc()
                    {
                        EntityName    = f.SourceEntityName,
                        AttributeName = f.SourceEntityName
                    };

                    csvFile.Blocs.Add(bloc);

                    bloc.AddRow(new string[] { f.Name, f.Type.Value + "", f.Type.Name });
                }
            }

            csvFile.Export();
        }
Пример #2
0
        public static void ExportToExcel()
        {
            var visitedAttrs = new List <string>();
            var csvFile      = new CSVFile()
            {
                FileName = "OptionsReport.csv"
            };

            foreach (var en in App.MigEntities)
            {
                foreach (var attr in en.OptionAttributes)
                {
                    var visitedBloc = csvFile.Blocs.Where(b => b.AttributeName == attr.Name).FirstOrDefault();

                    if (visitedBloc != null)
                    {
                        visitedBloc.EntityName += "," + en.LogicalName;
                        continue;
                    }

                    var bloc = new CSVBloc()
                    {
                        EntityName    = en.LogicalName,
                        AttributeName = attr.Name
                    };

                    csvFile.Blocs.Add(bloc);

                    if (attr.LeftOnlyOptions.Count > 0 || attr.RightOnlyOptions.Count > 0)
                    {
                        if (attr.CommonOptions.Count == 2 && (attr.CommonOptions[0].Name == "Yes" || attr.CommonOptions[0].Name == "No"))
                        {
                            continue;
                        }

                        if (attr.Name == "statecode" || attr.Name == "statuscode")
                        {
                            continue;
                        }

                        foreach (var o in attr.CommonOptions)
                        {
                            bloc.AddRow(new string[] { o.Value.ToString(), o.Name, o.Value.ToString(), o.Name, o.Usage?"Yes":"No", o.AllUsage?"Yes":"No", o.AllUsageEntities });
                        }
                        foreach (var o in attr.LeftOnlyOptions)
                        {
                            bloc.AddRow(new string[] { o.Value.ToString(), o.Name, "", "", o.Usage ? "Yes" : "No", o.AllUsage ? "Yes" : "No", o.AllUsageEntities });
                        }
                        foreach (var o in attr.RightOnlyOptions)
                        {
                            bloc.AddRow(new string[] { "", "", o.Value.ToString(), o.Name, o.Usage ? "Yes" : "No", o.AllUsage ? "Yes" : "No", o.AllUsageEntities });
                        }
                    }
                }
            }

            csvFile.Export();
        }
Пример #3
0
        private void exportToExcelToolStripMenuItem_Click(object sender, EventArgs e)
        {
            var csvFile = new CSVFile()
            {
                FileName = "LookupsReport.csv"
            };

            foreach (var le in App.CrmLookupEntities)
            {
                var bloc = new CSVBloc()
                {
                    EntityName    = le.LogicalName,
                    AttributeName = ""
                };

                csvFile.Blocs.Add(bloc);


                if (le.LeftOnlyLookups.Count > 0 || le.RightOnlyLookups.Count > 0)
                {
                    foreach (var o in le.CommonLookups)
                    {
                        bloc.AddRow(new string[] { o.Name, o.Name });
                    }
                    foreach (var o in le.LeftOnlyLookups)
                    {
                        bloc.AddRow(new string[] { o.Name, "" });
                    }
                    foreach (var o in le.RightOnlyLookups)
                    {
                        bloc.AddRow(new string[] { "", o.Name });
                    }
                }
            }

            csvFile.Export();
        }