private void ViewDetail(AlarmRecordItem item)
{
this.NavigationService.Navigate(new HistoryAlarmDetailPage()
{
AlarmRecordDID = item.AlarmDid
});
}
/// <summary>
/// 获取历史报警记录
/// </summary>
/// <param name="keyword"></param>
/// <param name="alarmDateStart"></param>
/// <param name="alarmDateEnd"></param>
/// <param name="pageNo"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public IPagedList <AlarmRecordItem> GetPagedAlarmRecords(string keyword, DateTime?alarmDateStart, DateTime?alarmDateEnd, int pageNo, int pageSize, int CraftDID)
{
string connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=root;Persist Security Info=True;Charset=utf8;";
MySqlConnection connatl = new MySqlConnection(connectionString_ATL);
connatl.Open();
string sql = string.Format(@"select
temp.报警时间
, temp.报警内容
, temp.dispose_time
, temp.craft_name
, temp.duration
, temp.alarm_record_did
from alarm_table temp");
string w1 = " where temp.报警内容 like '%" + keyword + "%'";
string w2 = alarmDateStart.HasValue ? " and temp.报警时间 >= '" + alarmDateStart.Value.ToString() + "' " : "";
string w3 = alarmDateStart.HasValue ? " and temp.报警时间 < '" + alarmDateStart.Value.AddDays(1.0).ToString() + "' " : "";
string w4 = " order by temp.报警时间 DESC";
MySqlDataAdapter b = new MySqlDataAdapter(sql + w1 + w2 + w3 + w4, connatl);
DataTable bt = new DataTable();
connatl.Close();
b.Fill(bt);
List <AlarmRecordItem> lstAlarmRecord = new List <AlarmRecordItem>();
if (bt != null && bt.Rows.Count > 0)
{
foreach (DataRow row in bt.Rows)
{
AlarmRecordItem item = new AlarmRecordItem();
item.RuleDID = "701";
item.AlarmTime = DateTime.Parse(row[0].ToString());
item.AlarmContent = row[1].ToString();
item.DisposeTime = DateTime.Parse(row[2].ToString());
item.CraftName = row[3].ToString();
item.Duration = int.Parse(row[4].ToString());
item.AlarmDid = int.Parse(row[5].ToString());
lstAlarmRecord.Add(item);
}
}
IQueryable <AlarmRecordItem> superset = lstAlarmRecord.AsQueryable();
return(new PagedList <AlarmRecordItem>(superset, pageNo, pageSize));
}
