1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
| 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
| }
| );
| }
|
|
| public void CreateLogI(
| SqlSugarScope db,
| Guid edtUserGuid,
| string abtGuid,
| string abtTable,
| string detail,
| string orderNo,
| string sendJson,
| string rtnJson,
| string xkyBeginTime,
| string xkyEndTime,
| int sendStatus,
| string executeTime)
| {
| db.Ado.ExecuteCommand(
| "exec prc_log_create @edtUserGuid, @abtGuid, @abtTable, @detail, @hNo,@RtnLogGuid, @SendJson, @RtnJson, @xkyBeginTime, @xkyEndTime, @sendStatus, @executeTime",
| new {
| edtUserGuid,
| abtGuid = string.IsNullOrEmpty(abtGuid) ? DBNull.Value : (object)abtGuid,
| abtTable = (object)abtTable ?? DBNull.Value,
| detail,
| hNo = orderNo,
| RtnLogGuid = DBNull.Value,
| SendJson = sendJson,
| RtnJson = rtnJson,
| xkyBeginTime = (object)xkyBeginTime ?? DBNull.Value,
| xkyEndTime = (object)xkyEndTime ?? DBNull.Value,
| sendStatus = (object)sendStatus ?? DBNull.Value,
| executeTime = (object)executeTime ?? DBNull.Value
| });
| }
| }
|
|
| }
|
|
