// CaDialog.cpp : implementation file
//

#include "stdafx.h"
#include "lhwy.h"
#include "CaDialog.h"
#include  "lhwyDlg.h"


#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CCaDialog dialog



CCaDialog::CCaDialog(CWnd* pParent /*=NULL*/)
	: CDialog(CCaDialog::IDD, pParent)
{    
	//{{AFX_DATA_INIT(CCaDialog)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT

}


void CCaDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCaDialog)
	DDX_Control(pDX, IDC_DELECTOBJECT, m_DelectObject);
	DDX_Control(pDX, IDC_DELE, m_Dele);
	DDX_Control(pDX, IDC_BUTTON1, m_DelObject);
	DDX_Control(pDX, IDC_ADDOBJECT, m_AddObject);
	DDX_Control(pDX, IDC_COMBAN, m_comban);
	DDX_Control(pDX, IDC_COMOBJECT, m_comobject);
	DDX_Control(pDX, IDC_COM, m_Com);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCaDialog, CDialog)
	//{{AFX_MSG_MAP(CCaDialog)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_DELE, OnDele)
	ON_BN_CLICKED(IDC_ADDOBJECT, OnAddobject)
	ON_BN_CLICKED(IDC_DELECTOBJECT, OnDelectobject)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCaDialog message handlers

BOOL CCaDialog::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
   CDRecordset m_Set(&theApp.m_DB);
   CBRecordset m_bSet(&theApp.m_DB);
   CTRecordset m_tSet(&theApp.m_DB);

  //GetDlgItem(IDC_DELECTOBJECT)->EnableWindow(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCaDialog::OnButton1() 
{
	// TODO: Add your control notification handler code here
//	pmyListCtrl.Create(
 //  WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT,
 //  CRect(0,0,800,300), this, 1);

   CString m_string;
   int k=m_Com.GetCurSel();
   if(k==CB_ERR )
   {
	AfxMessageBox("一定要選擇班級");
	return;
   }
   else{
    m_Com.GetLBText(k,m_string);
    CString SqlCmd;
   SqlCmd.Format("CREATE TABLE %sSTUDENT(學號 INTEGER ,姓名 VARCHAR(10) ,數學 REAL  ,物理 REAL,化學 REAL, 英語 REAL, 政治 REAL,總成績 REAL,平均成績 REAL );",m_string); 
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("CREATE TABLE %sOBJECT(科目 VARCHAR(20),總成績 REAL,平均成績 REAL,及格人數 REAL,優秀人數 REAL);",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("CREATE TABLE %sTECHER(科目 VARCHAR(20),任課老師 VARCHAR(20));",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("%s創建成功",m_string);
   AfxMessageBox(SqlCmd);
   SqlCmd.Format("INSERT INTO %sSTUDENT (學號,姓名,數學,物理,化學,英語, 政治,總成績,平均成績) VALUES (0,'',0,0,0,0,0,0,0)",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("INSERT INTO %sOBJECT(科目,總成績,平均成績,及格人數,優秀人數) VALUES('數學',0,0,0,0)",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("INSERT INTO %sOBJECT(科目,總成績,平均成績,及格人數,優秀人數) VALUES('物理',0,0,0,0)",m_string);
  theApp.m_DB.ExecuteSQL(SqlCmd);
 SqlCmd.Format("INSERT INTO %sOBJECT(科目,總成績,平均成績,及格人數,優秀人數) VALUES('化學',0,0,0,0)",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
 SqlCmd.Format("INSERT INTO %sOBJECT(科目,總成績,平均成績,及格人數,優秀人數) VALUES('英語',0,0,0,0)",m_string);
  theApp.m_DB.ExecuteSQL(SqlCmd);
 SqlCmd.Format("INSERT INTO %sOBJECT(科目,總成績,平均成績,及格人數,優秀人數) VALUES('政治',0,0,0,0)",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
  SqlCmd.Format("INSERT INTO %sTECHER(科目,任課老師) VALUES('','')",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
   
  }
   
CWnd *ppWnd=CWnd::FindWindow(NULL,"學生成績管理");
((CLhwyDlg*) ppWnd)->m_bdlg.PostMessage(WM_CREATETABEL,k+3);

//m_comban.AddString(m_string);
 

}

void CCaDialog::OnDele() 
{
	// TODO: Add your control notification handler code here
   CString m_string;
   int k=m_Com.GetCurSel();
   if(k==CB_ERR )
   {
	AfxMessageBox("一定要選擇班級");
	return;
   }
   else{
   m_Com.GetLBText(k,m_string);
   CString SqlCmd;
   SqlCmd.Format("DROP TABLE %sSTUDENT;",m_string); 
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("DROP TABLE %sOBJECT;",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("DROP TABLE %sTECHER;",m_string);
   theApp.m_DB.ExecuteSQL(SqlCmd);
   SqlCmd.Format("%s刪除成功",m_string);
   AfxMessageBox(SqlCmd);
   }

 CWnd *ppWnd=CWnd::FindWindow(NULL,"學生成績管理");
((CLhwyDlg*) ppWnd)->m_bdlg.PostMessage(WM_DELTABEL,k+3);



}

void CCaDialog::OnAddobject() 
{
	// TODO: Add your control notification handler code here
  CString m_string;
  CString m_Getstring;
   
 if(m_comobject.GetCurSel()==CB_ERR||m_comban.GetCurSel()==CB_ERR)
   {
	AfxMessageBox("一定要選擇");
	return;
   }
   else{
   m_comobject.GetLBText(m_comobject.GetCurSel(),m_string);
   m_comban.GetLBText(m_comban.GetCurSel(),m_Getstring);
   CString SqlCmd;
   SqlCmd.Format("Alter Table %sSTUDENT Add %s REAL;",m_Getstring,m_string ); 
   theApp.m_DB.ExecuteSQL(SqlCmd);
    SqlCmd.Format("%s的%s科目加入成功",m_Getstring ,m_string);
	AfxMessageBox(SqlCmd);
   }

}

void CCaDialog::OnDelectobject() 
{
	// TODO: Add your control notification handler code here
  CString m_string;
  CString m_Getstring;
   
 if(m_comobject.GetCurSel()==CB_ERR||m_comban.GetCurSel()==CB_ERR)
   {
	AfxMessageBox("一定要選擇");
	return;
   }
else{
   m_comobject.GetLBText(m_comobject.GetCurSel(),m_string);
   m_comban.GetLBText(m_comban.GetCurSel(),m_Getstring);
   CString SqlCmd;
   SqlCmd.Format("Alter Table %sSTUDENT Drop %s;",m_Getstring,m_string ); 
   theApp.m_DB.ExecuteSQL(SqlCmd);
    SqlCmd.Format("%s的%s科目刪除成功",m_Getstring ,m_string);
	AfxMessageBox(SqlCmd);
   }
}