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

namespace IWareDataAccess.Car.CAR
{
    public static class CarSqlFunc
    {
        /// <summary>
        /// 搜索表
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static List<CAR_CAR> Search(CarWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<CAR_CAR>();
                //便利所有属性
                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 (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }
                List<CAR_CAR> list = edm.CAR_CAR.Where(f.Compile()).Skip((page - 1) * onePageNum).Take(onePageNum).ToList();

                return list;
            }
        }

        /// <summary>
        /// 搜索视图
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static List<View_CAR_CAR> SearchView(CarWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_CAR_CAR>();
                //便利所有属性
                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 (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

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

                return list;
            }
        }

        /// <summary>
        /// 搜索视图数量
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static int SearchViewNum(CarWebEntity webEntity)
        {
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_CAR_CAR>();
                //便利所有属性
                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 (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

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

                return num;
            }
        }

        /// <summary>
        /// 添加叉车任务
        /// </summary>
        /// <param name="role"></param>
        /// <returns></returns>
        public static bool AddOrUpdate(CarWebEntity webEntity, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {

                CAR_CAR car = new CAR_CAR();
                car = edm.CAR_CAR.FirstOrDefault(x => x.CARNAME == webEntity.carName);
                if (car == null)
                {
                    car = new CAR_CAR();
                }
                car.CARNAME = webEntity.carName ?? car.CARNAME;
                car.CARCODE = webEntity.carCode ?? car.CARCODE;
                SYS_USER user = edm.SYS_USER.FirstOrDefault(x => x.USERNAME == webEntity.userName);
                if (user != null)
                {
                    car.SYS_USER = user;
                }
                CAR_CARTASK carTask = edm.CAR_CARTASK.FirstOrDefault(x => x.CARTASKNAME == webEntity.carTaskName);
                if (car != null)
                {
                    car.CAR_CARTASK = carTask;

                }
                car.STATUS = webEntity.status ?? car.STATUS;
                car.ENABLE = webEntity.enable ?? car.ENABLE;
                car.ISWORK = webEntity.isWork ?? car.ISWORK;
                edm.CAR_CAR.AddOrUpdateExtension(car);
                if (edm.SaveChanges() > 0)
                {
                    return true;
                }
                else
                {
                    msg = "保存失败";
                    return false;
                }
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="webDevice"></param>
        /// <returns></returns>
        public static bool Delete(CarWebEntity webEntity, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {

                CAR_CAR carTask = edm.CAR_CAR.FirstOrDefault(x => x.CARNAME == webEntity.carName);
                if (carTask == null)
                {
                    //无此角色
                    msg = "无此叉车";
                    return false;
                }
                else
                {
                    //edm.BASE_CONTAINER_VS_ITEM.Remove(cvi);
                    carTask.ENABLE = 0;
                    if (edm.SaveChanges() > 0)
                    {
                        return true;
                    }
                    else
                    {
                        msg = "保存失败";
                        return false;
                    }
                }
            }
        }
    }
}