/// <summary>
/// 获取所有歌曲类型
/// </summary>
/// <returns></returns>
public List <SingerType> GetAllTypes()
{
List <SingerType> types = new List <SingerType>();
try
{
sql = "select * from tb_singerTypes";
DataSet ds = DatabaseHelper.GetDataSet(sql);
if (ds != null)
{
DataTable dt = ds.Tables[0];
foreach (DataRow r in dt.Rows)
{
SingerType t = new SingerType();
t.Id = Convert.ToInt32(r["Id"]);
t.singType = r["singerType"].ToString();
types.Add(t);
}
}
}
catch (Exception)
{
throw;
}
return(types);
}
public Singer GetByType(SingerType type)
{
return(Singers.FirstOrDefault(e => e.SingerType == type));
}
