Exemplo n.º 1
0
 private void AddDepartmentAndUser(TreeViewNode company, DataTable dt)
 {
     BusiDepartMent department = new BusiDepartMent();
     foreach (DataRow drDepartment in dt.Rows)
     {
         string departmentCode = drDepartment["DEPTCODE"].ToString();
         string departmentName = drDepartment["DEPTNAME"].ToString();
         TreeViewNode departmentNode = BuildNode(departmentCode, string.Empty, departmentName, false, true);
         AddUserNode(departmentNode, departmentCode);
         AddNode(company, departmentNode);
     }
 }
Exemplo n.º 2
0
        public List<TreeViewNode> BuildUserTreeViewData(string queryProvinceShortCode, string queryCityShortCode, string queryDistrictShortCode)
        {
            BusiCompanyService company = new BusiCompanyService();
            BusiDepartMent department = new BusiDepartMent();

            List<TreeViewNode> result = new List<TreeViewNode>();

            //省。
            DataTable dtProvince = company.GetCompanyInfo(queryProvinceShortCode, 2);
            foreach (DataRow drProvince in dtProvince.Rows)
            {
                string provinceName = drProvince["CNAME"].ToString();
                string provinceCode = drProvince["CCODE"].ToString();
                TreeViewNode province = BuildNode(provinceCode, string.Empty, provinceName, true, true);
                DataTable dtProvinceDepartment = department.GetDeptMentInfo(provinceCode);
                AddDepartmentAndUser(province, dtProvinceDepartment);
                result.Add(province);
            }

            List<TreeViewNode> cityNodes = new List<TreeViewNode>();
            DataTable dtCity = company.GetCompanyInfo(queryCityShortCode, 4);

            DataTable dtDistrict = company.GetCompanyInfo(queryDistrictShortCode, 6);

            //市。
            foreach (DataRow drCity in dtCity.Rows)
            {
                string cityName = drCity["CNAME"].ToString();
                string cityCode = drCity["CCODE"].ToString();
                TreeViewNode city = BuildNode(cityCode, string.Empty, cityName, false, true);
                DataTable dtCityDepartment = department.GetDeptMentInfo(cityCode);
                AddDepartmentAndUser(city, dtCityDepartment);

                //区。
                foreach (DataRow drDistrict in dtDistrict.Select("ccode like '" + drCity["SHORTCCODE"].ToString() + "%'"))
                {
                    string districtName = drDistrict["CNAME"].ToString();
                    string districtCode = drDistrict["CCODE"].ToString();
                    TreeViewNode district = BuildNode(districtCode, string.Empty, districtName, false, true);
                    DataTable dtDistrictDepartment = department.GetDeptMentInfo(districtCode);
                    AddDepartmentAndUser(district, dtDistrictDepartment);
                    AddNode(city, district);
                }
                cityNodes.Add(city);
            }

            bool haveProvince = true;
            if (result.Count == 0)
            {
                haveProvince = false;
            }
            foreach (var cityNode in cityNodes)
            {
                if (haveProvince)
                {
                    AddNode(result[0], cityNode);
                }
                else
                {
                    result.Add(cityNode);
                }
            }

            return result;
        }