using HH.WCS.Mobox3.HD.models;
using HH.WCS.Mobox3.HD.util;
using System;
using System.Collections.Generic;
using static HH.WCS.Mobox3.HD.util.ExpressionHelper;
using System.Linq.Expressions;
using System.Linq;

namespace HH.WCS.Mobox3.HD.wms
{
    internal class MouldHelper
    {
        
        internal static MouldCntr GetMouldCntr(MouldCntr mouldCntrTemplate)
        {
            var db = new SqlHelper<object>().GetInstance();
            var query = db.Queryable<MouldCntr>(); 
            if (mouldCntrTemplate.S_MOULD_NO != null) {
                query.Where(a => a.S_MOULD_NO == mouldCntrTemplate.S_MOULD_NO || a.S_ITEM_CODE == mouldCntrTemplate.S_MOULD_NO);
            }
            if (mouldCntrTemplate.S_CNTR_CODE != null)
            {
                query.Where(a => a.S_CNTR_CODE == mouldCntrTemplate.S_CNTR_CODE);
            }
            if (mouldCntrTemplate.S_LOC_CODE != null)
            {
                query.Where(a => a.S_LOC_CODE == mouldCntrTemplate.S_LOC_CODE);
            }
            if (mouldCntrTemplate.S_ABLE_FLAG != null)
            {
                query.Where(a => a.S_ABLE_FLAG == mouldCntrTemplate.S_ABLE_FLAG);
            }

            MouldCntr mouldCntr = query.First();

            if (mouldCntr != null)
            {
                // 加载相关的 MouldDetail 记录  
                List<MouldDetail> mouldDetails = db.Queryable<MouldDetail>().Where(a => a.S_MOULD_NO == mouldCntr.S_MOULD_NO).ToList();
                mouldCntr.mouldDetails = mouldDetails; 
            }

            return mouldCntr;
        }

        internal static List<MouldCntr> GetMouldCntrList(MouldCntr mouldCntrTemplate)
        {
            var db = new SqlHelper<object>().GetInstance();
            var query = db.Queryable<MouldCntr>();
            if (mouldCntrTemplate.S_MOULD_NO != null)
            {
                query.Where(a => (a.S_MOULD_NO == mouldCntrTemplate.S_MOULD_NO || a.S_ITEM_CODE == mouldCntrTemplate.S_MOULD_NO));
            }
            if (mouldCntrTemplate.S_CNTR_CODE != null)
            {
                query.Where(a => a.S_CNTR_CODE == mouldCntrTemplate.S_CNTR_CODE);
            }
            if (mouldCntrTemplate.S_LOC_CODE != null)
            {
                query.Where(a => a.S_LOC_CODE == mouldCntrTemplate.S_LOC_CODE);
            }
            var mouldCntrs = query.Where(a => a.S_STATUS == "Y" && a.S_ABLE_FLAG == "是").ToList();
            return mouldCntrs;
        }

        internal static MouldCntr GetMouldCntrByLoc(string locCode)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<MouldCntr>().Where(a => a.S_LOC_CODE == locCode).First(); 
        }
        internal static MouldCntr GetMouldCntrByCntr(string cntrNo)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<MouldCntr>().Where(a => a.S_CNTR_CODE == cntrNo).First();
        }

        internal static MouldCntr GetMouldCntr(string mouldNo)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<MouldCntr>().Where(a => a.S_MOULD_NO == mouldNo).First();
        }

        internal static List<MouldDetail> GetMouldDetails (string mouldNo )
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<MouldDetail>().Where(a => a.S_MOULD_NO == mouldNo).ToList();
        }

        internal static bool deleteMould(string mouldNo)
        {
            bool result = false;
            var db = new SqlHelper<object>().GetInstance();
            try
            {
                db.BeginTran();
                var mouldCntr = db.Queryable<MouldCntr>().Where(a => a.S_MOULD_NO == mouldNo).First();
                if (mouldCntr != null) {
                    int count = db.Deleteable<MouldCntr>().Where(a => a.S_MOULD_NO == mouldNo).ExecuteCommand();
                    if (count > 0)
                    {
                        result = db.Deleteable<MouldDetail>().Where(a => a.S_MOULD_NO == mouldNo).ExecuteCommand() > 0;
                        if (result)
                        {
                            var container = ContainerHelper.GetCntr(mouldCntr.S_CNTR_CODE);
                            container.N_DETAIL_COUNT = 0;
                            db.Updateable(container).ExecuteCommand();
                        }
                    }
                }
                db.CommitTran();
                return result;
            }
            catch (Exception ex) {
                db.RollbackTran();
                LogHelper.Info("删除模具异常-deleteMould,error:"+ex.Message, "mobox");
            }
            return result;
        }

        internal static bool deleteMouldByCntr(string cntrCode)
        {
            bool result = false;
            var db = new SqlHelper<object>().GetInstance();
            try
            {
                db.BeginTran();
                var mouldCntr = db.Queryable<MouldCntr>().Where(a => a.S_CNTR_CODE.Trim() == cntrCode).First();
                int count = db.Deleteable<MouldCntr>().Where(a => a.S_MOULD_NO == mouldCntr.S_MOULD_NO).ExecuteCommand();
                if (count > 0)
                {
                    result = db.Deleteable<MouldDetail>().Where(a => a.S_MOULD_NO == mouldCntr.S_MOULD_NO).ExecuteCommand() > 0;
                }
                db.CommitTran();
                return result;
            }
            catch (Exception ex)
            {
                db.RollbackTran();
                LogHelper.Info("删除模具异常-deleteMould,error:" + ex.Message, "mobox");
            }
            return result;
        }

        /// <summary>
        /// 更新模具数量
        /// </summary>
        /// <param name="mouldDetails"></param>
        /// <returns></returns>    
        internal static bool updateMouldNum(List<MouldDetail> mouldDetails)
        {
            var db = new SqlHelper<object>().GetInstance();
            mouldDetails.ForEach(it =>
            {
                db.Updateable<MouldDetail>(it).UpdateColumns(a => a.N_QTY).ExecuteCommand();
            });
            return true;
        }
        /// <summary>
        /// 更新模具状态
        /// </summary>
        /// <param name="cntrCode"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        internal static bool updateMouldStatus(string cntrCode ,string status)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Updateable<MouldCntr>().SetColumns(a => a.S_STATUS == status).Where(a => a.S_CNTR_CODE == cntrCode).ExecuteCommand() > 0;
        }

        /// <summary>
        /// 更新模具状态
        /// </summary>
        /// <param name="mouldCntr"></param>
        /// <returns></returns>
        internal static bool updateMouldStatus(MouldCntr mouldCntr)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Updateable<MouldCntr>(mouldCntr).UpdateColumns(a => new { a.S_ABLE_FLAG  ,a.S_STATUS }).ExecuteCommand() > 0;
        }

        /// <summary>
        /// 添加模具
        /// </summary>
        /// <param name="mouldCntr"></param>
        /// <returns></returns>
        internal static bool addMould(MouldCntr mouldCntr)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Insertable<MouldCntr>(mouldCntr).ExecuteCommand() > 0;
        }

        /// <summary>
        /// 添加子模具
        /// </summary>
        /// <param name="mouldDetails"></param>
        /// <returns></returns>
        internal static void batchAddChildMould(List<MouldDetail> mouldDetails)
        {
            var db = new SqlHelper<object>().GetInstance();
            foreach (MouldDetail item in mouldDetails)
            {
                db.Insertable<MouldDetail>(item).ExecuteCommand();
            }
        }

    }
}