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
                }
            );
        }
    }
}