From 9441a216b632f9fb8f549a8278fc337367a08a4e Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期三, 06 八月 2025 09:02:13 +0800
Subject: [PATCH] 1.调拨出库优化 2.其他出库优化调整
---
service/base/LoginService.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/service/base/LoginService.cs b/service/base/LoginService.cs
index c483032..e43cb5e 100644
--- a/service/base/LoginService.cs
+++ b/service/base/LoginService.cs
@@ -35,7 +35,7 @@
else
{
string sql = string.Format(@"SELECT A.* FROM MES_SYS_PAGEVIEW A
- LEFT JOIN SYS_USER_BIND B ON A.guid = B.aboutGuid
+ LEFT JOIN SYS_USER_BIND B ON CAST(A.guid AS VARCHAR(100)) = B.aboutGuid
LEFT JOIN SYS_USER C ON C.GUID = B.userGuid
WHERE C.ACCOUNT = '{0}'", name);
pageViewList = Db.Ado.SqlQuery<MesSysPageview>(sql);
@@ -65,7 +65,9 @@
foreach (var pageView in group)
{
var mesFile = Db.Queryable<MesFile>()
- .Where(s => s.ParentGuid == pageView.Guid).First();
+ .Where(s => s.ParentGuid == pageView.Guid)
+ .OrderByDescending(s => s.CreateDate)
+ .First();
var icoimg = "";
if (mesFile != null)
--
Gitblit v1.9.3