vue-vben-admin 与.net core 结合实例 【自学与教学 小白教程】---第4节---部门管理

/// <summary>
/// 部门
/// </summary>
public class SysDep : RootEntityBase<int>
{
    public SysDep()
    {
        CreatedTime = DateTime.Now;
    }
    /// <summary>
    /// 机构代码
    /// </summary>
    public string OrgCode { get; set; }
    /// <summary>
    /// 上级代码
    /// </summary>
    public int ParentId { get; set; } = 0;
    /// <summary>
    /// 所属机构
    /// </summary>
    public long OrgId { get; set; }
    /// <summary>
    /// 部门名称
    /// </summary>
    public string DepName { get; set; }

    /// <summary>
    /// 部门代码
    /// </summary>
    public string DepCode { get; set; }

    /// <summary>
    /// 排序
    /// </summary>
    public int OrderNo { get; set; }

    /// <summary>
    /// 添加时间
    /// </summary>
    [SugarColumn(IndexGroupNameList = new string[] { "index_time1" })]
    public DateTime CreatedTime { get; set; }

    /// <summary>
    /// （子级）不映射数据库字段
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public List<SysDep> Children { get; set; }
    
}

/// <summary>
/// 部门
/// </summary>
[Route("api/[controller]/[action]")]
[ApiController]
public class SysDepController : BaseSimpleController<SysDep>
{
    public SysDepController(IUnitOfWork unitOfWork, IBaseRepository<SysDep> rep, IWebHostEnvironment env)
    {
     
        base._env = env;
        base._rep = rep;
        base._unitOfWork = unitOfWork;
    }

    /// <summary>
    /// 查询树
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    public  async Task<ResultMo<List<SysDep>>> SearchTree(QueryPageInput input)
    {
        input.queryKeyValue.Add(new AndWhere {
            FieldName= "ParentId", FieldValue="0"
        } );
        var main = await _rep.QueryPage(input);
        var Ids = main.data.Select(m => m.Id).ToList();
        var re = await _rep.Db.Queryable<SysDep>().Where(m => Ids.Contains(m.Id)|| Ids.Contains(m.ParentId)).
            ToTreeAsync(it => it.Children, it => it.ParentId, 0);
        re.ForEach(m =>
        {
            if (m.Children == null) m.Children = new List<SysDep> { };
        });
        return new ResultMo<List<SysDep>>(re, main.dataCount);

    }
}

 console.log(prams);
    postsearch = [];
    for (let pS in prams) {
      if (pS != "page" && pS != "pageSize" && prams[pS]!=undefined) {
        if (pS.startsWith('find_rp_')) {//find_g_  find_s_
          console.log('日期2');
          console.log(pS.replace('find_rp_',''));
          postsearch.push({
            fieldName: 'find_g_'+pS.replace('find_rp_',''),
            fieldValue: prams[pS][0]
          });
          postsearch.push({
            fieldName:  'find_s_'+pS.replace('find_rp_',''),
            fieldValue: prams[pS][1]
          });

        }
        else {
          postsearch.push({
            fieldName: pS,
            fieldValue: prams[pS]
          });
        }
      }
    }