//查询用户已经创建的歌单简要信息 public List <Modelsongsheets> getSongsheetsByCreateuserid(int userid) { DataSet set = dalsongsheets.querySongsheetsByCreateuserid(userid); List <Modelsongsheets> list = new List <Modelsongsheets>(); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { Modelsongsheets songsheet = new Modelsongsheets(); songsheet.songsheetId = (int)set.Tables[0].Rows[i].ItemArray[0]; songsheet.songsheetName = set.Tables[0].Rows[i].ItemArray[1].ToString(); songsheet.songsheetContent = set.Tables[0].Rows[i].ItemArray[2].ToString(); songsheet.ispublic = (int)set.Tables[0].Rows[i].ItemArray[3]; list.Add(songsheet); } return(list); }
//关键字搜索歌单简要信息 public List <Modelsongsheets> searchSongsheet(int offset, int rows, string keyword) { string[] keywords = System.Text.RegularExpressions.Regex.Split(keyword, @"\s{1,}"); List <Modelsongsheets> list = new List <Modelsongsheets>(); DataSet data = daltools.querySongsheetByKeyword(offset, rows, keywords); int num = data.Tables[0].Rows.Count; for (int i = 0; i < num; i++) { Modelsongsheets songsheet = new Modelsongsheets(); songsheet.songsheetId = (int)data.Tables[0].Rows[i].ItemArray[1]; songsheet.createuserId = (int)data.Tables[0].Rows[i].ItemArray[2]; songsheet.songsheetName = data.Tables[0].Rows[i].ItemArray[3].ToString(); songsheet.songsheetContent = data.Tables[0].Rows[i].ItemArray[4].ToString(); list.Add(songsheet); } return(list); }
//根据str查询歌单简要信息 public List <Modelsongsheets> getSongsheetBystr(string str) { DataSet set = dalsongsheets.querySongsheetBystr(str); if (set == null) { return(null); } else { List <Modelsongsheets> list = new List <Modelsongsheets>(); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { Modelsongsheets songsheet = new Modelsongsheets(); songsheet.songsheetId = (int)set.Tables[0].Rows[i].ItemArray[0]; songsheet.songsheetName = set.Tables[0].Rows[i].ItemArray[1].ToString(); songsheet.songsheetContent = set.Tables[0].Rows[i].ItemArray[2].ToString(); songsheet.ispublic = (int)set.Tables[0].Rows[i].ItemArray[3]; list.Add(songsheet); } return(list); } }