using iWareCommon.Common.Service;
using iWareCommon.Utils;
using iWareDataCore.BASE.Dao;
using iWareDataCore.BASE.Entity;
using iWareDataCore.ORM;
using iWareDataCore.Properties;
using iWareExcel.EXCEL.Entity;
using iWareExcel.Utils;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace iWareDataCore.BASE.Service
{
    public class PlaceViewService : CommonService<PlaceViewEntity, BASEPlaceView, DbModelCore>
    {

        private static object Lock = new object();

        private PlaceViewService() : base(PlaceViewDao.GetInstance()) { }

        private static PlaceViewService Instance = null;

        /// <summary>
        /// 获取单例的方法
        /// </summary>
        /// <returns>角色服务的单例实体</returns>
        public static PlaceViewService GetInstance()
        {

            if (Instance == null)
            {
                lock (Lock)
                {
                    if (Instance == null)
                    {
                        Instance = new PlaceViewService();
                    }
                }
            }
            return Instance;
        }


        



        /// <summary>
        /// 导入Excel
        /// </summary>
        /// <param name="path">文件在服务器上的路径</param>
        /// <param name="workBookEntity">导入使用的目板</param>
        /// <param name="name">导入者姓名</param>
        /// <param name="msg">异常错误消息</param>
        /// <returns>是否导入成功</returns>
        public bool ImportExcel(string path, WorkBookEntity workBookEntity, out string msg)
        {
            msg = "";

            using (var dbModel = new DbModelCore())
            {
                try
                {
                    var ds = ExcelHelper.FromExcelByEPPlus(path, workBookEntity, out msg);
                    if (!string.IsNullOrEmpty(msg))
                    {
                        throw new Exception(msg);
                    }

                    var places = ds[0];
                    if (places.Count < 1)
                    {
                        msg = "库位记录数为0，请修改后重新导入";
                        return false;
                    }
                    var types = dbModel.BASEPlaceTypes.Where(x => 1 == 1).ToList();
                    var i = 0;
                    var codes = new List<string>();
                    var shelfCodeRowColLayers = new List<string>();
                    foreach (PlaceViewEntity place in places)
                    {
                        if (string.IsNullOrEmpty(place.Code))
                        {
                            msg = string.Format("在第{0}行，库位编号不能为空，请修改后重新导入", i + 1);
                            return false;
                        }

                        if (string.IsNullOrEmpty(place.PlaceTypeName))
                        {
                            msg = string.Format("在第{0}行，库位类型不能为空，请修改后重新导入", i + 1);
                            return false;
                        }

                       

                        var type = types.FirstOrDefault(x => x.name == place.PlaceTypeName);
                        if (type == null)
                        {
                            msg = string.Format("在第{0}行，不存在库位类型{1}，请修改后重新导入", i + 1, place.PlaceTypeName);
                            return false;
                        }
                        place.TypeId = type.id;

                        if (codes.Contains(place.Code))
                        {
                            msg = string.Format("在第{0}行，库位编号为{1}的库位已重复出现，请修改后重新导入", i + 1, place.Code);
                            return false;
                        }


                        if (shelfCodeRowColLayers.Contains(place.Row + "#" + place.Col + "#" + place.Layer))
                        {
                            msg = string.Format("在第{0}行，第{1}排第{2}列第{3}列的库位已出现过，请修改后重新导入", i + 1, place.Row, place.Col, place.Layer);
                            return false;
                        }
                        shelfCodeRowColLayers.Add(place.Row + "#" + place.Col + "#" + place.Layer);

                        codes.Add(place.Code);
                    }

                    var placeSaves = new List<PlaceEntity>();
                    var placeUpdates = new List<PlaceEntity>();

                    var existPlaces = dbModel.BASEPlaces.Select(x => new { x.id, x.code }).Where(x => codes.Contains(x.code)).ToList();

                    foreach (PlaceViewEntity place in places)
                    {
                        var one = existPlaces.FirstOrDefault(x => x.code == place.Code);
                        if (one == null) { placeSaves.Add(new PlaceEntity(place)); }
                        else
                        {
                            place.Id = one.id;
                            placeUpdates.Add(new PlaceEntity(place));
                        }
                    }

                    var sum = placeSaves.Count % 1000 == 0 ? placeSaves.Count / 1000 : placeSaves.Count / 1000 + 1;
                    for (var j = 0; j < (int)Math.Ceiling(placeSaves.Count / 1000.0); j++)
                    {
                        var sql = string.Format("INSERT INTO [dbo].[BASEPlace] (code,typeid,heightlevel,row,col,layer,length,width,height,posx,posy,posz,maxweight,status,islock,isexecute) VALUES");
                        for (var r = j * 1000; r < j * 1000 + 1000; r++)
                        {
                            if (r == placeSaves.Count)
                            {
                                break;
                            }
                            sql += string.Format("( '{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}'),",
                                StringHelper.RelpaceQuot(placeSaves[r].Code),
                                placeSaves[r].TypeId,
                                placeSaves[r].HeightLevel,
                                placeSaves[r].Row,
                                placeSaves[r].Col,
                                placeSaves[r].Layer,
                                placeSaves[r].Length,
                                placeSaves[r].Width,
                                placeSaves[r].Height,
                                placeSaves[r].Posx,
                                placeSaves[r].Posy,
                                placeSaves[r].Posz,
                                placeSaves[r].MaxWeight,
                                placeSaves[r].Status,
                                placeSaves[r].IsLock,
                                placeSaves[r].IsExecute);
                        }
                        sql = sql.Substring(0, sql.Length - 1);
                        var num = dbModel.Database.ExecuteSqlCommand(sql);
                    }

                    PlaceDao.GetInstance().Update(placeUpdates, dbModel);
                    dbModel.SaveChanges();
                    return string.IsNullOrEmpty(msg);
                }
                catch (Exception ex)
                {
                    msg = ex.Message;
                    LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "ImportExcel", ex.Message);
                    return false;
                }
            }

        }

        /// <summary>
        /// 获取指定字符串开头的库位列表
        /// </summary>
        /// <param name="term">指定字符串</param>
        /// <param name="size">返回的最大条数</param>
        /// <param name="msg">异常错误消息</param>
        /// <returns>送货单号列表</returns>
        public List<string> GetPlaceCodes(string term, int size, out string msg)
        {
            using (var dbModel = new DbModelCore())
            {
                try
                {
                    msg = "";

                    if (string.IsNullOrEmpty(term))
                    {
                        return new List<string>();
                    }


                    var placeviews = dbModel.BASEPlaceViews.Select(x => new { x.id, x.code, }).OrderByDescending(x => x.id).Where(x => x.code.StartsWith(term)).Skip(0).Take(size).ToList();

                    var placecodes = new List<string>();

                    placeviews.ForEach(x => placecodes.Add(x.code));

                    return placecodes;

                }
                catch (Exception ex)
                {
                    msg = ex.Message;
                    LogTextHelper.WriteLog(Resources.LogDir, this.ToString(), "GetPlaceCodes", ex.Message);
                    return new List<string>();
                }
            }
        }
       

    }
}