private void DoIt() { string rt = Check(); if (rt != "OK") { MyMainForm.ShowWarning(rt); return; } ROps2aTableAdapter ad = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; if (ad == null) { return; } ad.FillBy_pvn_10(MyData.DataSetKlonsRep.ROps2a, startDate, endDate); SaveParams(); ReportViewerData rd = new ReportViewerData(); rd.FileName = "Report_PVN_kops"; rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a; rd.AddReportParameters( new string[] { "RSD", MyData.Params.RSD, "RED", MyData.Params.RED, "CompanyName", MyData.Params.CompName }); MyMainForm.ShowReport(rd); }
public decimal GetBal0ForDate(string pac, DateTime pdt) { ROps2aTableAdapter ad2a = KlonsData.St.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; ad2a.FillBy_apgr_01(MyDataSet.ROps2a, pdt, pdt, pac); PrepareRops2a(); var rv = MyDataSet.ROps2a[0]; return(rv.SDb - rv.SCr); }
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; } ROps2aTableAdapter ad = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; if (ad == null) { return; } if (cbCharCount.Text == "*") { ad.FillBy_apgr_np_11(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac); } else { ad.FillBy_apgr_np_12(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, int.Parse(cbCharCount.Text)); } SaveParams(); MyData.ReportHelper.PrepareRops2a(); ReportViewerData rd = new ReportViewerData(); rd.FileName = "Report_Apgr_NP"; rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a; rd.AddReportParameters( new string[] { "RSD", MyData.Params.RSD, "RED", MyData.Params.RED, "RACX", MyData.Params.RACX, "RACNM", MyData.Params.RACNM, "CompanyName", MyData.Params.CompNameX }); MyMainForm.ShowReport(rd); }
private void DoIt() { string rt = Check(); if (rt != "OK") { MyMainForm.ShowWarning(rt); return; } ROps2aTableAdapter ad2a = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; ROps3aTableAdapter ad3a = MyData.GetKlonsRepAdapter("ROps3a") as ROps3aTableAdapter; if (ad2a == null) { return; } if (ad3a == null) { return; } ad2a.FillBy_apgr_dz_12(MyData.DataSetKlonsRep.ROps2a, startDate, endDate); ad3a.FillBy_apgr_dz_11(MyData.DataSetKlonsRep.ROps3a, startDate, endDate); SaveParams(); MyData.ReportHelper.PrepareRops2a(); ReportViewerData rd = new ReportViewerData(); rd.FileName = "Report_Apgr_DZ_1"; rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a; rd.Sources["DataSet2"] = MyData.DataSetKlonsRep.ROps3a; rd.AddReportParameters( new string[] { "RSD", MyData.Params.RSD, "RED", MyData.Params.RED, "CompanyName", MyData.Params.CompNameX }); 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(bool doreport = true) { string rt = Check(); if (rt != "OK") { MyMainForm.ShowWarning(rt); return; } SaveParams(); ROps2aTableAdapter ad = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; if (ad == null) { return; } try { if (cbCharCount.Text == "*") { ad.FillBy_apgr_11(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac); } else { ad.FillBy_apgr_21(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, int.Parse(cbCharCount.Text)); } } catch (ConstraintException e) { Exception e1 = ExceptionHelper.TranslateException(e, MyData.DataSetKlonsRep.ROps2a); Form_Error.ShowException(MyMainForm, e1); return; } MyData.ReportHelper.PrepareRops2a(); if (doreport) { ReportViewerData rd = new ReportViewerData(); rd.FileName = "Report_Apgr_Bil"; rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a; rd.AddReportParameters( new string[] { "RSD", startDateStr, "RED", endDateStr, "RACX", cbAC.Text, "RACNM", lbACName.Text, "CompanyName", MyData.Params.CompNameX, "RCURRENCY", "" }); MyMainForm.ShowReport(rd); } else { var fm = MyMainForm.ShowFormDialog(typeof(Form_Apgr1)) as Form_Apgr1; if (fm == null) { return; } fm.Show(); fm.LoadParams(); } }
private void DoIt() { string rt = Check(); if (rt != "OK") { MyMainForm.ShowWarning(rt); return; } SaveParams(); ROps2aTableAdapter ad2a = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter; TRepA1TableAdapter ada1 = MyData.GetKlonsRepAdapter("TRepA1") as TRepA1TableAdapter; ReportViewerData rd = new ReportViewerData(); int selectedreport = lbCm.SelectedIndex; string s = string.Format("Konts: [{0}]", cbAC.Text); if (!string.IsNullOrEmpty(lbACName.Text)) { s = string.Format("{0} {1}", s, lbACName.Text); } if (!string.IsNullOrEmpty(cbClid.Text)) { s = string.Format("{0}\nPersona: [{1}]", s, cbClid.Text); } if (!string.IsNullOrEmpty(lbClName.Text)) { s = string.Format("{0} {1}", s, lbClName.Text); } string rtitle = ""; switch (selectedreport) { case 0: ad2a.FillBy_pers_12(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, clid); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a; MyData.ReportHelper.PrepareRops2a(); rd.FileName = "Report_Pers_1"; break; case 1: ad2a.FillBy_pers_11(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, clid); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a; MyData.ReportHelper.PrepareRops2a(); rd.FileName = "Report_Pers_2"; break; case 2: ada1.FillBy_pers_14(MyData.DataSetKlonsRep.TRepA1, startDate, endDate, ac, clid); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepA1; rd.FileName = "Report_Pers_4"; rtitle = "Rēķinu saraksts"; break; case 3: ada1.FillBy_pers_15(MyData.DataSetKlonsRep.TRepA1, startDate, endDate, ac, clid); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepA1; rd.FileName = "Report_Pers_4"; rtitle = "Rēķinu saraksts"; break; case 4: ada1.FillBy_pers_13(MyData.DataSetKlonsRep.TRepA1, startDate, endDate, ac, clid); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepA1; rd.FileName = "Report_Pers_4"; rtitle = "Neapmaksātie rēķini"; break; case 5: ada1.FillBy_pers_16(MyData.DataSetKlonsRep.TRepA1, startDate, endDate, ac, clid); rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepA1; rd.FileName = "Report_Pers_4"; rtitle = "Neapmaksātie rēķini"; break; } switch (selectedreport) { case 0: case 1: rd.AddReportParameters( new string[] { "RSD", startDateStr, "RED", endDateStr, "RACX", cbAC.Text, "RACNM", s, "CompanyName", MyData.Params.CompNameX }); break; case 2: case 3: case 4: case 5: rd.AddReportParameters( new string[] { "RSD", startDateStr, "RED", endDateStr, "RTITLE", rtitle, "RACNM", s, "CompanyName", MyData.Params.CompNameX }); break; } MyMainForm.ShowReport(rd); }