智慧商贸系统-商品分类设置

目前我的这个智慧商贸系统算是差不多完工了，给大家展示一下其中内容

下图是商品分类

这分别是树形数据查询、递归方法和下拉框返回和下拉树递归

---

/// <summary>
        /// 返回树形数据查询
        /// </summary>
        /// <returns></returns>
        public ActionResult selectPageProductClassifyList()
        {
            List<R_Product_Classify> types = (from tbPC in myModel.R_Product_Classify where tbPC.userId == userId orderby tbPC.sort select tbPC).ToList();
            //查询到的数据进行返回
            LayuiTableData<ProductClassifyVo> layuiTableData = new LayuiTableData<ProductClassifyVo>();
            List<ProductClassifyVo> data = DealProductTableTreeVoList(types, 0);

            layuiTableData.count = types.Count();
            layuiTableData.data = data;
            return Json(layuiTableData, JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        ///  树形数据 的 递归方法
        /// </summary>
        /// <param name="types"></param>
        /// <param name="pid"></param>
        /// <returns></returns>
        public List<ProductClassifyVo> DealProductTableTreeVoList(List<R_Product_Classify> types, int pid)
        {
            List<ProductClassifyVo> rList = new List<ProductClassifyVo>();
            ProductClassifyVo pcv = null;
            foreach (R_Product_Classify pc in types)
            {
                if (pc.parentId == pid)
                {
                    pcv = new ProductClassifyVo();
                    pcv.classifyId = pc.classifyId;
                    pcv.classifyName = pc.classifyName;
                    pcv.sort = pc.sort;
                    pcv.userId = pc.userId;
                    pcv.status = pc.status;
                    pcv.parentId = pc.parentId;

                    //向数据库查询
                    int num = myModel.R_Product_Classify.Where(o => o.parentId == pcv.classifyId).Count();
                    if (num > 0) //当 大于0时证明 可以继续递归
                    {
                        List<ProductClassifyVo> chidList = DealProductTableTreeVoList(types, pcv.classifyId);
                        pcv.treeList = chidList;
                    }
                    rList.Add(pcv);
                }
            }
            return rList;
        }
        /// <summary>
        /// 树形下拉框的返回
        /// </summary>
        /// <returns></returns>
        public ActionResult SelectForTreeSelect()
        {
            List<R_Product_Classify> product_Classifies = (from tbPC in myModel.R_Product_Classify where tbPC.userId == userId orderby tbPC.sort select tbPC).ToList();
            List<TreeSelectVo> rList = new List<TreeSelectVo>();

            TreeSelectVo tree = new TreeSelectVo();
            tree.id = 0;
            tree.name = "根";
            tree.Checked = false;//是否选中
            tree.open = true;//是否展开
            tree.children = dealTreeSelect(product_Classifies, 0);
            rList.Add(tree);
            return Json(rList, JsonRequestBehavior.AllowGet);
        }
        /// <summary>
        /// 下拉树的递归
        /// </summary>
        /// <param name="listSource"></param>
        /// <param name="pid"></param>
        /// <returns></returns>
        public List<TreeSelectVo> dealTreeSelect(List<R_Product_Classify> listSource, int pid)
        {
            List<TreeSelectVo> rList = new List<TreeSelectVo>();
            TreeSelectVo treeSelectVo = null;
            foreach (R_Product_Classify menu in listSource)
            {
                if (menu.parentId == pid)
                {
                    treeSelectVo = new TreeSelectVo();
                    treeSelectVo.id = menu.classifyId;
                    treeSelectVo.name = menu.classifyName;
                    treeSelectVo.Checked = false; //是否选中
                    treeSelectVo.open = true; //展开

                    int num = myModel.R_Product_Classify.Where(o => o.parentId == treeSelectVo.id).Count();

                    if (num > 0) // 当类型 小于等于2 时 即 为 菜单和 区域 ，至于 按钮时 不用细分的的
                    {
                        List<TreeSelectVo> children = this.dealTreeSelect(listSource, menu.classifyId);
                        if (children.Count > 0)
                        {
                            //  如果 有数据 就 添加 没有就不用管它
                            treeSelectVo.children = children;
                        }
                    }
                    else
                    {  //如果 不等于 目录直接 
                        treeSelectVo.children = null;
                    }
                    rList.Add(treeSelectVo);
                }
            }
            return rList;
        }