namespace NewPdaSqlServer.util
{
    using NewPdaSqlServer.Dto.service;
    using NewPdaSqlServer.entity;
    using SqlSugar;
    using System;
    using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
    using System.Data;
    using NewPdaSqlServer.DB;
    using System.Data;
    using System.Data.SqlClient;


    public class PdaJyMangeer
    {

        /// <summary>
        /// 通用入库校验
        /// </summary>
        /// <param name="db">SqlSugar 数据库上下文</param>
        /// <param name="edtUserNo">操作人工号</param>
        /// <param name="barcode">物料条码</param>
        /// <param name="sectionCode">库位编码</param>
        /// <param name="stockId">仓库ID</param>
        /// <param name="stockOrgId">库存组织ID</param>
        /// <param name="billNo">申请单号</param>
        /// <param name="transactionNo">事务类型</param>
        /// <returns>包含校验结果的数据传输对象</returns>
        public ProductionPickDto SalesReturnCheck(SqlSugarScope db, string edtUserNo,
            string barcode, string sectionCode, string stockId, string stockOrgId,
            string billNo, string transactionNo)
        {
            var outputMsg = "";
            var outputStatus = -1;

            using (var conn = new SqlConnection(DbHelperSQL.strConn))
            using (var cmd = new SqlCommand("prc_pda_inv_JY", conn))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                // 输入参数配置
                SqlParameter[] parameters =
                {
                    new("@pi_user", SqlDbType.NVarChar, 100) { Value = edtUserNo },
                    new("@pi_barcode", SqlDbType.NVarChar, 100) { Value = barcode },
                    new("@pi_sectionCode", SqlDbType.NVarChar, 100) { Value = sectionCode },
                    new("@pi_stockId", SqlDbType.NVarChar, 100) { Value = stockId },
                    new("@pi_stockOrgId", SqlDbType.NVarChar, 100) { Value = stockOrgId },
                    new("@pi_billno", SqlDbType.NVarChar, 100) { Value = billNo },
                    new("@pi_transaction_no", SqlDbType.NVarChar, 10) { Value = transactionNo },
                    new("@pi_val1", SqlDbType.NVarChar, 100) { Value = DBNull.Value }, // 预留扩展字段
                    new("@pi_val2", SqlDbType.NVarChar, 100) { Value = DBNull.Value }, // 预留扩展字段
                    new("@po_outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
                    new("@po_outStatus", SqlDbType.Int) { Direction = ParameterDirection.Output }
                };

                try
                {
                    conn.Open();
                    cmd.Parameters.AddRange(parameters);
                    cmd.ExecuteNonQuery();

                    // 获取输出参数
                    outputMsg = parameters[9].Value?.ToString() ?? "";
                    outputStatus = Convert.ToInt32(parameters[10].Value);

                    if (outputStatus <= 0)
                        throw new Exception(outputMsg);

                    return new ProductionPickDto
                    {
                        barcode = barcode,
                        strMsg = outputMsg,
                        result = outputStatus.ToString(),
                        // 其他需要映射的字段...
                    };
                }
                catch (Exception ex)
                {
                    throw new Exception($"入库校验失败: {ex.Message}");
                }
            }
        }
    }
}