public ReportAnalysisCardForm(string idRaw, Employee employee) { InitializeComponent(); SqlDataAdapter da = DAO.getInstance().selectReportAnalysisCardGeneral(idRaw, employee.Id); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ReportAnalysisCardGeneral"); ReportDocument doc = new ReportDocument(); SqlDataAdapter da1 = DAO.getInstance().selectReportAnalysisCardGrain(idRaw); da1.Fill(ds, "ReportAnalysisCardGrain"); SqlDataAdapter da2 = DAO.getInstance().selectReportAnalysisCardHarmful(idRaw); da2.Fill(ds, "ReportAnalysisCardHarmful"); SqlDataAdapter da3 = DAO.getInstance().selectReportAnalysisCardWeed(idRaw); da3.Fill(ds, "ReportAnalysisCardWeed"); doc.Load("Reports/ReportAnalysisCardWeed.rpt"); doc.Load("Reports/ReportAnalysisCardHarmful.rpt"); doc.Load("Reports/ReportAnalysisCardGrain.rpt"); doc.Load("Reports/ReportAnalysisCardGeneral.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; }
private void ReportForm_Load(object sender, EventArgs e) { if (type == "\'Объем зерна\'") { if (dateS == "" && datePo == "") { if (contractor == "") { SqlDataAdapter da = DAO.getInstance().selectReport("ReportWeight"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ReportWeight"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ReportWeight.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } else { SqlDataAdapter da = DAO.getInstance().selectReportContractor(contractor, subdivision, "ReportWeightWithContractor"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ReportWeightWithContractor"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ReportWeightWithContractor.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } } else { if (contractor == "") { SqlDataAdapter da = DAO.getInstance().selectReportWithPeriod(dateS, datePo, "ReportWeightWithPeriod"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ReportWeightWithPeriod"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ReportWeightWithPeriod.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } else { SqlDataAdapter da = DAO.getInstance().selectReportContractorWithPeriod(contractor, subdivision, dateS, datePo, "ReportWeightWithContractorPeriod"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ReportWeightWithContractorPeriod"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ReportWeightWithContractorPeriod.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } } } else if (type == "\'Проведенная обработка\'") { if (dateS == "" && datePo == "") { if (contractor == "") { SqlDataAdapter da = DAO.getInstance().selectReport("ProcessReport"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ProcessReport"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ReportProcess.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } else { SqlDataAdapter da = DAO.getInstance().selectReportContractor(contractor, subdivision, "ProcessReportContractor"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ProcessReportContractor"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ProcessReportContractor.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } } else { if (contractor == "") { SqlDataAdapter da = DAO.getInstance().selectReportWithPeriod(dateS, datePo, "ProcessReportWithPeriod"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ProcessReportWithPeriod"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ProcessReportWithPeriod.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } else { SqlDataAdapter da = DAO.getInstance().selectReportContractorWithPeriod(contractor, subdivision, dateS, datePo, "ProcessReportContractorWithPeriod"); AccountOfGrainDataSet ds = new AccountOfGrainDataSet(); da.Fill(ds, "ProcessReportContractorWithPeriod"); ReportDocument doc = new ReportDocument(); doc.Load("Reports/ProcessReportContractorWithPeriod.rpt"); doc.SetDataSource(ds); crystalReportViewer1.ReportSource = doc; } } } }