1

啊鑫

2024-12-13 7a9c5808da244c8d1b981cf796fbe99d7c167da3

 service/Warehouse/WomdaaManager.cs

@@ -1,5 +1,6 @@
using System.Data;
using System.Data.SqlClient;
using Masuit.Tools;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
@@ -35,7 +36,21 @@
        string _intSum = "";
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd =new SqlCommand("[prc_sys_role_set_menuOrAction]", conn))
            
            if (query.userName.IsNullOrEmpty())
            {
                throw new Exception("用户名不允许为空");
            }
            if (query.daa001.IsNullOrEmpty())
            {
                throw new Exception("领料单号不允许为空");
            }
            if (query.barcode.IsNullOrEmpty())
            {
                throw new Exception("条码不允许为空");
            }
                
            using (var cmd =new SqlCommand("[prc_pda_SCLL]", conn))
            {
                try
                {
@@ -93,6 +108,83 @@
        }
    }

    //prC_pda_SCLL_CF
    public ProductionPickDto ScanCodeCF(WarehouseQuery query)
    {
        
        if (query.userName.IsNullOrEmpty())
        {
            throw new Exception("用户名不允许为空");
        }
        if (query.daa001.IsNullOrEmpty())
        {
            throw new Exception("领料单号不允许为空");
        }
        if (query.barcode.IsNullOrEmpty())
        {
            throw new Exception("条码不允许为空");
        }
        
        if (query.Num is null or 0)
        {
            throw new Exception("条码拆分数不允许为空或者为0");
        }
        
        string _strMsg = "";
        string _intSum = "";
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd =new SqlCommand("[prc_pda_SCLL_CF]", conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.NVarChar, 300),
                        new("@c_User", query.userName),
                        new("@p_biLL_no", query.daa001),
                        new("@p_item_barcode", query.barcode),
                        new("@num", query.Num),
                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);
                    cmd.ExecuteNonQuery();
                    _strMsg  = parameters[0].Value.ToString();
                    _intSum = parameters[1].Value.ToString();
                    

                    var result = Convert.ToInt32(_intSum);
                    if (result <= 0)
                    {
                        throw new Exception(_strMsg);
                    }
                    
                    var dto = new ProductionPickDto
                    {
                        daa001 = query.daa001,
                        barcode = query.barcode
                    };

                    return dto;
                    
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
    }

    private ProductionPickDto getDaa001(WarehouseQuery query)
    {
        if (string.IsNullOrEmpty(query.daa001)) throw new Exception("工单号为空");