📄 成绩管理系统dlg.cpp
字号:
if(zcxlb=="学生资料")
{
m_LB.SetCurSel(0);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.SetRedraw(TRUE);m_list.UpdateData(TRUE);
m_list.InsertColumn(0,"学号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"性别",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"年龄",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(4,"所在系",LVCFMT_LEFT,nWidth);
Readstudent();
}
if(zcxlb=="课程表")
{
m_LB.SetCurSel(1);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.DeleteAllItems();m_list.Update(TRUE);
m_list.InsertColumn(0,"课程号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"课程名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"任课老师",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"学分",LVCFMT_LEFT,nWidth);
Readcourse();
}
if(zcxlb=="选修课成绩表")
{
m_LB.SetCurSel(2);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.InsertColumn(0,"学号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"课程号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"考试成绩",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"平时成绩",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(4,"总评成绩",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(5,"补考",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(6,"重修",LVCFMT_LEFT,nWidth);
ReadSC();
}
}
void CMyDlg::upbukaotongzhi()
{
UpdateData(); // 更新对话框数据
_RecordsetPtr prst=NULL;
prst.CreateInstance(__uuidof(Recordset));
POSITION pos=m_list.GetFirstSelectedItemPosition();
if(pos==NULL)
{
AfxMessageBox("没有选中记录!");
return;
}
CString strSql,xh,xm,szx,kch,kcm,xf,zpcj;
m_STU_XM.GetWindowText(xm);
m_STU_SZX.GetWindowText(szx);
m_KC_KCM.GetWindowText(kcm);
m_KC_XF.GetWindowText(xf);
m_XXQK_XH.GetWindowText(xh);
m_XXQK_KCH.GetWindowText(kch);
try
{
strSql.Format("update v_bukaotongzhi set 姓名='%s',所在系='%s',课程名='%s',学分=%f where 学号=%d and 课程号=%d",
xm,szx,kcm,atof(xf),atoi(xh),atoi(kch));
prst=m_DBCnt->Execute(_bstr_t(strSql),NULL,adCmdText);
Readbukaotongzhi();
MessageBox("修改成功!");
}
catch(_com_error& e)
{
AfxMessageBox("操作异常或者是你所在的用户组无此权限!");
return;
}
}
void CMyDlg::upchongxiutongzhi()
{
}
void CMyDlg::OnMenuCkzl()
{
// TODO: Add your command handler code here
CString lb;
m_LB.GetLBText(m_LB.GetCurSel(),lb);
/////////////////////列表加线和整行选择/////////////////////////////////
LONG lStyle = m_list.SendMessage
(LVM_GETEXTENDEDLISTVIEWSTYLE);
lStyle |= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES|
LVS_EX_HEADERDRAGDROP;
m_list.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0,
(LPARAM)lStyle);
m_list.SetExtendedStyle(lStyle);
/////////////////////////////////////////////////////////////
int nWidth=100;
int nColumnCount = m_list.GetHeaderCtrl()->GetItemCount();
m_dy.EnableWindow(true);
m_LB.SetCurSel(0);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.SetRedraw(TRUE);m_list.UpdateData(TRUE);
m_list.InsertColumn(0,"学号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"性别",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"年龄",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(4,"所在系",LVCFMT_LEFT,nWidth);
Readstudent();
}
void CMyDlg::OnMenuXzzl()
{
// TODO: Add your command handler code here
m_xz.DoModal();
}
void CMyDlg::OnMenuXzcj()
{
// TODO: Add your command handler code here
m_xz.DoModal();
}
void CMyDlg::OnMenuKcXz()
{
// TODO: Add your command handler code here
m_xz.DoModal();
}
void CMyDlg::OnMenuKcYykc()
{
// TODO: Add your command handler code here
CString lb;
m_LB.GetLBText(m_LB.GetCurSel(),lb);
/////////////////////列表加线和整行选择/////////////////////////////////
LONG lStyle = m_list.SendMessage
(LVM_GETEXTENDEDLISTVIEWSTYLE);
lStyle |= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES|
LVS_EX_HEADERDRAGDROP;
m_list.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0,
(LPARAM)lStyle);
m_list.SetExtendedStyle(lStyle);
/////////////////////////////////////////////////////////////
int nWidth=100;
int nColumnCount = m_list.GetHeaderCtrl()->GetItemCount();
m_dy.EnableWindow(true);
m_LB.SetCurSel(1);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.DeleteAllItems();m_list.Update(TRUE);
m_list.InsertColumn(0,"课程号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"课程名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"任课老师",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"学分",LVCFMT_LEFT,nWidth);
Readcourse();
}
void CMyDlg::OnMenuCjbCx()
{
// TODO: Add your command handler code here
CHAXUN dlg;
if(dlg.DoModal()==IDOK)
{
zcxlb=cxlb;
ZSQL=CXSQL;
key=k;
cxinit(ZSQL);
}
}
void CMyDlg::OnMenukcCx()
{
// TODO: Add your command handler code here
CHAXUN dlg;
if(dlg.DoModal()==IDOK)
{
zcxlb=cxlb;
ZSQL=CXSQL;
key=k;
cxinit(ZSQL);
}
}
void CMyDlg::OnMenuCjb()
{
// TODO: Add your command handler code here
CString lb;
m_LB.GetLBText(m_LB.GetCurSel(),lb);
/////////////////////列表加线和整行选择/////////////////////////////////
LONG lStyle = m_list.SendMessage
(LVM_GETEXTENDEDLISTVIEWSTYLE);
lStyle |= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES|
LVS_EX_HEADERDRAGDROP;
m_list.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0,
(LPARAM)lStyle);
m_list.SetExtendedStyle(lStyle);
/////////////////////////////////////////////////////////////
int nWidth=100;
int nColumnCount = m_list.GetHeaderCtrl()->GetItemCount();
m_dy.EnableWindow(true);
m_LB.SetCurSel(2);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.InsertColumn(0,"学号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"课程号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"考试成绩",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"平时成绩",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(4,"总评成绩",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(5,"补考",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(6,"重修",LVCFMT_LEFT,nWidth);
ReadSC();
}
void CMyDlg::OnMenuBktzd()
{
// TODO: Add your command handler code here
CString lb;
m_LB.GetLBText(m_LB.GetCurSel(),lb);
/////////////////////列表加线和整行选择/////////////////////////////////
LONG lStyle = m_list.SendMessage
(LVM_GETEXTENDEDLISTVIEWSTYLE);
lStyle |= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES|
LVS_EX_HEADERDRAGDROP;
m_list.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0,
(LPARAM)lStyle);
m_list.SetExtendedStyle(lStyle);
/////////////////////////////////////////////////////////////
int nWidth=100;
int nColumnCount = m_list.GetHeaderCtrl()->GetItemCount();
m_dy.EnableWindow(true);
m_LB.SetCurSel(3);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.InsertColumn(0,"学号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"所在系",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"课程号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(4,"课程名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(5,"学分",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(6,"成绩",LVCFMT_LEFT,nWidth);
Readbukaotongzhi();
}
void CMyDlg::OnMenuCxtzd()
{
// TODO: Add your command handler code here
CString lb;
m_LB.GetLBText(m_LB.GetCurSel(),lb);
/////////////////////列表加线和整行选择/////////////////////////////////
LONG lStyle = m_list.SendMessage
(LVM_GETEXTENDEDLISTVIEWSTYLE);
lStyle |= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES|
LVS_EX_HEADERDRAGDROP;
m_list.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0,
(LPARAM)lStyle);
m_list.SetExtendedStyle(lStyle);
/////////////////////////////////////////////////////////////
int nWidth=100;
int nColumnCount = m_list.GetHeaderCtrl()->GetItemCount();
m_dy.EnableWindow(true);
m_LB.SetCurSel(4);
for (int i=0;i < nColumnCount;i++)
{
m_list.DeleteColumn(0);
}
Clean();
m_sc.EnableWindow(TRUE);
m_xg.EnableWindow(TRUE);
m_list.EnableWindow(TRUE);
m_list.InsertColumn(0,"学号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(2,"所在系",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(3,"课程号",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(4,"课程名",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(5,"学分",LVCFMT_LEFT,nWidth);
m_list.InsertColumn(6,"成绩",LVCFMT_LEFT,nWidth);
Readchongxiutongzhi();
}
void CMyDlg::OnMenuGy()
{
// TODO: Add your command handler code here
CAboutDlg dlg;
dlg.DoModal();
}
void CMyDlg::OnClose()
{
// TODO: Add your message handler code here and/or call default
if(AfxMessageBox("确定要退出系统吗?",MB_YESNO) == IDYES)
{
CDialog::DestroyWindow();
}
}
void CMyDlg::OnCancel()
{
// TODO: Add extra cleanup here
if(AfxMessageBox("确定要退出系统吗?",MB_YESNO) == IDYES)
{
CDialog::OnCancel();
}
}
int CMyDlg::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
if (CDialog::OnCreate(lpCreateStruct) == -1)
return -1;
// TODO: Add your specialized creation code here
return 0;
}
CString CMyDlg::SplitString(CString &szText, CStringArray &szResult)
{
CString szTemp,s;
int nCount = 0;
for(int i=0; i<szText.GetLength(); i++)
{
if( szText.GetAt(i) !=';' )//separator
{
szTemp += CString( szText.GetAt(i) );
}
else
{
if( !szTemp.IsEmpty() )
{
szResult.SetAtGrow(nCount, szTemp);
nCount++;
szTemp.Empty();
}
}
if( i == szText.GetLength() -1 && !szTemp.IsEmpty() )
{
szResult.SetAtGrow(nCount, szTemp);
nCount++;
}
}
s=szResult.GetAt(3);
return s;
}
CString CMyDlg::SplitStringmm(CString &szText, CStringArray &szResult)
{
CString szTemp,s;
int nCount = 0;
for(int i=0; i<szText.GetLength(); i++)
{
if( szText.GetAt(i) !=';' )//separator
{
szTemp += CString( szText.GetAt(i) );
}
else
{
if( !szTemp.IsEmpty() )
{
szResult.SetAtGrow(nCount, szTemp);
nCount++;
szTemp.Empty();
}
}
if( i == szText.GetLength() -1 && !szTemp.IsEmpty() )
{
szResult.SetAtGrow(nCount, szTemp);
nCount++;
}
}
s=szResult.GetAt(4);
return s;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -