using Masuit.Tools;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using SqlSugar;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;

namespace NewPdaSqlServer.service.Warehouse;

public class MesKwcxManager : Repository<MesInvItemInCDetails>
{
    public dynamic GetBarInfoList(dynamic unity)
    {
        var sqlParams = new List<SugarParameter>
    {
        new("@deptSectionCode", unity.deptSectionCode),
        new("@rkDate", string.IsNullOrWhiteSpace(unity.rkDate?.ToString()) ? DBNull.Value : unity.rkDate),
        new("@zkChecked", unity.zkChecked?.ToString() == "True" ? 1 : unity.zkChecked?.ToString() == "False" ? 0 : DBNull.Value)
    };

        var sql2 = new StringBuilder("exec prc_pda_kwcx_barInfoList @deptSectionCode, @rkDate, @zkChecked");

        var list = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);

        if (list.Count < 1)
        {
            throw new Exception("该条件下无对应库位信息！");
        }

        return list;
    }
    public dynamic GetBarInfo(dynamic unity)
    {
        var sqlParams = new List<SugarParameter> { };

        var sql2 = new StringBuilder(@"exec prc_pda_kwcx_barInfo @BARCODE");
        sqlParams.Add(new("@BARCODE", unity.barcode));

        var list = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);

        if (list.Count < 1)
        {
            throw new Exception("该条件下无对应条码信息！");
        }

        return list[0];
    }

    public dynamic GetKWList(dynamic unity)
    {

        var sqlParams = new List<SugarParameter> { };

        var sql2 = new StringBuilder(@"
         select depot_code as code, depot_name as name from MES_DEPOTS");


        var XcslItem = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);

        return XcslItem;
    }

    public dynamic GetKWInfo(dynamic unity)
    {
        var sqlParams = new List<SugarParameter>
    {
        new("@depot_code", unity.code)
    };

        var sql2 = new StringBuilder("exec prc_pda_kwcx_kwInfo @depot_code");

        var KWInfo = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);

        return KWInfo;
    }

    public dynamic GetItemInfoList(dynamic unity,dynamic RequestInfo)
    {
        var sqlParams = new List<SugarParameter> { };
        var orgId = RequestInfo.OrgId;

        var sql2 = new StringBuilder(@"exec prc_pda_kwcx_itemInfo @barCode,@itemNo,@orgId");
        sqlParams.Add(new("@barCode", unity.barCode));
        sqlParams.Add(new("@itemNo", unity.itemNo));
        sqlParams.Add(new("@orgId", orgId));

        var list = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);

        if (list.Count < 1)
        {
            throw new Exception("该条件下无对应条码信息！");
        }

        return list;
    }
}