checkmandlg.cpp

C++应用编程20例,各种小程序原代码都有

// CheckManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Classsystem.h"
#include "CheckManDlg.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_recordset.h"
#include "ADOConn.h"
#include "CheckEditDlg.h"
#include "Grade.h"
#include "Users.h"

extern CUsers curUser;

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

/////////////////////////////////////////////////////////////////////////////
// CCheckManDlg dialog

CString xxx="";
CCheckManDlg::CCheckManDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCheckManDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCheckManDlg)
	m_XueHao = _T("");
	m_Name = _T("");
	m_Major = _T("");
	
	//}}AFX_DATA_INIT
}


void CCheckManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCheckManDlg)
	DDX_Control(pDX, IDC_TREE1, m_tree);
	DDX_Text(pDX, IDC_XUEHAO_EDIT, m_XueHao);
	DDV_MaxChars(pDX, m_XueHao, 6);
	DDX_Control(pDX, IDC_DATALIST1, m_datalist);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	DDX_Control(pDX, IDC_ADODC2, m_adodc2);
	DDX_Text(pDX, IDC_NAME_EDIT, m_Name);
	DDX_Text(pDX, IDC_MAJOR_STATIC, m_Major);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCheckManDlg, CDialog)
	//{{AFX_MSG_MAP(CCheckManDlg)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE1, OnSelchangedTree1)
	ON_BN_CLICKED(ID_SEARCH, OnSearch)
	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()

/////////////////////////////////////////////////////////////////////////////
// CCheckManDlg message handlers

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

	
	// TODO: Add extra initialization here
	//权限控制，如果不是系统管理员则添加、修改和删除按钮置灰
	if (curUser.GetUser_type() != 2)
	{
		GetDlgItem(IDC_ADD_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_MODI_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_DEL_BUTTON)->EnableWindow(FALSE);
		//GetDlgItem(IDC_TRANSFER_BUTTON)->EnableWindow(FALSE);
		//GetDlgItem(IDC_EXP_BUTTON)->EnableWindow(FALSE);
		//GetDlgItem(IDC_FAMILY_BUTTON)->EnableWindow(FALSE);
	}
	//装入部门信息
	dep.Load_dep();
	
	//添加根节点
	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);

	//设置员工状态属性
	//m_combo.SetCurSel(0);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCheckManDlg::OnSelchangedTree1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	Refresh_Data();
	*pResult = 0;
}
void CCheckManDlg::AddtoTree(HTREEITEM m_node, int UpperId)
{
	//使用递归方法将部门添加到TreeView控件中
	int i;
	HTREEITEM m_child;
	//依次访问dep对象中的部门数组，查找满足条件的记录添加到Tree控件中
	for(i=0; i<dep.a_UpperId.GetSize(); i++)
	{
		//@@@@ 打开a_UpperId数组中等于UpperId的元素
		//@@@@ 表明此元素为当前根节点的子节点，因此将其添加到Tree控件中，新节点为m_child
		//@@@@ 使用SetItemData()函数将部门编号值也保存在新节点中
		//@@@@ 以新节点为根节点，再次递归调用AddtoTree()函数，将其子节点添加到Tree控件中
		if (UpperId == atoi(dep.a_UpperId.GetAt(i)))
		{
			m_child = m_tree.InsertItem(dep.a_DepName.GetAt(i), m_node);
			m_tree.SetItemData(m_child, atol(dep.a_DepId.GetAt(i)));
			AddtoTree(m_child, atoi(dep.a_DepId.GetAt(i)));
		}
	}
}

void CCheckManDlg::Refresh_Data()
{
	UpdateData(TRUE);
	//从Tree控件中读取部门编号信息
	CString iDepId;
	HTREEITEM node;
	node = m_tree.GetSelectedItem();
	iDepId = m_tree.GetItemText(node);
	//根据部门编号设置SELECT语句
	CString cDepId;
	cDepId=iDepId;
	xxx=iDepId;//留给 datalist 用
	CString cSource = "SELECT * from xs where 专业名='" + cDepId+"'";
	
	m_adodc.SetRecordSource(cSource);
	m_adodc.Refresh();


}
void CCheckManDlg::Refresh_Data1()
{
	UpdateData(TRUE);
	//从Tree控件中读取部门编号信息
	CString iDepId;
//	HTREEITEM node;
//	node = m_tree.GetSelectedItem();
	iDepId = m_datalist.GetText();
	//根据部门编号设置SELECT语句
	CString cDepId;
	cDepId=iDepId;
	CString cSource = "select a.学号,姓名,b.课程号,c.课程名,成绩,专业名 from xs as a,xs_kc as b,kc as c where a.学号=b.学号 and b.课程号=c.课程号 and 姓名='"+ cDepId+"' and 专业名='" + xxx+"'";
	m_adodc2.SetRecordSource(cSource);
	m_adodc2.Refresh();

	//设置列宽度
	_variant_t vIndex;
	vIndex = long(0);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(2);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(3);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(4);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(5);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
//	vIndex = long(6);
//	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(200);
}

BEGIN_EVENTSINK_MAP(CCheckManDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CCheckManDlg)
	ON_EVENT(CCheckManDlg, IDC_DATALIST1, -600 /* Click */, OnClickDatalist1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()


void CCheckManDlg::OnOK() 
{
	// TODO: Add extra validation here
	
//	CDialog::OnOK();
}

void CCheckManDlg::OnSearch() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	//从Tree控件中读取部门编号信息
	CString cDepId;
	cDepId=m_XueHao;
	m_Major="";
	m_Name="没有纪录";
	UpdateData(false);
	Invalidate(true);
	if(HaveName(cDepId)==1)
	{
	CString cSource = "select a.学号,姓名,b.课程号,c.课程名,成绩,专业名 from xs as a,xs_kc as b,kc as c where a.学号=b.学号 and b.课程号=c.课程号 and b.学号='"+ cDepId+"'";
	m_adodc2.SetRecordSource(cSource);
	m_adodc2.Refresh();
	m_Name=m_datagrid.GetItem(1);
	m_Major=m_datagrid.GetItem(5);
	m_adodc2.Refresh();
	}
	else
	{
		CString cSource = "select a.学号,姓名,b.课程号,c.课程名,成绩,专业名 from xs as a,xs_kc as b,kc as c where a.学号=b.学号 and b.课程号=c.课程号 and b.学号='"+ cDepId+"'";
		m_adodc2.SetRecordSource(cSource);
		m_adodc2.Refresh();
	}

	//m_adodc2.Refresh();
	//Invalidate(true);
	

	
	//设置列宽度
	_variant_t vIndex;
	vIndex = long(0);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(2);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(3);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(4);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(5);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);

	//Refresh_Data1();
	
	UpdateData(false);
	//Invalidate(true);
}

void CCheckManDlg::OnClickDatalist1() 
{
	// TODO: Add your control notification handler code here
		
	m_Name="没有纪录";
	m_Major="";
	UpdateData(false);
	Invalidate(true);
	Refresh_Data1();
	m_Name=m_datagrid.GetItem(1);
	m_Major=m_datagrid.GetItem(5);
	UpdateData(false);
	Invalidate(true);
		//;
}
int CCheckManDlg::HaveName(CString cDep_Name)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "select a.学号,姓名,b.课程号,c.课程名,成绩 from xs as a,xs_kc as b,kc as c where a.学号=b.学号 and b.课程号=c.课程号 and b.学号='" + cDep_Name + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CCheckManDlg::OnAddButton() 
{
	// TODO: Add your control notification handler code here
	CCheckEditDlg dlg;
	dlg.orif=1;
	if(dlg.DoModal()==IDOK)
		MessageBox("成功添加纪录");
	//Refresh_Data();
	//m_adodc2.Refresh();
}

void CCheckManDlg::OnModiButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);

	if (m_adodc2.GetRecordset().GetEof())
	{
		MessageBox("请选择要修改的记录!");
		return;
	}
	CCheckEditDlg dlg;
    dlg.m_xuehao = m_datagrid.GetItem(0);
	dlg.m_name = m_datagrid.GetItem(1);
	dlg.m_course = m_datagrid.GetItem(2);
	//CString ii=m_datagrid.GetItem(4);
	dlg.m_grade =atoi((LPCTSTR)(_bstr_t)m_datagrid.GetItem(4));
	//dlg.m_home = m_datagrid.GetItem(4);
	dlg.orif=0;
	if (dlg.DoModal() == IDOK)
		MessageBox("成功修改！");
		//m_adodc2.Refresh();
	//Refresh_Data1();
}

void CCheckManDlg::OnDelButton() 
{
	// TODO: Add your control notification handler code here
	if(m_adodc2.GetRecordset().GetEof() == 1)
	{
		MessageBox("请你选择要删除的数据");
		return;
	}
	CString aa=m_datagrid.GetItem(0);
	CString bb=m_datagrid.GetItem(2);
	if(MessageBox("是否删除当前记录？","请确认",MB_YESNO)==IDYES)
	{
		//CCheckEditDlg
		CGrade emp;
		emp.g_delete(aa,bb);
		//Refresh_Data();
		MessageBox("删除操作成功！");
	}
}