//查询用户已经创建的歌单简要信息
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);
}
}
