public List <MusicItem> GetMusicItems(MusicSearchParameters p)
{
SetSqlFormat("select * from {0}", xmConsts.MusicItems);
if (p.InUsbList.HasValue)
{
AddSqlText(string.Format("inner join {0} usb on usb.ItemId = {1}.Id", xmConsts.UserUsbList, xmConsts.MusicItems));
}
if (p.InPlayList.HasValue)
{
AddSqlText(string.Format("inner join {0} pls on pls.ItemId = {1}.Id", xmConsts.UserPlayList, xmConsts.MusicItems));
}
ClearParameters();
if (!string.IsNullOrEmpty(p.SearchText))
{
StartORGroup();
AddORLikeField("Artist", p.SearchText, LikeSelectionStyle.CheckBoth);
AddORLikeField("FileName", p.SearchText, LikeSelectionStyle.CheckBoth);
AddORLikeField("FullFileName", p.SearchText, LikeSelectionStyle.CheckBoth);
AddORLikeField("Title", p.SearchText, LikeSelectionStyle.CheckBoth);
EndORGroup();
}
if (p.InUsbList.HasValue)
{
AddSqlWhereField("usb.UserId", GlobalAppData.CurrentUser.Id);
}
if (p.InPlayList.HasValue)
{
AddSqlWhereField("pls.UserId", GlobalAppData.CurrentUser.Id);
}
var lst = new List <MusicItem>();
FillList(lst, typeof(MusicItem));
return(lst);
}
public void ClearData(MusicSearchParameters musicSearchParameters)
{
SetSqlFormat("delete from {0}", xmConsts.MusicItems);
ExecuteSql();
}
