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)
{
}
}
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(); }
}
