yuangongfamilydlg.cpp

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

// YuangongFamilyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Renshi.h"
#include "YuangongFamilyDlg.h"
#include "YuangongFamilyEditDlg.h"
#include "Class\jiating.h"

#include "Control\Columns.h"
#include "Control\Column.h"
#include "Control\_recordset.h"


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

/////////////////////////////////////////////////////////////////////////////
// CYuangongFamilyDlg dialog


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


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


BEGIN_MESSAGE_MAP(CYuangongFamilyDlg, CDialog)
	//{{AFX_MSG_MAP(CYuangongFamilyDlg)
	ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
	ON_BN_CLICKED(IDC_MODI_BUTTON, OnModiButton)
	ON_BN_CLICKED(IDC_DEL_BUTTON, OnDelButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CYuangongFamilyDlg message handlers

void CYuangongFamilyDlg::Refresh_Data()
{
	CString cYgID;
	cYgID.Format("%d", iYgID);
	//设置记录源
	CString cSource;
	cSource = "SELECT ID, Name AS 姓名, Sex AS 性别, Age AS 年龄, Relationship AS 关系,";
	cSource	+= " WorkingOrg AS 工作单位 FROM Family 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(70);
	m_datagrid.GetColumns().GetItem((_variant_t)long(2)).SetWidth(70);
	m_datagrid.GetColumns().GetItem((_variant_t)long(3)).SetWidth(70);
	m_datagrid.GetColumns().GetItem((_variant_t)long(4)).SetWidth(70);
	m_datagrid.GetColumns().GetItem((_variant_t)long(5)).SetWidth(70);
}

void CYuangongFamilyDlg::OnAddButton() 
{	
	CYuangongFamilyEditDlg dlg;
	dlg.cID = "";
	dlg.iYgID = iYgID;
	if (dlg.DoModal() == IDOK)
		Refresh_Data();

}

BOOL CYuangongFamilyDlg::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 CYuangongFamilyDlg::OnModiButton() 
{
	if (m_adodc.GetRecordset().GetEof()) 
	{
		MessageBox("请选择要修改的记录");
		return;
	}
	CYuangongFamilyEditDlg dlg;
	dlg.cID = m_datagrid.GetItem(0); //记录编号
	dlg.iYgID = iYgID;  //员工编号
	dlg.m_Name = m_datagrid.GetItem(1); //姓名
	dlg.cSex = m_datagrid.GetItem(2); //性别
	dlg.m_Age = atoi(m_datagrid.GetItem(3)); //年龄
	dlg.m_Relation = m_datagrid.GetItem(4); //关系
	dlg.m_Org = m_datagrid.GetItem(5);

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

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