public bool Delete(Room value) { bool result = false; MachineHibernate machineHibernate = new MachineHibernate(); result = machineHibernate.DeleteByRoom(value.Guid); DatabaseHibernate hibernate = new DatabaseHibernate(); List<Parameter> parameters = new List<Parameter>(); if (result) { string sql = string.Format("delete from e_user_room as t where [t].[room_id] = '{0}'", value.Guid); parameters.Clear(); result = hibernate.Write(Variable.Link, sql, parameters); } if (result) { string sql = string.Format("delete from e_room as t where [t].[guid] = '{0}'", value.Guid); parameters.Clear(); result = hibernate.Write(Variable.Link, sql, parameters); } return result; }
public List<Machine> QueryByRoom(string roomId) { List<Machine> results = new List<Machine>(); MachineHibernate hibernate = new MachineHibernate(); results = hibernate.QueryByRoom(roomId); return results; }
public Machine QueryByNameOrIp(string name, string roomId, string ip) { Machine result = null; MachineHibernate hibernate = new MachineHibernate(); result = hibernate.QueryByNameOrIp(name, roomId, ip); return result; }
public Machine QueryByIp(string ip) { Machine result = null; MachineHibernate hibernate = new MachineHibernate(); result = hibernate.QueryByIp(ip); return result; }
public Machine QueryByGuid(string guid) { Machine result = null; MachineHibernate hibernate = new MachineHibernate(); result = hibernate.QueryByGuid(guid); return result; }
/// <summary> /// 增加 /// </summary> /// <param name="value">值</param> /// <returns>结果</returns> public bool Insert(Machine value) { bool result = false; MachineHibernate hibernate = new MachineHibernate(); result = hibernate.Insert(value); return result; }
public bool Delete(Machine value) { bool result = false; MachineHibernate hibernate = new MachineHibernate(); result = hibernate.Delete(value); return result; }
/// <summary> /// 解析数据 /// </summary> /// <param name="values">数据集合</param> /// <returns>探头集合</returns> public List<Detector> ParseDataCache(List<object[]> values) { List<Detector> results = new List<Detector>(); if (values != null) { int total = 0; MachineHibernate machineHibernate = new MachineHibernate(); List<Machine> machines = machineHibernate.Query(1, int.MaxValue, ref total); DetectorTypeHibernate detectorTypeHibernate = new DetectorTypeHibernate(); List<DetectorType> detectorTypes = detectorTypeHibernate.Query(1, int.MaxValue, ref total); for (int i = 0; i < values.Count; i++) { Detector value = this.ParseDataCache(values[i], machines, detectorTypes); results.Add(value); } } return results; }