public static int GetSongOpacity(int autoNumber)
{
using (FBirdTask t = new FBirdTask())
{
t.CommandText = "SELECT [Overlay] FROM [Songs] WHERE [AutoNumber] = @AutoNumber";
t.AddParameter("@AutoNumber", autoNumber);
return((int)t.ExecuteScalar());
}
}
public static int GetSongBackground(int autoNumber)
{
using (FBirdTask t = new FBirdTask())
{
t.CommandText = "SELECT [ImageId] FROM [Songs] WHERE [AutoNumber] = @AutoNumber";
t.AddParameter("@AutoNumber", autoNumber);
int r = (int)t.ExecuteScalar();
if (r == -2)
{
r = Program.ConfigHelper.SongDefaultImage;
}
return(r);
}
}
public static int GetNextAutoNumber()
{
using (FBirdTask t = new FBirdTask())
{
t.CommandText = "SELECT MAX([AutoNumber]) FROM [Songs]";
object obj = t.ExecuteScalar();
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj) + 1);
}
}
}
