1111

啊鑫

5 天以前 00a72fff219241eb5b0405a066cc859d07cf7735

 service/base/WmsBaseMangeer.cs

@@ -1,15 +1,20 @@
using System.Data;
using System.Data.SqlClient;
using NewPdaSqlServer.DB;
namespace NewPdaSqlServer.service.@base
{
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;
    using System;
    using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
    using System.Data;
    using NewPdaSqlServer.DB;
    using System.Data;
    using System.Data.SqlClient;
    using Microsoft.EntityFrameworkCore.Metadata.Internal;

namespace NewPdaSqlServer.service.@base;

public class WmsBaseMangeer : Repository<dynamic>
{

    /// <summary>
    ///     通用入库校验
    /// </summary>
@@ -38,22 +43,15 @@
            {
                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_sectionCode", SqlDbType.NVarChar, 100) { Value = sectionCode },
                new("@pi_stockId", SqlDbType.NVarChar, 100) { Value = stockId },
                new("@pi_stockOrgId", SqlDbType.NVarChar, 100)
                    { Value = stockOrgId },
                    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 }
                    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
@@ -73,7 +71,7 @@
                {
                    barcode = barcode,
                    strMsg = outputMsg,
                    result = outputStatus.ToString()
                        result = outputStatus.ToString(),
                    // 其他需要映射的字段...
                };
            }
@@ -128,17 +126,25 @@
            throw new ArgumentNullException(nameof(ownerId));

        if (Db.Queryable<SysOrganization>().Any(x => x.Fid == ownerId))
            {
            return "BD_OwnerOrg";

        if (Db.Queryable<MesCustomer>()
            .Any(x => x.Id == Convert.ToInt32(ownerId))) return "BD_Customer";

        if (Db.Queryable<MesSupplier>()
            .Any(x => x.Id == Convert.ToInt32(ownerId))) return "BD_Supplier";

        if (Db.Queryable<SysOrganization>().Any(x => x.Fid == ownerId))
            }
            else if (Db.Queryable<MesCustomer>().Any(x => x.Id == Convert.ToInt32(ownerId)))
            {
                return "BD_Customer";
            }
            else if (Db.Queryable<MesSupplier>().Any(x => x.Id == Convert.ToInt32(ownerId)))
            {
                return "BD_Supplier";
            }
            else if (Db.Queryable<SysOrganization>().Any(x => x.Fid == ownerId))
            {
            return "BD_OwnerOrg";
            }

        throw new Exception("无法确定货主类型，请检查货主ID是否正确！");
    }

        
    }
}