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

namespace IWareDataAccess.Base.ITEMSTORAGE
{
   public  class ItemStorageSqlFunc
    {


        /// <summary>
        /// 搜索视图
        /// </summary>
        /// <param name="keyValue"></param>
        /// <param name="page"></param>
        /// <returns></returns>
       public static List<View_ITEMSTORAGE> SearchView(ItemStorageWebEntity webEntity, int page, int onePageNum, out string msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_ITEMSTORAGE>();
                //便利所有属性
                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_ITEMSTORAGE> list = edm.View_ITEMSTORAGE.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(ItemStorageWebEntity webEntity,out string  msg)
        {
            msg = "";
            using (Model edm = new Model())
            {
                var f = PredicateBuilder.True<View_ITEMSTORAGE>();
                //便利所有属性
                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_ITEMSTORAGE.Where(f.Compile()).Count();

                return num;
            }
        }

       /// <summary>
       /// 首页滚动
       /// </summary>
       /// <param name="keyValue"></param>
       /// <param name="page"></param>
       /// <returns></returns>
       public static List<ReturnItemStorageEntity> SearchViewIndex(out string msg)
       {
           msg = "";
           List<ReturnItemStorageEntity> list=new List<ReturnItemStorageEntity>();
           using (Model edm = new Model())
           {
               List<View_ITEMSTORAGE> storageList = edm.View_ITEMSTORAGE.Where(x => x.isLessDay == "是" || x.isOverDay == "是" || x.isMoreDay=="是").ToList();
               //List<string> result = new List<string>();
               foreach (var i in storageList)
               {
                   //result.Add("零件号：" + i.itemName + " 零件名称：" + i.itemDes + "超限,目前存在" + i.itemNum + " 设置上限：" + i.maxStorage + " 下限：" + i.minStorage);
                   ReturnItemStorageEntity entity = new ReturnItemStorageEntity()
                   {
                       itemName=i.itemName,
                       itemDes=i.itemDes,
                       itemNum=i.itemNum,
                       maxStorage=i.maxStorage,
                       minStorage=i.minStorage,
                       isLessDay=i.isLessDay,
                       isMoreDay=i.isMoreDay,
                       isOverDay=i.isOverDay
                   };
                   list.Add(entity);
               }
               return list;
           }
       }
    }
}