1111

啊鑫

昨天 00a72fff219241eb5b0405a066cc859d07cf7735

 service/Warehouse/MesBarCFManager.cs

@@ -1,11 +1,12 @@
using System.Data;
using System.Data.SqlClient;
using Masuit.Tools;
using Masuit.Tools.Hardware;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;

namespace NewPdaSqlServer.service.Warehouse;

@@ -13,7 +14,7 @@
{
    public MesInvItemStocks GetBarInfo(WarehouseQuery unity)
    {
        var barInfo = Db.Queryable<MesInvItemStocks>()
        var barInfo =  Db.Queryable<MesInvItemStocks>()
            .Where(s => s.ItemBarcode == unity.barcode)
            .First();
        if (barInfo is null) throw new Exception("该条码库存不存在！");
@@ -23,16 +24,15 @@

    public dynamic GetBarInfoBefore(WarehouseQuery unity)
    {
        // 使用参数化查询防止SQL注入
        var sqlParams = new List<SugarParameter>
            { new("@barcode", unity.barcode) };

        var sql1 =
            @"SELECT 1 FROM MES_INV_ITEM_STOCKS WHERE ITEM_BARCODE =@barcode ";
        // 使用参数化查询防止SQL注入
        var sqlParams = new List<SugarParameter> { new("@barcode", unity.barcode) };

        var sql1 = @"SELECT 1 FROM MES_INV_ITEM_STOCKS WHERE ITEM_BARCODE =@barcode ";

        var KcInfo = Db.Ado.SqlQuery<dynamic>(sql1, sqlParams);

        if (KcInfo.Count > 0) throw new Exception("该条码已入库不能进行入库前拆分！");
        if(KcInfo.Count > 0) throw new Exception("该条码已入库不能进行入库前拆分！");


        //var sql3 = @"SELECT 1 FROM MES_INV_ITEM_CGYT_C_DETAILS WHERE ITEM_BARCODE =@barcode";
@@ -41,11 +41,9 @@

        //if (YtInfo.Count > 0) throw new Exception("该条码已扫描退料不能进行入库前拆分！");

        var sql2 =
            @"SELECT ITEM_ID,QUANTITY FROM MES_INV_ITEM_BARCODES WHERE ITEM_BARCODE =@barcode ";
        var sql2 = @"SELECT ITEM_ID,QUANTITY FROM MES_INV_ITEM_BARCODES WHERE ITEM_BARCODE =@barcode ";

        var barInfo =
            Db.Ado.SqlQuery<dynamic>(sql2, sqlParams).FirstOrDefault();
        var barInfo = Db.Ado.SqlQuery<dynamic>(sql2, sqlParams).FirstOrDefault();

        if (barInfo is null) throw new Exception("该条码信息不存在！");

@@ -66,7 +64,7 @@
    {
        var _strMsg = "";
        var _intSum = "";
        var _cfBar = ""; //拆分后条码
        var _cfBar = "";//拆分后条码
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            if (unity.userName.IsNullOrEmpty()) throw new Exception("用户名不允许为空");
@@ -86,7 +84,8 @@
                        new("@barcode_new", SqlDbType.NVarChar, 300),
                        new("@c_user", unity.userName),
                        new("@p_old_barcode", unity.barcode),
                        new("@p_qty", unity.CfNum)
                        new("@p_qty", unity.CfNum),

                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
@@ -105,8 +104,8 @@

                    var dto = new ProductionPickDto
                    {
                        barcode = unity.barcode, //原条码
                        cfBarcode = _cfBar //拆分后条码
                        barcode = unity.barcode,//原条码
                        cfBarcode = _cfBar//拆分后条码
                    };
                    return dto;

@@ -116,6 +115,7 @@
                    //return _strMsg;

                    //return 0;

                }
                catch (Exception ex)
                {
@@ -133,7 +133,7 @@
    {
        var _strMsg = "";
        var _intSum = "";
        var _cfBar = ""; //拆分后条码
        var _cfBar = "";//拆分后条码
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            if (unity.userName.IsNullOrEmpty()) throw new Exception("用户名不允许为空");
@@ -153,7 +153,8 @@
                        new("@barcode_new", SqlDbType.NVarChar, 300),
                        new("@c_user", unity.userName),
                        new("@p_old_barcode", unity.barcode),
                        new("@p_qty", unity.CfNum)
                        new("@p_qty", unity.CfNum),

                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
@@ -172,8 +173,8 @@

                    var dto = new ProductionPickDto
                    {
                        barcode = unity.barcode, //原条码
                        cfBarcode = _cfBar //拆分后条码
                        barcode = unity.barcode,//原条码
                        cfBarcode = _cfBar//拆分后条码
                    };
                    return dto;

@@ -183,6 +184,7 @@
                    //return _strMsg;

                    //return 0;

                }
                catch (Exception ex)
                {