xiangmukfdlg.cpp

陕西理工学院计算机系教师信息管理系统的设计与实现

// XiangMuKFDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TeacherMIS.h"
#include "XiangMuKFDlg.h"
#include "columns.h"
#include "column.h"
#include "AddXMKFDlg.h"
#include "XiangMu.h"
#include "XiangMuKF.h"

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

/////////////////////////////////////////////////////////////////////////////
// CXiangMuKFDlg dialog


CXiangMuKFDlg::CXiangMuKFDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CXiangMuKFDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CXiangMuKFDlg)
	m_strItemID = _T("");
	m_strTchID = _T("");
	//}}AFX_DATA_INIT
}


void CXiangMuKFDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CXiangMuKFDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adodcXMKF);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagridXMKF);
	DDX_Text(pDX, IDC_EDIT_ITEMID, m_strItemID);
	DDX_Text(pDX, IDC_EDIT_TCHID, m_strTchID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CXiangMuKFDlg, CDialog)
	//{{AFX_MSG_MAP(CXiangMuKFDlg)
	ON_BN_CLICKED(IDC_BUTTON_ITEMQUERY, OnButtonItemquery)
	ON_BN_CLICKED(IDC_BUTTON_TCHQUERY, OnButtonTchquery)
	ON_BN_CLICKED(IDC_BUTTON_ADD, OnButtonAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CXiangMuKFDlg message handlers

void CXiangMuKFDlg::ResetCol()
{
	CColumns allCols;
	CColumn onecol;
	allCols=m_datagridXMKF.GetColumns();
	//设置各列标题和宽度
	onecol=allCols.GetItem(COleVariant(long(0)));
	onecol.SetCaption("编号");
	onecol.SetWidth(50);
	onecol=allCols.GetItem(COleVariant(long(1)));
	onecol.SetCaption("项目编号");
	onecol.SetWidth(120);
	onecol=allCols.GetItem(COleVariant(long(2)));
	onecol.SetCaption("教师编号");
	onecol.SetWidth(60);
	onecol=allCols.GetItem(COleVariant(long(3)));
	onecol.SetCaption("开发进度");
	onecol.SetWidth(60);
	onecol=allCols.GetItem(COleVariant(long(4)));
	onecol.SetCaption("项目期限");
	onecol.SetWidth(150);

}

BOOL CXiangMuKFDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	ResetCol();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CXiangMuKFDlg::OnButtonItemquery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	//如果没有该项目编号，给出提示
	if (m_strItemID.IsEmpty()) 
	{
		MessageBox("请输入项目编号!");
		return;
	}
	CString strSQL;
	strSQL.Format("select * from tbXiangMuKF where ItemID='%s'",m_strItemID);
 	CXiangMuKF  ItemID;
    if (ItemID.HaveID(m_strItemID)<0) 
	{
		MessageBox("没有该项目!");
 		return;
	}
	m_adodcXMKF.SetRecordSource(strSQL);
	m_adodcXMKF.Refresh();
	ResetCol();	
}

void CXiangMuKFDlg::OnButtonTchquery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	//如果没有该教师编号，给出提示
	if (m_strTchID.IsEmpty()) 
	{
		MessageBox("请输入教师编号!");
		return;
	}
 	CXiangMuKF  TchID;
    if (TchID.HaveID(m_strTchID)<0) 
	{
		MessageBox("该教师没项目!");
 		return;
	}
	CString strSQL;
	strSQL.Format("select * from tbXiangMuKF where TchID='%s'",m_strTchID);
	m_adodcXMKF.SetRecordSource(strSQL);
	m_adodcXMKF.Refresh();
	ResetCol();		
}

void CXiangMuKFDlg::OnButtonAdd() 
{
	// TODO: Add your control notification handler code here
	CAddXMKFDlg dlg;
	//如果添加了记录，则刷新数据
	if (dlg.DoModal()==IDOK)
	{
		m_adodcXMKF.Refresh();
		ResetCol();
	}	
}