From bd7f147b15efd57c5f054e537e715486c53c25dc Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期五, 28 十一月 2025 17:08:34 +0800
Subject: [PATCH] 标准版
---
WebApi/Gs.JJGZ/MesJjgzTimeTypeController.cs | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/WebApi/Gs.JJGZ/MesJjgzTimeTypeController.cs b/WebApi/Gs.JJGZ/MesJjgzTimeTypeController.cs
index a3a6e22..59c9490 100644
--- a/WebApi/Gs.JJGZ/MesJjgzTimeTypeController.cs
+++ b/WebApi/Gs.JJGZ/MesJjgzTimeTypeController.cs
@@ -38,7 +38,7 @@
m.list = new List<dynamic>();
try
{
- string sqlMain = $"SELECT * FROM MES_JJGZ_TIMETYPE";
+ string sqlMain = $"SELECT a.* ,cj.USER_NAME as createByName FROM MES_JJGZ_TIMETYPE a left join SYS_USER cj on cj.ACCOUNT=a.create_by ";
var dsMain = DbHelperSQL.Query(sqlMain);
if (dsMain != null && dsMain.Tables.Count > 0 &&
dsMain.Tables[0].Rows.Count > 0)
@@ -71,7 +71,8 @@
string mainTable = "MES_JJGZ_TIMETYPE";
try
{
- string sqlMain = $"SELECT * FROM {mainTable} WHERE guid='{guid}'";
+ string sqlMain = $" SELECT a.* ,sh.USER_NAME as checkUserName ,cj.USER_NAME as createByName " +
+ $" FROM {mainTable} a left join SYS_USER sh on sh.ACCOUNT=a.CHECK_USER left join SYS_USER cj on cj.ACCOUNT=a.create_by 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