private void Form1_Load(object sender, EventArgs e) { TGlobal.ps = new pswift.PlanSwift(); string tkpath = TGlobal.ps.Root().FullPath() + "\\Job\\TakeOff"; pswift.IItem takeoff = TGlobal.ps.GetItem(tkpath); TGlobal.tlst = new List <string>(); loadTakeoffItems(takeoff, TGlobal.tlst); this.progressBar1.Minimum = 0; this.progressBar1.Maximum = TGlobal.tlst.Count - 1; }
public void itmtoexcel(pswift.IItem itm, int rowidx, Excel._Worksheet osheet) { if (rowidx > 36) { osheet.Cells[rowidx, 1].EntireRow.Insert(System.Reflection.Missing.Value); } osheet.Cells[rowidx, 1].value = itm.GetPropertyResultAsString("Qty", ""); osheet.Cells[rowidx, 2].value = itm.GetProperty("Qty").Units; osheet.Cells[rowidx, 3].value = itm.GetPropertyResultAsString("Item #", ""); osheet.Cells[rowidx, 4].value = itm.Name; osheet.Cells[rowidx, 5].value = itm.GetPropertyResultAsString("Price Each", ""); osheet.Cells[rowidx, 6].value = itm.GetPropertyResultAsString("Price Total", ""); }
public void itmtoword(pswift.IItem itm, Word.Table tbl, int rowidx, string tp) { if (rowidx > 20) { tbl.Rows.Add(System.Reflection.Missing.Value); } if (tp == "Digitizer") { tbl.Cell(rowidx, 1).Range.Font.Bold = 1; tbl.Cell(rowidx, 1).Range.Font.Italic = 0; } else { tbl.Cell(rowidx, 1).Range.Font.Bold = 0; tbl.Cell(rowidx, 1).Range.Font.Italic = 1; } tbl.Cell(rowidx, 1).Range.Text = itm.Name; tbl.Cell(rowidx, 2).Range.Text = itm.GetPropertyResultAsString("Qty", ""); tbl.Cell(rowidx, 3).Range.Text = itm.GetProperty("Qty").Units; tbl.Cell(rowidx, 4).Range.Text = itm.GetPropertyResultAsString("Price Each", ""); tbl.Cell(rowidx, 5).Range.Text = itm.GetPropertyResultAsString("Price Total", ""); }
public void loadTakeoffItems(pswift.IItem itm, List <string> lst) { for (int idx = 0; idx <= itm.ChildCount() - 1; idx++) { pswift.IItem citm = itm[idx]; if (citm.GetProperty("Type").ResultAsString() == "Folder") { loadTakeoffItems(citm, lst); } else { Boolean isItem = citm.GetPropertyResultAsBoolean("IsItem", false); if (isItem) { lst.Add(citm.GUID()); } if (citm.ChildCount() != 0) { loadTakeoffItems(citm, lst); } } } }
private void button1_Click(object sender, EventArgs e) { Form2 RForm = new Form2(); RForm.ShowDialog(); if (RForm.DialogResult != DialogResult.OK) { RForm.Dispose(); return; } Object template = Directory.GetCurrentDirectory() + "\\Includes\\Word_Template.dotx"; Console.WriteLine(template.ToString()); Object oMissing = System.Reflection.Missing.Value; Object isvisible = true; Word._Application oWord = new Word.Application(); try { Word._Document oDoc = oWord.Documents.Add(template, oMissing, oMissing, isvisible); Word.Table otable = oDoc.Tables[2]; String ReportType = RForm.ReportCBX.Text; if (ReportType == "Digitizer Items Only") { int rowidx = 1; for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); Boolean isDigitizer = false; if (itm.GetPropertyResultAsBoolean("isArea", false) == true) { isDigitizer = true; } if (itm.GetPropertyResultAsBoolean("isLinear", false) == true) { isDigitizer = true; } if (itm.GetPropertyResultAsBoolean("isSegment", false) == true) { isDigitizer = true; } if (itm.GetPropertyResultAsBoolean("isCount", false) == true) { isDigitizer = true; } if (isDigitizer) { rowidx++; itmtoword(itm, otable, rowidx, "Digitizer"); } this.progressBar1.Value = idx; } } if (ReportType == "Parts Only") { int rowidx = 1; for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); if (itm.GetPropertyResultAsBoolean("isPart", false) == true) { rowidx++; itmtoword(itm, otable, rowidx, "Part"); } this.progressBar1.Value = idx; } } if (ReportType == "Digitizer Items w/Parts") { int rowidx = 1; for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); rowidx++; if (itm.GetPropertyResultAsBoolean("isPart", false) == true) { itmtoword(itm, otable, rowidx, "Part"); } else { itmtoword(itm, otable, rowidx, "Digitizer"); } this.progressBar1.Value = idx; } } } finally { this.progressBar1.Value = 0; oWord.Visible = true; oWord = null; RForm.Dispose(); } }
public string createMailBody(string RT) { char quo = (char)34; string body = "<body>"; body = body + "<h1>Report Type: " + RT + "</h1>" + "\r\n"; body = body + "<table style=" + quo + "width:auto; font-weight:Bold; font-family:Tahoma; font-size:14px;" + quo + ">" + "\r\n"; body = body + "<tr>" + "\r\n"; body = body + "<td style=" + quo + "width:200px; font-weight:Bold; font-family:Tahoma; font-size:14px;" + quo + ">"; body = body + "Name"; body = body + "</td>" + "\r\n"; body = body + "<td style=" + quo + "width:100px; font-weight:Bold; font-family:Tahoma; font-size:14px;" + quo + ">"; body = body + "Qty"; body = body + "</td>" + "\r\n"; body = body + "<td style=" + quo + "width:100px; font-weight:Bold; font-family:Tahoma; font-size:14px;" + quo + ">"; body = body + "Price Each"; body = body + "</td>" + "\r\n"; body = body + "<td style=" + quo + "width:100px; font-weight:Bold; font-family:Tahoma;font-size:14px;" + quo + ">"; body = body + "Price Total"; body = body + "</td>" + "\r\n"; body = body + "</tr>" + "\r\n"; if (RT == "Digitizer Items Only") { for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); if (itm.GetPropertyResultAsBoolean("isPart", false) == false) { body = body + "<tr><td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.Name + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.GetPropertyResultAsString("Qty", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.GetPropertyResultAsString("Price Each", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.GetPropertyResultAsString("Price Total", "") + "</td>"; body = body + "</tr>"; } } } if (RT == "Parts Only") { for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); if (itm.GetPropertyResultAsBoolean("isPart", false) == true) { body = body + "<tr><td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.Name + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.GetPropertyResultAsString("Qty", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.GetPropertyResultAsString("Price Each", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal;" + quo + ">" + itm.GetPropertyResultAsString("Price Total", "") + "</td>"; body = body + "</tr>"; } } } if (RT == "Digitizer Items w/Parts") { for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); if (itm.GetPropertyResultAsBoolean("isPart", false) == false) { body = body + "<tr><td style=" + quo + "font-size:12px; font-weight:normal; color:#007dc3;" + quo + ">" + itm.Name + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal; color:#007dc3;" + quo + ">" + itm.GetPropertyResultAsString("Qty", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal; color:#007dc3;" + quo + ">" + itm.GetPropertyResultAsString("Price Each", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal; color:#007dc3;" + quo + ">" + itm.GetPropertyResultAsString("Price Total", "") + "</td>"; body = body + "</tr>"; } if (itm.GetPropertyResultAsBoolean("isPart", false) == true) { body = body + "<tr><td style=" + quo + "font-size:12px; font-weight:normal; color:#0000FF;" + quo + ">" + itm.Name + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal; color:#0000FF;" + quo + ">" + itm.GetPropertyResultAsString("Qty", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal; color:#0000FF;" + quo + ">" + itm.GetPropertyResultAsString("Price Each", "") + "</td>"; body = body + "<td style=" + quo + "font-size:12px; font-weight:normal; color:#0000FF;" + quo + ">" + itm.GetPropertyResultAsString("Price Total", "") + "</td>"; body = body + "</tr>"; } } } return(body); }
private void button2_Click(object sender, EventArgs e) { Form2 RForm = new Form2(); RForm.ShowDialog(); if (RForm.DialogResult != DialogResult.OK) { RForm.Dispose(); return; } Object template = Directory.GetCurrentDirectory() + "\\Includes\\Excel_Template.XLT"; Console.WriteLine(template.ToString()); Object oMissing = System.Reflection.Missing.Value; Object isvisible = true; Excel._Application oExcel = new Excel.Application(); try { Excel._Workbook oBook = oExcel.Workbooks.Add(template); Excel._Worksheet oSheet = oExcel.Worksheets[1]; String ReportType = RForm.ReportCBX.Text; if (ReportType == "Digitizer Items Only") { int rowidx = 17; for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); Boolean isDigitizer = false; if (itm.GetPropertyResultAsBoolean("isArea", false) == true) { isDigitizer = true; } if (itm.GetPropertyResultAsBoolean("isLinear", false) == true) { isDigitizer = true; } if (itm.GetPropertyResultAsBoolean("isSegment", false) == true) { isDigitizer = true; } if (itm.GetPropertyResultAsBoolean("isCount", false) == true) { isDigitizer = true; } if (isDigitizer) { rowidx++; itmtoexcel(itm, rowidx, oSheet); } this.progressBar1.Value = idx; } } if (ReportType == "Parts Only") { int rowidx = 17; for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); if (itm.GetPropertyResultAsBoolean("isPart", false) == true) { rowidx++; itmtoexcel(itm, rowidx, oSheet); } this.progressBar1.Value = idx; } } if (ReportType == "Digitizer Items w/Parts") { int rowidx = 17; for (int idx = 0; idx <= TGlobal.tlst.Count - 1; idx++) { pswift.IItem itm = TGlobal.ps.GetItem(TGlobal.tlst[idx]); rowidx++; if (itm.GetPropertyResultAsBoolean("isPart", false) == true) { itmtoexcel(itm, rowidx, oSheet); } else { itmtoexcel(itm, rowidx, oSheet); } this.progressBar1.Value = idx; } } } finally { this.progressBar1.Value = 0; oExcel.Visible = true; oExcel = null; RForm.Dispose(); } }