public static List<SalesModel> GetSalesOneQuery(DateTime stDate, DateTime endDate) { using (base3Entities db = new base3Entities()) { var db3 = new base2Entities(); List<SalesModel> result = new List<SalesModel>(); var qSeb = Accessors.QueryForGetSalesForSeb(stDate, endDate, db, db3); //только инфа по группам и производителям или как их SalesModel tmp = new SalesModel(); tmp.Date = stDate; tmp.Sales = QueryForGetSales(stDate, endDate, db, qSeb, db3); if (tmp.Sales.Count != 0) result.Add(tmp); return result; } }
public static List<SalesModel> GetSales(DateTime stDate, DateTime endDate, bool isLoadBeginOfTheTime = false) { using (base3Entities db = new base3Entities()) { endDate = endDate.AddSeconds(-1); List<SalesModel> result = new List<SalesModel>(); int[] endMonthYear = new int[] { endDate.Month, endDate.Year }; var db3 = new base2Entities(); int monthCount = 0; int[] startMonthYear = new int[] { stDate.Month, stDate.Year };//будем бежать от начала до конца периода List<SalesEnt> qSeb = new List<SalesEnt>(); if(!isLoadBeginOfTheTime) qSeb = Accessors.QueryForGetSalesForSeb(stDate, endDate, db, db3); do { DateTime stDt = new DateTime(startMonthYear[1], startMonthYear[0], 1); DateTime endDt = new DateTime(); #region Cчитаем кол-во месяцев if (startMonthYear[0] == 12) { startMonthYear[1]++; startMonthYear[0] = 1; monthCount++; endDt = new DateTime(startMonthYear[1], startMonthYear[0], 1); } else { startMonthYear[0]++; monthCount++; endDt = new DateTime(startMonthYear[1], startMonthYear[0], 1); } #endregion SalesModel tmp = new SalesModel(); tmp.Date = stDt; tmp.Sales = QueryForGetSales(stDt, endDt, db, qSeb, db3); if(tmp.Sales.Count != 0) result.Add(tmp); } while ((startMonthYear[1] <= endMonthYear[1] && startMonthYear[1] != endMonthYear[1]) || (startMonthYear[0] <= endMonthYear[0] && startMonthYear[1] == endMonthYear[1])); return result; } }