Core.NETCore.BI-Examples - Historie editací

Zavadil v 11. 8. 2017, 09:53

2017-08-11T09:53:54Z

Zavadil v 11. 8. 2017, 09:52

2017-08-11T09:52:27Z

Zavadil: Zavadil přesunul stránku Examples na Core.NETCore.BI-Examples

2017-08-11T09:33:40Z

Zavadil přesunul stránku Examples na Core.NETCore.BI-Examples

Zavadil v 11. 8. 2017, 09:31

2017-08-11T09:31:05Z

Zavadil v 11. 8. 2017, 09:30

2017-08-11T09:30:38Z

Zavadil v 11. 8. 2017, 09:29

2017-08-11T09:29:41Z

Zavadil v 11. 8. 2017, 09:15

2017-08-11T09:15:07Z

Zavadil v 11. 8. 2017, 08:52

2017-08-11T08:52:43Z

Zavadil v 11. 8. 2017, 08:51

2017-08-11T08:51:47Z

Zavadil v 11. 8. 2017, 08:51

2017-08-11T08:51:12Z

← Starší verze		Verze z 11. 8. 2017, 09:53
Řádka 1:		Řádka 1:
		+	=== Enumerations ===
		+	<syntaxhighlight lang="vb">
		+	Public Enum TurnoverTypes
		+	<TDescription("Zboží podle výdeje")>
		+	GoodsByIssue = 1
		+	<TDescription("Zboží podle prodeje")>
		+	GoodsBySale = 2
		+	<TDescription("Služby")>
		+	Services = 10
		+	End Enum
		+	</syntaxhighlight><syntaxhighlight lang="vb">
		+	Public Enum TurnoverSalessmannType
		+	<TDescription("Podle fakturační adresy")>
		+	ByInvoiceAddress = 0
		+	<TDescription("Podle dodací adresy")>
		+	ByDeliveryAddress = 2
		+	End Enum
		+	</syntaxhighlight>
		+
	=== Calculate purchase turnover for suppliers (for months) ===		=== Calculate purchase turnover for suppliers (for months) ===
	<syntaxhighlight lang="vb">		<syntaxhighlight lang="vb">

← Starší verze		Verze z 11. 8. 2017, 09:52
Řádka 77:		Řádka 77:

	=== Calculate company turnover trend (last 12 months) ===		=== Calculate company turnover trend (last 12 months) ===
		+	<syntaxhighlight lang="vb">
		+
		+	Dim Result As Core.NETCore.BI.CompanyBussinesInfo.TurnoverInfo
		+
		+	For Month As Integer = 0 To 11
		+
		+	'Calculate date
		+	Dim Dt As Date = DateSerial(Now.Year, Now.Month, 1).AddMonths((11 * -1) + Month)
		+
		+	'Calculate month turnover for goods
		+	Dim MonthGoods As New Core.NETCore.BI.CompanyBussinesInfo(Dt.Year, Dt.Month, Core.NETCore.BI.CompanyBussinesInfo.TurnoverTypes.GoodsByIssue)
		+	Result = MonthGoods.TotalTurnover
		+
		+	'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
		+	'Place your code to show data, stored in [Result]
		+	'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
		+
		+	'Calculate month turnover for non-goods
		+	Dim MonthServices As New Core.NETCore.BI.CompanyBussinesInfo(Dt.Year, Dt.Month, Core.NETCore.BI.CompanyBussinesInfo.TurnoverTypes.Services)
		+	Result = MonthServices.TotalTurnover
		+
		+	'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
		+	'Place your code to show data, stored in [Result]
		+	'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
		+	Next
		+	</syntaxhighlight>

	=== Calculate company debts overview (splitted by branch) ===		=== Calculate company debts overview (splitted by branch) ===

@@ Řádka 76: / Řádka 76: @@
 </syntaxhighlight>
-=== Company turnover trend (last 12 months) ===
+=== Calculate company turnover trend (last 12 months) ===
-=== Company debts overview (splitted by branch) ===
+=== Calculate company debts overview (splitted by branch) ===

← Starší verze		Verze z 11. 8. 2017, 09:30
Řádka 77:		Řádka 77:

	=== Company turnover trend (last 12 months) ===		=== Company turnover trend (last 12 months) ===
		+
		+	=== Company debts overview (splitted by branch) ===

← Starší verze		Verze z 11. 8. 2017, 09:29
Řádka 75:		Řádka 75:
	Next		Next
	</syntaxhighlight>		</syntaxhighlight>
		+
		+	=== Company turnover trend (last 12 months) ===

← Starší verze	Verze z 11. 8. 2017, 09:33
(Žádný rozdíl)

@@ Řádka 14: / Řádka 14: @@
              '2. Declare collection with supplier turnover info
-             Dim Results As System.Collections.Generic.SortedList(Of Integer, Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo)
+             Dim Result As System.Collections.Generic.SortedList(Of Integer, Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo)
              '3. Calculate supplier turnover info using base BI class (step 1.)
-             '   FilteredInSuppliers (coma delimited string with ID's of suppliers.Example: "1,5688,45")
+             '   FilteredInSuppliers (coma delimited string with ID's of suppliers. Example: "1,5688,45")
-             '   FilteredOutSuppliers (coma delimited string with ID's of suppliers.Example: "1,5688,45")
+             '   FilteredOutSuppliers (coma delimited string with ID's of suupliers. Example: "1,5688,45")
-             Results = MonthInfo.SupplierTurnover("", "")
+             Result = MonthInfo.SupplierTurnover("", "")
              '4. Browse and show data for each supplier info in specified month
-             For Each Item As Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo In Results.Values
+             For Each Item As Core.NETCore.BI.CompanyBussinesInfo.SupplierTurnoverInfo In Result.Values
                  'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
                  'Place your code to show data, stored in [Item]
                  'XXXXXXXXXXXXXXXXXXXXXXXXXXXX
              Next
          Next
 </syntaxhighlight>

@@ Řádka 1: / Řádka 1: @@
-=== Calculate purchase turnover for suppliers ===
+=== Calculate purchase turnover for suppliers (for months) ===
 <syntaxhighlight lang="vb">
         'Total moth count to calculate turnover