yuangong.cpp

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

// yuangong.cpp : implementation file
//

#include "stdafx.h"
#include "test.h"
#include "yuangong.h"
#include "view.h"
#include "bumenSet.h"
#include "yonghuSet.h"
#include "zhichenSet.h"
#include "zhiweiSet.h"
#include "shituSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// yuangong dialog


yuangong::yuangong(CWnd* pParent /*=NULL*/)
: CDialog(yuangong::IDD, pParent)
{
	//{{AFX_DATA_INIT(yuangong)
	m_nGongzi = _T("");
	m_nNumber = _T("");
	m_bumen = -1;
	m_zhiwei = -1;
	m_zhichen = -1;
	m_nName = _T("");
	m_nShenfen = _T("");
	m_nPhone = _T("");
	m_nJianli = _T("");
	m_nGonghao = _T("");
	m_nEmail = _T("");
	m_nDizhi = _T("");
	m_nBiye = _T("");
	m_nBeizhu = _T("");
	m_nHetongzhong = 0;
	m_nRuzhi = 0;
	m_nChusheng = 0;
	m_nHetongqi = 0;
	m_nJG = _T("");
	m_nZY = _T("");
	//}}AFX_DATA_INIT
	name="";
	filename="";
	type=-1;
	hao="";
}


void yuangong::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(yuangong)
	DDX_Control(pDX, IDC_EDIT_NUMBER, m_nNO);
	DDX_Control(pDX, IDC_COMBO_XUELI, m_nXueli);
	DDX_Control(pDX, IDC_COMBO_MINGZHU, m_nMingzhu);
	DDX_Control(pDX, IDC_COMBO_ZHENGZHI, m_nZhengzhi);
	DDX_Control(pDX, IDC_COMBO_HUNYIN, m_nHunyin);
	DDX_Control(pDX, IDC_COMBO_SEX, m_nSex);
	DDX_Control(pDX, IDC_COMBO_ZHIWEI, m_nZhiwei);
	DDX_Control(pDX, IDC_COMBO_ZHICHEN, m_nZhichen);
	DDX_Control(pDX, IDC_COMBO_ZHUANYE, m_nZhuanye);
	DDX_Control(pDX, IDC_COMBO_JIGUAN, m_nJiguan);
	DDX_Control(pDX, IDC_COMBO_BUMEN, m_nBumen);
	DDX_Control(pDX, IDC_TITLE, m_nTitle);
	DDX_Control(pDX, IDC_BUTTON2, m_nDelete);
	DDX_Control(pDX, IDC_BUTTON3, m_nChakan);
	DDX_Control(pDX, IDC_EXPLORER1, m_nWeb);
	DDX_Text(pDX, IDC_EDIT_GONGZI, m_nGongzi);
	DDX_Text(pDX, IDC_EDIT_NUMBER, m_nNumber);
	DDX_CBIndex(pDX, IDC_COMBO_BUMEN, m_bumen);
	DDX_CBIndex(pDX, IDC_COMBO_ZHIWEI, m_zhiwei);
	DDX_CBIndex(pDX, IDC_COMBO_ZHICHEN, m_zhichen);
	DDX_Text(pDX, IDC_EDIT_NAME, m_nName);
	DDX_Text(pDX, IDC_EDIT_SHENFEN, m_nShenfen);
	DDX_Text(pDX, IDC_EDIT_PHONE, m_nPhone);
	DDX_Text(pDX, IDC_EDIT_JIANLI, m_nJianli);
	DDX_Text(pDX, IDC_EDIT_GONGHAO, m_nGonghao);
	DDX_Text(pDX, IDC_EDIT_EMAIL, m_nEmail);
	DDX_Text(pDX, IDC_EDIT_DIZHI, m_nDizhi);
	DDX_Text(pDX, IDC_EDIT_BIYE, m_nBiye);
	DDX_Text(pDX, IDC_EDIT_BEIZHU, m_nBeizhu);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_HETONGZHONG, m_nHetongzhong);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_RUZHI, m_nRuzhi);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1_CHUSHENG, m_nChusheng);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_HETONGQI, m_nHetongqi);
	DDX_CBString(pDX, IDC_COMBO_JIGUAN, m_nJG);
	DDX_CBString(pDX, IDC_COMBO_ZHUANYE, m_nZY);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(yuangong, CDialog)
//{{AFX_MSG_MAP(yuangong)
ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// yuangong message handlers

void yuangong::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CFileDialog dlg(TRUE);
	dlg.m_ofn.lpstrFilter="所有图象文件\0*.gif;*.jpg\0GIF 文件\0*.gif\0JPEG 文件\0*.jpg;*.jpeg\0";
	if(dlg.DoModal()!=IDOK) return;
	
	COleVariant vt(dlg.GetPathName());
	name=dlg.GetPathName();
	filename=dlg.GetFileName();
	
	VARIANT bt;
	m_nWeb.Navigate2(vt,&bt,&bt,&bt,&bt);
	m_nChakan.EnableWindow(TRUE);
	m_nDelete.EnableWindow(TRUE);
}

void yuangong::OnButton2() 
{
	// TODO: Add your control notification handler code here
	
	m_nWeb.GoHome();
	name="";
	m_nChakan.EnableWindow(FALSE);
	m_nDelete.EnableWindow(FALSE);
}

void yuangong::OnButton3() 
{
	// TODO: Add your control notification handler code here
	view dlg1;
	dlg1.filename=name;
	dlg1.DoModal();
}

BOOL yuangong::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_nChakan.EnableWindow(FALSE);
	m_nDelete.EnableWindow(FALSE);
	
	CBumenSet mSet;
	if(mSet.IsOpen())
		mSet.Close();
	mSet.Open(CRecordset::snapshot,"select * from bumen");
	for(;!mSet.IsEOF();mSet.MoveNext())
	{
		m_nBumen.AddString(mSet.m_bumen);
	}
	mSet.Close();
	
	CZhiweiSet mSet1;
	if(mSet1.IsOpen())
		mSet1.Close();
	mSet1.Open(CRecordset::snapshot,"select * from zhiwei");
	for(;!mSet1.IsEOF();mSet1.MoveNext())
	{
		m_nZhiwei.AddString(mSet1.m_zhiwei);
	}
	mSet1.Close();
	
	CZhichenSet mSet2;
	if(mSet2.IsOpen())
		mSet2.Close();
	mSet2.Open(CRecordset::snapshot,"select * from zhichen");
	for(;!mSet2.IsEOF();mSet2.MoveNext())
	{
		m_nZhichen.AddString(mSet2.m_zhichen);
	}
	mSet2.Close();
	
	CShituSet mSet3;
	if(mSet3.IsOpen())
		mSet3.Close();
	mSet3.Open(CRecordset::snapshot,"select * from yonghu");
	for(;!mSet3.IsEOF();mSet3.MoveNext())
	{
		if(m_nJiguan.FindString(-1,mSet3.m_jiguan)==CB_ERR)
			m_nJiguan.AddString(mSet3.m_jiguan);
		if(m_nZhuanye.FindString(-1,mSet3.m_zhuanye)==CB_ERR)
			m_nZhuanye.AddString(mSet3.m_zhuanye);
	}
	mSet3.Close();
	
	if(type==0)
	{
		CString tmp;
		GetWindowText(tmp);
		tmp+="  -员工添加";
		this->SetWindowText(tmp);
		m_nSex.SelectString(-1,"男");
		m_nHunyin.SelectString(-1,"未婚");
		m_nZhengzhi.SelectString(-1,"团员");
		m_nMingzhu.SelectString(-1,"汉");
		m_nJG="江苏";
		m_nXueli.SelectString(-1,"本科");
		m_nZY="软件工程";
		
		m_bumen=0;
		m_zhiwei=0;
		m_zhichen=0;
		m_nNumber="MP";
		m_nGongzi="1500.00";
		
		m_nChusheng=m_nRuzhi=m_nHetongzhong=m_nHetongqi=CTime::GetCurrentTime();
		UpdateData(FALSE);
	}
	
	if(type==1)
	{
		CString tmp;
		GetWindowText(tmp);
		tmp+="  -员工编辑";
		this->SetWindowText(tmp);
		m_nNO.EnableWindow(FALSE);
		
		CShituSet mSet;
		if(mSet.IsOpen())
			mSet.Close();
		mSet.m_strFilter.Format("number='%s'",hao);
		mSet.Open();
		
		m_nNumber=mSet.m_number;
		
		m_nName=mSet.m_name;
		
		m_nSex.SelectString(-1,mSet.m_sex);
		
		m_nChusheng=mSet.m_chusheng;
		
		m_nRuzhi=mSet.m_ruzhi;
		
		m_nHunyin.SelectString(-1,mSet.m_hunyin);
		
		m_nZhengzhi.SelectString(-1,mSet.m_zhengzhi);
		
		m_nMingzhu.SelectString(-1,mSet.m_mingzhu);
		
		m_nJG=mSet.m_jiguan;
		
		m_nXueli.SelectString(-1,mSet.m_xueli);
		
		m_nZY=mSet.m_zhuanye;
		
		m_nBiye=mSet.m_biye;
		
		m_nDizhi=mSet.m_dizhi;
		
		m_nEmail=mSet.m_email;
		
		m_nShenfen=mSet.m_shenfen;
		
		m_nPhone=mSet.m_phone;
		
		m_nGongzi=mSet.m_gongzi;
		
		if(m_nBumen.FindString(-1,mSet.m_bumen)!=CB_ERR)
			m_bumen=m_nBumen.FindString(-1,mSet.m_bumen);
		else m_bumen=0;
		
		if(m_nZhiwei.FindString(-1,mSet.m_zhiwei)!=CB_ERR)
			m_zhiwei=m_nZhiwei.FindString(-1,mSet.m_zhiwei);
		else m_zhiwei=0;

		if(m_nZhichen.FindString(-1,mSet.m_zhichen)!=CB_ERR)
			m_zhichen=m_nZhichen.FindString(-1,mSet.m_zhichen);
		else m_zhichen=0;
		
		m_nGonghao=mSet.m_gonghao;
		
		m_nHetongqi=mSet.m_hetongqi;
		
		m_nHetongzhong=mSet.m_hetongzhong;
		
		m_nJianli=mSet.m_jianli;
		
		m_nBeizhu=mSet.m_beizhu;
		
		name=mSet.m_picture;
		
		mSet.Close();
		UpdateData(FALSE);
		if(name!="")
		{
			COleVariant vt(name);
			VARIANT bt;
			m_nWeb.Navigate2(vt,&bt,&bt,&bt,&bt);
			m_nChakan.EnableWindow(TRUE);
			m_nDelete.EnableWindow(TRUE);
		}
		
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	// EXCEPTION: OCX Property Pages should return FALSE
}

void yuangong::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	if(m_nName=="") 
	{
		MessageBox("员工姓名不能为空!","警告",MB_ICONERROR);
		return;
	}
	
	if(m_nNumber=="")
	{
		MessageBox("员工编号不能为空!","警告",MB_ICONERROR);
		return;
	}
	
	CYonghuSet mSet;
	if(mSet.IsOpen())
		mSet.Close();
	if(type==0)
	{	
		CYonghuSet mSet1;
		if(mSet1.IsOpen())
			mSet1.Close();
		mSet1.m_strFilter.Format("number='%s'",m_nNumber);
		mSet1.Open();
		if(!mSet1.IsEOF())
		{
			MessageBox("已存在相同编号的员工!","提示",MB_ICONASTERISK);
			mSet1.Close();
			return;
		}
		mSet1.Close();
		mSet.Open();
		mSet.AddNew();
		mSet.m_number=m_nNumber;
	}
	
	if(type==1)
	{
		if(MessageBox("请确认是否保存刚才修改的员工信息?\n(请注意，该操作无法恢复!)"
			,"提示",MB_ICONWARNING|MB_OKCANCEL)!=1)
			return;
		mSet.m_strFilter.Format("number='%s'",hao);
		mSet.Open();
		mSet.Edit();
	}
	
	mSet.m_name=m_nName;
	
	CString tmp;
	
	m_nSex.GetLBText(m_nSex.GetCurSel(),tmp);
	mSet.m_sex=tmp;
	
	mSet.m_chusheng=m_nChusheng;
	
	mSet.m_ruzhi=m_nRuzhi;
	
	m_nHunyin.GetLBText(m_nHunyin.GetCurSel(),tmp);
	mSet.m_hunyin=tmp;
	
	m_nZhengzhi.GetLBText(m_nZhengzhi.GetCurSel(),tmp);
	mSet.m_zhengzhi=tmp;
	
	m_nMingzhu.GetLBText(m_nMingzhu.GetCurSel(),tmp);
	mSet.m_mingzhu=tmp;
	
	mSet.m_jiguan=m_nJG;
	
	m_nXueli.GetLBText(m_nXueli.GetCurSel(),tmp);
	mSet.m_xueli=tmp;
	
	mSet.m_zhuanye=m_nZY;
	
	mSet.m_biye=m_nBiye;
	
	mSet.m_dizhi=m_nDizhi;
	
	mSet.m_email=m_nEmail;
	
	mSet.m_shenfen=m_nShenfen;
	
	mSet.m_phone=m_nPhone;
	
	mSet.m_gongzi=m_nGongzi;
	
	//更新无法在员工信息表中更新的数据***************************************
	CBumenSet nSet;
	if(nSet.IsOpen())
		nSet.Close();
	m_nBumen.GetLBText(m_nBumen.GetCurSel(),tmp);
	nSet.m_strFilter.Format("bumen='%s'",tmp);
	nSet.Open();
	mSet.m_bumen.Format("%i",nSet.m_ID);
	nSet.Close();
	
	CZhiweiSet nSet1;
	if(nSet1.IsOpen())
		nSet1.Close();
	m_nZhiwei.GetLBText(m_nZhiwei.GetCurSel(),tmp);
	nSet1.m_strFilter.Format("zhiwei='%s'",tmp);
	nSet1.Open();
	mSet.m_zhiwei.Format("%i",nSet1.m_ID);
	nSet1.Close();
	
	CZhichenSet nSet2;
	if(nSet2.IsOpen())
		nSet2.Close();
	m_nZhichen.GetLBText(m_nZhichen.GetCurSel(),tmp);
	nSet2.m_strFilter.Format("zhichen='%s'",tmp);
	nSet2.Open();
	mSet.m_zhichen.Format("%i",nSet2.m_ID);
	nSet2.Close();
//*******************************************************************
	
	mSet.m_gonghao=m_nGonghao;
	
	mSet.m_hetongqi=m_nHetongqi;
	
	mSet.m_hetongzhong=m_nHetongzhong;
	
	mSet.m_jianli=m_nJianli;
	
	mSet.m_beizhu=m_nBeizhu;
	
	mSet.m_picture=name;
	
	mSet.Update();
	mSet.Close();
	CDialog::OnOK();
}