everlight.eap/backend/DllScan/DAL/OrderMstDal.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Cksoft.Data;
using DllEapEntity;

namespace DllScan.DAL
{
    public class OrderMstDal
    {
        public IDatabase CurrDb;

        public OrderMstDal(IDatabase db)
        {
            CurrDb = db;
        }

        public IEnumerable<OrderMst> GetOrderMsts()
        {
            string errorinfo = string.Empty;
            return CurrDb.FindListForCondition<OrderMst>(string.Empty, ref errorinfo);
        }

        public IEnumerable<MacModel> GetMacModels()
        {
            string errorinfo = string.Empty;
            return CurrDb.FindListForCondition<MacModel>(string.Empty, ref errorinfo);
        }

        /// <summary>
        /// 获取左侧树结构数据
        /// </summary>
        /// <returns></returns>
        public IEnumerable<TreeModel> GetTreeModels()
        {
            var root = new TreeModel() { Id = 0, Name = "根节点", Open = false, IsParent = true };
            var macModels = GetMacModels();
            var ordermsts = GetOrderMsts();
            if (macModels != null && macModels.Count() > 0)
            {
                var secendChildren = new List<TreeModel>();
                foreach (var item in macModels)
                {
                    var macChild = new TreeModel()
                    {
                        Id = 0,
                        Name = item.FCode,
                        Open = false,
                        IsParent = true
                    };
                    var orders = ordermsts.Where(c => c.MModeID == item.ID);  
                    if (orders != null && orders.Count() > 0)
                    {
                        var thirds = new List<TreeModel>();
                        foreach (var order in orders)
                        {
                            thirds.Add(new TreeModel
                            {
                                Id = order.ID,
                                Name =order.FCode+"/"+ order.FName,
                                Children = null
                            });
                        }
                        macChild.Children = thirds;
                    }
                    secendChildren.Add(macChild);
                }
                root.Children = secendChildren;
            }
            var firsts = new List<TreeModel>();
            firsts.Add(root);
            return firsts;
        }
    }
}