tangxu
2024-06-07 18a1a6faf82b1ad00d27f6fc7f5734c34aea32df
WaterPredict/IStation.ChEr.Application.WaterPredict/01-info/DebugController.cs
@@ -32,44 +32,44 @@
                    }
                }
                bll.Inserts(waterPredictRecord);*/
            /*            List<SSAData> sSADatas = new List<SSAData>();
                        var path = "C:\\Users\\ZKC\\Desktop\\工作簿now.csv";
                        int totalLines = File.ReadLines(path, Encoding.GetEncoding("gb2312")).Count();//总行数
                        System.IO.FileStream fs = new System.IO.FileStream(path, System.IO.FileMode.Open);
                        System.IO.StreamReader sr = new System.IO.StreamReader(fs, Encoding.GetEncoding("gb2312"));
                        string tempText;
                        //   int line = 0;
                        double total = 0;
                        for (int i = 0; i < totalLines; i++)
                        {
                            tempText = sr.ReadLine();
                            string[] arr = tempText.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                            if (Convert.ToDateTime(arr[0]).Minute == 0)
                            {
                                sSADatas.Add(new SSAData { DateTime = Convert.ToDateTime(arr[0]), Total = Convert.ToDouble(arr[1]) });
                            }
                        }
                        var nee = new List<WaterPredictRecord>();
                        double lastValue = 1;
                        foreach (var item in sSADatas)
                        {
                            if (item.DateTime.Minute == 0)
                            {
                                if (lastValue != 1)
                                {
                                    int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                                    nee.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = item.Total - lastValue });
                                    lastValue = item.Total;
                                }
                                else
                                {
                                    int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                                    nee.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = 0 });
                                    lastValue = item.Total;
                                }
                            }
                        }
                        bll.Inserts(nee);*/
            List<SSAData> sSADatas = new List<SSAData>();
            /* var path = "C:\\Users\\ZKC\\Desktop\\工now.csv";
             int totalLines = File.ReadLines(path, Encoding.GetEncoding("gb2312")).Count();//总行数
             System.IO.FileStream fs = new System.IO.FileStream(path, System.IO.FileMode.Open);
             System.IO.StreamReader sr = new System.IO.StreamReader(fs, Encoding.GetEncoding("gb2312"));
             string tempText;
             //   int line = 0;
             double total = 0;
             for (int i = 0; i < totalLines; i++)
             {
                 tempText = sr.ReadLine();
                 string[] arr = tempText.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                 if (Convert.ToDateTime(arr[0]).Minute == 0)
                 {
                     sSADatas.Add(new SSAData { DateTime = Convert.ToDateTime(arr[0]), Total = Convert.ToDouble(arr[1]) });
                 }
             }
             var nee = new List<WaterPredictRecord>();
             double lastValue = 1;
             foreach (var item in sSADatas)
             {
                 if (item.DateTime.Minute == 0)
                 {
                     if (lastValue != 1)
                     {
                         int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                         nee.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = item.Total - lastValue });
                         lastValue = item.Total;
                     }
                     else
                     {
                         int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                         nee.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = 0 });
                         lastValue = item.Total;
                     }
                 }
             }
             bll.Inserts(nee);*/
            double lastValue = 1;
            var historylist = new List<WaterPredictRecord>();
            var historydata = ConnectHelper.GetByPumpOneDayWaterData(DateTime.Today.AddDays(-15), DateTime.Today, "1h");