public void ThirdPointMonth_NeedDataSource(object sender, EventArgs e)
        {
            var yearObj = ReportParameters["year"].Value;
            int year    = 0;

            if (yearObj != null)
            {
                year = Convert.ToInt32(yearObj);
                if (year <= 0)
                {
                    year = DateTime.Now.Year;
                }
            }
            else
            {
                year = DateTime.Now.Year;
            }
            String sYear = year.ToString() + "Äê";

            textBox2.Value = sYear;
            IPowerClassRepos powerClassRepos = new PowerClassRepos();
            var elecPowers = (powerClassRepos.GetSubPowers("001").Select(x => x.PC_ID).ToArray().Union(new string[] { "001" })).ToArray();

            IAnalogHistoryRepos analogHistoryRepos = new AnalogHistoryRepos();
            DateTime            startDate          = DateTime.Parse(year + "-1-1");
            DateTime            endDate            = startDate.AddYears(1);

            var query = analogHistoryRepos.GetMonthEnergyByAnalogNosGranularity(startDate, endDate, elecPowers);

            table1.DataSource = query.OrderBy(x => x.Name).ToList();
        }
Beispiel #2
0
        private void BuildingWaterMonth_NeedDataSource(object sender, EventArgs e)
        {
            var areaIdObj = ReportParameters["areaId"].Value;
            var yearObj   = ReportParameters["year"].Value;

            if (areaIdObj != null)
            {
                int areaId = Convert.ToInt32(areaIdObj);
                int year   = 0;
                if (yearObj != null)
                {
                    year = Convert.ToInt32(yearObj);
                    if (year <= 0)
                    {
                        year = DateTime.Now.Year;
                    }
                }
                ISchoolAreaRepos areaRepos = new SchoolAreaRepos();
                var area = areaRepos.GetSchoolArea(areaId);
                if (area != null)
                {
                    string buildingName = area.SAI_Name;
                    textBox134.Value = buildingName;

                    ISystemProfileRepos systemProfileRepos = new SystemProfileRepos();
                    var priceDic       = systemProfileRepos.GetAllPrice().ToDictionary(x => x.SP_ID, x => x.SP_Value);
                    var priceWater     = priceDic["price_water"];
                    var pricePollution = priceDic["price_pollution"];
                    textBox11.Value = priceWater;
                    textBox13.Value = pricePollution;

                    IPowerClassRepos powerClassRepos = new PowerClassRepos();
                    var waterPowers = powerClassRepos.GetSubPowers("002").Select(x => x.PC_ID).ToArray();

                    DateTime            startDate          = DateTime.Parse(year + "-1-1");
                    DateTime            endDate            = startDate.AddYears(1);
                    IAnalogHistoryRepos analogHistoryRepos = new AnalogHistoryRepos();
                    // 使用endDate2主要是因为GetEnergyStatisMonth函数中使用AnalogHistoryMonths,部分代码ahm.AHM_MTime <= endTime,所以月如果是下年1月就多了一月,重复
                    DateTime    endDate2      = endDate.AddMonths(-1);
                    var         monthDataDic  = analogHistoryRepos.GetEnergyStatisMonth(2, areaId, startDate, endDate2, waterPowers, 1).ToDictionary(x => x.Time.Month, x => x.StatisVal);
                    IDictionary monthValDic   = new Dictionary <int, string>();
                    IDictionary monthPriceDic = new Dictionary <int, string>();
                    double      waterPrice    = Convert.ToDouble(priceWater);
                    // 合计月值
                    double totalMonthVal = 0;
                    // 每月水费
                    double totalMonthPrice = 0;
                    // 合计月值个数
                    int totalValCount = 0;
                    for (int i = 1; i <= 12; i++)
                    {
                        if (monthDataDic.ContainsKey(i) && monthDataDic[i] > 0)
                        {
                            monthValDic.Add(i, monthDataDic[i].ToString("f1"));
                            double price = monthDataDic[i] * waterPrice;
                            monthPriceDic.Add(i, price.ToString("f1"));
                            totalMonthVal   += monthDataDic[i];
                            totalMonthPrice += price;
                            totalValCount++;
                        }
                        else
                        {
                            monthValDic.Add(i, "/");
                            monthPriceDic.Add(i, "/");
                        }
                    }
                    // 1月
                    textBox5.Value = monthValDic[1].ToString();
                    textBox6.Value = monthPriceDic[1].ToString();
                    // 2月
                    textBox18.Value = monthValDic[2].ToString();
                    textBox19.Value = monthPriceDic[2].ToString();
                    // 3月
                    textBox26.Value = monthValDic[3].ToString();
                    textBox27.Value = monthPriceDic[3].ToString();
                    // 4月
                    textBox34.Value = monthValDic[4].ToString();
                    textBox35.Value = monthPriceDic[4].ToString();
                    // 5月
                    textBox42.Value = monthValDic[5].ToString();
                    textBox43.Value = monthPriceDic[5].ToString();
                    // 6月
                    textBox50.Value = monthValDic[6].ToString();
                    textBox51.Value = monthPriceDic[6].ToString();
                    // 7月
                    textBox58.Value = monthValDic[7].ToString();
                    textBox59.Value = monthPriceDic[7].ToString();
                    // 8月
                    textBox66.Value = monthValDic[8].ToString();
                    textBox67.Value = monthPriceDic[8].ToString();
                    // 9月
                    textBox74.Value = monthValDic[9].ToString();
                    textBox75.Value = monthPriceDic[9].ToString();
                    // 10月
                    textBox82.Value = monthValDic[10].ToString();
                    textBox83.Value = monthPriceDic[10].ToString();
                    // 11月
                    textBox90.Value = monthValDic[11].ToString();
                    textBox91.Value = monthPriceDic[11].ToString();
                    // 12月
                    textBox98.Value = monthValDic[12].ToString();
                    textBox99.Value = monthPriceDic[12].ToString();
                    // 合计平均月值
                    if (totalMonthVal > 0 && totalValCount > 0)
                    {
                        textBox106.Value = totalMonthVal.ToString("f1");
                        textBox114.Value = (totalMonthVal / totalValCount).ToString("f1");
                    }
                    // 合计平均水费
                    if (totalMonthPrice > 0 && totalValCount > 0)
                    {
                        textBox107.Value = totalMonthPrice.ToString("f1");
                        textBox115.Value = (totalMonthPrice / totalValCount).ToString("f1");
                    }
                }
            }
        }
Beispiel #3
0
        private void BuildingEnergyMonth_NeedDataSource(object sender, EventArgs e)
        {
            var buildingIDObj = ReportParameters["buildingId"].Value;
            var yearObj       = ReportParameters["year"].Value;
            var monthObj      = ReportParameters["month"].Value;

            if (buildingIDObj != null)
            {
                int buildingId = Convert.ToInt32(buildingIDObj);
                int year       = 0;
                if (yearObj != null)
                {
                    year = Convert.ToInt32(yearObj);
                    if (year <= 0)
                    {
                        year = DateTime.Now.Year;
                    }
                }
                int month = 0;
                if (monthObj != null)
                {
                    month = Convert.ToInt32(monthObj);
                    if (month <= 0)
                    {
                        month = DateTime.Now.Month;
                    }
                }
                IBuildingRepos buildingRepos = new BuildingRepos();
                var            building      = buildingRepos.GetBuilding(buildingId);
                if (building != null)
                {
                    string buildingName    = building.BDI_Name;
                    double?buildingArea    = building.BDI_Area;
                    double?buildingAreaSpe = building.BDI_AreaSpe;
                    textBox134.Value = buildingName;
                    textBox300.Value = month.ToString();
                    if (buildingArea != null)
                    {
                        textBox135.Value = buildingArea.ToString();
                    }
                    if (buildingAreaSpe != null)
                    {
                        textBox137.Value = buildingAreaSpe.ToString();
                    }
                    ISystemProfileRepos systemProfileRepos = new SystemProfileRepos();
                    var priceDic        = systemProfileRepos.GetAllPrice().ToDictionary(x => x.SP_ID, x => x.SP_Value);
                    var priceHighTime   = priceDic["price_highTime"];
                    var priceNormalTime = priceDic["price_normalTime"];
                    var priceLowTime    = priceDic["price_lowTime"];
                    textBox145.Value = priceHighTime;
                    textBox143.Value = priceNormalTime;
                    textBox141.Value = priceLowTime;

                    var timeDic    = systemProfileRepos.GetByStartStr("time").ToDictionary(x => x.SP_ID, x => x.SP_Value);
                    var timeHigh   = timeDic["time_high"];
                    var timeNormal = timeDic["time_normal"];
                    var timeLow    = timeDic["time_low"];

                    IPowerClassRepos powerClassRepos = new PowerClassRepos();
                    var elecPowers = (powerClassRepos.GetSubPowers("001").Select(x => x.PC_ID).ToArray().Union(new string[] { "001" })).ToArray();

                    IAnalogHistoryRepos analogHistoryRepos = new AnalogHistoryRepos();
                    DateTime            startDate          = DateTime.Parse(year + "-" + month + "-1");
                    DateTime            endDate            = startDate.AddMonths(1);

                    DateTime startDate2 = startDate.AddDays(1);
                    DateTime endDate2   = endDate.AddSeconds(-1);
                    var      dayDataDic = analogHistoryRepos.GetEnergyStatisDay(3, buildingId, startDate, endDate2, elecPowers, 1).ToDictionary(x => x.Time.Day, x => x.StatisVal);

                    var      timeBlocks = timeHigh.Split(new char[] { ',' });
                    double[] highVals   = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime = Int32.Parse(times[0]);
                            int endTime   = Int32.Parse(times[1]);
                            var query     = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var dayData   = query.ToDictionary(x => x.Time.Day, x => x.StatisVal);
                            foreach (var item in dayData)
                            {
                                highVals[item.Key] = item.Value;
                            }
                        }
                    }
                    timeBlocks = timeNormal.Split(new char[] { ',' });
                    double[] normalVals = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime = Int32.Parse(times[0]);
                            int endTime   = Int32.Parse(times[1]);
                            var query     = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var dayData   = query.ToDictionary(x => x.Time.Day, x => x.StatisVal);
                            foreach (var item in dayData)
                            {
                                normalVals[item.Key] = item.Value;
                            }
                        }
                    }
                    timeBlocks = timeLow.Split(new char[] { ',' });
                    double[] lowVals = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime = Int32.Parse(times[0]);
                            int endTime   = Int32.Parse(times[1]);
                            var query     = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var dayData   = query.ToDictionary(x => x.Time.Day, x => x.StatisVal);
                            foreach (var item in dayData)
                            {
                                lowVals[item.Key] = item.Value;
                            }
                        }
                    }

                    foreach (var item in dayDataDic)
                    {
                        double hnlsum = highVals[item.Key] + normalVals[item.Key] + lowVals[item.Key];
                        highVals[item.Key]   = highVals[item.Key] * dayDataDic[item.Key] / hnlsum;
                        normalVals[item.Key] = normalVals[item.Key] * dayDataDic[item.Key] / hnlsum;
                        lowVals[item.Key]    = lowVals[item.Key] * dayDataDic[item.Key] / hnlsum;
                    }

                    IDictionary highDayValDic   = new Dictionary <int, string>();
                    IDictionary normalDayValDic = new Dictionary <int, string>();
                    IDictionary lowDayValDic    = new Dictionary <int, string>();
                    IDictionary dayValDic       = new Dictionary <int, string>();
                    // 合计峰时值
                    double totalHighVal = 0;
                    // 峰时值个数
                    int totalHighValCount = 0;
                    // 合计平时值
                    double totalNormalVal = 0;
                    // 平时值个数
                    int totalNormalValCount = 0;
                    // 合计谷时值
                    double totalLowVal = 0;
                    // 谷时值个数
                    int totalLowValCount = 0;
                    // 合计月值
                    double totalMonthVal = 0;
                    // 合计月值个数
                    int totalValCount = 0;
                    for (int i = 1; i <= 31; i++)
                    {
                        if (highVals[i] > 0)
                        {
                            highDayValDic.Add(i, highVals[i].ToString("f1"));
                            totalHighVal += highVals[i];
                            totalHighValCount++;
                        }
                        else
                        {
                            highDayValDic.Add(i, "/");
                        }
                        if (normalVals[i] > 0)
                        {
                            normalDayValDic.Add(i, normalVals[i].ToString("f1"));
                            totalNormalVal += normalVals[i];
                            totalNormalValCount++;
                        }
                        else
                        {
                            normalDayValDic.Add(i, "/");
                        }
                        if (lowVals[i] > 0)
                        {
                            lowDayValDic.Add(i, lowVals[i].ToString("f1"));
                            totalLowVal += lowVals[i];
                            totalLowValCount++;
                        }
                        else
                        {
                            lowDayValDic.Add(i, "/");
                        }
                        if (dayDataDic.ContainsKey(i) && dayDataDic[i] > 0)
                        {
                            dayValDic.Add(i, dayDataDic[i].ToString("f1"));
                            totalMonthVal += dayDataDic[i];
                            totalValCount++;
                        }
                        else
                        {
                            dayValDic.Add(i, "/");
                        }
                    }
                    int days = (endDate - startDate).Days;
                    // 1日
                    textBox5.Value  = dayValDic[1].ToString();
                    textBox8.Value  = highDayValDic[1].ToString();
                    textBox10.Value = normalDayValDic[1].ToString();
                    textBox12.Value = lowDayValDic[1].ToString();
                    // 2日
                    textBox18.Value = dayValDic[2].ToString();
                    textBox20.Value = highDayValDic[2].ToString();
                    textBox21.Value = normalDayValDic[2].ToString();
                    textBox22.Value = lowDayValDic[2].ToString();
                    // 3日
                    textBox26.Value = dayValDic[3].ToString();
                    textBox28.Value = highDayValDic[3].ToString();
                    textBox29.Value = normalDayValDic[3].ToString();
                    textBox30.Value = lowDayValDic[3].ToString();
                    // 4日
                    textBox34.Value = dayValDic[4].ToString();
                    textBox36.Value = highDayValDic[4].ToString();
                    textBox37.Value = normalDayValDic[4].ToString();
                    textBox38.Value = lowDayValDic[4].ToString();
                    // 5日
                    textBox42.Value = dayValDic[5].ToString();
                    textBox44.Value = highDayValDic[5].ToString();
                    textBox45.Value = normalDayValDic[5].ToString();
                    textBox46.Value = lowDayValDic[5].ToString();
                    // 6日
                    textBox50.Value = dayValDic[6].ToString();
                    textBox52.Value = highDayValDic[6].ToString();
                    textBox53.Value = normalDayValDic[6].ToString();
                    textBox54.Value = lowDayValDic[6].ToString();
                    // 7日
                    textBox58.Value = dayValDic[7].ToString();
                    textBox60.Value = highDayValDic[7].ToString();
                    textBox61.Value = normalDayValDic[7].ToString();
                    textBox62.Value = lowDayValDic[7].ToString();
                    // 8日
                    textBox66.Value = dayValDic[8].ToString();
                    textBox68.Value = highDayValDic[8].ToString();
                    textBox69.Value = normalDayValDic[8].ToString();
                    textBox70.Value = lowDayValDic[8].ToString();
                    // 9日
                    textBox74.Value = dayValDic[9].ToString();
                    textBox76.Value = highDayValDic[9].ToString();
                    textBox77.Value = normalDayValDic[9].ToString();
                    textBox78.Value = lowDayValDic[9].ToString();
                    // 10日
                    textBox82.Value = dayValDic[10].ToString();
                    textBox84.Value = highDayValDic[10].ToString();
                    textBox85.Value = normalDayValDic[10].ToString();
                    textBox86.Value = lowDayValDic[10].ToString();
                    // 11日
                    textBox90.Value = dayValDic[11].ToString();
                    textBox92.Value = highDayValDic[11].ToString();
                    textBox93.Value = normalDayValDic[11].ToString();
                    textBox94.Value = lowDayValDic[11].ToString();
                    // 12日
                    textBox98.Value  = dayValDic[12].ToString();
                    textBox100.Value = highDayValDic[12].ToString();
                    textBox101.Value = normalDayValDic[12].ToString();
                    textBox102.Value = lowDayValDic[12].ToString();
                    // 13日
                    textBox106.Value = dayValDic[13].ToString();
                    textBox108.Value = highDayValDic[13].ToString();
                    textBox109.Value = normalDayValDic[13].ToString();
                    textBox110.Value = lowDayValDic[13].ToString();
                    // 14日
                    textBox114.Value = dayValDic[14].ToString();
                    textBox116.Value = highDayValDic[14].ToString();
                    textBox117.Value = normalDayValDic[14].ToString();
                    textBox118.Value = lowDayValDic[14].ToString();
                    // 15日
                    textBox148.Value = dayValDic[15].ToString();
                    textBox150.Value = highDayValDic[15].ToString();
                    textBox151.Value = normalDayValDic[15].ToString();
                    textBox152.Value = lowDayValDic[15].ToString();
                    // 16日
                    textBox156.Value = dayValDic[16].ToString();
                    textBox158.Value = highDayValDic[16].ToString();
                    textBox159.Value = normalDayValDic[16].ToString();
                    textBox160.Value = lowDayValDic[16].ToString();
                    // 17日
                    textBox164.Value = dayValDic[17].ToString();
                    textBox166.Value = highDayValDic[17].ToString();
                    textBox167.Value = normalDayValDic[17].ToString();
                    textBox168.Value = lowDayValDic[17].ToString();
                    // 18日
                    textBox172.Value = dayValDic[18].ToString();
                    textBox174.Value = highDayValDic[18].ToString();
                    textBox175.Value = normalDayValDic[18].ToString();
                    textBox176.Value = lowDayValDic[18].ToString();
                    // 19日
                    textBox180.Value = dayValDic[19].ToString();
                    textBox182.Value = highDayValDic[19].ToString();
                    textBox183.Value = normalDayValDic[19].ToString();
                    textBox184.Value = lowDayValDic[19].ToString();
                    // 20日
                    textBox188.Value = dayValDic[20].ToString();
                    textBox190.Value = highDayValDic[20].ToString();
                    textBox191.Value = normalDayValDic[20].ToString();
                    textBox192.Value = lowDayValDic[20].ToString();
                    // 21日
                    textBox196.Value = dayValDic[21].ToString();
                    textBox198.Value = highDayValDic[21].ToString();
                    textBox199.Value = normalDayValDic[21].ToString();
                    textBox200.Value = lowDayValDic[21].ToString();
                    // 22日
                    textBox204.Value = dayValDic[22].ToString();
                    textBox206.Value = highDayValDic[22].ToString();
                    textBox207.Value = normalDayValDic[22].ToString();
                    textBox208.Value = lowDayValDic[22].ToString();
                    // 23日
                    textBox212.Value = dayValDic[23].ToString();
                    textBox214.Value = highDayValDic[23].ToString();
                    textBox215.Value = normalDayValDic[23].ToString();
                    textBox216.Value = lowDayValDic[23].ToString();
                    // 24日
                    textBox220.Value = dayValDic[24].ToString();
                    textBox222.Value = highDayValDic[24].ToString();
                    textBox223.Value = normalDayValDic[24].ToString();
                    textBox224.Value = lowDayValDic[24].ToString();
                    // 25日
                    textBox228.Value = dayValDic[25].ToString();
                    textBox230.Value = highDayValDic[25].ToString();
                    textBox231.Value = normalDayValDic[25].ToString();
                    textBox232.Value = lowDayValDic[25].ToString();
                    // 26日
                    textBox236.Value = dayValDic[26].ToString();
                    textBox238.Value = highDayValDic[26].ToString();
                    textBox239.Value = normalDayValDic[26].ToString();
                    textBox240.Value = lowDayValDic[26].ToString();
                    // 27日
                    textBox244.Value = dayValDic[27].ToString();
                    textBox246.Value = highDayValDic[27].ToString();
                    textBox247.Value = normalDayValDic[27].ToString();
                    textBox248.Value = lowDayValDic[27].ToString();
                    // 28日
                    textBox252.Value = dayValDic[28].ToString();
                    textBox254.Value = highDayValDic[28].ToString();
                    textBox255.Value = normalDayValDic[28].ToString();
                    textBox256.Value = lowDayValDic[28].ToString();
                    // 29日
                    if (days >= 29)
                    {
                        textBox260.Value = dayValDic[29].ToString();
                        textBox262.Value = highDayValDic[29].ToString();
                        textBox263.Value = normalDayValDic[29].ToString();
                        textBox264.Value = lowDayValDic[29].ToString();
                    }
                    // 30日
                    if (days >= 30)
                    {
                        textBox268.Value = dayValDic[30].ToString();
                        textBox270.Value = highDayValDic[30].ToString();
                        textBox271.Value = normalDayValDic[30].ToString();
                        textBox272.Value = lowDayValDic[30].ToString();
                    }
                    // 31日
                    if (days >= 31)
                    {
                        textBox276.Value = dayValDic[31].ToString();
                        textBox278.Value = highDayValDic[31].ToString();
                        textBox279.Value = normalDayValDic[31].ToString();
                        textBox290.Value = lowDayValDic[31].ToString();
                    }

                    // 合计平均月值
                    if (totalMonthVal > 0 && totalValCount > 0)
                    {
                        textBox284.Value = totalMonthVal.ToString("f1");
                        textBox292.Value = (totalMonthVal / totalValCount).ToString("f1");
                    }
                    // 合计平均峰时值
                    if (totalHighVal > 0 && totalHighValCount > 0)
                    {
                        textBox286.Value = totalHighVal.ToString("f1");
                        textBox294.Value = (totalHighVal / totalHighValCount).ToString("f1");
                    }
                    // 合计平均平时值
                    if (totalNormalVal > 0 && totalNormalValCount > 0)
                    {
                        textBox287.Value = totalNormalVal.ToString("f1");
                        textBox295.Value = (totalNormalVal / totalNormalValCount).ToString("f1");
                    }
                    // 合计平均谷时值
                    if (totalLowVal > 0 && totalLowValCount > 0)
                    {
                        textBox288.Value = totalLowVal.ToString("f1");
                        textBox296.Value = (totalLowVal / totalLowValCount).ToString("f1");
                    }
                }
            }
        }
        private void BuildingEnergyMonth_NeedDataSource(object sender, EventArgs e)
        {
            var buildingIDObj = ReportParameters["buildingId"].Value;
            var yearObj       = ReportParameters["year"].Value;

            if (buildingIDObj != null)
            {
                int buildingId = Convert.ToInt32(buildingIDObj);
                int year       = 0;
                if (yearObj != null)
                {
                    year = Convert.ToInt32(yearObj);
                    if (year <= 0)
                    {
                        year = DateTime.Now.Year;
                    }
                }
                IBuildingRepos buildingRepos = new BuildingRepos();
                var            building      = buildingRepos.GetBuilding(buildingId);
                if (building != null)
                {
                    string buildingName      = building.BDI_Name;
                    double?buildingArea      = building.BDI_Area;
                    double?buildingUserCount = building.BDI_Users;
                    textBox277.Value = buildingName;
                    if (buildingArea != null)
                    {
                        textBox279.Value = buildingArea.ToString();
                    }
                    if (buildingUserCount != null)
                    {
                        textBox281.Value = buildingUserCount.ToString();
                    }
                    ISystemProfileRepos systemProfileRepos = new SystemProfileRepos();
                    var priceDic        = systemProfileRepos.GetAllPrice().ToDictionary(x => x.SP_ID, x => x.SP_Value);
                    var priceHighTime   = Convert.ToDouble(priceDic["price_highTime"]);
                    var priceNormalTime = Convert.ToDouble(priceDic["price_normalTime"]);
                    var priceLowTime    = Convert.ToDouble(priceDic["price_lowTime"]);

                    var timeDic    = systemProfileRepos.GetByStartStr("time").ToDictionary(x => x.SP_ID, x => x.SP_Value);
                    var timeHigh   = timeDic["time_high"];
                    var timeNormal = timeDic["time_normal"];
                    var timeLow    = timeDic["time_low"];

                    IPowerClassRepos powerClassRepos = new PowerClassRepos();
                    var elecPowers = (powerClassRepos.GetSubPowers("001").Select(x => x.PC_ID).ToArray().Union(new string[] { "001" })).ToArray();

                    IAnalogHistoryRepos analogHistoryRepos = new AnalogHistoryRepos();
                    DateTime            startDate          = DateTime.Parse(year + "-1-1");
                    DateTime            endDate            = startDate.AddYears(1);

                    var      timeBlocks = timeHigh.Split(new char[] { ',' });
                    double[] highVals   = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime  = Int32.Parse(times[0]);
                            int endTime    = Int32.Parse(times[1]);
                            var query      = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var monthQuery = query.GroupBy(x => x.Month, x => x.StatisVal).Select(g => new { Month = g.Key, Val = g.Sum() });
                            var monthData  = monthQuery.ToDictionary(x => x.Month, x => x.Val);
                            foreach (var item in monthData)
                            {
                                highVals[item.Key] = item.Value;
                            }
                        }
                    }
                    timeBlocks = timeNormal.Split(new char[] { ',' });
                    double[] normalVals = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime  = Int32.Parse(times[0]);
                            int endTime    = Int32.Parse(times[1]);
                            var query      = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var monthQuery = query.GroupBy(x => x.Month, x => x.StatisVal).Select(g => new { Month = g.Key, Val = g.Sum() });
                            var monthData  = monthQuery.ToDictionary(x => x.Month, x => x.Val);
                            foreach (var item in monthData)
                            {
                                normalVals[item.Key] = item.Value;
                            }
                        }
                    }
                    timeBlocks = timeLow.Split(new char[] { ',' });
                    double[] lowVals = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime  = Int32.Parse(times[0]);
                            int endTime    = Int32.Parse(times[1]);
                            var query      = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var monthQuery = query.GroupBy(x => x.Month, x => x.StatisVal).Select(g => new { Month = g.Key, Val = g.Sum() });
                            var monthData  = monthQuery.ToDictionary(x => x.Month, x => x.Val);
                            foreach (var item in monthData)
                            {
                                lowVals[item.Key] = item.Value;
                            }
                        }
                    }
                    // 使用endDate2主要是因为GetEnergyStatisMonth函数中使用AnalogHistoryMonths,部分代码ahm.AHM_MTime <= endTime,所以月如果是下年1月就多了一月,重复
                    DateTime endDate2     = endDate.AddMonths(-1);
                    var      monthDataDic = analogHistoryRepos.GetEnergyStatisMonth(3, buildingId, startDate, endDate2, elecPowers, 1).ToDictionary(x => x.Time.Month, x => x.StatisVal);

                    foreach (var item in monthDataDic)
                    {
                        double hnlsum = highVals[item.Key] + normalVals[item.Key] + lowVals[item.Key];
                        highVals[item.Key]   = highVals[item.Key] * monthDataDic[item.Key] / hnlsum;
                        normalVals[item.Key] = normalVals[item.Key] * monthDataDic[item.Key] / hnlsum;
                        lowVals[item.Key]    = lowVals[item.Key] * monthDataDic[item.Key] / hnlsum;
                    }

                    IDictionary highMonthValDic   = new Dictionary <int, string>();
                    IDictionary normalMonthValDic = new Dictionary <int, string>();
                    IDictionary lowMonthValDic    = new Dictionary <int, string>();
                    IDictionary monthValDic       = new Dictionary <int, string>();
                    // 月电费
                    IDictionary elecChargeDic = new Dictionary <int, string>();
                    // 单位面积电耗
                    IDictionary monthValPerUnitDic = new Dictionary <int, string>();
                    // 单位面积电费
                    IDictionary elecChargeDicPerUnitDic = new Dictionary <int, string>();
                    // 合计峰时值
                    double totalHighVal = 0;
                    // 峰时值个数
                    int totalHighValCount = 0;
                    // 合计平时值
                    double totalNormalVal = 0;
                    // 平时值个数
                    int totalNormalValCount = 0;
                    // 合计谷时值
                    double totalLowVal = 0;
                    // 谷时值个数
                    int totalLowValCount = 0;
                    // 合计月值
                    double totalMonthVal = 0;
                    // 合计月值个数
                    int totalValCount = 0;
                    // 合计电费
                    double totalElecCharge = 0;
                    // 合计电费个数
                    int totalElecChargeCount = 0;
                    // 合计单位面积电耗
                    double totalMonthValPerUnit = 0;
                    // 合计单位面积电耗个数
                    int totalMonthValPerUnitCount = 0;
                    // 合计单位面积电费
                    double totalElecChargeDicPerUnit = 0;
                    // 合计单位面积电费个数
                    int totalElecChargeDicPerUnitCount = 0;
                    for (int i = 1; i <= 12; i++)
                    {
                        if (highVals[i] > 0)
                        {
                            highMonthValDic.Add(i, highVals[i].ToString("f1"));
                            totalHighVal += highVals[i];
                            totalHighValCount++;
                        }
                        else
                        {
                            highMonthValDic.Add(i, "/");
                        }
                        if (normalVals[i] > 0)
                        {
                            normalMonthValDic.Add(i, normalVals[i].ToString("f1"));
                            totalNormalVal += normalVals[i];
                            totalNormalValCount++;
                        }
                        else
                        {
                            normalMonthValDic.Add(i, "/");
                        }
                        if (lowVals[i] > 0)
                        {
                            lowMonthValDic.Add(i, lowVals[i].ToString("f1"));
                            totalLowVal += lowVals[i];
                            totalLowValCount++;
                        }
                        else
                        {
                            lowMonthValDic.Add(i, "/");
                        }
                        if (monthDataDic.ContainsKey(i) && monthDataDic[i] > 0)
                        {
                            monthValDic.Add(i, monthDataDic[i].ToString("f1"));
                            if (buildingArea.HasValue)
                            {
                                var val = monthDataDic[i] / buildingArea.Value;
                                monthValPerUnitDic.Add(i, val.ToString("f1"));
                                totalMonthValPerUnit += val;
                                totalMonthValPerUnitCount++;
                            }
                            else
                            {
                                monthValPerUnitDic.Add(i, "/");
                            }
                            totalMonthVal += monthDataDic[i];
                            totalValCount++;
                        }
                        else
                        {
                            monthValDic.Add(i, "/");
                            monthValPerUnitDic.Add(i, "/");
                        }
                        if (highVals[i] > 0 && normalVals[i] > 0 && lowVals[i] > 0)
                        {
                            double price = highVals[i] * priceHighTime + normalVals[i] * priceNormalTime + lowVals[i] * priceLowTime;
                            elecChargeDic.Add(i, price.ToString("f1"));
                            totalElecCharge += price;
                            totalElecChargeCount++;
                            if (buildingArea.HasValue)
                            {
                                var val = price / buildingArea.Value;
                                elecChargeDicPerUnitDic.Add(i, val.ToString("f1"));
                                totalElecChargeDicPerUnit += val;
                                totalElecChargeDicPerUnitCount++;
                            }
                            else
                            {
                                elecChargeDicPerUnitDic.Add(i, "/");
                            }
                        }
                        else
                        {
                            elecChargeDic.Add(i, "/");
                            elecChargeDicPerUnitDic.Add(i, "/");
                        }
                    }
                    // 1月
                    textBox24.Value = monthValDic[1].ToString();
                    textBox25.Value = highMonthValDic[1].ToString();
                    textBox29.Value = normalMonthValDic[1].ToString();
                    textBox31.Value = lowMonthValDic[1].ToString();
                    textBox33.Value = elecChargeDic[1].ToString();
                    textBox35.Value = monthValPerUnitDic[1].ToString();
                    textBox37.Value = elecChargeDicPerUnitDic[1].ToString();
                    // 2月
                    textBox27.Value = monthValDic[2].ToString();
                    textBox28.Value = highMonthValDic[2].ToString();
                    textBox30.Value = normalMonthValDic[2].ToString();
                    textBox32.Value = lowMonthValDic[2].ToString();
                    textBox34.Value = elecChargeDic[2].ToString();
                    textBox36.Value = monthValPerUnitDic[2].ToString();
                    textBox38.Value = elecChargeDicPerUnitDic[2].ToString();
                    // 3月
                    textBox60.Value = monthValDic[3].ToString();
                    textBox61.Value = highMonthValDic[3].ToString();
                    textBox62.Value = normalMonthValDic[3].ToString();
                    textBox63.Value = lowMonthValDic[3].ToString();
                    textBox64.Value = elecChargeDic[3].ToString();
                    textBox65.Value = monthValPerUnitDic[3].ToString();
                    textBox66.Value = elecChargeDicPerUnitDic[3].ToString();
                    // 4月
                    textBox78.Value = monthValDic[4].ToString();
                    textBox79.Value = highMonthValDic[4].ToString();
                    textBox80.Value = normalMonthValDic[4].ToString();
                    textBox81.Value = lowMonthValDic[4].ToString();
                    textBox82.Value = elecChargeDic[4].ToString();
                    textBox83.Value = monthValPerUnitDic[4].ToString();
                    textBox84.Value = elecChargeDicPerUnitDic[4].ToString();

                    // 5月
                    textBox96.Value  = monthValDic[5].ToString();
                    textBox97.Value  = highMonthValDic[5].ToString();
                    textBox98.Value  = normalMonthValDic[5].ToString();
                    textBox99.Value  = lowMonthValDic[5].ToString();
                    textBox100.Value = elecChargeDic[5].ToString();
                    textBox101.Value = monthValPerUnitDic[5].ToString();
                    textBox102.Value = elecChargeDicPerUnitDic[5].ToString();
                    // 6月
                    textBox114.Value = monthValDic[6].ToString();
                    textBox115.Value = highMonthValDic[6].ToString();
                    textBox116.Value = normalMonthValDic[6].ToString();
                    textBox117.Value = lowMonthValDic[6].ToString();
                    textBox118.Value = elecChargeDic[6].ToString();
                    textBox119.Value = monthValPerUnitDic[6].ToString();
                    textBox120.Value = elecChargeDicPerUnitDic[6].ToString();
                    // 7月
                    textBox132.Value = monthValDic[7].ToString();
                    textBox133.Value = highMonthValDic[7].ToString();
                    textBox134.Value = normalMonthValDic[7].ToString();
                    textBox135.Value = lowMonthValDic[7].ToString();
                    textBox136.Value = elecChargeDic[7].ToString();
                    textBox137.Value = monthValPerUnitDic[7].ToString();
                    textBox138.Value = elecChargeDicPerUnitDic[7].ToString();
                    // 8月
                    textBox150.Value = monthValDic[8].ToString();
                    textBox151.Value = highMonthValDic[8].ToString();
                    textBox152.Value = normalMonthValDic[8].ToString();
                    textBox153.Value = lowMonthValDic[8].ToString();
                    textBox154.Value = elecChargeDic[8].ToString();
                    textBox155.Value = monthValPerUnitDic[8].ToString();
                    textBox156.Value = elecChargeDicPerUnitDic[8].ToString();
                    // 9月
                    textBox168.Value = monthValDic[9].ToString();
                    textBox169.Value = highMonthValDic[9].ToString();
                    textBox170.Value = normalMonthValDic[9].ToString();
                    textBox171.Value = lowMonthValDic[9].ToString();
                    textBox172.Value = elecChargeDic[9].ToString();
                    textBox173.Value = monthValPerUnitDic[9].ToString();
                    textBox174.Value = elecChargeDicPerUnitDic[9].ToString();
                    // 10月
                    textBox186.Value = monthValDic[10].ToString();
                    textBox187.Value = highMonthValDic[10].ToString();
                    textBox188.Value = normalMonthValDic[10].ToString();
                    textBox189.Value = lowMonthValDic[10].ToString();
                    textBox190.Value = elecChargeDic[10].ToString();
                    textBox191.Value = monthValPerUnitDic[10].ToString();
                    textBox192.Value = elecChargeDicPerUnitDic[10].ToString();
                    // 11月
                    textBox204.Value = monthValDic[11].ToString();
                    textBox205.Value = highMonthValDic[11].ToString();
                    textBox206.Value = normalMonthValDic[11].ToString();
                    textBox207.Value = lowMonthValDic[11].ToString();
                    textBox208.Value = elecChargeDic[11].ToString();
                    textBox209.Value = monthValPerUnitDic[11].ToString();
                    textBox210.Value = elecChargeDicPerUnitDic[11].ToString();
                    // 12月
                    textBox222.Value = monthValDic[12].ToString();
                    textBox223.Value = highMonthValDic[12].ToString();
                    textBox224.Value = normalMonthValDic[12].ToString();
                    textBox225.Value = lowMonthValDic[12].ToString();
                    textBox226.Value = elecChargeDic[12].ToString();
                    textBox227.Value = monthValPerUnitDic[12].ToString();
                    textBox228.Value = elecChargeDicPerUnitDic[12].ToString();
                    // 合计平均月值
                    if (totalMonthVal > 0 && totalValCount > 0)
                    {
                        textBox240.Value = totalMonthVal.ToString("f1");
                        textBox258.Value = (totalMonthVal / totalValCount).ToString("f1");
                    }
                    // 合计平均峰时值
                    if (totalHighVal > 0 && totalHighValCount > 0)
                    {
                        textBox241.Value = totalHighVal.ToString("f1");
                        textBox259.Value = (totalHighVal / totalHighValCount).ToString("f1");
                    }
                    // 合计平均平时值
                    if (totalNormalVal > 0 && totalNormalValCount > 0)
                    {
                        textBox242.Value = totalNormalVal.ToString("f1");
                        textBox260.Value = (totalNormalVal / totalNormalValCount).ToString("f1");
                    }
                    // 合计平均谷时值
                    if (totalLowVal > 0 && totalLowValCount > 0)
                    {
                        textBox243.Value = totalLowVal.ToString("f1");
                        textBox261.Value = (totalLowVal / totalLowValCount).ToString("f1");
                    }
                    // 合计平均月电费
                    if (totalElecCharge > 0 && totalElecChargeCount > 0)
                    {
                        textBox244.Value = totalElecCharge.ToString("f1");
                        textBox262.Value = (totalElecCharge / totalElecChargeCount).ToString("f1");
                    }
                    // 合计平均单位面积电耗
                    if (totalMonthValPerUnit > 0 && totalMonthValPerUnitCount > 0)
                    {
                        textBox245.Value = totalMonthValPerUnit.ToString("f1");
                        textBox263.Value = (totalMonthValPerUnit / totalMonthValPerUnitCount).ToString("f1");
                    }
                    // 合计平均单位面积电费
                    if (totalElecChargeDicPerUnit > 0 && totalElecChargeDicPerUnitCount > 0)
                    {
                        textBox246.Value = totalElecChargeDicPerUnit.ToString("f1");
                        textBox264.Value = (totalElecChargeDicPerUnit / totalElecChargeDicPerUnitCount).ToString("f1");
                    }
                }
            }
        }
        private void BuildingEnergyMonth_NeedDataSource(object sender, EventArgs e)
        {
            var buildingIDObj = ReportParameters["buildingId"].Value;
            var yearObj       = ReportParameters["year"].Value;

            if (buildingIDObj != null)
            {
                int buildingId = Convert.ToInt32(buildingIDObj);
                int year       = 0;
                if (yearObj != null)
                {
                    year = Convert.ToInt32(yearObj);
                    if (year <= 0)
                    {
                        year = DateTime.Now.Year;
                    }
                }
                IBuildingRepos buildingRepos = new BuildingRepos();
                var            building      = buildingRepos.GetBuilding(buildingId);
                if (building != null)
                {
                    string buildingName    = building.BDI_Name;
                    double?buildingArea    = building.BDI_Area;
                    double?buildingAreaSpe = building.BDI_AreaSpe;
                    textBox134.Value = buildingName;
                    if (buildingArea != null)
                    {
                        textBox135.Value = buildingArea.ToString();
                    }
                    if (buildingAreaSpe != null)
                    {
                        textBox137.Value = buildingAreaSpe.ToString();
                    }
                    ISystemProfileRepos systemProfileRepos = new SystemProfileRepos();
                    var priceDic        = systemProfileRepos.GetAllPrice().ToDictionary(x => x.SP_ID, x => x.SP_Value);
                    var priceHighTime   = priceDic["price_highTime"];
                    var priceNormalTime = priceDic["price_normalTime"];
                    var priceLowTime    = priceDic["price_lowTime"];
                    textBox145.Value = priceHighTime;
                    textBox143.Value = priceNormalTime;
                    textBox141.Value = priceLowTime;

                    var timeDic    = systemProfileRepos.GetByStartStr("time").ToDictionary(x => x.SP_ID, x => x.SP_Value);
                    var timeHigh   = timeDic["time_high"];
                    var timeNormal = timeDic["time_normal"];
                    var timeLow    = timeDic["time_low"];

                    IPowerClassRepos powerClassRepos = new PowerClassRepos();
                    var elecPowers = (powerClassRepos.GetSubPowers("001").Select(x => x.PC_ID).ToArray().Union(new string[] { "001" })).ToArray();

                    IAnalogHistoryRepos analogHistoryRepos = new AnalogHistoryRepos();
                    DateTime            startDate          = DateTime.Parse(year + "-1-1");
                    DateTime            endDate            = startDate.AddYears(1);

                    var      timeBlocks = timeHigh.Split(new char[] { ',' });
                    double[] highVals   = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime  = Int32.Parse(times[0]);
                            int endTime    = Int32.Parse(times[1]);
                            var query      = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var monthQuery = query.GroupBy(x => x.Month, x => x.StatisVal).Select(g => new { Month = g.Key, Val = g.Sum() });
                            var monthData  = monthQuery.ToDictionary(x => x.Month, x => x.Val);
                            foreach (var item in monthData)
                            {
                                highVals[item.Key] = item.Value;
                            }
                        }
                    }
                    timeBlocks = timeNormal.Split(new char[] { ',' });
                    double[] normalVals = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime  = Int32.Parse(times[0]);
                            int endTime    = Int32.Parse(times[1]);
                            var query      = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var monthQuery = query.GroupBy(x => x.Month, x => x.StatisVal).Select(g => new { Month = g.Key, Val = g.Sum() });
                            var monthData  = monthQuery.ToDictionary(x => x.Month, x => x.Val);
                            foreach (var item in monthData)
                            {
                                normalVals[item.Key] = item.Value;
                            }
                        }
                    }
                    timeBlocks = timeLow.Split(new char[] { ',' });
                    double[] lowVals = new double[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
                    foreach (var timeStr in timeBlocks)
                    {
                        var times = timeStr.Split(new char[] { '-' });
                        if (times != null && times.Length > 1)
                        {
                            int startTime  = Int32.Parse(times[0]);
                            int endTime    = Int32.Parse(times[1]);
                            var query      = analogHistoryRepos.GetEnergyBySpecialHours(3, buildingId, startDate, endDate, elecPowers, startTime, endTime);
                            var monthQuery = query.GroupBy(x => x.Month, x => x.StatisVal).Select(g => new { Month = g.Key, Val = g.Sum() });
                            var monthData  = monthQuery.ToDictionary(x => x.Month, x => x.Val);
                            foreach (var item in monthData)
                            {
                                lowVals[item.Key] = item.Value;
                            }
                        }
                    }
                    // 使用endDate2主要是因为GetEnergyStatisMonth函数中使用endTime = endTime.AddDays(1),所以要减一天,另外使用ahm.AHM_MTime <= endTime,可以考虑多减1秒
                    DateTime endDate2     = endDate.AddDays(-1).AddSeconds(-1);
                    var      monthDataDic = analogHistoryRepos.GetEnergyStatisMonth(3, buildingId, startDate, endDate2, elecPowers, 1).ToDictionary(x => x.Time.Month, x => x.StatisVal);


                    foreach (var item in monthDataDic)
                    {
                        double hnlsum = highVals[item.Key] + normalVals[item.Key] + lowVals[item.Key];
                        highVals[item.Key]   = highVals[item.Key] * monthDataDic[item.Key] / hnlsum;
                        normalVals[item.Key] = normalVals[item.Key] * monthDataDic[item.Key] / hnlsum;
                        lowVals[item.Key]    = lowVals[item.Key] * monthDataDic[item.Key] / hnlsum;
                    }

                    IDictionary highMonthValDic   = new Dictionary <int, string>();
                    IDictionary normalMonthValDic = new Dictionary <int, string>();
                    IDictionary lowMonthValDic    = new Dictionary <int, string>();
                    IDictionary monthValDic       = new Dictionary <int, string>();
                    // 合计峰时值
                    double totalHighVal = 0;
                    // 峰时值个数
                    int totalHighValCount = 0;
                    // 合计平时值
                    double totalNormalVal = 0;
                    // 平时值个数
                    int totalNormalValCount = 0;
                    // 合计谷时值
                    double totalLowVal = 0;
                    // 谷时值个数
                    int totalLowValCount = 0;
                    // 合计月值
                    double totalMonthVal = 0;
                    // 合计月值个数
                    int totalValCount = 0;
                    for (int i = 1; i <= 12; i++)
                    {
                        if (highVals[i] > 0)
                        {
                            highMonthValDic.Add(i, highVals[i].ToString("f1"));
                            totalHighVal += highVals[i];
                            totalHighValCount++;
                        }
                        else
                        {
                            highMonthValDic.Add(i, "/");
                        }
                        if (normalVals[i] > 0)
                        {
                            normalMonthValDic.Add(i, normalVals[i].ToString("f1"));
                            totalNormalVal += normalVals[i];
                            totalNormalValCount++;
                        }
                        else
                        {
                            normalMonthValDic.Add(i, "/");
                        }
                        if (lowVals[i] > 0)
                        {
                            lowMonthValDic.Add(i, lowVals[i].ToString("f1"));
                            totalLowVal += lowVals[i];
                            totalLowValCount++;
                        }
                        else
                        {
                            lowMonthValDic.Add(i, "/");
                        }
                        if (monthDataDic.ContainsKey(i) && monthDataDic[i] > 0)
                        {
                            monthValDic.Add(i, monthDataDic[i].ToString("f1"));
                            totalMonthVal += monthDataDic[i];
                            totalValCount++;
                        }
                        else
                        {
                            monthValDic.Add(i, "/");
                        }
                    }
                    // 1月
                    textBox5.Value  = monthValDic[1].ToString();
                    textBox8.Value  = highMonthValDic[1].ToString();
                    textBox10.Value = normalMonthValDic[1].ToString();
                    textBox12.Value = lowMonthValDic[1].ToString();
                    // 2月
                    textBox18.Value = monthValDic[2].ToString();
                    textBox20.Value = highMonthValDic[2].ToString();
                    textBox21.Value = normalMonthValDic[2].ToString();
                    textBox22.Value = lowMonthValDic[2].ToString();
                    // 3月
                    textBox26.Value = monthValDic[3].ToString();
                    textBox28.Value = highMonthValDic[3].ToString();
                    textBox29.Value = normalMonthValDic[3].ToString();
                    textBox30.Value = lowMonthValDic[3].ToString();
                    // 4月
                    textBox34.Value = monthValDic[4].ToString();
                    textBox36.Value = highMonthValDic[4].ToString();
                    textBox37.Value = normalMonthValDic[4].ToString();
                    textBox38.Value = lowMonthValDic[4].ToString();
                    // 5月
                    textBox42.Value = monthValDic[5].ToString();
                    textBox44.Value = highMonthValDic[5].ToString();
                    textBox45.Value = normalMonthValDic[5].ToString();
                    textBox46.Value = lowMonthValDic[5].ToString();
                    // 6月
                    textBox50.Value = monthValDic[6].ToString();
                    textBox52.Value = highMonthValDic[6].ToString();
                    textBox53.Value = normalMonthValDic[6].ToString();
                    textBox54.Value = lowMonthValDic[6].ToString();
                    // 7月
                    textBox58.Value = monthValDic[7].ToString();
                    textBox60.Value = highMonthValDic[7].ToString();
                    textBox61.Value = normalMonthValDic[7].ToString();
                    textBox62.Value = lowMonthValDic[7].ToString();
                    // 8月
                    textBox66.Value = monthValDic[8].ToString();
                    textBox68.Value = highMonthValDic[8].ToString();
                    textBox69.Value = normalMonthValDic[8].ToString();
                    textBox70.Value = lowMonthValDic[8].ToString();
                    // 9月
                    textBox74.Value = monthValDic[9].ToString();
                    textBox76.Value = highMonthValDic[9].ToString();
                    textBox77.Value = normalMonthValDic[9].ToString();
                    textBox78.Value = lowMonthValDic[9].ToString();
                    // 10月
                    textBox82.Value = monthValDic[10].ToString();
                    textBox84.Value = highMonthValDic[10].ToString();
                    textBox85.Value = normalMonthValDic[10].ToString();
                    textBox86.Value = lowMonthValDic[10].ToString();
                    // 11月
                    textBox90.Value = monthValDic[11].ToString();
                    textBox92.Value = highMonthValDic[11].ToString();
                    textBox93.Value = normalMonthValDic[11].ToString();
                    textBox94.Value = lowMonthValDic[11].ToString();
                    // 12月
                    textBox98.Value  = monthValDic[12].ToString();
                    textBox100.Value = highMonthValDic[12].ToString();
                    textBox101.Value = normalMonthValDic[12].ToString();
                    textBox102.Value = lowMonthValDic[12].ToString();
                    // 合计平均月值
                    if (totalMonthVal > 0 && totalValCount > 0)
                    {
                        textBox106.Value = totalMonthVal.ToString("f1");
                        textBox114.Value = (totalMonthVal / totalValCount).ToString("f1");
                    }
                    // 合计平均峰时值
                    if (totalHighVal > 0 && totalHighValCount > 0)
                    {
                        textBox108.Value = totalHighVal.ToString("f1");
                        textBox116.Value = (totalHighVal / totalHighValCount).ToString("f1");
                    }
                    // 合计平均平时值
                    if (totalNormalVal > 0 && totalNormalValCount > 0)
                    {
                        textBox109.Value = totalNormalVal.ToString("f1");
                        textBox117.Value = (totalNormalVal / totalNormalValCount).ToString("f1");
                    }
                    // 合计平均谷时值
                    if (totalLowVal > 0 && totalLowValCount > 0)
                    {
                        textBox110.Value = totalLowVal.ToString("f1");
                        textBox118.Value = (totalLowVal / totalLowValCount).ToString("f1");
                    }
                }
            }
        }