using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?HangKTV.DAL;

namespace?HangKTV
{
????public?partial?class?Admin?:?Form
????{
????????public?Admin（）
????????{
????????????InitializeComponent（）;
????????????userc.Open（）;
????????????da?=?userc.Select（Admin.ID）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds）;
????????????dgv.DataSource?=?ds.Tables[0];
????????}

????????public?static?int?ID?=?2;//放用戶權限，>0即登陸=0就是沒有登陸
????????public?static?String?USER?=?“Hang“;//存放登陸用戶名//////
????????private?SqlDataAdapter?da;
????????private?int?songFlag;//判讀修改歌曲信息是不是先從刪除歌曲選項卡中過來的
????????private?int?songId;
????????DAL.UserClass?userc?=?new?DAL.UserClass（）;//UserClass類實例化
????????private?String?user;
??????

????????private?void?Admin_Load（object?sender?EventArgs?e）
????????{

????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????button1.BackgroundImage?=?Rsc.Btn4;
????????????if?（MessageBox.Show（“是否要退出本系統？“?“提示“?MessageBoxButtons.YesNo?MessageBoxIcon.Information）?==?DialogResult.Yes）
????????????{
????????????????Application.Exit（）;

????????????}
????????}

???????//改控件可見時發生，給combobox賦值
????????private?void?tabControl2_Enter（object?sender?EventArgs?e）
????????{
????????????DAL.SingerClass?singerc?=?new?SingerClass（）;
????????????da?=?singerc.SelectMvSingers（）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds）;
????????????//給歌手性別combobox賦值
????????????foreach?（DataRow?dr?in?ds.Tables[0].Rows）
????????????{
????????????????cb_sex.Items.Add（dr[“sex“].ToString（））;
????????????}
????????????singerc.Close（）;
?????????????
????????????//給歌曲分類combobox賦值
????????????DAL.SongClass?songc?=?new?SongClass（）;
????????????da?=?songc.SelectMvClass（）;
????????????DataSet?ds1?=?new?DataSet（）;
????????????da.Fill（ds1）;
????????????foreach?（DataRow?dr1?in?ds1.Tables[0].Rows）
????????????{
????????????????cb_class.Items.Add（dr1[“class“].ToString（））;
????????????}
????????}
????????

????????//按歌名查詢歌曲后，可進行刪除
????????private?void?button7_Click（object?sender?EventArgs?e）
????????{
????????????SongClass?songc?=?new?SongClass（）;
????????????if?（（txt.Text）.ToString（）?==?““）
????????????{
????????????????da?=?songc.Select（）;
????????????}
????????????else
????????????{
????????????????da?=?songc.SelectSong（（txt.Text）.ToString（）.Trim（））;
????????????}
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds）;
????????????clb1.Items.Clear（）;
????????????//*遍歷將數據給checkedlistbox
????????????foreach?（DataRow?dr?in?ds.Tables[0].Rows）
????????????{
????????????????clb1.Items.Add（dr[“song“].ToString（）?+?“$“?+?dr[“singer“].ToString（）?+?dr[“class“].ToString（）?+?dr[“info“].ToString（））;
????????????}
????????}

????????//按歌手查歌曲后，可進行刪除
????????private?void?button8_Click（obje

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????24361??2013-03-14?08:52??行HangKTV\HangKTV\Admin.cs

?????文件??????65791??2013-03-14?08:52??行HangKTV\HangKTV\Admin.designer.cs

?????文件???????6686??2013-03-14?08:52??行HangKTV\HangKTV\Admin.resx

?????文件????????790??2013-03-12?07:26??行HangKTV\HangKTV\App.config

?????文件????????790??2013-03-12?07:26??行HangKTV\HangKTV\bin\Debug\HangKTV.exe.config

?????文件??????14328??2013-05-06?21:08??行HangKTV\HangKTV\bin\Debug\HangKTV.vshost.exe

?????文件????????790??2013-03-12?07:26??行HangKTV\HangKTV\bin\Debug\HangKTV.vshost.exe.config

?????文件????????490??2009-06-11?05:14??行HangKTV\HangKTV\bin\Debug\HangKTV.vshost.exe.manifest

?????文件???????2092??2013-03-06?17:13??行HangKTV\HangKTV\BLL\Use.cs

?????文件???????3981??2013-03-12?15:12??行HangKTV\HangKTV\DAL\LogClass.cs

?????文件???????6343??2013-03-07?21:22??行HangKTV\HangKTV\DAL\SingerClass.cs

?????文件???????7695??2013-03-12?15:04??行HangKTV\HangKTV\DAL\SongClass.cs

?????文件???????5768??2013-03-07?08:02??行HangKTV\HangKTV\DAL\UserClass.cs

?????文件???????3488??2013-03-14?11:33??行HangKTV\HangKTV\frmLogin.cs

?????文件???????8700??2013-03-14?11:33??行HangKTV\HangKTV\frmLogin.Designer.cs

?????文件???????5814??2013-03-14?11:33??行HangKTV\HangKTV\frmLogin.resx

?????文件???????6624??2013-03-14?07:00??行HangKTV\HangKTV\frmMain.cs

?????文件???????9566??2013-03-14?07:00??行HangKTV\HangKTV\frmMain.Designer.cs

?????文件?????113095??2013-03-14?07:00??行HangKTV\HangKTV\frmMain.resx

?????文件??????11217??2013-03-13?19:59??行HangKTV\HangKTV\frmMusicPlayer.cs

?????文件??????17678??2013-03-12?07:27??行HangKTV\HangKTV\frmMusicPlayer.Designer.cs

?????文件???????6716??2013-03-12?07:27??行HangKTV\HangKTV\frmMusicPlayer.resx

?????文件???????8600??2013-03-12?13:38??行HangKTV\HangKTV\frmNumber.cs

?????文件??????13165??2013-03-12?12:55??行HangKTV\HangKTV\frmNumber.Designer.cs

?????文件???????5814??2013-03-12?12:55??行HangKTV\HangKTV\frmNumber.resx

?????文件???????2055??2013-03-12?13:25??行HangKTV\HangKTV\frmSinger.cs

?????文件???????4944??2013-03-12?12:54??行HangKTV\HangKTV\frmSinger.Designer.cs

?????文件???????5814??2013-03-12?12:54??行HangKTV\HangKTV\frmSinger.resx

?????文件???????2864??2013-03-14?11:51??行HangKTV\HangKTV\frmSong.cs

?????文件???????5140??2013-03-12?12:56??行HangKTV\HangKTV\frmSong.Designer.cs

............此處省略213個文件信息