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

#include "stdafx.h"
#include "member.h"

#include "MainFrm.h"
#include "MemberSearchDlg.h"
#include "MemberDialog.h"
#include "MemberReSet.h"
#include "MemberEditDlg.h"
#include "LeftTreeView.h"
#include "ScoreDlg.h"
#include "MemberAdd.h"
#include "SearchScoreDlg.h"
#include "HelpDlg.h"
#include "ScoreAddDlg.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_MEMBER_ADD, OnMemberAdd)
	ON_COMMAND(ID_MEMBER_EDIT, OnMemberEdit)
	ON_COMMAND(ID_MEMBER_DEL, OnMemberDel)
	ON_COMMAND(ID_MEMBER_LIST, OnMemberList)
//	ON_COMMAND(ID_USER_ADD, OnUserAdd)
//	ON_COMMAND(ID_USER_DEL, OnUserDel)
	ON_COMMAND(ID_MEMBER_MORE, OnMemberMore)
	ON_COMMAND(ID_ONPAINT, OnOnpaint)
	ON_COMMAND(ID_SCORE_LIST, OnScoreList)
	ON_COMMAND(ID_SEARCH_SCORE, OnSearchScore)
	ON_COMMAND(IDC_HELP_DIALOG, OnHelpDialog)
	ON_COMMAND(ID_SCORE_ADD, OnScoreAdd)
	//}}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))
	{
		TRACE0("Failed to create toolbar\n");
		return -1;      // fail to create
	}

	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
	}

	// 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;
}

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


void CMainFrame::OnMemberAdd() //工具欄中的添加信息
{
	// TODO: Add your command handler code here
	m_ListView->MemberAdd();
}

void CMainFrame::OnMemberEdit() //工具欄中的個人信息
{
	// TODO: Add your command handler code here
   	m_ListView->EditCurUser();
}

void CMainFrame::OnMemberDel() 
{
	// TODO: Add your command handler code here
	
   m_ListView->DelCurUser();
}
 
void CMainFrame::OnMemberList() //工具欄中的信息查詢
{
	// TODO: Add your command handler code here
    //個人信息查詢
    CMemberSearchDlg m_SearchDlg;
	//取消按扭，則退出
	if(m_SearchDlg.DoModal()==IDOK)
	//確定按扭輸出用戶信息
	{
		m_ListView->ListMember(m_SearchDlg.m_strSearch,m_SearchDlg.m_strMemberSearch);
	//	return;
	}
}   


void CMainFrame::OnMemberMore() 
{
	// TODO: Add your command handler code here
   	m_ListView->EditCurUser();
	//刷新全部信息
    m_ListView->RemoveAll();
    m_ListView->OnPaint();
}


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(CMemberView),CSize(150,150),pContext))
		return FALSE;
	m_pLeftView = (CLeftTreeView*)m_wndSplitter.GetPane(0,0);
	m_ListView = (CMemberView*)m_wndSplitter.GetPane(0,1);

	return TRUE;

}

void CMainFrame::OnOnpaint() 
{
	// TODO: Add your command handler code here
		m_ListView->OnPaint();
	
}

void CMainFrame::OnScoreList() //工具欄中的查看成績
{
	// TODO: Add your command handler code here
	CString sql,str;
	str=m_ListView->FindPosition();
	if(str=="")
		return;
	sql.Format("select * from score where MemID='%s'",str);
//	AfxMessageBox(sql);
	CScoreDlg m_ScoreDlg;
    m_ScoreDlg.AddPosition(sql);
	// m_ScoreDlg.ListScore(cstring);
    if(m_ScoreDlg.DoModal()!=IDOK)
		return;
}

void CMainFrame::OnSearchScore() //工具欄中的成績查詢
{
	// TODO: Add your command handler code here
    CSearchScoreDlg m_SearchScoreDlg;
	CString strsql,sqlcourse,strCourse,strSQL;
	BOOL temp=FALSE;
	//取消按扭，則退出
	if(m_SearchScoreDlg.DoModal()!=IDOK)
		return;
	//無關鍵字輸入提示
	if(m_SearchScoreDlg.m_Course==""&&m_SearchScoreDlg.m_Score==0)
	{
	    AfxMessageBox("請輸入查詢條件");
	    return;
	}
	//選擇課程查詢條件
	if(m_SearchScoreDlg.m_SearchCourse=="課程編號")
	    strCourse="CourseID";
	else if(m_SearchScoreDlg.m_SearchCourse=="課程名稱")
	    strCourse="CourseName";
   	else
	{
	   	AfxMessageBox("請選擇正確的課程查詢條件");
	    return;
	}
	//合并查詢條件
	if(m_SearchScoreDlg.m_Course!="")
	{
		sqlcourse.Format("%s='%s'",strCourse,m_SearchScoreDlg.m_Course);
	    temp=TRUE;
	}
   	if(m_SearchScoreDlg.m_Score!=0)
	{
		if(temp)
		strsql.Format("%s and Score%s%d",sqlcourse,m_SearchScoreDlg.m_SearchScore,m_SearchScoreDlg.m_Score);
		else
		strsql.Format("Score%s%d",m_SearchScoreDlg.m_SearchScore,m_SearchScoreDlg.m_Score);
	}
	else
		strsql=sqlcourse;
		strSQL="select * from score where "+strsql;
	CScoreDlg m_ScoreDlg;	
	m_ScoreDlg.AddPosition(strSQL);	
   	if(m_ScoreDlg.DoModal()!=IDOK)
		return;
	CButton* button=(CButton*)GetDlgItem(IDC_SCORE_ADD);   
    if(button)   
	{   
        button->EnableWindow(FALSE);   
	}
}

void CMainFrame::OnHelpDialog() 
{
	// TODO: Add your command handler code here
	CHelpDlg m_HelpDlg;
 	if(m_HelpDlg.DoModal()!=IDOK)
	  return;
	
}

void CMainFrame::OnScoreAdd() //工具欄中的成績導入
{
	// TODO: Add your command handler code here
	CScoreAddDlg m_ScoreAddDlg;
	if(m_ScoreAddDlg.DoModal()!=IDOK)
	  return;
}