trainexpeinfodlg.cpp

VC++和ACCESS使用ADO连接

// TrainExpeInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MinistryPerson.h"
#include "TrainExpeInfoDlg.h"

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

/////////////////////////////////////////////////////////////////////////////

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

void TrainExpeInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(TrainExpeInfoDlg)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(TrainExpeInfoDlg, CDialog)
	//{{AFX_MSG_MAP(TrainExpeInfoDlg)
	ON_BN_CLICKED(IDC_BUTTON_TR_SAVE, OnButtonTrSave)
	ON_BN_CLICKED(IDC_BUTTON_TR_MODIFY, OnButtonTrModify)
	ON_BN_CLICKED(IDC_BUTTON_TR_MORE, OnButtonTrMore)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// TrainExpeInfoDlg message handlers

BOOL TrainExpeInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	if (!g_bQueryToShow)
	{
		((CEdit*)GetDlgItem(IDC_EDIT_TR_MOREREMARK))->EnableWindow(FALSE);
		GetDlgItem(IDC_BUTTON_TR_SAVE)->EnableWindow(TRUE);
		GetDlgItem(IDC_BUTTON_TR_MODIFY)->EnableWindow(FALSE);
		IniAllTimePicker();
		m_bSaveNotModify_TE = TRUE;
	}
	else
	{		
		GetDlgItem(IDC_BUTTON_TR_SAVE)->EnableWindow(FALSE);
		GetDlgItem(IDC_BUTTON_TR_MODIFY)->EnableWindow(TRUE);
		CtrlStatus_TrainE(FALSE);
		GetTrainEInfoFromDB();
		m_bSaveNotModify_TE = FALSE;
	}

	return TRUE;  
}

/*********************************************************************
函数说明:	  保存按钮
函数参数:	  
*********************************************************************/
void TrainExpeInfoDlg::OnButtonTrSave() 
{
	if (!CheckAllInfo_TrainE())
	{
		return;
	}

	if (!m_bSaveNotModify_TE)
	{
		if (g_bQueryToShow)
		{
			TrModify(g_nEmployee_ID, g_strEmployee_IDCard);
		}
		else
		{
			TrModify(g_In_nID, g_In_strIDCard);
		}		
	}
	else
	{
		TrSave(g_In_nID, g_In_strIDCard);		// 保存
	}	
}

/*********************************************************************
函数说明:	  修改按钮
函数参数:	  
*********************************************************************/
void TrainExpeInfoDlg::OnButtonTrModify() 
{
	CtrlStatus_TrainE(TRUE);
	m_bSaveNotModify_TE = FALSE;
	GetDlgItem(IDC_BUTTON_TR_SAVE)->EnableWindow(TRUE);
	GetDlgItem(IDC_BUTTON_TR_MODIFY)->EnableWindow(FALSE);
}

/*********************************************************************
函数说明:	  保存按钮
函数参数:	  
*********************************************************************/
BOOL TrainExpeInfoDlg::TrSave(int nKeyID, CString strKeyIDCard) 
{
	CADOOperation ADOdbo;
	CString SQL;
	
	SQL.Format("insert into Employee_TrainExpe_Table \
		values (%d, '%s', \
		'%s', '%s', '%s', '%s', '%s', '%s', '%s', \
		'%s', '%s', '%s', '%s', '%s', '%s', '%s', \
		'%s', '%s', '%s', '%s', '%s', '%s', '%s', \
		'%s')", nKeyID, strKeyIDCard,																		
		Train_StuBegTime1, Train_StuEndTime1, Train_TrainSchool1, Train_TrainAddress1, Train_Speciality1, Train_Diploma1, Train_StudyMode1,	
		Train_StuBegTime2, Train_StuEndTime2, Train_TrainSchool2, Train_TrainAddress2, Train_Speciality2, Train_Diploma2, Train_StudyMode2,
		Train_StuBegTime3, Train_StuEndTime3, Train_TrainSchool3, Train_TrainAddress3, Train_Speciality3, Train_Diploma3, Train_StudyMode3,	
		Train_Remark);
	ADOdbo.OpenRecordset(SQL);
	ADOdbo.CloseRecorset();	

	GetDlgItem(IDC_BUTTON_TR_SAVE)->EnableWindow(FALSE);
	GetDlgItem(IDC_BUTTON_TR_MODIFY)->EnableWindow(TRUE);
	CtrlStatus_TrainE(FALSE);
	MessageBox("员工 【教育培训经历信息】 录入成功！", "成功", MB_OK | MB_ICONEXCLAMATION);
	return TRUE;
}

/*********************************************************************
函数说明:	  修改按钮
函数参数:	  
*********************************************************************/
BOOL TrainExpeInfoDlg::TrModify(int nKeyID, CString strKeyIDCard) 
{
	CADOOperation ADOdbo;
	CString SQL; 
	CString strFields[] = {"employee_ID", "employee_IDCard"};
	CString strRetValue[2];
	strRetValue[0] = "NOID";
	strRetValue[1] = "NOIDCARD";

	SQL.Format("select employee_ID, employee_IDCard from Employee_TrainExpe_Table \
				where employee_ID = %d and employee_IDCard = '%s'", nKeyID, strKeyIDCard);
	ADOdbo.OpenRecordset(SQL);
	ADOdbo.GetFieldsValue(strFields, 2, strRetValue, FALSE);
	ADOdbo.CloseRecorset();
	if (strRetValue[0] == "NOID" && strRetValue[1] == "NOIDCARD")
	{
		TrSave(nKeyID, strKeyIDCard);
		return TRUE;
	}

 	SQL.Format("update Employee_TrainExpe_Table \
		set TrainExpe_StuBegTime1 = '%s', TrainExpe_StuEndTime1 = '%s', TrainExpe_TrainSchool1 = '%s', TrainExpe_Speciality1 = '%s', TrainExpe_TrainAddress1 = '%s', TrainExpe_StudyMode1 = '%s', TrainExpe_Diploma1 = '%s', \
			TrainExpe_StuBegTime2 = '%s', TrainExpe_StuEndTime2 = '%s', TrainExpe_TrainSchool2 = '%s', TrainExpe_Speciality2 = '%s', TrainExpe_TrainAddress2 = '%s', TrainExpe_StudyMode2 = '%s', TrainExpe_Diploma2 = '%s', \
		    TrainExpe_StuBegTime3 = '%s', TrainExpe_StuEndTime3 = '%s', TrainExpe_TrainSchool3 = '%s', TrainExpe_Speciality3 = '%s', TrainExpe_TrainAddress3 = '%s', TrainExpe_StudyMode3 = '%s', TrainExpe_Diploma3 = '%s', \
		    TrainExpe_Remark = '%s' \
			where employee_ID = %d AND employee_IDCard = '%s'",
			Train_StuBegTime1, Train_StuEndTime1, Train_TrainSchool1, Train_Speciality1,Train_TrainAddress1, Train_StudyMode1, Train_Diploma1,
			Train_StuBegTime2, Train_StuEndTime2, Train_TrainSchool2, Train_Speciality2,Train_TrainAddress2, Train_StudyMode2, Train_Diploma2,
			Train_StuBegTime3, Train_StuEndTime3, Train_TrainSchool3, Train_Speciality3,Train_TrainAddress3, Train_StudyMode3, Train_Diploma3,
			Train_Remark, nKeyID, strKeyIDCard);
	ADOdbo.OpenRecordset(SQL);
	ADOdbo.CloseRecorset();

	CtrlStatus_TrainE(FALSE);
	GetDlgItem(IDC_BUTTON_TR_SAVE)->EnableWindow(FALSE);
	GetDlgItem(IDC_BUTTON_TR_MODIFY)->EnableWindow(TRUE);
	MessageBox("员工 【教育培训经历信息】 修改成功！", "成功", MB_OK | MB_ICONEXCLAMATION);
	return TRUE;
}

/*********************************************************************
函数说明:	  填写
函数参数:	  
*********************************************************************/
void TrainExpeInfoDlg::OnButtonTrMore() 
{
	CString str;
	
	if(GetDlgItemText(IDC_BUTTON_TR_MORE, str), str == "填写")
	{
		SetDlgItemText(IDC_BUTTON_TR_MORE, "关闭");
		((CEdit*)GetDlgItem(IDC_EDIT_TR_MOREREMARK))->EnableWindow(TRUE);
	}
	else
	{
		SetDlgItemText(IDC_BUTTON_TR_MORE, "填写");		
		((CEdit*)GetDlgItem(IDC_EDIT_TR_MOREREMARK))->EnableWindow(FALSE);
	}	

}

/*********************************************************************
函数说明:	  初始化时间显示
函数参数:	  
*********************************************************************/
void TrainExpeInfoDlg::IniAllTimePicker()
{
	SYSTEMTIME sysTime = {0};
	sysTime.wYear  = 1900;
	sysTime.wMonth = 1;
	sysTime.wDay   = 1;

	((CDateTimeCtrl*)GetDlgItem(IDC_DTP_TR_SBT1))->SetTime(&sysTime);
	((CDateTimeCtrl*)GetDlgItem(IDC_DTP_TR_SBT2))->SetTime(&sysTime);
	((CDateTimeCtrl*)GetDlgItem(IDC_DTP_TR_SBT3))->SetTime(&sysTime);

	((CDateTimeCtrl*)GetDlgItem(IDC_DTP_TR_SET1))->SetTime(&sysTime);
	((CDateTimeCtrl*)GetDlgItem(IDC_DTP_TR_SET2))->SetTime(&sysTime);