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

namespace IWareDataAccess.Base.PALLET
{
   public class PalletSqlFunc
    {
        /// <summary>
        /// 搜索表
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
       public static List<PalletWebEntity> Search(PalletWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<BASE_PALLET>();
                //便利所有属性
                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<BASE_PALLET> list = edm.BASE_PALLET.Where(f.Compile()).Skip((page - 1) * onePageNum).Take(onePageNum).ToList();
               List<PalletWebEntity>  pwlst=new List<PalletWebEntity>();
                list.ForEach(x =>
                {
                    pwlst.Add(new PalletWebEntity() { 
                     id=x.ID,
                      PalletType=x.PALLETTYPE,
                      PalletCode=x.PALLETCODE,
                      HeightMax=x.HEIGHTMAX,
                      HeightMin=x.HEIGHTMIN,
                      LengthMax=x.LENGTHMAX,
                      LengthMin=x.LENGTHMIN,
                      WidthMax=x.WIDTHMAX,
                      WidthMin=x.WIDTHMIN
                    });
                });
                return pwlst;
            }
        }



        /// <summary>
        /// 搜索视图数量
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public static int SearchViewNum(PalletWebEntity webEntity)
        {
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<BASE_PALLET>();

                //便利所有属性
                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.BASE_PALLET.Where(f.Compile()).Count();

                return num;
            }
        }


        /// <summary>
        /// 添加修改托盘
        /// </summary>
        /// <param name="role"></param>
        /// <returns></returns>
        public static bool AddOrUpdate(PalletWebEntity webEntity, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                //查询是否已存在此托盘
                BASE_PALLET pallet = edm.BASE_PALLET.FirstOrDefault(x => x.PALLETCODE==webEntity.PalletCode);
                if (pallet == null)
                {
                    //无此库位，属于新建
                    pallet = new BASE_PALLET();
                }
                else
                {
                    msg = "该器具编号规格已存在！";
                }
                pallet.PALLETCODE = webEntity.PalletCode ?? pallet.PALLETCODE;
                pallet.PALLETTYPE = webEntity.PalletType ?? pallet.PALLETTYPE;

                edm.BASE_PALLET.AddOrUpdateExtension(pallet);
                if (edm.SaveChanges() > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
        }

        /// <summary>
        /// 删除托盘
        /// </summary>
        /// <param name="webDevice"></param>
        /// <returns></returns>
        public static bool Delete(PalletWebEntity webDevice, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                //查询是否已存在此权限
                BASE_PALLET pallet = edm.BASE_PALLET.FirstOrDefault(x => x.PALLETCODE == webDevice.PalletCode);
                if (pallet == null)
                {
                    //无此角色
                    msg = "无此规格";
                    return false;
                }
                else
                {
                    edm.BASE_PALLET.Remove(pallet);

                    return  edm.SaveChanges()>0?true:false;
                }
            }
        }

    }
}