Exemplo n.º 1
0
        public static void OutputPDF(string path, List <DesignatorGroup> groups, HeaderBlock header, string file, bool rtf = false)
        {
            Console.WriteLine("Generating " + file + "...");

            // document setup
            var doc = new Document();

            doc.DefaultPageSetup.PageFormat   = PageFormat.A4;
            doc.DefaultPageSetup.Orientation  = Orientation.Landscape;
            doc.DefaultPageSetup.TopMargin    = "1.5cm";
            doc.DefaultPageSetup.BottomMargin = "1.5cm";
            doc.DefaultPageSetup.LeftMargin   = "1.5cm";
            doc.DefaultPageSetup.RightMargin  = "1.5cm";
            doc.Styles["Normal"].Font.Name    = "Arial";

            var footer = new Paragraph();

            footer.AddTab();
            footer.AddPageField();
            footer.AddText(" of ");
            footer.AddNumPagesField();
            footer.Format.Alignment = ParagraphAlignment.Center;

            // generate content
            var section = doc.AddSection();

            section.Footers.Primary.Add(footer.Clone());
            section.Footers.EvenPage.Add(footer.Clone());
            PDFCreateHeader(ref section, header);
            var para  = section.AddParagraph();
            var table = PDFCreateTable(ref section);

            // BOM table
            int i = 1;

            foreach (DesignatorGroup g in groups)
            {
                // check for groups that are entire "no part"
                bool all_no_part = true;
                foreach (Component c in g.comp_list)
                {
                    if (!c.no_part)
                    {
                        all_no_part = false;
                    }
                }
                if (all_no_part)
                {
                    continue;
                }

                // group header row
                var row = table.AddRow();
                row.Shading.Color             = Colors.LightGray;
                row.Cells[0].MergeRight       = 6;
                row.Cells[0].Format.Alignment = ParagraphAlignment.Left;

                DefaultComp def = Component.FindDefaultComp(g.designator);
                if (def != null)
                {
                    var p = row.Cells[0].AddParagraph(def.long_name);
                    p.Format.Font.Bold = true;
                    if (def.has_default)
                    {
                        row.Cells[0].AddParagraph("All " + def.default_type + " unless otherwise stated");
                    }
                }
                else
                {
                    var p = row.Cells[0].AddParagraph(g.designator);
                    p.Format.Font.Bold = true;
                }

                foreach (Component c in g.comp_list)
                {
                    if (c.no_part)
                    {
                        continue;
                    }

                    row = table.AddRow();
                    row.Cells[0].AddParagraph(i++.ToString());
                    row.Cells[1].AddParagraph((c.count + 1).ToString());
                    row.Cells[2].AddParagraph(c.reference);
                    row.Cells[3].AddParagraph(c.value);

                    string temp = c.footprint_normalized;
                    if (c.code != null)
                    {
                        temp += ", " + c.code;
                    }
                    if (c.precision != null)
                    {
                        temp += ", " + c.precision;
                    }
                    row.Cells[4].AddParagraph(temp);
                    //row.Cells[4].AddParagraph(c.footprint_normalized);

                    row.Cells[5].AddParagraph(c.part_no);
                    row.Cells[6].AddParagraph(c.note);
                }
            }

            // generate PDF file
            if (!rtf)
            {
                var pdfRenderer = new PdfDocumentRenderer(true, PdfSharp.Pdf.PdfFontEmbedding.Always);
                pdfRenderer.Document = doc;
                pdfRenderer.RenderDocument();
                pdfRenderer.PdfDocument.Save(file);
            }
            else
            {
                var rtfRenderer = new RtfDocumentRenderer();
                rtfRenderer.Render(doc, file, null);
            }
        }
Exemplo n.º 2
0
        public static void OutputPretty(string path, List <DesignatorGroup> groups, HeaderBlock header, string file)
        {
            Console.WriteLine("Generating " + file + "...");
            using (StreamWriter sw = new StreamWriter(file))
            {
                int count_width;
                int reference_width;
                int value_width;
                int footprint_width;
                int precision_width;
                PrettyMeasureWidths(groups, out count_width, out reference_width, out value_width, out footprint_width, out precision_width);

                sw.WriteLine("Title:      " + header.title);
                sw.WriteLine("Date:       " + header.date);
                sw.WriteLine("Source:     " + header.source);
                sw.WriteLine("Revsision:  " + header.revision);
                if (header.company != "")
                {
                    sw.WriteLine("Company:    " + header.company);
                }
                sw.WriteLine("");

                //sw.WriteLine("No.  Designation    Value          Footprint     Precision");
                sw.Write(TextUtils.FixedLengthString("No.", ' ', count_width) + "  ");
                sw.Write(TextUtils.FixedLengthString("Reference", ' ', reference_width) + "  ");
                sw.Write(TextUtils.FixedLengthString("Value", ' ', value_width) + "  ");
                sw.Write(TextUtils.FixedLengthString("Footprint", ' ', footprint_width) + "  ");
                sw.WriteLine("Precision");
                sw.WriteLine("");

                foreach (DesignatorGroup g in groups)
                {
                    // check for groups that are entire "no part"
                    bool all_no_part = true;
                    foreach (Component c in g.comp_list)
                    {
                        if (!c.no_part)
                        {
                            all_no_part = false;
                        }
                    }
                    if (all_no_part)
                    {
                        continue;
                    }

                    // header
                    DefaultComp def = Component.FindDefaultComp(g.designator);
                    if (def != null)
                    {
                        sw.Write("[ " + def.long_name);
                        sw.Write(", " + g.comp_list.Count.ToString() + (g.comp_list.Count > 1 ? " values" : " value"));
                        if (def.has_default)
                        {
                            sw.Write(", " + def.default_type + " unless otherwise stated");
                        }
                        sw.WriteLine(" ]");
                    }
                    else
                    {
                        sw.WriteLine("[ " + g.designator + ", " + g.comp_list.Count.ToString() +
                                     (g.comp_list.Count > 1 ? " values" : " value") + " ]");
                    }

                    sw.WriteLine(new string('-', count_width + 2 + reference_width + 2 + value_width + 2 + footprint_width + 2 + precision_width));

                    // component list
                    foreach (Component c in g.comp_list)
                    {
                        if (c.no_part)
                        {
                            continue;
                        }

                        string footprint = c.footprint_normalized;
                        if (footprint == "")
                        {
                            footprint = c.footprint;
                        }
                        sw.Write(TextUtils.FixedLengthString((c.count + 1).ToString(), ' ', count_width) + "  ");

                        string reference   = TextUtils.Reformat(c.reference, reference_width);
                        int    split_point = reference.IndexOf('\n');
                        if (split_point == -1)
                        {
                            sw.Write(TextUtils.FixedLengthString(reference, ' ', reference_width) + "  ");
                        }
                        else
                        {
                            sw.Write(TextUtils.FixedLengthString(reference.Substring(0, split_point - 1), ' ', reference_width) + "  ");
                        }

                        sw.Write(TextUtils.FixedLengthString(c.value, ' ', value_width) + "  ");
                        //sw.Write(TextUtils.FixedLengthString(c.part_no, ' ', 10));
                        sw.Write(TextUtils.FixedLengthString(footprint, ' ', footprint_width) + "  ");
                        if (!string.IsNullOrEmpty(c.precision))
                        {
                            sw.Write(TextUtils.FixedLengthString(c.precision, ' ', precision_width));
                        }
                        sw.WriteLine();

                        if (split_point != -1)                          // need to do the rest of the references
                        {
                            string indent = new string(' ', count_width + 2);
                            do
                            {
                                reference   = reference.Substring(split_point + 1);
                                split_point = reference.IndexOf('\n');
                                if (split_point == -1)
                                {
                                    sw.WriteLine(indent + reference.Trim());
                                }
                                else
                                {
                                    sw.WriteLine(indent + reference.Substring(0, split_point - 1).Trim());
                                }
                            } while (split_point != -1);
                        }
                    }
                    sw.WriteLine();
                }
            }
        }
Exemplo n.º 3
0
        public static void OutputXLSX(string path, List <DesignatorGroup> groups, HeaderBlock header, string file, string template, string footer, bool nfl)
        {
            ExcelPackage   p = null;
            ExcelWorksheet ws;
            ExcelRange     r;
            int            table_x;
            int            table_y;

            if (string.IsNullOrEmpty(template))
            {
                XLSXCreateDefaultSheet(ref p, header, out ws);
                table_x = 1;
                table_y = 8;
            }
            else
            {
                XLXSLoadSheet(template, ref p, header, out ws, out table_x, out table_y);
            }


            int row = table_y;

            table_x--;
            foreach (DesignatorGroup g in groups)
            {
                // check for groups that are entirly "no part" or "no fit"
                bool all_no_part = true;
                foreach (Component c in g.comp_list)
                {
                    if (!c.no_part && !c.no_fit)
                    {
                        all_no_part = false;
                    }
                }
                if (all_no_part)
                {
                    continue;
                }

                // header
                DefaultComp def = Component.FindDefaultComp(g.designator);
                if (def != null)
                {
                    ws.Cells[row, table_x + 1].Value = def.long_name;
                    ws.Cells[row, table_x + 2].Value = g.comp_list.Count.ToString() + " value(s)";
                    if (def.has_default)
                    {
                        ws.Cells[row, 3].Value = def.default_type + " unless otherwise stated";
                    }
                }
                else
                {
                    ws.Cells[row, table_x + 1].Value = g.designator;
                    ws.Cells[row, table_x + 2].Value = g.comp_list.Count.ToString() + " value(s)";
                }
                XLXSStyleHeader(row, table_x, ref ws);
                row++;

                // component list
                foreach (Component c in g.comp_list)
                {
                    if (c.no_part)
                    {
                        continue;
                    }

                    string footprint = c.footprint_normalized;
                    if (footprint == "")
                    {
                        footprint = c.footprint;
                    }
                    ws.Cells[row, table_x + 1].Value = c.count + 1;
                    ws.Cells[row, table_x + 2].Value = c.reference;
                    ws.Cells[row, table_x + 3].Value = c.value;
                    ws.Cells[row, table_x + 4].Value = c.part_no;
                    ws.Cells[row, table_x + 5].Value = footprint;
                    ws.Cells[row, table_x + 6].Value = c.precision;
                    r = ws.Cells[row, table_x + 1, row, table_x + 6];
                    r.Style.Border.BorderAround(ExcelBorderStyle.Thin, System.Drawing.Color.LightGray);
                    r.Style.Border.Left.Style = ExcelBorderStyle.Thin;
                    r.Style.Border.Left.Color.SetColor(System.Drawing.Color.LightGray);
                    row++;
                }
                row++;
            }

            r = ws.Cells[1, table_x + 1, row, table_x + 6];
            r.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
            r.Style.VerticalAlignment   = ExcelVerticalAlignment.Top;
            r.Style.WrapText            = true;

            if (nfl)                    // no fit part list
            {
                XLXSNoFitList(ref row, table_x, ref ws, groups);
            }

            XLXSFooter(path, footer, ref ws, ref row);

            // generate output file
            byte[] bin = p.GetAsByteArray();
            File.WriteAllBytes(file, bin);
        }
Exemplo n.º 4
0
        public static void OutputTSV(string path, List <DesignatorGroup> groups, HeaderBlock header, string file)
        {
            Console.WriteLine("Generating " + file + "...");
            using (StreamWriter sw = new StreamWriter(file))
            {
                sw.WriteLine("Title\t" + header.title);
                sw.WriteLine("Date\t" + header.date);
                sw.WriteLine("Source\t" + header.source);
                sw.WriteLine("Revsision\t" + header.revision);
                if (header.company != "")
                {
                    sw.WriteLine("Company\t" + header.company);
                }
                sw.WriteLine("");
                //sw.WriteLine("Type\tDesignation\tValue\tPart Name");

                foreach (DesignatorGroup g in groups)
                {
                    // check for groups that are entire "no part"
                    bool all_no_part = true;
                    foreach (Component c in g.comp_list)
                    {
                        if (!c.no_part)
                        {
                            all_no_part = false;
                        }
                    }
                    if (all_no_part)
                    {
                        continue;
                    }

                    // header
                    //sw.WriteLine("Group: " + g.designator + " (" + g.comp_list.Count.ToString() + ")");
                    DefaultComp def = Component.FindDefaultComp(g.designator);
                    if (def != null)
                    {
                        sw.Write(def.long_name);
                        sw.Write("\t" + g.comp_list.Count.ToString() + " values");
                        if (def.has_default)
                        {
                            sw.Write("\t" + def.default_type + " unless otherwise stated");
                        }
                        sw.WriteLine();
                    }
                    else
                    {
                        sw.WriteLine(g.designator + "\t" + g.comp_list.Count.ToString());
                    }

                    // component list
                    foreach (Component c in g.comp_list)
                    {
                        if (c.no_part)
                        {
                            continue;
                        }

                        string footprint = c.footprint_normalized;
                        if (footprint == "")
                        {
                            footprint = c.footprint;
                        }
                        sw.WriteLine((c.count + 1).ToString() +
                                     "\t" + c.reference +
                                     "\t" + c.value +
                                     "\t" + c.part_no +
                                     "\t" + footprint +
                                     "\t" + c.precision);
                    }
                    sw.WriteLine();
                }
            }
        }
Exemplo n.º 5
0
        static bool ParseKicadXML(XmlDocument doc, string path, string filename, string outputs, string output_filename, string template, string footer, bool nfl)
        {
            HeaderBlock header = new HeaderBlock();

            if (!header.ParseHeader(doc))
            {
                Console.WriteLine("Could not parse XML header block.");
                return(false);
            }

            // build component list
            List <Component> comp_list = ParseComponents(doc);

            if (comp_list == null)
            {
                return(false);
            }

            // group components by designators and sort by value
            List <DesignatorGroup> groups = Component.BuildDesignatorGroups(comp_list);

            Component.SortDesignatorGroups(ref groups);
            List <DesignatorGroup> merged_groups = Component.MergeComponents(groups);

            Component.SortComponents(ref merged_groups);

            // sort groups alphabetically
            merged_groups.Sort((a, b) => a.designator.CompareTo(b.designator));

            if (output_filename == "")
            {
                string base_filename = Path.GetFileNameWithoutExtension(path + filename);
                if (outputs.Contains('t'))
                {
                    Output.OutputTSV(path, merged_groups, header, path + base_filename + ".tsv.txt");
                }
                if (outputs.Contains('q'))
                {
                    Output.OutputPretty(path, merged_groups, header, path + base_filename + ".txt");
                }
                if (outputs.Contains('x'))
                {
                    Output.OutputXLSX(path, merged_groups, header, path + base_filename + ".xlsx", template, footer, nfl);
                }
                if (outputs.Contains('p'))
                {
                    Output.OutputPDF(path, merged_groups, header, path + base_filename + ".pdf");
                }
                if (outputs.Contains('r'))
                {
                    Output.OutputPDF(path, merged_groups, header, path + base_filename + ".rtf", true);
                }
            }
            else
            {
                if (outputs.Contains('t'))
                {
                    Output.OutputTSV(path, merged_groups, header, output_filename);
                }
                if (outputs.Contains('q'))
                {
                    Output.OutputPretty(path, merged_groups, header, output_filename);
                }
                if (outputs.Contains('x'))
                {
                    Output.OutputXLSX(path, merged_groups, header, output_filename, template, footer, nfl);
                }
                if (outputs.Contains('p'))
                {
                    Output.OutputPDF(path, merged_groups, header, output_filename);
                }
                if (outputs.Contains('r'))
                {
                    Output.OutputPDF(path, merged_groups, header, output_filename, true);
                }
            }

            // debug output
            if (outputs.Contains('d'))
            {
                foreach (DesignatorGroup g in merged_groups)
                {
                    Console.WriteLine("Group: " + g.designator + " (" + g.comp_list.Count.ToString() + ")");
                    DefaultComp def = Component.FindDefaultComp(g.designator);
                    if (def != null)
                    {
                        Console.Write("(" + def.long_name);
                        if (def.has_default)
                        {
                            Console.Write(", " + def.default_type + " unless otherwise stated");
                        }
                        Console.WriteLine(")");
                    }
                    foreach (Component c in g.comp_list)
                    {
                        Console.WriteLine("\t" + c.reference +
                                          "\t" + c.value +
                                          "\t" + c.footprint_normalized);
                    }
                    Console.WriteLine();
                }
            }
            return(true);
        }