Example #1
0
		public IList<Report> GetReports(int year, int clientId)
		{
			_year = year;
			_clientId = clientId;

			PrepareReport();
			GetAccounts();

			AccountsGrouping();

			foreach (var account in _accounts)
			{
				_report = new Report { AccountName = account.Name, Dt = new List<ReportDocument>(), Ct = new List<ReportDocument>() };

				GetAccountOpeningsDictionaryForAccount(account);
				GetAccountDocumentsForAccountSide(account, report => report.Dt, openings => openings.Dt, document=>document.AccountDt);
				GetAccountDocumentsForAccountSide(account, report => report.Ct, openings => openings.Ct, document=>document.AccountCt);
				CalculateSums();
				CalculateClosingForSideCt();
				CalculateClosingForSideDt();

				if (AnyDocumentsExists())
					_result.Add(_report);
			}

			return _result;
		}
Example #2
0
		private string GetAccountTable(Report report)
		{
			var rows = "";
			for (int i = 0; i < Math.Max(report.Ct.Count, report.Dt.Count); i++)
			{
				var dtName = report.Dt.Count > i ? report.Dt[i].AutoNumber : "";
				var dtPrice = report.Dt.Count > i ? DecimalToString(report.Dt[i].Price) : "";
				var ctName = report.Ct.Count > i ? report.Ct[i].AutoNumber : "";
				var ctPrice = report.Ct.Count > i ? DecimalToString(report.Ct[i].Price) : "";
				rows += "<tr><td class=\"col-2\">" + dtName + "</td><td class=\"col-4 right\">" + dtPrice + "</td><td class=\"col-2\">" + ctName + "</td><td class=\"col-4 right\">" + ctPrice + "</td></tr>";
			}
			var dtBzName = IsZero(report.DtClosing) ? "" : "BZ";
			var dtBzPrice = IsZero(report.DtClosing) ? "" : DecimalToString(report.DtClosing);
			var ctBzName = IsZero(report.CtClosing) ? "" : "BZ";
			var ctBzPrice = IsZero(report.CtClosing) ? "" : DecimalToString(report.CtClosing);

			var table = "<table class=\"main col-11\" id=\"one-column-emphasis\"><thead>" +
					"<tr><th colspan=\"4\"><b>Konto: " + report.AccountName + "</b></th></tr>" +
					"<tr><th class=\"col-2\"></th><th class=\"col-4 right\">Ma</th><th class=\"col-2\"></th><th class=\"col-4 right\">Wn</th></tr>" +
					"</thead><tbody></tbody></table>" +
					"<table class=\"col-11\" id=\"one-column-emphasis\"><thead></thead><tbody>" +
					rows + 
			        "</tbody></table>" +
					"<table class=\"main col-11\" id=\"one-column-emphasis\"><thead></thead><tbody>" +
					"<tr class=\"bold\"><td class=\"col-2\">suma:</td><td class=\"col-4 right\">" + DecimalToString(report.DtSum) + "</td><td class=\"col-2\">suma:</td><td class=\"col-4 right\">" + DecimalToString(report.CtSum) + "</td></tr>" +
					"<tr class=\"bold\"><td class=\"col-2\">" + dtBzName + "</td><td class=\"col-4 right\">" + dtBzPrice + "</td><td class=\"col-2\">" + ctBzName + "</td><td class=\"col-4 right\">" + ctBzPrice + "</td></tr></tbody></table>";
            return table;
		}