using System.Collections.Generic;
using HH.WCS.Mobox3.RiDong.models;

namespace HH.WCS.Mobox3.RiDong.generalMethod;

/// <summary>
/// 出入库记录表
/// </summary>
public static class OnOffShelvesMethod
{
    /// <summary>
    /// 创建出入库记录
    /// </summary>
    /// <param name="task"></param>
    /// <returns></returns>
    public static bool CreateRKOnOffShelves(Task task)
    {
        var result = false;
        
        var cntritem = AdoSqlMethod<CntrItemDetail>.QueryList(p => p.S_CNTR_CODE == task.S_CNTR_CODE);

        if (cntritem.Count > 0)
        {
            var onOffShelvesList = new List<OnOffShelves>();

            foreach (var item in cntritem)
            {
                var onOffShelves = new OnOffShelves();

                onOffShelves.S_LOC_CODE = task.S_END_LOC;
                onOffShelves.S_CNTR_CODE = task.S_CNTR_CODE;
                onOffShelves.S_ITEM_CODE = item.S_ITEM_CODE.Trim();
                onOffShelves.S_ITEM_NAME = item.S_ITEM_NAME;
                onOffShelves.S_MATERIAL_TYPE = item.S_EXT_ATTR1;
                
                onOffShelves.S_OP_TYPE = "上架";
                onOffShelves.F_QTY = item.F_QTY;
                
                onOffShelvesList.Add(onOffShelves);
                
            }

            if (onOffShelvesList.Count > 0)
            {
                AdoSqlMethod<OnOffShelves>.AddList(onOffShelvesList);
                result = true;
            }
        }
        return result;
    }
    
    
    /// <summary>
    /// 创建出入库记录
    /// </summary>
    /// <param name="task"></param>
    /// <returns></returns>
    public static bool CreateCKOnOffShelves(Task task)
    {
        var result = false;
        
        var cntritem = AdoSqlMethod<CntrItemDetail>.QueryList(p => p.S_CNTR_CODE == task.S_CNTR_CODE);

        if (cntritem.Count > 0)
        {
            var onOffShelvesList = new List<OnOffShelves>();

            foreach (var item in cntritem)
            {
                if (item.F_ALLOC_QTY > 0)
                {
                    var onOffShelves = new OnOffShelves();

                    onOffShelves.S_LOC_CODE = task.S_START_LOC;
                    onOffShelves.S_CNTR_CODE = task.S_CNTR_CODE;
                    onOffShelves.S_ITEM_CODE = item.S_ITEM_CODE.Trim();
                    onOffShelves.S_ITEM_NAME = item.S_ITEM_NAME;
                    onOffShelves.S_MATERIAL_TYPE = item.S_EXT_ATTR1;
                
                    onOffShelves.S_OP_TYPE = "下架";
                    onOffShelves.F_QTY = item.F_ALLOC_QTY;
                
                    onOffShelvesList.Add(onOffShelves);
                }
            }

            if (onOffShelvesList.Count > 0)
            {
                AdoSqlMethod<OnOffShelves>.AddList(onOffShelvesList);
                result = true;
            }
        }
        return result;
    }
}