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