From 88ebe3f492f8af85d46606a3cc0bad95c4290c66 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 23 八月 2023 13:49:27 +0800
Subject: [PATCH] 查询用户所在的单位编码、显示文件的大小信息等
---
DataLoader/CS/DBHelper.cs | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/DataLoader/CS/DBHelper.cs b/DataLoader/CS/DBHelper.cs
index a51056b..a716e80 100644
--- a/DataLoader/CS/DBHelper.cs
+++ b/DataLoader/CS/DBHelper.cs
@@ -84,5 +84,17 @@
return list;
}
+
+ /// <summary>
+ /// 鏍规嵁鐢ㄦ埛ID鏌ヨ鍗曚綅缂栫爜
+ /// </summary>
+ public static string SelectDepCodeByUid(int userId)
+ {
+ string sql = string.Format("select depcode from lf.sys_user where id = {0}", userId);
+
+ object obj = Tools.DBHelper.GetScalar(sql);
+
+ return null == obj ? null : obj.ToString();
+ }
}
}
--
Gitblit v1.9.3