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

public class MesDeliveryNoteBarcodeManager : Repository<MesDeliveryNoteBarcode>
{
    public List<ReturnBarcode> Save(PrintBarcode barcode)
    {
        int ftype= UseTransaction(db =>
        {
            return SaveOrUpdateData(db, barcode) ? 1 : 0;
        });
        var barcodes = new List<ReturnBarcode>();

        if (ftype >0)
        {
            barcodes = GetMesShdBarcode(barcode.LineNo);
        }

        return barcodes;
    }

    public int SaveBatch(PrintBarcode barcode)
    {
        int ftype = UseTransaction(db =>
        {
            return SaveOrUpdateData(db, barcode) ? 1 : 0;
        });

        return ftype;
    }

    private bool SaveOrUpdateData(SqlSugarScope db, PrintBarcode barcode)
    {
        //定义输入参数
        var inputParam1 = new SugarParameter("PI_ID", barcode.LineNo);
        var inputParam2 = new SugarParameter("PI_QTY", barcode.IncludeQty);
        var inputParam3 = new SugarParameter("PI_COUNT", barcode.FCount);
        var inputParam4 = new SugarParameter("PI_BOXQTY", barcode.PackageQty);
        // 定义输出参数
        var outParam1 = new SugarParameter("PO_RESULT", null, true);
        var outParam2 = new SugarParameter("PO_MSG", null, true);
        // 使用 SqlSugar 执行存储过程
        Db.Ado.ExecuteCommand("BEGIN PRC_MES_CREATE_SHD_BARCODE(:PI_ID,:PI_QTY,:PI_COUNT,:PI_BOXQTY,:PO_RESULT,:PO_MSG); END;", inputParam1,inputParam2,inputParam3,inputParam4,outParam1,outParam2);
        // 获取输出参数的值
        int result = int.Parse((string)outParam1.Value);
        string message = outParam2.Value == DBNull.Value ? string.Empty : (string)outParam2.Value;
        if (result == 1)
        {
            //存储过程失败则事务进行回滚
            db.Ado.RollbackTran();
            throw new Exception(message);
        }
        // 提交事务
        db.Ado.CommitTran();
        return true;
        throw new NotImplementedException("生成失败");
    }


    public dynamic SaveList(List<PrintBarcode> barcode)
    {
        var result = barcode.Select(SaveBatch).ToList();

        List<ReturnBarcode> barcodes = GetMesShdBarcodeBatch(barcode);

        return barcodes;
    }
    public dynamic DeleteBarcode(ErpBarcode barcode)
    {
        return UseTransaction(db =>
        {
            return DeleteData(db, barcode) ? 1 : 0;
        }) > 0;
    }
    public dynamic DeleteBarcodeList(List<ErpBarcode> barcode)
    {
        var result = barcode.Select(DeleteBarcode).ToList();
        return result.All(b => b);
    }

    // 删除数据的方法
    private bool DeleteData(SqlSugarScope db, ErpBarcode barcode)
    {
        var del = db.Deleteable<MesDeliveryNoteBarcode>().Where(s => s.SmallBarcode == barcode.SmallBarcode).ExecuteCommand() > 0;

        if (del) { 
            return true;
        } 
        throw new NotImplementedException("删除失败");
    }

    //返回条码
    public List<ReturnBarcode> GetMesShdBarcode(string LineNo)
    {
        var db = SqlSugarHelper.GetInstance();
        return db.Queryable<MesDeliveryNoteBarcode>()
            .Where(t => t.LineNo == LineNo)
            .OrderBy(t => t.Id)
            .Select(t => new ReturnBarcode
            {
                Barcodes = t.SmallBarcode,
                LineNo = t.LineNo,
                IncludeQty = t.IncludeQty
            })
            .ToList();
    }

    //返回条码（批量）
    public List<ReturnBarcode> GetMesShdBarcodeBatch(List<PrintBarcode> dtoList)
    {
        var barcodeList = new List<ReturnBarcode>();
        var db = SqlSugarHelper.GetInstance();

        foreach (var dto in dtoList)
        {
            // 确保查询返回的是 List<ReturnBarcode>
            var barcode = db.Queryable<MesDeliveryNoteBarcode>()
                            .Where(t => t.LineNo == dto.LineNo)
                            .OrderBy(t => t.Id)
                            .Select(t => new ReturnBarcode
                            {
                                Barcodes = t.SmallBarcode,
                                LineNo = t.LineNo,
                                IncludeQty = t.IncludeQty
                            })
                            .ToList();

            // 使用 AddRange 将 barcode 中的所有对象添加到 barcodeList
            barcodeList.AddRange(barcode);
        }

        return barcodeList;
    }

}