using IWareDataAccess.EF;
using IWareDataAccess.Entity.Alert;
using IWareDataAccess.Helper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace IWareDataAccess.Alert.ALERT
{
    public static class AlertSqlFunc
    {
        /// <summary>
        /// 搜索表
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static List<ALERT_ALERT> Search(AlertWebEntity webEntity, int page, int onePageNum)
        {
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<ALERT_ALERT>();

                //便利所有属性
                Type type = webEntity.GetType();
                foreach (var i in type.GetProperties())
                {
                    object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
                    if (i.PropertyType == typeof(String))
                    {
                        string value;
                        if (v != null)
                        {
                            value = v.ToString();
                            f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
                        }
                    }
                    else if (i.PropertyType == typeof(DateTime?))
                    {
                        if (v != null)
                        {
                            DateTime value = DateTime.Parse(v.ToString());
                            if (i.Name == "createTimeStart")
                            {
                                f = f.And(x => x.CREATETIME > value);
                            }
                            if (i.Name == "createTimeEnd")
                            {
                                f = f.And(x => x.CREATETIME < value);
                            }

                            if (i.Name == "finishTimeStart")
                            {
                                f = f.And(x => x.FINISHTIME > value);
                            }
                            if (i.Name == "finishTimeEnd")
                            {
                                f = f.And(x => x.FINISHTIME < value);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

                List<ALERT_ALERT> list = edm.ALERT_ALERT.OrderByDescending(x=>x.CREATETIME).Where(f.Compile()).Skip((page - 1) * onePageNum).Take(onePageNum).ToList();

                return list;
            }
        }

        /// <summary>
        /// 搜索(视图)
        /// </summary>
        public static List<View_ALERT_ALERT> SearchView(AlertWebEntity webEntity, int page, int onePageNum,out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_ALERT_ALERT>();

                //便利所有属性
                Type type = webEntity.GetType();
                foreach (var i in type.GetProperties())
                {
                    object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
                    if (i.PropertyType == typeof(String))
                    {
                        string value;
                        if (v != null)
                        {
                            value = v.ToString();
                            f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
                        }
                    }
                    else if (i.PropertyType == typeof(DateTime?))
                    {
                        if (v != null)
                        {
                            DateTime value = DateTime.Parse(v.ToString());
                            if (i.Name == "createTimeStart")
                            {
                                f = f.And(x => x.createTime > value);
                            }
                            if (i.Name == "createTimeEnd")
                            {
                                f = f.And(x => x.createTime < value);
                            }

                            if (i.Name == "finishTimeStart")
                            {
                                f = f.And(x => x.finishTime > value);
                            }
                            if (i.Name == "finishTimeEnd")
                            {
                                f = f.And(x => x.finishTime < value);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

                List<View_ALERT_ALERT> list = edm.View_ALERT_ALERT.OrderByDescending(x=>x.createTime).Where(f.Compile()).Skip((page - 1) * onePageNum).Take(onePageNum).ToList();

                return list;
            }
        }

        /// <summary>
        /// 搜索数量(视图)
        /// </summary>
        public static int SearchViewNum(AlertWebEntity webEntity)
        {
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_ALERT_ALERT>();

                //便利所有属性
                Type type = webEntity.GetType();
                foreach (var i in type.GetProperties())
                {
                    object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
                    if (i.PropertyType == typeof(String))
                    {
                        string value;
                        if (v != null)
                        {
                            value = v.ToString();
                            f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
                        }
                    }
                    else if (i.PropertyType == typeof(DateTime?))
                    {
                        if (v != null)
                        {
                            DateTime value = DateTime.Parse(v.ToString());
                            if (i.Name == "createTimeStart")
                            {
                                f = f.And(x => x.createTime > value);
                            }
                            if (i.Name == "createTimeEnd")
                            {
                                f = f.And(x => x.createTime < value);
                            }

                            if (i.Name == "finishTimeStart")
                            {
                                f = f.And(x => x.finishTime > value);
                            }
                            if (i.Name == "finishTimeEnd")
                            {
                                f = f.And(x => x.finishTime < value);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

                int num = edm.View_ALERT_ALERT.Where(f.Compile()).Count();

                return num;
            }
        }

        /// <summary>
        /// 添加修改
        /// </summary>
        /// <returns></returns>
        public static bool AddOrUpdate(AlertWebEntity webAlert, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                //查询是否已存在此故障
                ALERT_ALERT alert = edm.ALERT_ALERT.FirstOrDefault(x => x.ALERTCODE == webAlert.alertCode);
                if (alert == null)
                {
                    //无此故障，属于新建
                    alert = new ALERT_ALERT();
                    alert.CREATETIME = DateTime.Now;
                    alert.ALERTCODE = webAlert.alertCode ?? alert.ALERTCODE;
                }
                else
                {
                    alert.FINISHTIME = DateTime.Now;

                    System.TimeSpan time = alert.FINISHTIME.Value - alert.CREATETIME.Value;  //两个时间相减 。默认得到的是 两个时间之间的天数   得到：365.00:00:00 
                    double getMinutes = time.TotalMinutes; //将这个天数转换成小时, 返回值是double类型的 
                    alert.TOTALTIME = (int)getMinutes;
                }
                alert.ALERTNAME = webAlert.alertName?? alert.ALERTNAME;
                alert.ALERTDES = webAlert.alertDes ?? alert.ALERTDES;
                //绑定设备
                BASE_DEVICE device = edm.BASE_DEVICE.FirstOrDefault(x => x.DEVICENAME == webAlert.deviceName);
                if (device != null)
                {
                    alert.BASE_DEVICE = device;
                }
                
                edm.ALERT_ALERT.AddOrUpdateExtension(alert);
                if (edm.SaveChanges() > 0)
                {
                    return true;
                }
                else
                {
                    msg = "修改失败";
                    return false;
                }
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="webUser"></param>
        /// <returns></returns>
        public static bool Delete(AlertWebEntity webUser, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                //查询是否已存在此用户
                ALERT_ALERT alert = edm.ALERT_ALERT.FirstOrDefault(x => x.ALERTCODE == webUser.alertCode);
                if (alert == null)
                {
                    //无此用户，错误
                    msg = "无此故障";
                    return false;
                }
                else
                {
                    edm.ALERT_ALERT.Remove(alert);
                    if (edm.SaveChanges() > 0)
                    {
                        return true;
                    }
                    else
                    {
                        msg = "保存失败";
                        return false;
                    }
                }
            }
        }

        /// <summary>
        /// 获取组盘号
        /// </summary>
        /// <returns></returns>
        public static string GetCode()
        {
            using (Model edm = new Model())
            {
                string month = DateTime.Now.Month.ToString("00");
                string day = DateTime.Now.Day.ToString("00");
                string hour = DateTime.Now.Hour.ToString("00");
                string minute = DateTime.Now.Minute.ToString("00");
                string second = DateTime.Now.Second.ToString("00");
                string millSecond = DateTime.Now.Millisecond.ToString("0000");
                string time = DateTime.Now.Year.ToString() + month + day + hour + minute + second + millSecond;
                return "AL" + time;
            }
        }

        /// <summary>
        /// 获取所有设备报警信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static List<View_ALERT_ALERT> GetAllAlarmInfo(AlertWebEntity model)
        {

            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_ALERT_ALERT>();

                //便利所有属性
                Type type = model.GetType();
                foreach (var i in type.GetProperties())
                {
                    object v = Helper.Helper.GetFieldValueByName(model, i.Name);
                    if (i.PropertyType == typeof(String))
                    {
                        string value;
                        if (v != null)
                        {
                            value = v.ToString();
                            f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
                        }
                    }
                    else if (i.PropertyType == typeof(DateTime?))
                    {
                        if (v != null)
                        {
                            DateTime value = DateTime.Parse(v.ToString());
                            if (i.Name == "createTimeStart")
                            {
                                f = f.And(x => x.createTime > value);
                            }
                            if (i.Name == "createTimeEnd")
                            {
                                f = f.And(x => x.createTime < value);
                            }

                            if (i.Name == "finishTimeStart")
                            {
                                f = f.And(x => x.finishTime > value);
                            }
                            if (i.Name == "finishTimeEnd")
                            {
                                f = f.And(x => x.finishTime < value);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

                List<View_ALERT_ALERT> list = edm.View_ALERT_ALERT.OrderByDescending(x => x.createTime).Where(f.Compile()).ToList();

                return list;
            }
        }
    }
}