using MES.Service.DB;
using MES.Service.Dto.webApi.SRM;
using MES.Service.Modes.SRM;
using SqlSugar;

public class MesDeliveryNoteManager : Repository<MesDeliveryNote>{
    private readonly MesDeliveryNoteDetailsManager mesDeliveryNoteManager = new();
    public dynamic Save(Delivery delivery)
    {
        var DeliveryNote = delivery.DeliveryNote;
        var mesDeliveryNote = GetMesDeliveryNote(DeliveryNote);
        var mesDeliveryNoteDetails = GetMesDeliveryNoteDetails(delivery.DeliveryNoteDetail, DeliveryNote.DeliveryNo);

        return UseTransaction(db =>
        {
            return SaveOrUpdateData(db, mesDeliveryNote, mesDeliveryNoteDetails) ? 1 : 0;
        }) > 0;
    }

    public dynamic SaveList(List<Delivery> delivery)
    {
        var result = delivery.Select(Save).ToList();
        return result.All(b => b);
    }

    public dynamic DeleteDelivery(ErpDelivery delivery)
    {
        return UseTransaction(db =>
        {
            return DeleteData(db, delivery) ? 1 : 0;
        }) > 0;
    }
    public dynamic DeleteDeliveryList(List<ErpDelivery> delivery)
    {
        var result = delivery.Select(DeleteDelivery).ToList();
        return result.All(b => b);
    }

    // 删除数据的方法
    private bool DeleteData(SqlSugarScope db, ErpDelivery delivery)
    {
        var update = db.Deleteable<MesDeliveryNote>().Where(s => s.DeliveryNo == delivery.DeliveryNo).ExecuteCommand()>0;
        var insertOrUpdate = db.Deleteable<MesDeliveryNoteDetails>().Where(s => s.DeliveryNo == delivery.DeliveryNo).ExecuteCommand() >= 0;

        if (update && insertOrUpdate) return true;
        throw new NotImplementedException("删除失败,MES中不存在此送货单");
    }

    // 插入或更新数据的方法
    private bool SaveOrUpdateData(SqlSugarScope db, MesDeliveryNote mesDeliveryNote, List<MesDeliveryNoteDetails> mesDeliveryNoteDetails)
    {
        if (mesDeliveryNote.Id != null)
        {
            base.DeleteById(mesDeliveryNote.Id);
        }

        if (mesDeliveryNoteDetails.Count > 0)
        {
            db.Deleteable<MesDeliveryNoteDetails>().Where(s => s.DeliveryNo == mesDeliveryNote.DeliveryNo).ExecuteCommand();
        }
        
        var orUpdate = base.Insert(mesDeliveryNote);
        var baOrUpdate = mesDeliveryNoteManager.InsertRange(mesDeliveryNoteDetails);
        if (orUpdate && baOrUpdate) return true;
        throw new NotImplementedException("插入或更新失败");
    }

    public MesDeliveryNote GetMesDeliveryNote(DeliveryNote delivery)
    {
        var mesDeliveryNote = new MesDeliveryNote();
        var single = base.GetSingle(it => it.DeliveryNo == delivery.DeliveryNo);
        if (single != null) mesDeliveryNote.Id = single.Id;

        mesDeliveryNote.ErpId = delivery.Erpid;
        mesDeliveryNote.DeliveryNo = delivery.DeliveryNo;
        mesDeliveryNote.SuppNo = delivery.SupplierId;
        mesDeliveryNote.DeliveryDate = delivery.FDate;
        mesDeliveryNote.Remark = delivery.Remark;
        mesDeliveryNote.Site = delivery.FReceiveOrgId;
        mesDeliveryNote.Issrm=delivery.Is_SRM;
        if (single != null)
        {
            mesDeliveryNote.Status = single.Status;
            mesDeliveryNote.CheckUser = single.CheckUser;
            mesDeliveryNote.CheckDate = single.CheckDate;
        }
        else
        {
            mesDeliveryNote.Status = 0;
        }
        mesDeliveryNote.CreateDate = DateTime.Now;

        return mesDeliveryNote;
    }

    public List<MesDeliveryNoteDetails> GetMesDeliveryNoteDetails(List<DeliveryNoteDetail> erpDeliveryDatas, string? type)
    {
        return erpDeliveryDatas.Select(s =>
        {
            var entity = new MesDeliveryNoteDetails
            {
                DeliveryNo = type,
                LineNo = Convert.ToDecimal(s.LineNo),
                ErpNo = s.FBillNo,
                PoLineNo = s.OrderlineId,
                ProductCode = s.ProductCode,
                SlUnit = s.PurchaseUnit,
                KcUnit = s.InventoryUnit,
                DeliveryQty = Convert.ToDecimal(s.DeliveryQty),
                Remark = s.Remark,
                CreateDate = DateTime.Now,
                PurchaseQty = Convert.ToDecimal(s.PurchaseQty),
                IncludeQty = Convert.ToDecimal(s.IncludeQty),
                DepotCode = s.DepotNo,
                IsGift = s.IsGift
            };
            return entity;
        }).ToList();
    }
}