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