kaoqinview.cpp

一套人事管理系统

// KAOQINVIEW.cpp : implementation file
//

#include "stdafx.h"
#include "zhurui_jk02_人事管理.h"
#include "KAOQINVIEW.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKAOQINVIEW
CString YGID;
IMPLEMENT_DYNCREATE(CKAOQINVIEW, CRecordView)

CKAOQINVIEW::CKAOQINVIEW()
	: CRecordView(CKAOQINVIEW::IDD)
{
	//{{AFX_DATA_INIT(CKAOQINVIEW)
	m_pSet = NULL;
	m_BDYY = _T("");
	m_DEPARTMENT = _T("");
	m_EDULEVEL = _T("");
	m_JCYY = _T("");
	m_JOB = _T("");
	m_NAMEID = _T("");
	m_SEX = _T("");
	m_YBM = _T("");
	m_YZHW = _T("");
	m_CXYY = _T("");
	//}}AFX_DATA_INIT
}

CKAOQINVIEW::~CKAOQINVIEW()
{
	if (m_pSet)
		delete m_pSet;
}

void CKAOQINVIEW::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKAOQINVIEW)
	DDX_Control(pDX, IDC_DATE_BDSX, m_ctrBDSX);
	DDX_Control(pDX, IDC_MEMBER_TREE, m_TREE_GROUP);
	DDX_Control(pDX, IDC_DATET_PZRQ, m_ctrPZRQ);
	DDX_Control(pDX, IDC_DATE_QSRQ, m_ctrQSRQ);
	DDX_Control(pDX, IDC_DATE_KQRQ, m_ctrKQRQ);
	DDX_Control(pDX, IDC_DATE_JSRQ, m_ctrJSRQ);
	DDX_Control(pDX, IDC_DATE_JCSX, m_ctrJCSX);
	DDX_Control(pDX, IDC_DATE_JCCX, m_ctrJCCX);
	DDX_Control(pDX, IDC_DATE_BDRQ, m_ctrBDRQ);
	DDX_Control(pDX, IDC_COMBO_XZHW, m_ctrXZHW);
	DDX_Control(pDX, IDC_COMBO_XBM, m_ctrXBM);
	DDX_Control(pDX, IDC_COMBO_PZRID, m_ctrPZRID);
	DDX_Control(pDX, IDC_COMBO_PZBM, m_ctrPZBM);
	DDX_Control(pDX, IDC_COMBO_KQLB, m_ctrKQLB);
	DDX_Control(pDX, IDC_COMBO_JCLX, m_ctrJCLX);
	DDX_Control(pDX, IDC_COMBO_CXBM, m_ctrCXBM);
	DDX_Control(pDX, IDC_COMBO_BDLX, m_ctrBDLX);
	DDX_Text(pDX, IDC_EDIT_BDYY, m_BDYY);
	DDX_Text(pDX, IDC_EDIT_DEPARTMENT, m_DEPARTMENT);
	DDX_Text(pDX, IDC_EDIT_EDULEVEL, m_EDULEVEL);
	DDX_Text(pDX, IDC_EDIT_JCYY, m_JCYY);
	DDX_Text(pDX, IDC_EDIT_JOB, m_JOB);
	DDX_Text(pDX, IDC_EDIT_NAMEID, m_NAMEID);
	DDX_Text(pDX, IDC_EDIT_SEX, m_SEX);
	DDX_Text(pDX, IDC_EDIT_YBM, m_YBM);
	DDX_Text(pDX, IDC_EDIT_YZHW, m_YZHW);
	DDX_Text(pDX, IDC_EDIT_CXYY, m_CXYY);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKAOQINVIEW, CRecordView)
	//{{AFX_MSG_MAP(CKAOQINVIEW)
	ON_WM_CTLCOLOR()
	ON_NOTIFY(TVN_SELCHANGED, IDC_MEMBER_TREE, OnSelchangedMemberTree)
	ON_CBN_SELCHANGE(IDC_COMBO_KQLB, OnSelchangeComboKqlb)
	ON_BN_CLICKED(IDC_KQOK, OnKqok)
	ON_BN_CLICKED(IDC_JCOK, OnJcok)
	ON_BN_CLICKED(IDC_BDOK, OnBdok)
	ON_EN_CHANGE(IDC_EDIT_NAMEID, OnChangeEditNameid)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKAOQINVIEW diagnostics

#ifdef _DEBUG
void CKAOQINVIEW::AssertValid() const
{
	CRecordView::AssertValid();
}

void CKAOQINVIEW::Dump(CDumpContext& dc) const
{
	CRecordView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CKAOQINVIEW message handlers

CRecordset* CKAOQINVIEW::OnGetRecordset()
{
	if (m_pSet != NULL)
		return m_pSet;

	m_pSet = new CKAOQINSET(NULL);
	m_pSet->Open();

	return m_pSet;
}

CKAOQINSET* CKAOQINVIEW::GetRecordset()
{
	CKAOQINSET* pData = (CKAOQINSET*) OnGetRecordset();
	ASSERT(pData == NULL || pData->IsKindOf(RUNTIME_CLASS(CKAOQINSET)));
	return pData;
}

void CKAOQINVIEW::OnInitialUpdate()
{
	BeginWaitCursor();
	GetRecordset();
	CRecordView::OnInitialUpdate();
	if (m_pSet->IsOpen())
	{
		CString strTitle = m_pSet->m_pDatabase->GetDatabaseName();
		CString strTable = m_pSet->GetTableName();
		if (!strTable.IsEmpty())
			strTitle += _T(":") + strTable;
		GetDocument()->SetTitle(strTitle);
	}
	EndWaitCursor();
	//
	m_TREE_GROUP.SetBkColor(RGB(0,0,0));
	m_TREE_GROUP.SetTextColor(RGB(0,255,255));
	CDatabase dbtmp0,dbtmp1;
	dbtmp0.Open("sam人事管理");
	dbtmp1.Open("sam人事管理");
	CRecordset rstmp0(&dbtmp0);
	CRecordset rstmp1(&dbtmp1);
	CString strtmp,str1,str2;
	rstmp0.Open(CRecordset::forwardOnly,"select NAME from 部门");
	HTREEITEM root0=m_TREE_GROUP.InsertItem("所有员工",0,1,TVI_ROOT,TVI_LAST);
	while(!rstmp0.IsEOF())
	{
		rstmp0.GetFieldValue("NAME",strtmp);
		strtmp.TrimRight();
		HTREEITEM leaf0=m_TREE_GROUP.InsertItem(strtmp,0,1,root0,TVI_LAST);
		rstmp1.Open(CRecordset::forwardOnly,"select NAME,ID from 员工 where DEPARTMENT='"+strtmp+"'");
		while(!rstmp1.IsEOF())
		{
			rstmp1.GetFieldValue("NAME",str1);
			rstmp1.GetFieldValue("ID",str2);
			str1.TrimRight();
			str2.TrimRight();
			strtmp.Format("%s|%s",str1,str2);
			m_TREE_GROUP.InsertItem(strtmp,0,1,leaf0,TVI_LAST);
			rstmp1.MoveNext();
		}
		rstmp1.Close();
		
		
		rstmp0.MoveNext();
	}
	rstmp0.Close();
	dbtmp0.Close();
	dbtmp1.Close();

	dbtmp0.Open("sam人事管理");
	rstmp0.Open(CRecordset::forwardOnly,"select * from 人事变更类型");
	CString str0;
	while(!rstmp0.IsEOF())
	{
		rstmp0.GetFieldValue("SHUOMING",str0);
		str0.TrimRight();
		m_ctrBDLX.AddString(str0);
		rstmp0.MoveNext();
	}
//	m_ctrBDLX.SetCurSel(0);
	rstmp0.Close();
	dbtmp0.Close();

	dbtmp0.Open("sam人事管理");//初始化部门
	rstmp0.Open(CRecordset::forwardOnly,"select * from 部门");
	while(!rstmp0.IsEOF())
	{
		rstmp0.GetFieldValue("NAME",str0);
		str0.TrimRight();
		m_ctrXBM.AddString(str0);
		m_ctrPZBM.AddString(str0);
		m_ctrCXBM.AddString(str0);
		rstmp0.MoveNext();
	}
//	m_ctrXBM.SetCurSel(0);
//	m_ctrPZBM.SetCurSel(0);
//	m_ctrCXBM.SetCurSel(0);
	rstmp0.Close();
	dbtmp0.Close();

	dbtmp0.Open("sam人事管理");//初始化批准人ID
	rstmp0.Open(CRecordset::forwardOnly,"select * from 员工");
	while(!rstmp0.IsEOF())
	{
		rstmp0.GetFieldValue("ID",str0);
		rstmp0.GetFieldValue("NAME",str1);
		str0.TrimRight();
		str1.TrimRight();
		str0.Format("%s-%s",str0,str1);
		m_ctrPZRID.AddString(str0);
		rstmp0.MoveNext();
	}
	rstmp0.Close();
	dbtmp0.Close();

	dbtmp0.Open("sam人事管理");//初始化职务
	rstmp0.Open(CRecordset::forwardOnly,"select * from 职务");
	while(!rstmp0.IsEOF())
	{
		rstmp0.GetFieldValue("SHUOMING",str0);
		str0.TrimRight();
		m_ctrXZHW.AddString(str0);
		rstmp0.MoveNext();
	}
//	m_ctrXZHW.SetCurSel(0);
	rstmp0.Close();
	dbtmp0.Close();

	dbtmp0.Open("sam人事管理");//初始化奖惩类型
	rstmp0.Open(CRecordset::forwardOnly,"select * from 奖惩类型");
	while(!rstmp0.IsEOF())
	{
		rstmp0.GetFieldValue("JCLX",str0);
		str0.TrimRight();
		m_ctrJCLX.AddString(str0);
		rstmp0.MoveNext();
	}
//	m_ctrJCLX.SetCurSel(0);
	rstmp0.Close();
	dbtmp0.Close();

	m_ctrQSRQ.EnableWindow(FALSE);
	m_ctrJSRQ.EnableWindow(FALSE);

	m_btn1.AutoLoad(IDC_KQOK,this);
	m_btn2.AutoLoad(IDC_BDOK,this);
	m_btn3.AutoLoad(IDC_JCOK,this);
	m_btn1.m_pbtn=(CSAMBTN*)this->GetDlgItem(IDC_KQOK);
	m_btn2.m_pbtn=(CSAMBTN*)this->GetDlgItem(IDC_BDOK);
	m_btn3.m_pbtn=(CSAMBTN*)this->GetDlgItem(IDC_JCOK);

}

HBRUSH CKAOQINVIEW::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{	
	HBRUSH hbr = CRecordView::OnCtlColor(pDC, pWnd, nCtlColor);
	if(nCtlColor   ==   CTLCOLOR_DLG)   
	{   
        //返回对话框的颜色   
		hbr=(HBRUSH)::CreateSolidBrush(RGB(0,255,255));     
	}  
	
	HBRUSH hbr0=(HBRUSH)::GetStockObject(NULL_BRUSH); 
	if(nCtlColor==CTLCOLOR_STATIC)   
	{   
		//让静态文本框透明   
		pDC->SetBkMode(TRANSPARENT);   
		pDC->SetTextColor(RGB(0,255,255));   //设置字体颜色天蓝色   
		HBRUSH hbr0=(HBRUSH)::GetStockObject(NULL_BRUSH);  
		return hbr0 ;
	}
	if(nCtlColor==CTLCOLOR_EDIT)   
	{   
		//让静态文本框不透明   
		pDC->SetBkMode(2);   
		pDC->SetBkColor(RGB(0,0,0));
		pDC->SetTextColor(RGB(0,255,255));   //设置字体颜色天蓝色   
		HBRUSH hbr0=(HBRUSH)::GetStockObject(NULL_BRUSH);  
		return hbr0 ;
	}   
	return hbr;
}

void CKAOQINVIEW::OnSelchangedMemberTree(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	HTREEITEM hsel=m_TREE_GROUP.GetSelectedItem();//得到当前鼠标选择的项目
	YGID=m_TREE_GROUP.GetItemText(hsel);//得到鼠标选中项的字符串
    int i=m_TREE_GROUP.ItemHasChildren(hsel);//判断hsel项是否有子项,i==0表示没有子项
	if(i==0)
	{
		YGID.TrimRight();
		InitGroup(YGID);
		UpdateData(FALSE);
	}
	
	*pResult = 0;
}
CString strID,strNAME,strSEX;
void CKAOQINVIEW::InitGroup(CString str)
{
	CString strtmp=str;
	int i=str.Find('|')+1;
	str=str.Mid(i);
	CDatabase db;
	db.Open("sam人事管理");
	CRecordset rs(&db);
	rs.Open(CRecordset::forwardOnly,"select * from 员工 where ID ='"+str+"' ");
	if(!rs.IsEOF())
	{
		m_NAMEID=strtmp;
		rs.GetFieldValue("SEX",m_SEX);
		rs.GetFieldValue("DEPARTMENT",m_DEPARTMENT);
		rs.GetFieldValue("JOB",m_JOB);
		rs.GetFieldValue("EDU_LEVEL",m_EDULEVEL);
		m_YBM=m_DEPARTMENT;
		m_YZHW=m_JOB;
		strID=str;
		strSEX=m_SEX;
	}
	UpdateData(FALSE);
	rs.Close();
	db.Close();

}

void CKAOQINVIEW::OnSelchangeComboKqlb() 
{
	// TODO: Add your control notification handler code here
	CString strtmp;
	m_ctrKQLB.GetWindowText(strtmp);
	strtmp.TrimRight();
	if(strtmp=="出差"||strtmp=="遇事请假")
	{
		m_ctrQSRQ.EnableWindow(TRUE);
		m_ctrJSRQ.EnableWindow(TRUE);
	}
	else
	{
		m_ctrQSRQ.EnableWindow(FALSE);
		m_ctrJSRQ.EnableWindow(FALSE);
	}
}

void CKAOQINVIEW::OnKqok() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CString m_QSRQ,m_JSRQ;
	CDatabase db;
	db.Open("sam人事管理");
	CString strSQL;
	if(strID!="")
	{
		CString strKQRQ,strKQLB,strQSSJ,strJSSJ;
		m_ctrKQRQ.GetWindowText(strKQRQ);
		m_ctrKQLB.GetWindowText(strKQLB);
		if(strKQLB=="")
		{
			MessageBox("请选择考勤类型！");//
			m_ctrKQLB.SetFocus();
		}
		else
		{
			if(strKQLB=="")
			{
				MessageBox("请选择考勤类别！");// 两处代码重复，脑子有点乱，暂时不改，以免发生错误
			}
			else
			{
				if(strKQLB=="出差")
				{
					m_ctrQSRQ.GetWindowText(m_QSRQ);
					m_ctrJSRQ.GetWindowText(m_JSRQ);
					strSQL=" insert into 考勤(ID,KQRQ,KQLB,CCQSRQ,CCJSRQ) values\
						('"+strID+"','"+strKQRQ+"','"+strKQLB+"','"+m_QSRQ+"','"+m_JSRQ+"' )";
				}else
					if(strKQLB=="遇事请假")
					{
						m_ctrQSRQ.GetWindowText(m_QSRQ);
						m_ctrJSRQ.GetWindowText(m_JSRQ);
						strSQL=" insert into 考勤(ID,KQRQ,KQLB,QJQSRQ,QJJSRQ) values\
							('"+strID+"','"+strKQRQ+"','"+strKQLB+"','"+m_QSRQ+"','"+m_JSRQ+"' )";
					}
					else
					{
					strSQL=" insert into 考勤(ID,KQRQ,KQLB) values\
						('"+strID+"','"+strKQRQ+"','"+strKQLB+"' )";
					}
					db.ExecuteSQL(strSQL);
					AfxMessageBox("考勤记录添加成功！");
			}
					db.Close();
		}
	}
	else
		AfxMessageBox("请选择员工先！");
	
}

void CKAOQINVIEW::OnJcok() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CString m_QSRQ,m_JSRQ;
	CDatabase db;
	db.Open("sam人事管理");
	CRecordset rs(&db);
	CString strSQL;
	if(strID!="")
	{
		CString strJCLX,strPZBM,strPZRID,strPZRQ,strSXRQ,strCXRQ,strCXBM;
		m_ctrJCLX.GetWindowText(strJCLX);
		m_ctrPZBM.GetWindowText(strPZBM);
		m_ctrPZRID.GetWindowText(strPZRID);
		m_ctrCXBM.GetWindowText(strCXBM);
		m_ctrPZRQ.GetWindowText(strPZRQ);
		m_ctrJCSX.GetWindowText(strSXRQ);
		m_ctrJCCX.GetWindowText(strCXRQ);
		if(strJCLX=="")
		{
			AfxMessageBox("请选择奖惩类型！");
			m_ctrBDLX.SetFocus();
		}
		else
			if(strPZBM=="")
			{
				AfxMessageBox("请选择批准部门！");
				m_ctrXBM.SetFocus();
			}
			else
				if(strPZRID=="")
				{
					AfxMessageBox("请选择批准人！");
					m_ctrXZHW.SetFocus();
				}
				else
					if(m_JCYY=="")
					{
						AfxMessageBox("请填写奖惩原因！");
					}
					else
					{
						rs.Open(CRecordset::forwardOnly,"select * from 奖惩信息 where ID='"+strID+"' ");
						strSQL="insert into 奖惩信息 values ('"+strID+"', '"+strJCLX+"','"+strPZBM+"', '"+strPZRID+"', '"+strPZRQ+"', '"+strSXRQ+"',\
							'"+strCXRQ+"', '"+strCXBM+"', '"+m_JCYY+"','"+m_CXYY+"' ) "; 
						rs.Close();
						db.ExecuteSQL(strSQL);
						AfxMessageBox("奖惩记录添加成功！");
					}
					db.Close();					
	}
	else
		AfxMessageBox("请选择员工先！");
	
	
}

void CKAOQINVIEW::OnBdok() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CString m_QSRQ,m_JSRQ;
	CDatabase db;
	db.Open("sam人事管理");
	CRecordset rs(&db);
	CString strSQL;
	if(strID!="")
	{
		CString strBDLX,strXBM,strBDRQ,strXZHW,strSXRQ;
		m_ctrBDLX.GetWindowText(strBDLX);
		m_ctrXBM.GetWindowText(strXBM);
		m_ctrBDRQ.GetWindowText(strBDRQ);
		m_ctrXZHW.GetWindowText(strXZHW);
		m_ctrBDSX.GetWindowText(strSXRQ);
		if(strBDLX=="")
		{
			AfxMessageBox("请选择变动类型！");
			m_ctrBDLX.SetFocus();
		}
		else
			if(strXBM=="")
			{
				AfxMessageBox("请选择新部门！");
				m_ctrXBM.SetFocus();
			}
			else
				if(strXZHW=="")
				{
					AfxMessageBox("请选择新职务！");
					m_ctrXZHW.SetFocus();
				}
				else
				{
					rs.Open(CRecordset::forwardOnly,"select * from 人事变动 where ID='"+strID+"' ");
					if(rs.IsEOF())
					{
					strSQL="insert into 人事变动 values ('"+strID+"', '"+strBDLX+"','"+m_YBM+"', '"+strXBM+"', '"+strBDRQ+"', '"+m_YZHW+"',\
						'"+strXZHW+"', '"+strSXRQ+"', '"+m_BDYY+"') "; 
					rs.Close();
					}
					else
					{
					strSQL="update 人事变动 set\
											 BDLX='"+strBDLX+"',\
											 YBM='"+m_YBM+"',\
											 XBM='"+strXBM+"',\
											 BDRQ='"+strBDRQ+"',\
											 YZHW='"+m_YZHW+"',\
											 XZHW='"+strXZHW+"',\
											 SXRQ='"+strSXRQ+"',\
											 BDYY='"+m_BDYY+"'\
											 where ID='"+strID+"'  ";
					
					
					rs.Close();
					
					}
					db.ExecuteSQL(strSQL);

					strSQL="update 员工 set DEPARTMENT='"+strXBM+"',JOB='"+strXZHW+"' where ID='"+strID+"' ";
					db.ExecuteSQL(strSQL);
					AfxMessageBox("人事变动记录添加成功！");
					db.Close();
				}
	}
	else
		AfxMessageBox("请选择员工先！");	
	
}

void CKAOQINVIEW::OnChangeEditNameid() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the CRecordView::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	// TODO: Add your control notification handler code here
}

void CKAOQINVIEW::InitListBD(int iflag, CString strNAMEID)
{

}