Example #1
0
        public DPMViewModel GetDPM()
        {
            DayOfWeek weekStart    = DayOfWeek.Monday; // or Sunday, or whenever
            DateTime  startingDate = DateTime.Today;

            while (startingDate.DayOfWeek != weekStart)
            {
                startingDate = startingDate.AddDays(-1);
            }

            DateTime previousFiveWeekStart = startingDate.AddDays(-35);

            //tổng số sản phẩm được kiểm tra rồi
            var list = _appDbContext.Inspections.Where(t => t.InspectDate.Date >= previousFiveWeekStart.Date && t.InspectDate.Date < startingDate.Date && t.InspectStatus == true).ToList();

            var          checkedItems = list.Select(b => b.NumberChecked).Sum();
            var          mistakeItems = list.Select(b => b.ProductQuantityChecked).Sum();
            double       dpmValue     = checkedItems == 0 ? 0 : Math.Round(((double)mistakeItems / (double)checkedItems) * 1000000, 0);
            DPMViewModel result       = new DPMViewModel()
            {
                CheckedItems = checkedItems,
                MistakeItems = mistakeItems,
                DPMValue     = dpmValue
            };

            return(result);
        }
Example #2
0
        public DPMListViewModel GetDPMByFactory()
        {
            DayOfWeek weekStart    = DayOfWeek.Sunday; // or Sunday, or whenever
            DateTime  startingDate = DateTime.Today;

            while (startingDate.DayOfWeek != weekStart)
            {
                startingDate = startingDate.AddDays(-1);
            }

            //lấy ngày thứ 2 cách đó 5 tuần
            DateTime previousFiveWeekStart = startingDate.AddDays(-35);

            //tổng số sản phẩm được kiểm tra rồi
            var list = _appDbContext.Inspections.Where(t => t.InspectDate.Date >= previousFiveWeekStart.Date && t.InspectDate.Date < startingDate.Date && t.InspectStatus == true).ToList();

            var manufacturerList = (from so in list//_appDbContext.Inspections : avoid retrieving all inspections to improve performance; btw maybe not list all manufacturer unless list does not collect all
                                    group so by so.FactoryName into TotaledFactories
                                    select new
            {
                FactoryName = TotaledFactories.Key,
            });
            List <DPMViewModel> dpmList = new List <DPMViewModel>();

            foreach (var item in manufacturerList)
            {
                var checkedItems = list.Where(a => a.FactoryName == item.FactoryName).Select(b => b.NumberChecked).Sum();
                var mistakeItems = list.Where(x => x.FactoryName == item.FactoryName).Select(b => b.ProductQuantityChecked).Sum();

                double       dpmValue = checkedItems == 0 ? 0 : Math.Round(((double)mistakeItems / (double)checkedItems) * 1000000, 0);
                DPMViewModel dpm      = new DPMViewModel()
                {
                    CheckedItems = checkedItems,
                    MistakeItems = mistakeItems,
                    FactoryName  = item.FactoryName,
                    DPMValue     = dpmValue
                                   //FactoryId = factoryId
                };

                dpmList.Add(dpm);
            }

            DPMListViewModel result = new DPMListViewModel()
            {
                DPMList   = dpmList,
                StartDate = previousFiveWeekStart.AddDays(1).ToString("d"),
                EndDate   = startingDate.AddDays(-1).ToString("d")
            };

            return(result);
        }