partial void RevenueCalculate_Execute()
        {
            // Вычисляем общую сумму дохода клиента за месяц по всем точкам обслуживания
            Customer cust = this.Customers.SelectedItem;
            var query = from servpoint in cust.ServicePointCustomers
                        select new
                        {
                            totalrevenue = servpoint.InkasControlCards.Sum(s => (decimal)s.RevenueServicePoint)
                        };

            foreach(var servpoint in query) 
            {              
               this.RevenueCustomers.SelectedItem.AmountRevenue = servpoint.totalrevenue;              
            }
        }

SELECT DISTINCT Customers.CustomerName,InkasControlCards.CurrentYearInkas,InkasControlCards,CurrentMonthInkas,
InkasControlCards.CurrentYearInkas,Sum(InkasControlCards.RevenueServicePoint) AS [TotalRevenue], RevenueCustomers.YearRevenue, RevenueCustomers.MonthRevenue
FROM (Customers INNER JOIN (ServicePointCustomers INNER JOIN InkasControlCards ON (ServicePointCustomers.ID=InkasControlCards.ID) AND (ServicePointCustomers.ID=InkasControlCards.ID)) ON Customers.ID=ServicePointCustomers.ID) INNER JOIN RevenueCustomers ON Customers.ID=RevenueClient.ID
WHERE InkasControlCards.CurrentYearInkas=RevenueCustomers.YearRevenue AND InkasControlCards,CurrentMonthInkas=RevenueCustomers.MonthRevenue
GROUPBYCustomers.CustomerName,ServicePointCustomers,InkasControlCards,CurrentMonthInkas,InkasControlCards.CurrentYearInkas RevenueCustomers.YearRevenue, RevenueCustomers.MonthRevenue;

Customer cust = this.Customers.SelectedItem;
            var query = from servpoint in cust.ServicePointCustomers
                        from card in servpoint.InkasControlCards
                        where card.CurrentMonthInkas==cust.RevenueCustomers.SingleOrDefault().MonthRevenue
                        select new
                        {
                            totalrevenue = servpoint.InkasControlCards.Sum(s => (decimal)s.RevenueServicePoint)
                        };

            foreach(var servpoint in query) 
                {
               this.RevenueCustomers.SelectedItem.AmountRevenue = servpoint.totalrevenue;
                }

// Вычисляем общую сумму дохода клиента за рабочий месяц по всем точкам обслуживания
            Customer cust = this.Customers.SelectedItem;
            var query = from servpoint in cust.ServicePointCustomers
                        from card in servpoint.InkasControlCards
                        where card.CurrentMonthInkas == cust.RevenueCustomers.SingleOrDefault().MonthRevenue
                        group card by card.CurrentMonthInkas into pointsales
                        select new
                        {
                          totalrevenue= pointsales.Sum(s => (decimal)s.RevenueServicePoint)
                        };
            foreach(var servpoint in query) 
                {
                    this.RevenueCustomers.SelectedItem.AmountRevenue =(decimal) servpoint.totalrevenue;
                }

// Вычисляем общую сумму дохода клиента за рабочий месяц по всем точкам обслуживания
            Customer cust = this.Customers.SelectedItem;
            var query = from servpoint in cust.ServicePointCustomers
                        from card in servpoint.InkasControlCards
                        where card.CurrentMonthInkas == cust.RevenueCustomers.SingleOrDefault().MonthRevenue
                        group card by card.CurrentMonthInkas into pointsales
                        select new
                        {
                          totalrevenue= pointsales.Sum(s => (decimal)s.RevenueServicePoint)
                        };
            foreach(var servpoint in query) 
                {
                    this.RevenueCustomers.SelectedItem.AmountRevenue =(decimal) servpoint.totalrevenue;
                }

partial void RevenueCalculate_Execute()
        {
            // Вычисляем общую сумму дохода клиента за рабочий месяц по всем точкам обслуживания
            Customer cust = this.Customers.SelectedItem;
            var query = from servpoint in cust.ServicePointCustomers
                        from card in servpoint.InkasControlCards
                        where card.CurrentMonthInkas == this.RevenueCustomers.SelectedItem.MonthRevenue
                        group card by card.CurrentMonthInkas into pointsales
                        select new
                        {
                          totalrevenue= pointsales.Sum(s => (decimal)s.RevenueServicePoint)
                        };
            foreach(var servpoint in query) 
                {
                  this.RevenueCustomers.SelectedItem.AmountRevenue =(decimal)servpoint.totalrevenue;
                }
        }