下面通过图文并茂的方式给大家分享C#实现KTV点歌系统。
public enum SongPlayState
{
//未播放，播放，重播，切歌
unplayed, played, again, cut
}
public class Song
{
public string SongName { get; set; }//歌曲名称
public string SongURL { get; set; }//歌曲路径
public SongPlayState playState = SongPlayState.unplayed;//默认未播放
internal SongPlayState PlayState { get; set; }
//状态为已播
public void SetSongPlayed()
{
this.PlayState = SongPlayState.played;
}
//重唱
public void SetPlayAgain()
{
this.playState = SongPlayState.again;
}
//切歌
public void SetSongCut()
{
this.playState = SongPlayState.cut;
}
PlayList类中实现切歌 重唱 下一首 等.....
public class PlayList
{
//定义一个长度为、 的歌曲数组，默认存储 首歌曲
public static Song[] SongList = new Song[ ];
public static int SongIndex = ;//当前播放的歌曲在数组中的索引
//点播一首歌曲，其实是将歌曲对象添加到歌曲数组中
public static bool AddSong(Song song)
{
bool success = false;//记录添加歌曲是否成功
for (int i = ; i < SongList.Length; i++)
{
//找到数组中第一个为null的位置
if (SongList[i] == null)
{
SongList[i] = song;
success = true;
break;
}
}
return success;
}
//获取当前播放的歌曲：：既然是获取当前播放的歌曲，返回值肯定是Song类型
public static Song GetPlaySong()
{
if (SongList[SongIndex] != null)
{
return SongList[SongIndex];
}
else
{
return null;
}
}
/// <summary>
/// 播放下一首
/// </summary>
public static void MoveOn()
{
if (SongList[SongIndex] != null && SongList[SongIndex].PlayState == SongPlayState.again)
{
SongList[SongIndex].SetSongPlayed();
}
else
{
SongIndex++;
}
}
/// <summary>
/// 当前播放的歌曲名称
/// </summary>
/// <returns>歌曲名称</returns>
public static string PlayingSongName()
{
string songName = ""; // 歌曲名称
if (SongList[SongIndex] != null)
{
songName = SongList[SongIndex].SongName;
}
return songName;
}
/// <summary>
/// 下一首要播放的歌曲名称
/// </summary>
/// <returns>歌曲名称</returns>
public static string NextSongName()
{
string songName = ""; // 歌曲名称
if (SongList[SongIndex + ] != null)
{
songName = SongList[SongIndex + ].SongName;
}
return songName;
}
//重放当前歌曲
public static void PlayAgain()
{
if (SongList[SongIndex] != null)
{
SongList[SongIndex].SetPlayAgain();
}
}
//切歌
public static void CutSong(int index)
{
int i;//循环变量，代表切歌的位置
if (index == - )//循环变量，代表切割的位置
{
i = SongIndex;
}
else
{
i = index;//从切歌的位置开始，将歌曲逐个向前移一个位置
}
SongList[i].SetSongCut();
while (SongList[i] != null)
{
SongList[i] = SongList[i + ];
i++;
//如果达到数组最后一个元素，就将最后一个元素指向空
if (i == SongList.Length)
{
SongList[i] = null;
}
}
}
}
实现歌手点歌
public FrmMain frmMain;
string connectionStr = "server=.;database=MyKTV;uid=sa";
DBHelp db = new DBHelp();
private SqlConnection con;
//首先要查出数据库中的图片路径和歌曲路径
private void FrmCountry_Load(object sender, EventArgs e)
{
con = new SqlConnection(connectionStr);
con.Open();
string sql = "select resource_path from resource_path where resource_id= ";
string sqlsongpath = "select resource_path from resource_path where resource_id= ";
SqlCommand cmd = new SqlCommand(sql,con);
SqlCommand cmd = new SqlCommand(sqlsongpath, con);
KtvUnit.ImagePath = cmd.ExecuteScalar().ToString();
KtvUnit.SongPath = cmd .ExecuteScalar().ToString();
con.Close();
}
//点击歌手男女或组合时
private void LvOne_Click(object sender, EventArgs e)
{
LoadSingerArea();
}
public string singer_type { get; set; }
private void LoadSingerArea()
{
if (this.LvOne.SelectedItems[ ] != null)
{
LvOne.Visible = false;
LvTwo.Location = LvOne.Location;
LvTwo.Dock = DockStyle.Fill;
LvTwo.Visible = true;
this.singer_type=Convert.ToString(LvOne.SelectedItems[ ].Text);
}
con = new SqlConnection(connectionStr);
string sql = "select singertype_id,singertype_name from singer_type";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr;
try
{
con.Open();
LvTwo.Items.Clear();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
int index = ;
while (dr.Read())
{
ListViewItem lvItem = new ListViewItem();
int typeid = Convert.ToInt (dr["singertype_id"]);
string typename = Convert.ToString(dr["singertype_name"]);
lvItem.Text = typename;
lvItem.Tag = typeid;
lvItem.ImageIndex = index;
LvTwo.Items.Add(lvItem);
index++;
}
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show("系统出现异常" + ex.Message);
}
finally
{
con.Close();
}
}
public string singertype_id { get; set; }
/// <summary>
/// 点击地区类型时
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LvTwo_Click(object sender, EventArgs e)
{
if (this.LvTwo.SelectedItems[ ] != null)
{
LvTwo.Visible = false;
Lvthree.Location = LvTwo.Location;
Lvthree.Dock = DockStyle.Fill;
Lvthree.Visible = true;
this.singertype_id = Convert.ToString(LvTwo.SelectedItems[ ].Tag);
}
string result = singer_type;
if (result != "组合")
{
result = singer_type == "女歌手" ? "女" : "男";
}
con = new SqlConnection(connectionStr);
string sql =string.Format( "select singer_id,singer_name,singer_photo_url from singer_info where singertype_id={ } and singer_Sex='{ }'",singertype_id,result);
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr;
try
{
con.Open();
int index = ;
Lvthree.Items.Clear();
imageList .Images.Clear();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
string photoURL =KtvUnit.ImagePath + Convert.ToString(dr["singer_photo_url"]);
//先给ImageList填充图片
imageList .Images.Add(Image.FromFile(photoURL));
ListViewItem lvItem = new ListViewItem();
lvItem.Text = Convert.ToString(dr["singer_name"]);
lvItem.Tag = Convert.ToString(dr["singer_id"]);
lvItem.ImageIndex = index;
Lvthree.Items.Add(lvItem);
index++;
}
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show("系统出现异常" + ex.Message);
}
finally
{
con.Close();
}
}
public void SongList()
{
//读取数据库，读出该歌手的所有歌曲
StringBuilder sb = new StringBuilder();
//拼接SQL语句
sb.AppendFormat("select song_id,song_name,song_url,singer_name from song_info,singer_info where singer_name='{ }' and song_info.singer_id={ }", Lvthree.SelectedItems[ ].Text, Convert.ToInt (Lvthree.SelectedItems[ ].Tag));
FrmSongList songList = new FrmSongList();
songList.Sql = sb.ToString();
songList.Previous = KtvClient.PrevioisForm.Singer;//指定返回的窗体是按歌手点歌
songList.ShowDialog();
this.Close();
}
private void Lvthree_Click(object sender, EventArgs e)
{
SongList();
}
private void tsSingerMain_Click(object sender, EventArgs e)
{
FrmMain main = new FrmMain();
main.Show();
this.Hide();
}
private void tsSingerBack_Click(object sender, EventArgs e)
{
if (this.LvOne.Visible==true)
{
FrmMain man = new FrmMain();
man.Show();
this.Hide();
}
else if (this.LvTwo.Visible==true)
{
this.LvTwo.Visible = false;
this.LvOne.Visible = true;
}
else if (this.Lvthree.Visible==true)
{
this.Lvthree.Visible = false;
this.LvTwo.Visible = true;
}
}
private void tsSingerCut_Click(object sender, EventArgs e)
{
PlayList.CutSong(- );
}
private void tsSingerAgain_Click(object sender, EventArgs e)
{
PlayList.PlayAgain();
}
private void tsSingerYidian_Click(object sender, EventArgs e)
{
FrmPlayList frm = new FrmPlayList();
frm.Show();
}
拼音点歌
public FrmMain frmMain;
[DllImportAttribute("user .dll")]
private static extern bool AnimateWindow(IntPtr hwnd, int dwTime, int dwFlags);
DBHelp db = new DBHelp();
string connectionStr = "server=.;database=MyKTV;uid=sa";
private void FrmPinYin_Load(object sender, EventArgs e)
{
AnimateWindow(this.Handle, , FrmMain.AW_SLIDE + FrmMain.AW_VER_POSITIVE);
SqlConnection con = new SqlConnection(connectionStr);
con.Open();
db.connection();
string sqlsongpath = "select resource_path from resource_path where resource_id= ";
SqlCommand cmd = new SqlCommand(sqlsongpath, con);
KtvUnit.SongPath = cmd.ExecuteScalar().ToString();
}
private void btnSearch_Click(object sender, EventArgs e)
{
string PinYin = this.txtPinYin.Text;
//判断是否是中文 还是拼音
if (!Regex.IsMatch(this.txtPinYin.Text, @"^[\u e -\u fa ]+$"))
{
StringBuilder PY = new StringBuilder(PinYin);
for (int i = ; i <= PY.Length; i++)
{
PY.Insert(i, "%");
i++;
}
string sql = string.Format("SELECT song_name,singer_name FROM dbo.singer_info, dbo.song_info WHERE dbo.singer_info.singer_id=dbo.song_info.singer_id AND song_ab LIKE '{ }'", PY);
this.dgvPinYinInfo.DataSource = db.dataTable(sql,"PY");
}
else
{
StringBuilder ZW = new StringBuilder(PinYin);
for (int i = ; i < ZW.Length; i++)
{
ZW.Insert(i,"%");
i++;
}
string sql = string.Format("SELECT song_name,singer_name FROM dbo.singer_info, dbo.song_info WHERE dbo.singer_info.singer_id=dbo.song_info.singer_id AND song_name LIKE '{ }'", ZW);
this.dgvPinYinInfo.DataSource = db.dataTable(sql, "PY");
}
}
private void dgvPinYinInfo_DoubleClick(object sender, EventArgs e)
{
string songname = this.dgvPinYinInfo.SelectedRows[ ].Cells["song_name"].Value.ToString();
DBHelp db = new DBHelp();
db.connection();
string sql = string.Format("SELECT song_name,singer_name,song_url,song_photo_url FROM dbo.song_info,dbo.singer_info where dbo.singer_info.singer_id=dbo.song_info.singer_id and song_name='{ }'",songname);
SqlDataReader reader = db.ExecuteReaders(sql.ToString());
Song song;
if (reader.Read())
{
song = new Song();
song.SongName = reader["song_name"].ToString();
song.SongURL = KtvUnit.SongPath+reader["song_url"].ToString();
PlayList.AddSong(song);
}
reader.Close();
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "a";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "b";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "c";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "d";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "e";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "f";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "g";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "h";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "i";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "j";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "k";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "l";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "m";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "n";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "o";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "p";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "q";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "r";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "s";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "t";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "u";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "v";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "w";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "x";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "y";
}
private void pictureBox _Click(object sender, EventArgs e)
{
textBox .Text = textBox .Text + "z";
}
private void FrmPinYin_FormClosing(object sender, FormClosingEventArgs e)
{
AnimateWindow(this.Handle, , FrmMain.AW_SLIDE + FrmMain.AW_VER_POSITIVE);
}
public void Binder()
{
string PinYin = this.textBox .Text;
StringBuilder PY = new StringBuilder(PinYin);
for (int i = ; i <= PY.Length; i++)
{
PY.Insert(i, "%");
i++;
}
string sql = string.Format("SELECT song_name,singer_name FROM dbo.singer_info, dbo.song_info WHERE dbo.singer_info.singer_id=dbo.song_info.singer_id AND song_ab LIKE '{ }'", PY);
DataSet ds = db.dataSet(sql, "PY");
if (ds.Tables["PY"]!=null)
{
ds.Tables["PY"].Clear();
}
this.dgvPinYinInfo.DataSource = db.dataTable(sql, "PY");
}
private void pictureBox _Click(object sender, EventArgs e)
{
string text = textBox .Text;
int index = text.Length - ;
if (index >= )
{
textBox .Text = text.Remove(index);
}
}
private void textBox _TextChanged(object sender, EventArgs e)
{
if (textBox .Text!=string.Empty)
{
Binder();
this.dgvPinYinInfo.AutoGenerateColumns = false;
}
else
{
this.dgvPinYinInfo.DataSource=null;
}
}
private void tsPYMain_Click(object sender, EventArgs e)
{
FrmMain main = new FrmMain();
main.Show();
this.Hide();
}
private void txPYAgain_Click(object sender, EventArgs e)
{
FrmMain main = new FrmMain();
main.Playsong();
}
Song song = new Song();
private void tsPYCut_Click(object sender, EventArgs e)
{
song.playState = SongPlayState.cut;
}
private void tsPYYidian_Click(object sender, EventArgs e)
{
FrmPlayList list = new FrmPlayList();
list.Show();
}
private void tsPYBack_Click(object sender, EventArgs e)
{
Application.Exit();
}
类型点歌
public FrmMain frmMain;
string connectionStr = "server=.;database=MyKTV;uid=sa";
DBHelp db = new DBHelp();
private SqlConnection con;
private void FrmSongType_Load(object sender, EventArgs e)
{
con = new SqlConnection(connectionStr);
con.Open();
string sql = "select resource_path from resource_path where resource_id= ";
string sqlsongpath = "select resource_path from resource_path where resource_id= ";
SqlCommand cmd = new SqlCommand(sqlsongpath,con);
KtvUnit.SongPath = cmd .ExecuteScalar().ToString();
SqlCommand cmd = new SqlCommand(sql, con);
KtvUnit.ImagePath = cmd.ExecuteScalar().ToString();
con.Close();
con = new SqlConnection(connectionStr);
string sql = string.Format("select songtype_id,songtype_name,songtype_URL from song_type");
SqlCommand cmd = new SqlCommand(sql , con);
SqlDataReader dr;
try
{
con.Open();
int index = ;
lvSongType.Items.Clear();
imageList .Images.Clear();
dr = cmd .ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
string photoURL = KtvUnit.ImagePath + Convert.ToString(dr["songtype_URL"]);
//先给ImageList填充图片
imageList .Images.Add(Image.FromFile(photoURL));
ListViewItem lvItem = new ListViewItem();
lvItem.Text = Convert.ToString(dr["songtype_name"]);
lvItem.Tag = Convert.ToString(dr["songtype_id"]);
lvItem.ImageIndex = index;
lvSongType.Items.Add(lvItem);
index++;
}
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show("系统出现异常" + ex.Message);
}
finally
{
con.Close();
}
}
private void LoadSongType()
{
//读取数据库，读出该歌曲类型的所有歌曲
StringBuilder sb = new StringBuilder();
//拼接SQL语句
sb.AppendFormat("select song_info.song_name,singer_info.singer_name,song_info.song_url from singer_info,song_info where song_info.singer_id=singer_info.singer_id and song_info.songtype_id={ }", Convert.ToInt (lvSongType.SelectedItems[ ].Tag));
FrmSongList songList = new FrmSongList();
songList.Sql = sb.ToString();
songList.Previous = KtvClient.PrevioisForm.SongType;//指定返回的窗体是按歌曲类型点歌
songList.ShowDialog();
this.Close();
}
private void lvSongType_Click(object sender, EventArgs e)
{
LoadSongType();
}
private void tsTYSingerMain_Click(object sender, EventArgs e)
{
FrmMain main = new FrmMain();
main.Show();
this.Hide();
}
private void tsTYSingerAgain_Click(object sender, EventArgs e)
{
FrmMain main = new FrmMain();
main.Playsong();
}
Song song = new Song();
private void tsTYSingerCut_Click(object sender, EventArgs e)
{
song.playState = SongPlayState.cut;
}
private void tsTYSingerYidian_Click(object sender, EventArgs e)
{
FrmPlayList list = new FrmPlayList();
list.Show();
}
private void tsTYSingerBack_Click(object sender, EventArgs e)
{
FrmMain main = new FrmMain();
main.Show();
this.Hide();
}
金榜排行
public FrmMain frmMain;
DBHelp db = new DBHelp();
string connectionStr = "server=.;database=MyKTV;uid=sa";
private void FrmJB_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(connectionStr);
con.Open();
db.connection();
string sql = "SELECT song_name,song_play_count FROM dbo.song_info ORDER BY song_play_count DESC";
string sqlsongpath = "select resource_path from resource_path where resource_id= ";
SqlCommand cmd = new SqlCommand(sqlsongpath, con);
KtvUnit.SongPath = cmd.ExecuteScalar().ToString();
DataSet ds = db.dataSet(sql,"Count");
this.dgvSongList.DataSource = ds.Tables["Count"].DefaultView;
}
private void dgvSongList_Click(object sender, EventArgs e)
{
DBHelp db = new DBHelp();
if (dgvSongList.SelectedRows[ ]!=null)
{
string songname = this.dgvSongList.SelectedRows[ ].Cells["SongName"].Value.ToString();
db.connection();
string sql = string.Format("SELECT song_name,singer_name,song_url,song_photo_url FROM dbo.song_info,dbo.singer_info where dbo.singer_info.singer_id=dbo.song_info.singer_id and song_name='{ }'", songname);
SqlDataReader reader = db.ExecuteReaders(sql.ToString());
Song song;
if (reader.Read())
{
song = new Song();
song.SongName = reader["song_name"].ToString();
song.SongURL = KtvUnit.SongPath + reader["song_url"].ToString();
PlayList.AddSong(song);
}
reader.Close();
}
else
{
MessageBox.Show("空");
}
}
数字点歌
public FrmMain frmMain;
string connectionStr = "server=.;database=MyKTV;uid=sa";
DBHelp db = new DBHelp();
private SqlConnection con;
private void FrmNumber_Load(object sender, EventArgs e)
{
con = new SqlConnection(connectionStr);
con.Open();
string sqlsongpath = "select resource_path from resource_path where resource_id= ";
SqlCommand cmd = new SqlCommand(sqlsongpath, con);
KtvUnit.SongPath = cmd.ExecuteScalar().ToString();
con.Close();
for (int i = ; i <= ; i++)
{
for (int j = ; j <= ; j++)
{
Label label = new Label();
label.ForeColor = Color.Red;
label.BackColor = Color.Pink;
label.Font=new System.Drawing.Font("华文彩云", );
label.TextAlign = ContentAlignment.MiddleCenter;
label.Click += label_Click;
this.MouseMove += FrmNumber_MouseMove;
label.MouseHover += label_MouseHover;
label.Size = new System.Drawing.Size( , );
label.Text = j.ToString();
if (i > )
{
label.Text = (j + i + ).ToString();
}
if (i > )
{
label.Text = (j + i + ).ToString();
}
if (i > )
{
label.Text = (j + i + ).ToString();
}
label.Location = new Point( + * j, + * i);
this.Controls.Add(label);
}
}
}
已点列表
private void FrmPlayList_Load(object sender, EventArgs e)
{
SongList();
}
public void SongList()
{
lvSong.Items.Clear();
for (int i = ; i < PlayList.SongList.Length; i++)
{
if (PlayList.SongList[i]!=null)
{
ListViewItem item = new ListViewItem();
item.Text = PlayList.SongList[i].SongName;
item.Tag = i;
string playstate = PlayList.SongList[i].PlayState == SongPlayState.unplayed ? "未播放" : "已播";
item.SubItems.Add(playstate);
lvSong.Items.Add(item);
}
}
}
private void btnClose_Click(object sender, EventArgs e)
{
this.Close();
}
以上就是C#实现KTV点歌系统的全部代码，希望大家喜欢。