/// <summary> /// 插入C/T日志 /// </summary> /// <param name="obj"></param> /// <returns></returns> public int Insert(CT_Log obj) { try { int id = PostgreHelper.InsertSingleEntity <CT_Log>(obj); return(id); } catch (Exception ex) { throw ex; } }
public CT_Log SelectNewsLog(string machine_code, string ts) { try { string comm = "select * from fimp.ct_log where machine_code='{0}' order by insert_time desc limit 1"; CT_Log ctlog = PostgreHelper.GetSingleEntity <CT_Log>(comm); return(ctlog); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查找最近的一笔记录 /// </summary> /// <param name="device_code"></param> /// <param name="tag_code"></param> /// <param name="value"></param> /// <returns></returns> public CT_Log SelectLatestLog(string device_code, string tag_code, DateTime datetime, int value) { try { string comm; comm = "select * from fimp.ct_log where machine_code='{0}' and tag_code='{1}' and insert_time<'{2}' and value='{3}' order by insert_time desc limit 1"; comm = string.Format(comm, device_code, tag_code, datetime, value); CT_Log ctlog = PostgreHelper.GetSingleEntity <CT_Log>(comm); return(ctlog); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查找最近的一笔记录 /// </summary> /// <param name="device_code"></param> /// <param name="tag_code"></param> /// <param name="value"></param> /// <returns></returns> public CT_Log SelectLatestLog(string device_code, string tag_code, int value = -1, DateTime start_time = default(DateTime)) { try { string comm; if (start_time > default(DateTime) || start_time > Convert.ToDateTime("2001-01-01")) { if (value >= 0) { comm = "select * from fimp.ct_log where machine_code='{0}' and tag_code='{1}' and value='{2}' and insert_time>='{3}' order by insert_time desc limit 1"; comm = string.Format(comm, device_code, tag_code, value, start_time); } else { comm = "select * from fimp.ct_log where machine_code='{0}' and tag_code='{1}' and insert_time>='{2}' order by insert_time desc limit 1"; comm = string.Format(comm, device_code, tag_code, start_time); } } else { if (value >= 0) { comm = "select * from fimp.ct_log where machine_code='{0}' and tag_code='{1}' and value='{2}' order by insert_time desc limit 1"; comm = string.Format(comm, device_code, tag_code, value); } else { comm = "select * from fimp.ct_log where machine_code='{0}' and tag_code='{1}' order by insert_time desc limit 1"; comm = string.Format(comm, device_code, tag_code); } } CT_Log ctlog = PostgreHelper.GetSingleEntity <CT_Log>(comm); return(ctlog); } catch (Exception ex) { throw ex; } }
public int Insert(CT_Log obj) { int count = ctlog.Insert(obj); return(count); }
/// <summary> /// 查找最近一笔日志记录 /// </summary> /// <param name="device_code"></param> /// <param name="tag_code"></param> /// <param name="value">=-1的时候不按照值查询</param> /// <returns></returns> public CT_Log SelectLatestLog(string device_code, string tag_code, DateTime datetime, int value) { CT_Log ct = ctlog.SelectLatestLog(device_code, tag_code, datetime, value); return(ct); }
/// <summary> /// 查找最近一笔日志记录 /// </summary> /// <param name="device_code"></param> /// <param name="tag_code"></param> /// <param name="value">=-1的时候不按照值查询</param> /// <param name="start_time">开始查询的时间范围</param> /// <returns></returns> public CT_Log SelectLatestLog(string device_code, string tag_code, int value = -1, DateTime start_time = default(DateTime)) { CT_Log ct = ctlog.SelectLatestLog(device_code, tag_code, value, start_time); return(ct); }
public CT_Log SelectNewsLog(string machine_code, string ts) { CT_Log ct = ctlog.SelectNewsLog(machine_code, ts); return(ct); }