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