/// <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); }