yuangongjinglidlg.cpp

企业之间的竞争主要体现在三个方面：产品市场的竞争、资金市场的竞争和人才市场的竞争。在网络经济的环境下

// YuangongjingliDlg.cpp : implementation file
//

#include "stdafx.h"
#include "renshi.h"
#include "YuangongjingliDlg.h"
#include "YuangongjingliEditDlg.h"

#include "control\Columns.h"
#include "control\Column.h"
#include "control\_recordset.h"
#include "class\jingli.h"

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

/////////////////////////////////////////////////////////////////////////////
// CYuangongjingliDlg dialog


CYuangongjingliDlg::CYuangongjingliDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CYuangongjingliDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CYuangongjingliDlg)
	m_YgName = _T("");
	//}}AFX_DATA_INIT
}


void CYuangongjingliDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CYuangongjingliDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	DDX_Text(pDX, IDC_STATIC_NAME, m_YgName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CYuangongjingliDlg, CDialog)
	//{{AFX_MSG_MAP(CYuangongjingliDlg)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_MODIFY, OnModify)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CYuangongjingliDlg message handlers

void CYuangongjingliDlg::Refresh_Data()
{
		CString cYgID;
	cYgID.Format("%d", iYgID);
	//设置记录源
	CString cSource;
	cSource = "SELECT ID, StartDate AS 开始日期, EndDate AS 结束日期, Unit AS 学校或单位名称,";
	cSource	+= " Title AS 职务 FROM Jingli WHERE yg_ID=" + cYgID;
	m_adodc.SetRecordSource(cSource);
	m_adodc.Refresh();


	m_datagrid.GetColumns().GetItem((_variant_t)long(0)).SetWidth(0);
	m_datagrid.GetColumns().GetItem((_variant_t)long(1)).SetWidth(80);
	m_datagrid.GetColumns().GetItem((_variant_t)long(2)).SetWidth(80);
	m_datagrid.GetColumns().GetItem((_variant_t)long(3)).SetWidth(80);
	m_datagrid.GetColumns().GetItem((_variant_t)long(4)).SetWidth(80);
}

void CYuangongjingliDlg::OnAdd() 
{
	CYuangongJingliEditDlg dlg;
	dlg.cID = "";
	dlg.iYgID = iYgID;
	if (dlg.DoModal() == IDOK)
		Refresh_Data();		
}

BOOL CYuangongjingliDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	Refresh_Data();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CYuangongjingliDlg::OnModify() 
{
	if (m_adodc.GetRecordset().GetEof()) 
	{
		MessageBox("请选择要修改的记录");
		return;
	}


	CYuangongJingliEditDlg dlg;
	dlg.cID = m_datagrid.GetItem(0);		//记录编号
	dlg.iYgID = iYgID;						//员工编号
	dlg.__StartTime=m_datagrid.GetItem(1);
	dlg.__EndTime=m_datagrid.GetItem(2);
	dlg.m_Org = m_datagrid.GetItem(3);		//单位/学校
	dlg.m_Title = m_datagrid.GetItem(4);	//职务

	if (dlg.DoModal() == IDOK)
		Refresh_Data();		
}

void CYuangongjingliDlg::OnDelete() 
{
	if (m_adodc.GetRecordset().GetEof()) 
	{
		MessageBox("请选择要删除的记录");
		return;
	}
	if (MessageBox("是否删除当前记录","请确定", MB_YESNO) == IDYES)
	{
		CJingli exp;
		exp.sql_delete(m_datagrid.GetItem(0));
		Refresh_Data();
	}		
}