using Tiger.Model;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq.Expressions;
|
using System.Text;
|
using System.Threading.Tasks;
|
using Rhea.Common;
|
using System.Net;
|
using System.Linq;
|
using Newtonsoft.Json;
|
|
namespace Tiger.Business
|
{
|
public partial class Biz
|
{
|
/// <summary>
|
/// 获取所有组织机构列表
|
/// </summary>
|
/// <returns></returns>
|
public async Task<string> getOrgTreeList(string orgName, string status)
|
{
|
var data = new List<OrgItem>();
|
SYS_ORGANIZATION func = null;
|
if (!string.IsNullOrEmpty(orgName))
|
{
|
func = Biz.Db.Queryable<SYS_ORGANIZATION>().Where(x=>x.ORG_NAME == orgName).First();
|
}
|
var items = await Biz.Db.Queryable<SYS_ORGANIZATION>()
|
.WhereIF(!string.IsNullOrEmpty(status),q=>q.STATUS == Convert.ToInt32(status))
|
.OrderBy(x => x.SEQ_NO)
|
.Distinct().ToListAsync();
|
//没有查询的时候
|
if (func == null)
|
{
|
List<SYS_ORGANIZATION> entities = items.OrderBy(x => x.SEQ_NO).ToList().FindAll(t => t.PARENT.IsNullOrEmpty());
|
foreach (var item in entities)
|
{
|
OrgItem deptItem = new();
|
deptItem.id = item.ID;
|
deptItem.deptCode = item.ORG_CODE;
|
deptItem.deptName = item.ORG_NAME;
|
deptItem.PARENT = item.PARENT;
|
deptItem.createTime = item.CREATE_TIME.ToString("yyyy-MM-dd mm:dd:ss");
|
deptItem.status = item.STATUS;
|
deptItem.remark = item.REMARK;
|
deptItem.orderNo= item.SEQ_NO;
|
deptItem.children = new();
|
deptItem.DefaultApi = item.DEFAULTAPI;
|
GetOrgItem(items, item.ORG_CODE, ref deptItem);
|
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>
|
/// <param name="data"></param>
|
/// <param name="parent"></param>
|
/// <param name="pOrgItem"></param>
|
private static void GetOrgItem(List<SYS_ORGANIZATION> data, string parent, ref OrgItem pOrgItem)
|
{
|
List<SYS_ORGANIZATION> entities = data.OrderBy(x => x.SEQ_NO).ToList().FindAll(t => t.PARENT == parent).Distinct().ToList();
|
if (entities.Count > 0)
|
{
|
foreach (var item in entities)
|
{
|
OrgItem deptItem = new();
|
deptItem.id = item.ID;
|
deptItem.deptCode = item.ORG_CODE;
|
deptItem.deptName = item.ORG_NAME;
|
deptItem.PARENT = item.PARENT;
|
deptItem.createTime = item.CREATE_TIME.ToString("yyyy-MM-dd mm:dd:ss");
|
deptItem.status = item.STATUS;
|
deptItem.remark = item.REMARK;
|
deptItem.orderNo = item.SEQ_NO;
|
deptItem.children = new();
|
deptItem.DefaultApi = item.DEFAULTAPI;
|
GetOrgItem(data, item.ORG_CODE, ref deptItem);
|
pOrgItem.children.Add(deptItem);
|
}
|
}
|
}
|
|
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>
|
public class OrgItem
|
{
|
public List<OrgItem> children { get; set; }
|
public int? status { get; set; }
|
public string PARENT { get; set; }
|
public string deptCode { get; set; }
|
public string deptName { get; set; }
|
public string createTime { get; set; }
|
public int? orderNo { get; set; }
|
public string remark { get; set; }
|
public string id { get; set; }
|
public string DefaultApi { get; set; }
|
|
}
|
}
|
