示例#1
0
        private void AddChildrenNode(ref CustomerHirerachyViewModel node, List<CustomerHirerachy> allCustomerHirerachy, List<CustomerHirerachy> listCustomer)
        {
            try
            {
                string parentID = node.id;
                var obj = listCustomer.Find(p => p.CustomerHirerachyID == parentID);
                if (obj != null)
                {
                    node.@checked = true;
                }
                List<CustomerHirerachy> lstChildMenu = allCustomerHirerachy.Where(p => p.ParentCustomerHirerachyID == parentID).ToList();// db.Select<CustomerHirerachy>("Status = {0} AND ParentCustomerHirerachyID ={1}", true, parentID).OrderBy(p => p.CustomerHirerachyIndex).ToList();//Danh sách menu con của parentID
                foreach (CustomerHirerachy der in lstChildMenu)
                {
                    CustomerHirerachyViewModel n = new CustomerHirerachyViewModel();
                    n.id = der.CustomerHirerachyID;
                    n.text = der.CustomerHirerachyName;

                    var check = listCustomer.Find(p => p.CustomerHirerachyID == der.CustomerHirerachyID);
                    if (check != null)
                    {
                        n.@checked = true;
                    }

                    n.items = new List<CustomerHirerachyViewModel>();
                    AddChildrenNode(ref n, allCustomerHirerachy, listCustomer);
                    node.items.Add(n);
                }
            }
            catch (Exception)
            {

            }
        }
示例#2
0
        public JsonResult GetCustomerHirerachy(string customerid)
        {
            IDbConnection db = new OrmliteConnection().openConn();
            try
            {
                //select list menu cha
                List<CustomerHirerachy> lstFirstMenu = db.Select<CustomerHirerachy>("Status = 1 AND ParentCustomerHirerachyID ='' ").OrderBy(p => p.CustomerHirerachyIndex).ToList();
                List<CustomerHirerachy> allCustomerHirerachy = db.Select<CustomerHirerachy>("Status = 1 ").OrderBy(p => p.CustomerHirerachyIndex).ToList();

                var listCustomer = new List<CustomerHirerachy>();
                if (!string.IsNullOrEmpty(customerid))
                {
                    listCustomer = db.SqlList<CustomerHirerachy>("p_CustomerHirerachy_Select '" + customerid+"'");
                }

                List<CustomerHirerachyViewModel> lstMenuView = new List<CustomerHirerachyViewModel>();
                foreach (CustomerHirerachy der in lstFirstMenu)
                {
                    CustomerHirerachyViewModel node = new CustomerHirerachyViewModel();
                    node.id = der.CustomerHirerachyID;
                    node.text = der.CustomerHirerachyName;
                    node.items = new List<CustomerHirerachyViewModel>();
                    AddChildrenNode(ref node, allCustomerHirerachy, listCustomer);
                    lstMenuView.Add(node);
                }
                return Json(new { success = true, Data = lstMenuView });
            }
            catch (Exception e)
            {
                return Json(new { success = false, message = e.Message });
            }
            finally { db.Close(); }
        }