开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 查看源码
ClassDlg.cpp
资源名称：school.rar　[点击查看]
上传用户：rs600066
上传日期：2017-10-16
资源大小：4788k
文件大小：8k
源码类别：

数据库系统

开发平台：

Visual C++

ClassDlg.cpp：源码内容
  1. // ClassDlg.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "school.h"
  6. #include "ClassDlg.h"
  7. #include "departmentset.h"
  8. #include "majorset.h"
  11. #ifdef _DEBUG
  12. #define new DEBUG_NEW
  13. #undef THIS_FILE
  14. static char THIS_FILE[] = __FILE__;
  15. #endif
  17. /////////////////////////////////////////////////////////////////////////////
  18. // CClassDlg dialog
  21. CClassDlg::CClassDlg(CWnd* pParent /*=NULL*/)
  22. : CDialog(CClassDlg::IDD, pParent)
  23. {
  24. //{{AFX_DATA_INIT(CClassDlg)
  25. m_strDepartment = _T("");
  26. m_strMajor = _T("");
  27. m_strCode = _T("");
  28. m_strInfo = _T("");
  29. m_strName = _T("");
  30. m_strTeacher = _T("");
  31. //}}AFX_DATA_INIT
  32. }
  35. void CClassDlg::DoDataExchange(CDataExchange* pDX)
  36. {
  37. CDialog::DoDataExchange(pDX);
  38. //{{AFX_DATA_MAP(CClassDlg)
  39. DDX_Control(pDX, IDC_LIST1, m_ctrList);
  40. DDX_Control(pDX, IDC_COMBO_MAJOR, m_ctrMajor);
  41. DDX_Control(pDX, IDC_COMBO_DEPARTMENT, m_ctrDepartment);
  42. DDX_Control(pDX, IDC_BUTTON_SAVE, m_bntSave);
  43. DDX_Control(pDX, IDC_BUTTON_NEW, m_bntNew);
  44. DDX_Control(pDX, IDC_BUTTON_MODIFY, m_bntModify);
  45. DDX_Control(pDX, IDC_BUTTON_DELETE, m_bntDelete);
  46. DDX_CBString(pDX, IDC_COMBO_DEPARTMENT, m_strDepartment);
  47. DDX_CBString(pDX, IDC_COMBO_MAJOR, m_strMajor);
  48. DDX_Text(pDX, IDC_EDIT_CODE, m_strCode);
  49. DDX_Text(pDX, IDC_EDIT_INFO, m_strInfo);
  50. DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
  51. DDX_Text(pDX, IDC_EDIT_TEACHER, m_strTeacher);
  52. //}}AFX_DATA_MAP
  53. }
  56. BEGIN_MESSAGE_MAP(CClassDlg, CDialog)
  57. //{{AFX_MSG_MAP(CClassDlg)
  58. ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
  59. ON_BN_CLICKED(IDC_BUTTON_NEW, OnButtonNew)
  60. ON_BN_CLICKED(IDC_BUTTON_SAVE, OnButtonSave)
  61. ON_BN_CLICKED(IDC_BUTTON_MODIFY, OnButtonModify)
  62. ON_BN_CLICKED(IDC_BUTTON_DELETE, OnButtonDelete)
  63. //}}AFX_MSG_MAP
  64. END_MESSAGE_MAP()
  66. /////////////////////////////////////////////////////////////////////////////
  67. // CClassDlg message handlers
  69. BOOL CClassDlg::OnInitDialog() 
  70. {
  71. CDialog::OnInitDialog();
  73. CDepartmentSet DeptSet ;
  74. CString strSQL;
  75. strSQL="select * from department";
  76. if(!DeptSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  77. {
  78. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  80. }
  81. while(!DeptSet.IsEOF())
  82. {
  83. m_ctrDepartment.AddString(DeptSet.m_name);
  84. DeptSet.MoveNext();
  85. }
  86. DeptSet.Close();
  88. CMajorSet MajorSet ;
  89. strSQL="select * from major";
  90. if(!MajorSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  91. {
  92. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  94. }
  95. while(!MajorSet.IsEOF())
  96. {
  97. m_ctrMajor.AddString(MajorSet.m_name);
  98. MajorSet.MoveNext();
  99. }
  100. MajorSet.Close();
  102. m_ctrList.InsertColumn(0,"班级代码");
  103. m_ctrList.InsertColumn(1,"班级名称");
  104. m_ctrList.InsertColumn(2,"所属系别");
  105. m_ctrList.InsertColumn(3,"所属专业");
  106. m_ctrList.InsertColumn(4,"辅导员");
  107. m_ctrList.InsertColumn(5,"说明");
  109. m_ctrList.SetColumnWidth(0,60);
  110. m_ctrList.SetColumnWidth(1,100);
  111. m_ctrList.SetColumnWidth(2,100);
  112. m_ctrList.SetColumnWidth(3,100);
  113. m_ctrList.SetColumnWidth(4,100);
  114. m_ctrList.SetColumnWidth(5,160);
  116. m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
  120. //设置按钮状态
  121. m_bntSave.EnableWindow(FALSE);
  122. m_bntNew.EnableWindow(FALSE);
  123. m_bntDelete.EnableWindow(FALSE);
  124. m_bntModify.EnableWindow(FALSE);
  126. RefreshData();
  128. return TRUE;  // return TRUE unless you set the focus to a control
  129.               // EXCEPTION: OCX Property Pages should return FALSE
  130. }
  132. void CClassDlg::RefreshData()
  133. {
  134. m_ctrList.DeleteAllItems();
  135. m_ctrList.SetRedraw(FALSE);
  137. UpdateData(TRUE);
  138. CString strSQL;
  139. strSQL.Format( "select * from class ");
  140. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  141. {
  142. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  143. return ;
  144. }
  146. int i=0;
  147. while(!m_recordset.IsEOF())
  148. {
  149. m_ctrList.InsertItem(i,m_recordset.m_code);
  150. m_ctrList.SetItemText(i,1,m_recordset.m_name);
  151. m_ctrList.SetItemText(i,2,m_recordset.m_department);
  152. m_ctrList.SetItemText(i,3,m_recordset.m_major);
  153. m_ctrList.SetItemText(i,4,m_recordset.m_techer);
  154. m_ctrList.SetItemText(i,5,m_recordset.m_brief);
  155. i++;
  156. m_recordset.MoveNext();
  157. }
  158. m_recordset.Close();
  159. m_ctrList.SetRedraw(TRUE);
  160. //设置按钮状态
  161. m_bntSave.EnableWindow(FALSE);
  162. m_bntNew.EnableWindow();
  163. m_bntDelete.EnableWindow(FALSE);
  164. m_bntModify.EnableWindow(FALSE);
  165. }
  167. void CClassDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
  168. {
  169. // TODO: Add your control notification handler code here
  170. CString strSQL;
  171. UpdateData(TRUE);
  172. int i = m_ctrList.GetSelectionMark();
  173. strSQL.Format("select * from class where code='%s'",m_ctrList.GetItemText(i,0));
  174. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  175. {
  176. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  177. return ;
  178. }
  179. m_strName = m_recordset.m_name;
  180. m_strCode = m_recordset.m_code;
  181. m_strDepartment = m_recordset.m_department;
  182. m_strMajor = m_recordset.m_major;
  183. m_strTeacher = m_recordset.m_techer;
  184. m_strInfo = m_recordset.m_brief;
  186. m_recordset.Close();
  188. UpdateData(FALSE);
  189. m_bntSave.EnableWindow(FALSE);
  190. m_bntNew.EnableWindow();
  191. m_bntDelete.EnableWindow();
  192. m_bntModify.EnableWindow();
  193. *pResult = 0;
  194. }
  196. void CClassDlg::OnButtonNew() 
  197. {
  198. // TODO: Add your control notification handler code here
  199. m_strName = "";
  200. m_strCode = "";
  201. m_strDepartment = "";
  202. m_strMajor = "";
  203. m_strTeacher="";
  204. m_strInfo = "";
  206. m_bntSave.EnableWindow();
  207. m_bntNew.EnableWindow(FALSE);
  208. m_bntDelete.EnableWindow(FALSE);
  209. m_bntModify.EnableWindow(FALSE);
  210. UpdateData(FALSE);
  211. }
  213. void CClassDlg::OnButtonSave() 
  214. {
  215. // TODO: Add your control notification handler code here
  216. UpdateData();
  219. if(m_strName=="")
  220. {
  221. AfxMessageBox("请输入班级名称！");
  222. return;
  223. }
  224. if(m_strCode=="")
  225. {
  226. AfxMessageBox("请输入班级代码！");
  227. return;
  228. }
  229. if(m_strDepartment=="")
  230. {
  231. AfxMessageBox("请输入所属系别！");
  232. return;
  233. }
  234. if(m_strMajor=="")
  235. {
  236. AfxMessageBox("请输入所属专业！");
  237. return;
  238. }
  241. CString strSQL;
  243. strSQL.Format("select * from class where code='%s'",m_strCode);
  244. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  245. {
  246. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  247. return ;
  248. }
  249. if( m_recordset.GetRecordCount()!=0)
  250. {
  251. AfxMessageBox("当前编码已经存在！请重新输入！");
  252. m_strCode = "";
  253. UpdateData(FALSE);
  254. m_recordset.Close();
  255. return;
  256. }
  258. m_recordset.AddNew();
  259. m_recordset.m_name = m_strName ;
  260. m_recordset.m_code = m_strCode ;
  261. m_recordset.m_department= m_strDepartment ;
  262. m_recordset.m_major = m_strMajor ;
  263. m_recordset.m_techer = m_strTeacher ;
  264. m_recordset.m_brief = m_strInfo ;
  265. m_recordset.Update();
  267. m_recordset.Close();
  269. RefreshData();
  270. }
  272. void CClassDlg::OnButtonModify() 
  273. {
  274. // TODO: Add your control notification handler code here
  275. UpdateData();
  276. int i = m_ctrList.GetSelectionMark();
  277. if(0>i)
  278. {
  279. MessageBox("请选择一条记录进行修改！");
  280. return;
  281. }
  283. if(m_strName=="")
  284. {
  285. AfxMessageBox("请输入班级名称！");
  286. return;
  287. }
  288. if(m_strCode=="")
  289. {
  290. AfxMessageBox("请输入班级代码！");
  291. return;
  292. }
  293. if(m_strDepartment=="")
  294. {
  295. AfxMessageBox("请输入所属系别！");
  296. return;
  297. }
  298. if(m_strMajor=="")
  299. {
  300. AfxMessageBox("请输入所属专业！");
  301. return;
  302. }
  304. CString strSQL;
  305. strSQL.Format("select * from class where code= '%s' ",m_ctrList.GetItemText(i,0));
  306. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  307. {
  308. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  309. return ;
  310. }
  311. m_recordset.Edit();
  312. m_recordset.m_name = m_strName ;
  313. m_recordset.m_code = m_strCode ;
  314. m_recordset.m_department= m_strDepartment ;
  315. m_recordset.m_major = m_strMajor ;
  316. m_recordset.m_techer = m_strTeacher ;
  317. m_recordset.m_brief = m_strInfo ;
  318. m_recordset.Update();
  320. m_recordset.Close();
  322. RefreshData();
  323. }
  325. void CClassDlg::OnButtonDelete() 
  326. {
  327. // TODO: Add your control notification handler code here
  328. int i = m_ctrList.GetSelectionMark();
  329. if(0>i)
  330. {
  331. MessageBox("请选择一条记录进行删除！");
  332. return;
  333. }
  335. CString strSQL;
  336. strSQL.Format("select * from class where code= '%s' ",m_ctrList.GetItemText(i,0));
  337. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  338. {
  339. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  340. return ;
  341. }
  342. //删除该记录
  343. m_recordset.Delete();
  344. m_recordset.Close();
  346. //更新用户界面
  347. RefreshData();
  349. m_strName = "";
  350. m_strCode = "";
  351. m_strDepartment = "";
  352. m_strMajor = "";
  353. m_strTeacher = "";
  354. m_strInfo = "";
  355. UpdateData(FALSE);
  356. }