tongji.cpp

用VC++6.0开发的人事信息系统

// tongji.cpp : implementation file
//

#include "stdafx.h"
#include "test.h"
#include "tongji.h"
#include "yonghuSet.h"
#include "shituSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// tongji dialog


tongji::tongji(CWnd* pParent /*=NULL*/)
: CDialog(tongji::IDD, pParent)
{
	//{{AFX_DATA_INIT(tongji)
	m_nTongji = -1;
	//}}AFX_DATA_INIT
	sql="";
}


void tongji::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(tongji)
	DDX_Control(pDX, IDC_COMBO_ZHUANYE, m_nZhuanye);
	DDX_Control(pDX, IDC_COMBO_ZHIWEI, m_nZhiwei);
	DDX_Control(pDX, IDC_COMBO_ZHICHENG, m_nZhicheng);
	DDX_Control(pDX, IDC_COMBO_ZHENGZHI, m_nZhengzhi);
	DDX_Control(pDX, IDC_COMBO_XUELI, m_nXuele);
	DDX_Control(pDX, IDC_COMBO_SEX, m_nSex);
	DDX_Control(pDX, IDC_COMBO_NIANFEN, m_nNianfen);
	DDX_Control(pDX, IDC_COMBO_JIGUAN, m_nJiguan);
	DDX_Control(pDX, IDC_COMBO_HUNYIN, m_nHunyin);
	DDX_Control(pDX, IDC_COMBO_BUMEN, m_nBumen);
	DDX_Radio(pDX, IDC_RADIO_SEX, m_nTongji);
	//}}AFX_DATA_MAP
	CShituSet mSet;
	if(mSet.IsOpen())
		mSet.Close();
	mSet.Open(CRecordset::snapshot,"select * from yonghu");
	for(;!mSet.IsEOF();mSet.MoveNext())
	{
		if(m_nJiguan.FindString(-1,mSet.m_jiguan)==CB_ERR)
			m_nJiguan.AddString(mSet.m_jiguan);
		if(m_nNianfen.FindString(-1,mSet.m_chusheng.Format("%Y"))==CB_ERR)
			m_nNianfen.AddString(mSet.m_chusheng.Format("%Y"));
		if(m_nZhuanye.FindString(-1,mSet.m_zhuanye)==CB_ERR)
			m_nZhuanye.AddString(mSet.m_zhuanye);
		if(m_nBumen.FindString(-1,mSet.m_bumen)==CB_ERR)
			m_nBumen.AddString(mSet.m_bumen);
		if(m_nZhiwei.FindString(-1,mSet.m_zhiwei)==CB_ERR)
			m_nZhiwei.AddString(mSet.m_zhiwei);
		if(m_nZhicheng.FindString(-1,mSet.m_zhichen)==CB_ERR)
			m_nZhicheng.AddString(mSet.m_zhichen);
	}
	mSet.Close();
}


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

/////////////////////////////////////////////////////////////////////////////
// tongji message handlers

void tongji::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CString tmp;
	if(m_nTongji==-1)
	{
		MessageBox("请选择一项项目进行统计!","提示",MB_OK);
		return;
	}
	switch(m_nTongji)
	{
	case 0:if(m_nSex.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nSex.GetLBText(m_nSex.GetCurSel(),tmp);
			sql.Format("select * from yonghu where sex='%s'",tmp);
		}
		break;
	case 1:if(m_nHunyin.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nHunyin.GetLBText(m_nHunyin.GetCurSel(),tmp);
			sql.Format("select * from yonghu where hunyin='%s'",tmp);
		}
		break;
	case 2:if(m_nZhengzhi.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nZhengzhi.GetLBText(m_nZhengzhi.GetCurSel(),tmp);
			sql.Format("select * from yonghu where zhengzhi='%s'",tmp);
		}
		break;
	case 3:if(m_nJiguan.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nJiguan.GetLBText(m_nJiguan.GetCurSel(),tmp);
			sql.Format("select * from yonghu where jiguan='%s'",tmp);
		}
		break;
	case 4:if(m_nNianfen.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nNianfen.GetLBText(m_nNianfen.GetCurSel(),tmp);
			sql.Format("select * from yonghu where chusheng>='%s-01-01' and chusheng<='%s-12-31'",tmp,tmp);
		}
		break;
	case 5:if(m_nZhuanye.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nZhuanye.GetLBText(m_nZhuanye.GetCurSel(),tmp);
			sql.Format("select * from yonghu where zhuanye='%s'",tmp);
		}
		break;
	case 6:if(m_nBumen.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nBumen.GetLBText(m_nBumen.GetCurSel(),tmp);
			sql.Format("select * from yonghu where bumen='%s'",tmp);
		}
		break;
	case 7:if(m_nXuele.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nXuele.GetLBText(m_nXuele.GetCurSel(),tmp);
			sql.Format("select * from yonghu where xueli='%s'",tmp);
		}
		break;
	case 8:if(m_nZhiwei.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nZhiwei.GetLBText(m_nZhiwei.GetCurSel(),tmp);
			sql.Format("select * from yonghu where zhiwei='%s'",tmp);
		}
		break;
	case 9:if(m_nZhicheng.GetCurSel()==CB_ERR) sql.Format("select * from yonghu");
		else {
			m_nZhicheng.GetLBText(m_nZhicheng.GetCurSel(),tmp);
			sql.Format("select * from yonghu where zhichen='%s'",tmp);
		}
		break;
	default:break;
	}
	CDialog::OnOK();
}