private void DoCurrCheck()
{
var adap = MyData.GetKlonsRepAdapter("ROps1a") as ROps1aTableAdapter;
adap.FillBy_curcheck_01(MyData.DataSetKlonsRep.ROps1a,
startDate, endDate, ac, null, currency);
ReportViewerData rd = new ReportViewerData();
rd.FileName = "Report_DokSar_1";
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps1a;
string paramstr = string.Format(
"Dokumenti ar valūtas konvertācijas kļūdām \nDatums:[{0}-{1}], konts: [{2}]",
startDateStr, endDateStr, cbAC.Text);
rd.AddReportParameters(
new string[]
{
"RSD", startDateStr,
"RED", endDateStr,
"RACX", "",
"RACNM", paramstr,
"CompanyName", MyData.Params.CompNameX
});
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;
}
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);
}
private void DoIt()
{
string rt = Check();
if (rt != "OK")
{
MyMainForm.ShowWarning(rt);
return;
}
SaveParams();
DataView rv = new DataView(MyData.DataSetKlons.Persons,
"clid = '" + clid + "'", null, DataViewRowState.CurrentRows);
ReportViewerData rd = new ReportViewerData();
rd.FileName = "Report_Rekins_1";
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepOPSd;
rd.Sources["DataSet2"] = rv;
rd.AddReportParameters(
new string[]
{
"RCOMPNAME", MyData.Params.CompName,
"RREGNR", MyData.Params.CompRegNr,
"RPVNREGNR", MyData.Params.CompRegNrPVN,
"RADRESE", MyData.Params.CompAddr + ", " + MyData.Params.CompAddrInd,
"RBANKASKODS", MyData.Params.BankId,
"RBANKA", MyData.Params.BankName,
"RKONTS", MyData.Params.BankAcc,
"RDESCR", tbDescr.Text,
"RSIGNER", tbSigner.Text
});
MyMainForm.ShowReport(rd);
}
private void DoApgr1()
{
var ad = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter;
if (ad == null)
{
return;
}
ad.FillBy_apgr_cur_01_clid(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, null, currency);
MyData.ReportHelper.PrepareRops2a();
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", currency
});
MyMainForm.ShowReport(rd);
}
public void MakeReport3()
{
//var cnm = new[] { "Kat.", "Nol.kat.", "Nod.nol. kat.", "Strv.", "Atrodas" };
var cnm = new[] {
"Kategorija",
"Nolietojuma kategorija",
"Nolietojuma kategorija nodokļa aprēķinam",
"Struktīr-vienība",
"Atrošanās vieta"
};
var cnm2 = new string[5];
for (int i = 0; i < 5; i++)
{
cnm2[i] = GroupFieldsOrderA[i] == -1 ? "" : cnm[GroupFieldsOrderA[i]];
}
ReportViewerData rd = new ReportViewerData();
rd.FileName = "ReportP_Kustiba_3";
rd.Sources["DataSet1"] = ReportMovement.ReportRows;
rd.AddReportParameters(
new string[]
{
"PCompany", MyData.Params.CompNameX,
"PDate1", Utils.DateToString(DT1),
"PDate2", Utils.DateToString(DT2),
"PFilterStr", "Atlases parametri:" + MakeFilterStr(),
"PCNM1", cnm2[0],
"PCNM2", cnm2[1],
"PCNM3", cnm2[2],
"PCNM4", cnm2[3]
});
MyMainForm.ShowReport(rd);
}
private void DoCurrDiff()
{
var ad = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter;
if (ad == null)
{
return;
}
ad.FillBy_currdiff_01(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, null, currency);
if (MyData.DataSetKlonsRep.ROps2a.Count == 0)
{
MyMainForm.ShowWarning("Ar dotajiem parametriem dati netika atrasti");
return;
}
var dr = MyData.DataSetKlonsRep.ROps2a[0];
decimal d1, d2, d3, d4;
d1 = dr.ADb - dr.ACr;
d2 = dr.BDb - dr.BCr;
string s = ac.Substring(0, 1);
if (s != "1" && s != "2")
{
d1 = -d1;
d2 = -d2;
}
d3 = Math.Round(d1 * currrate, 2);
d4 = d3 - d2;
dr.ADb = d1;
dr.ACr = d3;
dr.TDb = d2;
dr.TCr = d4;
MyData.DataSetKlonsRep.ROps2a.AcceptChanges();
ReportViewerData rd = new ReportViewerData();
rd.FileName = "Report_CurrDiff";
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a;
s = string.Format(
"Valūta: {0}\nKonts: {1} {2}\nPersona: {3} {4}",
currency, cbAC.Text, lbACName.Text,
cbClid.Text, lbClName.Text);
rd.AddReportParameters(
new string[]
{
"RSD", startDateStr,
"RED", endDateStr,
"RACX", cbAC.Text,
"RACNM", s,
"CompanyName", MyData.Params.CompNameX,
"RCURRENCY", currency
});
MyMainForm.ShowReport(rd);
}
private void DoIt1(int selectedreport)
{
var ad = MyData.GetKlonsAdapter("BalA21") as BalA21TableAdapter;
var ad2 = MyData.GetKlonsAdapter("BalA22") as BalA22TableAdapter;
if (ad == null)
{
return;
}
try
{
MyData.DataSetKlons.BalA21.Clear();
MyData.DataSetKlons.BalA22.Clear();
ad2.Fill(MyData.DataSetKlons.BalA22);
ad.FillBy_bal_12(MyData.DataSetKlons.BalA21, startDate, endDate, balid);
}
catch (Exception)
{
MyMainForm.ShowWarning("Neizdevās sagatavot atskaiti.");
return;
}
MyData.ReportHelper.FillBalA2FromBalA21(balid);
ReportViewerData rd = new ReportViewerData();
switch (selectedreport)
{
case 0:
rd.FileName = "Report_Bilance_2";
break;
case 1:
rd.FileName = "Report_Bilance_1";
break;
}
DataView dv = new DataView(
MyData.DataSetKlons.BalA22,
"balid = '" + balid + "'",
"dc, nr",
DataViewRowState.CurrentRows);
rd.Sources["DataSet1"] = dv;
rd.AddReportParameters(
new string[]
{
"RSD", MyData.Params.RSD,
"RED", MyData.Params.RED,
"CompanyName", MyData.Params.CompNameX,
"RTITLE", rtitle,
"RAKTIVS", raktivs,
"RPASIVS", rpasivs
});
MyMainForm.ShowReport(rd);
}
private void DoIt2(int selectedreport)
{
var ad = MyData.GetKlonsAdapter("BalA2") as BalA2TableAdapter;
var ad2 = MyData.GetKlonsRepAdapter("SP_REP_BAL_22") as SP_REP_BAL_22TableAdapter;
if (ad == null)
{
return;
}
try
{
MyData.DataSetKlons.BalA2.Clear();
MyData.DataSetKlons.BalA22.Clear();
MyData.DataSetKlonsRep.SP_REP_BAL_22.Clear();
ad.Fill(MyData.DataSetKlons.BalA2);
ad2.Fill(MyData.DataSetKlonsRep.SP_REP_BAL_22, startDate, endDate, balid);
}
catch (Exception)
{
MyMainForm.ShowWarning("Neizdevās sagatavot atskaiti.");
return;
}
List <RepRow_BalMT> reprows = null;
ReportViewerData rd = new ReportViewerData();
switch (selectedreport)
{
case 2:
reprows = PrepareReportMt_apgr(balid, MyData.DataSetKlonsRep.SP_REP_BAL_22);
rd.FileName = "Report_Bilance_31";
break;
case 3:
reprows = PrepareReportMt_atl(balid, MyData.DataSetKlonsRep.SP_REP_BAL_22);
rd.FileName = "Report_Bilance_41";
break;
}
rd.Sources["DataSet1"] = reprows;
rd.AddReportParameters(
new string[]
{
"RSD", MyData.Params.RSD,
"RED", MyData.Params.RED,
"CompanyName", MyData.Params.CompNameX,
"RTITLE", rtitle,
"RAKTIVS", raktivs,
"RPASIVS", rpasivs
});
MyMainForm.ShowReport(rd);
}
private void DoIt(int k)
{
string rt = Check();
if (rt != "OK")
{
MyMainForm.ShowWarning(rt);
return;
}
SaveParams();
var ad = MyData.GetKlonsRepAdapter("ROps1a") as ROps1aTableAdapter;
if (k == 1)
{
ad.FillBy_skaidra_01(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, limit1, "JP");
}
else
{
ad.FillBy_skaidra_02(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, limit2, "FP");
}
ReportViewerData rd = new ReportViewerData();
rd.FileName = "Report_Skaidra_1";
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps1a;
string s1 = "", s = " ";
int i = 13;
if (k == 2)
{
i = startDate.Month;
}
s1 = s.Substring(0, i - 1);
s1 += "X";
s1 += s.Substring(0, 13 - i);
rd.AddReportParameters(
new string[]
{
"PYEAR", startDate.Year.ToString(),
"PMONTH", s1,
"Company", MyData.Params.CompName,
"Addr", MyData.Params.CompAddr,
"AddrInd", MyData.Params.CompAddrInd,
"RegNr", MyData.Params.CompRegNr,
"Manager", MyData.Params.CompMName,
"Phone", MyData.Params.CompPhone
});
MyMainForm.ShowReport(rd);
}
private void MakeReport()
{
ReportViewerData rd = new ReportViewerData();
rd.FileName = "ReportP_NodNolGads_1";
rd.Sources["dsRows"] = bsRows;
rd.AddReportParameters(
new string[]
{
"PCompany", MyData.Params.CompNameX,
"PYear", YearCurrent.ToString()
});
MyMainForm.ShowReport(rd);
}
public void MakeReport()
{
ReportViewerData rd = new ReportViewerData();
rd.FileName = "ReportP_NodNol_1";
rd.Sources["DataSet1"] = ReportMovement.ReportRows;
rd.AddReportParameters(
new string[]
{
"PCompany", MyData.Params.CompNameX,
"PYR", YR.ToString(),
"PDate1", "01.01.\n" + YR,
"PDate2", "31.12.\n" + YR
});
MyMainForm.ShowReport(rd);
}
public void MakeReport2()
{
ReportViewerData rd = new ReportViewerData();
rd.FileName = "ReportP_Kustiba_2";
rd.Sources["DataSet1"] = ReportMovement.ReportRows;
rd.AddReportParameters(
new string[]
{
"PCompany", MyData.Params.CompNameX,
"PDate1", Utils.DateToString(DT1),
"PDate2", Utils.DateToString(DT2),
"PFilterStr", "Atlases parametri:" + MakeFilterStr()
});
MyMainForm.ShowReport(rd);
}
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 MakeReport()
{
var dr = bsCatT.CurrentDataRow as KlonsPDataSet.CATTRow;
ReportViewerData rd = new ReportViewerData();
rd.FileName = "ReportP_NodNolKat_1";
rd.Sources["dsRows"] = bsRows;
rd.AddReportParameters(
new string[]
{
"PCompany", MyData.Params.CompNameX,
"PCatStr", $"[{dr.CODE}] {dr.DESCR}",
"PCatRate", $"{dr.RATE}%"
});
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 DoApgrPers1()
{
var ad = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter;
if (ad == null)
{
return;
}
ad.FillBy_apgr_cur_01_clid(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, clid, currency);
MyData.ReportHelper.PrepareRops2a();
ReportViewerData rd = new ReportViewerData();
rd.FileName = "Report_Pers_1";
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.ROps2a;
string s = string.Format("{1} Konts: [{0}]", cbAC.Text, currency);
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);
}
rd.AddReportParameters(
new string[]
{
"RSD", startDateStr,
"RED", endDateStr,
"RACX", cbAC.Text,
"RACNM", s,
"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()
{
ReportViewerData rd = new ReportViewerData();
rd.FileName = "ReportA_VidIzp_1";
rd.Sources["DataSet1"] = AvPayCalcInfo.ReportRows;
rd.AddReportParameters(
new string[]
{
"CompanyName", MyData.Params.CompNameX,
"RPerson", string.Format("{0} {1}", AvPayCalcInfo.FName, AvPayCalcInfo.LName),
"RPeriod", string.Format("{0}.{1:00}", AvPayCalcInfo.Year, AvPayCalcInfo.Month),
"RRateHour", AvPayCalcInfo.RateHour.ToString("N2"),
"RRateDay", AvPayCalcInfo.RateDay.ToString("N2"),
"RRateCalDay", AvPayCalcInfo.RateCalendarDay.ToString("N2"),
"RRemark", AvPayCalcInfo.UsingMinRate? "Izmantotās minimālās likmes.":""
});
MyMainForm.ShowReport(rd);
}
private void DoIt()
{
string rt = Check();
if (rt != "OK")
{
MyMainForm.ShowWarning(rt);
return;
}
var ad1 = MyData.GetKlonsRepAdapter("TREPPVNZ1") as TREPPVNZ1TableAdapter;
if (ad1 == null)
{
return;
}
string speriod = string.Format("{0}. gada {1}", startDate.Year, Utils.MonthNames[startDate.Month - 1]);
SaveParams();
ReportViewerData rd = new ReportViewerData();
ad1.FillBy_PVNZ1(MyData.DataSetKlonsRep.TREPPVNZ1, startDate, endDate);
rd.FileName = "Report_PVNZ_1";
MyData.ReportHelper.PrepareTRepDarz1();
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TREPPVNZ1;
rd.AddReportParameters(
new string[]
{
"RPERIOD", speriod,
"CompanyName", MyData.Params.CompNameX,
"PRID0", firstPRowNr.ToString(),
"PFirstPageNr", firstPageNr.ToString()
});
MyMainForm.ShowReport(rd);
}
private void DoKoresp1()
{
var ad1a = MyData.GetKlonsRepAdapter("ROps1a") as ROps1aTableAdapter;
var ad2a = MyData.GetKlonsRepAdapter("ROps2a") as ROps2aTableAdapter;
var 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_cur(MyData.DataSetKlonsRep.ROps1a, startDate, endDate, ac, clid, currency);
ad2a.FillBy_apgr_cur_01_clid(MyData.DataSetKlonsRep.ROps2a, startDate, endDate, ac, clid, currency);
ad3a.FillBy_koresp_01_cur(MyData.DataSetKlonsRep.ROps3a, startDate, endDate, ac, clid, currency);
MyData.ReportHelper.PrepareRops1a();
MyData.ReportHelper.PrepareRops2a();
MyData.ReportHelper.PrepareRops2aRAC(cbAC.Text, lbACName.Text, cbClid.Text, lbClName.Text);
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", currency
});
rd.FileName = "Report_Koresp_1";
MyMainForm.ShowReport(rd);
}
private void DoIt()
{
string rt = Check();
if (rt != "OK")
{
MyMainForm.ShowWarning(rt);
return;
}
TRepApAnTableAdapter ad = MyData.GetKlonsRepAdapter("TRepApAn") as TRepApAnTableAdapter;
if (ad == null)
{
return;
}
ad.FillBy_apgr_full_11(MyData.DataSetKlonsRep.TRepApAn, startDate, endDate,
ac1, ac2, ac3, ac4, ac5, cl,
xac1, xac2, xac3, xac4, xac5, xcl);
SaveParams();
ReportViewerData rd = new ReportViewerData();
rd.FileName = "Report_Apgr_Full_11";
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepApAn;
rd.AddReportParameters(
new string[]
{
"RSD", MyData.Params.RSD,
"RED", MyData.Params.RED,
"RACX", "",
"RACNM", param,
"CompanyName", MyData.Params.CompNameX
});
MyMainForm.ShowReport(rd);
}
private void DoIt()
{
ReportViewerData rd = new ReportViewerData();
rd.FileName = "ReportA_SlimibasNauda_1";
rd.Sources["DataSet1"] = SickDayCalcInfo.Rows;
rd.AddReportParameters(
new string[]
{
"CompanyName", MyData.Params.CompNameX,
"RPerson", Person,
"RPeriod", Period,
"RPay", SickDayCalcInfo.TotalRow.SickDayPay.ToString("N2"),
"RPay75", SickDayCalcInfo.TotalRow.SickDayPay75.ToString("N2"),
"RPay80", SickDayCalcInfo.TotalRow.SickDayPay80.ToString("N2"),
"RRateHour", SickDayCalcInfo.AvPayRateHour.ToString("N4"),
"RRateDay", SickDayCalcInfo.AvPayRateDay.ToString("N4"),
"RRateCalDay", SickDayCalcInfo.AvPayRateCalendarDay.ToString("N4"),
"RRemark", ""
});
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();
DataView rv = new DataView(MyData.DataSetKlons.Persons,
"clid = '" + clid + "'", null, DataViewRowState.CurrentRows);
var ad = MyData.KlonsRepTableAdapterManager.TRepOPSTableAdapter;
ad.FillBy_rekins_11(MyData.DataSetKlonsRep.TRepOPS, docid);
bool haspvn = false;
decimal pvn = 0.00M;
decimal total = 0.00M;
List <klonsRepDataSet.TRepOPSRow> PVNRows = new List <klonsRepDataSet.TRepOPSRow>();
foreach (var dr in MyData.DataSetKlonsRep.TRepOPS)
{
total += dr.Summ;
if (MyData.IsPVN(dr.AC15.Nz()) || MyData.IsPVN(dr.AC25.Nz()))
{
haspvn = true;
pvn += dr.Summ;
PVNRows.Add(dr);
break;
}
}
foreach (var dr in PVNRows)
{
MyData.DataSetKlonsRep.TRepOPS.RemoveTRepOPSRow(dr);
}
ReportViewerData rd = new ReportViewerData();
switch (repid)
{
case 1:
rd.FileName = "Report_Rekins_PZ_1";
break;
default:
return;
}
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepOPSd;
rd.Sources["DataSet2"] = rv;
rd.Sources["DataSet3"] = MyData.DataSetKlonsRep.TRepOPS;
rd.AddReportParameters(
new string[]
{
"RCOMPNAME", MyData.Params.CompName,
"RREGNR", MyData.Params.CompRegNr,
"RPVNREGNR", MyData.Params.CompRegNrPVN,
"RADRESE", MyData.Params.CompAddr,
"RBANKASKODS", MyData.Params.BankId,
"RBANKA", MyData.Params.BankName,
"RKONTS", MyData.Params.BankAcc,
"RDESCR", "",
"RPVN", haspvn? pvn.ToString("F2") : "-",
"RAPMAKSAI", total.ToString("F2"),
"RSIGNER", tbSigner.Text,
"RPARVNOSAUKUMS", parv,
"RPARVREGNR", parvregnr,
"RPARVPVNREGNR", parvpvnregnr,
"RPARVJURADRESE", parvjuradrese,
"RPARVTR", tbTLNumurs.Text,
"RPARVVARDS", tbTLVaditajs.Text,
"RDARIJUMS", cbDarVeids.Text,
"RAPMAKSA", cbApmaksa.Text,
"RTERMINS", cbTermins.Text
});
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);
}
private void DoIt()
{
string rt = Check();
if (rt != "OK")
{
MyMainForm.ShowWarning(rt);
return;
}
int selectedReport = lbCM.SelectedIndex;
if (selectedReport == -1)
{
return;
}
TRepDarz1TableAdapter ad1 = MyData.GetKlonsRepAdapter("TRepDarz1") as TRepDarz1TableAdapter;
TRepDarz2TableAdapter ad2 = MyData.GetKlonsRepAdapter("TRepDarz2") as TRepDarz2TableAdapter;
if (ad1 == null)
{
return;
}
if (ad2 == null)
{
return;
}
DateTime startDateOfYear = new DateTime(startDate.Year, 1, 1);
string speriod = string.Format("{0}. gada {1}", startDate.Year, Utils.MonthNames[startDate.Month - 1]);
SaveParams();
ReportViewerData rd = new ReportViewerData();
switch (selectedReport)
{
case 0:
ad1.FillBy_darz_1(MyData.DataSetKlonsRep.TRepDarz1, startDate, endDate);
ad2.FillBy_darz_2(MyData.DataSetKlonsRep.TRepDarz2, startDateOfYear, startDate.AddDays(-1));
rd.FileName = "Report_Darz_1";
break;
case 1:
ad1.FillBy_darz_1(MyData.DataSetKlonsRep.TRepDarz1, startDate, endDate);
ad2.FillBy_darz_2(MyData.DataSetKlonsRep.TRepDarz2, startDateOfYear, startDate.AddDays(-1));
rd.FileName = "Report_Darz_3";
break;
case 2:
ad1.FillBy_darz_3(MyData.DataSetKlonsRep.TRepDarz1, startDate, endDate);
ad2.FillBy_darz_4(MyData.DataSetKlonsRep.TRepDarz2, startDateOfYear, startDate.AddDays(-1));
rd.FileName = "Report_Darz_2";
break;
}
MyData.ReportHelper.PrepareTRepDarz1();
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepDarz1;
rd.Sources["DataSet2"] = MyData.DataSetKlonsRep.TRepDarz2;
rd.AddReportParameters(
new string[]
{
"RPERIOD", speriod,
"CompanyName", MyData.Params.CompNameX
});
MyMainForm.ShowReport(rd);
}
private void DoReportDoks2()
{
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, sdocgr);
ReportViewerData rd = new ReportViewerData();
rd.FileName = "Report_Ieraksti_1";
rd.Sources["DataSet1"] = MyData.DataSetKlons.vw_OPS;
rd.AddReportParameters(
new string[]
{
"RSD", MyData.Params.RSD,
"RED", MyData.Params.RED,
"RACX", "",
"RACNM", paramstr,
"CompanyName", MyData.Params.CompNameX
});
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 DoIt()
{
string rt = Check();
if (rt != "OK")
{
MyMainForm.ShowWarning(rt);
return;
}
int cmid = lbCM.SelectedIndex;
if (cmid == -1)
{
return;
}
SaveParams();
TRepMTTableAdapter ad = MyData.GetKlonsRepAdapter("TRepMT") as TRepMTTableAdapter;
if (ad == null)
{
return;
}
ReportViewerData rd = new ReportViewerData();
switch (cmid)
{
case 0:
ad.FillBy_apgr_mt_11(MyData.DataSetKlonsRep.TRepMT, startDate, endDate, ac);
break;
case 1:
case 2:
ad.FillBy_apgr_mt_12(MyData.DataSetKlonsRep.TRepMT, startDate, endDate, ac);
break;
case 3:
ad.FillBy_apgr_mt_21(MyData.DataSetKlonsRep.TRepMT, startDate, endDate, ac);
break;
case 4:
ad.FillBy_apgr_mt_22(MyData.DataSetKlonsRep.TRepMT, startDate, endDate, ac);
break;
}
MyData.ReportHelper.PrepareTRepMT();
switch (cmid)
{
case 0:
rd.FileName = "Report_Apgr_MT_11";
break;
case 1:
rd.FileName = "Report_Apgr_MT_12";
break;
case 2:
rd.FileName = "Report_Apgr_MT_13";
break;
case 3:
case 4:
rd.FileName = "Report_Apgr_MT_21";
break;
}
rd.Sources["DataSet1"] = MyData.DataSetKlonsRep.TRepMT;
rd.AddReportParameters(
new string[]
{
"RSD", MyData.Params.RSD,
"RED", MyData.Params.RED,
"RACX", MyData.Params.RACX,
"RACNM", MyData.Params.RACNM,
"CompanyName", MyData.Params.CompNameX
});
switch (cmid)
{
case 3:
rd.AddReportParameter("RTITLE", "Apgrozijuma pārskats debetam ar summām un daudzumiem");
break;
case 4:
rd.AddReportParameter("RTITLE", "Apgrozijuma pārskats kredītam ar summām un daudzumiem");
break;
}
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);
}
