menu_alterinfoflower.cpp

来自「VC++和ACCESS使用ADO连接」· C++ 代码 · 共 182 行

// Menu_AlterInfoFlower.cpp : implementation file
//

#include "stdafx.h"
#include "ministryperson.h"
#include "Menu_AlterInfoFlower.h"

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

/////////////////////////////////////////////////////////////////////////////
// Menu_AlterInfoFlower dialog


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


void Menu_AlterInfoFlower::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Menu_AlterInfoFlower)
	DDX_Control(pDX, IDC_ALF_LIST, m_AlterFlower_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Menu_AlterInfoFlower, CDialog)
	//{{AFX_MSG_MAP(Menu_AlterInfoFlower)
	ON_BN_CLICKED(IDC_ALF_BTN_QUERY, OnAlfBtnQuery)
	ON_BN_CLICKED(IDC_ALF_BTN_QUERYALL, OnAlfBtnQueryall)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Menu_AlterInfoFlower message handlers

BOOL Menu_AlterInfoFlower::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	MakeShowStyle();
	GetAlterInfoFromDB();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

/*********************************************************************
函数说明:	  清空数据表的显示
函数参数:	  void
*********************************************************************/
BOOL Menu_AlterInfoFlower::DeleteAllRows()
{
	m_AlterFlower_List.DeleteAllItems();	// 清空列表控件
	return TRUE;
}

/*********************************************************************
函数说明:	  设置列表控件一行的内容
函数参数:	  
*********************************************************************/
BOOL Menu_AlterInfoFlower::SetRow(int row, CString *strArray, int nCount)
{
	m_AlterFlower_List.InsertItem(row, strArray[0]);			// 在列表控件中插入一行
	for (int i = 1; i < nCount; i++)
	{
		m_AlterFlower_List.SetItemText(row, i, strArray[i]);	// 设置除第一行外的其他行
	}
	return TRUE;
}

/*********************************************************************
函数说明:	  要显示的内容项
函数参数:	  
*********************************************************************/
void Menu_AlterInfoFlower::MakeShowStyle()
{
	m_AlterFlower_List.SetExtendedStyle(LVS_EX_FLATSB | 
									  LVS_EX_GRIDLINES | 
									  LVS_EX_FULLROWSELECT | 
									  LVS_EX_ONECLICKACTIVATE);
	m_AlterFlower_List.InsertColumn(0, "序号", LVCFMT_LEFT, 50);
	m_AlterFlower_List.InsertColumn(1, "姓名", LVCFMT_LEFT, 50);
	m_AlterFlower_List.InsertColumn(2, "身份证", LVCFMT_LEFT, 145);
	m_AlterFlower_List.InsertColumn(3, "变动时间", LVCFMT_LEFT, 80);

	m_AlterFlower_List.InsertColumn(4, "（原）单位", LVCFMT_LEFT, 120);
	m_AlterFlower_List.InsertColumn(5, "【新】单位", LVCFMT_LEFT, 120);
	m_AlterFlower_List.InsertColumn(6, "（原）部门", LVCFMT_LEFT, 90);
	m_AlterFlower_List.InsertColumn(7, "【新】部门", LVCFMT_LEFT, 90);
	m_AlterFlower_List.InsertColumn(8, "（原）职务", LVCFMT_LEFT, 90);
	m_AlterFlower_List.InsertColumn(9, "【新】职务", LVCFMT_LEFT, 90);
	m_AlterFlower_List.InsertColumn(10, "工资截止日期", LVCFMT_LEFT, 90);
	m_AlterFlower_List.InsertColumn(11, "工资起薪日期", LVCFMT_LEFT, 90);
	m_AlterFlower_List.InsertColumn(12, "备注", LVCFMT_LEFT, 200);
}

/*********************************************************************
函数说明:	  通过数据库显示信息
函数参数:	  
*********************************************************************/
void Menu_AlterInfoFlower::GetAlterInfoFromDB()
{
	CADOOperation ADOdbo;
	CString SQL;
	CString strFields[] = {"PersonAlter_EventNum", "employee_Name", "employee_IDCard", "PersonAlter_AlterTime", 
						   "PersonAlter_OldCompany", "PersonAlter_NewCompany", 
						   "PersonAlter_OldDepart", "PersonAlter_NewDepart", 
						   "PersonAlter_OldDuty", "PersonAlter_NewDuty", 
						   "PersonAlter_PayOldEndT", "PersonAlter_PayNewBegT", 
						   "PersonAlter_Remark"};
	SQL.Format("select * from Employee_PersonAlter_Table where 1=1");
	ADOdbo.OpenRecordset(SQL);
	ADOdbo.ShowADOView(strFields, 13, this);
	ADOdbo.CloseRecorset();
}

/*********************************************************************
函数说明:	  通过数据库显示信息
函数参数:	  
*********************************************************************/
void Menu_AlterInfoFlower::OnAlfBtnQuery() 
{
	CString strFrom;
	CString strTo;
	GetDlgItemText(IDC_ALF_DTP_FROM, strFrom);
	GetDlgItemText(IDC_ALF_DTP_TO, strTo);

	CFuncOper FunOper;
	WORD wFrom[3];
	WORD wTo[3];
	FunOper.strTimeTowTime(strFrom, wFrom);
	FunOper.strTimeTowTime(strTo, wTo);
	if ((wFrom[0] > wTo[0]) ||
		((wFrom[0] == wTo[0]) && (wFrom[1] > wTo[1])) ||
		((wFrom[0] == wTo[0]) && (wFrom[1] == wTo[1]) && (wFrom[2] > wTo[2])))
	{
		MessageBox("输入时间段的前后关系有误！\t", "错误", MB_OK | MB_ICONERROR);
		GetDlgItem(IDC_ALF_DTP_FROM)->SetFocus();
		return;
	}

	CADOOperation ADOdbo;
	CString SQL;
	CString strFields[] = {"PersonAlter_EventNum", "employee_Name", "employee_IDCard", "PersonAlter_AlterTime", 
						   "PersonAlter_OldCompany", "PersonAlter_NewCompany", 
						   "PersonAlter_OldDepart", "PersonAlter_NewDepart", 
						   "PersonAlter_OldDuty", "PersonAlter_NewDuty", 
						   "PersonAlter_PayOldEndT", "PersonAlter_PayNewBegT", 
						   "PersonAlter_Remark"};
	SQL.Format("select * from Employee_PersonAlter_Table where \
				(PersonAlter_AlterTime > #%d-%d-%d# and PersonAlter_AlterTime < #%d-%d-%d#) or \
				(PersonAlter_AlterTime = #%d-%d-%d# and PersonAlter_AlterTime < #%d-%d-%d#) or \
				(PersonAlter_AlterTime = #%d-%d-%d# and PersonAlter_AlterTime = #%d-%d-%d#) or \
				(PersonAlter_AlterTime > #%d-%d-%d# and PersonAlter_AlterTime = #%d-%d-%d#)", 
				wFrom[0], wFrom[1], wFrom[2], wTo[0], wTo[1], wTo[2],
				wFrom[0], wFrom[1], wFrom[2], wTo[0], wTo[1], wTo[2],
				wFrom[0], wFrom[1], wFrom[2], wTo[0], wTo[1], wTo[2],
				wFrom[0], wFrom[1], wFrom[2], wTo[0], wTo[1], wTo[2]);
	ADOdbo.OpenRecordset(SQL);
	ADOdbo.ShowADOView(strFields, 13, this);
	ADOdbo.CloseRecorset();	
}

/*********************************************************************
函数说明:	  查看全部
函数参数:	  
*********************************************************************/
void Menu_AlterInfoFlower::OnAlfBtnQueryall() 
{
	GetAlterInfoFromDB();
}