【VC开源代码栏目提醒】:网学会员鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“ErrandManDlg.cpp”一文,供大家参考学习
// ErrandManDlg.cpp : implementation file
//
#include "stdafx.h"
#include "CheckManage.h"
#include "ErrandManDlg.h"
#include "ErrandEditDlg.h"
#include "EmpInfo.h"
#include "CheckInfo.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_Recordset.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CErrandManDlg dialog
CErrandManDlg::CErrandManDlg(CWnd* pParent /*=NULL*/)
: CDialog(CErrandManDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CErrandManDlg)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CErrandManDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CErrandManDlg)
DDX_Control(pDX, IDC_TREE1, m_tree);
DDX_Control(pDX, IDC_ADODC1, m_Adodc);
DDX_Control(pDX, IDC_DATAGRID1, m_Datagrid);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CErrandManDlg, CDialog)
//{{AFX_MSG_MAP(CErrandManDlg)
ON_NOTIFY(TVN_SELCHANGED, IDC_TREE1, OnSelchangedTree1)
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()
/////////////////////////////////////////////////////////////////////////////
// CErrandManDlg message handlers
BOOL CErrandManDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
//装入部门信息
dep.LoadDep();
//添加根节点
m_treeImageList.Create(16,16,FALSE,1,0); //创建CImageList控件
//装入ICON资源
HICON hIcon = ::LoadIcon(AfxGetResourceHandle(), MAKEINTRESOURCE(IDI_ICON1));
m_treeImageList.Add(hIcon); //将ICON资源添加到CImageList控件中
//将CImageList控件与Tree控件相关联
m_tree.SetImageList(&m_treeImageList, LVSIL_NORMAL);
m_root = m_tree.InsertItem("部门信息"); //添加根节点
//调用AddtoTree() 函数,将所有部门信息添加到Tree控件中
AddtoTree(m_root, 0);
m_tree.Expand(m_root, TVE_EXPAND); //展开根节点
//选中根节点
m_tree.SelectItem(m_root);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CErrandManDlg::RefreshData()
{
UpdateData(TRUE);
//从Tree控件中读取部门编号信息
int iDepId;
HTREEITEM node;
node = m_tree.GetSelectedItem();
iDepId = m_tree.GetItemData(node);
//根据部门编号设置SELECT语句
CString cDepId;
cDepId.Format("%d", iDepId);
// 设置SELECT语句
CString cSource = "SELECT c.EmpId AS 员工编号, e.Name AS , c.CheckDate AS 出勤日期,"
" c.ChuChai AS 是否出差, c.Memo AS 备注"
" FROM CheckInfo c, EmpInfo e, DepInfo d"
" WHERE c.EmpId = e.EmpId AND e.DepId = d.DepId";
// 若选择的不是根节点
if(m_tree.GetItemData(node) != 0) // 不是根节点
{
// 第2级节点
if(m_tree.GetItemData(m_tree.GetParentItem(node)) != 0)
{
cSource += " AND d.DepId = " + cDepId;
}
// 第1级节点
else
{
cSource += " AND (d.UID = " + cDepId + " OR d.DepId = " + cDepId + ")";
}
}
//刷新ADO Data控件的记录源
m_Adodc.SetRecordSource(cSource);
m_Adodc.Refresh();
//设置列宽度
_variant_t vIndex;
vIndex = long(0);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
vIndex = long(1);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
vIndex = long(2);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
vIndex = long(3);
m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
vIndex = long(4);
m_Datagrid.GetColumns().GetItem(vInd