private static void CreatSchoolModle(string schoolType, string[] strContents, string villageID, string cityIDByArea, Village village) { //解析txt所得到学校信息处理 string[] schoolNames = UtilsHelper.GetSchoolsInfo(strContents[1]); int j = AcessDBUser.Instance.ReadMaxShcoolID(villageID); foreach (string schoolName in schoolNames) { try { //删除特殊符号 string dealSchoolName = UtilsHelper.HandleSpecialSymbol(schoolName).Trim(); if (string.IsNullOrEmpty(dealSchoolName)) continue; j++; string shcoolID = string.Format("{0}{1}", villageID, j.ToString().PadLeft(3, '0')); // 如 : 安徽蚌埠美佛儿国际学校 340305012 School school = new School(shcoolID, villageID, cityIDByArea, dealSchoolName, schoolType, string.Empty); //直接插入插入,因为判断的话太耗时了 village.Schools.Add(school); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); throw ex; } } }
private static void CreateVillageModle(string strProvinceData, string schoolType, bool isMuitCity, string[] strContents, string[] areaList, out string cityNameByArea, out string cityIDByArea, out Village village) { //解析txt所得到区域级别处理 string villageName = areaList[areaList.Length - 1].Split('>')[1].Replace(" ", string.Empty); // 荔湾区 string villageID = UtilsHelper.GetAreaID(strContents[0]); //解析txt所得到的ID 如 : 东城区 110101 //解析txt所得到市级信息处理,用于匹配 cityNameByArea = areaList[1]; cityIDByArea = UtilsHelper.GetCityID(strProvinceData, cityNameByArea); //取出来三级目录中的市名称,再匹配二级目录的id就是市级id //根据城市的id和区域的名称去数据库中找区域的名称 if (isMuitCity) { UtilsHelper.DealMuitCityArea(villageName, ref cityNameByArea, ref cityIDByArea); } //从数据库中获取villiageid,找不到则插入 string vID = AcessDBUser.Instance.QureyIDFromVillageDS(villageName, cityIDByArea, isMuitCity); if (!string.IsNullOrEmpty(vID)) //找到的话,赋值给areaID { villageID = vID; } else //找不到,说明数据库中没有此城市对应的区域 { //那么,将更新数据库区域列表:将此条区域记录加入数据库中 AcessDBUser.Instance.InsertVillageInfoToDB(villageID, villageName, cityIDByArea); AcessDBUser.Instance.ClearVillageDS(); } village = new Village() { VillageID = villageID, VillageName = villageName, DistrictID = cityIDByArea }; #region 学校信息处理 CreatSchoolModle(schoolType, strContents, villageID, cityIDByArea, village); #endregion }