提交临时代码

duheng

2024-05-13 af447e8f2a28cd775bb8bd345ee59dbd575beb47

 WaterPredict/IStation.ChEr.DAL.WaterPredict/BLL/WaterPredict.cs

@@ -4,18 +4,16 @@
namespace IStation.ChEr.BLL
{
    /// <summary>
    ///  
    ///
    /// </summary>
    public partial class WaterPredictRecord 
    public partial class WaterPredictRecord
    {

        #region Get
 

        /// <summary>
        ///  查询num条
        /// </summary>
        public List<Model.WaterPredictRecord> GetLast (int num)
        public List<Model.WaterPredictRecord> GetLast(int num)
        {
            var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
@@ -36,10 +34,11 @@
                return Entity2Models(db.Queryable<Entity.WaterPredictRecord>().Take(24).ToList());
            }
        }

        /// <summary>
        ///  查询48条
        /// </summary>
        public List<Model.WaterPredictRecord> GetLast48( )
        public List<Model.WaterPredictRecord> GetLast48()
        {
            var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
@@ -51,7 +50,7 @@
        /// <summary>
        /// 根据 ID 查询
        /// </summary>
        public   Model.WaterPredictRecord QueryByID(long id)
        public Model.WaterPredictRecord QueryByID(long id)
        {
            var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
@@ -60,10 +59,17 @@
            }
        }


        //找出最近数据
        public List<Model.WaterPredictRecord> GerEnd2Days(int num)
        {
            var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return Entity2Models(db.Queryable<Entity.WaterPredictRecord>().OrderBy(x => x.DayHour, OrderByType.Desc).Take(num).ToList());
            }
        }

        #endregion Get


        /// <summary>
        /// 批量设置:每次更新23条, 添加1条
@@ -89,25 +95,20 @@
                //更新滚动数据
                if (update_models != null)
                {
                    foreach(var model in update_models)
                    foreach (var model in update_models)
                    {
                        Entity.WaterPredictRecord t = new Entity.WaterPredictRecord();
                        t.ID = model.ID;
                        t.LastPredictValue = model.LastPredictValue;
                        t.LastPredictTime = DateTime.Now;

                        db.Updateable<Entity.WaterPredictRecord>(t).UpdateColumns(t => new { t.LastPredictValue, t.LastPredictTime }).Where(t => t.ID == model.ID).ExecuteCommand();
                        t.PredictValueList = model.PredictValueList;
                        db.Updateable<Entity.WaterPredictRecord>(t).UpdateColumns(t => new { t.LastPredictValue, t.LastPredictTime, t.PredictValueList }).Where(t => t.ID == model.ID).ExecuteCommand();
                    }
                }

          
            }



            return true;
        }


        #region Insert

@@ -139,7 +140,9 @@
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Insertable(list).ExecuteReturnSnowflakeIdList().Count() > 0;
            } 
                // db.Insertable(entities).ExecuteCommand();
                //return true;
            }
        }

        #endregion Insert
@@ -160,7 +163,7 @@
            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
            {
                return db.Updateable(entity).ExecuteCommand() > 0;
            } 
            }
        }

        /// <summary>
@@ -180,9 +183,6 @@
        }

        #endregion Update




        #region Delete