yearcheckdlg.cpp

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

// YearCheckDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TeacherMIS.h"
#include "YearCheckDlg.h"
#include "AddCheckDlg.h"
#include "User.h"

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

/////////////////////////////////////////////////////////////////////////////
// CYearCheckDlg dialog


CYearCheckDlg::CYearCheckDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CYearCheckDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CYearCheckDlg)
	m_strTchID = _T("");
	//}}AFX_DATA_INIT
	CString strConnection="File Name=TeacherMIS.udl";
	pDB=new CADODatabase;
	pDB->Open(strConnection);
	pRs=new CADORecordset(pDB);
}


void CYearCheckDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CYearCheckDlg)
	DDX_Control(pDX, IDC_BUTTON_ADDCHECK, m_btnAdd);
	DDX_Control(pDX, IDC_BUTTON_SHOWALL, m_btnShowAll);
	DDX_Control(pDX, IDC_BUTTON_QUERY, m_btnQuery);
	DDX_Control(pDX, IDC_LIST_YEARCHECK, m_listYearCheck);
	DDX_Text(pDX, IDC_EDIT_TCHID, m_strTchID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CYearCheckDlg, CDialog)
	//{{AFX_MSG_MAP(CYearCheckDlg)
	ON_BN_CLICKED(IDC_BUTTON_SHOWALL, OnButtonShowall)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	ON_BN_CLICKED(IDC_BUTTON_ADDCHECK, OnButtonAddcheck)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CYearCheckDlg message handlers

BOOL CYearCheckDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here

	m_listYearCheck.InsertColumn(0,"教师姓名",LVCFMT_LEFT,100,-1);
	m_listYearCheck.InsertColumn(1,"考核成绩",LVCFMT_LEFT,150,-1);	
	m_listYearCheck.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

	extern CUser curUser;
	int type=curUser.GetUser_type();
	if(type==2)
	{
		m_btnAdd.EnableWindow(FALSE);

	}

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CYearCheckDlg::RefreshList(CADORecordset &recordset)
{
	m_listYearCheck.DeleteAllItems();
	if (!recordset.IsOpen())
        return;
	if (recordset.GetRecordCount()<=0)
		return;
	recordset.MoveFirst();
	CString strName,strType;
	int indexofList=0;
	while(!(recordset.IsEOF()))
	{
		recordset.GetFieldValue("Name",strName);
		recordset.GetFieldValue("YearCheck",strType);
		m_listYearCheck.InsertItem(indexofList,strName);
		m_listYearCheck.SetItemText(indexofList,1,strType);

		indexofList+=1;
		recordset.MoveNext();
	}
	recordset.MoveFirst();
}

void CYearCheckDlg::OnButtonShowall() 
{
	// TODO: Add your control notification handler code here
	pRs->Open("select * from VIEWTY",CADORecordset.openQuery);
	RefreshList(*pRs);
	//在EditBox控件中，显示第一条记录的详细信息
	//List控件中首记录设为高亮状态
	m_listYearCheck.SetFocus();
	m_listYearCheck.SetItemState(0,LVIS_SELECTED,LVIS_SELECTED);		
}

void CYearCheckDlg::OnButtonQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if (m_strTchID.IsEmpty())
	{
		MessageBox("请输入教师编号!");
		return;
	}
	CYearCheckDlg name;
	if (name.HaveID(m_strTchID)<0) 
	{
		MessageBox("没有该教师!");
		return;
    }

	CString strSQL;
	strSQL.Format("select * from VIEWTY where TchID='%s'",m_strTchID);
	pRs->Close();
	pRs->Open(_bstr_t(strSQL),CADORecordset.openQuery);
	RefreshList(*pRs);
	m_listYearCheck.SetFocus();
	m_listYearCheck.SetItemState(0,LVIS_SELECTED,LVIS_SELECTED);	
}

int CYearCheckDlg::HaveID(CString cID)
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	int m;
	strSQL.Format("select * from VIEWTY where TchID='%s'",cID);
	pRs->Open(strSQL,CADORecordset::openQuery);
	if(pRs->GetRecordCount()>=1)
		m=1;
	else m=-1;
	
	pRs->Close();
	delete pRs;
	return m;
}

void CYearCheckDlg::OnButtonAddcheck() 
{
	// TODO: Add your control notification handler code here
	CAddCheckDlg dlg;
	dlg.DoModal();
}