c#实现KTV点歌系统

下面通过图文并茂的方式给大家分享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();
 }