public void PrintJobStatList(int deptID, bool isPreview, int sortCode) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatListByDeptID(deptID, sortCode); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); //************** Done 6/29/15 pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewReport(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PrintJobStat(int deptID, int projID) { //FPreview pv; //rprtJobStat rprt = new rprtJobStat(); //DataSet ds; //ds = CBDrawingLog.GetJobStatForRprt(deptID, projID); //rprt = new rprtJobStat(); //rprt.SetDataSource(ds); //pv = new FPreview(); //pv.ShowReport(rprt); //pv.ShowDialog(); ////rprt.PrintToPrinter(1, false, 0, 0); FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatForRprt(deptID, projID); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); pv.ViewReport(rprt); pv.ShowDialog(); }
public void PrintDrawingLogList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode, int drwgSpec) { FPreviewAR pv; rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2(); dsDrawingLog dl; dl = CBDrawingLog.GetDrawingLogMainByLeadList(deptXml, leadXml, sortCode, drwgSpec); string name_of_Method = "GetDrawingLogMainByLeadList"; //**************************Added 10/3/2015 rprt.DataSource = dl; rprt.DataMember = "DrawingList"; rprt.SetTitle = GetDrawingSpecTitle(drwgSpec); pv = new FPreviewAR(); //************** Done 6/29/15 pv.name_of_Method = name_of_Method; pv.leadXml = leadXml; pv.deptXml = deptXml; pv.sortCode = sortCode; pv.drwgSpec = drwgSpec; pv.Title = rprt.SetTitle; //********************************12/01 pv.ViewDrawingLogWithExcel(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewDrawingLogWithExcel(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PrintJobStatList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatListByLeadList(deptXml, leadXml, sortCode); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); //************** Done 6/29/15 pv.Title = "DRAWING/SPEC LOG"; //********************************12/01 pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewReport(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PreviewBudgetFormEntry(int budID, string wbs) { FPreviewAR pv = new FPreviewAR(); rprtBudgetAccounting rprt = new rprtBudgetAccounting(); DataSet ds; CBBudget bud = new CBBudget(); CBProject proj = new CBProject(); CBCustomer cust = new CBCustomer(); CBLocation loc = new CBLocation(); CBState state = new CBState(); bud.Load(budID); proj.Load(bud.ProjectID); cust.Load(proj.CustomerID); loc.Load(proj.LocationID); state.Load(loc.StateID); ds = CBBudget.GetBudgetAccountingEntryForReport(budID, wbs); rprt.SetTitles(cust.Name + " / " + loc.City + "," + state.Abbrev, proj.Description, proj.Number, bud.GetNumber(), wbs); rprt.DataSource = ds; rprt.DataMember = "Table"; pv.projNumber = proj.Number; //*************************Added 6/29/15 pv.ViewReport(rprt); pv.ShowDialog(); }
public void PrintDrawingLogList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode) { FPreviewAR pv; //rprtDrawingLog1 rprt = new rprtDrawingLog1(); rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2(); dsDrawingLog dl; dl = CBDrawingLog.GetDrawingLogMainByLeadList(deptXml, leadXml, sortCode, 0); rprt.SetDrawingLogAsCustomerReport(); rprt.DataSource = dl; rprt.DataMember = "DrawingList"; pv = new FPreviewAR(); //************** Done 6/29/15 pv.Title = "DRAWING/SPEC LOG"; //********************************12/01 pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //pv.ViewReport(rprt); pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PrintJobStatList(int deptID, bool isPreview, int sortCode) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatListByDeptID(deptID, sortCode); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); pv.ViewReport(rprt); if (isPreview == true) { //pv = new FPreviewAR(); //****Took these out of If Block, so that, ViewReport() is called, and reportType is available for Save file name //pv.ViewReport(rprt); //************** Done 6/29/15 pv.ShowDialog(); } else { rprt.Run(); rprt.Document.Print(true, false); } }
public void PrintForecastRemainingNew(int ENGPLSPM) { rprtForecastRemaining r = new rprtForecastRemaining(); FPreviewAR pv = new FPreviewAR(); //if (usePipe == true) // r.SetAsPipeline(); if (ENGPLSPM == 1) //********************Added 9/30/2015 { pv.Title = r.SetAsEngineering(); } if (ENGPLSPM == 3) { pv.Title = r.SetAsPM(); } DataSet ds = CBProjectSummary.GetForecastRemainingNew(ENGPLSPM); r.DataSource = ds; r.DataMember = "Table"; pv.ViewReportWithExcel(r); pv.ShowDialog(); }
public void PrintDrawingLog(int deptID, int projID) { //FPreview pv; ////rprtDrawingLog rprt = new rprtDrawingLog(); //rprtDrawingLog_Alt rprt = new rprtDrawingLog_Alt(); //dsDrawingLog ds; //ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID); ////rprt = new rprtDrawingLog(); //rprt = new rprtDrawingLog_Alt(); //rprt.SetDataSource(ds); //pv = new FPreview(); //pv.ShowReport(rprt); //pv.ShowDialog(); ////rprt.PrintToPrinter(1, false, 0, 0); FPreviewAR pv; rprtDrawingLog1 rprt = new rprtDrawingLog1(); dsDrawingLog ds; ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID); rprt.SetDrawingLogAsCustomerReport(); rprt.DataSource = ds; rprt.DataMember = "DrawingList"; pv = new FPreviewAR(); pv.Title = "DRAWING/SPEC LOG"; //********************************12/01 pv.ViewReport(rprt); pv.ShowDialog(); }
public static void ShowTestIssuance(DataSet ds) { rprtIssuance1 r = new rprtIssuance1(); FPreviewAR pvar = new FPreviewAR(); r.DataSource = ds; r.DataMember = "Table"; pvar.ViewReport(r); pvar.ShowDialog(); }
public void PreviewBudgetDetails(int budID, string wbs) { FPreviewAR pv = new FPreviewAR(); rprtBudgetDetail rprt = new rprtBudgetDetail(); DataSet ds; CBBudget bud = new CBBudget(); CBProject proj = new CBProject(); CBCustomer cust = new CBCustomer(); CBLocation loc = new CBLocation(); CBState state = new CBState(); bud.Load(budID); proj.Load(bud.ProjectID); cust.Load(proj.CustomerID); loc.Load(proj.LocationID); state.Load(loc.StateID); ds = CBBudget.GetBudgetDetailsForReport(budID, wbs); if (proj.BusinessUnit() == 1) { rprt.MainReportTitle = "Staffing Estimate Loaded Details"; } if (proj.BusinessUnit() == 2) { rprt.MainReportTitle = "Engineering Estimate Loaded Details"; } if (proj.BusinessUnit() == 3) { rprt.MainReportTitle = "Pipeline Services Estimate Loaded Details"; } if (proj.BusinessUnit() == 4) { rprt.MainReportTitle = "Program Management Estimate Loaded Details"; } if (proj.BusinessUnit() == 5) { rprt.MainReportTitle = "EPC Estimate Loaded Details"; } pv.projNumber = proj.Number; //***************************Added 6/25/15 // MessageBox.Show(pv.projNumber); rprt.SetTitles(cust.Name + " / " + loc.City + "," + state.Abbrev, proj.Description, proj.Number, bud.GetNumber(), wbs); rprt.DataSource = ds; rprt.DataMember = "Table"; pv.Title = rprt.MainReportTitle; //************************Added 10/1/2015 pv.ViewReport(rprt); pv.ShowDialog(); }
public void PreviewSummary(SummaryInfo si, RowsInfo ri) { rprtCostSummary rprt = new rprtCostSummary(); FPreviewAR pv = new FPreviewAR(); rprt.SummaryInformation = si; rprt.RowsInfo = ri; rprt.Run(); pv.projNumber = si.project; //*******************************Added 9/30/2015 pv.ViewReport(rprt); pv.ShowDialog(); }
public void PrintVariance(DataSet ds, string title) { rprtJobVariance1 r = new rprtJobVariance1(); r.Title.Text = title; FPreviewAR pv = new FPreviewAR(); r.DataSource = ds; r.DataMember = "Table"; pv.ViewReport(r); pv.Title = title; //*****************************Added 10/1/2015 pv.ShowDialog(); }
public void PreviewPCNLog(string client, string project, string hgaNum, string clientNum, string pm, DataSet pcnLog) { FPreviewAR pv = new FPreviewAR(); rprtPCNLog rprt = new rprtPCNLog(); rprt.SetHeaderInfo(client, project, hgaNum, clientNum, pm); rprt.DataSource = pcnLog; rprt.DataMember = "Table"; pv.projNumber = hgaNum; //******************************Added 6/29/15 pv.ViewReport(rprt); pv.ShowDialog(); }
public void PreviewPCI(int pciID) { FPreviewAR pv = new FPreviewAR(); rprtPCIInformation rprt = new rprtPCIInformation(); CBPCIInfo info = new CBPCIInfo(); info.Load(pciID); rprt.SetInformation(info); pv.ViewReport(rprt); pv.ShowDialog(); }
public void PrintDrawingLog(int deptID, int projID) { FPreviewAR pv; rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2(); dsDrawingLog ds; ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID); rprt.DataSource = ds; rprt.DataMember = "DrawingList"; pv = new FPreviewAR(); pv.ViewReport(rprt); pv.ShowDialog(); }
public void PrintForecastRemainingBHam() { rprtForecastRemaining r = new rprtForecastRemaining(); FPreviewAR pv = new FPreviewAR(); pv.Title = r.SetAsBHam(); DataSet ds = CBProjectSummary.GetForecastRemainingBHam(); r.DataSource = ds; r.DataMember = "Table"; pv.ViewReportWithExcel(r); pv.ShowDialog(); }
public void PrintJobStat(int deptID, int projID) { FPreviewAR pv; rprtJobStat1 rprt = new rprtJobStat1(); DataSet ds; ds = CBDrawingLog.GetJobStatForRprt(deptID, projID); rprt.DataSource = ds; rprt.DataMember = "Table"; pv = new FPreviewAR(); pv.ViewReport(rprt); pv.ShowDialog(); }
public void TestPM() { rprtPMReport1 r = new rprtPMReport1(); FPreviewAR pv = new FPreviewAR(); CBEmployee e = new CBEmployee(); e.Load(25); DataSet ds = CBProjectSummary.GetPMReport(25); r.ProjectManager = e.Name; r.DataSource = ds; r.DataMember = "Table"; pv.ViewReport(r); pv.ShowDialog(); }
public void LoadReportsForPDF_ForAllPCN(string projNumber, int projID) { FPreviewAR pv = new FPreviewAR(); string pcnNumber; int pcnID; int prntCnt; int indx = 0; int copy = 1; object o; // this.Cursor = Cursors.WaitCursor; GrapeCity.ActiveReports.SectionReport rprtMain = new GrapeCity.ActiveReports.SectionReport(); GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport pdfOut; lblStatus.Visible = true; lblStatus.Text = "Saving"; //*******************Edited 12/10 Application.DoEvents(); GrapeCity.ActiveReports.Document.Section.PagesCollection pagesPCN; for (int j = 0; j < clstProjects.CheckedItems.Count; j++) { o = clstProjects.CheckedItems[j]; pcnNumber = o.ToString().Substring(0, 2); pcnID = GetPCNID_From_PCNNumber(pcnNumber, projID); indx++; lblStatus.Text = "Saving - " + pcnNumber; Application.DoEvents(); pagesPCN = CreatePagesPCN(projNumber, pcnNumber, pcnID); for (int k = 0; k < pagesPCN.Count; k++) { rprtMain.Document.Pages.Add(pagesPCN[k]); } } this.Close(); pv.projNumber = projNumber; pv.ViewReportBatch(rprtMain); pv.ShowDialog(); }
public void PrintForecastRemaining(bool usePipe) { rprtForecastRemaining r = new rprtForecastRemaining(); FPreviewAR pv = new FPreviewAR(); if (usePipe == true) { r.SetAsPipeline(); } DataSet ds = CBProjectSummary.GetForecastRemaining(usePipe); r.DataSource = ds; r.DataMember = "Table"; pv.Title = "Pipeline Forecast Remaining Report"; //********************Added 9/30/2015 pv.ViewReportWithExcel(r); pv.ShowDialog(); }
public void PreviewPCN(int pcnID) { FPreviewAR pv = new FPreviewAR(); rprtPCNMain rprt = new rprtPCNMain(); DataSet ds; CBBudgetPCN pcn = new CBBudgetPCN(); ds = CBBudgetPCN.GetBudgetPCNInfoForReport(pcnID); pcn.Load(pcnID); rprt.SetInformation(pcn); rprt.DataSource = ds; rprt.DataMember = "Table"; pv.Title = pcn.PCNTitle; //************************Added 10/1/2015 //rprt.Run(); pv.ViewReport(rprt); pv.ShowDialog(); }
public void PreviewAllBudget_New(int budID, string projNumber, string wbs) //*********************************Added 6/29 { FPreviewAR pv = new FPreviewAR(); GrapeCity.ActiveReports.SectionReport rprtMain = new GrapeCity.ActiveReports.SectionReport(); GrapeCity.ActiveReports.Document.Section.PagesCollection pagesBudSum; GrapeCity.ActiveReports.Document.Section.PagesCollection pagesBudDtl; GrapeCity.ActiveReports.Document.Section.PagesCollection pagesJobStat; GrapeCity.ActiveReports.Document.Section.PagesCollection pagesBudEntry; pagesBudSum = CreatePagesBudgetSummary(budID, wbs); for (int i = 0; i < pagesBudSum.Count; i++) { rprtMain.Document.Pages.Add(pagesBudSum[i]); } pagesBudDtl = CreatePagesBudgetDetails(budID, wbs); for (int i = 0; i < pagesBudDtl.Count; i++) { rprtMain.Document.Pages.Add(pagesBudDtl[i]); } pagesJobStat = CreatePagesJobStat(budID, wbs); for (int i = 0; i < pagesJobStat.Count; i++) { rprtMain.Document.Pages.Add(pagesJobStat[i]); } pagesBudEntry = CreatePagesBudgetFormEntry(budID, wbs); for (int i = 0; i < pagesBudEntry.Count; i++) { rprtMain.Document.Pages.Add(pagesBudEntry[i]); } pv.projNumber = projNumber; //************************Added 6/29 pv.ViewReportNoRun(rprtMain); pv.ShowDialog(); }
public static void PrintTransmittal(int transmittalID) { rprtTransmittal1 rprt = new rprtTransmittal1(); DataSet ds; FPreviewAR pv = new FPreviewAR(); CBProject proj = new CBProject(); //***********************************Added 9/30/2015 CBTransmittal t = new CBTransmittal(); t.Load(transmittalID); proj.Load(t.ProjectID); pv.projNumber = proj.Number; ds = CBTransmittal.GetTransmittalForReport(transmittalID); rprt.DataSource = ds; rprt.DataMember = "Table"; pv.ViewReport(rprt); pv.ShowDialog(); }
public static void PrintTransmittalRelease(int releaseID) { rprtTransmittalRelease1 rprt = new rprtTransmittalRelease1(); DataSet ds; FPreviewAR pv = new FPreviewAR(); CBProject proj = new CBProject(); //***********************************Added 9/30/2015 CBTransmittalRelease r = new CBTransmittalRelease(); r.Load(releaseID); proj.Load(r.ProjectID); pv.projNumber = proj.Number; ds = CBTransmittalRelease.GetTransmittalReleaseForReport(releaseID); rprt.DataSource = ds; rprt.DataMember = "Table"; pv.ViewReport(rprt); pv.ShowDialog(); }
public void PreviewPCI_New(string projNumber, int pciID) // *************************** Added 6/25/15 { FPreviewAR pv = new FPreviewAR(); rprtPCIInformation rprt = new rprtPCIInformation(); CBPCIInfo info = new CBPCIInfo(); //CBBudget bud = new CBBudget(); //CBProject proj = new CBProject(); //bud.Load(budID); //proj.Load(bud.ProjectID); info.Load(pciID); rprt.SetInformation(info); pv.projNumber = projNumber; // MessageBox.Show(pv.projNumber); pv.ViewReport(rprt); pv.ShowDialog(); }
public void PreviewBudgetSummary(int budID, string wbs, bool rate) //***********************Added 7/22/2015 { FPreviewAR pv = new FPreviewAR(); rprtBudgetSummary1 rprt = new rprtBudgetSummary1(); DataSet ds; int totalHours; decimal totalHourDollars; decimal totalExpenses; decimal contingency; CBBudget bud = new CBBudget(); CBProject proj = new CBProject(); CBCustomer cust = new CBCustomer(); CBLocation loc = new CBLocation(); CBState state = new CBState(); bud.Load(budID); proj.Load(bud.ProjectID); cust.Load(proj.CustomerID); loc.Load(proj.LocationID); state.Load(loc.StateID); totalHours = CBBudget.GetTotalBudgetHours(budID, wbs); totalHourDollars = CBBudget.GetTotalBudgetHourDollars(budID, wbs); totalExpenses = CBBudget.GetTotalBudgetExpenses(budID); contingency = CBBudget.GetContingencyForBudget(budID); ds = CBBudget.GetBudgetSummaryForReport(budID, wbs); //ds = CBBudget.GetBudgetSummaryForReport(budID, wbs); if (proj.BusinessUnit() == 1) { rprt.MainReportTitle = "Staffing Estimate Loaded Summary"; } if (proj.BusinessUnit() == 2) { rprt.MainReportTitle = "Engineering Estimate Loaded Summary"; } if (proj.BusinessUnit() == 3) { rprt.MainReportTitle = "Pipeline Services Estimate Loaded Summary"; } if (proj.BusinessUnit() == 4) { rprt.MainReportTitle = "Program Management Estimate Loaded Summary"; } if (proj.BusinessUnit() == 5) { rprt.MainReportTitle = "EPC Estimate Loaded Summary"; } rprt.SetTitles(proj.Number, proj.Description, bud.GetNumber(), cust.Name, loc.City + "," + state.Abbrev, wbs); rprt.TotalHours = totalHours; rprt.TotalHourDollars = totalHourDollars; rprt.TotalExpenses = totalExpenses; rprt.Contingency = contingency; rprt.Rate = rate; rprt.DataSource = ds; rprt.DataMember = "Table"; pv.projNumber = proj.Number; // **************************Added 6/29/2015 ************************** if (rate == false) //************************Added 10/1/2015 { pv.Title = rprt.MainReportTitle + "WO Rate"; } else { pv.Title = rprt.MainReportTitle; } pv.ViewReport(rprt); pv.ShowDialog(); }