From bd7f147b15efd57c5f054e537e715486c53c25dc Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期五, 28 十一月 2025 17:08:34 +0800
Subject: [PATCH] 标准版
---
WebApi/Gs.Wom/WorkService/WorkProController.cs | 13 ++++++++++---
1 files changed, 10 insertions(+), 3 deletions(-)
diff --git a/WebApi/Gs.Wom/WorkService/WorkProController.cs b/WebApi/Gs.Wom/WorkService/WorkProController.cs
index 8b7528e..6ce5e6c 100644
--- a/WebApi/Gs.Wom/WorkService/WorkProController.cs
+++ b/WebApi/Gs.Wom/WorkService/WorkProController.cs
@@ -49,15 +49,22 @@
sbSql.Append("( ");
sbSql.Append("select top 100000 ROW_NUMBER() over(order by " +
sortName + " " + model.sortOrder +
- ") as rowIndex,cast(0 as bit) as chkInt,a.*,(a.processNo+':'+a.processName) as processNoAndName,(case a.isStatus when 1 then '姝ｅ父' when -1 then '绂佺敤' else cast(a.isStatus as nvarchar(4)) end) as isStatusTxt from WORK_PROCESS a where 1=1" +
- keyWhere);
+ ") as rowIndex,cast(0 as bit) as chkInt,a.*," +
+ "(a.processNo+':'+a.processName) as processNoAndName," +
+ "(case a.isStatus when 1 then '姝ｅ父' when -1 then '绂佺敤' else cast(a.isStatus as nvarchar(4)) end) as isStatusTxt," +
+ "cj.USER_NAME as createByName," +
+ "isnull(gx.USER_NAME,a.lastUpdateBy) as lastupdateByName " +
+ "from WORK_PROCESS a " +
+ "left join SYS_USER cj on cj.ACCOUNT=a.createBy " +
+ "left join SYS_USER gx on gx.ACCOUNT=a.lastUpdateBy " +
+ "where 1=1" + keyWhere);
sbSql.Append(") as T ");
sbSql.Append(" where T.rowindex>(" + currentPage + "-1)*" +
everyPageSize + " and T.rowindex<=" + currentPage + "*" +
everyPageSize);
sbSql.Append(" order by rowindex asc ");
sbSql.Append(
- " select count(1) as intTotal from WORK_PROCESS a where 1=1 " +
+ " select count(1) as intTotal from WORK_PROCESS a left join SYS_USER cj on cj.ACCOUNT=a.createBy left join SYS_USER gx on gx.ACCOUNT=a.lastUpdateBy where 1=1 " +
keyWhere);
var dset = new DataSet();
try
--
Gitblit v1.9.3