private void DoIt() { string rt = Check(); if (rt != "OK") { MyMainForm.ShowWarning(rt); return; } SaveParams(); ROps1aTableAdapter ad1a = MyData.GetKlonsRepAdapter("ROps1a") as ROps1aTableAdapter; ROps2aTableAdapter ad2a = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; ROps3aTableAdapter ad3a = MyData.GetKlonsRepAdapter("ROps3a") as ROps3aTableAdapter; ReportViewerData rd = new ReportViewerData(); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps1a; rd.Sources["DataSet_2a"] = MyData.DataSetKlonsRep.ROps2a; rd.Sources["DataSet_3a"] = MyData.DataSetKlonsRep.ROps3a; ad1a.FillBy_koresp_11_clid2(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac, clid); ad2a.FillBy_apgr_01_clid2(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, clid); ad3a.FillBy_koresp_01_clid2(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac, clid); MyData.ReportHelper.PrepareRops1a(); MyData.ReportHelper.PrepareRops2a(); MyData.ReportHelper.PrepareRops2aRAC(); rd.AddReportParameters( new string[] { "RSD", startDateStr, "RED", endDateStr, "RAC", cbAC.Text, "RACNM", lbACName.Text, "CompanyName", MyData.Params.CompNameX, "RPER", MyData.Params.RPER, "RPERNM", lbClName.Text, "AVNR", tbNr.Text, "PAC", null, "PCLID", null }); rd.FileName = "Report_AvNor_1"; MyMainForm.ShowReport(rd); }
private void DoIt() { string rt = Check(); if (rt != "OK") { MyMainForm.ShowWarning(rt); return; } SaveParams(); int repid = lbCm.SelectedIndex; if (cbClid.Text == "*") { cbClid.Text = ""; } if (cbClid.Text != "") { repid += 6; } ROps1aTableAdapter ad1a = MyData.GetKlonsRepAdapter("ROps1a") as ROps1aTableAdapter; ROps2aTableAdapter ad2a = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; ROps3aTableAdapter ad3a = MyData.GetKlonsRepAdapter("ROps3a") as ROps3aTableAdapter; ReportViewerData rd = new ReportViewerData(); if (repid != 5) { rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps1a; } rd.Sources["DataSet_2a"] = MyData.DataSetKlonsRep.ROps2a; rd.Sources["DataSet_3a"] = MyData.DataSetKlonsRep.ROps3a; ReportViewerData rdsub = null; switch (repid) { case 0: case 1: case 2: ad1a.FillBy_koresp_11(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac); ad2a.FillBy_apgr_01(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac); ad3a.FillBy_koresp_01(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac); break; case 3: ad1a.FillBy_koresp_11(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac); ad2a.FillBy_apgr_02(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac); ad3a.FillBy_koresp_02(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac); break; case 5: ad2a.FillBy_apgr_01(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac); ad3a.FillBy_koresp_01(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac); break; case 6: case 7: case 8: ad1a.FillBy_koresp_11_clid(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac, clid); ad2a.FillBy_apgr_01_clid(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, clid); ad3a.FillBy_koresp_01_clid(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac, clid); break; case 9: ad1a.FillBy_koresp_11_clid(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac, clid); ad2a.FillBy_apgr_02_clid(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, clid); ad3a.FillBy_koresp_02_clid(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac, clid); break; case 4: case 10: ad1a.FillBy_koresp_11(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac); ad2a.FillBy_apgr_02_clid(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, null); ad3a.FillBy_koresp_02_clid(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac, null); break; } MyData.ReportHelper.PrepareRops1a(); MyData.ReportHelper.PrepareRops2a(); MyData.ReportHelper.PrepareRops2aRAC(); rd.AddReportParameters( new string[] { "RSD", startDateStr, "RED", endDateStr, "RAC", cbAC.Text, "RACNM", lbACName.Text, "CompanyName", MyData.Params.CompNameX, "RPER", MyData.Params.RPER, "RPERNM", lbClName.Text, "PAC", null, "PCLID", null, "RCURRENCY", "" }); switch (lbCm.SelectedIndex) { case 0: rd.FileName = "Report_Koresp_1"; break; case 1: rd.FileName = "Report_Koresp_2"; break; case 2: rd.FileName = "Report_Koresp_1_full"; break; case 5: rd.FileName = "Report_Koresp_3"; break; case 3: rdsub = rd; rdsub.FileName = "Report_Koresp_1"; rdsub.AddSubreportLink("DataSet1", "PAC", "Ac1"); rdsub.AddSubreportLink("DataSet_2a", "PAC", "AC"); rdsub.AddSubreportLink("DataSet_3a", "PAC", "Ac1"); rd = new ReportViewerData(); rd.Sources["DataSet_2a"] = MyData.DataSetKlonsRep.ROps2a; rd.FileName = "Report_Koresp_1_byac"; rd.SubReports[rdsub.FileName] = rdsub; rd.AddReportParameters( new string[] { "RSD", startDateStr, "RED", endDateStr, "RAC", cbAC.Text, "RACNM", lbACName.Text, "CompanyName", MyData.Params.CompNameX, "RPER", MyData.Params.RPER, "RPERNM", lbClName.Text, "RCURRENCY", "" }); break; case 4: rdsub = rd; rdsub.FileName = "Report_Koresp_1"; rdsub.AddSubreportLink("DataSet1", "PAC", "Ac1", "PCLID", "Clid"); rdsub.AddSubreportLink("DataSet_2a", "PAC", "AC", "PCLID", "Clid"); rdsub.AddSubreportLink("DataSet_3a", "PAC", "Ac1", "PCLID", "Clid"); rd = new ReportViewerData(); rd.Sources["DataSet_2a"] = MyData.DataSetKlonsRep.ROps2a; rd.FileName = "Report_Koresp_1_byacnadcl"; rd.SubReports[rdsub.FileName] = rdsub; rd.AddReportParameters( new string[] { "RSD", startDateStr, "RED", endDateStr, "RAC", cbAC.Text, "RACNM", lbACName.Text, "CompanyName", MyData.Params.CompNameX, "RPER", "", "RPERNM", "", "RCURRENCY", "" }); break; } MyMainForm.ShowReport(rd); }
private void DoIt() { string rt = Check(); if (rt != "OK") { MyMainForm.ShowWarning(rt); return; } SaveParams(); ROps1aTableAdapter ad1a = MyData.GetKlonsRepAdapter("ROps1a") as ROps1aTableAdapter; ReportViewerData rd = new ReportViewerData(); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps1a; int selectedreport = lbCm.SelectedIndex; if (selectedreport == -1) { return; } switch (selectedreport) { case 0: ad1a.FillBy_kg_11(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac); MyData.ReportHelper.PrepareRops1aForKO(); rd.FileName = "Report_KasesGr_1"; break; case 1: ad1a.FillBy_kg_11(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac); MyData.ReportHelper.PrepareRops1aForKO(); rd.FileName = "Report_KasesGr_2"; break; case 2: ad1a.FillBy_kieo_21(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac); MyData.ReportHelper.PrepareRops1aForKO(); rd.FileName = "Report_KIEO_1"; break; case 3: ad1a.FillBy_kizo_21(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac); MyData.ReportHelper.PrepareRops1aForKO(); rd.FileName = "Report_KIZO_1"; break; default: return; } decimal bal0; switch (selectedreport) { case 0: bal0 = MyData.ReportHelper.GetBal0ForDate(ac, startDate); rd.AddReportParameters( new string[] { "CompanyName", MyData.Params.CompNameX, "RPAGENR", (nr - 1).ToString(), "RBAL0", bal0.ToString() }); break; case 1: bal0 = MyData.ReportHelper.GetBal0ForDate(ac, startDate); string speriod = Utils.DateToString(startDate) + " - " + Utils.DateToString(endDate); rd.AddReportParameters( new string[] { "CompanyName", MyData.Params.CompNameX, "RPAGENR", (nr - 1).ToString(), "RBAL0", bal0.ToString(), "RPERIOD", speriod }); break; case 2: case 3: rd.AddReportParameters( new string[] { "RCOMPNAME", MyData.Params.CompName, "RREGNR", MyData.Params.CompRegNr, "RPVNREGNR", MyData.Params.CompPhone }); break; } MyMainForm.ShowReport(rd); }
private void DoReportDoks1() { DateTime?dt1, dt2; dt1 = Utils.StringToDate(tbDate1.Text); dt2 = Utils.StringToDate(tbDate2.Text); string sac11, sac12, sac13, sac14, sac15; string sac21, sac22, sac23, sac24, sac25; string sclid = ZN(cbClid.Text); string stext = ZN(tbText.Text); string sdocgr = ZN(cbDocGr.Text); sac11 = ZN(cbAC11.Text); sac12 = ZN(cbAC12.Text); sac13 = ZN(cbAC13.Text); sac14 = ZN(cbAC14.Text); sac15 = ZN(cbAC15.Text); sac21 = ZN(cbAC21.Text); sac22 = ZN(cbAC22.Text); sac23 = ZN(cbAC23.Text); sac24 = ZN(cbAC24.Text); sac25 = ZN(cbAC25.Text); string s = ""; if (dt1.HasValue) { s = Utils.DateToString(dt1.Value); } s += " - "; if (dt2.HasValue) { s += Utils.DateToString(dt2.Value); } string paramstr = string.Format( "Datums:[{0}], persona:[{2}]," + " dokumentu grupa:[{14}]" + " debets:[{3},{4},{5},{6},{7}] {13}" + " kredīts:[{8},{9},{10},{11},{12}]", s, "", cbClid.Text, cbAC11.Text, cbAC12.Text, cbAC13.Text, cbAC14.Text, cbAC15.Text, cbAC21.Text, cbAC22.Text, cbAC23.Text, cbAC24.Text, cbAC25.Text, cmAndOr.Text, cbDocGr.Text); bool b1 = (sac11 == null && sac12 == null && sac13 == null && sac14 == null && sac15 == null) || (sac21 == null && sac22 == null && sac23 == null && sac24 == null && sac25 == null); string pandor = (cmAndOr.Text == "un" || b1) ? "AND" : "OR"; ROps1aTableAdapter adap = MyData.GetKlonsRepAdapter("ROps1a") as ROps1aTableAdapter; adap.FillBy_doks_11(MyData.DataSetKlonsRep.ROps1a, dt1, dt2, stext, sclid, sac11, sac12, sac13, sac14, sac15, sac21, sac22, sac23, sac24, sac25, sdocgr, pandor); ReportViewerData rd = new ReportViewerData(); rd.FileName = "Report_DokSar_1"; rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps1a; rd.AddReportParameters( new string[] { "RSD", MyData.Params.RSD, "RED", MyData.Params.RED, "RACX", "", "RACNM", paramstr, "CompanyName", MyData.Params.CompNameX }); MyMainForm.ShowReport(rd); }