kaochaview.cpp

一套人事管理系统

		db.Open("sam人事管理");
		CRecordset rs(&db);
		rs.Open(CRecordset::forwardOnly,"select * from 人事变动 where ID='"+strID+"' ");
		if(BDflag==0)
		{
			m_LISTBD.InsertColumn(0,"姓名|ID",LVCFMT_LEFT,60,4);
			m_LISTBD.InsertColumn(1,"变动类型",LVCFMT_LEFT,65,4);
			m_LISTBD.InsertColumn(2,"原部门",LVCFMT_LEFT,70,4);
			m_LISTBD.InsertColumn(3,"现部门",LVCFMT_LEFT,70,4);
			m_LISTBD.InsertColumn(4,"变动日期",LVCFMT_LEFT,90,4);
			m_LISTBD.InsertColumn(5,"原职务",LVCFMT_LEFT,80,4);
			m_LISTBD.InsertColumn(6,"新职务",LVCFMT_LEFT,80,4);
			m_LISTBD.InsertColumn(7,"生效日期",LVCFMT_LEFT,90,4);
			m_LISTBD.InsertColumn(8,"变动原因",LVCFMT_LEFT,80,4);
			BDflag=1;
		}
		if(rs.IsEOF())
		{
			m_LISTBD.InsertItem(0,"无记录");
		}
		while(!rs.IsEOF())
		{
			m_LISTBD.InsertItem(0,strNAMEID);
			
			rs.GetFieldValue("BDLX",strTMP);
			m_LISTBD.SetItemText(0,1,strTMP);
			
			rs.GetFieldValue("YBM",strTMP);
			m_LISTBD.SetItemText(0,2,strTMP);
			
			rs.GetFieldValue("XBM",strTMP);
			m_LISTBD.SetItemText(0,3,strTMP);
			
			rs.GetFieldValue("BDRQ",strTMP);
			m_LISTBD.SetItemText(0,4,strTMP);
			
			rs.GetFieldValue("YZHW",strTMP);
			m_LISTBD.SetItemText(0,5,strTMP);
			
			rs.GetFieldValue("XZHW",strTMP);
			m_LISTBD.SetItemText(0,6,strTMP);
			
			rs.GetFieldValue("SXRQ",strTMP);
			m_LISTBD.SetItemText(0,7,strTMP);
			
			rs.GetFieldValue("BDYY",strTMP);
			m_LISTBD.SetItemText(0,8,strTMP);
			
			rs.MoveNext();
			
		}
		rs.Close();
		db.Close();
	}
	else
	{
		if(BDflag==0)
		{
			m_LISTBD.InsertColumn(0,"姓名|ID",LVCFMT_LEFT,60,4);
			m_LISTBD.InsertColumn(1,"变动类型",LVCFMT_LEFT,65,4);
			m_LISTBD.InsertColumn(2,"原部门",LVCFMT_LEFT,70,4);
			m_LISTBD.InsertColumn(3,"现部门",LVCFMT_LEFT,70,4);
			m_LISTBD.InsertColumn(4,"变动日期",LVCFMT_LEFT,90,4);
			m_LISTBD.InsertColumn(5,"原职务",LVCFMT_LEFT,80,4);
			m_LISTBD.InsertColumn(6,"新职务",LVCFMT_LEFT,80,4);
			m_LISTBD.InsertColumn(7,"生效日期",LVCFMT_LEFT,90,4);
			m_LISTBD.InsertColumn(8,"变动原因",LVCFMT_LEFT,80,4);
			BDflag=1;
		}
		m_LISTBD.DeleteAllItems();
		CString strIDtmp,strTMP;
		CDatabase dbBM,dbKQ;
		dbBM.Open("sam人事管理");
		dbKQ.Open("sam人事管理");
		CRecordset rsBM(&dbBM);
		CRecordset rsKQ(&dbKQ);
		rsBM.Open(CRecordset::forwardOnly,"select ID from 员工 where DEPARTMENT='"+strNAMEID+"' ");
		while(!rsBM.IsEOF())
		{
			rsBM.GetFieldValue("ID",strIDtmp);
			rsKQ.Open(CRecordset::forwardOnly,"select * from 人事变动 where ID='"+strIDtmp+"' ");
			while(!rsKQ.IsEOF())
			{
				m_LISTBD.InsertItem(0,strIDtmp);
				
				rsKQ.GetFieldValue("BDLX",strTMP);
				m_LISTBD.SetItemText(0,1,strTMP);
				
				rsKQ.GetFieldValue("YBM",strTMP);
				m_LISTBD.SetItemText(0,2,strTMP);
				
				rsKQ.GetFieldValue("XBM",strTMP);
				m_LISTBD.SetItemText(0,3,strTMP);
				
				rsKQ.GetFieldValue("BDRQ",strTMP);
				m_LISTBD.SetItemText(0,4,strTMP);
				
				rsKQ.GetFieldValue("YZHW",strTMP);
				m_LISTBD.SetItemText(0,5,strTMP);
				
				rsKQ.GetFieldValue("XZHW",strTMP);
				m_LISTBD.SetItemText(0,6,strTMP);
				
				rsKQ.GetFieldValue("SXRQ",strTMP);
				m_LISTBD.SetItemText(0,7,strTMP);
				
				rsKQ.GetFieldValue("BDYY",strTMP);
				m_LISTBD.SetItemText(0,8,strTMP);
				
				rsKQ.MoveNext();
			}
			rsKQ.Close();
			rsBM.MoveNext();
		}
		rsBM.Close();
	}
	
}

int JCflag=0;
void CKAOCHAVIEW::InitListJC(int iflag, CString strNAMEID)
{
	if(iflag==0)
	{
		m_LISTJC.DeleteAllItems();
		
		CString strID,strTMP;
		strTMP=strNAMEID;
		int i=strTMP.Find('|');
		strID=strTMP.Mid(i+1);
		CDatabase db;
		db.Open("sam人事管理");
		CRecordset rs(&db);
		rs.Open(CRecordset::forwardOnly,"select * from 奖惩信息 where ID='"+strID+"' ");
		if(JCflag==0)
		{
			m_LISTJC.InsertColumn(0,"姓名|ID",LVCFMT_LEFT,60,4);
			m_LISTJC.InsertColumn(1,"奖惩类型",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(2,"批准部门",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(3,"批准人ID",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(4,"批准日期",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(5,"生效日期",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(6,"撤销日期",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(7,"撤销部门",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(8,"奖惩原因",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(9,"撤销原因",LVCFMT_LEFT,65,4);
			JCflag=1;
		}
		if(rs.IsEOF())
		{
			m_LISTJC.InsertItem(0,"无记录");
		}
		while(!rs.IsEOF())
		{
			m_LISTJC.InsertItem(0,strNAMEID);
			
			rs.GetFieldValue("JCLX",strTMP);
			m_LISTJC.SetItemText(0,1,strTMP);
			
			rs.GetFieldValue("PZBM",strTMP);
			m_LISTJC.SetItemText(0,2,strTMP);
			
			rs.GetFieldValue("PZRID",strTMP);
			m_LISTJC.SetItemText(0,3,strTMP);
			
			rs.GetFieldValue("PZRQ",strTMP);
			m_LISTJC.SetItemText(0,4,strTMP);
			
			rs.GetFieldValue("SXRQ",strTMP);
			m_LISTJC.SetItemText(0,5,strTMP);
			
			rs.GetFieldValue("CXRQ",strTMP);
			m_LISTJC.SetItemText(0,6,strTMP);
			
			rs.GetFieldValue("CXBM",strTMP);
			m_LISTJC.SetItemText(0,7,strTMP);
			
			rs.GetFieldValue("JCYY",strTMP);
			m_LISTJC.SetItemText(0,8,strTMP);
			
			rs.GetFieldValue("CXYY",strTMP);
			m_LISTJC.SetItemText(0,9,strTMP);
			
			
			rs.MoveNext();
			
		}
		rs.Close();
		db.Close();
	}
	else
	{
		if(JCflag==0)
		{
			m_LISTJC.InsertColumn(0,"姓名|ID",LVCFMT_LEFT,60,4);
			m_LISTJC.InsertColumn(1,"奖惩类型",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(2,"批准部门",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(3,"批准人ID",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(4,"批准日期",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(5,"生效日期",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(6,"撤销日期",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(7,"撤销部门",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(8,"奖惩原因",LVCFMT_LEFT,65,4);
			m_LISTJC.InsertColumn(9,"撤销原因",LVCFMT_LEFT,65,4);
			JCflag=1;
		}
		m_LISTJC.DeleteAllItems();
		CString strIDtmp,strTMP;
		CDatabase dbBM,dbKQ;
		dbBM.Open("sam人事管理");
		dbKQ.Open("sam人事管理");
		CRecordset rsBM(&dbBM);
		CRecordset rsKQ(&dbKQ);
		rsBM.Open(CRecordset::forwardOnly,"select ID from 员工 where DEPARTMENT='"+strNAMEID+"' ");
		while(!rsBM.IsEOF())
		{
			rsBM.GetFieldValue("ID",strIDtmp);
			rsKQ.Open(CRecordset::forwardOnly,"select * from 奖惩信息 where ID='"+strIDtmp+"' ");
			while(!rsKQ.IsEOF())
			{
				m_LISTJC.InsertItem(0,strIDtmp);
				
				rsKQ.GetFieldValue("JCLX",strTMP);
				m_LISTJC.SetItemText(0,1,strTMP);
				
				rsKQ.GetFieldValue("PZBM",strTMP);
				m_LISTJC.SetItemText(0,2,strTMP);
				
				rsKQ.GetFieldValue("PZRID",strTMP);
				m_LISTJC.SetItemText(0,3,strTMP);
				
				rsKQ.GetFieldValue("PZRQ",strTMP);
				m_LISTJC.SetItemText(0,4,strTMP);
				
				rsKQ.GetFieldValue("SXRQ",strTMP);
				m_LISTJC.SetItemText(0,5,strTMP);
				
				rsKQ.GetFieldValue("CXRQ",strTMP);
				m_LISTJC.SetItemText(0,6,strTMP);
				
				rsKQ.GetFieldValue("CXBM",strTMP);
				m_LISTJC.SetItemText(0,7,strTMP);
				
				rsKQ.GetFieldValue("JCYY",strTMP);
				m_LISTJC.SetItemText(0,8,strTMP);
				
				rsKQ.GetFieldValue("CXYY",strTMP);
				m_LISTJC.SetItemText(0,9,strTMP);
				
				rsKQ.MoveNext();
			}
			rsKQ.Close();
			rsBM.MoveNext();
		}
		rsBM.Close();
	}
	
}

void CKAOCHAVIEW::OnRclickListcq(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
/*	POINT point;
	GetCursorPos(&point);
	CMenu menu;
	menu.LoadMenu(IDR_KQDELETE);
	menu.GetSubMenu(0)->TrackPopupMenu(TPM_LEFTALIGN|TPM_RIGHTBUTTON,point.x,point.y,this);
*/	*pResult = 0;
}

void CKAOCHAVIEW::OnRclickListbd(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
/*	POINT point;
	GetCursorPos(&point);
	CMenu menu;
	menu.LoadMenu(IDR_KQDELETE);
	menu.GetSubMenu(0)->TrackPopupMenu(TPM_LEFTALIGN|TPM_RIGHTBUTTON,point.x,point.y,this);
*/	*pResult = 0;
}

void CKAOCHAVIEW::OnRclickListjc(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
/*		int i=m_LISTJC.GetSelectionMark();
	CString strID;
	strID=m_LISTJC.GetItemText(i,0);


	POINT point;
	GetCursorPos(&point);
	CMenu menu;
	menu.LoadMenu(IDR_CXJC);
	menu.GetSubMenu(0)->TrackPopupMenu(TPM_LEFTALIGN|TPM_RIGHTBUTTON,point.x,point.y,this);
*/	*pResult = 0;
}