using System.Linq;
using System.Text;

namespace YZXYH.Repository
{
	public partial class CityInfoRepository
	{
		public string GetCities()
		{
			StringBuilder sb=new StringBuilder();
			var lists= Get(c=>c.IsLocked=="N", a => a.OrderBy(s => s.SortNo));
			foreach (var list in lists)
			{
				sb.Append("<option value=\"" + list.Id + "\">" + list.CityName + "</option>");
			}
			return sb.ToString();
		}

		public string GetCities(string id)
		{
			StringBuilder sb = new StringBuilder();
			var cityNo = UnitOfWork.AlumUserRepository.GetSingle(a => a.Id == id).CityNo;
			var lists = Get(c => c.IsLocked == "N", a => a.OrderBy(s => s.SortNo));
			foreach (var list in lists)
			{
				if (list.Id == cityNo)
					sb.Append("<option value=\"" + list.Id + "\" selected=\"selected\">" + list.CityName + "</option>");
				else
					sb.Append("<option value=\"" + list.Id + "\">" + list.CityName + "</option>");
			}
			return sb.ToString();
		}

	}
}