keyandlg.cpp

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

// KeYanDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TeacherMIS.h"
#include "KeYanDlg.h"
#include "column.h"
#include "columns.h"
#include "AddKeYanDlg.h"
#include "User.h"
#include "KeYan.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKeYanDlg dialog


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


void CKeYanDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKeYanDlg)
	DDX_Control(pDX, IDC_BUTTON_ADDKEYAN, m_btnAdd);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagridKeYan);
	DDX_Control(pDX, IDC_ADODC1, m_adodcKeYan);
	DDX_Text(pDX, IDC_EDIT_TCHID, m_strTchID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKeYanDlg, CDialog)
	//{{AFX_MSG_MAP(CKeYanDlg)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	ON_BN_CLICKED(IDC_BUTTON_ADDKEYAN, OnButtonAddkeyan)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKeYanDlg message handlers

void CKeYanDlg::ResetCol()
{
	CColumns allCols;
	CColumn onecol;
	allCols=m_datagridKeYan.GetColumns();
	//设置各列标题和宽度
	onecol=allCols.GetItem(COleVariant(long(0)));
	onecol.SetCaption("成果编号");
	onecol.SetWidth(50);
	onecol=allCols.GetItem(COleVariant(long(1)));
	onecol.SetCaption("教师编号");
	onecol.SetWidth(50);
	onecol=allCols.GetItem(COleVariant(long(2)));
	onecol.SetCaption("发表论文");
	onecol.SetWidth(120);
	onecol=allCols.GetItem(COleVariant(long(3)));
	onecol.SetCaption("授奖单位");
	onecol.SetWidth(100);
	onecol=allCols.GetItem(COleVariant(long(4)));
	onecol.SetCaption("获奖级别");
	onecol.SetWidth(70);
	onecol=allCols.GetItem(COleVariant(long(5)));
	onecol.SetCaption("获得时间");
	onecol.SetWidth(70);
	onecol=allCols.GetItem(COleVariant(long(6)));
	onecol.SetCaption("备注");
	onecol.SetWidth(100);
}

BOOL CKeYanDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	ResetCol();
	extern CUser curUser;
	int type=curUser.GetUser_type();
	if(type==2)
	{
		m_btnAdd.EnableWindow(FALSE);
		m_datagridKeYan.EnableWindow(FALSE);
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CKeYanDlg::OnButtonQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if (m_strTchID.IsEmpty())
	{
		MessageBox("请输入教师编号!");
		return;
	}
	CKeYan ID;
    if (ID.HaveID(m_strTchID)<0) 
	{
		MessageBox("该教师科研信息不存在!");
 		return;
    }
	CString strSQL;
	strSQL.Format("select * from tbKeYan where TchID='%s'",m_strTchID);
	m_adodcKeYan.SetRecordSource(strSQL);
	m_adodcKeYan.Refresh();
	ResetCol();

}

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