jiangchengstatdlg.cpp

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

// JiangChengStatDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TeacherMIS.h"
#include "JiangChengStatDlg.h"
#include "KeYanStatDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CJiangChengStatDlg dialog


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


void CJiangChengStatDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJiangChengStatDlg)
	DDX_Control(pDX, IDC_LIST_JIANGCHNEGSTAT, m_listJC);
	DDX_Control(pDX, IDC_BUTTON_QUERY, m_btnQuery);
	DDX_Text(pDX, IDC_EDIT_HUOJIANGALL, m_strAll);
	DDX_Text(pDX, IDC_EDIT_TCHID, m_strTchID);
	DDX_Text(pDX, IDC_EDIT_TCHNAME, m_strTchName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CJiangChengStatDlg, CDialog)
	//{{AFX_MSG_MAP(CJiangChengStatDlg)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CJiangChengStatDlg message handlers

BOOL CJiangChengStatDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_listJC.InsertColumn(0,"获奖级别",LVCFMT_LEFT,100,-1);
	m_listJC.InsertColumn(1,"获奖时间",LVCFMT_LEFT,160,-1);	
	m_listJC.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CJiangChengStatDlg::RefreshList(CADORecordset &recordset)
{
	m_listJC.DeleteAllItems();
	if (!recordset.IsOpen())
        return;
	if (recordset.GetRecordCount()<=0)
		return;
	recordset.MoveFirst();
	CString strGrade,strTime1;
	COleDateTime strTime;
	int indexofList=0;
	while(!(recordset.IsEOF()))
	{
		recordset.GetFieldValue("Grade",strGrade);
		recordset.GetFieldValue("GainTime",strTime);
		m_listJC.InsertItem(indexofList,strGrade);
        strTime1.Format("%d-%d-%d",strTime.GetYear(),strTime.GetMonth(),strTime.GetDay());
		m_listJC.SetItemText(indexofList,1,strTime1);
		indexofList+=1;
		recordset.MoveNext();
	}
	recordset.MoveFirst();
}

void CJiangChengStatDlg::OnButtonQuery() 
{
	// TODO: Add your control notification handler code here
   UpdateData(TRUE);
   if (m_strTchID.IsEmpty())
   {
	   MessageBox("请输入查询姓名!");
	   return;
	}

   CKeYanStatDlg name;
   if (name.HaveID(m_strTchID)<0) 
   {
	   MessageBox("该教师没有科研信息!");
	   return;
   }

    CString strSQL1;
	strSQL1.Format("select * from VIEWTK where TchID='%s'",m_strTchID);  
    pRs->Open(strSQL1,CADORecordset.openQuery);
	RefreshList(*pRs);
	//List控件中首记录设为高亮状态
	m_listJC.SetFocus();
 	m_listJC.SetItemState(0,LVIS_SELECTED,LVIS_SELECTED);

   CString strSQL;
// strSQL="select * from tbTeach where TchName like '%"+m_strTchName+"%'"; 
   strSQL.Format(_T("select * from VIEWTK where TchID='%s'"),m_strTchID);
   pRs->Open(strSQL,CADORecordset.openQuery);
 //pRs->Open("select TchName , COUNT(AllNum)  number  from tbTeach group by TchName ",CADORecordset.openQuery);
 //不能比较或排序 text、ntext 和 image 数据类型，除非使用 IS NULL 或 LIKE 运算符。

   RefreshList2(*pRs);
   UpdateData(FALSE);
}


void CJiangChengStatDlg::RefreshList2(CADORecordset& recordset)
{
  	
if (!recordset.IsOpen())
        return;
	if (recordset.GetRecordCount()<=0)
		return;
	recordset.MoveFirst();
	CString thegrade,strName;
    int number=0;
	while(!(recordset.IsEOF()))
	{
    recordset.GetFieldValue("Grade",thegrade);
	if(thegrade!=_T(""))
    number++;
   	recordset.MoveNext();
	}
	recordset.MoveFirst();
	m_strAll.Format("%d", number);
	//显示不出名字
//    strName.Format("select TchName from VIEWTK where TchID='%s'",m_strTchID);
//    m_strTchName=strName;
	//取出字段了，哈哈，开心啊
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
    strName.Format("select TchName from VIEWTK where TchID=%s",m_strTchID);
	pRs->Open(strName,CADORecordset::openQuery);
	pRs->GetFieldValue("TchName",m_strTchName);
	pRs->Close();
	delete pRs;
}