private void Send_btn_Click(object sender, EventArgs e)
{
if (Tabs_cbx.Text == "")
{
MessageBox.Show("Please Select a Tab", "Select a Tab", MessageBoxButtons.OK, MessageBoxIcon.Error);
Tabs_cbx.Focus();
return;
}
PlanSwift.Tab CurrentTab;
CurrentTab = TGlobal.pc.Tabs.ByName(Tabs_cbx.Text);
CurrentTab.MakeActive();
AuCad = new Autodesk.AutoCAD.Interop.AcadApplication();
AuCad.Visible = true;
AuDocument = AuCad.ActiveDocument;
for (int ItemIndex = 0; ItemIndex <= CurrentTab.Count - 1; ItemIndex++)
{
GetItems(CurrentTab[ItemIndex]);
}
AuCad.ZoomAll();
AuCad = null;
AuDocument = null;
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (Tabs_cbx.Text == "")
{
MessageBox.Show("Please Select a Tab", "Select a Tab", MessageBoxButtons.OK, MessageBoxIcon.Error);
Tabs_cbx.Focus();
return;
}
//Excel.Application oExcel;
//Excel._Workbook oWBook;
//Excel._Worksheet oSheet;
//PlanSwift.Tab CurrentTab;
int i = 0;
// Start Excel and get Application object
oExcel = new Excel.Application();
// Create new Workbook
oWBook = (Excel._Workbook)(oExcel.Workbooks.Add(Missing.Value));
oSheet = (Excel._Worksheet)oWBook.ActiveSheet;
// Add Header Information
oSheet.Cells[1, 1] = "Tab";
oSheet.Cells[1, 2] = "Name";
oSheet.Cells[1, 3] = "Item Number";
oSheet.Cells[1, 4] = "Qty";
oSheet.Cells[1, 5] = "Price Each";
oSheet.Cells[1, 6] = "Price Total";
oSheet.Cells[1, 7] = "Item Type";
// Apply Header Formating
oSheet.get_Range("A1", "G1").Font.Bold = true;
oSheet.get_Range("A1", "G1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
//Get Selected Planswift Tab
CurrentTab = TGlobal.pc.Tabs.ByName(Tabs_cbx.Text);
CurrentTab.MakeActive();
for (int ItemIndex = 0; ItemIndex <= CurrentTab.Count - 1; ItemIndex++)
{
GetItems(CurrentTab[ItemIndex]);
i = ItemIndex;
}
oSheet.get_Range("A1", "G1").EntireColumn.AutoFit();
oExcel.Visible = true;
oExcel = null;
oWBook = null;
oSheet = null;
}
private void Send_btn_Click(object sender, EventArgs e)
{
if (Tabs_cbx.Text == "")
{
MessageBox.Show("Please Select a Tab", "Select a Tab", MessageBoxButtons.OK, MessageBoxIcon.Error);
Tabs_cbx.Focus();
return;
}
// Start Word and Get Application Object
oWord = new Word.Application();
PlanSwift.Tab CurrentTab;
oWord.Visible = true;
object FilePath = Environment.CurrentDirectory + @"\Templates\Work Order.dotx";
object Readonly = false;
object missing = System.Reflection.Missing.Value;
object isVisible = true;
object TStyle = "Medium Shading 1 - Accent 1";
//Open Template
oDocument = (Word._Document)oWord.Documents.Open(ref FilePath, ref missing, ref Readonly, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible,
ref missing, ref missing, ref missing, ref missing);
// Apply Table Formating Style
oDocument.Tables[2].set_Style(ref TStyle);
oDocument.Tables[2].Columns[3].Width = 40;
oDocument.Tables[2].Columns[4].Width = 70;
// Get Planswift Items
CurrentTab = TGlobal.pc.Tabs.ByName(Tabs_cbx.Text);
CurrentTab.MakeActive();
for (int ItemIndex = 0; ItemIndex <= CurrentTab.Count - 1; ItemIndex++)
{
GetItems(CurrentTab[ItemIndex]);
}
//Delete Last unused Row
oDocument.Tables[2].Rows[ItemNumber].Delete();
//Free Microsoft Word
oWord = null;
oDocument = null;
this.Close();
}
private void send_btn_Click(object sender, EventArgs e)
{
if (Tabs_cbx.Text == "")
{
MessageBox.Show("Please Select a Tab", "Select a Tab", MessageBoxButtons.OK, MessageBoxIcon.Error);
Tabs_cbx.Focus();
return;
}
OLook = new OutLook.Application();
OMail = (OutLook.MailItem)OLook.CreateItem(Microsoft.Office.Interop.Outlook.OlItemType.olMailItem);
OMail.Display(OMail);
OMail.To = to_txt.Text;
OMail.CC = CC_txt.Text;
OMail.Subject = Subject_txt.Text;
CurrentTab = TGlobal.pc.Tabs.ByName(Tabs_cbx.Text);
CurrentTab.MakeActive();
for (int ItemIndex = 0; ItemIndex <= CurrentTab.Count - 1; ItemIndex++)
{
GetItems(CurrentTab[ItemIndex]);
}
OMail.BodyFormat = Microsoft.Office.Interop.Outlook.OlBodyFormat.olFormatHTML;
OMail.HTMLBody = "<HTML><body><b>Job Name: </b>" + TGlobal.pc.JobNumber +
"<br><b>Description: </b>" + TGlobal.pc.JobName + "<br><br><i><b>Item Types</b></i><br>";
OMail.HTMLBody = OMail.HTMLBody + "<Table width=" + chr + "400" +
chr + "Height=" + chr + "9" + chr + ">";
for (int HtmLoop = 0; HtmLoop <= 1; HtmLoop++)
{
if (HtmLoop > 0)
{
OMail.HTMLBody = OMail.HTMLBody + "</Table><br><i><b>Total Quantity’s</b></i>";
OMail.HTMLBody = OMail.HTMLBody + "<Table width=" + chr + "400" + chr + "Height=" + chr + "9" + chr + ">";
}
String ArrCount;
if (Folders_ck.Checked)
{
if (HtmLoop == 0)
{
ArrCount = System.Convert.ToString(FolderArry.Count);
AddHtml("Folders", ArrCount);
}
}
if (Assem_ck.Checked)
{
if (HtmLoop > 0)
{
ArrCount = GetSum(AssemblyQArry);
}
else
{
ArrCount = System.Convert.ToString(AssemblyQArry.Count);
}
AddHtml("Assemblies", ArrCount);
}
if (Parts_ck.Checked)
{
if (HtmLoop > 0)
{
ArrCount = GetSum(PartQArry);
}
else
{
ArrCount = System.Convert.ToString(PartQArry.Count);
}
AddHtml("Parts", ArrCount);
}
if (Area_ck.Checked)
{
if (HtmLoop > 0)
{
ArrCount = GetSum(AreaQArry);
}
else
{
ArrCount = System.Convert.ToString(AreaQArry.Count);
}
AddHtml("Areas", ArrCount);
}
if (Linear_ck.Checked)
{
if (HtmLoop > 0)
{
ArrCount = GetSum(LinearQArry);
}
else
{
ArrCount = System.Convert.ToString(LinearQArry.Count);
}
AddHtml("Linears", ArrCount);
}
if (Segment_ck.Checked)
{
if (HtmLoop > 0)
{
ArrCount = GetSum(SegmentQArry);
}
else
{
ArrCount = System.Convert.ToString(SegmentQArry.Count);
}
AddHtml("Segments", ArrCount);
}
if (Count_ck.Checked)
{
if (HtmLoop > 0)
{
ArrCount = GetSum(CountQArry);
}
else
{
ArrCount = System.Convert.ToString(CountQArry.Count);
}
AddHtml("Counts", ArrCount);
}
}
OMail.HTMLBody = OMail.HTMLBody + "</Table></body></HTML>";
OLook = null;
OMail = null;
this.Close();
}
