1.委外补料优化调整 2.新增PDA日志通用方法

南骏 池

2025-02-21 9937f480fd5e861255b0c51d10d7f1135d4c5db9

1.委外补料优化调整
2.新增PDA日志通用方法

 service/Wom/WwGdManager.cs

@@ -718,17 +718,17 @@
        // å¼€å¯äº‹åŠ¡å¤„理
        var success = UseTransaction(db =>
        {
            query.Type = "委外补料";
            //query.Type = "委外补料";
            var outNoType = "WWBL(委外补料)";
            if (query.Type == "生产补料")
            if (query.Type == "委外补料")
            {
                outNoType = "SCBL(生产补料)";
                outNoType = "WWBL(委外补料)";
            }
            else
            {
                outNoType = "SCCL(生产超领)";
                outNoType = "WWCL(委外超领)";
            }
            outNoType = "WWBL(委外补料)";
            //outNoType = "WWBL(委外补料)";
            // èŽ·å–或创建出库单
            var outId = Guid.NewGuid();
            var outNo = BillNo.GetBillNo(outNoType);
@@ -947,6 +947,11 @@
                    .Where(it => it.Id == mesItemBl.Id)
                    .ExecuteCommand();

            // åˆ›å»º æ’入日志
            var logService = new LogService();
            var LogMsg = query.Type + "。条码【" +query.barcode+"】 è¡¥æ–™å•å·ã€"+ outNo +"】";
            logService.CreateLog(db,query.userName,wwgd.Id.ToString(), "WW_GD", LogMsg,wwgd.Daa001);

            return 1;
        });


 util/LogUtil.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,40 @@
namespace NewPdaSqlServer.util
{
    using NewPdaSqlServer.entity;
    using SqlSugar;
    using System;

    public class LogService
    {
        /// <summary>
        /// åˆ›å»ºæ—¥å¿—记录
        /// </summary>
        /// <param name="db">SqlSugar æ•°æ®åº“上下文</param>
        /// <param name="edtUserNo">用户编号</param>
        /// <param name="abtGuid">关联单据id</param>
        /// <param name="abtTable">表名称</param>
        /// <param name="detail">日志内容</param>
        /// <param name="orderNo">单据号</param>
        public void CreateLog(SqlSugarScope db, string edtUserNo, string abtGuid, string abtTable, string detail, string orderNo)
        {
            var edtUserGuid = db.Queryable<SysUser>()
                .Where(it => it.Account == edtUserNo)
                .Select(it => it.Guid) //
                .First();

            detail = "[PDA]" + detail;
            // æ‰§è¡Œå­˜å‚¨è¿‡ç¨‹
            db.Ado.ExecuteCommand(
                "exec prc_log_create @edtUserGuid, @abtGuid, @abtTable, @detail, @orderNo",
                new
                {
                    edtUserGuid,
                    abtGuid,
                    abtTable,
                    detail,
                    orderNo
                }
            );
        }
    }
}