using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Reflection;
using System.Text;

namespace M423project
{
    public class WarningData : IDisposable
    {
        private SqlConnection connection;
        public WarningData()
        {
            string connStr = ConfigurationManager.AppSettings["connectionString"];
            connection = new SqlConnection(connStr);
            try
            {
                connection.Open();
            }
            catch (Exception)
            {
                CommonUtil.WriteLog(LogType.Err, "连接数据库失败！");
            }
        }

        public void Dispose()
        {
            connection.Close();
        }

        public void SaveWarning(int type)
        {
            lock (this)
            {
                StringBuilder sb = new StringBuilder();
                sb.AppendFormat(@"INSERT INTO Warning (Type,Time) VALUES('{0}','{1}')",
                    type, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                using (SqlCommand cmd = new SqlCommand(sb.ToString(), connection))
                {
                    cmd.ExecuteNonQuery();
                }
            }
        }

        public void UpdateWarning()
        {
            lock (this)
            {
                StringBuilder sb = new StringBuilder();
                sb.AppendFormat(@"UPDATE Warning SET ClearTime='{0}' WHERE ID=(SELECT TOP 1 ID FROM Warning ORDER BY TIME DESC) AND ClearTime IS NULL", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                using (SqlCommand cmd = new SqlCommand(sb.ToString(), connection))
                {
                    cmd.ExecuteNonQuery();
                }
            }
        }

        public List<WarningConfigure> GetWarningType(int? val)
        {
            List<WarningConfigure> list = new List<WarningConfigure>();
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat(@"SELECT * FROM WarningConfigure WHERE 1=1");
            if (val != null)
            {
                sql.AppendFormat(@" AND Val={0}", val.Value);
            }
            DataTable dt = new DataTable();
            using (SqlCommand cmd = new SqlCommand(sql.ToString(), connection))
            {
                SqlDataReader dr = cmd.ExecuteReader();
                dt.Load(dr);
            }
            if (dt.Rows.Count > 0)
            {
                list = DataConvertFill<WarningConfigure>.SetValueListObject(dt);
            }
            return list;
        }

        public static List<EnumEntity> GetEnumList(Type enumType)
        {
            var pairs = new List<EnumEntity>();
            var values = Enum.GetValues(enumType);
            foreach (var value in values)
            {
                var name = Enum.GetName(enumType, value);
                var field = enumType.GetField(name);
                var attribute = Attribute.GetCustomAttribute(field, typeof(DescriptionAttribute)) as DescriptionAttribute;
                pairs.Add(new EnumEntity()
                {
                    Name = name,
                    Value = Convert.ToInt32(value),
                    Description = attribute == null ? null : attribute.Description
                });
            }

            return pairs;
        }

        public void CleanData()
        {
            StringBuilder sb = new StringBuilder();
            sb.AppendFormat(@"delete from Warning
                            where DATEDIFF(DAY,Time,GETDATE())>40");
            using (SqlCommand cmd = new SqlCommand(sb.ToString(), connection))
            {
                cmd.ExecuteNonQuery();
            }

        }
    }

    public class WarningConfigure
    {
        /// <summary>
        /// 主键
        /// </summary>
        public int Val { get; set; }

        /// <summary>
        /// 类型(1-报警 2-警告)
        /// </summary>
        public int Type { get; set; }

        /// <summary>
        /// 警告内容
        /// </summary>
        public string Content { get; set; }

        /// <summary>
        /// 解决方法
        /// </summary>
        public string Solution { get; set; }
    }

    public class Warning
    {
        /// <summary>
        /// 主键ID
        /// </summary>
        public int ID { get; set; }

        /// <summary>
        /// 类型
        /// </summary>
        public int Type { get; set; }

        /// <summary>
        /// 报警时间
        /// </summary>
        public DateTime Time { get; set; }

        /// <summary>
        /// 警报清除时间
        /// </summary>
        public DateTime? ClearTime { get; set; }
    }

    public class ComboboxItem
    {
        public int Key { get; set; }

        public string Value { get; set; }
    }

    public class EnumEntity
    {
        public string Name { get; set; }

        public int Value { get; set; }

        public string Description { get; set; }

        public override string ToString()
        {
            return Description;
        }
    }

    public class DataConvertFill<T> where T : new()
    {
        public static List<T> SetValueListObject(DataTable dt)
        {
            if (dt == null || dt.Rows.Count <= 0)
            {
                return null;
            }
            List<T> lst = new List<T>();
            foreach (DataRow dr in dt.Rows)
            {
                T t = new T();
                System.Reflection.PropertyInfo property1 = t.GetType().GetProperty("SerialNumber",
                 BindingFlags.Public | BindingFlags.Instance | BindingFlags.IgnoreCase);
                if (null != property1)
                {
                    property1.SetValue(t, lst.Count + 1, null);
                }
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    System.Reflection.PropertyInfo property = t.GetType().GetProperty(dt.Columns[i].ColumnName,
                        BindingFlags.Public | BindingFlags.Instance | BindingFlags.IgnoreCase);
                    if (null == property)
                        continue;
                    switch (property.PropertyType.ToString())
                    {
                        case "System.Int16":
                        case "System.Nullable`1[System.Int16]":
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? Int16.MinValue : Convert.ToInt16(dr[i].ToString()), null);
                            break;
                        case "System.Int32":
                        case "System.Nullable`1[System.Int32]":
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? Int32.MinValue : Convert.ToInt32(dr[i].ToString()), null);

                            break;
                        case "System.Int64":
                        case "System.Nullable`1[System.Int64]":
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? Int64.MinValue : (string.IsNullOrEmpty(Convert.ToString(dr[i])) ? 0 : Convert.ToInt64(dr[i])), null);
                            break;
                        case "System.Decimal":
                        case "System.Nullable`1[System.Decimal]":
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? 0 : Convert.ToDecimal(dr[i]), null);
                            break;
                        case "System.DateTime":
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? default(DateTime) : Convert.ToDateTime(dr[i]), null);
                            break;
                        case "System.Boolean":
                        case "bool":
                        case "System.Nullable`1[System.Boolean]":
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? false : Convert.ToBoolean(dr[i]), null);
                            break;
                        case "System.Nullable`1[System.DateTime]":
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? DateTime.MinValue : Convert.ToDateTime(dr[i]), null);
                            break;
                        default:
                            property.SetValue(t, (dr[i] is System.DBNull || string.IsNullOrEmpty(dr[i].ToString())) ? string.Empty : dr[i], null);
                            break;
                    }
                }
                lst.Add(t);
            }
            return lst;
        }
    }
}