From dc00dcd986589c2f19160e711b819f1080576344 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期三, 05 六月 2024 14:14:35 +0800
Subject: [PATCH] 登录更新

---
 Tiger.Business/SYS/Biz.SYS_ORGANIZATION.cs |   47 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 47 insertions(+), 0 deletions(-)

diff --git a/Tiger.Business/SYS/Biz.SYS_ORGANIZATION.cs b/Tiger.Business/SYS/Biz.SYS_ORGANIZATION.cs
index 534c15a..0a903c6 100644
--- a/Tiger.Business/SYS/Biz.SYS_ORGANIZATION.cs
+++ b/Tiger.Business/SYS/Biz.SYS_ORGANIZATION.cs
@@ -98,9 +98,56 @@
             }
         }
 
+        public async Task<string> getProdTreeList(string prodName)
+        {
+            var data = new List<OrgItem>();
+            MES_FACTORY func = null;
+            if (!string.IsNullOrEmpty(prodName))
+            {
+                func = Biz.Db.Queryable<MES_FACTORY>().Where(x => x.FTY_CODE == prodName).First();
+            }
+            var items = await Biz.Db.Queryable<MES_FACTORY>()
+                .Distinct().ToListAsync();
+            //娌℃湁鏌ヨ鐨勬椂鍊�
+            if (func == null)
+            {
+                int i = 0;
+                foreach (var item in items)
+                {
+                    OrgItem deptItem = new();
+                    deptItem.id = item.ID;
+                    deptItem.deptCode = item.FTY_CODE;
+                    deptItem.deptName = item.FTY_NAME;
+                    deptItem.PARENT = "";
+                    deptItem.createTime = item.CREATE_TIME.ToString("yyyy-MM-dd mm:dd:ss");
+                    deptItem.status = 0;
+                    deptItem.remark = item.REMARK;
+                    deptItem.orderNo = i++;
+                    deptItem.children = new();
+                    deptItem.DefaultApi = "";
+                    data.Add(deptItem);
+                }
+            }
+            //鏈夋煡璇㈡潯浠剁殑鏃跺��
+            else
+            {
+
+            }
+
+            //string where = page.sqlcmd;
+            //action.Data = isAsync ? await Db.Queryable<T>().Where(where).ToPageAsync(page.pageIndex, page.pageSize) : Db.Queryable<T>().Where(where).ToPage(page.pageIndex, page.pageSize);
+            //action.Data.draw = page.draw;
+            //action.Message = $"Query {typeof(T).Name} entity page from database success";
+
+            //杞崲Json鏃讹紝鍘婚櫎鍊间负null鐨勫睘鎬�
+            var jsonSetting = new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore };
+            var json = JsonConvert.SerializeObject(data, Formatting.Indented, jsonSetting);
+            return json;
+        }
 
     }
 
+
     /// <summary>
     /// 閮ㄩ棬鏍戝舰鍒楄〃
     /// </summary>

--
Gitblit v1.9.3