数据库课程设计报告（员工培训管理系统）

}

m_Edit2_cname = _T(\m_Edit3_personid = _T(\m_Edit5_book = _T(\m_Edit6_classroom = _T(\m_Edit8_classtime = _T(\m_Edit4_intro = _T(\m_Edit7_number = _T(\m_Edit9_cscode = _T(\m_Edit10_exam_date = _T(\//}}AFX_DATA_INIT

void DailogForMGcourse::DoDataExchange(CDataExchange* pDX) {

CDialog::DoDataExchange(pDX);

//{{AFX_DATA_MAP(DailogForMGcourse) DDX_Control(pDX, IDC_ADODC1, m_adodc1); DDX_Text(pDX, IDC_EDIT1, m_Edit1_cid); DDX_Text(pDX, IDC_EDIT2, m_Edit2_cname); DDX_Text(pDX, IDC_EDIT3, m_Edit3_personid); DDX_Text(pDX, IDC_EDIT5, m_Edit5_book); DDX_Text(pDX, IDC_EDIT6, m_Edit6_classroom); DDX_Text(pDX, IDC_EDIT8, m_Edit8_classtime); DDX_Text(pDX, IDC_EDIT4, m_Edit4_intro);

}

DDX_Text(pDX, IDC_EDIT7, m_Edit7_number); DDX_Text(pDX, IDC_EDIT9, m_Edit9_cscode); DDX_Text(pDX, IDC_EDIT10, m_Edit10_exam_date); DDX_Control(pDX, IDC_DATAGRID1, m_datagrid1); //}}AFX_DATA_MAP

BEGIN_MESSAGE_MAP(DailogForMGcourse, CDialog)

//{{AFX_MSG_MAP(DailogForMGcourse) ON_BN_CLICKED(IDC_BUTTON1, OnButton1) ON_BN_CLICKED(IDC_BUTTON4, OnInsert) ON_BN_CLICKED(IDC_BUTTON3, OnDEL) ON_BN_CLICKED(IDC_BUTTON2, OnUPDATE) ON_BN_CLICKED(IDC_BUTTON5, OnClear) //}}AFX_MSG_MAP

END_MESSAGE_MAP()

///////////////////////////////////////////////////////////////////////////// // DailogForMGcourse message handlers

void DailogForMGcourse::OnButton1() {

// TODO: Add your control notification handler code here int ok=0;

UpdateData(TRUE);

CString tmpStr, strSQL = \课程号=cid,课程名=cname,老师编号=personid,课程简介

=intro,所用教材=book,上课地点=classroom,课程上限人数=number,开课时间=classtime,状态=cscode,

考试时间=exam_date FROM course WHERE \

if(m_Edit1_cid!=\{ }

if(m_Edit2_cname!=\

if(ok==1) else { }

strSQL += \ok=1;

strSQL += \strSQL += \ok=1;

if(m_Edit3_personid!=\

if(ok==1) else {

strSQL += \strSQL += \

}

ok=1;

if(m_Edit4_intro!=\

if(ok==1) else { }

strSQL += \ok=1;

strSQL += \

if(m_Edit5_book!=\

if(ok==1) else { }

strSQL += \ok=1;

strSQL += \

if(m_Edit6_classroom!=\

if(ok==1) else {

strSQL += \ok=1;

strSQL += \