📄 browsedlg.cpp

📁 人事管理系统源码。很好用的一个程序源码
💻 CPP
📖 第 1 页 / 共 2 页
字号:
上一页 12
	else if(9==m_nCondition)
	{//按文化程度查询
		CEducationSet recordset ;
		strSQL="select * from education";
		if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
		{
			MessageBox("打开数据库失败!","数据库错误",MB_OK);
			return ;
		}	
		while(!recordset.IsEOF())
		{
			m_ctrContent.AddString(recordset.m_education);
			recordset.MoveNext();
		}
		recordset.Close();
	}
	///////////////////////////////////////////////////////////////////
	//设置按钮状态
	m_ctrNewBnt.EnableWindow(TRUE);
	m_ctrDelBnt.EnableWindow(TRUE);
	m_ctrSaveBnt.EnableWindow(FALSE);
	m_ctrCancelBnt.EnableWindow(FALSE);
	m_ctrModify.EnableWindow(TRUE);
	m_bNew = FALSE;
	m_BaseInfoDlg.m_ctrID.EnableWindow(FALSE);
}

void CBrowseDlg::OnSelchangeComboContent() 
{
	// TODO: Add your control notification handler code here
	//设置按钮状态
	m_ctrNewBnt.EnableWindow(TRUE);
	m_ctrDelBnt.EnableWindow(TRUE);
	m_ctrSaveBnt.EnableWindow(FALSE);
	m_ctrCancelBnt.EnableWindow(FALSE);
	m_ctrModify.EnableWindow(TRUE);
	m_bNew = FALSE;
	m_BaseInfoDlg.m_ctrID.EnableWindow(FALSE);
}



void CBrowseDlg::OnEditupdateComboContent() 
{
	// TODO: Add your control notification handler code here


}



void CBrowseDlg::OnButtonSearch() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	
	if(m_nCondition<0)
	{
		MessageBox("请选择查询条件！");
		m_ctrCondition.SetFocus();
		return;
	}
	if(m_strContent=="")
	{
		MessageBox("请输入查询内容！");
		m_ctrContent.SetFocus();
		return;
	}

	CString strSQL;
	if(0==m_nCondition)
	{//按部门查询
		strSQL.Format("select * from person where dept='%s'",m_strContent);
		RefreshData(strSQL);
	}
	else if(1==m_nCondition)
	{//按职工职务查询
		strSQL.Format("select * from person where duty='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(2==m_nCondition)
	{//按职工职称查询
		strSQL.Format("select * from person where technical='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(3==m_nCondition)
	{//按职工类型查询
		strSQL.Format("select * from person where isworker='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(4==m_nCondition)
	{//按工资类别查询
		strSQL.Format("select * from person where aboutpay='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(5==m_nCondition)
	{//按职工性别查询
		strSQL.Format("select * from person where sex='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(6==m_nCondition)
	{//按婚姻状况查询
		strSQL.Format("select * from person where ismarry='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(7==m_nCondition)
	{//按职工民族查询
		strSQL.Format("select * from person where folk='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(8==m_nCondition)
	{//按政治面貌查询
		strSQL.Format("select * from person where political='%s'",m_strContent);
		RefreshData(strSQL);

	}
	else if(9==m_nCondition)
	{//按文化程度查询
		strSQL.Format("select * from person where education='%s'",m_strContent);
		RefreshData(strSQL);

	}
	//设置按钮状态
	m_ctrNewBnt.EnableWindow(TRUE);
	m_ctrDelBnt.EnableWindow(TRUE);
	m_ctrSaveBnt.EnableWindow(FALSE);
	m_ctrCancelBnt.EnableWindow(FALSE);
	m_bNew = FALSE;
	m_ctrModify.EnableWindow(TRUE);
	m_BaseInfoDlg.m_ctrID.EnableWindow(FALSE);

}

void CBrowseDlg::OnButtonNew() 
{
	//选择基本档案信息属性页
	m_ctrTabSheet.SetCurSel(0);
	//清空基本档案信息属性页中数据
	m_BaseInfoDlg.Clear();
	//设置基本档案信息属性页状态
	m_BaseInfoDlg.m_ctrID.EnableWindow();
	//设置按钮状态
	m_ctrNewBnt.EnableWindow(FALSE);
	m_ctrDelBnt.EnableWindow(FALSE);
	m_ctrSaveBnt.EnableWindow(TRUE);
	m_ctrCancelBnt.EnableWindow(TRUE);
	m_ctrModify.EnableWindow(FALSE);
	m_bNew = TRUE;
}

void CBrowseDlg::OnButtonSave() 
{
	// TODO: Add your control notification handler code here
	//保存数据到数据库中
	if(!m_BaseInfoDlg.Save())
		return;
	m_BaseInfoDlg.RefreshData();
	m_BaseInfoDlg.m_ctrID.EnableWindow(FALSE);
	//设置按钮状态
	m_ctrNewBnt.EnableWindow(TRUE);
	m_ctrDelBnt.EnableWindow(TRUE);
	m_ctrSaveBnt.EnableWindow(FALSE);
	m_ctrCancelBnt.EnableWindow(FALSE);
	m_ctrModify.EnableWindow(TRUE);
	m_bNew = FALSE;

	//更新对话框上当前记录信息
	m_strName = m_BaseInfoDlg.m_strName;
	m_strCode = m_BaseInfoDlg.m_strID;
	UpdateData(FALSE);
	//更新列表信息
	CString strSQL;
	strSQL="select * from person";
	RefreshData(strSQL);

	//更新各属性页信息
	m_FamilyDlg.RefreshData(m_strCode);
	m_HistoryDlg.RefreshData(m_strCode);
	m_HonorDlg.RefreshData(m_strCode);
	m_QualificationDlg.RefreshData(m_strCode);
//	m_RecordDlg.RefreshData(m_strCode);
	m_TrainDlg.RefreshData(m_strCode);

	
}

void CBrowseDlg::OnButtonDelete() 
{
	// TODO: Add your control notification handler code here
	int i = m_ctrList.GetSelectionMark();
	if(0>i)
	{
		MessageBox("请选择一个职工进行删除！");
		return;
	}

	CString strSQL;
	strSQL.Format("select * from person where ID='%s'",m_ctrList.GetItemText(i,1));
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	//删除该用户
	m_recordset.Delete();
	m_recordset.Close();

	//更新用户列表
	strSQL = "select * from person";
	RefreshData(strSQL);
	//更新对话框上当前记录信息
	m_strCode = "";
	m_strName = "";
	UpdateData(FALSE);
	m_BaseInfoDlg.Clear();

	//更新各属性页信息
	m_FamilyDlg.RefreshData(m_strCode);
	m_HistoryDlg.RefreshData(m_strCode);
	m_HonorDlg.RefreshData(m_strCode);
	m_QualificationDlg.RefreshData(m_strCode);
//	m_RecordDlg.RefreshData(m_strCode);
	m_TrainDlg.RefreshData(m_strCode);


}

void CBrowseDlg::OnButtonModify() 
{
	// TODO: Add your control notification handler code here
	//保存数据到数据库中
	if(!m_BaseInfoDlg.Modify())
		return;
	m_BaseInfoDlg.RefreshData();
	//更新对话框上当前记录信息
	m_strName = m_BaseInfoDlg.m_strName;
	m_strCode = m_BaseInfoDlg.m_strID;
	UpdateData(FALSE);
	//更新列表信息
	CString strSQL;
	strSQL="select * from person";
	RefreshData(strSQL);
	//更新各属性页信息
	m_FamilyDlg.RefreshData(m_strCode);
	m_HistoryDlg.RefreshData(m_strCode);
	m_HonorDlg.RefreshData(m_strCode);
	m_QualificationDlg.RefreshData(m_strCode);
//	m_RecordDlg.RefreshData(m_strCode);
	m_TrainDlg.RefreshData(m_strCode);
	
}

void CBrowseDlg::OnSelchangeTab1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	if(m_bNew)
	{	
		m_ctrTabSheet.SetCurSel(1);

		m_ctrTabSheet.SetCurSel(0);
		m_ctrTabSheet.UpdateWindow();
		*pResult = 0;
		return;
	}


	*pResult = 0;
}

void CBrowseDlg::OnSelchangingTab1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here

	*pResult = 0;
}

void CBrowseDlg::OnButtonCancel() 
{
	//设置按钮状态
	m_ctrNewBnt.EnableWindow(TRUE);
	m_ctrDelBnt.EnableWindow(TRUE);
	m_ctrSaveBnt.EnableWindow(FALSE);
	m_ctrCancelBnt.EnableWindow(FALSE);
	m_ctrModify.EnableWindow(TRUE);
	m_bNew = FALSE;
	
}

void CBrowseDlg::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	
	CDialog::OnClose();
}

void CBrowseDlg::OnDestroy() 
{
	CDialog::OnDestroy();
	
	// TODO: Add your message handler code here
	
}
上一页 12
💿 文件大小 3728 K
👤 上传用户 yingyingyingyin
📂 所属分类企业管理
🏷️ 相关标签

#管理系统 #源码 #程序源码
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -