void LoadDealQuarter(int quarter) { //quarter = 1 => Quý 1: Tháng 1 -> 3 //quarter = 2 => Quý 1: Tháng 4 -> 6 //quarter = 3 => Quý 1: Tháng 7 -> 9 //quarter = 4 => Quý 1: Tháng 10 -> 12 ReportDataList.DealQuarter = new ObservableCollection <Revenue>(); ReportDataList2.DealQuarter = new ObservableCollection <Revenue>(); List <sumArray> SumArrayQuantity = new List <sumArray>(); List <sumArray> SumArrayPrice = new List <sumArray>(); var DealList = DataProvider.Ins.DB.DEALs.Where(x => x.IsDeleted == false && x.PayDate.Value.Year == DateTime.Now.Year && (x.PayDate.Value.Month + 2) / 3 == quarter); foreach (var deal in DealList) { if (IsExistsDate(SumArrayPrice, deal.PayDate.Value.Month, deal.DisplayPrice) == false) { var element = new sumArray(); element.date = deal.PayDate.Value.Month; element.sumPrice = deal.DisplayPrice; SumArrayPrice.Add(element); } if (IsExistsProduct(SumArrayQuantity, deal.PRODUCT.DisplayName, deal.Quantity) == false) { var element = new sumArray(); element.productName = deal.PRODUCT.DisplayName; element.sumQuantity = deal.Quantity; SumArrayQuantity.Add(element); } } foreach (var element in SumArrayQuantity) { var revenue = new Revenue(); revenue.ProductName = element.productName; revenue.SumQuantity = element.sumQuantity; ReportDataList.DealQuarter.Add(revenue); //Load vào biểu đố số lượng } foreach (var element in SumArrayPrice) { var revenue = new Revenue(); revenue.Time = element.date; revenue.SumPrice = element.sumPrice; ReportDataList2.DealQuarter.Add(revenue); //Load vào biểu đố doanh thu } }
void LoadDealPeriodTime(DateTime beginTime, DateTime endTime) { ReportDataList.DealPeriod = new ObservableCollection <Revenue>(); ReportDataList2.DealPeriod = new ObservableCollection <Revenue>(); List <sumArray> SumArrayQuantity = new List <sumArray>(); List <sumArray> SumArrayPrice = new List <sumArray>(); var DealList = DataProvider.Ins.DB.DEALs.Where(x => x.IsDeleted == false && x.PayDate >= beginTime && x.PayDate <= endTime); foreach (var deal in DealList) { if (IsExistsDate(SumArrayPrice, deal.PayDate.Value.Day, deal.DisplayPrice) == false) { var element = new sumArray(); element.detailDate = (DateTime)deal.PayDate; element.sumPrice = deal.DisplayPrice; SumArrayPrice.Add(element); } if (IsExistsProduct(SumArrayQuantity, deal.PRODUCT.DisplayName, deal.Quantity) == false) { var element = new sumArray(); element.productName = deal.PRODUCT.DisplayName; element.sumQuantity = deal.Quantity; SumArrayQuantity.Add(element); } } foreach (var element in SumArrayQuantity) { var revenue = new Revenue(); revenue.ProductName = element.productName; revenue.SumQuantity = element.sumQuantity; ReportDataList.DealPeriod.Add(revenue); //Load vào biểu đố số lượng } foreach (var element in SumArrayPrice) { var revenue = new Revenue(); revenue.PayDate = element.detailDate; revenue.SumPrice = element.sumPrice; ReportDataList2.DealPeriod.Add(revenue); //Load vào biểu đố doanh thu } }