精简修正代码

啊鑫

9 天以前 0aa54059b26e6641196e9953490dd18616e916e3

 service/Warehouse/MesItemQtrkManager.cs

@@ -1,10 +1,10 @@
using NewPdaSqlServer.DB;
using System.Text.RegularExpressions;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.entity.Base;
using NewPdaSqlServer.util;
using SqlSugar;
using System.Text.RegularExpressions;

namespace NewPdaSqlServer.service.Warehouse;

@@ -30,7 +30,8 @@
        {
            // 返回单号字符串列表
            var blDetails = Db.Ado.SqlQuery<string>(
                "EXEC prc_pda_qtrk_list @pi_orgId,@inP1,@inP2,@inP3,@inP4", parameters);
                "EXEC prc_pda_qtrk_list @pi_orgId,@inP1,@inP2,@inP3,@inP4",
                parameters);
            return blDetails;
        }
        catch (Exception ex)
@@ -57,14 +58,14 @@
        };
        try
        {
            List<dynamic>? blDetails = Db.Ado.SqlQuery<dynamic>(
                "EXEC prc_pda_qtrk_detailList @billNo,@pi_orgId,@inP1,@inP2,@inP3,@inP4", parameters);
            var blDetails = Db.Ado.SqlQuery<dynamic>(
                "EXEC prc_pda_qtrk_detailList @billNo,@pi_orgId,@inP1,@inP2,@inP3,@inP4",
                parameters);
            var items = blDetails.Where(x => x.DSQty > 0).ToList();    // 待扫物料
            var ysitems = blDetails.Where(x => x.SQty > 0).ToList();   // 已扫物料
            return new
            {
                items = items,
                ysitems = ysitems
                items, ysitems
            };
        }
        catch (Exception ex)
@@ -82,7 +83,8 @@
        // 1. 验证库位条码是否为空
        if (string.IsNullOrEmpty(sectionCode)) throw new Exception("请扫库位条码！");

        var sqlParams = new List<SugarParameter> { new("@sectionCode", sectionCode) };
        var sqlParams = new List<SugarParameter>
            { new("@sectionCode", sectionCode) };

        var sql2 = @"        SELECT TOP 1  b.depot_code,
                      b.depot_id,
@@ -118,8 +120,7 @@
            throw new Exception("请扫库位条码！");

        // 2. 查询库位对应的仓库编码和仓库ID
        var depotInfo = Db.Queryable<MesDepotSections, MesDepots>(
                (a, b) =>
        var depotInfo = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
                    new JoinQueryInfos(JoinType.Inner, a.DepotGuid == b.Guid))
            .Where((a, b) => a.DepotSectionCode == p_section_code)
            .Select((a, b) => new { b.DepotCode, b.DepotId })
@@ -131,7 +132,8 @@
        var c_depot_code = depotInfo.DepotCode;
        var c_depot_id = depotInfo.DepotId;

        var sqlParams = new List<SugarParameter> { new("@barcode", p_item_barcode), new("@billNo", p_bill_no) };
        var sqlParams = new List<SugarParameter>
            { new("@barcode", p_item_barcode), new("@billNo", p_bill_no) };

//        var sql1 = @"   SELECT TOP 1 A.rkCkId
//FROM MES_QA_ITEMS_DETECT_01 A
@@ -143,13 +145,8 @@
//        var appDepotInfo = Db.Ado.SqlQuery<dynamic>(sql1, sqlParams).First();




        var mesDepost = Db.Queryable<MesDepots>()
                .Where(s => s.DepotId == c_depot_id).First();

        



        // 3. 验证条码是否已入库
@@ -185,9 +182,11 @@
            throw new Exception($"该条码对应的申请单【{barcode.BillNo}】与当前申请单号不匹配！");

        if (qtrk.Qt008 != c_depot_id.ToString())
            throw new Exception($"该 {p_section_code} 对应的仓库 与 检验判定的入库仓库不一致，请确认！");
            throw new Exception(
                $"该 {p_section_code} 对应的仓库 与 检验判定的入库仓库不一致，请确认！");

        var sql = @"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,
        var sql =
            @"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,
                    ISNULL(A.qd007,0) FQty,ISNULL(A.qd008,0) SQty,ISNULL(A.qd007,0) - ISNULL(A.qd008,0) DSQty
                    FROM MES_ITEM_QTRR_DETAIL A
                    LEFT JOIN MES_ITEM_QTRK B ON A.qtrkGuid = B.guid
@@ -195,7 +194,8 @@
                    WHERE B.qtck = @billNo AND QT015 = 1 AND QT028 = 1 AND QT032 = 1 AND QT014 = 0 ";
        //AND QT014 = 0

        var sqlParams1 = new List<SugarParameter> {
        var sqlParams1 = new List<SugarParameter>
        {
            new("@billNo", p_bill_no)
        };

@@ -224,20 +224,15 @@

        var details = new List<MesItemQtrrDetail>();

        string pattern = @"\(([^)]+)\)";
        Match match = Regex.Match(qtrk.Qt023, pattern);
        var pattern = @"\(([^)]+)\)";
        var match = Regex.Match(qtrk.Qt023, pattern);
        var owner_type = "";

        // 8.获取货主类型
        if (match.Success)
        {
            owner_type = match.Groups[1].Value;
        }
        else
        {
            throw new Exception("其他入库申请单货主类型有误,请核对！");
        }



        // 10. 执行入库事务
@@ -247,7 +242,8 @@
            // 查询是否存在未入库的入库单
            var existingInv = db.Queryable<MesInvItemIns>()
                .Where(x => x.Status == 0
                            && x.InsDate.Value.ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd")
                            && x.InsDate.Value.ToString("yyyy-MM-dd") ==
                            DateTime.Now.ToString("yyyy-MM-dd")
                            && x.TransctionNo == transactionNo.ToString()
                            && x.TaskNo == p_bill_no
                            //&& x.CbillNo == p_bill_no
@@ -289,7 +285,6 @@
                    DepotsId = Convert.ToInt64(c_depot_id) ,
                    InType = "其他入库",
                    ReceiveOrgId = qtrk.Qt022

                }).IgnoreColumns(true).ExecuteCommand();
            }
            else
@@ -334,13 +329,13 @@
                    LineK3id = barcode.LineK3id,
                    ItemId = barcode.ItemId,
                    DepotId = c_depot_id.ToString(),
                    itemDabid = barcode.AboutGuid.ToString(),
                    itemDabid = barcode.AboutGuid.ToString()
                }).IgnoreColumns(true).ExecuteCommand();
            else
                // 存在则更新数量
                res += db.Updateable<MesInvItemInCItems>()
                    .SetColumns(
                        x => x.Quantity == x.Quantity + barcode.Quantity)
                    .SetColumns(x =>
                        x.Quantity == x.Quantity + barcode.Quantity)
                    .Where(x => x.ItemInId == newId
                            && x.ItemId == barcode.ItemId
                            && x.DepotId == c_depot_id.ToString())
@@ -483,8 +478,9 @@
                    .Where(x => x.Guid == detail1.Guid)
                    .ExecuteCommand();

            details = Db.Queryable<MesItemQtrk, MesItemQtrrDetail, MesItems>(
                    (a, b, c) => new JoinQueryInfos(
            details = Db
                .Queryable<MesItemQtrk, MesItemQtrrDetail,
                    MesItems>((a, b, c) => new JoinQueryInfos(
                        JoinType.Left, a.Guid == b.QtrkGuid,
                        JoinType.Left, c.Id.ToString() == b.ItemId))
                .Where((a, b, c) =>
@@ -509,8 +505,10 @@

            // 创建 插入日志
            var logService = new LogService();
            var LogMsg = "【PDA】其他入库。条码【" + query.barcode + "】数量【" + barcode.Quantity.ToString() + "】 入库单号【" + billNo + "】";
            logService.CreateLog(db, query.userName, qtrk.Guid.ToString(), "MES_ITEM_QTRK", LogMsg, qtrk.Qtck);
            var LogMsg = "【PDA】其他入库。条码【" + query.barcode + "】数量【" +
                         barcode.Quantity + "】 入库单号【" + billNo + "】";
            logService.CreateLog(db, query.userName, qtrk.Guid.ToString(),
                "MES_ITEM_QTRK", LogMsg, qtrk.Qtck);

            if (res < 5) throw new Exception("插入或更新失败");