Exemplo n.º 1
0
        public static bool ReSetRegionData()
        {
            string        a = "";
            string        connectionString = ConfigurationManager.ConnectionStrings["HidistroSqlServer"].ConnectionString;
            string        path             = Globals.GetphysicsPath("/Installer/SqlScripts/InitRegionData.sql");
            StreamReader  streamReader     = null;
            SqlConnection sqlConnection    = null;

            using (streamReader = new StreamReader(path))
            {
                using (sqlConnection = new SqlConnection(connectionString))
                {
                    DbCommand dbCommand = new SqlCommand
                    {
                        Connection     = sqlConnection,
                        CommandType    = CommandType.Text,
                        CommandTimeout = 500
                    };
                    sqlConnection.Open();
                    while (!streamReader.EndOfStream)
                    {
                        try
                        {
                            string text = RegionHelper.NextSqlFromStream(streamReader);
                            if (!string.IsNullOrEmpty(text))
                            {
                                dbCommand.CommandText = text;
                                dbCommand.ExecuteNonQuery();
                                HiCache.Remove("FileCache-Regions");
                            }
                        }
                        catch (Exception ex)
                        {
                            Globals.WriteExceptionLog(ex, null, "ReSetRegionData");
                            a = ex.Message;
                        }
                    }
                    sqlConnection.Close();
                }
                streamReader.Close();
            }
            if (sqlConnection != null && sqlConnection.State != 0)
            {
                sqlConnection.Close();
                sqlConnection.Dispose();
            }
            if (streamReader != null)
            {
                streamReader.Close();
                streamReader.Dispose();
            }
            if (a != "")
            {
                return(false);
            }
            return(true);
        }
Exemplo n.º 2
0
        public static bool AddRegion(Hidistro.Entities.Store.RegionInfo regionInfo)
        {
            int  num  = regionInfo.RegionId = new RegionDao().GetNewRegionId();
            bool flag = new RegionDao().Add(regionInfo, null) > 0;

            if (flag)
            {
                string fullPath = RegionHelper.GetFullPath(num, true);
                new RegionDao().UpdateFullRegionPath(num, fullPath);
                HiCache.Remove("FileCache-Regions");
            }
            return(flag);
        }
Exemplo n.º 3
0
        public static IList <Hidistro.Entities.Store.RegionInfo> GetAllProvinceLists(bool containDel = true)
        {
            IList <Hidistro.Entities.Store.RegionInfo> allRegions = RegionHelper.GetAllRegions();

            if (containDel)
            {
                return((from r in allRegions
                        where r.Depth == 1
                        select r).ToList());
            }
            return((from r in allRegions
                    where r.Depth == 1 && !r.IsDel
                    select r).ToList());
        }
Exemplo n.º 4
0
 public static int GetRegionId(string county, string city, string province)
 {
     try
     {
         Hidistro.Entities.Store.RegionInfo regionInfo = RegionHelper.FindNodeByRegionName(province.Replace("市", ""), 1);
         if (regionInfo == null)
         {
             regionInfo = RegionHelper.FindNodeByRegionName(province + "省", 1);
         }
         if (regionInfo != null)
         {
             int regionId = regionInfo.RegionId;
             if (string.IsNullOrEmpty(city))
             {
                 return(regionId);
             }
             IList <Hidistro.Entities.Store.RegionInfo> regionChildList = RegionHelper.GetRegionChildList(regionId, true);
             regionInfo = RegionHelper.FindNodeByRegionName(regionChildList, city);
             if (regionInfo == null)
             {
                 regionInfo = RegionHelper.FindNodeByRegionName(regionChildList, city + "市");
             }
             if (regionInfo != null)
             {
                 if (string.IsNullOrEmpty(county))
                 {
                     return(regionId);
                 }
                 regionId = regionInfo.RegionId;
                 IList <Hidistro.Entities.Store.RegionInfo> regionChildList2 = RegionHelper.GetRegionChildList(regionId, true);
                 regionInfo = RegionHelper.FindNodeByRegionName(regionChildList2, county);
                 if (regionInfo != null)
                 {
                     regionId = regionInfo.RegionId;
                 }
             }
             return(regionId);
         }
     }
     catch (Exception ex)
     {
         IDictionary <string, string> dictionary = new Dictionary <string, string>();
         dictionary.Add("Province", province.ToNullString());
         dictionary.Add("city", city.ToNullString());
         dictionary.Add("county", county.ToNullString());
         Globals.WriteExceptionLog(ex, dictionary, "GetRegionId");
     }
     return(0);
 }
Exemplo n.º 5
0
        public static Dictionary <int, string> GetRegions()
        {
            Dictionary <int, string> dictionary = new Dictionary <int, string>();
            IList <Hidistro.Entities.Store.RegionInfo> allRegions = RegionHelper.GetAllRegions();
            IList <Hidistro.Entities.Store.RegionInfo> list       = (from r in allRegions
                                                                     where r.Depth == 0
                                                                     select r).ToList();

            foreach (Hidistro.Entities.Store.RegionInfo item in list)
            {
                int regionId = item.RegionId;
                dictionary.Add(item.RegionId, item.RegionName);
            }
            return(dictionary);
        }
Exemplo n.º 6
0
        public static int GetCountyId(int currentRegionId)
        {
            int result = 0;

            Hidistro.Entities.Store.RegionInfo region = RegionHelper.GetRegion(currentRegionId, true);
            if (region != null)
            {
                if (region.Depth == 4)
                {
                    result = region.ParentRegionId;
                }
                if (region.Depth == 3)
                {
                    result = currentRegionId;
                }
            }
            return(result);
        }
Exemplo n.º 7
0
        public static IDictionary <int, string> GetAllProvinces(bool containDel = true)
        {
            IDictionary <int, string> dictionary = new Dictionary <int, string>();
            IList <Hidistro.Entities.Store.RegionInfo> allRegions = RegionHelper.GetAllRegions();
            IList <Hidistro.Entities.Store.RegionInfo> list       = (!containDel) ? (from r in allRegions
                                                                                     where r.Depth == 1 && !r.IsDel
                                                                                     select r).ToList() : (from r in allRegions
                                                                                                           where r.Depth == 1
                                                                                                           select r).ToList();

            foreach (Hidistro.Entities.Store.RegionInfo item in list)
            {
                int regionId = item.RegionId;
                if (!dictionary.ContainsKey(item.RegionId))
                {
                    dictionary.Add(item.RegionId, item.RegionName);
                }
            }
            return(dictionary);
        }
Exemplo n.º 8
0
        private static Dictionary <int, string> GetChildList(int parentRegionId, bool containDel = true)
        {
            Dictionary <int, string> dictionary = new Dictionary <int, string>();
            IList <Hidistro.Entities.Store.RegionInfo> allRegions = RegionHelper.GetAllRegions();
            IList <Hidistro.Entities.Store.RegionInfo> list       = (!containDel) ? (from a in allRegions
                                                                                     where a.ParentRegionId == parentRegionId && !a.IsDel
                                                                                     select a).ToList() : (from a in allRegions
                                                                                                           where a.ParentRegionId == parentRegionId
                                                                                                           select a).ToList();

            if (list == null)
            {
                return(dictionary);
            }
            foreach (Hidistro.Entities.Store.RegionInfo item in list)
            {
                if (item.RegionId > 0 && !dictionary.ContainsKey(item.RegionId))
                {
                    dictionary.Add(item.RegionId, item.RegionName);
                }
            }
            return(dictionary);
        }
Exemplo n.º 9
0
        public static Hidistro.Entities.Store.RegionInfo GetRegion(int regionId, bool containDel = true)
        {
            IList <Hidistro.Entities.Store.RegionInfo> allRegions = RegionHelper.GetAllRegions();

            Hidistro.Entities.Store.RegionInfo regionInfo = null;
            try
            {
                regionInfo = ((!containDel) ? (from r in allRegions
                                               where r.RegionId == regionId && !r.IsDel
                                               select r).First() : (from r in allRegions
                                                                    where r.RegionId == regionId
                                                                    select r).First());
            }
            catch
            {
            }
            if (regionInfo == null)
            {
                regionInfo = new RegionDao().Get <Hidistro.Entities.Store.RegionInfo>(regionId);
                if (regionInfo != null && regionInfo.Depth == 4)
                {
                    Hidistro.Entities.Store.RegionInfo region = RegionHelper.GetRegion(regionInfo.ParentRegionId, true);
                    if (region != null)
                    {
                        IList <Hidistro.Entities.Store.RegionInfo> streetsOfCity = new RegionDao().GetStreetsOfCity(region.ParentRegionId, containDel);
                        if (streetsOfCity != null && streetsOfCity.Count > 0)
                        {
                            IList <Hidistro.Entities.Store.RegionInfo> allRegions2 = RegionHelper.GetAllRegions();
                            allRegions2 = allRegions2.Concat(streetsOfCity).ToList();
                            HiCache.Remove("FileCache-Regions");
                            HiCache.Insert("FileCache-Regions", allRegions2);
                        }
                    }
                }
            }
            return(regionInfo);
        }
Exemplo n.º 10
0
        public static string GetFullRegion(int currentRegionId, string separator, bool isEndOnProvince = true, int endDpeth = 0)
        {
            Hidistro.Entities.Store.RegionInfo region = RegionHelper.GetRegion(currentRegionId, true);
            if (region == null)
            {
                return(string.Empty);
            }
            if (isEndOnProvince)
            {
                endDpeth = 1;
            }
            string text = region.RegionName;

            if (region.Depth > endDpeth)
            {
                Hidistro.Entities.Store.RegionInfo region2 = RegionHelper.GetRegion(region.ParentRegionId, true);
                while (region2 != null && region2.Depth >= endDpeth)
                {
                    text    = region2.RegionName + separator + text;
                    region2 = RegionHelper.GetRegion(region2.ParentRegionId, true);
                }
            }
            return(text);
        }
Exemplo n.º 11
0
 public static Dictionary <int, string> GetCountys(int cityId, bool containDel = true)
 {
     return(RegionHelper.GetChildList(cityId, containDel));
 }
Exemplo n.º 12
0
 public static Dictionary <int, string> GetCitys(int provinceId, bool containDel = true)
 {
     return(RegionHelper.GetChildList(provinceId, containDel));
 }