From c78e94462c0ba8b3c1ec6fbcddaa3eec9ffcb980 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期四, 18 十二月 2025 16:56:01 +0800
Subject: [PATCH] ERP接口增加详细错误日志
---
WebApi/Gs.JJGZ/MesJjgzErrorJsController.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/WebApi/Gs.JJGZ/MesJjgzErrorJsController.cs b/WebApi/Gs.JJGZ/MesJjgzErrorJsController.cs
index d99e78a..67abb18 100644
--- a/WebApi/Gs.JJGZ/MesJjgzErrorJsController.cs
+++ b/WebApi/Gs.JJGZ/MesJjgzErrorJsController.cs
@@ -104,7 +104,7 @@
string mainTable = "MES_JJGZ_ERRORJS";
try
{
- string sqlMain = $"SELECT * FROM {mainTable} WHERE guid='{guid}'";
+ string sqlMain = $"SELECT a.* ,cj.USER_NAME as createByName ,sh.USER_NAME as checkUserName FROM {mainTable} a left join SYS_USER cj on cj.ACCOUNT=a.create_by left join SYS_USER sh on sh.ACCOUNT=a.CHECK_USER WHERE a.guid='{guid}'";
var dsMain = DbHelperSQL.Query(sqlMain);
if (dsMain != null && dsMain.Tables.Count > 0 && dsMain.Tables[0].Rows.Count > 0)
{
--
Gitblit v1.9.3