mainfrm.cpp

主要基于数据库技术

// MainFrm.cpp : implementation of the CMainFrame class
//

#include "stdafx.h"
#include "YLmms.h"
#include "AddSingerDlg.h"
#include "MainFrm.h"
#include "vfw.h"
#include "GenreTab.h"
#include "QueryDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CMainFrame

IMPLEMENT_DYNCREATE(CMainFrame, CFrameWnd)

BEGIN_MESSAGE_MAP(CMainFrame, CFrameWnd)
	//{{AFX_MSG_MAP(CMainFrame)
	ON_WM_CREATE()
	ON_COMMAND(ID_ADD_SINGER, OnAddSinger)
	ON_COMMAND(ID_DEL_SINGER, OnDelSinger)
	ON_COMMAND(ID_DELSONG, OnDelsong)
	ON_COMMAND(ID_EDITSONG, OnEditsong)
	ON_COMMAND(ID_QUERY, OnQuery)
	ON_BN_CLICKED(IDC_OPEN_SINGLE, OnOpenSingle)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

static UINT indicators[] =
{
	ID_SEPARATOR,           // status line indicator
	ID_INDICATOR_CAPS,
	ID_INDICATOR_NUM,
	ID_INDICATOR_SCRL,
};

/////////////////////////////////////////////////////////////////////////////
// CMainFrame construction/destruction

CMainFrame::CMainFrame()
{
	// TODO: add member initialization code here
	
}

CMainFrame::~CMainFrame()
{
}
/*

int CMainFrame::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
	if (CFrameWnd::OnCreate(lpCreateStruct) == -1)
		return -1;
/ *
	
	if (!m_wndToolBar.CreateEx(this, TBSTYLE_FLAT, WS_CHILD | WS_VISIBLE | CBRS_TOP
		| CBRS_GRIPPER | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC) ||
		!m_wndToolBar.LoadToolBar(IDR_MAINFRAME))* /

	
	if (!m_wndToolBar.CreateEx(this) ||
		!m_wndToolBar.LoadToolBar(IDR_MAINFRAME))
	{
		TRACE0("Failed to create toolbar\n");
		return -1;      // fail to create
	}

/ *
	{
		TRACE0("Failed to create toolbar\n");
		return -1;      // fail to create
	}* /

	// create dialog bar
	if (!m_PlayBar.Create(this, IDD_PLAY_BAR, 
		CBRS_ALIGN_TOP, AFX_IDW_DIALOGBAR)||
		!m_PlayBar.InitDialog())
	{
		TRACE0("Failed to create dialog bar\n");
		return -1;      // fail to create
	}

	if (!m_wndReBar.Create(this) ||
		!m_wndReBar.AddBar(&m_wndToolBar) ||
		!m_wndReBar.AddBar(&m_PlayBar))
	{
		TRACE0("Failed to create rebar\n");
		return -1;      // fail to create
	}
	// TODO: Remove this if you don't want tool tips


	











	if (!m_wndStatusBar.Create(this) ||
		!m_wndStatusBar.SetIndicators(indicators,
		  sizeof(indicators)/sizeof(UINT)))
	{
		TRACE0("Failed to create status bar\n");
		return -1;      // fail to create
	}



//定义工具栏显示的图像
	CImageList img;
	CYLmmsApp *myApp=(CYLmmsApp*)AfxGetApp();
	img.Create(32,32,ILC_COLOR32,6,6);
	img.Add(myApp->LoadIcon(IDI_ICON6));	
	img.Add(myApp->LoadIcon(IDI_ICON4));
	img.Add(myApp->LoadIcon(IDI_ICON7));
	img.Add(myApp->LoadIcon(IDI_ICON8));
	img.Add(myApp->LoadIcon(IDI_ICON5));
	//img.Add(myApp->LoadIcon(IDI_ICON6));
	m_wndToolBar.GetToolBarCtrl().SetImageList(&img);
	img.Detach();


	// TODO: Delete these three lines if you don't want the toolbar to
	//  be dockable
	m_wndToolBar.EnableDocking(CBRS_ALIGN_ANY);
	EnableDocking(CBRS_ALIGN_ANY);
	DockControlBar(&m_wndToolBar);

	return 0;
}
*/





int CMainFrame::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
	if (CFrameWnd::OnCreate(lpCreateStruct) == -1)
		return -1;
	
	if (!m_wndToolBar.CreateEx(this) ||
		!m_wndToolBar.LoadToolBar(IDR_MAINFRAME))
	{
		TRACE0("Failed to create toolbar\n");
		return -1;      // fail to create
	}
	// create dialog bar
	if (!m_PlayBar.Create(this, IDD_PLAY_BAR, 
		CBRS_ALIGN_TOP, AFX_IDW_DIALOGBAR)||
		!m_PlayBar.InitDialog())
	{
		TRACE0("Failed to create dialog bar\n");
		return -1;      // fail to create
	}

	if (!m_wndReBar.Create(this) ||
		!m_wndReBar.AddBar(&m_wndToolBar) ||
		!m_wndReBar.AddBar(&m_PlayBar))
	{
		TRACE0("Failed to create rebar\n");
		return -1;      // fail to create
	}
	// TODO: Remove this if you don't want tool tips
	m_wndToolBar.SetBarStyle(m_wndToolBar.GetBarStyle()|
		CBRS_TOOLTIPS | CBRS_FLYBY);

	if (!m_wndStatusBar.Create(this) ||
		!m_wndStatusBar.SetIndicators(indicators,
		  sizeof(indicators)/sizeof(UINT)))
	{
		TRACE0("Failed to create status bar\n");
		return -1;      // fail to create
	}

//定义工具栏显示的图像
	CImageList img;
	CYLmmsApp *myApp=(CYLmmsApp*)AfxGetApp();
	img.Create(32,32,ILC_COLOR32,6,6);
	img.Add(myApp->LoadIcon(IDI_ICON6));	
	img.Add(myApp->LoadIcon(IDI_ICON4));
	img.Add(myApp->LoadIcon(IDI_ICON7));
	img.Add(myApp->LoadIcon(IDI_ICON8));
	img.Add(myApp->LoadIcon(IDI_ICON5));
	//img.Add(myApp->LoadIcon(IDI_ICON6));
	m_wndToolBar.GetToolBarCtrl().SetImageList(&img);
	img.Detach();
















	return 0;
}




BOOL CMainFrame::PreCreateWindow(CREATESTRUCT& cs)
{
	if( !CFrameWnd::PreCreateWindow(cs) )
		return FALSE;
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return TRUE;
}

/////////////////////////////////////////////////////////////////////////////
// CMainFrame diagnostics

#ifdef _DEBUG
void CMainFrame::AssertValid() const
{
	CFrameWnd::AssertValid();
}

void CMainFrame::Dump(CDumpContext& dc) const
{
	CFrameWnd::Dump(dc);
}

#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CMainFrame message handlers


BOOL CMainFrame::OnCreateClient(LPCREATESTRUCT lpcs, CCreateContext* pContext) 
{
	// TODO: Add your specialized code here and/or call the base class
   if (!m_wndSplitter.CreateStatic(this,1,2)) 
   return FALSE;	
	if(!m_wndSplitter.CreateView(0,0,RUNTIME_CLASS(CLeftTreeView),CSize(150,150),pContext))
		return FALSE;
	if(!m_wndSplitter.CreateView(0,1,RUNTIME_CLASS(CRightListView),CSize(100,100),pContext))
		return FALSE;

return TRUE;

	//return CFrameWnd::OnCreateClient(lpcs, pContext);
}

void CMainFrame::OnAddSinger() //对应菜单中的Addsinger
{
	// TODO: Add your command handler code here
	
	LPBROWSEINFO lpbi=new BROWSEINFO;//BROWSEINFO结构体	
	lpbi->hwndOwner=GetSafeHwnd();//NULL;
	lpbi->pidlRoot=NULL;
	lpbi->pszDisplayName=NULL;
	lpbi->lpszTitle="请选择演唱者目录:";
	lpbi->ulFlags=BIF_RETURNONLYFSDIRS|BIF_EDITBOX;
	lpbi->lpfn=NULL;
	//显示外壳文件夹以便用户选择
    LPITEMIDLIST lpitemidlist=SHBrowseForFolder(lpbi); 
	
	if(lpitemidlist==NULL)
	{
		delete lpbi;
		lpbi = NULL;
		return;
	}
	char path[MAX_PATH];
	//转换项目标志符列表为一个系统文件路径
	SHGetPathFromIDList(lpitemidlist,path);
	delete lpbi;

  //添加歌手对话框
	CAddSingerDlg dlg;
	m_strPath.Format("%s",path);
	m_strSinger=m_strPath.Mid(m_strPath.ReverseFind('\\')+1);
	if(m_strSinger.IsEmpty())
	{
		AfxMessageBox("不是有效的歌手");
		return;
	}
	dlg.m_strsingername=m_strSinger;
	if(dlg.DoModal()!=IDOK)
		return;
   	

/////	m_strComment=dlg.m_strComment;
/////	m_bCheckCom=dlg.m_bCheckComment;
	//添加树项
	CLeftTreeView* pLeftView=(CLeftTreeView*)m_wndSplitter.GetPane(0,0);
/////	pLeftView->AddSingerToTree(m_strSinger,m_strSingerSex);
     
	//********************************
	//CString m_strSinger;//用来保存歌手姓名的


	//pLeftView->AddSingerToTree(m_strSinger,temp,gudian);

	//读取文件信息
	BrowseDir(m_strPath);
	//更新树视图
	CTreeCtrl& treeCtrl=pLeftView->GetTreeCtrl();
	treeCtrl.DeleteAllItems();
	//插入树项-歌手列表
	//treeCtrl.InsertItem("歌手列表", 0, 1);
	//插入树项-歌手列表
	treeCtrl.InsertItem("分类目录", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("古典", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("流行", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("欧美金曲", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("日韩", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("中国民乐", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("流金岁月", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("轻音乐", 0, 1,TVI_ROOT);
	treeCtrl.InsertItem("少儿", 0, 1,TVI_ROOT);
	//将数据库中记录插入
	CSongRecordSet db;
	try
	{
		if(db.IsOpen())
			db.Close();
		//设置查询条件
		CString strSQL="select * from music";
		//执行查询
		db.Open(CRecordset::snapshot,NULL,CRecordset::none);
		while(!db.IsEOF())
		{
		
		   
			pLeftView->AddSingerToTree(db.m_Singer,db.m_Sex,db.m_Classify);
		    pLeftView->m_Singer=db.m_Singer;
			pLeftView->m_Classify=db.m_Classify;
			//记录游标移到下一条记录
			db.MoveNext();
		}	
		db.Close();
	}
	//意外捕获
	catch(CDBException*e)
	{
		e->ReportError();
		return;
	}
	AfxMessageBox("歌手添加完毕");



}


void CMainFrame::BrowseDir(CString &strDir)
{
	//定义查找文件对象
	CFileFind cff;
	CString szDir = strDir;
	//当前文件
	CString str;	
	//当为根目录时，最右侧为'\'
	if(szDir.Right(1) != "\\")
		szDir += "\\";
	//所有文件
	szDir += "*.*";
	BOOL bResult = cff.FindFile(szDir);
	while(bResult)
	{
		bResult = cff.FindNextFile();
		if(cff.IsDirectory() && !cff.IsDots())
		{
			//如果是一个子目录，用递归继续往深一层找
			m_strPath=cff.GetFilePath();
			BrowseDir(m_strPath);

		}
		else if(!cff.IsDirectory() && !cff.IsDots())
		{
			//打开当前访问的文件获取文件大小等信息
			str.Format("%s",cff.GetFilePath());
			m_strFN.Format("%s",cff.GetFileName());
			if(str.Right(3)=="mp3"||str.Right(3)=="mP3"||
				str.Right(3)=="Mp3"||str.Right(3)=="MP3")
			{
				HANDLE hFile=::CreateFile(str,GENERIC_READ,FILE_SHARE_READ,NULL,
					OPEN_EXISTING,FILE_ATTRIBUTE_NORMAL,NULL);
				DWORD fileSize=::GetFileSize(hFile,NULL);
				ReagTag(hFile,fileSize,m_tagID1,0);
				//添加数据库中
				CSongRecordSet songDb;
				AddToDb(songDb,m_tagID1);
			}
		}
		//置空
		str="";
	}
	cff.Close();//关闭
}

void CMainFrame::ReagTag(HANDLE hFile,DWORD fileSize,MP3_TAG_ID1 &tagID1,UINT uMethod)
{
	//文件偏移，MP3文件的最后128字节存放着标签ID3v1
	SetFilePointer(hFile,fileSize-128,NULL,FILE_BEGIN);
	DWORD dCount=0;
	//读取标签值
	switch(uMethod)
	{
		case 0:
			dCount=3;
			ReadFile(hFile,tagID1.header,dCount,&dCount,NULL);
			dCount=30;
			ReadFile(hFile,tagID1.title,dCount,&dCount,NULL);
			ReadFile(hFile,tagID1.artist,dCount,&dCount,NULL);
			ReadFile(hFile,tagID1.album,dCount,&dCount,NULL);
			dCount=4;
			ReadFile(hFile,tagID1.year,dCount,&dCount,NULL);
			dCount=30;
			ReadFile(hFile,tagID1.comment,dCount,&dCount,NULL);
			dCount=1;
			ReadFile(hFile,tagID1.genre,dCount,&dCount,NULL);
			break;
		case 1:
			dCount=128;
			ReadFile(hFile,&tagID1,dCount,&dCount,NULL);
			break;
		default:
			break;
	}
}

void CMainFrame::AddToDb(CSongRecordSet &db, MP3_TAG_ID1 &tagID1)
{
	//创建CUserRecordSet的实例
	try
	{
		if(db.IsOpen())
			db.Close();
		//执行查询
		db.Open(CRecordset::snapshot,NULL,CRecordset::none);
		//首先增加一条新记录
		db.AddNew();
		CString strTem;
		//然后编辑该条记录的内容
		strTem.Format("%s",tagID1.title);
		strTem.TrimLeft();
		strTem.TrimRight();
		db.m_Title=strTem;
		//另外一种方法
		db.m_Artist=(LPCSTR)tagID1.artist;
		db.m_Album=(LPCSTR)tagID1.album;
		db.m_Year=(LPCSTR)tagID1.year;
		db.m_Comment=(LPCSTR)tagID1.comment;
		//流派字典查询
		CString strGenre;
		strGenre.Format("%d",tagID1.genre[0]);
		int iGenreNum=atoi(strGenre);
		if(iGenreNum>=0&&iGenreNum<=147)
		{
			db.m_Genre=(LPCSTR)genretab[iGenreNum];
		}
		else
		{
			db.m_Genre=(LPCSTR)genretab[148];
		}
		//将歌曲文件名和所在目录也加入数据库
		db.m_Folder=m_strPath;
		//去掉扩展名
		m_strFN=m_strFN.Left(m_strFN.GetLength()-4);
		//db.m_strFileName=m_strFN;
		db.m_FileName=m_strFN;

		//备注和歌手、性别
/////		if(m_bCheckCom)
//////		{
/////			db.m_Comment=m_strComment;
/////		}
		db.m_Singer=m_strSinger;
		db.m_Sex=m_strsex;
		db.m_Classify=m_strClassify;
		//最后，将歌曲信息更新到数据库中
		//更新时，要判断当前是否能够进行更新操作
        if(db.CanUpdate())
		{
			db.Update();			
		}
		db.Close();
	}
	//意外捕获
	catch(CDBException*e)
	{
		e->ReportError ();
		//e->Delete ();
		return;
	}
}



void CMainFrame::OnDelSinger() 
{
	// TODO: Add your command handler code here
	CLeftTreeView* pLeftView;
	pLeftView=(CLeftTreeView*)m_wndSplitter.GetPane(0,0);
	//具体操作在视图类中
	pLeftView->DelSinger();
	
}

void CMainFrame::OnDelsong() 
{
	// TODO: Add your command handler code here

	CRightListView* pListView;
	pListView=(CRightListView*)m_wndSplitter.GetPane(0,1);
	//具体操作在视图类中
	pListView->DeleteSong();





	
	
}

void CMainFrame::OnEditsong() 
{
	// TODO: Add your command handler code here
	CRightListView* pListView;
	pListView=(CRightListView*)m_wndSplitter.GetPane(0,1);
	//具体操作在视图类中
	pListView->EditSong();


	
	
}

void CMainFrame::OnQuery() 
{
	// TODO: Add your command handler code here
    CQueryDlg dlg;
	CString strSql;
    char chTem='%';
    CString ziduan;

	if(dlg.DoModal()!=IDOK)
		return;
    


 
  switch(dlg.m_Selection) {
   case 0:
 	        strSql.Format("'%c%s%c'",chTem,dlg.m_queryfname,chTem);
        	ziduan="FileName";
            strSql=ziduan+" "+"like"+" "+strSql;
 	  
   	break;
   
  case 1:   strSql.Format("'%c%s%c'",chTem,dlg.m_querysname,chTem);
	         ziduan="Singer";
             strSql=ziduan+" "+"like"+" "+strSql;
 
   	break;
  case 2:  strSql.Format("'%c%s%c'",chTem,dlg.m_classify,chTem);
	         ziduan="Classify";
             strSql=ziduan+" "+"like"+" "+strSql;
 
  // default:
 
   }
 
 
 











/*
	else if(dlg.DoModal()==IDOK)
	{

     if (dlg.m_Selection==0) 
	 strSql=dlg.m_querysname;
	// if (dlg.m_Selection==1) 
    }*/

	
	CSongRecordSet db;
	CRightListView* pListView;
	pListView=(CRightListView*)m_wndSplitter.GetPane(0,1);
	//具体操作在视图类中	 
	//strSql=dlg.m_queryfname;
/*
	CString a="FileName=";
    strSql=a+"'wenqing'";*/

	pListView->AddToList(db,strSql);
}

void CMainFrame::OnOpenSingle() 
{
	// TODO: Add your control notification handler code here
	if(m_PlayBar.m_hMp3!=NULL)
	{
		MCIWndDestroy(m_PlayBar.m_hMp3);
		m_PlayBar.m_hMp3=NULL;
	}
	CFileDialog mp3(TRUE,NULL,NULL,OFN_HIDEREADONLY,"MP3 Files (*.mp3)|*.mp3|");
	if(mp3.DoModal()!=IDOK)
	{
		return;
	}
	m_PlayBar.m_strPath=mp3.GetPathName();
	m_PlayBar.Play(m_PlayBar.m_strPath);


	
}

BOOL CMainFrame::OnCmdMsg(UINT nID, int nCode, void* pExtra, AFX_CMDHANDLERINFO* pHandlerInfo) 
{
	// TODO: Add your specialized code here and/or call the base class
     if (m_PlayBar.OnCmdMsg(nID,nCode,pExtra,pHandlerInfo))
		return TRUE;

	
	
	return CFrameWnd::OnCmdMsg(nID, nCode, pExtra, pHandlerInfo);
}