202309U/YZXYH2017/YZXYH.Repository/HobbyInfoRepository.cs


using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace YZXYH.Repository
{
	public partial class HobbyInfoRepository
	{
		public string GetHobbies()
		{
			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.HobbyName + "</option>");
			}
			return sb.ToString();
		}

		public string GetHobbies(string id)
		{
			StringBuilder sb = new StringBuilder();
			var hobbies = UnitOfWork.HobbyUserRepository.Get(a => a.UserNo == id);
			List<string> hobbyNos = new List<string>();
			foreach (var hobby in hobbies)
				hobbyNos.Add(hobby.HobbyNo);

			var lists = Get(c => c.IsLocked == "N", a => a.OrderBy(s => s.SortNo));
			foreach (var list in lists)
			{
				if (hobbyNos.Contains(list.Id))
					sb.Append("<option value=\"" + list.Id + "\" selected=\"selected\">" + list.HobbyName + "</option>");
				else
					sb.Append("<option value=\"" + list.Id + "\">" + list.HobbyName + "</option>");
			}
			return sb.ToString();
		}
	}
}