1.生产退补料优化，日志

南骏 池

2025-03-12 c09e27ad225db06c1ebff340635654c76acc4d2d

1.生产退补料优化，日志

 service/Warehouse/MesItemBlManager.cs

@@ -298,7 +298,7 @@
                    PbillNo = query.billNo,
                    ItemId = blDetail.Bld012,
                    DepotId = stockBarcode.DepotsId.ToString(),
                    ItemDabid = womdab.Guid,
                    ItemDabid = blDetail.Id,
                    // Unit = blDetail.Bld009,
                    // DepotId = (int)stockBarcode.DepotsId
                }).IgnoreColumns(true).ExecuteCommand();
@@ -932,6 +932,13 @@

            if (executeCommand <= 1) throw new Exception("更新失败");


            // 创建 插入日志
            var logService = new LogService();
            var LogMsg = "[PDA]" + query.Type + "。条码【" + query.barcode + "】 出库单号【" + outNo + "】";
            logService.CreateLog(db, query.userName, womdaa.Guid.ToString(), "WOMDAA", LogMsg, womdaa.Daa001);


            return executeCommand;
        }) > 0;


 service/Warehouse/MesItemTblManager.cs

@@ -312,7 +312,8 @@
                    LineK3id = c_mes_inv_item_barcodes.LineK3id,
                    ItemId = c_mes_inv_item_barcodes.ItemId,
                    DepotCode = c_mes_depots.DepotCode,
                    DepotId = c_depot_code.ToString()
                    DepotId = c_depot_code.ToString(),
                    itemDabid = C_MES_ITEM_TBL_DETAIL.Tlid.ToString()
                }).IgnoreColumns(true).ExecuteCommand();
            else
                // 存在时更新数量
@@ -554,6 +555,11 @@
                throw new Exception(
                    $"关键数据插入失败，预期至少{minimumExpectedOperations}个操作，实际执行{totalResult}个操作");

            // 创建 插入日志
            var logService = new LogService();
            var LogMsg = "[PDA]生产退料。条码【" + query.barcode + "】 退料单号【" + c_bill_no + "】";
            logService.CreateLog(db, query.userName, tbWOMDAA.Guid.ToString(), "WOMDAA", LogMsg, tbWOMDAA.Daa001);

            return totalResult;
        });


 service/Wom/WwGdManager.cs

@@ -696,7 +696,7 @@

            // 创建 插入日志
            var logService = new LogService();
            var LogMsg = "委外退料。条码【" + query.barcode + "】 退料单号【" + c_bill_no + "】";
            var LogMsg = "[PDA]委外退料。条码【" + query.barcode + "】 退料单号【" + c_bill_no + "】";
            logService.CreateLog(db, query.userName, wwgd.Id.ToString(), "WW_GD", LogMsg, wwgd.Daa001);

            return totalResult;
@@ -1069,7 +1069,7 @@

            // 创建 插入日志
            var logService = new LogService();
            var LogMsg = query.Type + "。条码【" +query.barcode+"】 补料单号【"+ outNo +"】";
            var LogMsg = "[PDA]"+query.Type + "。条码【" +query.barcode+"】 出库单号【"+ outNo +"】";
            logService.CreateLog(db,query.userName,wwgd.Id.ToString(), "WW_GD", LogMsg,wwgd.Daa001);

            return 1;

 util/LogUtil.cs

@@ -22,7 +22,7 @@
                .Select(it => it.Guid) //
                .First();

            detail = "[PDA]" + detail;
            //detail = "[PDA]" + detail;
            // 执行存储过程
            db.Ado.ExecuteCommand(
                "exec prc_log_create @edtUserGuid, @abtGuid, @abtTable, @detail, @orderNo",