Exemplo n.º 1
0
        /// <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);
        }
Exemplo n.º 2
0
        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);
            }
        }
Exemplo n.º 3
0
        /// <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);
        }