保存工艺路线到产品的客户

Ben Lin

2024-10-13 53f33d1f1575f5ce60fb3e6230e569ba4cc0dba5

 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>