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