第1页 / 共8页
第2页 / 共8页
第3页 / 共8页
第4页 / 共8页
第5页 / 共8页
第6页 / 共8页
第7页 / 共8页
第8页 / 共8页
c#实现KTV点歌系统.pdf
c#实现实现KTV点歌系统
点歌系统
主要用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;
}
}
///
/// 播放下一首
///
public static void MoveOn()
{
if (SongList[SongIndex] != null && SongList[SongIndex].PlayState == SongPlayState.again)
{
SongList[SongIndex].SetSongPlayed();
}
else
{
SongIndex++;
}
}
///
/// 当前播放的歌曲名称
///
/// 歌曲名称
public static string PlayingSongName()
{
string songName = ""; // 歌曲名称
if (SongList[SongIndex] != null)
{
songName = SongList[SongIndex].SongName;
}
return songName;
}
///
/// 下一首要播放的歌曲名称
///
/// 歌曲名称
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; }
///
/// 点击地区类型时
///
///
///
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点歌系统的全部代码，希望大家喜欢。
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
