xiangmudlg.cpp

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

// XiangMuDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TeacherMIS.h"
#include "XiangMuDlg.h"
#include "column.h"
#include "columns.h"
#include "AddXiangMuDlg.h"
#include "User.h"
#include "XiangMu.h"

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

/////////////////////////////////////////////////////////////////////////////
// CXiangMuDlg dialog


CXiangMuDlg::CXiangMuDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CXiangMuDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CXiangMuDlg)
	m_strItemName = _T("");
	m_strID = _T("");
	//}}AFX_DATA_INIT
}


void CXiangMuDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CXiangMuDlg)
	DDX_Control(pDX, IDC_BUTTON_QUERY, m_btnQueryName);
	DDX_Control(pDX, IDC_BUTTON_ID, m_btnID);
	DDX_Control(pDX, IDC_BUTTON_ADDXIANGMU, m_btnAdd);
	DDX_Control(pDX, IDC_ADODC1, m_adodcXiangMu);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagridXiangMu);
	DDX_Text(pDX, IDC_EDIT_ITEMNAME, m_strItemName);
	DDX_Text(pDX, IDC_EDIT_ITEMID, m_strID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CXiangMuDlg, CDialog)
	//{{AFX_MSG_MAP(CXiangMuDlg)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	ON_BN_CLICKED(IDC_BUTTON_ADDXIANGMU, OnButtonAddxiangmu)
	ON_BN_CLICKED(IDC_BUTTON_ID, OnButtonId)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CXiangMuDlg message handlers

void CXiangMuDlg::ResetCol()
{
	CColumns allCols;
	CColumn onecol;
	allCols=m_datagridXiangMu.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(80);
	onecol=allCols.GetItem(COleVariant(long(3)));
	onecol.SetCaption("截止日期");
	onecol.SetWidth(80);
	onecol=allCols.GetItem(COleVariant(long(4)));
	onecol.SetCaption("项目简介");
	onecol.SetWidth(50);
	onecol=allCols.GetItem(COleVariant(long(5)));
	onecol.SetCaption("项目介绍");
	onecol.SetWidth(100);

}

BOOL CXiangMuDlg::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_datagridXiangMu.EnableWindow(FALSE);
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CXiangMuDlg::OnButtonQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if (m_strItemName.IsEmpty()) 
	{
		MessageBox("请输入项目名称!");
		return;
	}

	CString strSQL="select * from tbXiangMu where ItemName like'%"+m_strItemName+"%'";
	//如果没有项目，给出提示
	//使用CXiangMu类
 	CXiangMu name;
    if (name.HaveName(m_strItemName)<0) 
	{
		MessageBox("该项目不存在!");
 		return;
    }
	m_adodcXiangMu.SetRecordSource(strSQL);
	m_adodcXiangMu.Refresh();
	ResetCol();		
}

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


void CXiangMuDlg::OnButtonId() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if (m_strID.IsEmpty())
	{
		MessageBox("请输入项目编号!");
		return;
	}
	CString strSQL;
	strSQL.Format("select * from tbXiangMu where ItemID='%s'",m_strID);
	//如果没有该课程名，给出提示
	//使用Course类
 	CXiangMu  TchID;
    if (TchID.HaveID(m_strID)<0) 
	{
		MessageBox("该编号不存在!");
 		return;
	}
	m_adodcXiangMu.SetRecordSource(strSQL);
	m_adodcXiangMu.Refresh();
	ResetCol();	
}