精简修正代码

啊鑫

2025-09-10 0aa54059b26e6641196e9953490dd18616e916e3

 service/base/WmsBaseMangeer.cs

@@ -1,20 +1,15 @@
namespace NewPdaSqlServer.service.@base
{
using System.Data;
using System.Data.SqlClient;
using NewPdaSqlServer.DB;
    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>
@@ -43,15 +38,22 @@
                {
                    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
@@ -71,7 +73,7 @@
                    {
                        barcode = barcode,
                        strMsg = outputMsg,
                        result = outputStatus.ToString(),
                    result = outputStatus.ToString()
                        // 其他需要映射的字段...
                    };
                }
@@ -126,25 +128,17 @@
                throw new ArgumentNullException(nameof(ownerId));

            if (Db.Queryable<SysOrganization>().Any(x => x.Fid == ownerId))
            {
                return "BD_OwnerOrg";
            }
            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))
            {

        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))
                return "BD_OwnerOrg";
            }
            
            throw new Exception("无法确定货主类型，请检查货主ID是否正确！");
        }

        
    }
}