/// <summary>
/// 显示历史数据
/// </summary>
/// <param name="dtStart">开始时间</param>
/// <param name="dtEnd">结束时间</param>
private void ShowLog(DateTime dtStart, DateTime dtEnd)
{
using (GISContext context = new GISContext())
{
var logs = context.Infoes.Where(info => info.Time >= dtStart && info.Time <= dtEnd).OrderByDescending(x => x.Id);
if (logs == null || logs.Count() == 0)
{
MessageBox.Show("没有该数据!");
this.Close();
}
dataLogs.Rows.Clear();
foreach (var log in logs)
{
var row = new DataGridViewRow();
row.CreateCells(dataLogs);
row.Cells[0].Value = log.Temp;
row.Cells[1].Value = log.NH3;
row.Cells[2].Value = log.Light;
row.Cells[3].Value = log.Hum;
row.Cells[4].Value = log.Time;
dataLogs.Rows.Add(row);
}
}
}
public GISController(GISContext context)
{
_context = context;
if (_context.GISItems.Count() == 0)
{
// Create a new GISItem if collection is empty,
// which means you can't delete all GISItems.
_context.SaveChanges();
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="info">元数据</param>
public void SaveData(Info info)
{
using (GISContext context = new GISContext())
{
try
{
context.Infoes.Add(info);
context.SaveChanges();
this.ShowMsg("保存数据成功!");
}
catch (Exception ex)
{
this.ShowMsg("保存数据失败! " + ex.Message);
}
}
}
/// <summary>
/// 初始化数据库
/// </summary>
private void InitDB()
{
using (GISContext context = new GISContext())
{
this.ShowMsg("正在迁移数据库,请稍后...");
// 迁移数据库
context.Database.Migrate();
try
{
// 初始化数据
if (!context.Users.Any())
{
List <User> users = new List <User>();
for (int i = 0; i < 9; i++)
{
users.Add(new User {
UserName = "******" + (i + 1), Password = "******".Encryption("00" + (i + 1))
});
}
context.Users.AddRange(users);
context.SaveChanges();
}
this.ShowMsg("数据库迁移成功!");
LogHelper.MigrateDbOk();
}
catch (Exception e)
{
this.ShowMsg("数据库迁移失败! " + e.Message);
this.ShowMsg("遇到大麻烦了。。。。。。。。。");
}
}
}
public InfoModel(GISContext context)
{
_context = context;
}
public BaseRepository(GISContext contextParam)
{
Context = contextParam;
}
public LoginModel(GISContext context)
{
_context = context;
}