/// <summary>
/// 方法：查询用户信息
/// </summary>
/// <returns>返回对象集合</returns>
public List <Model.CustomerMusic> SelectLogin(string phone, string pwd)
{
List <Model.CustomerMusic> list = new List <Model.CustomerMusic>();
string sql = "select c.*,r.RankName from CustomerMusic c left join RankUser r on c.RankID=r.RankID where c.Phone='" + phone + "' and c.UserPwd='" + pwd + "'";
SqlDataReader dr = Dbhelper.ExecReader(sql);
if (dr != null)
{
while (dr.Read())
{
list.Add(new Model.CustomerMusic(
(int)dr["ID"],
dr["UserName"].ToString(),
dr["UserPwd"].ToString(),
dr["Phone"].ToString(),
dr["Birthday"].ToString(),
dr["Sex"].ToString(),
dr["Email"].ToString(),
dr["LastLoginTime"].ToString(),
dr["Remark"].ToString(),
(int)dr["State"],
(int)dr["RankID"],
dr["RankName"].ToString()
));
}
dr.Close();
}
return(list);
}
/// <summary>
/// 查询方法
/// </summary>
/// <param name="albuID">歌单编号</param>
/// <returns>查询对象</returns>
public List <Model.Music> GetMusicData(int albuID)
{
List <Model.Music> cs = new List <Model.Music>();
string sql = "select * from Muisc_Song_Type d where d.AlbID=" + albuID + "";
SqlDataReader dr = Dbhelper.ExecReader(sql);
if (dr != null)
{
while (dr.Read())
{
cs.Add(new Model.Music(dr["MusicID"].ToString(), dr["MusicName"].ToString(), dr["Dearmer"].ToString(), dr["MusicTime"].ToString(), (int)dr["SongsterID"], (int)dr["MusicTypeID"], dr["Musicyear"].ToString(), (int)dr["ID"], (int)dr["Musicheart"], (int)dr["State"], dr["SongsterName"].ToString(), dr["TypeName"].ToString(), (int)dr["AlbID"]));
}
dr.Close();
}
return(cs);
}
/// <summary>
/// 查询方法：显示歌单
/// </summary>
/// <param name="x"></param>
/// <returns></returns>
public List <Model.Albummusic> SelectAlbu(int x)
{
List <Model.Albummusic> cs = new List <Model.Albummusic>();
string sql = "select * from Albummusic where ID=" + x + "";
SqlDataReader dr = Dbhelper.ExecReader(sql);
if (dr != null)
{
while (dr.Read())
{
cs.Add(new Model.Albummusic((int)dr["AlbumID"], dr["AlbumName"].ToString(), dr["Albumabstract"].ToString(), (int)dr["ID"], dr["AlbuTime"].ToString(), (int)dr["Listeners"], dr["ImageUrl"].ToString()));
}
dr.Close();
}
return(cs);
}
