menul_showdelflowerdlg.cpp

VC++和ACCESS使用ADO连接

			{
				m_strTimeCondition.Format("(Demission_Property = '农民工自动辞职' and Demission_IsFinished = '未完清' and \
											Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#) or \
										   (Demission_Property = '农民工除名'  and Demission_IsFinished = '未完清' and \
											Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#)",
										wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2], 
										wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);
			}
			else	// 选项【忽略此条件】
			{
				m_strTimeCondition.Format("(Demission_Property = '农民工自动辞职' and \
											Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#) or \
										   (Demission_Property = '农民工除名' and \
											Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#)",
										wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2], 
										wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);
			}
		}
		else if (strProperty == "所有辞职人员")
		{
			if (strIsOver == "已完清")
			{
				m_strTimeCondition.Format("Demission_Property <> ' ' and Demission_IsFinished = '已完清' and \
					Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#",
					wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);
			}
			else if (strIsOver == "未完清")
			{
				m_strTimeCondition.Format("Demission_Property <> ' ' and Demission_IsFinished = '未完清' and \
					Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#",
					wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);
			}
			else	// 选项【忽略此条件】
			{
				m_strTimeCondition.Format("Demission_Property <> ' ' and \
					Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#",
					wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);	
			}
		}
		else
		{			
			if (strIsOver == "已完清")
			{
				m_strTimeCondition.Format("Demission_Property = '%s' and Demission_IsFinished = '已完清' and \
					Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#",
					strProperty, wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);
			}
			else if (strIsOver == "未完清")
			{
				m_strTimeCondition.Format("Demission_Property = '%s' and Demission_IsFinished = '未完清' and \
					Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#",
					strProperty, wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);
			}
			else	// 选项【忽略此条件】
			{
				m_strTimeCondition.Format("Demission_Property = '%s' and \
					(Demission_Leavetime > #%d-%d-%d# and Demission_Leavetime < #%d-%d-%d#)",
					strProperty, wStart[0], wStart[1], wStart[2], wFinish[0], wFinish[1], wFinish[2]);	
			}
		}		
	}
	else	// 未选中时间段查询
	{		
		if (strProperty == "所有在职辞职")
		{
			m_strProCondition.Format("Demission_Property = '%s' or Demission_Property = '%s'",
				"在职自动辞职", "在职除名");
		}
		else if (strProperty == "所有农民工辞职")
		{
			m_strProCondition.Format("Demission_Property = '%s' or Demission_Property = '%s'",
				"农民工自动辞职", "农民工除名");
		}
		else if (strProperty == "所有辞职人员")
		{
			m_strProCondition.Format("Demission_Property <> ' '");
		}
		else
		{
			m_strProCondition.Format("Demission_Property = '%s'", strProperty);
		}
	}

	return TRUE;
}

/*********************************************************************
函数说明:	  有时间限制查询
函数参数:	  
*********************************************************************/
void MenuL_ShowDelFlowerDlg::QueryWithTimeLimit()
{
	CADOOperation ADOdbo;
	CString SQL;
	SQL.Format("select * from Demission_EmployeeInfo_Table where %s", m_strTimeCondition);
	ADOdbo.OpenRecordset(SQL);

	CString strFields[] = {"Demission_B_Name", "Demission_B_IDCard", "Demission_B_Sex", "Demission_B_Age", 
						   "Demission_I_Company", "Demission_I_Depart", "Demission_B_JobPosition", 
						   "Demission_B_TechPost", "Demission_I_Duty", "Demission_B_JoinTime",
						   "Demission_B_FirstJobTime", "Demission_Leavetime",
						   "Demission_IsFinished", "Demission_Property"};
	ADOdbo.ShowADOView(strFields, 14, this);
	ADOdbo.CloseRecorset();
}

/*********************************************************************
函数说明:	  无时间限制查询
函数参数:	  
*********************************************************************/
void MenuL_ShowDelFlowerDlg::QueryWithoutTime()
{	
	CADOOperation ADOdbo;
	CString SQL;
	SQL.Format("select * from Demission_EmployeeInfo_Table where %s", m_strProCondition);
	ADOdbo.OpenRecordset(SQL);
	
	CString strFields[] = {"Demission_B_Name", "Demission_B_IDCard", "Demission_B_Sex", "Demission_B_Age", 
						   "Demission_I_Company", "Demission_I_Depart", "Demission_B_JobPosition", 
						   "Demission_B_TechPost", "Demission_I_Duty", "Demission_B_JoinTime",
						   "Demission_B_FirstJobTime", "Demission_Leavetime",
						   "Demission_IsFinished", "Demission_Property"};
	ADOdbo.ShowADOView(strFields, 14, this);
	ADOdbo.CloseRecorset();
}

/*********************************************************************
函数说明:	  检查时间是否正确
函数参数:	  
*********************************************************************/
BOOL MenuL_ShowDelFlowerDlg::IsTimeCorrect(CString strBeg, CString strEnd)
{
	WORD wBeg[3];
	WORD wEnd[3];
	CFuncOper FunOper;
	FunOper.strTimeTowTime(strBeg, wBeg);
	FunOper.strTimeTowTime(strEnd, wEnd);
	
	if ((wBeg[0] > wEnd[0]) ||
		(wBeg[0] == wEnd[0] && wBeg[1] >  wEnd[1]) ||
		(wBeg[0] == wEnd[0] && wBeg[1] == wEnd[1] && wBeg[2] > wEnd[2]) ||
		(wBeg[0] == wEnd[0] && wBeg[1] == wEnd[1] && wBeg[2] == wEnd[2]))
	{
		return FALSE;
	}

	return TRUE;
}

/*********************************************************************
函数说明:	  [按钮] 查询
函数参数:	  
*********************************************************************/
void MenuL_ShowDelFlowerDlg::OnMenulDCheckbox() 
{
	if (!m_CBtn_CheckTimeLimit.GetCheck())
	{
		IDStateControl(FALSE);		
	}
	else
	{
		IDStateControl(TRUE);		
	}	
}

/*********************************************************************
函数说明:	  状态控制
函数参数:	  
*********************************************************************/
void MenuL_ShowDelFlowerDlg::IDStateControl(BOOL bState)
{
	GetDlgItem(IDC_MENUL_D_DTP_START)->EnableWindow(bState);
	GetDlgItem(IDC_MENUL_D_DTP_END)->EnableWindow(bState);
	GetDlgItem(IDC_MENUL_D_CMB_ISOVER)->EnableWindow(bState);

	GetDlgItem(IDC_MENUL_D_STATIC_TITLE)->EnableWindow(bState);
	GetDlgItem(IDC_MENUL_D_STATIC_START)->EnableWindow(bState);
	GetDlgItem(IDC_MENUL_D_STATIC_END)->EnableWindow(bState);
	GetDlgItem(IDC_MENUL_D_STATIC_ISOVER)->EnableWindow(bState);
}

int g_nDemIndex = -1;
DemissionInfoDlg DemissionDlg2;
/*********************************************************************
函数说明:	  详细信息
函数参数:	  
*********************************************************************/
void MenuL_ShowDelFlowerDlg::OnMenulDBtnMoreinfo() 
{
	if (g_nDemIndex < 0)
	{
		MessageBox("请选择一个要查看的项\t", "提示", MB_OK | MB_ICONEXCLAMATION);
		return;
	}

	DemissionDlg2.m_bFlowerToShow = TRUE;
	DemissionDlg2.m_bModifyNotFirst = TRUE;
	DemissionDlg2.m_strIDCard = m_IDCard;
	DemissionDlg2.DoModal();
}

/*********************************************************************
函数说明:	  单击
函数参数:	  
*********************************************************************/
void MenuL_ShowDelFlowerDlg::OnClickMenulDList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	LPNMLISTVIEW lpnmlv = (LPNMLISTVIEW)pNMHDR;
	g_nDemIndex = lpnmlv->iItem;
	
	m_IDCard = m_MenuL_D_List.GetItemText(lpnmlv->iItem, 1);		
	*pResult = 0;
}