Esempio n. 1
0
        public ActionResult MonthAnalyze(string[] Grid1_fields, DateTime?yearMonth, DateTime?toYearMonth)
        {
            List <MonthAnalyze> prList = new List <MonthAnalyze>();

            int year  = yearMonth.Value.Year;
            int month = yearMonth.Value.Month;

            int toYear  = toYearMonth.Value.Year;
            int toMonth = toYearMonth.Value.Month;

            List <SaleManage> smList = db.SaleManage.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                                           p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth).ToList();

            MonthAnalyze pr4 = new MonthAnalyze();

            pr4.Content = "年/月计划";
            pr4.ZZSYB   = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                               p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT != "制造事业部").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.JGGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "精工工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.JAGGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                             p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "加工工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.MJGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "模具工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.ZNSBGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                              p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "智能设备工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.ZNJQ = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "智能机器").Sum(p => p.MANAGE_PLAN) / 12;
            prList.Add(pr4);

            MonthAnalyze pr1 = new MonthAnalyze();

            pr1.Content = "月计划";
            pr1.ZZSYB   = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                               p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT != "制造事业部").Sum(p => p.SALE_PLAN);
            pr1.JGGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "精工工厂").Sum(p => p.SALE_PLAN);
            pr1.JAGGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                             p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "加工工厂").Sum(p => p.SALE_PLAN);
            pr1.MJGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "模具工厂").Sum(p => p.SALE_PLAN);
            pr1.ZNSBGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                              p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "智能设备工厂").Sum(p => p.SALE_PLAN);
            pr1.ZNJQ = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "智能机器").Sum(p => p.SALE_PLAN);
            prList.Add(pr1);

            MonthAnalyze pr2 = new MonthAnalyze();

            pr2.Content = "月实际";
            pr2.ZZSYB   = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                               p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT != "制造事业部").Sum(p => p.SALE_FINISH);
            pr2.JGGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "精工工厂").Sum(p => p.SALE_FINISH);
            pr2.JAGGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                             p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "加工工厂").Sum(p => p.SALE_FINISH);
            pr2.MJGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "模具工厂").Sum(p => p.SALE_FINISH);
            pr2.ZNSBGC = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                              p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "智能设备工厂").Sum(p => p.SALE_FINISH);
            pr2.ZNJQ = (double)smList.Where(p => p.PLAN_DATE.Year >= yearMonth.Value.Year && p.PLAN_DATE.Month >= yearMonth.Value.Month &&
                                            p.PLAN_DATE.Year <= toYear && p.PLAN_DATE.Month <= toMonth && p.RSPO_DEPT == "智能机器").Sum(p => p.SALE_FINISH);
            prList.Add(pr2);

            MonthAnalyze pr3 = new MonthAnalyze();

            pr3.Content = "月完成率";
            pr3.ZZSYB   = Convert.ToDouble((pr2.ZZSYB / pr1.ZZSYB * 100.0).ToString("0"));
            pr3.JGGC    = Convert.ToDouble((pr2.JGGC / pr1.JGGC * 100.0).ToString("0"));
            pr3.JAGGC   = Convert.ToDouble((pr2.JAGGC / pr1.JAGGC * 100.0).ToString("0"));
            pr3.MJGC    = Convert.ToDouble((pr2.MJGC / pr1.MJGC * 100.0).ToString("0"));
            pr3.ZNSBGC  = Convert.ToDouble((pr2.ZNSBGC / pr1.ZNSBGC * 100.0).ToString("0"));
            pr3.ZNJQ    = Convert.ToDouble((pr2.ZNJQ / pr1.ZNJQ * 100.0).ToString("0"));
            prList.Add(pr3);

            var grid1 = UIHelper.Grid("Grid1");

            var dataSource = prList;

            grid1.DataSource(dataSource, Grid1_fields);

            return(UIHelper.Result());
        }
Esempio n. 2
0
        public ActionResult MonthAnalyze()
        {
            List <MonthAnalyze> prList = new List <MonthAnalyze>();

            int year  = DateTime.Now.Year;
            int month = DateTime.Now.Month;

            List <SaleManage> smList = db.SaleManage.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month).ToList();

            MonthAnalyze pr4 = new MonthAnalyze();

            pr4.Content = "年/月计划";
            pr4.ZZSYB   = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT != "制造事业部").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.JGGC    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "精工工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.JAGGC   = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "加工工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.MJGC    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "模具工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.ZNSBGC  = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "智能设备工厂").Sum(p => p.MANAGE_PLAN) / 12;
            pr4.ZNJQ    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "智能机器").Sum(p => p.MANAGE_PLAN) / 12;
            prList.Add(pr4);

            MonthAnalyze pr1 = new MonthAnalyze();

            pr1.Content = "月计划";
            pr1.ZZSYB   = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT != "制造事业部").Sum(p => p.SALE_PLAN);
            pr1.JGGC    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "精工工厂").Sum(p => p.SALE_PLAN);
            pr1.JAGGC   = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "加工工厂").Sum(p => p.SALE_PLAN);
            pr1.MJGC    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "模具工厂").Sum(p => p.SALE_PLAN);
            pr1.ZNSBGC  = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "智能设备工厂").Sum(p => p.SALE_PLAN);
            pr1.ZNJQ    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "智能机器").Sum(p => p.SALE_PLAN);
            prList.Add(pr1);

            MonthAnalyze pr2 = new MonthAnalyze();

            pr2.Content = "月实际";
            pr2.ZZSYB   = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT != "制造事业部").Sum(p => p.SALE_FINISH);
            pr2.JGGC    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "精工工厂").Sum(p => p.SALE_FINISH);
            pr2.JAGGC   = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "加工工厂").Sum(p => p.SALE_FINISH);
            pr2.MJGC    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "模具工厂").Sum(p => p.SALE_FINISH);
            pr2.ZNSBGC  = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "智能设备工厂").Sum(p => p.SALE_FINISH);
            pr2.ZNJQ    = (double)smList.Where(p => p.PLAN_DATE.Year == year && p.PLAN_DATE.Month == month && p.RSPO_DEPT == "智能机器").Sum(p => p.SALE_FINISH);
            prList.Add(pr2);

            MonthAnalyze pr3 = new MonthAnalyze();

            pr3.Content = "月完成率";
            pr3.ZZSYB   = Convert.ToDouble((pr2.ZZSYB / pr1.ZZSYB * 100.0).ToString("0"));
            pr3.JGGC    = Convert.ToDouble((pr2.JGGC / pr1.JGGC * 100.0).ToString("0"));
            pr3.JAGGC   = Convert.ToDouble((pr2.JAGGC / pr1.JAGGC * 100.0).ToString("0"));
            pr3.MJGC    = Convert.ToDouble((pr2.MJGC / pr1.MJGC * 100.0).ToString("0.00"));
            pr3.ZNSBGC  = Convert.ToDouble((pr2.ZNSBGC / pr1.ZNSBGC * 100.0).ToString("0"));
            pr3.ZNJQ    = Convert.ToDouble((pr2.ZNJQ / pr1.ZNJQ * 100.0).ToString("0"));
            prList.Add(pr3);

            foreach (var pr in prList)
            {
                if (double.IsNaN(pr.JAGGC))
                {
                    pr.JAGGC = 0;
                }
                if (double.IsNaN(pr.JGGC))
                {
                    pr.JGGC = 0;
                }
                if (double.IsNaN(pr.MJGC))
                {
                    pr.MJGC = 0;
                }
                if (double.IsNaN(pr.ZNJQ))
                {
                    pr.ZNJQ = 0;
                }
                if (double.IsNaN(pr.ZNSBGC))
                {
                    pr.ZNSBGC = 0;
                }
                if (double.IsNaN(pr.ZZSYB))
                {
                    pr.ZZSYB = 0;
                }
            }

            return(View(prList));
        }