using Infrastructure;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using WebRepository;

namespace WebApp
{
    /// <summary>
	/// 机器信息表
	/// </summary>
    
    public partial class MachineApp
    {
        private IUnitWork _unitWork;
        public IRepository<Machine> _app;
        private static IHostingEnvironment _hostingEnvironment;
        ExcelHelper imp = new ExcelHelper(_hostingEnvironment);

        public MachineApp(IUnitWork unitWork, IRepository<Machine> repository, IHostingEnvironment hostingEnvironment)
        {
            _unitWork = unitWork;
            _app = repository;
            _hostingEnvironment = hostingEnvironment;
        }
        
        public MachineApp SetLoginInfo(LoginInfo loginInfo)
        {
            _app._loginInfo = loginInfo;
            return this;
        }
        
        public TableData Load(PageReq pageRequest, Machine entity)
        {
            return _app.Load(pageRequest, entity);
        }

        public Response Ins(Machine entity)
        {
            Response result = new Response();
            Machine data = _unitWork.Find<Machine>(n => n.MachineCode == entity.MachineCode).FirstOrDefault();
            if (data == null)
            {
                _app.Add(entity);
                return result;
            }
            else {
                result.Status = false;
                result.Message = "机台号重复";
            }
            return result;
        }

        public void Upd(Machine entity)
        {
            _app.Update(entity);
        }

        public void DelByIds(int[] ids)
        {
            _app.Delete(u => ids.Contains(u.Id.Value));
        }
        
        public Machine FindSingle(Expression<Func<Machine, bool>> exp)
        {
            return _app.FindSingle(exp);
        }

        public IQueryable<Machine> Find(Expression<Func<Machine, bool>> exp)
        {
            return _app.Find(exp);
        }

        public Response ImportIn(IFormFile excelfile)
        {
            Response result = new Infrastructure.Response();
            List<Machine> exp = imp.ConvertToModel<Machine>(excelfile);
            string sErrorMsg = "";

            for (int i = 0; i < exp.Count; i++)
            {
                try
                {
                    Machine e = exp[i];
                    e.Id = null;
                    _app.Add(e);
                }
                catch (Exception ex)
                {
                    sErrorMsg += "第" + (i + 2) + "行:" + ex.Message + "<br>";
                    result.Message = sErrorMsg;
                    break;
                }
            }
            if (sErrorMsg.Equals(string.Empty))
            {
                if (exp.Count == 0)
                {
                    sErrorMsg += "没有发现有效数据, 请确定模板是否正确， 或是否有填充数据！";
                    result.Message = sErrorMsg;
                }
                else
                {
                    result.Message = "导入完成";
                }
            }
            else
            {
                result.Status = false;
                result.Message = result.Message;
            }
            return result;
        }

        public TableData ExportData(Machine entity)
        {
            return _app.ExportData(entity);
        }

        public TableData Query(Machine entity)
        {
            var result = new TableData();
            var data = _app.Find(EntityToExpression<Machine>.GetExpressions(entity));

            GetData(data, result);
            result.count = data.Count();

            return result;
        }

        public void GetData(IQueryable<Machine> data, TableData result, PageReq pageRequest = null)
        {
            _app.GetData(data, result, pageRequest);
        }

        #region 自定义方法
        /// <summary>
        /// 停用或启用机台
        /// </summary>
        public void OpenStopMachine(List<Machine> Table_entitys)
        {
            foreach (var item in Table_entitys)
            {
                if (item.IsStop == 0)
                {
                    item.IsStop = 1;
                }
                else
                {
                    item.IsStop = 0;
                }
                _app.Update(item);
            }
        }

        /// <summary>
        /// 停用或启用仓位
        /// </summary>
        public void OpenStopWareCell(List<MachineWarecell> Table_entitys)
        {
            foreach (var item in Table_entitys)
            {
                if (item.IsStop == 0)
                {
                    item.IsStop = 1;
                }
                else
                {
                    item.IsStop = 0;
                }
                _unitWork.Update(item);
            }
        }
        #endregion
    }
}