NopCommerce 3.4省市联动

做法有两种，一种是在StateProvince表里面加个字段，另一种是新建两个表，用来存市、县的数据，表结构完全按照StateProvince走就好了。我这里用的是第二种做法，菜鸟一枚，代码写的比较烂，哪里写的不好欢迎提出来以便我提高自己。

第一步：去数据库，新建两个表，表我就不给了，直接给对应的Model

using System.Collections.Generic;
using Nop.Core.Domain.Localization;

namespace Nop.Core.Domain.Directory
{
    /// <summary>
    /// Represents a state/province
    /// </summary>
    public partial class City : BaseEntity, ILocalizedEntity
    {
        private ICollection<County> _counties;
        /// <summary>
        /// Gets or sets the country identifier
        /// </summary>
        public int StateProvinceId { get; set; }

        /// <summary>
        /// Gets or sets the name
        /// </summary>
        public string Name { get; set; }

        /// <summary>
        /// Gets or sets the abbreviation
        /// </summary>
        public string Abbreviation { get; set; }

        /// <summary>
        /// Gets or sets a value indicating whether the entity is published
        /// </summary>
        public bool Published { get; set; }

        /// <summary>
        /// Gets or sets the display order
        /// </summary>
        public int DisplayOrder { get; set; }

        /// <summary>
        /// Gets or sets the country
        /// </summary>
        public virtual StateProvince StateProvince { get; set; }
        public virtual ICollection<County> Countys
        {
            get { return _counties ?? (_counties = new List<County>()); }
            protected set { _counties = value; }
        }
    }

}

using Nop.Core.Domain.Localization;

namespace Nop.Core.Domain.Directory
{
    /// <summary>
    /// Represents a state/province
    /// </summary>
    public partial class County : BaseEntity, ILocalizedEntity
    {
        /// <summary>
        /// Gets or sets the country identifier
        /// </summary>
        public int CityId { get; set; }

        /// <summary>
        /// Gets or sets the name
        /// </summary>
        public string Name { get; set; }

        /// <summary>
        /// Gets or sets the abbreviation
        /// </summary>
        public string Abbreviation { get; set; }

        /// <summary>
        /// Gets or sets a value indicating whether the entity is published
        /// </summary>
        public bool Published { get; set; }

        /// <summary>
        /// Gets or sets the display order
        /// </summary>
        public int DisplayOrder { get; set; }

        /// <summary>
        /// Gets or sets the country
        /// </summary>
        public virtual City City { get; set; }
    }

}

当然，还需要修改StateProvince的Model

using System.Collections.Generic;
using Nop.Core.Domain.Localization;

namespace Nop.Core.Domain.Directory
{
    /// <summary>
    /// Represents a state/province
    /// </summary>
    public partial class StateProvince : BaseEntity, ILocalizedEntity
    {
        private ICollection<City> _cities;
        /// <summary>
        /// Gets or sets the country identifier
        /// </summary>
        public int CountryId { get; set; }

        /// <summary>
        /// Gets or sets the name
        /// </summary>
        public string Name { get; set; }

        /// <summary>
        /// Gets or sets the abbreviation
        /// </summary>
        public string Abbreviation { get; set; }

        /// <summary>
        /// Gets or sets a value indicating whether the entity is published
        /// </summary>
        public bool Published { get; set; }

        /// <summary>
        /// Gets or sets the display order
        /// </summary>
        public int DisplayOrder { get; set; }

        /// <summary>
        /// Gets or sets the country
        /// </summary>
        public virtual Country Country { get; set; }
        public virtual ICollection<City> Citys
        {
            get { return _cities ?? (_cities = new List<City>()); }
            protected set { _cities = value; }
        }
    }

}

第二步：去Service层去做Crud，县、市的基本是一样的，我就只列出来一个。另外一个照着写就完了。

先定义接口：

using System.Collections.Generic;
using Nop.Core.Domain.Directory;

namespace Nop.Services.Directory
{
    public interface ICityService
    {
        void DeleteCity(City city);
        City GetCityById(int cityId);
        City GetByAbbreviation(string abbreviation);
        IList<City> GetCityByStateProvinceId(int stateProvinceId, bool showHidden = false);
        void InsertCity(City city);
        void UpdateCity(City city);
    }
}

去实现接口：

using System;
using System.Collections.Generic;
using System.Linq;
using Nop.Core.Caching;
using Nop.Core.Data;
using Nop.Core.Domain.Directory;
using Nop.Services.Events;

namespace Nop.Services.Directory
{
    public  partial class CityService:ICityService
    {
        #region Constants

        /// <summary>
        /// Key for caching
        /// </summary>
        /// <remarks>
        /// {1} : country ID
        /// </remarks>
        private const string CITYS_ALL_KEY = "Nop.city.all-{0}";
        /// <summary>
        /// Key pattern to clear cache
        /// </summary>
        private const string CITYS_PATTERN_KEY = "Nop.city.";

        #endregion

        #region Fields

        private readonly IRepository<City> _cityRepository;
        private readonly IEventPublisher _eventPublisher;
        private readonly ICacheManager _cacheManager;

        #endregion

        #region Ctor

        /// <summary>
        /// Ctor
        /// </summary>
        /// <param name="cacheManager">Cache manager</param>
        /// <param name="stateProvinceRepository">State/province repository</param>
        /// <param name="eventPublisher">Event published</param>
        public CityService(ICacheManager cacheManager,
            IRepository<City> cityRepository,
            IEventPublisher eventPublisher)
        {
            _cacheManager = cacheManager;
            _cityRepository = cityRepository;
            _eventPublisher = eventPublisher;
        }

        #endregion
        public void DeleteCity(City city)
        {
            if(city==null)
                throw new ArgumentNullException("city");
            _cityRepository.Delete(city);
            _cacheManager.RemoveByPattern(CITYS_PATTERN_KEY);
            _eventPublisher.EntityDeleted(city);
        }

        public City GetCityById(int cityId)
        {
            if (cityId == 0)
            {
                return null;
            }
            return _cityRepository.GetById(cityId);
        }

        public City GetByAbbreviation(string abbreviation)
        {
            var query = from sp in _cityRepository.Table
                where sp.Abbreviation == abbreviation
                select sp;
            var city = query.FirstOrDefault();
            return city;
        }

        public IList<City> GetCityByStateProvinceId(int stateProvinceId, bool showHidden = false)
        {
            string key = string.Format(CITYS_ALL_KEY, stateProvinceId);
            return _cacheManager.Get(key, () =>
            {
                var query= from sp in _cityRepository.Table 
                                 orderby  sp.DisplayOrder
                           where sp.StateProvinceId == stateProvinceId &&
                       (showHidden || sp.Published)
                           select sp;
                var city = query.ToList();
                return city;
            });
        }

        public void InsertCity(City city)
        {
            if (city == null)
                throw new ArgumentNullException("city");

            _cityRepository.Insert(city);

            _cacheManager.RemoveByPattern(CITYS_PATTERN_KEY);

            //event notification
            _eventPublisher.EntityInserted(city);
        }

        public void UpdateCity(City city)
        {
            if (city == null)
                throw new ArgumentNullException("city");

            _cityRepository.Update(city);

            _cacheManager.RemoveByPattern(CITYS_PATTERN_KEY);

            //event notification
            _eventPublisher.EntityUpdated(city);
        }
    }
}

这是市的，县的照着这个写就完了。注意缓存那块也一定要给把那个Key给改了，不然会重名的。

第三步：去Nop.Web.Framework把刚写的这些Service注入。

 builder.RegisterType<CityService>().As<ICityService>().SingleInstance();
            builder.RegisterType<CountyService>().As<ICountyService>().SingleInstance();

第三步：修改他转换po和vo的方法，我这个做的是国内的电子商务网站，所以，国家那里我直接就写死了，而且在后续的界面中，我也直接把国家给干掉了。

public static void PrepareModel(this AddressModel model,
            Address address, bool excludeProperties, 
            AddressSettings addressSettings,
            ILocalizationService localizationService = null,
            IStateProvinceService stateProvinceService = null,
              #region yunchen.bai
         ICityService cityService=null,
            ICountyService countyService=null ,
    #endregion
            Func<IList<Country>> loadCountries = null,
            bool prePopulateWithCustomerFields = false,
            Customer customer = null
         
            )
        {
            if (model == null)
                throw new ArgumentNullException("model");

            if (addressSettings == null)
                throw new ArgumentNullException("addressSettings");

            if (!excludeProperties && address != null)
            {
                model.Id = address.Id;
                model.FirstName = address.FirstName;
                model.LastName = address.LastName;
                model.Email = address.Email;
                model.Company = address.Company;
                model.CountryId = address.CountryId;
                model.CountryName = address.Country != null 
                    ? address.Country.GetLocalized(x => x.Name) 
                    : null;
                model.StateProvinceId = address.StateProvinceId;
                model.StateProvinceName = address.StateProvince != null 
                    ? address.StateProvince.GetLocalized(x => x.Name)
                    : null;
                model.City = address.City;
                model.Address1 = address.Address1;
                model.Address2 = address.Address2;
                model.ZipPostalCode = address.ZipPostalCode;
                model.PhoneNumber = address.PhoneNumber;
                model.FaxNumber = address.FaxNumber;
            }

            if (address == null && prePopulateWithCustomerFields)
            {
                if (customer == null)
                    throw new Exception("Customer cannot be null when prepopulating an address");
                model.Email = customer.Email;
                model.FirstName = customer.GetAttribute<string>(SystemCustomerAttributeNames.FirstName);
                model.LastName = customer.GetAttribute<string>(SystemCustomerAttributeNames.LastName);
                model.Company = customer.GetAttribute<string>(SystemCustomerAttributeNames.Company);
                model.Address1 = customer.GetAttribute<string>(SystemCustomerAttributeNames.StreetAddress);
                model.Address2 = customer.GetAttribute<string>(SystemCustomerAttributeNames.StreetAddress2);
                model.ZipPostalCode = customer.GetAttribute<string>(SystemCustomerAttributeNames.ZipPostalCode);
                model.City = customer.GetAttribute<string>(SystemCustomerAttributeNames.City);
                //ignore country and state for prepopulation. it can cause some issues when posting pack with errors, etc
                //model.CountryId = customer.GetAttribute<int>(SystemCustomerAttributeNames.CountryId);
                //model.StateProvinceId = customer.GetAttribute<int>(SystemCustomerAttributeNames.StateProvinceId);
                model.PhoneNumber = customer.GetAttribute<string>(SystemCustomerAttributeNames.Phone);
                model.FaxNumber = customer.GetAttribute<string>(SystemCustomerAttributeNames.Fax);
            }

            //countries and states
            if (addressSettings.CountryEnabled && loadCountries != null)
            {
                if (localizationService == null)
                    throw new ArgumentNullException("localizationService");

                model.AvailableCountries.Add(new SelectListItem() { Text = localizationService.GetResource("Address.SelectCountry"), Value = "0" });
                foreach (var c in loadCountries())
                {
                    model.AvailableCountries.Add(new SelectListItem()
                    {
                        Text = c.GetLocalized(x => x.Name),
                        Value = c.Id.ToString(),
                        Selected = c.Id == model.CountryId
                    });
                }
                model.CountryId = 21;
                if (address != null)
                {
                    model.CountyId = address.CountyId;
                    model.CityId = address.CityId;
                }
                if (addressSettings.StateProvinceEnabled)
                {
                    //states
                    if (stateProvinceService == null)
                        throw new ArgumentNullException("stateProvinceService");

                    var states = stateProvinceService
                        .GetStateProvincesByCountryId(21)//这块直接给写死成中国
                        .ToList();
                    if (states.Count > 0)
                    {
                        foreach (var s in states)
                        {
                            model.AvailableStates.Add(new SelectListItem()
                            {
                                Text = s.GetLocalized(x => x.Name),
                                Value = s.Id.ToString(), 
                                Selected = (s.Id == model.StateProvinceId)
                            });
                        }
                    }
                    else
                    {
                        model.AvailableStates.Add(new SelectListItem()
                        {
                            Text = localizationService.GetResource("Address.OtherNonUS"),
                            Value = "0"
                        });
                    }
                    #region yunchen.bai 2014.10.27
                    if (cityService == null)
                        throw new ArgumentNullException("cityService");
                    var firstProvince = stateProvinceService.GetStateProvincesByCountryId(21).FirstOrDefault() ??
                                        new StateProvince();
                    var citys =
                        cityService.GetCityByStateProvinceId(model.StateProvinceId != null
                            ? model.StateProvinceId.Value
                            : firstProvince.Id).ToList();
                    var firstCity = cityService.GetCityByStateProvinceId(firstProvince.Id).FirstOrDefault() ??
                                     new City();
                    if (citys.Count > 0)
                    {
                        foreach (var c in citys)
                        {
                           model.AvailableCity.Add(new SelectListItem()
                           {
                               Text = c.GetLocalized(x=>x.Name),
                               Value = c.Id.ToString(),
                               Selected = (c.Id==model.CityId)
                           });
                        }
                    }
                    else
                    {
                        model.AvailableCity.Add(new SelectListItem()
                        {
                            Text = localizationService.GetResource("Address.OtherNonUS"),
                            Value = "0"
                        });
                    }
                    if(countyService==null)
                        throw  new ArgumentNullException("countyService");
                    var counties = countyService.GetCountyByCityId(model.CityId.HasValue?model.CityId.Value:firstCity.Id);
                    if (counties.Count > 0)
                    {
                        foreach (var county in counties)
                        {
                            model.AvailableCounty.Add(new SelectListItem()
                            {
                                Text = county.GetLocalized(x=>x.Name),
                                Value = county.Id.ToString(),
                                Selected = (county.Id==model.CityId)
                            });
                        }
                    }
                    else
                    {
                        model.AvailableCity.Add(new SelectListItem()
                        {
                            Text = localizationService.GetResource("Address.OtherNonUS"),
                            Value = "0"
                        });
                    }

                    #endregion


                }
            }

未完待续.....