dlgmeetdefine.cpp

航空公司简单考勤系统：主要运用指纹管理深圳航空公司的会议签到管理系统

// DlgMeetDefine.cpp : implementation file
//

#include "stdafx.h"
#include "Demo_airline.h"
#include "DlgMeetDefine.h"
#include <assert.h>
#include "DlgMeetSet.h"

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

extern CDemo_airlineApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CDlgMeetDefine dialog


CDlgMeetDefine::CDlgMeetDefine(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgMeetDefine::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgMeetDefine)
	m_strMeetNo = _T("");
	m_strMeetName = _T("");
	//}}AFX_DATA_INIT
}


void CDlgMeetDefine::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgMeetDefine)
	DDX_Text(pDX, IDC_EDT_MEETNO, m_strMeetNo);
	DDV_MaxChars(pDX, m_strMeetNo, 11);
	DDX_Text(pDX, IDC_EDT_MEETNAME, m_strMeetName);
	DDV_MaxChars(pDX, m_strMeetName, 100);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgMeetDefine, CDialog)
	//{{AFX_MSG_MAP(CDlgMeetDefine)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgMeetDefine message handlers

void CDlgMeetDefine::OnOK() 
{
	UpdateData(TRUE);
	CString strBeginDate,strEndDate;
	CString strOnBeginTime,strOnEndTime;
	
    CDateTimeCtrl* pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_DATE_BEGIN);
	pDateCtrl->GetWindowText(strBeginDate);

    pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_DATE_END);
	pDateCtrl->GetWindowText(strEndDate);

    pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_TIME_BEGIN);
	pDateCtrl->GetWindowText(strOnBeginTime);

	pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_TIME_END);
	pDateCtrl->GetWindowText(strOnEndTime);


	try
	{
		/*CString strSql;
		strSql.Format("insert into meeting (MeetingNo,MeetingName,BeginDate,EndDate,OnBeginTime,OnEndTime) "\
			 " values('%s','%s','%s','%s','%s','%s')", m_strMeetNo,m_strMeetName,strBeginDate,strEndDate,strOnBeginTime,strOnEndTime  );*/
        
		m_pRecordMeet->Open("select * from Meeting",
			                    theApp.m_pConnection.GetInterfacePtr(),
								adOpenDynamic,
								adLockOptimistic,
								adCmdText);
		
		m_pRecordMeet->AddNew();
		m_pRecordMeet->PutCollect("MeetingNo",_bstr_t(m_strMeetNo));
		m_pRecordMeet->PutCollect("MeetingName",_bstr_t(m_strMeetName));
		m_pRecordMeet->PutCollect("BeginDate",_bstr_t(strBeginDate));
		m_pRecordMeet->PutCollect("EndDate",_bstr_t(strEndDate));
		m_pRecordMeet->PutCollect("OnBeginTime",_bstr_t(strOnBeginTime));
		m_pRecordMeet->PutCollect("OnEndTime",_bstr_t(strOnEndTime));
		m_pRecordMeet->Update();

		m_pRecordMeet->Close();
	}
	catch(_com_error e)
	{
		e.Description();
	}
	


	CDialog::OnOK();
}

void CDlgMeetDefine::CreateMeetNo()
{
	CTime time = CTime::GetCurrentTime();
    CString strDate ;
	strDate.Empty();
	strDate.Format("%02d-%02d-%02d",time.GetYear(),time.GetMonth(),time.GetDay());
	int nIndex = 0;
	nIndex = FindMeetCount(strDate);
	
	strDate.Empty();
	strDate.Format("%02d%02d%02d",time.GetYear(),time.GetMonth(),time.GetDay());
	
	strDate.Format(strDate + "%03d",nIndex+1);
	m_strMeetNo = strDate;
}

BOOL CDlgMeetDefine::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	CDateTimeCtrl* pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_DATE_BEGIN);
	pDateCtrl->SetFormat("yyyy-MM-dd");
    pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_DATE_END);
    pDateCtrl->SetFormat("yyyy-MM-dd");

	pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_TIME_BEGIN);
	pDateCtrl->SetFormat("hh:mm:ss");
	pDateCtrl = (CDateTimeCtrl*)GetDlgItem(IDC_TIME_END);
    pDateCtrl->SetFormat("hh:mm:ss");

    m_pRecordMeet.CreateInstance(__uuidof(Recordset));

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

/* 功能: 获取某天内会议的数目
   参数: 具体日期
   返回: 会议数目
*/
int CDlgMeetDefine::FindMeetCount(LPCTSTR lpszDate)
{
    assert(NULL != lpszDate);
	int nCount = 0;
	try
	{
		CString strSql;
		strSql.Format("SELECT count(*) from Meeting");
		/*m_pRecordMeet->Open(strSql.AllocSysString(),
			                    theApp.m_pConnection.GetInterfacePtr(),
								adOpenDynamic,
								adLockOptimistic,
								adCmdText);*/
		//m_pRecordMeet = theApp.m_pConnection->Execute(strSql.AllocSysString(),&RecordsAffected,adCmdText);
		_variant_t vIndex = (long)0;
		_variant_t vCount = m_pRecordMeet->GetCollect(vIndex);
		m_pRecordMeet->Close();
		
		char strCount[3] = {0};
		
		strcpy(strCount,(LPCSTR)_bstr_t(vCount));
		assert(NULL != strCount);
		nCount = atoi(strCount);

	//	m_pRecordMeet->Close();
	}
	catch(_com_error e)
	{
       AfxMessageBox(e.ErrorMessage());
	}
	return nCount;
}