// LevelDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MenuManage.h"
#include "LevelDlg.h"
#include "columns.h"
#include "column.h"
#include "UpdateUserDlg.h"

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

extern CMenuManageApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CLevelDlg dialog


CLevelDlg::CLevelDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLevelDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLevelDlg)
	m_strLookforName = _T("");
	m_nUpdateNum = 0;
	//}}AFX_DATA_INIT
}


void CLevelDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLevelDlg)
	DDX_Text(pDX, IDC_LOOKFOR_NAME, m_strLookforName);
	DDX_Control(pDX, IDC_DATAGRID_USER, m_dbUserInfo);
	DDX_Text(pDX, IDC_UPDATE_NUM, m_nUpdateNum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLevelDlg, CDialog)
	//{{AFX_MSG_MAP(CLevelDlg)
	ON_BN_CLICKED(IDC_LOOKFOR_BTN, OnLookforBtn)
	ON_BN_CLICKED(ID_UPDATE_BTN, OnUpdateBtn)
	ON_BN_CLICKED(IDC_DISP_ALL_BTN, OnDispAllBtn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLevelDlg message handlers

BOOL CLevelDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//初始化記錄集對象
	try
	{

		m_pRecordset.CreateInstance("ADODB.Recordset");
		//打開記錄集
	    m_pRecordset->Open("SELECT * FROM UserInfo",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	}	
	catch(_com_error e)///捕捉異常
	{
		CString temp;
		temp.Format("aaa連接數據庫錯誤信息:%s",e.ErrorMessage());
		AfxMessageBox(temp);
		return 0;
	}

	m_dbUserInfo.SetRefDataSource(NULL);
	m_dbUserInfo.SetRefDataSource((LPUNKNOWN)m_pRecordset);
	m_dbUserInfo.SetColumnHeaders(2) ;

	_variant_t vIndex;
	vIndex = long(0);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("姓名");
	vIndex = long(1);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("編號");
	vIndex = long(2);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("密碼");
	vIndex = long(3);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("權限");
	vIndex = long(4);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("性別");
	vIndex = long(5);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("年齡");
	vIndex = long(6);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("籍貫");
	vIndex = long(7);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(100);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("家庭住址");

	m_dbUserInfo.Refresh();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

BEGIN_EVENTSINK_MAP(CLevelDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CLevelDlg)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()



void CLevelDlg::OnLookforBtn() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	
	m_pRecordset->Close();
	CString sql;
	sql = "SELECT * FROM UserInfo WHERE UserName = '"+m_strLookforName+"'";
    m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	m_pRecordset ->Update();
	
	m_dbUserInfo.SetRefDataSource((LPUNKNOWN)m_pRecordset);
	m_dbUserInfo.SetColumnHeaders(2) ;

	_variant_t vIndex;
	vIndex = long(0);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("姓名");
	vIndex = long(1);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("編號");
	vIndex = long(2);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("密碼");
	vIndex = long(3);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("權限");
	vIndex = long(4);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("性別");
	vIndex = long(5);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("年齡");
	vIndex = long(6);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("籍貫");
	vIndex = long(7);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(100);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("家庭住址");

	m_dbUserInfo.Refresh();
}

void CLevelDlg::OnUpdateBtn() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_pRecordset->Close();
	CString str;
	str.Format("%d",m_nUpdateNum);

	CString sql;
	sql =  "SELECT * FROM UserInfo WHERE UserNum = "+str+" ";
    m_pRecordset->Open((_variant_t)sql,
		_variant_t((IDispatch *)theApp.m_pConnection,true),
		adOpenDynamic,
		adLockPessimistic,
		adCmdText);
	m_pRecordset ->Update();
	
	if(m_pRecordset->adoEOF||m_pRecordset->BOF) 
	{
		AfxMessageBox("沒有此編號的員工");
	}
	else
	{
		CUpdateUserDlg dlg(this);
		dlg.m_strUpdateName = m_pRecordset->GetCollect("UserName").bstrVal;
		dlg.m_nUpdateNumber = m_nUpdateNum;
		dlg.m_nUpdateLevel = m_pRecordset->GetCollect("UserLevel").lVal;
		dlg.DoModal();
	}

}


void CLevelDlg::OnDispAllBtn() 
{
	// TODO: Add your control notification handler code here
	m_pRecordset->Close();
    m_pRecordset->Open("SELECT * FROM UserInfo",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	m_pRecordset ->Update();
	
	m_dbUserInfo.SetRefDataSource((LPUNKNOWN)m_pRecordset);
	_variant_t vIndex;
	vIndex = long(0);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("姓名");
	vIndex = long(1);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("編號");
	vIndex = long(2);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("密碼");
	vIndex = long(3);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("權限");
	vIndex = long(4);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("性別");
	vIndex = long(5);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(30);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("年齡");
	vIndex = long(6);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(50);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("籍貫");
	vIndex = long(7);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetWidth(100);
	m_dbUserInfo.GetColumns().GetItem(vIndex).SetCaption("家庭住址");

	m_dbUserInfo.Refresh();	
}