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;
}
}
}
}
