学生成绩管理系统(MFC ODBC)

// ADDdlg.cpp : implementation file // #include "stdafx.h" #include "STU.h" #include "ADDdlg.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif extern int i, K; ///////////////////////////////////////////////////////////////////////////// // CADDdlg dialog CADDdlg::CADDdlg(CWnd* pParent /*=NULL*/) : CDialog(CADDdlg::IDD, pParent) { //{{AFX_DATA_INIT(CADDdlg) m_name = _T(""); m_numberstr = _T(""); m_age = _T(""); m_BZR = _T(""); m_beizhu = _T(""); m_bytime = _T(""); m_chushengtime = _T(""); m_class = _T(""); m_zhucetime = _T(""); m_zhuanye = _T(""); m_tpho = _T(""); m_shoufei = 0; m_ruxuetime = _T(""); m_nianji = _T(""); m_family = _T(""); m_dangan = _T(""); m_jiben = new CJIBENdlg; m_sheet1 = new CTabSheet; //}}AFX_DATA_INIT } void CADDdlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CADDdlg) DDX_Control(pDX, IDC_NIANJI, m_nianji1); DDX_Control(pDX, IDC_SNUMBER, m_numberstr1); DDX_Control(pDX, IDC_TPHO, m_tpho1); DDX_Control(pDX, IDC_ZHUANYE, m_zhuanye1); DDX_Control(pDX, IDC_ZHUCETIME, m_zhucetime1); DDX_Control(pDX, IDC_RUXUETIME, m_ruxuetime1); DDX_Control(pDX, IDC_FAMILY, m_family1); DDX_Control(pDX, IDC_DANGAN, m_dangan1); DDX_Control(pDX, IDC_CLASS, m_class1); DDX_Control(pDX, IDC_CHUSHENGTIME, m_chushengtime1); DDX_Control(pDX, IDC_BIYETIME, m_bytime1); DDX_Control(pDX, IDC_AGE, m_age1); DDX_Control(pDX, IDC_BANZHUREN, m_BZR1); DDX_Control(pDX, IDC_BEIZHU, m_beizhu1); DDX_Control(pDX, IDC_NAME, m_name1); DDX_Control(pDX, IDC_LEIXING1, m_leixing); DDX_Control(pDX, IDC_SEX, m_sex); DDX_Control(pDX, IDC_XINGSHI, m_xingshi); DDX_Control(pDX, IDC_XUEXIAO, m_xuexiao); DDX_Control(pDX, IDC_CENGCI2, m_cengci); DDX_Control(pDX, IDC_DELETE, m_delete); DDX_Control(pDX, IDC_EDIT21, m_edit); DDX_Control(pDX, IDC_ADD1, m_add); DDX_Text(pDX, IDC_NAME, m_name); DDX_Text(pDX, IDC_SNUMBER, m_numberstr); DDX_Text(pDX, IDC_AGE, m_age); DDX_Text(pDX, IDC_BANZHUREN, m_BZR); DDX_Text(pDX, IDC_BEIZHU, m_beizhu); DDX_Text(pDX, IDC_BIYETIME, m_bytime); DDX_Text(pDX, IDC_CHUSHENGTIME, m_chushengtime); DDX_Text(pDX, IDC_CLASS, m_class); DDX_Text(pDX, IDC_ZHUCETIME, m_zhucetime); DDX_Text(pDX, IDC_ZHUANYE, m_zhuanye); DDX_Text(pDX, IDC_TPHO, m_tpho); DDX_Text(pDX, IDC_SHOUFEI, m_shoufei); DDV_MinMaxLong(pDX, m_shoufei, 0, 999999); DDX_Text(pDX, IDC_RUXUETIME, m_ruxuetime); DDX_Text(pDX, IDC_NIANJI, m_nianji); DDX_Text(pDX, IDC_FAMILY, m_family); DDX_Text(pDX, IDC_DANGAN, m_dangan); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CADDdlg, CDialog) //{{AFX_MSG_MAP(CADDdlg) ON_BN_CLICKED(IDC_ADD1, OnAdd1) ON_BN_CLICKED(IDC_KONG, OnKong) ON_BN_CLICKED(IDC_EDIT21, OnEdit) ON_BN_CLICKED(IDC_EDIT22, OnShowEdit) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CADDdlg message handlers BOOL CADDdlg::OnInitDialog() { CDialog::OnInitDialog(); // TODO: Add extra initialization here if(K != 2) { m_add.EnableWindow(false); m_delete.EnableWindow(false); m_edit.EnableWindow(false); } m_sex.SetCurSel(0); m_cengci.SetCurSel(0); m_xingshi.SetCurSel(0); m_xuexiao.SetCurSel(0); m_leixing.SetCurSel(0); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void CADDdlg::OnAdd1() { // TODO: Add your control notification handler code here UpdateData(); if((m_name == "")&&(m_numberstr == "")) { MessageBox("学号，姓名不可以为空"); return; } CString s; m_sex.GetLBText(m_sex.GetCurSel(), m_sexstr); m_cengci.GetLBText(m_cengci.GetCurSel(), m_cengcistr); m_xingshi.GetLBText(m_xingshi.GetCurSel(), m_xingshistr); m_xuexiao.GetLBText(m_xuexiao.GetCurSel(), m_xuexiaostr); m_leixing.GetLBText(m_leixing.GetCurSel(), m_leixingstr); addedit(); m_jiben->m_Set.MoveLast(); int column; column = m_jiben->m_ListCtrl.GetItemCount(); m_jiben->m_ListCtrl.InsertItem(column, m_jiben->m_Set.m_column3, 0); m_jiben->m_ListCtrl.SetItemText(column, 1, m_jiben->m_Set.m_column4); m_jiben->m_ListCtrl.SetItemText(column, 2, m_jiben->m_Set.m_column5); m_jiben->m_ListCtrl.SetItemText(column, 3, m_jiben->m_Set.m_column6); m_jiben->m_ListCtrl.SetItemText(column, 4, m_jiben->m_Set.m_column7); m_jiben->m_ListCtrl.SetItemText(column, 5, m_jiben->m_Set.m_column10); m_jiben->m_ListCtrl.SetItemText(column, 6, m_jiben->m_Set.m_column15); m_jiben->m_ListCtrl.SetItemText(column, 7, m_jiben->m_Set.m_column21); m_jiben->m_ListCtrl.SetItemText(column, 8, m_jiben->m_Set.m_column16); m_jiben->m_ListCtrl.SetItemText(column, 9, m_jiben->m_Set.m_column8); m_jiben->m_ListCtrl.SetItemText(column, 10, m_jiben->m_Set.m_column9); m_jiben->m_ListCtrl.SetItemText(column, 11, m_jiben->m_Set.m_column17); s.Format("%d", m_jiben->m_Set.m_column18); m_jiben->m_ListCtrl.SetItemText(column, 12, s); } void CADDdlg::OnKong() { // TODO: Add your control notification handler code here m_age1.SetWindowText(""); m_beizhu1.SetWindowText(""); m_bytime1.SetWindowText(""); m_class1.SetWindowText(""); m_family1.SetWindowText(""); m_dangan1.SetWindowText(""); m_chushengtime1.SetWindowText(""); m_zhucetime1.SetWindowText(""); m_ruxuetime1.SetWindowText(""); m_numberstr1.SetWindowText(""); m_nianji1.SetWindowText(""); m_zhuanye1.SetWindowText(""); m_tpho1.SetWindowText(""); m_name1.SetWindowText(""); m_BZR1.SetWindowText(""); } void CADDdlg::addedit() { // m_sheet1->SetCurSel(0); // m_jiben->ShowWindow(SW_SHOW); m_jiben->m_ListCtrl.EnableWindow(true); CString s, str; // CSTUset m_set; // str.Format("select * from 主体表"); // m_set.Open(AFX_DB_USE_DEFAULT_TYPE, str); m_jiben->m_Set.MoveLast(); long id = 0; m_jiben->m_Set.AddNew(); m_jiben->m_Set.m_column1 = m_ruxuetime; m_jiben->m_Set.m_column2 = m_zhucetime; m_jiben->m_Set.m_column3 = m_numberstr; m_jiben->m_Set.m_column4 = m_name; m_jiben->m_Set.m_column15 = m_nianji; m_jiben->m_Set.m_column16 = m_BZR; m_jiben->m_Set.m_column17 = m_bytime; m_jiben->m_Set.m_column18 = m_shoufei; m_jiben->m_Set.m_column19 = m_dangan; m_jiben->m_Set.m_column20 = m_beizhu; m_jiben->m_Set.m_column21 = m_class; m_jiben->m_Set.m_column6 = m_age; m_jiben->m_Set.m_column7 = m_chushengtime; m_jiben->m_Set.m_column8 = m_tpho; m_jiben->m_Set.m_column9 = m_family; m_jiben->m_Set.m_column10 = m_zhuanye; m_jiben->m_Set.m_column11 = m_leixingstr; m_jiben->m_Set.m_column13 = m_xingshistr; m_jiben->m_Set.m_column14 = m_xuexiaostr; m_jiben->m_Set.m_column12 = m_cengcistr; m_jiben->m_Set.m_column5 = m_sexstr; m_jiben->m_Set.Update(); OnKong(); } void CADDdlg::OnEdit() { // TODO: Add your control notification handler code here UpdateData(); m_sheet1->SetCurSel(0); m_jiben->ShowWindow(SW_SHOW); m_jiben->m_ListCtrl.EnableWindow(true); m_sex.GetLBText(m_sex.GetCurSel(), m_sexstr); m_cengci.GetLBText(m_cengci.GetCurSel(), m_cengcistr); m_xingshi.GetLBText(m_xingshi.GetCurSel(), m_xingshistr); m_xuexiao.GetLBText(m_xuexiao.GetCurSel(), m_xuexiaostr); m_leixing.GetLBText(m_leixing.GetCurSel(), m_leixingstr); CString s; m_jiben->m_Set.Edit(); m_jiben->m_Set.m_column1 = m_ruxuetime; m_jiben->m_Set.m_column2 = m_zhucetime; m_jiben->m_Set.m_column3 = m_numberstr; m_jiben->m_Set.m_column4 = m_name; m_jiben->m_Set.m_column15 = m_nianji; m_jiben->m_Set.m_column16 = m_BZR; m_jiben->m_Set.m_column17 = m_bytime; m_jiben->m_Set.m_column18 = m_shoufei;