Пример #1
0
        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;
        }