using HH.WCS.Mobox3.YNJT_PT.models;
using HH.WCS.Mobox3.YNJT_PT.models.other;
using HH.WCS.Mobox3.YNJT_PT.util;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static HH.WCS.Mobox3.YNJT_PT.dispatch.NDC;

namespace HH.WCS.Mobox3.YNJT_PT.wms {
    /// <summary>
    /// 容器帮助类
    /// </summary>
    internal class ContainerHelper {
        internal static string GenerateCntrNo() {
            var id = SYSHelper.GetSerialNumber("托盘号", "TP");
            var date = DateTime.Now.ToString("yyMMdd");
            return $"TP{date}{id.ToString().PadLeft(4, '0')}";
        }
        
        /// <summary>
        /// TN_ContainerHelper.test("4L天然水箱装6入", 50, "335ml东方树叶15入", 30);
        /// </summary>
        /// <param name="item1"></param>
        /// <param name="qty1"></param>
        /// <param name="item2"></param>
        /// <param name="qty2"></param>
        //internal static void test(string item1, int qty1, string item2, int qty2) {
        //    var db = new SqlHelper<object>().GetInstance();
        //    var cntr = db.Queryable<TN_Container>().Includes(a => a.CntrItemRelList).
        //        Where(a => a.CntrItemRelList.Count(b => b.S_ITEM_CODE == item1 && int.Parse(b.F_QTY) > qty1) > 0
        //        && a.CntrItemRelList.Count(b => b.S_ITEM_CODE == item2 && int.Parse(b.F_QTY) > qty2) > 0).First();
        //}

        /// <summary>
        /// 判断容器是否有物料信息
        /// </summary>
        /// <param name="cntr"></param>
        /// <returns></returns>
        internal static bool CheckEmpty(string cntr) {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<LocCntrRel>().Count(a => a.S_LOC_CODE.Trim() == cntr) == 0;

        }

        internal static bool AddCntr(string cntrCode)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var TN_Container = new Container { S_CODE = cntrCode };
            try
            {
                res = db.Insertable<Container>(TN_Container).ExecuteCommand() > 0;
            }
            catch (Exception ex)
            {
                LogHelper.Info($"添加容器错误，错误原因：{ex.Message}", "WMS");
            }
            return res;
        }

        internal static bool AddCntr(string cntrCode, string itemCode) {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var TN_Container = new Container { S_CODE = cntrCode };
            var cntrItemRel = new CntrItemRel { S_CNTR_CODE = cntrCode, S_ITEM_CODE = itemCode };
            try {
                db.BeginTran();

                db.Insertable<Container>(TN_Container).ExecuteCommand();
                db.Insertable<CntrItemRel>(cntrItemRel).ExecuteCommand();

                db.CommitTran();
                res = true;
            }
            catch (Exception ex) {
                db.RollbackTran();

            }
            return res;
        }

        /// <summary>
        /// 根据容器号获取容器信息
        /// </summary>
        /// <param name="cntr"></param>
        /// <returns></returns>
        internal static Container GetCntr(string cntr, bool create = false) {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var old = db.Queryable<Container>().Where(a => a.S_CODE == cntr).First();
            if (old == null && create) {
                var model = new Container { S_CODE = cntr };
                if (db.Insertable(model).ExecuteCommand() > 0) {
                    old = model;
                }
            }
            return old;

        }

        /// <summary>
        /// 根据容器获取物料信息
        /// </summary>
        /// <param name="cntr"></param>
        /// <returns></returns>
        internal static List<CntrItemRel> GetCntrItemRel(string cntr) {
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr).ToList();
            return list;
        }

        /// <summary>
        /// 根据容器获取物料信息
        /// </summary>
        /// <param name="cntr"></param>
        /// <returns></returns>
        internal static bool deleteCntrItemRelByCntr(string cntr)
        {
            var db = new SqlHelper<object>().GetInstance();
            var container = ContainerHelper.GetCntr(cntr);
            if(container != null)
            {
                db.Deleteable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr).ExecuteCommand();
                
                container.N_DETAIL_COUNT = 0;
                db.Updateable(container).ExecuteCommand();
            }
            return true;
        }

        /// <summary>
        /// 添加容器物料信息
        /// </summary>
        /// <returns></returns>
        public static bool addCntrItemRel( string cntrCode,GreenTireInformation info) 
        {
            bool res = false;
            var db = new SqlHelper<object>().GetInstance();
            var container = ContainerHelper.GetCntr(cntrCode);
            if (container != null)
            {
                try
                {
                    db.BeginTran();
                    db.Deleteable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntrCode).ExecuteCommand();

                    CntrItemRel cntrItemRel = new CntrItemRel()
                    {
                        S_CG_ID = info.BARCODE,
                        S_CNTR_CODE = cntrCode,
                        S_ITEM_CODE = info.ITEMCODE,
                        S_CELL_NO = info.TIRECODE,
                        F_QTY = info.QTY,
                        S_MCN = info.MCN,
                        S_OPR = info.OPR,
                        S_OPR02 = info.OPR02,
                        S_OPR03 = info.OPR03,
                        S_OPR04 = info.OPR04,
                        S_WINDUP = info.WINDUP,
                        S_TXNDATE = info.TXNDATE,
                        S_DATE_SHIFT = info.DATE_SHIFT,
                        S_EFFECTIVE_TIME = info.S_EFFECTIVE_TIME,
                        S_EXPIRATION_TIME = info.S_EXPIRATION_TIME,
                        N_URGENT_FLAG = info.N_URGENT_FLAG,
                    };

                    db.Insertable(cntrItemRel).ExecuteCommand();
                    container.N_DETAIL_COUNT = 1;
                    db.Updateable(container).ExecuteCommand();
                    db.CommitTran();
                    res = true;
                }
                catch (Exception ex)
                {
                    db.RollbackTran();
                }
            }
            return res;
        }
        
    }
}