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

namespace IWareDataAccess.Order.OUTORDER
{
    public static class OutOrderSqlFunc
    {
        /// <summary>
        /// 搜索表
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static List<ORDER_OUTORDER> Search(OutOrderWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<ORDER_OUTORDER>();
                //便利所有属性
                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 == "updateTimeStart")
                            {
                                f = f.And(x => x.UPDATETIME > value);
                            }
                            if (i.Name == "updateTimeEnd")
                            {
                                f = f.And(x => x.UPDATETIME < value);
                            }
                            //执行时间
                            if (i.Name == "doTimeStart")
                            {
                                f = f.And(x => x.DOTIME > value);
                            }
                            if (i.Name == "doTimeEnd")
                            {
                                f = f.And(x => x.DOTIME < value);
                            }
                            //修改时间
                            if (i.Name == "changeDateStart")
                            {
                                f = f.And(x => x.CHANGEDATE > value);
                            }
                            if (i.Name == "changeDateEnd")
                            {
                                f = f.And(x => x.CHANGEDATE < value);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }
                List<ORDER_OUTORDER> list = edm.ORDER_OUTORDER.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_ORDER_OUTORDER> SearchView(OutOrderWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_ORDER_OUTORDER>();
                //便利所有属性
                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 == "updateTimeStart")
                            {
                                f = f.And(x => x.updateTime > value);
                            }
                            if (i.Name == "updateTimeEnd")
                            {
                                f = f.And(x => x.updateTime < value);
                            }
                            //执行时间
                            if (i.Name == "doTimeStart")
                            {
                                f = f.And(x => x.doTime > value);
                            }
                            if (i.Name == "doTimeEnd")
                            {
                                f = f.And(x => x.doTime < value);
                            }
                            //修改时间
                            if (i.Name == "changeDateStart")
                            {
                                f = f.And(x => x.changeDate > value);
                            }
                            if (i.Name == "changeDateEnd")
                            {
                                f = f.And(x => x.changeDate < value);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }
                List<View_ORDER_OUTORDER> list = edm.View_ORDER_OUTORDER.OrderByDescending(x => x.id).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(OutOrderWebEntity webEntity)
        {
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_ORDER_OUTORDER>();
                //便利所有属性
                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 == "updateTimeStart")
                            {
                                f = f.And(x => x.updateTime > value);
                            }
                            if (i.Name == "updateTimeEnd")
                            {
                                f = f.And(x => x.updateTime < value);
                            }
                            //执行时间
                            if (i.Name == "doTimeStart")
                            {
                                f = f.And(x => x.doTime > value);
                            }
                            if (i.Name == "doTimeEnd")
                            {
                                f = f.And(x => x.doTime < value);
                            }
                            //修改时间
                            if (i.Name == "changeDateStart")
                            {
                                f = f.And(x => x.changeDate > value);
                            }
                            if (i.Name == "changeDateEnd")
                            {
                                f = f.And(x => x.changeDate < value);
                            }
                        }
                    }
                    else
                    {
                        if (v != null)
                        {
                            f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
                        }
                    }
                }

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

                return num;
            }
        }

        /// <summary>
        /// 添加修改 出库单
        /// </summary>
        /// <param name="role"></param>
        /// <returns></returns>
        public static bool AddOrUpdate(OutOrderWebEntity webEntity, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {

                ORDER_OUTORDER order = new ORDER_OUTORDER();
                order = edm.ORDER_OUTORDER.FirstOrDefault(x => x.OUTORDERCODE == webEntity.outOrderCode);
                if (order == null)
                {
                    order = new ORDER_OUTORDER();
                    order.ORDERSTATUS = "新建";
                    order.CHECKOUTNUM = 0;
                }
                else
                {
                    if (order.ORDERSTATUS == "新建")
                    {
                        msg = "此单据已处理";
                        return false;
                    }
                    order.ORDERSTATUS = webEntity.orderStatus ?? order.ORDERSTATUS;
                }
                SYS_USER user = edm.SYS_USER.FirstOrDefault(x => x.USERNAME == webEntity.userName);
                if (user != null)
                {
                    order.CREATORID = user.ID;
                }

                if (string.IsNullOrEmpty(webEntity.orderType))//为空返回false
                {
                    msg = "未选择出库类型";
                    return false;
                }
                else
                {
                    //修改用户可以为空，[Editby kejj,20230628]
                    if (user.SYS_USER_VS_ROLE.FirstOrDefault() == null)
                    {
                        msg = "用户无角色";
                        return false;
                    }
                    if ((webEntity.orderType != "空器具出库" && !webEntity.orderType.Contains("冲压待返修")) && user.SYS_USER_VS_ROLE.FirstOrDefault().SYS_ROLE.ROLENAME.Contains("冲压"))
                    {
                        msg = "冲压无法出零件";
                        return false;
                    }
                }
                order.OUTORDERCODE = webEntity.outOrderCode ?? order.OUTORDERCODE;
                BASE_ITEM item = edm.BASE_ITEM.FirstOrDefault(x => x.ITEMNAME == webEntity.itemName);
                if (item == null)
                {
                    msg = "无此零件";
                    return false;
                }
                order.BASE_ITEM = item;
                order.UPDATETIME = DateTime.Now;
                order.ORDERTYPE = webEntity.orderType ?? order.ORDERTYPE;
                order.TOTALOUTNUM = webEntity.totalOutNum ?? order.TOTALOUTNUM;

                order.ISFINISH = webEntity.isFinish ?? order.ISFINISH;
                order.TOTALWEIGHT = item.WEIGHT * order.TOTALOUTNUM ?? 0;
                order.CARUSERID = webEntity.CarUserId;

                BASE_PRODUCTIONLINE pl = edm.BASE_PRODUCTIONLINE.FirstOrDefault(x => x.PRODUCTIONLINENAME == webEntity.productionLineName);
                if (pl != null)
                {
                    order.BASE_PRODUCTIONLINE = pl;
                }
                else
                {
                    pl = edm.BASE_PRODUCTIONLINE.FirstOrDefault(x => x.PRODUCTIONLINECODE == webEntity.productionLineCode);
                    if (pl != null)
                    {
                        order.BASE_PRODUCTIONLINE = pl;
                    }
                }

                ERP_EPRORDER erpOrder = edm.ERP_EPRORDER.FirstOrDefault(x => x.ERPORDERID == webEntity.erpOrderId);
                if (erpOrder != null)
                {
                    order.ERP_EPRORDER = erpOrder;
                }
                order.DOTIME = webEntity.doTime ?? order.DOTIME;
                order.CHANGEDATE = webEntity.changeDate ?? order.CHANGEDATE;
                order.ENABLE = webEntity.enable ?? order.ENABLE;
                order.TRANLINE = webEntity.tranLine ?? order.TRANLINE;
                order.ISERP = webEntity.isErp ?? order.ISERP;
                if ((order.TRANLINE ?? 0) == 0)
                {
                    msg = "选择出库口";
                    return false;
                }
                edm.ORDER_OUTORDER.AddOrUpdateExtension(order);
                if (edm.SaveChanges() > 0)
                {
                    return true;
                }
                else
                {
                    msg = "保存失败";
                    return false;
                }
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="webDevice"></param>
        /// <returns></returns>
        public static bool Delete(OutOrderWebEntity webEntity, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                ORDER_OUTORDER outOrder = edm.ORDER_OUTORDER.FirstOrDefault(x => x.OUTORDERCODE == webEntity.outOrderCode);
                if (outOrder == null)
                {
                    //无此角色
                    msg = "无此订单";
                    return false;
                }
                else
                {
                    //edm.BASE_CONTAINER_VS_ITEM.Remove(cvi);
                    outOrder.ENABLE = 0;
                    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 "OO" + time;
            }
        }

        /// <summary>
        /// 确认下发出库计划
        /// </summary>
        /// <returns></returns>
        public static bool CheckOutOrder(OutOrderWebEntity model, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                ORDER_OUTORDER order = null;
                if (model.id != null)
                {
                    order = edm.ORDER_OUTORDER.FirstOrDefault(x => x.ID == model.id);
                }
                if(!string.IsNullOrEmpty(model.outOrderCode))
                {
                    order = edm.ORDER_OUTORDER.FirstOrDefault(x => x.OUTORDERCODE == model.outOrderCode);
                }
               
                if (order != null)
                {
                    PlaceVsContainerWebEntity pvcWeb = new PlaceVsContainerWebEntity();
                    pvcWeb.itemName = order.BASE_ITEM.ITEMNAME;
                    if (order.ORDERTYPE != "空器具出库")
                    {
                        int num = Base.PLACEVSCONTAINER.PlaceVsContainerSqlFunc.SearchItemCanUseNum(pvcWeb, out msg);
                        if (order.TOTALOUTNUM <= num)//数量够
                        {
                            order.ORDERSTATUS = "执行中";
                            if (edm.SaveChanges() > 0)
                            {
                                return true;
                            }
                            else
                            {
                                msg = "保存失败";
                                return false;
                            }
                        }
                        else
                        {
                            msg = "库存不足不能下发";
                            return false;
                        }
                    }
                    else
                    {
                        int num = Base.PLACEVSCONTAINER.PlaceVsContainerSqlFunc.SearchEmptyContainerPlace(pvcWeb, out msg).FirstOrDefault(x => x.titel == "有效空器具数").value;
                        if (order.TOTALOUTNUM <= num)//数量够
                        {
                            order.ORDERSTATUS = "执行中";
                            if (edm.SaveChanges() > 0)
                            {
                                return true;
                            }
                            else
                            {
                                msg = "保存失败";
                                return false;
                            }
                        }
                        else
                        {
                            msg = "库存不足不能下发";
                            return false;
                        }
                    }
                }
                else
                {
                    msg = "无此计划";
                    return false;
                }
            }
        }
    }
}