1.OA接口优化。 2.携客云接口调用 3.携客云送货单、送货明细、条码信息实体

南骏 池

2025-05-14 f95dd1ce548f2a465d13f70fe4616410a4d77cc5

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