/// <summary> /// 企业全称,有效服务合同数量 /// </summary> /// <param name="customerid">客户id</param> /// <returns></returns> public CusContract GetContractInfo(string customerid) { DataTable dt = customerDal.GetContractInfo(customerid); CusContract result = new CusContract(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][1].ToString() == "0") { result.customerName = dt.Rows[i][0].ToString(); result.customerid = dt.Rows[i][3].ToString(); } else { result.customerName = dt.Rows[i][0].ToString(); result.customerid = dt.Rows[i][3].ToString(); } result.contractCount += int.Parse(dt.Rows[i][2].ToString()); } } return(result); }
public static void LoopToAppendChildren(List <CusContract> list, CusContract children) { var subItems = list.Where(x => x.parentId == children.customerid).ToList(); children.children = new List <CusContract>(); children.children.AddRange(subItems); foreach (var item in subItems) { LoopToAppendChildren(list, item); } }
/// <summary> /// 获取客户名称包括该客户的子公司,子部门 /// </summary> /// <param name="customerid">客户id</param> /// <returns></returns> public CusContract GetCustomerName(string customerid) { DataTable dt = customerDal.GetCustomerName(customerid); List <CusContract> list = new List <CusContract>(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { CusContract result = new CusContract(); result.customerid = dt.Rows[i][0].ToString(); result.customerName = dt.Rows[i][1].ToString(); result.parentId = dt.Rows[i][2].ToString(); list.Add(result); } } CusContract root = list.First(x => x.customerid == customerid); TreeHelper.LoopToAppendChildren(list, root); //string json = JsonConvert.SerializeObject(root); return(root); }