kcdlg.cpp

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

// KcDlg.cpp : implementation file
//

#include "stdafx.h"
#include "学生成绩管理系统.h"
#include "KcDlg.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

/////////////////////////////////////////////////////////////////////////////
// CKcDlg 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; 

CKcDlg::CKcDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CKcDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKcDlg)
	m_kcno = _T("");
	m_kcname = _T("");
	m_xuefen = 0;
	//}}AFX_DATA_INIT
}


void CKcDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKcDlg)
	DDX_Control(pDX, IDC_KCLIST, m_kclist);
	DDX_Text(pDX, IDC_EDIT1, m_kcno);
	DDX_Text(pDX, IDC_EDIT2, m_kcname);
	DDX_Text(pDX, IDC_EDIT6, m_xuefen);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKcDlg, CDialog)
	//{{AFX_MSG_MAP(CKcDlg)
	ON_BN_CLICKED(IDC_ADDKCBUTTON, OnAddkcbutton)
	ON_BN_CLICKED(IDC_DELKCBUTTON, OnDelkcbutton)
	ON_BN_CLICKED(IDC_MODKCBUTTON, OnModkcbutton)
	ON_BN_CLICKED(IDC_FDKCBUTTON, OnFdkcbutton)
	ON_NOTIFY(NM_CLICK, IDC_KCLIST, OnClickKclist)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKcDlg message handlers



void CKcDlg::OnAddkcbutton() 
{
	// TODO: Add your control notification handler code here
	KcInfo kc;
	bool        ret;
	UpdateData(true);
	
	strcpy(kc.kc_no,m_kcno);
	strcpy(kc.kc_name,m_kcname);
	kc.kc_score=m_xuefen;
	if(strlen(kc.kc_no)<=0)
	{
		MessageBox("主码不能为空!");
		return;
	}

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

	ret=InsertInfoIntoKechengTable(kc);
	if( true == ret)
	{
		MessageBox("记录插入成功!");
		m_kcno="";
		m_kcname="";
		m_xuefen=0;
	}
	else
	{
		MessageBox("记录插入失败!");
		return;
	}
	UpdateData(false);
	ReadDb();
}

void CKcDlg::OnDelkcbutton() 
{
	// TODO: Add your control notification handler code here
	KcInfo kc;
	bool        ret;

	UpdateData(true);
	
	strcpy(kc.kc_no,m_kcno);
	if( false == gDBConnected )
	{
		MessageBox("数据库尚未连接!");
		return;
	}
	if(strlen(kc.kc_no)<=0)
	{
		MessageBox("学号不能为空!");
		return;
	}


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

void CKcDlg::OnModkcbutton() 
{
	// TODO: Add your control notification handler code here
	KcInfo kc;
	bool        ret;
	UpdateData(true);
	
	strcpy(kc.kc_no,m_kcno);
	strcpy(kc.kc_name,m_kcname);
	kc.kc_score=m_xuefen;
	if(strlen(kc.kc_no)<=0)
	{
		MessageBox("主码不能为空!");
		return;
	}

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

void CKcDlg::ReadDb()
{
	CADORecordset *pRs=NULL;
	CString kcno,kcname,temp,xuefen;
	char  strSql[400];
	pRs = new CADORecordset(gpDataBase);
	strcpy(strSql,"select * from 课程表");
	if(!pRs) return;
	if(pRs->Open(strSql)==false)
	{
		delete pRs;
		return ;
	}
	//清空表的内容
	m_kclist.DeleteAllItems();
	try
	{
		if(pRs->IsBOF())
		{
			AfxMessageBox("表内数据为空");
			return ;
		}
        else
		{
			pRs->MoveFirst();
		}
		// 读入库中各字段并加入列表框中
		while(!pRs->IsEOF())
		{
			pRs->GetFieldValue("课程号",temp);
			temp.TrimRight();
			kcno=temp;
			pRs->GetFieldValue("课程名",temp);
			temp.TrimRight();
			kcname=temp;
			pRs->GetFieldValue("学分",temp);
			temp.TrimRight();
		    xuefen=temp;
            LV_ITEM l; 
            int index = m_kclist.GetItemCount(); 
            l.mask = LVIF_TEXT; 
            l.iSubItem = 0; 
            l.iItem = index; 
            l.pszText = (char*)(LPCTSTR)kcno; 

            m_kclist.InsertItem(&l); 
  
            m_kclist.SetItemText( index, 1, kcname); 
            m_kclist.SetItemText( index, 2, xuefen); 
			pRs->MoveNext();
		}
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	UpdateData(false);
}

BOOL CKcDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	DWORD dwExStyle=LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP ;  
    m_kclist.SetExtendedStyle(dwExStyle);     
	m_kclist.InsertColumn(0,"学分",LVCFMT_CENTER,80);
	m_kclist.InsertColumn(0,"课程名",LVCFMT_CENTER,80);
	m_kclist.InsertColumn(0,"课程号",LVCFMT_CENTER,80);
   
	ReadDb();

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



void CKcDlg::OnFdkcbutton() 
{
	// TODO: Add your control notification handler code here
    UpdateData(true);
	CString temp;
	char strSql[400];
	long xuefen;
	strcpy(strSql,"select * from 课程表 where 课程号='");
	strcat(strSql,m_kcno);
	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_kcname=temp;
			pRs->GetFieldValue("学分",xuefen);
			temp.TrimRight();
			m_xuefen=xuefen;
		}
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	pRs->Close();
    UpdateData(false);
}

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

	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_kcno=temp;
		
		pRs->GetFieldValue("课程名",temp);
		temp.TrimRight();
		m_kcname=temp;
		
		pRs->GetFieldValue("学分",xuefen);
        m_xuefen=xuefen;

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

	*pResult = 0;
}