private void PrintSelectedProjects(string printer) { string proj; int prntCnt; int indx = 0; int copy = 1; prntCnt = clstProjects.CheckedItems.Count; lblStatus.Visible = true; lblStatus.Text = "Printing"; copy = Convert.ToInt32(numPrint.Value); progressBar1.Minimum = 0; progressBar1.Maximum = copy; progressBar1.Value = 0; Application.DoEvents(); object o; for (int i = 0; i < copy; i++) { for (int j = clstProjects.CheckedItems.Count; j > 0; j--) { o = clstProjects.CheckedItems[j - 1]; proj = o.ToString(); indx++; lblStatus.Text = "Printing - " + proj; progressBar1.Value = i; Application.DoEvents(); LoadReportforBatchPrint(proj, FCRMain.GetRprtCase(proj), printer, 1); } // roll up forecast for (int j = chkRollups.CheckedItems.Count; j > 0; j--) { o = chkRollups.CheckedItems[j - 1]; proj = o.ToString(); indx++; lblStatus.Text = "Printing - " + proj; Application.DoEvents(); LoadReportRollupforBatchPrint(proj, FCRMain.GetRprtCase(proj), printer, 1); } } this.Close(); }
private void LoadReportsForPDF(string pdfLoc) { string proj; this.Cursor = Cursors.WaitCursor; GrapeCity.ActiveReports.SectionReport rprtMain = new GrapeCity.ActiveReports.SectionReport(); GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport pdfOut; lblStatus.Text = "Saving - "; Application.DoEvents(); GrapeCity.ActiveReports.Document.Section.PagesCollection pagesForecast; SqlDataReader dr; dr = GetListbyBillType(BillID); while (dr.Read()) { proj = dr["number"].ToString(); lblStatus.Text = "Saving - " + proj; Application.DoEvents(); pagesForecast = CreatePagesForecast(proj, FCRMain.GetRprtCase(proj)); for (int k = 0; k < pagesForecast.Count; k++) { rprtMain.Document.Pages.Add(pagesForecast[k]); } } pdfOut = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport(); pdfOut.Export(rprtMain.Document, pdfLoc); this.Cursor = Cursors.Default; MessageBox.Show("Reports created"); this.Close(); }
private void PrintSelectedProjects(string printer, int billType) { string proj; // MessageBox.Show(printer + "selected"); SqlDataReader dr; lblStatus.Text = "Printing - "; Application.DoEvents(); dr = GetListbyBillType(billType); while (dr.Read()) { proj = dr["number"].ToString(); lblStatus.Text = "Printing - " + proj; Application.DoEvents(); LoadReportforBatchPrint(proj, FCRMain.GetRprtCase(proj), printer, 1); } this.Close(); }
private GrapeCity.ActiveReports.Document.Section.PagesCollection CreatePagesForecastForRollup(string project) { string currDate; this.Cursor = Cursors.WaitCursor; currDate = DateTime.Now.ToShortDateString(); DSForecastRprt rprtDs; CRolllups ru = new CRolllups(); rprtDs = ru.LoadReportForProjectRollup(project, FCRMain.GetRprtCase(project)); rprtCostReport1 rprt = new rprtCostReport1(); rprt.CutoffDate = currDate; rprt.IsRollup = true; rprt.DataSource = rprtDs; rprt.DataMember = "EngrInfo"; rprt.Run(false); return(rprt.Document.Pages); }
private void bttUpdate_Click(object sender, EventArgs e) { RevSol.RSConnection cnn; SqlCommand cmd; SqlParameter prm; int forecastID; int specGrp = 0; CBProject proj = new CBProject(); proj.Load(msCurrProj); cnn = new RevSol.RSConnection("CR"); cmd = new SqlCommand("spForecastUpdate_Insert", cnn.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; prm = cmd.Parameters.Add("@ForecastID", SqlDbType.Int); prm.Direction = ParameterDirection.Output; prm = cmd.Parameters.Add("@Project", SqlDbType.VarChar, 50); prm.Value = msCurrProj; cmd.ExecuteNonQuery(); forecastID = Convert.ToInt32(cmd.Parameters["@ForecastID"].Value); specGrp = 0; if (proj.UseAllGroups() == true) { specGrp = 0; } string acct; decimal hrs, amnt; foreach (DataRow dr in mdsForecast.Tables["Forecast"].Rows) { acct = dr["AcctGroup"].ToString(); hrs = Convert.ToDecimal(dr["FTCHrs"]); amnt = Convert.ToDecimal(dr["FTCRate"]); cmd = new SqlCommand("spForecastToComplete_Insert2_Vision", cnn.GetConnection()); cmd.CommandType = CommandType.StoredProcedure; prm = cmd.Parameters.Add("@ForecastID", SqlDbType.Int); prm.Value = forecastID; prm = cmd.Parameters.Add("@AccountGroup", SqlDbType.VarChar, 50); prm.Value = acct.Replace("E", ""); prm = cmd.Parameters.Add("@ForecastHrs", SqlDbType.Money); prm.Value = hrs; prm = cmd.Parameters.Add("@ForecastRate", SqlDbType.Money); prm.Value = amnt; prm = cmd.Parameters.Add("@SpecialGroup", SqlDbType.Int); prm.Value = specGrp; cmd.ExecuteNonQuery(); } cnn.CloseConnection(); LoadCurrentGroups(); bttUpdate.Enabled = false; bttSetForecast.Enabled = false; LoadReportForProject(FCRMain.GetRprtCase(msCurrProj)); }
private void LoadReportsForPDF(string pdfLoc) { string proj; 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; prntCnt = clstProjects.CheckedItems.Count; lblStatus.Visible = true; // lblStatus.Text = "Printing"; lblStatus.Text = "Saving"; //*******************Edited 12/10 copy = Convert.ToInt32(numPrint.Value); Application.DoEvents(); GrapeCity.ActiveReports.Document.Section.PagesCollection pagesForecast; for (int j = clstProjects.CheckedItems.Count; j > 0; j--) { o = clstProjects.CheckedItems[j - 1]; proj = o.ToString(); indx++; // lblStatus.Text = "Printing - " + proj; lblStatus.Text = "Saving - " + proj; //*******************Edited 12/10 Application.DoEvents(); pagesForecast = CreatePagesForecast(proj, FCRMain.GetRprtCase(proj)); for (int k = 0; k < pagesForecast.Count; k++) { rprtMain.Document.Pages.Add(pagesForecast[k]); } } for (int j = chkRollups.CheckedItems.Count; j > 0; j--) { o = chkRollups.CheckedItems[j - 1]; proj = o.ToString(); indx++; // lblStatus.Text = "Printing - " + proj; lblStatus.Text = "Saving - " + proj; //*******************Edited 12/10 Application.DoEvents(); pagesForecast = CreatePagesForecastForRollup(proj); for (int k = 0; k < pagesForecast.Count; k++) { rprtMain.Document.Pages.Add(pagesForecast[k]); } } pdfOut = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport(); pdfOut.Export(rprtMain.Document, pdfLoc); this.Cursor = Cursors.Default; MessageBox.Show("Reports created"); }