Exemplo n.º 1
0
        public ActionResult Modal(QueryModel qm)
        {
            qm.Date_01 = DateTime.Now;

            qm.Unit = new Unit[4];
            //DbEntities db = new DbEntities();
            DbModelDataContext db = DbContextFactory.Create();
            var units = db.SIS_Unit;
            int i = 0;
            foreach (var item in units)
            {
                qm.Unit[i] = new Unit();
                qm.Unit[i].Id = item.UnitId;
                i++;
            }
            db.Dispose();
            return View(qm);
        }
Exemplo n.º 2
0
 public ActionResult Query(QueryModel qm)
 {
     QueryModel[] result;
     if (qm.Date_02.Year == 1)
     {
         result = new QueryModel[1];
         result[0] = qm;
         result = DoQuery(result, false);
         return View("Query", result.ToList());
     }
     else
     {
         result = new QueryModel[2];
         result[0] = qm;
         result[1]=new QueryModel();
         result[1].GeneralInfo = new GeneralInfo();
         result[1].Unit = new Unit[4];
         for (int i = 0; i < 4; i++)
         {
             result[1].Unit[i] = new Unit();
         }
         result = DoQuery(result, true);
         return View("QueryCompare",result.ToList());
     }
 }
Exemplo n.º 3
0
        private QueryModel[] DoQuery(QueryModel[] qm,bool isCompare)
        {
            DbModelDataContext db = DbContextFactory.Create();
            if (qm[0].GeneralInfo.IsTotalInstalledCapacityChecked)
            {
                qm[0].GeneralInfo.TotalInstalledCapacity = db.SIS_PlantSummary.First().InstalledCapacity;
            }
            if (qm[0].GeneralInfo.IsDailyGenerateChecked)
            {
                qm[0].GeneralInfo.DailyGenerate = db.SIS_TotalPowerGeneration_Daily
                    .Single(g => g.Timestamp.Year == qm[0].Date_01.Year
                    && g.Timestamp.Month == qm[0].Date_01.Month
                    && g.Timestamp.Day == qm[0].Date_01.Day)
                    .PowerGenerate ?? 0;
                if (isCompare)
                {
                    qm[1].GeneralInfo.DailyGenerate = db.SIS_TotalPowerGeneration_Daily
                    .Single(g => g.Timestamp.Year == qm[0].Date_02.Year
                    && g.Timestamp.Month == qm[0].Date_02.Month
                    && g.Timestamp.Day == qm[0].Date_02.Day)
                    .PowerGenerate ?? 0;
                }
            }
            if (qm[0].GeneralInfo.IsMonthlyGenerateChecked)
            {
                var total = db.SIS_TotalPowerGeneration_Monthly
                    .Single(g => g.Timestamp.Year == qm[0].Date_01.Year && g.Timestamp.Month == qm[0].Date_01.Month)
                    .PowerGenerate;
                qm[0].GeneralInfo.MonthlyGenerate = total ?? 0;
                if (isCompare)
                {
                    var total2 = db.SIS_TotalPowerGeneration_Monthly
                    .Single(g => g.Timestamp.Year == qm[0].Date_02.Year && g.Timestamp.Month == qm[0].Date_02.Month)
                    .PowerGenerate;
                    qm[1].GeneralInfo.MonthlyGenerate = total2 ?? 0;
                }
            }
            if (qm[0].GeneralInfo.IsYearlyGenerateChecked)
            {
                var total = db.SIS_TotalPowerGeneration_Yearly.Single(g => g.Timestamp.Year == qm[0].Date_01.Year).PowerGenerate;
                qm[0].GeneralInfo.YearlyGenerate = total ?? 0;
                if (isCompare)
                {
                    var total2 = db.SIS_TotalPowerGeneration_Yearly.Single(g => g.Timestamp.Year == qm[0].Date_02.Year).PowerGenerate;
                    qm[1].GeneralInfo.YearlyGenerate = total2 ?? 0;

                }
            }

            List<int> chk_id = new List<int>();
            for (int i = 0; i < 4; i++)
            {
                if (qm[0].Unit[i].IsIdChecked)
                {
                    chk_id.Add(i + 1);
                    qm[0].Unit[i].Id = i + 1;
                    if (isCompare)
                    {
                        qm[1].Unit[i].Id = i+1;
                        qm[1].Unit[i].IsIdChecked = true;
                    }
                }
            }

            if (qm[0].GeneralInfo.IsHourlyTotalAvgLoadChecked)
            {
                qm[0].GeneralInfo.HourlyAvgTotalLoadList = new List<decimal>();
                var total = db.SIS_TotalPowerGeneration_Hourly.Where(g => g.Timestamp.Year == qm[0].Date_01.Year
                    && g.Timestamp.Month == qm[0].Date_01.Month && g.Timestamp.Day == qm[0].Date_01.Day);
                foreach (var item in total)
                {
                    qm[0].GeneralInfo.HourlyAvgTotalLoadList.Add(item.PowerGenerate ?? 0);
                }
                if (isCompare)
                {
                    qm[1].GeneralInfo.HourlyAvgTotalLoadList = new List<decimal>();
                    var total2 = db.SIS_TotalPowerGeneration_Hourly.Where(g => g.Timestamp.Year == qm[0].Date_02.Year
                        && g.Timestamp.Month == qm[0].Date_02.Month && g.Timestamp.Day == qm[0].Date_02.Day);
                    foreach (var item in total2)
                    {
                        qm[1].GeneralInfo.HourlyAvgTotalLoadList.Add(item.PowerGenerate ?? 0);
                    }
                }
            }

            if (qm[0].Unit[0].IsHourlyAvgLoadChecked)
            {

                for (int i = 0; i < chk_id.Count(); i++)
                {
                    int id = chk_id[i];
                    var generate = db.SIS_PowerGeneration_Hourly.Where(g => g.UnitId == id
                        && g.Timestamp.Year == qm[0].Date_01.Year
                        && g.Timestamp.Month == qm[0].Date_01.Month
                        && g.Timestamp.Day == qm[0].Date_01.Day
                        );
                    qm[0].Unit[id-1].HourlyAvgLoadList = new List<decimal>();
                    foreach (var item in generate)
                    {
                        qm[0].Unit[id - 1].HourlyAvgLoadList.Add(item.PowerGeneration ?? 0);
                    }
                }

                if (isCompare)
                {
                    for (int i = 0; i < chk_id.Count(); i++)
                    {
                        int id = chk_id[i];
                        var generate = db.SIS_PowerGeneration_Hourly.Where(g => g.UnitId == id
                            && g.Timestamp.Year == qm[0].Date_02.Year
                            && g.Timestamp.Month == qm[0].Date_02.Month
                            && g.Timestamp.Day == qm[0].Date_02.Day
                            );
                        qm[1].Unit[id - 1].HourlyAvgLoadList = new List<decimal>();
                        foreach (var item in generate)
                        {
                            qm[1].Unit[id - 1].HourlyAvgLoadList.Add(item.PowerGeneration ?? 0);
                        }
                    }
                }
            }
            db.Dispose();

            return qm;
        }