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