using IStation.ChEr.DAL;
|
using SqlSugar;
|
|
namespace IStation.ChEr.BLL
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public partial class WaterPredict//: IStation.ChEr.DAL.BaseDAL<Entity.WaterPredict>
|
{
|
|
#region Get
|
|
|
/// <summary>
|
/// 查询num条
|
/// </summary>
|
public List<Model.WaterPredict> GetLast (int num)
|
{
|
var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return Entity2Models(db.Queryable<Entity.WaterPredict>().Take(num).ToList());
|
}
|
}
|
|
/// <summary>
|
/// 查询24条
|
/// </summary>
|
public List<Model.WaterPredict> GetLast24()
|
{
|
var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return Entity2Models(db.Queryable<Entity.WaterPredict>().Take(24).ToList());
|
}
|
}
|
/// <summary>
|
/// 查询48条
|
/// </summary>
|
public List<Model.WaterPredict> GetLast48( )
|
{
|
var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return Entity2Models(db.Queryable<Entity.WaterPredict>().Take(48).ToList());
|
}
|
}
|
|
/// <summary>
|
/// 根据 ID 查询
|
/// </summary>
|
public Model.WaterPredict QueryByID(long id)
|
{
|
var ConnectionConfig = ConnectionFactory.MainConnection(DateTime.Now.Year);
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return Entity2Model(db.Queryable<Entity.WaterPredict>().First(x => x.ID == id));
|
}
|
}
|
|
|
|
#endregion Get
|
|
//#region Insert
|
|
///// <summary>
|
///// 插入
|
///// </summary>
|
//public long Insert(Model.WaterPredict model)
|
//{
|
// if (model == null)
|
// return default;
|
// var entity = Model2Entity(model);
|
// var ID = _dal.Insert(entity);
|
// if (ID > 0)
|
// {
|
// UpdateCache(ID);
|
// }
|
// return ID;
|
//}
|
|
///// <summary>
|
///// 批量插入
|
///// </summary>
|
//public bool Inserts(List<Model.WaterPredict> list)
|
//{
|
// if (list == null || list.Count() < 1)
|
// return default;
|
// var entities = Model2Entities(list.ToList());
|
// var Ids = _dal.InsertsR(entities);
|
// if (Ids != null && Ids.Count > 0)
|
// {
|
// UpdateCache(Ids);
|
// return true;
|
// }
|
// return false;
|
//}
|
|
//#endregion Insert
|
|
//#region Update
|
|
///// <summary>
|
///// 更新
|
///// </summary>
|
//public bool Update(Model.WaterPredict model)
|
//{
|
// if (model == null)
|
// return default;
|
// if (model.ID < 1)
|
// return default;
|
// var entity = Model2Entity(model);
|
// var bol = _dal.Update(entity);
|
// if (bol)
|
// {
|
// UpdateCache(model.ID);
|
// }
|
// return bol;
|
//}
|
|
///// <summary>
|
///// 批量更新
|
///// </summary>
|
//public bool Updates(List<Model.WaterPredict> list)
|
//{
|
// if (list == null || list.Count() < 1)
|
// return default;
|
// if (list.ToList().Exists(x => x.ID < 1))
|
// return default;
|
// var entities = Model2Entities(list.ToList());
|
// var bol = _dal.Updates(entities);
|
// if (bol)
|
// {
|
// UpdateCache(list.Select(x => x.ID).ToList());
|
// }
|
// return bol;
|
//}
|
|
//#endregion Update
|
|
//#region Exist
|
|
///// <summary>
|
///// 根据 ID 判断是否存在
|
///// </summary>
|
//public bool IsExistByID(long id)
|
//{
|
// var all = GetAll();
|
// return all.Exists(x => x.ID == id);
|
//}
|
|
//#endregion Exist
|
|
//#region Delete
|
|
///// <summary>
|
///// 根据 ID 删除
|
///// </summary>
|
//public bool DeleteByID(long id, out string msg)
|
//{
|
// msg = string.Empty;
|
// var bol = _dal.DeleteByID(id);
|
// if (bol)
|
// {
|
// RemoveCache(id);
|
// }
|
// return bol;
|
//}
|
|
//#endregion Delete
|
}
|
}
|
