cjdlg.cpp

具有添加,删除,修改,更新的功能,用ado读ini文件访问数据库

// CjDlg.cpp : implementation file
//

#include "stdafx.h"
#include "学生成绩管理系统.h"
#include "CjDlg.h"
#include "GlobalVarFunc.h"
#include "DBOper.h"
#include "ado.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CCjDlg dialog
//数据库相关变量
extern char gServerName[128];
extern char gDataBaseName[200];
extern char gUserName[128];
extern char gPassWD[128];

extern	CADODatabase *gpDataBase;
extern	bool         gDBConnected;
extern	COleDateTime gDBConnTime;
extern  CADORecordset *pRs; 

CCjDlg::CCjDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCjDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCjDlg)
	m_stno = _T("");
	m_stname = _T("");
	m_kcno = _T("");
	m_kcname = _T("");
	m_chengji = 0;
	m_xuehao = _T("");
	m_xingming = _T("");
	m_kchao = _T("");
	m_kcming = _T("");
	//}}AFX_DATA_INIT
}


void CCjDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCjDlg)
	DDX_Control(pDX, IDC_CJLIST, m_cjlist);
	DDX_Text(pDX, IDC_EDIT1, m_stno);
	DDX_Text(pDX, IDC_EDIT2, m_stname);
	DDX_Text(pDX, IDC_EDIT4, m_kcno);
	DDX_Text(pDX, IDC_EDIT5, m_kcname);
	DDX_Text(pDX, IDC_EDIT7, m_chengji);
	DDX_Text(pDX, IDC_EDIT6, m_xuehao);
	DDX_Text(pDX, IDC_EDIT8, m_xingming);
	DDX_Text(pDX, IDC_EDIT9, m_kchao);
	DDX_Text(pDX, IDC_EDIT10, m_kcming);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCjDlg, CDialog)
	//{{AFX_MSG_MAP(CCjDlg)
	ON_NOTIFY(NM_CLICK, IDC_CJLIST, OnClickCjlist)
	ON_BN_CLICKED(IDC_ADDCJBUTTON, OnAddcjbutton)
	ON_BN_CLICKED(IDC_DELCJBUTTO, OnDelcjbutto)
	ON_BN_CLICKED(IDC_MODCJBUTTON, OnModcjbutton)
	ON_BN_CLICKED(IDC_FINDCJBUTTON, OnFindcjbutton)
	ON_BN_CLICKED(IDC_FINDALLBUTTON, OnFindallbutton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCjDlg message handlers

void CCjDlg::OnClickCjlist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int curSel = m_cjlist.GetSelectionMark();	
	int i;
	char strSql[40];
	CString temp; 
	long chengji;

	if(false==gDBConnected )
	{
		MessageBox("数据库尚未连接!");
		return;
	}
	if(curSel<0)
		return;

	try
	{
		// 先将指针移向第一条记录，然后就可以相对第一条记录来随意移动记录指针
		pRs=new CADORecordset(gpDataBase);
	    if(!pRs) return;
		strcpy(strSql,"select * from 成绩表");
	    if(pRs->Open(strSql)==false)
		{
			delete pRs;
		    return;
		}
		else
		{
			pRs->MoveFirst();
		}
		for(i=1;i<=curSel;i++)
		{
			//pRs->Move(long(curSel));
			pRs->MoveNext();
		}

		pRs->GetFieldValue("学号",temp);
		temp.TrimRight();
		m_stno=temp;
		
		pRs->GetFieldValue("姓名",temp);
		temp.TrimRight();
		m_stname=temp;

		pRs->GetFieldValue("课程号",temp);
		temp.TrimRight();
		m_kcno=temp;
		
		pRs->GetFieldValue("课程名",temp);
		temp.TrimRight();
		m_kcname=temp;
		
		pRs->GetFieldValue("成绩",chengji);
        m_chengji=chengji;

		UpdateData(false); 
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	*pResult = 0;
}

void CCjDlg::OnAddcjbutton() 
{
	// TODO: Add your control notification handler code here
    CjInfo cj;
	bool        ret;
	UpdateData(true);
	
	strcpy(cj.cj_stno,m_stno);
	strcpy(cj.cj_stname,m_stname);
	strcpy(cj.cj_kcno,m_kcno);
	strcpy(cj.cj_kcname,m_kcname);
	cj.cj_cj=m_chengji;
	if(strlen(cj.cj_stno)<=0||strlen(cj.cj_kcno)<=0)
	{
		MessageBox("主码不能为空!");
		return;
	}

	if( false == gDBConnected )
	{
		MessageBox("数据库尚未连接!");
		return;
	}

	ret=InsertInfoIntoChengjiTable(cj);
	if( true == ret)
	{
		MessageBox("记录插入成功!");
		m_stno="";
		m_stname="";
		m_kcno="";
		m_kcname="";
		m_chengji=0;
	}
	else
	{
		MessageBox("记录插入失败!");
		return;
	}
	UpdateData(false);
	ReadDb();
}

void CCjDlg::OnDelcjbutto() 
{
	// TODO: Add your control notification handler code here
    CjInfo cj;
	bool        ret;

	UpdateData(true);
	
	strcpy(cj.cj_stno,m_stno);
    strcpy(cj.cj_kcno,m_kcno);
	if( false == gDBConnected )
	{
		MessageBox("数据库尚未连接!");
		return;
	}
	if(strlen(cj.cj_stno)<=0||strlen(cj.cj_kcno)<=0)
	{
		MessageBox("主码不能为空!");
		return;
	}

	ret = DeleteInfoFromChengjiTable(cj);
	if( true == ret)
	{
		MessageBox("记录删除成功!");
		m_stno="";
		m_stname="";
		m_kcno="";
		m_kcname="";
		m_chengji=0;
	}
	else
	{
		MessageBox("用户不存在或访问数据表出错!");
		return;
	}
    UpdateData(false);
	ReadDb();	
}

void CCjDlg::OnModcjbutton() 
{
	// TODO: Add your control notification handler code here
	CjInfo cj;
	bool        ret;
	UpdateData(true);
	
	strcpy(cj.cj_stno,m_stno);
	strcpy(cj.cj_stname,m_stname);
	strcpy(cj.cj_kcno,m_kcno);
	strcpy(cj.cj_kcname,m_kcname);
	cj.cj_cj=m_chengji;
	if(strlen(cj.cj_stno)<=0||strlen(cj.cj_kcno))
	{
		MessageBox("主码不能为空!");
		return;
	}

	if( false == gDBConnected )
	{
		MessageBox("数据库尚未连接!");
		return;
	}
	ret=UpdateInfoFromChengjiTable(cj);
	if( true == ret)
	{
		MessageBox("修改成功!");
		m_stno="";
		m_stname="";
		m_kcno="";
		m_kcname="";
		m_chengji=0;
	}
	else
	{
		MessageBox("修改失败!");
		return;
	}
    UpdateData(false);
	ReadDb();
}

BOOL CCjDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE ; 
    m_cjlist.SetExtendedStyle(dwExStyle);  

	m_cjlist.InsertColumn(0,"学号",LVCFMT_CENTER,80);
	m_cjlist.InsertColumn(1,"课程号",LVCFMT_CENTER,80);
	m_cjlist.InsertColumn(2,"姓名",LVCFMT_CENTER,80);
	m_cjlist.InsertColumn(3,"课程名",LVCFMT_CENTER,80);
	m_cjlist.InsertColumn(4,"成绩",LVCFMT_CENTER,80);
	m_cjlist.InsertColumn(5,"学分",LVCFMT_CENTER,80);
	m_cjlist.InsertColumn(6,"性别",LVCFMT_CENTER,80);
	m_cjlist.InsertColumn(7,"年龄",LVCFMT_CENTER,80);

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

void CCjDlg::ReadDb()
{
	UpdateData(true);
	CString stno,stname,sex,age,kcno,kcname,xuefen,chengji,temp;
	char  strSql[400];
	int choice = CDialog::GetCheckedRadioButton(IDC_RADIOSTNO,IDC_RADIOKCNAME);
	if( choice == IDC_RADIOSTNO )
	{
		if(m_xuehao.IsEmpty())
		{
			MessageBox("学号不能为空！");
			return;
		}
		strcpy(strSql,"select 学生表.*,课程表.*,成绩表.* from 学生表,课程表,成绩表 where 学生表.学号 ='" );
		strcat(strSql,m_xuehao);
		strcat(strSql,"'and 课程表.课程号=成绩表.课程号");
	}
	else if( choice == IDC_RADIOSTNAME )
	{
		if(m_xingming.IsEmpty())
		{
			MessageBox("姓名不能为空!");
			return;
		}
		strcpy(strSql,"select 学生表.*,课程表.*,成绩表.* from 学生表,课程表,成绩表 where 学生表.姓名 ='" );
		strcat(strSql,m_xingming);
		strcat(strSql,"'and 课程表.课程号=成绩表.课程号");
	}
	else if( choice == IDC_RADIOKCNO )
	{
		if(m_kchao.IsEmpty())
		{
			MessageBox("课程号不能为空!");
			return;
		}
		strcpy(strSql,"select 学生表.*,课程表.*,成绩表.* from 学生表,课程表,成绩表 where 课程表.课程号 ='" );
		strcat(strSql,m_kchao);
		strcat(strSql,"'and 学生表.学号=成绩表.学号");
	}
	else if( choice == IDC_RADIOKCNAME )
	{
		if(m_kcming.IsEmpty())
		{
			MessageBox("课程名不能为空!");
			return;
		}
		strcpy(strSql,"select 学生表.*,课程表.*,成绩表.* from 学生表,课程表,成绩表 where 课程表.课程名 ='" );
		strcat(strSql,m_kcming);
		strcat(strSql,"'and 学生表.学号=成绩表.学号");
	}
	else
	{
		strcpy(strSql,"select * from 成绩表");
	}
	m_cjlist.DeleteAllItems();
	CADORecordset *pRs=NULL;
	pRs = new CADORecordset(gpDataBase);
	if(!pRs) return;
	if(pRs->Open(strSql)==false)
	{
		//AfxMessageBox("QQ!");
		delete pRs;
		return ;
	}
	try
	{
		if(pRs->IsBOF())
		{
			AfxMessageBox("表内数据为空");
			return ;
		}
        else
		{
			pRs->MoveFirst();
		}
		// 读入库中各字段并加入列表框中
		while(!pRs->IsEOF())
		{
			pRs->GetFieldValue("学号",temp);
			temp.TrimRight();
			stno=temp;
			pRs->GetFieldValue("姓名",temp);
			temp.TrimRight();
			stname=temp;
			if(choice !=0 )
			{
				pRs->GetFieldValue("性别",temp);
			    temp.TrimRight();
			    sex=temp;
			    pRs->GetFieldValue("年龄",temp);
			    temp.TrimRight();
			    age=temp;
				pRs->GetFieldValue("学分",temp);
			    temp.TrimRight();
		        xuefen=temp;
			}	
			pRs->GetFieldValue("课程号",temp);
			temp.TrimRight();
			kcno=temp;
			pRs->GetFieldValue("课程名",temp);
			temp.TrimRight();
			kcname=temp;
			pRs->GetFieldValue("成绩",temp);
			temp.TrimRight();
		    chengji=temp;
			LV_ITEM l; 
            int index = m_cjlist.GetItemCount(); 
            l.mask = LVIF_TEXT; 
            l.iSubItem = 0; 
            l.iItem = index; 
            l.pszText = (char*)(LPCTSTR)stno; 

            m_cjlist.InsertItem(&l); 
			m_cjlist.SetItemText( index, 1, kcno); 
            m_cjlist.SetItemText( index, 2, stname); 
            m_cjlist.SetItemText( index, 3, kcname); 
			m_cjlist.SetItemText( index, 4, chengji); 
            m_cjlist.SetItemText( index, 5, xuefen); 
            m_cjlist.SetItemText( index, 6, sex); 
            m_cjlist.SetItemText( index, 7, age); 

			UpdateData(false);
			pRs->MoveNext();
		}
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
}



void CCjDlg::OnFindcjbutton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CString temp;
	char strSql[400];
	long chengji;
	strcpy(strSql,"select * from 成绩表 where 学号='");
	strcat(strSql,m_stno);
	strcat(strSql,"'");
	CADORecordset *pRs=NULL;
	pRs = new CADORecordset(gpDataBase);
	if(!pRs) return;
	if(pRs->Open(strSql)==false)
	{
		//AfxMessageBox("QQ!");
		delete pRs;
		return ;
	}
	try
	{
		if(pRs->IsBOF())
		{
			AfxMessageBox("表内无此数据");
			return;
		}

		// 读入库中各字段并加入列表框中
		else
		{
			pRs->GetFieldValue("姓名",temp);
			temp.TrimRight();
			m_stname=temp;
			pRs->GetFieldValue("课程号",temp);
			temp.TrimRight();
			m_kcno=temp;
			pRs->GetFieldValue("课程名",temp);
			temp.TrimRight();
			m_kcname=temp;
			pRs->GetFieldValue("成绩",chengji);
			m_chengji=chengji;
		}
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
    
	UpdateData(false);
}

void CCjDlg::OnFindallbutton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	m_cjlist.DeleteAllItems();
    ReadDb();
}