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

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

namespace YZXYH.Repository
{
	public partial class VocationInfoRepository
	{
		public string GetVocations()
		{
			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.VocationName + "</option>");
			}
			return sb.ToString();
		}
		public string GetVocations(string id)
		{
			StringBuilder sb = new StringBuilder();
			var vocations = UnitOfWork.VocationUserRepository.Get(a => a.UserNo == id);
			List<string> vocationNos= new List<string>();
			foreach (var vocation in vocations)
				vocationNos.Add(vocation.VocationNo);
			
			var lists = Get(c => c.IsLocked == "N", a => a.OrderBy(s => s.SortNo));
			foreach (var list in lists)
			{
				if (vocationNos.Contains(list.Id))
					sb.Append("<option value=\"" + list.Id + "\" selected=\"selected\">" + list.VocationName + "</option>");
				else
					sb.Append("<option value=\"" + list.Id + "\">" + list.VocationName + "</option>");
			}
			return sb.ToString();
		}
	}
}