📄 outstandingrecord.cpp

📁 这是一个企业办公管理系统。实现了文件的制作、修改、传递、、保存、销毁、存档等一系列操作。为windows系统认证模式
💻 CPP
字号:
// OutstandingRecord.cpp : implementation file
//

#include "stdafx.h"
#include "Office.h"
#include "OutstandingRecord.h"
#include "Achievement.h"

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

/////////////////////////////////////////////////////////////////////////////
// COutstandingRecord dialog


COutstandingRecord::COutstandingRecord(CWnd* pParent /*=NULL*/)
	: CDialog(COutstandingRecord::IDD, pParent)
{
	//{{AFX_DATA_INIT(COutstandingRecord)
	m_name = _T("");
	m_id = _T("");
	m_achievementDate = COleDateTime::GetCurrentTime();
	m_department = _T("");
	m_project = _T("");
	m_achievement = _T("");
	m_remark = _T("");
	//}}AFX_DATA_INIT
}


void COutstandingRecord::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(COutstandingRecord)
	DDX_Control(pDX, IDC_LIST, m_list);
	DDX_Control(pDX, IDC_DEPARTMENT, m_departmentCombo);
	DDX_Control(pDX, IDC_NAME, m_nameCombo);
	DDX_CBString(pDX, IDC_NAME, m_name);
	DDX_CBString(pDX, IDC_ID, m_id);
	DDX_DateTimeCtrl(pDX, IDC_ACHIEVEMENTDATE, m_achievementDate);
	DDX_CBString(pDX, IDC_DEPARTMENT, m_department);
	DDX_Text(pDX, IDC_PROJECT, m_project);
	DDX_Text(pDX, IDC_ACHIEVEMENT, m_achievement);
	DDX_Text(pDX, IDC_REMARK, m_remark);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(COutstandingRecord, CDialog)
	//{{AFX_MSG_MAP(COutstandingRecord)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_MODIFY, OnModify)
	ON_BN_CLICKED(IDC_SAVE, OnSave)
	ON_BN_CLICKED(IDC_CANCELLATION, OnCancellation)
	ON_BN_CLICKED(IDC_EXIT, OnExit)
	ON_NOTIFY(NM_CLICK, IDC_LIST, OnClickList)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// COutstandingRecord message handlers

void COutstandingRecord::OnAdd() 
{
	cwnd_name->EnableWindow(true);
	cwnd_id->EnableWindow(true);
	cwnd_achievementDate->EnableWindow(true);
	cwnd_department->EnableWindow(true);
	cwnd_project->EnableWindow(true);
	cwnd_achievement->EnableWindow(true);
	cwnd_remark->EnableWindow(true);

	cwnd_add->EnableWindow(false);
	cwnd_cancel->EnableWindow(true);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(true);
	cwnd_exit->EnableWindow(false);

	m_name = _T("");
	m_id = _T("");
	m_achievementDate = COleDateTime::GetCurrentTime();
	m_department = _T("");
	m_project = _T("");
	m_achievement = _T("");
	m_remark = _T("");

	flag=1;
	
	UpdateData(false);
}

void COutstandingRecord::OnDelete() 
{
	UpdateData(true);

	CAchievement achievement;
	achievement.sqlDelete(m_achievement);

	cwnd_name->EnableWindow(false);
	cwnd_id->EnableWindow(false);
	cwnd_achievementDate->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_project->EnableWindow(false);
	cwnd_achievement->EnableWindow(false);
	cwnd_remark->EnableWindow(false);

	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);

	m_name = _T("");
	m_id = _T("");
	m_achievementDate = COleDateTime::GetCurrentTime();
	m_department = _T("");
	m_project = _T("");
	m_achievement = _T("");
	m_remark = _T("");

	Refresh();

	UpdateData(false);
}

void COutstandingRecord::OnModify() 
{
	cwnd_name->EnableWindow(true);
	cwnd_id->EnableWindow(true);
	cwnd_achievementDate->EnableWindow(true);
	cwnd_department->EnableWindow(true);
	cwnd_project->EnableWindow(true);
	cwnd_achievement->EnableWindow(false);
	cwnd_remark->EnableWindow(true);

	cwnd_add->EnableWindow(false);
	cwnd_cancel->EnableWindow(true);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(true);
	cwnd_exit->EnableWindow(false);

	flag=2;
}

void COutstandingRecord::OnSave() 
{
	UpdateData(true);

	if(flag==1)
	{
		CAchievement achievement;

		achievement.SetAchievementDate(m_achievementDate);
		achievement.SetName(m_name);
		achievement.SetId(m_id);
		achievement.SetDepartment(m_department);
		achievement.SetProject(m_project);
		achievement.SetAchievement(m_achievement);
		achievement.SetRemark(m_remark);

		achievement.sqlInsert();
	}
	else if(flag==2) 
	{
		CAchievement achievement;

		achievement.SetAchievementDate(m_achievementDate);
		achievement.SetName(m_name);
		achievement.SetId(m_id);
		achievement.SetDepartment(m_department);
		achievement.SetProject(m_project);
		achievement.SetAchievement(m_achievement);
		achievement.SetRemark(m_remark);

		achievement.sqlUpdate(m_achievement);
	}

	cwnd_name->EnableWindow(false);
	cwnd_id->EnableWindow(false);
	cwnd_achievementDate->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_project->EnableWindow(false);
	cwnd_achievement->EnableWindow(false);
	cwnd_remark->EnableWindow(false);

	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(true);
	cwnd_modify->EnableWindow(true);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);

	Refresh();

	UpdateData(false);
}

void COutstandingRecord::OnCancellation() 
{
	cwnd_name->EnableWindow(false);
	cwnd_id->EnableWindow(false);
	cwnd_achievementDate->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_project->EnableWindow(false);
	cwnd_achievement->EnableWindow(false);
	cwnd_remark->EnableWindow(false);

	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);

	m_name = _T("");
	m_id = _T("");
	m_achievementDate = COleDateTime::GetCurrentTime();
	m_department = _T("");
	m_project = _T("");
	m_achievement = _T("");
	m_remark = _T("");

	UpdateData(false);	
}

void COutstandingRecord::OnExit() 
{
	this->OnCancel();
}

BOOL COutstandingRecord::OnInitDialog() 
{
	CDialog::OnInitDialog();

	DWORD style;
	style=m_list.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_list.SetExtendedStyle(style);
	
	m_list.InsertColumn(0,"姓名",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"项目",LVCFMT_LEFT,100);
	m_list.InsertColumn(2,"业绩",LVCFMT_LEFT,100);
	
	cwnd_name = GetDlgItem(IDC_NAME);
	cwnd_id = GetDlgItem(IDC_ID);
	cwnd_achievementDate = GetDlgItem(IDC_ACHIEVEMENTDATE);
	cwnd_department = GetDlgItem(IDC_DEPARTMENT);
	cwnd_project = GetDlgItem(IDC_PROJECT);
	cwnd_achievement = GetDlgItem(IDC_ACHIEVEMENT);
	cwnd_remark = GetDlgItem(IDC_REMARK);

	cwnd_add = GetDlgItem(IDC_ADD);
	cwnd_cancel = GetDlgItem(IDC_CANCELLATION);
	cwnd_delete = GetDlgItem(IDC_DELETE);
	cwnd_modify = GetDlgItem(IDC_MODIFY);
	cwnd_save = GetDlgItem(IDC_SAVE);
	cwnd_exit = GetDlgItem(IDC_EXIT);

	flag=0;


	_RecordsetPtr m_pRecordset;

	CString strSQL;
	strSQL="select * from achievementRecord";
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		
		while(!(m_pRecordset->adoEOF))
		{
			m_list.InsertItem(i,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("name")));
			m_list.SetItemText(i,1,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("project")));
			m_list.SetItemText(i,2,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("achievement")));
			
			i++;
			if(!(m_pRecordset->adoEOF))
				m_pRecordset->MoveNext();
		}
	}

	cwnd_name->EnableWindow(false);
	cwnd_id->EnableWindow(false);
	cwnd_achievementDate->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_project->EnableWindow(false);
	cwnd_achievement->EnableWindow(false);
	cwnd_remark->EnableWindow(false);

	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void COutstandingRecord::OnClickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	UpdateData(true);
	POSITION pos = m_list.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_list.GetNextSelectedItem(pos);
		m_achievement=m_list.GetItemText(nFirstSelItem,2);
	}

	CAchievement achievement;
	achievement.GetData(m_achievement);
	m_name=achievement.GetName();
	m_project=achievement.GetProject();
	m_achievement=achievement.GetAchievement();
	m_department=achievement.GetDepartment();
	m_id=achievement.GetId();
	m_remark=achievement.GetRemark();
	m_achievementDate=achievement.GetAchievementDate();

	
	cwnd_name->EnableWindow(false);
	cwnd_id->EnableWindow(false);
	cwnd_achievementDate->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_project->EnableWindow(false);
	cwnd_achievement->EnableWindow(false);
	cwnd_remark->EnableWindow(false);

	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(true);
	cwnd_modify->EnableWindow(true);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);

	*pResult = 0;

	UpdateData(false);
}

void COutstandingRecord::Refresh()
{
	m_list.DeleteAllItems();
	_RecordsetPtr m_pRecordset;

	CString strSQL;
	strSQL="select * from achievementRecord";
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		
		while(!(m_pRecordset->adoEOF))
		{
			m_list.InsertItem(i,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("name")));
			m_list.SetItemText(i,1,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("project")));
			m_list.SetItemText(i,2,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("achievement")));
			
			i++;
			if(!(m_pRecordset->adoEOF))
				m_pRecordset->MoveNext();
		}
	}
}
💿 文件大小 4018 K
👤 上传用户 fq335288450
📂 所属分类企业管理
🏷️ 相关标签

#windows #管理系统 #修改 #操作
⌨️ 快捷键说明

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