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

namespace IWareDataAccess.Task.TASK
{
    public class SrmRecordSqlFunc
    {   /// <summary>
        /// 搜索表
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static List<TASK_SRMRECORD> Search(SrmRecordWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<TASK_SRMRECORD>();
                //便利所有属性
                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);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }
                List<TASK_SRMRECORD> list = edm.TASK_SRMRECORD.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_TASK_SRMRECORD> SearchView(SrmRecordWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_TASK_SRMRECORD>();
                //便利所有属性
                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();
                            //特殊处理
                            if (i.Name == "taskType")
                            {
                                if (value == "移库")
                                {
                                    f = f.And(x => (x.useSrmId == 1 && x.toPlace != "02-01-01" && x.sourcePlace != "01-01-01" && x.toPlace != "01-19-01" && x.sourcePlace != "02-19-01") || x.useSrmId != 1);
                                    f = f.And(x => (x.useSrmId == 2 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-20-01" && x.sourcePlace != "03-20-01") || x.useSrmId != 2);
                                    f = f.And(x => (x.useSrmId == 3 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-19-01" && x.sourcePlace != "03-19-01") || x.useSrmId != 3);
                                    f = f.And(x => (x.useSrmId == 4 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-21-01" && x.sourcePlace != "03-21-01") || x.useSrmId != 4);
                                    f = f.And(x => (x.useSrmId == 5 && x.toPlace != "02-01-01" && x.sourcePlace != "01-01-01" && x.toPlace != "01-20-01" && x.sourcePlace != "02-20-01") || x.useSrmId != 5);
                                    f = f.And(x => (x.useSrmId == 6 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-20-01" && x.sourcePlace != "03-20-01") || x.useSrmId != 6);
                                    f = f.And(x => (x.useSrmId == 7 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-24-01" && x.sourcePlace != "03-24-01") || x.useSrmId != 7);
                                    f = f.And(x => (x.useSrmId == 8 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-25-01" && x.sourcePlace != "03-25-01") || x.useSrmId != 8);
                                    f = f.And(x => (x.useSrmId == 9 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-23-01" && x.sourcePlace != "03-23-01") || x.useSrmId != 9);
                                }
                            }
                            else
                            {
                                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);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

                List<View_TASK_SRMRECORD> list = edm.View_TASK_SRMRECORD.OrderByDescending(x => x.createTime).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_TASK_SRMRECORD> SearchViewAll(SrmRecordWebEntity webEntity, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_TASK_SRMRECORD>();
                //便利所有属性
                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();
                            //特殊处理
                            if (i.Name == "taskType")
                            {
                                if (value == "移库")
                                {
                                    f = f.And(x => (x.useSrmId == 1 && x.toPlace != "02-01-01" && x.sourcePlace != "01-01-01" && x.toPlace != "01-19-01" && x.sourcePlace != "02-19-01") || x.useSrmId != 1);
                                    f = f.And(x => (x.useSrmId == 2 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-20-01" && x.sourcePlace != "03-20-01") || x.useSrmId != 2);
                                    f = f.And(x => (x.useSrmId == 3 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-19-01" && x.sourcePlace != "03-19-01") || x.useSrmId != 3);
                                    f = f.And(x => (x.useSrmId == 4 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-21-01" && x.sourcePlace != "03-21-01") || x.useSrmId != 4);
                                    f = f.And(x => (x.useSrmId == 5 && x.toPlace != "02-01-01" && x.sourcePlace != "01-01-01" && x.toPlace != "01-20-01" && x.sourcePlace != "02-20-01") || x.useSrmId != 5);
                                    f = f.And(x => (x.useSrmId == 6 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-20-01" && x.sourcePlace != "03-20-01") || x.useSrmId != 6);
                                    f = f.And(x => (x.useSrmId == 7 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-24-01" && x.sourcePlace != "03-24-01") || x.useSrmId != 7);
                                    f = f.And(x => (x.useSrmId == 8 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-25-01" && x.sourcePlace != "03-25-01") || x.useSrmId != 8);
                                    f = f.And(x => (x.useSrmId == 9 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-23-01" && x.sourcePlace != "03-23-01") || x.useSrmId != 9);
                                }
                            }
                            else
                            {
                                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);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

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

                return list;
            }
        }

        /// <summary>
        /// 搜索视图
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static int SearchViewNum(SrmRecordWebEntity webEntity)
        {
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_TASK_SRMRECORD>();
                //便利所有属性
                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(); //特殊处理
                            if (i.Name == "taskType")
                            {
                                if (value == "移库")
                                {
                                    f = f.And(x => (x.useSrmId == 1 && x.toPlace != "02-01-01" && x.sourcePlace != "01-01-01" && x.toPlace != "01-19-01" && x.sourcePlace != "02-19-01") || x.useSrmId != 1);
                                    f = f.And(x => (x.useSrmId == 2 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-20-01" && x.sourcePlace != "03-20-01") || x.useSrmId != 2);
                                    f = f.And(x => (x.useSrmId == 3 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-19-01" && x.sourcePlace != "03-19-01") || x.useSrmId != 3);
                                    f = f.And(x => (x.useSrmId == 4 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-21-01" && x.sourcePlace != "03-21-01") || x.useSrmId != 4);
                                    f = f.And(x => (x.useSrmId == 5 && x.toPlace != "02-01-01" && x.sourcePlace != "01-01-01" && x.toPlace != "01-20-01" && x.sourcePlace != "02-20-01") || x.useSrmId != 5);
                                    f = f.And(x => (x.useSrmId == 6 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-20-01" && x.sourcePlace != "03-20-01") || x.useSrmId != 6);
                                    f = f.And(x => (x.useSrmId == 7 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-24-01" && x.sourcePlace != "03-24-01") || x.useSrmId != 7);
                                    f = f.And(x => (x.useSrmId == 8 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-25-01" && x.sourcePlace != "03-25-01") || x.useSrmId != 8);
                                    f = f.And(x => (x.useSrmId == 9 && x.toPlace != "03-01-01" && x.sourcePlace != "02-01-01" && x.toPlace != "02-23-01" && x.sourcePlace != "03-23-01") || x.useSrmId != 9);
                                }
                            }
                            else
                            {
                                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);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

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

                return num;
            }
        }



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

                var task = edm.TASK_SRMRECORD.FirstOrDefault(x => x.id == webEntity.id);
                if (task == null)
                {
                    //无此角色
                    msg = "无此任务";
                    return false;
                }
                else
                {
                    edm.TASK_SRMRECORD.Remove(task);
                    if (edm.SaveChanges() > 0)
                    {
                        return true;
                    }
                    else
                    {
                        msg = "保存失败";
                        return false;
                    }
                }
            }
        }
    }
}