S1的小成果：MyKTV系统

转眼之间，已经到了2016年，即新的一年了！S1也结束了，收获的也不多 ，想想最后留给大家的就一个KTV项目了。

希望大家看时有所收获

          现在我们一起来看KTV前台管理

主界面的运行效果：

主要代码：

 1   
 2         private void MainForm_Load(object sender, EventArgs e)
 3         {
 4             // 加载时，运行播放窗体
 5             FrmPlay playForm = new FrmPlay();
 6             playForm.Show();
 7 
 8             // 启动定时器
 9             this.timer1.Start();  
10 
11             // 读取资源路径
12             DBHelper dbHelper = new DBHelper();
13             string sql = "select resource_path from resource_path where resource_type = 'singer_photo'";
14             SqlCommand command = new SqlCommand(sql, dbHelper.Connection);
15             
16             // 读取歌手照片路径
17             try
18             {
19                 dbHelper.OpenConnection();
20                 KTVUtil.singerPhotoPath = command.ExecuteScalar().ToString();
21             }
22             catch (Exception ex)
23             {
24                 MessageBox.Show("资源路径发生错误！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
25             }
26             finally
27             {
28                 dbHelper.CloseConnection();
29             }
30 
31             // 读取歌曲路径
32             sql = "select resource_path from resource_path where resource_type = 'song'";
33             command.CommandText = sql;
34             try
35             {
36                 dbHelper.OpenConnection();
37                 KTVUtil.songPath = command.ExecuteScalar().ToString();
38             }
39             catch (Exception ex)
40             {
41                 MessageBox.Show("路径错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
42             }
43             finally
44             {
45                 dbHelper.CloseConnection();
46             }
47         }

1 /// <summary>
2 /// 显示当前播放的歌曲名字
3 /// </summary>
4 public void ShowPlayingSongName()
5 {
6 this.lblPlayingSong.Text = PlayList.PlayingSongName();
7 this.lblNextSong.Text = PlayList.NextSongName();
8 }

 同一窗体显示不同界面

如果在一个窗体中显示不同的界面呢？

我们可以转换一下思路，所谓界面不同就是容器不同

解决方案：通过控制Form窗体中ListView控件的显示和隐藏来实现多界面窗体

歌星点歌的运行效果：

 点击第一个LIstView，弹出第二个ListView解析：1.隐藏第一个ListView，显示第二个ListView 的代码

 1         // 点击后，显示歌手类别
 2         private void lvOrder_Click(object sender, EventArgs e)
 3         {
 4             if (lvOrder.SelectedItems[0] != null)
 5             {
 6                 // 隐藏歌手性别，显示歌手类别
 7                 pnlSingerSex.Visible = false;
 8                 pnlSingerType.Location = pnlSingerSex.Location;
 9                 pnlSingerType.Dock = DockStyle.Fill;
10                 pnlSingerType.Visible = true;
11                 this.singerSex = Convert.ToString(lvOrder.SelectedItems[0].Tag);  // 记录选择的性别
12             }      
13     
14             // 读取歌手类别
15             DBHelper dbHelper = new DBHelper();
16             string sql = "select * from singer_type";
17             try
18             {
19                 // 查询数据库
20                 SqlCommand command = new SqlCommand(sql, dbHelper.Connection);
21                 dbHelper.OpenConnection();//相当于con.open
22                 SqlDataReader reader = command.ExecuteReader();
23 
24                 // 循环将类别读取出来添加到ListView中
25                 lvSingerType.Items.Clear();
26                 int i = 0;
27                 while (reader.Read())
28                 {
29                     ListViewItem item = new ListViewItem();
30                     item.Text = Convert.ToString(reader["singertype_name"]);
31                     item.Tag = Convert.ToInt32(reader["singertype_id"]);
32                     item.ImageIndex = i;
33                     lvSingerType.Items.Add(item);
34                     i++;
35                 }
36                 reader.Close();
37             }
38             catch (Exception ex)
39             {
40                 Console.WriteLine(ex.Message);
41                 MessageBox.Show("错误！");
42                 
43             }
44             finally
45             {
46                 dbHelper.CloseConnection();
47             }
48         }

  需要将【男歌手】汉字传递到第二个ListView上 显示5个国家的信息（包括文本和图片）

 需要将【男歌手】汉字传递到第二个ListView上   .显示5个国家的信息（包括文本和图片）

点击第二个ListVIew，填出第三个ListView

效果：

    // 点击类别后，显示对应类别下的歌手列表
        private void lvSingerType_Click(object sender, EventArgs e)
        {
            // 隐藏歌手类别，显示歌手列表
            pnlSingerType.Visible = false;
            pnlSingerList.Location = pnlSingerSex.Location;
            pnlSingerList.Dock = DockStyle.Fill;
            pnlSingerList.Visible = true;
            this.singerTypeId = Convert.ToInt32(lvSingerType.SelectedItems[0].Tag); // 保存选中的类别编号
            
            // 读取数据库，读出歌手信息
            DBHelper dbHelper = new DBHelper();
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("select singer_id,singer_name,singer_photo_url from singer_info where singertype_id={0} and singer_gender='{1}'",
                this.singerTypeId,this.singerSex);
           
            try
            {
                SqlCommand command = new SqlCommand(sql.ToString(),dbHelper.Connection);
                dbHelper.OpenConnection();
                SqlDataReader reader = command.ExecuteReader();

                int imageIndex = 0; // 代表歌手头像的索引
                ilSinger.Images.Clear();

                // 循环读出歌手信息添加到窗体中显示
                lvSinger.Items.Clear();
                while (reader.Read())
                {
                    // 将歌手头像放在ImageList控件中
                    string photoURL = KTVUtil.singerPhotoPath + "\" + Convert.ToString(reader["singer_photo_url"]);
                    ilSinger.Images.Add(Image.FromFile(photoURL));

                    // 将歌手添加到ListView中
                    ListViewItem item = new ListViewItem();
                    item.Text = Convert.ToString(reader["singer_name"]);
                    item.Tag = Convert.ToString(reader["singer_id"]);                   
                    item.ImageIndex = imageIndex;
                    lvSinger.Items.Add(item);

                    imageIndex++;
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                MessageBox.Show("错误！");
            }
            finally
            { 
                dbHelper.CloseConnection(); 
            } 
        }

第三个ListView出来后，点击其中的一个歌手，弹出该歌手演唱的所有歌曲
效果：

1. 
2. 

3.  1   // 点击歌手姓名，打开歌曲列表窗口
    2         private void lvSinger_Click(object sender, EventArgs e)
    3         {
    4             // 读取数据库，读出该歌手的所有歌曲
    5             DBHelper dbHelper = new DBHelper();
    6             StringBuilder sb = new StringBuilder();
    7             sb.AppendFormat("select song_id,song_name, singer_name='{0}',song_url  from song_info where singer_id={1}",
    8                 lvSinger.SelectedItems[0].Text, Convert.ToInt32(lvSinger.SelectedItems[0].Tag));
    9 
   10             FrmSongList songList = new FrmSongList();
   11             songList.Sql = sb.ToString();
   12             songList.Previous = PrevioisForm.Singer; // 指定返回的窗体是按歌手点歌
   13             songList.Show();
   14             this.Close();
   15         }

 我们都知道ListView绑定首列的数据是通过

 1 ListViewItem lvitem = new ListViewItem(stuno);
 2 显示地区图片的代码：  SqlDataReader dr = command.ExecuteReader();
 3 
 4  
 5 
 6                 // 循环将类别读取出来添加到ListView中
 7 
 8                 lvlisttwo.Items.Clear();
 9 
10                 int i = 0;
11 
12                 while (dr.Read())
13 
14                 {
15 
16                     ListViewItem item = new ListViewItem();
17 
18                     item.Text = Convert.ToString(dr["singertype_name"]);
19 
20                     item.Tag = Convert.ToInt32(dr["singertype_id"]);
21 
22                     item.ImageIndex = i;
23 
24                     lvlisttwo.Items.Add(item);
25 
26                     i++;
27 
28                 }
29 
30       dr.Close();

 详细分析：

显示歌手的图片的代码

 1 SqlDataReader dr = cmd.ExecuteReader();
 2 
 3                 int imageIndex = 0; // 代表歌手头像的索引
 4 
 5                 imglistthree.Images.Clear();
 8 
 9                 // 循环读出歌手信息添加到窗体中显示
10 
11                 lvlistthree.Items.Clear();
12 
13                 while (dr.Read())
14 
15                 {
16 
17                     // 将歌手头像放在ImageList控件中
18 
19                     string photoURL = KTVUtil.singerPhotoPath + "\" + Convert.ToString(dr["singer_photo_url"]);
20 
21                     imglistthree.Images.Add(Image.FromFile(photoURL));
24 
25                     // 将歌手添加到ListView中
26 
27                     ListViewItem item = new ListViewItem();
28 
29                     item.Text = Convert.ToString(dr["singer_name"]);
30 
31                     item.Tag = Convert.ToString(dr["singer_id"]);
32 
33                     item.ImageIndex = imageIndex;
34 
35                     lvlistthree.Items.Add(item);
36 
37  
38 
39                     imageIndex++;
40 
41                 }
42 
43                 dr.Close();
44 
45             }

 ListView控件首列不能居中问题

我也没找到解决方法，能做的，也许就是把第一列宽度设为 0，不用第一列，从第二列开始用。

此时 ListView1.Items[i].Text 也不能用了，因为它对应的是 ListView1[i].SubItems[0].Text。

设置ToolStrip对应项图片的大小，通过ImageScalingSize来设置。

04.Panel不能实现同一窗体不同界面。

17. 实现播放歌曲功能 

01.点击某歌曲后，将选择的歌曲添加到已点列表

02.在已点列表中放入一个Timer控件，实时检测每首歌曲的状态

03.在播放窗口中放入一个Timer控件，实时检测需要播放的歌曲

 1      private void PlayForm_Load(object sender, EventArgs e)
 2         {
 3             this.PlaySong();
 4             this.timer1.Start();
 5         }
 6 
 7         /// <summary>
 8         /// 播放歌曲
 9         /// </summary>
10         private void PlaySong()
11         {
12             this.song = PlayList.GetPlayingSong(); // 获取当前要播放的歌曲
13             if (song != null)
14             {
15                 this.song.SetSongPlayed();             // 将当前歌曲播放状态设为已播放
16                 this.wmpSong.URL = KTVUtil.songPath + "\" + this.song.SongURL;  // 得到当前播放歌曲的路径
17             }            
18         }
19 
20         private void timer1_Tick(object sender, EventArgs e)
21         {
22             if(this.song == null)
23             {
24                 this.PlaySong();
25             }
26             if (this.wmpSong.playState == WMPLib.WMPPlayState.wmppsStopped)
27             {
28                 this.song = null; // 将歌曲设为空
29                 PlayList.MoveOn();
30             }
31             // 切歌
32             if (this.song != null && this.song.PlayState == SongPlayState.cut)
33             {
34                 this.wmpSong.URL = "";
35                 this.song = null;
36             }
37         }

实现播放列表操作：

   1.KTVUtil 类：

1 class KTVUtil
2 
3     {
4 
5         public static string singerPhotoPath = "";  // 歌手照片路径
6 
7         public static string songPath = "";         // 歌曲路径
8 
9     }

2.编写歌曲类（Song）

 1 代码例子：enum SongPlayState
 2 
 3     {
 4 
 5         unplayed, played, again, cut
 6 
 7     }
 8 
 9     // 歌曲类
10 
11     class Song
12 
13     {
14 
15         //歌曲名称
16 
17         public string SongName
18 
19         {
20 
21             get { return songName; }
22 
23             set { songName = value; }
24 
25         }
26 
27         //歌曲存放路径
28 
29         public string SongURL
30 
31         {
32 
33             get { return songURL; }
34 
35             set { songURL = value; }
36 
37         }
38 
39         // 歌曲播放状态
40 
41         internal SongPlayState PlayState
42 
43         {
44 
45             get { return playState; }
46 
47             set { playState = value; }
48 
49         }
50 
51         private string songName;
52 
53         private string songURL;
54 
55         // 歌曲播放状态,默认为未播放状态
56 
57         private SongPlayState playState = SongPlayState.unplayed;
58 
59         //将歌曲状态改为已播放
60 
61         public void SetSongPlayed()
62 
63         {
64 
65             this.playState = SongPlayState.played;
66 
67         }
68 
69         // 将歌曲状态改为再拨放一次
70 
71         public void SetPlayAgain()
72 
73         {
74 
75             this.playState = SongPlayState.again;
76 
77         }
78 
79         // 将歌曲状态改为切歌
80 
81         public void SetSongCut()
82 
83         {
84 
85             this.playState = SongPlayState.cut;

3.编写播放列表类（PlayList），提供播放列表的各种方法

代码例子：// 播放列表管理

  1  
  2     class PlayList
  3 
  4     {
  5 
  6         // 歌曲播放列表数组
  7 
  8         private static Song[] songList = new Song[50];
  9 
 10         // 当前播放的歌曲在数组中的索引   
 11 
 12         private static int songIndex = 0;
 13 
 14  // 播放列表数组
 15 
 16         public static Song[] SongList
 17 
 18         {
 19 
 20             get { return PlayList.songList; }
 21 
 22         }
 23 
 24         //当前播放歌曲的索引
 25 
 26         public static int SongIndex
 27 
 28         {
 29 
 30             get { return PlayList.songIndex; }
 31 
 32         }
 33 
 34         // 当前播放的歌曲名称
 35 
 36         public static string PlayingSongName()
 37 
 38         {
 39 
 40             string songName = ""; // 歌曲名称
 41 
 42             if (SongList[SongIndex] != null)
 43 
 44             {
 45 
 46                 songName = SongList[SongIndex].SongName;
 47 
 48             }
 49 
 50             return songName;
 51 
 52         }
 53 
 54         //获取当前播放的歌曲
 55 
 56         public static Song GetPlayingSong()
 57 
 58         {
 59 
 60             if (SongList[songIndex] != null)
 61 
 62            {
 63                return SongList[songIndex];
 64             }
 65 
 66             else
 67 
 68             {
 69                 return null;
 70 
 71             }
 72 
 73         }
 74 
 75         //下一首要播放的歌曲名称
 76 
 77         public static string NextSongName()
 78 
 79         {
 80 
 81             string songName = ""; // 歌曲名称
 82 
 83             if (SongList[SongIndex + 1] != null)
 84 
 85             {
 86                 songName = SongList[SongIndex + 1].SongName;
 87             }
 88             return songName;
 89 
 90         }
 91 
 92  
 93 
 94         // 点播,及添加播放,一首歌曲
 95 
 96         public static bool AddSong(Song song)
 97 
 98         {
 99 
100             //默认为没有添加播放歌曲
101 
102             bool success = false;
103 
104             //for遍历Song[],
105 
106             for (int i = 0; i < SongList.Length; i++)
107             {
108                 if (SongList[i] == null)
109 
110                 {
111 
112                     SongList[i] = song;
113 
114                     // Console.WriteLine(song.SongName);
115 
116                     //返回要播放的歌曲,
117 
118                     success = true;
119 
120                     break;
121                 }
122             }
123     return success;
124 
125         }
126     // 切歌 要切歌曲的编号，如果是切当前播放的歌曲传入-1
127 
128         public static void CutSong(int index)
129 
130         {
131 
132             int i;  // 循环变量，代表切歌的位置
133 
134             if (index == -1)
135 
136             {
137                 i = SongIndex;
138             }
139             else
140             {
141                 i = index; // 从切歌的位置开始，将歌曲逐个向前移一个位置
142             }
143                     SongList[i].SetSongCut();
144             while (SongList[i] != null)
145             {
146                 SongList[i] = SongList[i + 1];
147                 i++;
148           // 如果到达数组最后一个元素，就将最后一个元素指向空
149                 if (i == SongList.Length)
150                 {
151                     SongList[i] = null;
152                 }
153 
154             }
155 
156         }
157    // 重放当前歌曲
158         public static void PlayAgain()
159         {
160             if (SongList[songIndex] != null)
161             {
162                 SongList[songIndex].SetPlayAgain();
163             }
164         }
165 // 播放下一首
166         public static void MoveOn()
167 
168         {
169             if (SongList[songIndex] != null && SongList[songIndex].PlayState == SongPlayState.again)
170             {
171                 SongList[songIndex].SetSongPlayed();
172             }
173             else
174             {
175                 songIndex++;
176 
177             }    }

 去Time控件：在Tick事件中写代码

代码例子：  // 定时扫描歌曲列表，显示当前播放歌曲的名称

 1   private void PlaySong()
 2 
 3         {
 4             this.song = PlayList.GetPlayingSong(); // 获取当前要播放的歌曲
 5 
 6             if (song != null)
 7             {
 8 
 9                 this.song.SetSongPlayed();             // 将当前歌曲播放状态设为已播放
10                 this.Winplaymedia.URL = KTVUtil.songPath + "\" + this.song.SongURL;  // 得到当前播放歌曲的路径
11 
12             }
13 
14         }
15  private void timer1_Tick(object sender, EventArgs e)
16 
17         {
18 
19             // 在文本框中显示当前播放的歌曲名字
20 
21             this.txtplay.Text = PlayList.PlayingSongName();
22 
23             this.txtnextsong.Text = PlayList.NextSongName();
24 
25             if (this.song == null)
26 
27             {
28                 this.PlaySong();
29             }
30 
31             if (this.Winplaymedia.playState == WMPLib.WMPPlayState.wmppsStopped)
32 
33             {
34 
35                 this.song = null; // 将歌曲设为空
36 
37                 PlayList.MoveOn();
38 
39             }
40 
41             // 切歌
42 
43             if (this.song != null && this.song.PlayState == SongPlayState.cut)
44 
45             {
46 
47                this.Winplaymedia.URL = "";
48 
49                 this.song = null;
50 
51             }

在Load时中启动计时器：

代码例子:

  this.time.Start();

01:切歌：

1 代码例子：  DialogResult re = MessageBox.Show("确定要切歌吗?", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
2 
3             if (re == DialogResult.OK)
4 
5             {
6 
7                 PlayList.CutSong(-1);
8 
9             }

02：重唱：

代码例子： 

1 PlayList.PlayAgain();
2 
3             PlaySong();
4 
5  

移动窗体的代码： 

 1   private Point mouseOffset;        //记录鼠标指针的坐标       
 2 
 3         private bool isMouseDown = false; //记录鼠标按键是否按下
 4 
 5         private void pnlon_MouseDown(object sender, MouseEventArgs e)
 6 
 7         {
 8 
 9             int xOffset;
10 
11             int yOffset;
12 
13             if (e.Button == MouseButtons.Left)
14 
15             {
16                 xOffset = -e.X - SystemInformation.FrameBorderSize.Width;
17 
18                 yOffset = -e.Y - SystemInformation.CaptionHeight - SystemInformation.FrameBorderSize.Height;
19 
20                 mouseOffset = new Point(xOffset, yOffset);
21 
22                 isMouseDown = true;
23 
24             }
25 
26         }
27    private void pnlon_MouseMove(object sender, MouseEventArgs e)
28 
29         {
30             if (isMouseDown)
31 
32             {
33                 Point mousePos = Control.MousePosition;
34 
35                 mousePos.Offset(mouseOffset.X + 5, mouseOffset.Y + 30);
36                 Location = mousePos;
37 
38             }
39 
40         }
41 
42  
43 
44         private void pnlon_MouseUp(object sender, MouseEventArgs e)
45 
46         {
47             // 修改鼠标状态isMouseDown的值     
48 
49             // 确保只有鼠标左键按下并移动时，才移动窗体      
50 
51             if (e.Button == MouseButtons.Left)
52 
53             {
54 
55                 isMouseDown = false;
56 
57             }
58 
59         }
60 

拼音点歌

 1  // 查询歌曲显示在窗体中
 2         private void btnSearch_Click(object sender, EventArgs e)
 3         {                       
 4             DBHelper dbHelper = new DBHelper();
 5             DataSet dataSet = new DataSet();
 6             StringBuilder sb = new StringBuilder();
 7             sb.Append("select song_id,song_name,singer_name,song_url  from song_info inner join singer_info on singer_info.singer_id=song_info.singer_id ");
 8             sb.AppendFormat("where song_name like '%{0}%' or song_ab like '{0}'",this.txtSongName.Text);
 9 
10             Console.WriteLine(sb.ToString());
11 
12             SqlDataAdapter adapter = new SqlDataAdapter(sb.ToString(), dbHelper.Connection);
13 
14              // 清空当前列表
15             if (dataSet.Tables["songList"] != null)
16             {
17                 dataSet.Tables["songList"].Clear();
18             }
19 
20             adapter.Fill(dataSet, "songList");
21             this.dgvSong.DataSource = dataSet.Tables["songList"];            
22         }
23 
24         private void tsbtnExit_Click(object sender, EventArgs e)
25         {
26             this.Close();
27         }
28 
29         private void dgvSong_CellClick(object sender, DataGridViewCellEventArgs e)
30         {
31             if (dgvSong.SelectedRows[0].Cells["songName"]!=null)
32             {
33                 // 创建一个歌曲对象，并将当权选中的歌曲名和路径赋给该对象
34                 Song song = new Song();
35                 song.SongName = dgvSong.SelectedRows[0].Cells["songName"].Value.ToString();
36                 song.SongURL = dgvSong.SelectedRows[0].Cells["songURL"].Value.ToString();
37                 PlayList.AddSong(song);
38 
39                 // 更新数据库，将选中的歌曲点播次数加1
40                 int songId = Convert.ToInt32(dgvSong.SelectedRows[0].Cells["songId"].Value);
41                 string sql = string.Format("update song_info set song_play_count=song_play_count+1 where song_id={0}", songId);
42                 DBHelper dbHelper = new DBHelper();
43                 try
44                 {
45                     SqlCommand command = new SqlCommand(sql, dbHelper.Connection);
46                     dbHelper.OpenConnection();
47                     command.ExecuteNonQuery();
48                 }
49                 catch (Exception ex)
50                 {
51                     Console.WriteLine(ex.Message);
52                     MessageBox.Show("错误！");
53                 }
54                 finally
55                 {
56                     dbHelper.CloseConnection();
57                 } 
58             }
59         }

实现分类点歌功能

 1         // 窗体加载时，显示歌曲类别
 2         private void OrderBySongTypeForm_Load(object sender, EventArgs e)
 3         {
 4             // 读取歌曲类别
 5             DBHelper dbHelper = new DBHelper();
 6             string sql = "select * from song_type";
 7             try
 8             {
 9                 // 查询数据库
10                 SqlCommand command = new SqlCommand(sql, dbHelper.Connection);
11                 dbHelper.OpenConnection();
12                 SqlDataReader reader = command.ExecuteReader();
13 
14                 // 循环将类别读取出来添加到ListView中
15                 this.lvSongType.Items.Clear();
16                 int i = 0;
17                 while (reader.Read())
18                 {
19                     ListViewItem item = new ListViewItem();
20                     item.Text = Convert.ToString(reader["songtype_name"]);
21                     item.Tag = Convert.ToInt32(reader["songtype_id"]);
22                     item.ImageIndex = i;
23                     this.lvSongType.Items.Add(item);
24                     i++;
25                 }
26                 reader.Close();
27             }
28             catch (Exception ex)
29             {
30                 Console.WriteLine(ex.Message);
31                 MessageBox.Show("cuowu！");
32 
33             }
34             finally
35             {
36                 dbHelper.CloseConnection();
37             }
38         }
39 
40         private void lvSongType_Click(object sender, EventArgs e)
41         {
42             // 读取数据库，读出该歌手的所有歌曲
43             DBHelper dbHelper = new DBHelper();
44             StringBuilder sb = new StringBuilder();
45             sb.Append("select song_id,song_name, singer_name,song_url  from song_info inner join singer_info on song_info.singer_id=singer_info.singer_id ");
46             sb.AppendFormat("where songtype_id={0}",Convert.ToInt32(lvSongType.SelectedItems[0].Tag));
47             Console.WriteLine(sb.ToString());
48             FrmSongList songList = new FrmSongList();
49             songList.Sql = sb.ToString();
50             songList.Previous = PrevioisForm.SongType;
51             songList.Show();
52             this.Close();
53         }

字数点歌

 1   private void OrderByWordCountForm_Load(object sender, EventArgs e)
 2         {
 3             // 将字数列表添加到窗体中            
 4             for (int i = 0; i < 12; i++)
 5             {
 6                 // 循环生成字数项添加到窗体中
 7                 ListViewItem item = new ListViewItem();
 8                 item.Text = (i + 1)+"个字";
 9                 item.Tag = i + 1;
10                 lvWordCount.Items.Add(item);
11             }          
12 
13         }
14 
15         private void lvWordCount_Click(object sender, EventArgs e)
16         {
17             if (lvWordCount.SelectedItems[0] != null)
18             {
19                 // 读取数据库，读出该歌手的所有歌曲
20                 DBHelper dbHelper = new DBHelper();
21                 StringBuilder sb = new StringBuilder();
22                 sb.Append("select song_id,song_name, singer_name,song_url  from song_info inner join singer_info on song_info.singer_id=singer_info.singer_id ");
23                 sb.AppendFormat("where song_word_count={0}", Convert.ToInt32(lvWordCount.SelectedItems[0].Tag));
24                 Console.WriteLine(sb.ToString());
25                 FrmSongList songList = new FrmSongList();
26                 songList.Sql = sb.ToString();
27                 songList.Previous = PrevioisForm.WordCount;
28                 songList.Show();
29                 this.Close();
30             }
31         }

已点歌曲：

 1      //刷新歌曲列表
 2 
 3   private void timer1_Tick(object sender, EventArgs e){ 
 4 
 5  this.newSonglist();
 6 
 7 }
 8 
 9    private void newSonglist()
10 
11         {
12 
13             // 清空原列表
14 
15             lvlist.Items.Clear();
16 
17             int index = 0;
18 
19             while (PlayList.SongList[index] != null)
20 
21             {
22 
23                 ListViewItem item = new ListViewItem();
24 
25                 //获取歌曲的名称
26 
27                 item.Text = PlayList.SongList[index].SongName;
28 
29                 item.Tag = index;
30 
31                 //歌曲的播放状态
32 
33                 string playState = PlayList.SongList[index].PlayState == SongPlayState.unplayed ? "未播放" : "已播放";
34 
35                 item.SubItems.Add(playState);
36 
37                 lvlist.Items.Add(item);
38 
39                 index++;
40 
41             }
42 
43         }    
44 
45 //切割
46 
47         private void tsbtnCut_Click_1(object sender, EventArgs e)
48 
49         {
50 
51             int songId = -1;  // 切歌的编号
52 
53             DialogResult re = MessageBox.Show("确定要切歌吗?", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
54 
55             if (re == DialogResult.OK)
57             {
58 
59                 if (this.lvlist.SelectedItems.Count > 0)
60 
61                 {
62 
63                     songId = Convert.ToInt32(this.lvlist.SelectedItems[0].Tag);
64 
65                 }
66 
67                 PlayList.CutSong(songId);
68 
69                 this.newSonglist();
70 
71             }
72 
73  

歌曲列表：

 1    // 窗体加载时查询歌曲列表
 2         private void SongListForm_Load(object sender, EventArgs e)
 3         {
 4             DBHelper dbHelper = new DBHelper();
 5             DataSet dataSet = new DataSet();
 6             SqlDataAdapter adapter = new SqlDataAdapter(this.Sql,dbHelper.Connection);
 7             adapter.Fill(dataSet, "songList");
 8             dgvSong.DataSource = dataSet.Tables["songList"];
 9         }
10 
11         // 点播一首歌曲
12         private void dgvSong_CellClick(object sender, DataGridViewCellEventArgs e)
13         {
14             // 创建一个歌曲对象，并将当权选中的歌曲名和路径赋给该对象
15             Song song = new Song();
16             song.SongName = dgvSong.SelectedRows[0].Cells["songName"].Value.ToString();
17             song.SongURL = dgvSong.SelectedRows[0].Cells["songURL"].Value.ToString();
18             PlayList.AddSong(song);
19 
20             // 更新数据库，将选中的歌曲点播次数加1
21             int songId = Convert.ToInt32(dgvSong.SelectedRows[0].Cells["songId"].Value);
22             string sql = string.Format("update song_info set song_play_count=song_play_count+1 where song_id={0}", songId);
23             DBHelper dbHelper = new DBHelper();
24             try
25             {
26                 SqlCommand command = new SqlCommand(sql, dbHelper.Connection);
27                 dbHelper.OpenConnection();
28                 command.ExecuteNonQuery();
29             }
30             catch (Exception ex)
31             {
32                 Console.WriteLine(ex.Message);
33                 MessageBox.Show("错误！");
34             }
35             finally
36             {
37                 dbHelper.CloseConnection();
38             }
39         }

                                                      后台管理

KTVUtil 类：

 1 public   class  KTVUtil
 2 
 3     {
 4 
 5         //保存歌曲的目录
 6 
 7         public static string songURL = "";
 8 
 9         //保存歌手图片的目录
10 
11         public static string singer_photoURL = "";
12 
13 }

主窗体的Load事件：

 1  private void frmKTV_Load(object sender, EventArgs e)
 2 
 3         {
 4 
 5  
 6 
 7             // 歌曲路径
 8 
 9             string sql = "select resource_path from Resource_path where resource_id=2";
10 
11             KTVUtil.songURL = song_path(sql);
12 
13             // 歌手图片路径
14 
15             string sql1 = "select resource_path from Resource_path where resource_id=1";
16 
17             KTVUtil.singer_photoURL = song_path(sql1);
18 
19         }
20 
21    //路径
22 
23         private string song_path(string sql)
24 
25         {
26 
27             SqlConnection con = new SqlConnection(DBHelp.str);
28 
29             SqlCommand cmd = new SqlCommand(sql, con);
30 
31             string path = "";
32 
33  
34 
35             con.Open();
36 
37             SqlDataReader dr = cmd.ExecuteReader();
38 
39  
40 
41             if (dr != null)
42 
43             {
44 
45                 if (dr.HasRows)
46 
47                 {
48 
49                     while (dr.Read())
50 
51                     {
52 
53                         path = dr["resource_path"].ToString();

增加修改歌手信息：

 1 获取图片的代码： 
 2 
 3   //相对路径
 4 
 5         public string FileName;
 6 
 7         //绝对路径
 8 
 9         public string Path;
10 
11  //获取
12 
13         private void btnLiu_Click(object sender, EventArgs e)
14 
15         {
16 
17             DialogResult result = open.ShowDialog();
18 
19  
20 
21             if (result == DialogResult.OK)//获取路径
22 
23             {
24 
25                 //相对路径
26 
27                 FileName = open.SafeFileName;
28 
29                 //绝对路径
30 
31                 Path = open.FileName;
32 
33                 pic.Image = Image.FromFile(Path);
39             }
40 
41         }
42 
43 //复制图片的路径
44 
45 if (Path != null)
46 
47                     {
48 
49                         if (Path != KTVUtil.singer_photoURL + FileName)
50 
51                         {
52 
53                             File.Copy(Path, KTVUtil.singer_photoURL + FileName, true);
54 
55                         }
56 
57                     }
58 
59  
60 
61   private void 修改ToolStripMenuItem_Click(object sender, EventArgs e)
62 
63         {
64 
65             if (dgvlist.SelectedRows[0].Cells[0].Value.ToString() != "")
66 
67             {
68 
69                 //获取选中行的歌曲编号
70 
71                 int songid = Convert.ToInt32(dgvlist.SelectedRows[0].Cells["song_id"].Value);
72 
73                 FrmAddSong frm = new FrmAddSong();
74 
75                 frm.songid = songid;
76 
77                 frm.Show();
78 
79             }
80 
81             else
82 
83             {
84 
85                 MessageBox.Show("选歌曲");
86 
87             }

查询，删除，歌手信息

  1    public void deletesonginfo()
  2         {
  3             //获取选中行的歌手编号
  4             singer_id = Convert.ToInt32(dgvlist.SelectedRows[0].Cells["siigid"].Value);
  5             string sql = "delete song_info where singer_id=" + singer_id + "";
  6 
  7             SqlCommand cmd = new SqlCommand(sql, con);
  8             con.Open();
  9             cmd.ExecuteNonQuery();
 10             con.Close();
 11 
 12         }
 13         //删除歌手
 14         public void deletesingerinfo()
 15         {
 16             //获取选中行的歌手编号
 17             singer_id = Convert.ToInt32(dgvlist.SelectedRows[0].Cells["siigid"].Value);
 18             string sql1 = "select song_id from song_info where singer_id=" + singer_id + "";
 19             SqlConnection con1 = new SqlConnection(DBHelp.str);
 20             SqlCommand cmd1 = new SqlCommand(sql1, con1);
 21             con1.Open();
 22             int song_id = Convert.ToInt32(cmd1.ExecuteScalar());
 23             con1.Close();
 24             if (song_id != 0)
 25             {
 26                 MessageBox.Show("删除该歌手的歌曲信息");
 27 
 28             }
 29             else
 30             {
 31                 string sql = "delete dbo.singer_info where singer_id=" + singer_id + " ";
 32 
 33                 SqlCommand cmd = new SqlCommand(sql, con);
 34                 con.Open();
 35                 int count = cmd.ExecuteNonQuery();
 36                 if (count > 0)
 37                 {
 38                     MessageBox.Show("成功!");
 39                     string RowFilter = "";
 40                     SelectInfo(RowFilter);
 41                 }
 42                 else
 43                 {
 44                     MessageBox.Show("失败!");
 45                 }
 46 
 47                 con.Close();
 48 
 49             }
 50 
 51         }
 52         //给dgvlist控件绑定数据的方法
 53         public void SelectInfo(string RowFilter)
 54         {
 55             dgvlist.AutoGenerateColumns = false;
 56             //歌手姓名,歌手类型,歌手性别,歌手描述
 57 
 58             string sql = "select singer_info.singertype_id,singer_name,singer_id,singertype_name,singer_gender,singer_description from dbo.singer_info,dbo.singer_type where singer_info.singertype_id=singer_type.singertype_id ";
 59             SqlDataAdapter da = new SqlDataAdapter(sql, con);
 60             DataSet ds = new DataSet();
 61             try
 62             {
 63                 da.Fill(ds, "info");
 64                 DataView dv = new DataView(ds.Tables["info"]);
 65                 dv.RowFilter = RowFilter;
 66                 dgvlist.DataSource = dv;
 67             }
 68             catch (Exception)
 69             {
 70 
 71                 MessageBox.Show("网络异常!");
 72             }
 73             finally
 74             {
 75                 con.Close();
 76             }
 77         }
 78         private void btnselect_Click(object sender, EventArgs e)
 79         {
 80 
 81             if (txtname.Text == "" && cboty.Text == "全部")
 82             {
 83                 string RowFilter = "";
 84                 SelectInfo(RowFilter);
 85             }
 86             else if (txtname.Text != "")
 87             {
 88                 //获取要查询歌手的姓名
 89                 name = txtname.Text;
 90                 //获取要查询的歌手类型
 91                 int type = Convert.ToInt32(cboty.SelectedValue);
 92                 string RowFilter = "singer_name like '%" + name + "%'";
 93                 SelectInfo(RowFilter);
 94 
 95             }
 96             else
 97             {
 98 
 99                 //获取要查询歌手的姓名
100                 name = txtname.Text;
101                 //获取要查询的歌手类型
102                 int type = Convert.ToInt32(cboty.SelectedValue);
103                 string RowFilter = "singer_name like '%" + name + "%' and singertype_id=" + type + "";
104                 SelectInfo(RowFilter);
105             }
106 
107         }
108         //给歌手类型下拉框绑定数据的方法
109         public void LoadINGO()
110         {
111 
112             string sql = "select * from dbo.singer_type";
113             SqlDataAdapter da = new SqlDataAdapter(sql, con);
114             DataSet ds = new DataSet();
115             try
116             {
117                 da.Fill(ds, "info");
118                 cboty.DataSource = ds.Tables["info"];
119                 cboty.DisplayMember = "singertype_name";
120                 cboty.ValueMember = "singertype_id";
121                 DataRow row = ds.Tables["info"].NewRow();
122                 row["singertype_id"] = -1;
123                 row["singertype_name"] = "全部";
124                 ds.Tables["info"].Rows.InsertAt(row, 0);
125                 cboty.SelectedIndex = 0;
126 
127 
128             }
129             catch (Exception)
130             {
131 
132                 MessageBox.Show("网路异常!");
133             }
134             finally
135             {
136                 con.Close();
137             }
138         }
139         private void FrmSelectSinger_Load(object sender, EventArgs e)
140         {
141 
142             // 给歌手类型下拉框绑定数据的方法
143             LoadINGO();
144             //给dgvlist控件绑定数据
145             string RowFilter = "";
146             SelectInfo(RowFilter);
147         }
148 
149         private void 删除ToolStripMenuItem_Click_1(object sender, EventArgs e)
150         {
151             if (dgvlist.SelectedRows[0].Cells[0].Value.ToString() != "")
152             {
153                 DialogResult result = MessageBox.Show("确定删除?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
154                 if (result == DialogResult.OK)
155                 {
156                     //删除歌手信息的方法
157                     deletesonginfo();
158                     deletesingerinfo();
159                     string RowFilter = "";
160                     SelectInfo(RowFilter);

增加歌曲和修改歌曲：

 1 public int songid;
 2 
 3         public string Path;
 4 
 5         //相对路径
 6 
 7         public string txtxdpath;
 8 
 9   //新增歌曲信息的方法
10 
11         public void addinfo()
12 
13         {
14 
15             //获取歌曲名称
16 
17             string song_name = txtname.Text;
18 
19             //获取拼音缩写信息
20 
21             string py = txtsuo.Text;
22 
23             //获取歌曲类型对应的隐藏值
24 
25             int type_id = Convert.ToInt32(cboty.SelectedValue);
26 
27             //获取歌手姓名对应的编号
28 
29             int singe_id = Convert.ToInt32(txtsername.Tag);
30 
31             //获取歌曲文件名
32 
33             string url = txtsongurl.Text;
34 
35             //获取歌曲名称的长度
36 
37             int length = song_name.Length;
38 
39         //拼接sql语句
40 
41             string sql = "insert into song_info values('" + song_name + "','" + py + "'," + length + "," + type_id + "," + singe_id + ",'" + url + "',default)";
42 
43       SqlCommand cmd = new SqlCommand(sql, con);
44 
45        con.Open();
46 
47             int result = cmd.ExecuteNonQuery();
48 
49             if (result > 0)
50 
51             {
52 
53                 MessageBox.Show("保存成功!");
54 
55                 if (Path != null)
56 
57                 {
58 
59                     if (Path != KTVUtil.songURL + txtxdpath)
60 
61                     {             
62 
63                         File.Copy(Path, KTVUtil.songURL + txtxdpath, true);
64 
65                     }
66                 }
67 
68             }
69 
70             else
71 
72             {

查询，删除歌曲信息

  1   //删除歌曲信息的方法
  2         public void deletesong()
  3         {
  4 
  5             if (dgvlist.SelectedRows[0].Cells[0].Value.ToString() != "")
  6             {
  7                 //获取选中行的歌曲编号
  8                 int song_id = Convert.ToInt32(dgvlist.SelectedRows[0].Cells["song_id"].Value);
  9                 DialogResult result = MessageBox.Show("删除?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
 10                 if (result == DialogResult.OK)
 11                 {
 12                     SqlConnection con = new SqlConnection(DBHelp.str);
 13                     string sql = "delete song_info where song_id=" + song_id + "";
 14                     SqlCommand cmd = new SqlCommand(sql, con);
 15 
 16                     con.Open();
 17                     int count = cmd.ExecuteNonQuery();
 18                     if (count > 0)
 19                     {
 20                         MessageBox.Show("成功!");
 21                         string RowFilter="";
 22                         LoadAllINFO(RowFilter);
 23                     }
 24                     else
 25                     {
 26                         MessageBox.Show("失败!");
 27                     }
 28 
 29                     con.Close();
 30 
 31                 }
 32 
 33             }
 34             else
 35             {
 36 
 37                 MessageBox.Show("选歌曲");
 38 
 39             }
 40         }
 41         //给歌曲类型下拉框赋值的方法
 42         public void LoadINFO()
 43         {
 44 
 45             SqlConnection con = new SqlConnection(DBHelp.str);
 46             string sql = "select * from song_type";
 47             SqlDataAdapter da = new SqlDataAdapter(sql, con);
 48             DataSet ds = new DataSet();
 49 
 50             da.Fill(ds, "info");
 51             cbolist.DataSource = ds.Tables["info"];
 52             cbolist.DisplayMember = "songtype_name";
 53             cbolist.ValueMember = "songtype_id";
 54 
 55             DataRow row = ds.Tables["info"].NewRow();
 56             row["songtype_id"] = -1;
 57             row["songtype_name"] = "全部";
 58             ds.Tables["info"].Rows.InsertAt(row, 0);
 59             cbolist.SelectedIndex = 0;
 60 
 61 
 62 
 63 
 64             con.Close();
 65 
 66 
 67         }
 68 
 69         //给dgvlist绑定数据的方法
 70         public void LoadAllINFO(string RowFilter)
 71         {
 72             //取消英文列自动生成 
 73             dgvlist.AutoGenerateColumns = false;
 74             SqlConnection con = new SqlConnection(DBHelp.str);
 75             string sql = "select  song_id,song_name,songtype_name,song_play_count,song_info.songtype_id from song_info,song_type where song_info.songtype_id=song_type.songtype_id";
 76             SqlDataAdapter da = new SqlDataAdapter(sql, con);
 77             DataSet ds = new DataSet();
 78 
 79             da.Fill(ds, "info");
 80             DataView dv = new DataView(ds.Tables["info"]);
 81             dv.RowFilter = RowFilter;
 82             dgvlist.DataSource = dv;
 83 
 84             con.Open();
 85 
 86 
 87         }
 88         private void btnselect_Click(object sender, EventArgs e)
 89         {
 90 
 91 
 92             if (txtname.Text == "" && cbolist.Text == "全部")
 93             {
 94                 string RowFilter = "";
 95                 LoadAllINFO(RowFilter);
 96             }
 97             else if (txtname.Text != "")
 98             {
 99                 //获取歌曲名称
100                 string song_name = txtname.Text;
101                 //获取歌曲类型对应的隐藏值
102                 int type_id = Convert.ToInt32(cbolist.SelectedValue);
103                 string RowFilter = "song_name like '%" + song_name + "%'";
104                 LoadAllINFO(RowFilter);
105 
106             }
107             else
108             {
109 
110                 //获取歌曲名称
111                 string song_name = txtname.Text;
112                 //获取歌曲类型对应的隐藏值
113                 int type_id = Convert.ToInt32(cbolist.SelectedValue);
114                 string RowFilter = "song_name like '%" + song_name + "%' and songtype_id =" + type_id + "";
115                 LoadAllINFO(RowFilter);
116 
117             }
118         }
119 
120         private void 修改ToolStripMenuItem_Click(object sender, EventArgs e)
121         {
122             if (dgvlist.SelectedRows[0].Cells[0].Value.ToString() != "")
123             {
124                 //获取选中行的歌曲编号
125                 int songid = Convert.ToInt32(dgvlist.SelectedRows[0].Cells["song_id"].Value);
126                 FrmAddSong frm = new FrmAddSong();
127                 frm.songid = songid;
128                 frm.Show();
129             }
130             else
131             {
132                 MessageBox.Show("选歌曲");
133             }
134         }
135 
136         private void 删除ToolStripMenuItem_Click(object sender, EventArgs e)
137         {
138 
139             //删除歌曲信息的方法
140             deletesong();   
141         }
142 
143         private void frmselectSong_Load(object sender, EventArgs e)
144         {
145             //给歌曲类型下拉框赋值
146             LoadINFO();
147             //给dgvlist绑定数据
148             string RowFilter = "";
149             LoadAllINFO(RowFilter);
150         }

歌曲路径：

 1    private void frmAddSongURL_Load(object sender, EventArgs e)
 2 
 3         {
 4 
 5             string sql = "select resource_path from Resource_path where resource_id=2";
 6 
 7             txtoldurl.Text = song_path(sql);
 8 
 9         }
10 
11 //给当前路径赋值
12 
13         private string song_path(string sql)
14 
15         {
16 
17  
18 
19             SqlCommand cmd = new SqlCommand(sql, con);
20 
21             string path = "";
22 
23             try
24 
25             {
26 
27                 con.Open();
28 
29                 SqlDataReader dr = cmd.ExecuteReader();
30 
31  
32 
33                 if (dr != null)
34 
35                 {
36 
37                     if (dr.HasRows)
38 
39                     {
40 
41                         while (dr.Read())
42 
43                         {
44 
45                             path = dr["resource_path"].ToString();
46 
47                         }
48 
49  
50 
51 DialogResult re = MessageBox.Show("修改路径?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
52 
53                 if (re == DialogResult.Yes)
54 
55                 {
56 
57  
58 
59                     Directory.Delete(txtnewurl.Text);
60 
61                     Directory.Move(txtoldurl.Text, txtnewurl.Text);
62 
63                     string newUrl = txtnewurl.Text;
64 
65                     SqlConnection con = new SqlConnection(DBHelp.str);
66 
67                     string sql = "update Resource_path set resource_path='" + newUrl + "' where resource_type='song'";
68 
69                     SqlCommand cmd = new SqlCommand(sql, con);
70 
71                     try
72 
73                     {
74 
75                         con.Open();
76 
77                         int count = cmd.ExecuteNonQuery();
78 
79                         if (count > 0)
80 
81 //浏览新路径
82 
83         private void btnLiu_Click(object sender, EventArgs e)
84 
85         {
86 
87  
88 
89             DialogResult result = brow.ShowDialog();
90 
91             if (result == DialogResult.OK)
92 
93             {
94 
95                 txtnewurl.Text = brow.SelectedPath + "\";
96 
97             }

 1 //歌曲的文件名：
 2 
 3 //浏览
 4 
 5   private void btnLiu_Click(object sender, EventArgs e)
 6 
 7         {
 8 
 9             open.Filter = "歌曲文件|*.mp3;";
10 
11             DialogResult result = open.ShowDialog();
12 
13             if (result == DialogResult.OK)//获取路径
14 
15             {
16 
17                 //相对路径
18 
19                 txtxdpath = open.SafeFileName;
20 
21                 txtsongurl.Text = txtxdpath;
22 
23                 //绝对路径
24 
25                 Path = open.FileName;
26 
27  
28 
29                 int dot = txtxdpath.LastIndexOf('.');
30 
31                 string fileType = txtxdpath.Substring(dot + 1);
32 
33                 if (fileType != "mp3")
34 
35                 {
36 
37                     MessageBox.Show("文件类型不对！");

歌手图片的路径：

 1 //给当前路径赋值
 2 
 3         private string song_path(string sql)
 4 
 5         {
 6 
 7             SqlConnection con = new SqlConnection(DBHelp.str);
 8 
 9             SqlCommand cmd = new SqlCommand(sql, con);
10 
11             string path = "";
12 
13  
14 
15             con.Open();
16 
17             SqlDataReader dr = cmd.ExecuteReader();
18 
19  
20 
21             if (dr != null)
22 
23             {
24 
25                 if (dr.HasRows)
26 
27                 {
28 
29                     while (dr.Read())
30 
31                     {
32 
33                         path = dr["resource_path"].ToString();
34 
35                     }
36 
37  private void btnSa_Click(object sender, EventArgs e)
38 
39         {
40 
41             // 如果新路径为空，提示
42 
43             if (this.txtnewurl.Text.Trim() == "")
44 
45             {
46 
47                 MessageBox.Show("请选择新路径！");
48 
49             }
50 
51             else
52 
53             {
54 
55                 // 用户确认修改
56 
57                 if (MessageBox.Show("确定要修改路径吗?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
58 
59                 {
60 
61  
62 
63                     Directory.Delete(txtnewurl.Text);
64 
65                     Directory.Move(txtoldurl.Text, txtnewurl.Text);
66 
67                     string newUrl = txtnewurl.Text;
68 
69                     SqlConnection con = new SqlConnection(DBHelp.str);
70 
71                     string sql = "update Resource_path set resource_path='" + newUrl + "' where resource_type='singer_photo'";
72 
73                     SqlCommand cmd = new SqlCommand(sql, con);
74 
75                     con.Open();
76 
77                     int count = cmd.ExecuteNonQuery();
78 
79                     if (count > 0)
80 
81                     {
82 
83 //浏览
84 
85 private void btnLiu_Click(object sender, EventArgs e)
86 
87         {
88 
89             DialogResult result = brow.ShowDialog();
90 
91             if (result == DialogResult.OK)
92 
93             {
94 
95                 txtnewurl.Text = brow.SelectedPath + "\";
96 
97             }

汉字转拼音首字母

 1   public static string GetChineseSpell(string strText)
 2         {
 3             if (strText == null || strText.Length == 0)
 4                 return strText;
 5             System.Text.StringBuilder myStr = new System.Text.StringBuilder();
 6             foreach (char vChar in strText)
 7             {
 8                 // 若是字母则直接输出
 9                 if ((vChar >= 'a' && vChar <= 'z') || (vChar >= 'A' && vChar <= 'Z'))
10                     myStr.Append(char.ToUpper(vChar));
11                 else if ((int)vChar >= 19968 && (int)vChar <= 40869)
12                 {
13                     // 若字符Unicode编码在编码范围则 查汉字列表进行转换输出
14                     foreach (string strList in strChineseCharList)
15                     {
16                         if (strList.IndexOf(vChar) > 0)
17                         {
18                             myStr.Append(strList[0]);
19                             break;
20                         }
21                     }
22                 }
23             }
24             return myStr.ToString();
25         }// GetChineseSpell 
26  
27  

 这可是我辛辛苦苦的成果哦，虽然这不算什么，但我还希望大家看看就能收获一些知识，就开心了。