// DocManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HosptialMan.h"
#include "DocManDlg.h"
#include "DocEditDlg.h"
#include "Doctor.h"
#include "columns.h"
#include "column.h"
#include "COMDEF.H"
#include "_recordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDocManDlg dialog


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


void CDocManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDocManDlg)
	DDX_Control(pDX, IDC_SEL_COMBO, m_Sel);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_ADODC2, m_AdoDept);
	DDX_Control(pDX, IDC_DATACOMBO1, m_Dept);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDocManDlg, CDialog)
	//{{AFX_MSG_MAP(CDocManDlg)
	ON_CBN_SELCHANGE(IDC_SEL_COMBO, OnSelchangeSelCombo)
	ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
	ON_BN_CLICKED(IDC_EDIT_BUTTON, OnEditButton)
	ON_BN_CLICKED(IDC_DELT_BUTTON, OnDeltButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDocManDlg message handlers
void CDocManDlg::RefreshData()
{
	// 刷新記錄
	CString cSql;
	cSql = "SELECT d.Id, d.Name AS 姓名, d.Sex AS 性別, d.Age AS 年齡,";
	cSql += " b.TypeName AS 科室, d.DeptId,d.Title AS 職務 ";
	cSql += "FROM Doctor d,BaseType b WHERE b.TypeId=1 AND d.DeptId=b.Id";
	// 查詢條件（科室）是否為空
	CString cDeptId;
	if(m_Sel.GetCurSel()==1)
	{
		cDeptId = m_Dept.GetBoundText();
		if(cDeptId!="")
			cSql += " AND d.DeptId=" + cDeptId;
	}
//	MessageBox(cSql);
	m_Adodc.SetRecordSource((LPCTSTR)(_bstr_t)cSql);
	m_Adodc.Refresh();
	// 設置列寬度
	_variant_t vIndex;
	vIndex = long(0);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);  // 姓名
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(2);  // 性別
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(3);  // 年齡
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(4);  // 科室
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(5);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(6);  // 職務
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(120);
}

BOOL CDocManDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// 設置查詢條件為全部醫生信息
	m_Sel.SetCurSel(0);
	// 當查詢條件為全部醫生信息時，不顯示科室信息
	GetDlgItem(IDC_DATACOMBO1)->ShowWindow(SW_HIDE);
	RefreshData();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDocManDlg::OnSelchangeSelCombo() 
{
	// 選擇全部時，則顯示后面的組合框，否則將其隱藏
	if(m_Sel.GetCurSel()==0)
		GetDlgItem(IDC_DATACOMBO1)->ShowWindow(SW_HIDE);
	else
		GetDlgItem(IDC_DATACOMBO1)->ShowWindow(SW_SHOW);
	//數據刷新
	RefreshData();	
}

BEGIN_EVENTSINK_MAP(CDocManDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CDocManDlg)
	ON_EVENT(CDocManDlg, IDC_DATACOMBO1, -600 /* Click */, OnClickDatacombo1, VTS_I2)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CDocManDlg::OnClickDatacombo1(short Area) 
{
	// 得到選擇的列值，刷新記錄
	if(m_Dept.GetBoundText()!="")
		RefreshData();	
}

void CDocManDlg::OnAddButton() 
{
	CDocEditDlg dlg;
	dlg.cDId = "";
	if(dlg.DoModal()==IDOK)
		RefreshData();	
}

void CDocManDlg::OnEditButton() 
{
	if (m_Adodc.GetRecordset().GetEof()) 
	{
		MessageBox("沒有數據");
		return;
	}
	// 定義固定資產對象并設置變量cId為空字符串
	CDocEditDlg dlg;
	dlg.cDId = m_DataGrid.GetItem(0);			//編號
	dlg.m_Name = m_DataGrid.GetItem(1);			//姓名
	dlg.cSex = m_DataGrid.GetItem(2);			//性別
	dlg.m_Age = atoi(m_DataGrid.GetItem(3));	//年齡
	dlg.cDeptId = m_DataGrid.GetItem(5);		//部門編號
	dlg.m_Title = m_DataGrid.GetItem(6);		//職務

	if(dlg.DoModal()==IDOK)
		RefreshData();			
}

void CDocManDlg::OnDeltButton() 
{
	if (m_Adodc.GetRecordset().GetEof()) 
	{
		MessageBox("請選擇要刪除的數據");
		return;
	}
	if (MessageBox("是否刪除當前記錄？","請確認", MB_YESNO) == IDYES)
	{
		CDoctor doct;
		doct.sql_Delete(m_DataGrid.GetItem(0));
		RefreshData();
	}		
}