111

啊鑫

11 小时以前 971e03ccbe5124d4761f56e71025453d1d4742bc

 util/LogUtil.cs

@@ -1,45 +1,45 @@
using NewPdaSqlServer.DB;
using NewPdaSqlServer.entity;
using SqlSugar;

namespace NewPdaSqlServer.util;

public class LogService : RepositoryNoEntity
namespace NewPdaSqlServer.util
{
    /// <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)
    using NewPdaSqlServer.DB;
    using NewPdaSqlServer.entity;
    using SqlSugar;
    using System;

    public class LogService : RepositoryNoEntity
    {
        var edtUserGuid = db.Queryable<SysUser>()
            .Where(it => it.Account == edtUserNo)
            .Select(it => it.Guid) //
            .First();
        /// <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
            }
        );
    }
            //detail = "[PDA]" + detail;
            // 执行存储过程
            db.Ado.ExecuteCommand(
                "exec prc_log_create @edtUserGuid, @abtGuid, @abtTable, @detail, @orderNo",
                new
                {
                    edtUserGuid,
                    abtGuid,
                    abtTable,
                    detail,
                    orderNo
                }
            );
        }


    public void CreateLogI(
            public void CreateLogI(
        SqlSugarScope db,
        Guid edtUserGuid,
        string abtGuid,
@@ -53,14 +53,11 @@
        int sendStatus,
        string executeTime)
    {
        Db.Ado.ExecuteCommand(
            Db.Ado.ExecuteCommand(
            "exec prc_log_create @edtUserGuid, @abtGuid, @abtTable, @detail, @hNo,@RtnLogGuid, @SendJson, @RtnJson, @xkyBeginTime, @xkyEndTime, @sendStatus, @executeTime",
            new
            {
            new {
                edtUserGuid,
                abtGuid = string.IsNullOrEmpty(abtGuid)
                    ? DBNull.Value
                    : (object)abtGuid,
                abtGuid = string.IsNullOrEmpty(abtGuid) ? DBNull.Value : (object)abtGuid,
                abtTable = (object)abtTable ?? DBNull.Value,
                detail,
                hNo = orderNo,
@@ -73,4 +70,7 @@
                executeTime = (object)executeTime ?? DBNull.Value
            });
    }
    }

    
}