文件遗漏

tangxu

2024-05-13 d662c08aee9ea241eb5ef89e60eee704667ca47c

文件遗漏

 DAL/IStation.DAL.Project/DAL/WaterPredictRecord.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,68 @@
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;

namespace IStation.DAL
{
    public class WaterPredictRecord
    {

        static Dictionary<int, ConnectionConfig> _connectionConfigDict = new Dictionary<int, ConnectionConfig>();
        public static ISqlSugarClient CreateConnection(int year)
        {
            if (_connectionConfigDict.ContainsKey(year))
            {
                return new SqlSugarClient(_connectionConfigDict[year]);
            }

            var root_directory = System.Configuration.ConfigurationManager.AppSettings["WaterPredictDsPath"];
            if (System.IO.File.Exists(root_directory) || !System.IO.Directory.Exists(root_directory))
            {
                throw new Exception($"缺少WaterPredictDsPath配置");
            }
            var dsName = string.Format("WaterPredict{0}.db", year);

            var filePath = Path.Combine(root_directory,  dsName);
            if (!System.IO.File.Exists(filePath))
            {
                throw new Exception($"缺少db文件:"+ dsName);
            }

            var connectionConfig = new ConnectionConfig()
            {
                DbType = SqlSugar.DbType.Sqlite,
                ConnectionString = "Data Source=" + filePath,// + ";Version=3;",
                IsAutoCloseConnection = true,//是否自动关闭
            };

            _connectionConfigDict[year] = connectionConfig;
            ISqlSugarClient conn = new SqlSugarClient(connectionConfig);
            return conn;
        }



        #region Query

        /// <summary>
        ///  æŸ¥è¯¢num条
        /// </summary>
        public List<IStation.Model.WaterPredictRecord> GetLast(int num)
        {
            using (ISqlSugarClient db = CreateConnection(DateTime.Now.Year))
            {
                return db.Queryable<IStation.Model.WaterPredictRecord>().Take(num).ToList(); 
            }
        }




        #endregion
 
    }
}

 Model/IStation.Model.Basic/waterLevel/WaterPredictRecord.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,73 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace IStation.Model
{
    /// <summary>
    /// 
    /// </summary>
    public class WaterPredictRecord //: Model.BaseModel, System.ICloneable
    {
        /// <summary>
        /// 
        /// </summary>
        public WaterPredictRecord()  { }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="rhs"></param>
        public WaterPredictRecord(WaterPredictRecord rhs)  
        {
            this.ID = rhs.ID;
            this.DayHour = rhs.DayHour;
            this.LastPredictValue = rhs.LastPredictValue;
            this.RealValue = rhs.RealValue;
            this.LastPredictTime = rhs.LastPredictTime;

            this.PredictValueList = rhs.PredictValueList;
            this.PredictTime = rhs.PredictTime;
        }

        /// <summary>
        /// id
        /// </summary>
        public   long ID { get; set; }

        /// <summary>
        /// å°æ—¶: ä¾‹å¦‚2024-05-14 01:00 è¡¨ç¤ºä¸º 051401
        /// </summary>
        public int DayHour { get; set; }

        /// <summary>
        /// çœŸå®žç´¯è®¡æµé‡
        /// </summary>
        public double RealValue { get; set; }

        /// <summary>
        /// æœ€æ–°é¢„测流量(滚动值)
        /// </summary>
        public double LastPredictValue { get; set; }

        /// <summary>
        /// æœ€æ–°é¢„测时间(滚动值对应时间)
        /// </summary>
        public DateTime LastPredictTime { get; set; }

        /// <summary>
        /// é¢„测流量值(多个用逗号隔开)
        /// </summary>
        public string PredictValueList { get; set; }

        /// <summary>
        /// é¢„测流量值时间:PredictValueList对应时间
        /// </summary>
        public DateTime PredictTime { get; set; }


 
 
    }
}