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

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

数据库系统

开发平台：

Visual C++

MajorDlg.cpp：源码内容
  1. // MajorDlg.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "school.h"
  6. #include "MajorDlg.h"
  7. #include "DepartmentSet.h"
  9. #ifdef _DEBUG
  10. #define new DEBUG_NEW
  11. #undef THIS_FILE
  12. static char THIS_FILE[] = __FILE__;
  13. #endif
  15. /////////////////////////////////////////////////////////////////////////////
  16. // CMajorDlg dialog
  19. CMajorDlg::CMajorDlg(CWnd* pParent /*=NULL*/)
  20. : CDialog(CMajorDlg::IDD, pParent)
  21. {
  22. //{{AFX_DATA_INIT(CMajorDlg)
  23. m_strDepartment = _T("");
  24. m_strCode = _T("");
  25. m_strInfo = _T("");
  26. m_strName = _T("");
  27. //}}AFX_DATA_INIT
  28. }
  31. void CMajorDlg::DoDataExchange(CDataExchange* pDX)
  32. {
  33. CDialog::DoDataExchange(pDX);
  34. //{{AFX_DATA_MAP(CMajorDlg)
  35. DDX_Control(pDX, IDC_COMBO_DEPARTMENT, m_ctrDepartment);
  36. DDX_Control(pDX, IDC_LIST1, m_ctrList);
  37. DDX_Control(pDX, IDC_BUTTON_SAVE, m_bntSave);
  38. DDX_Control(pDX, IDC_BUTTON_NEW, m_bntNew);
  39. DDX_Control(pDX, IDC_BUTTON_MODIFY, m_bntModify);
  40. DDX_Control(pDX, IDC_BUTTON_DELETE, m_bntDelete);
  41. DDX_CBString(pDX, IDC_COMBO_DEPARTMENT, m_strDepartment);
  42. DDX_Text(pDX, IDC_EDIT_CODE, m_strCode);
  43. DDX_Text(pDX, IDC_EDIT_INFO, m_strInfo);
  44. DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
  45. //}}AFX_DATA_MAP
  46. }
  49. BEGIN_MESSAGE_MAP(CMajorDlg, CDialog)
  50. //{{AFX_MSG_MAP(CMajorDlg)
  51. ON_BN_CLICKED(IDC_BUTTON_NEW, OnButtonNew)
  52. ON_BN_CLICKED(IDC_BUTTON_SAVE, OnButtonSave)
  53. ON_BN_CLICKED(IDC_BUTTON_DELETE, OnButtonDelete)
  54. ON_BN_CLICKED(IDC_BUTTON_MODIFY, OnButtonModify)
  55. ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
  56. //}}AFX_MSG_MAP
  57. END_MESSAGE_MAP()
  59. /////////////////////////////////////////////////////////////////////////////
  60. // CMajorDlg message handlers
  62. BOOL CMajorDlg::OnInitDialog() 
  63. {
  64. CDialog::OnInitDialog();
  66. CDepartmentSet DeptSet ;
  67. CString strSQL;
  68. strSQL="select * from department";
  69. if(!DeptSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  70. {
  71. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  73. }
  74. while(!DeptSet.IsEOF())
  75. {
  76. m_ctrDepartment.AddString(DeptSet.m_name);
  77. DeptSet.MoveNext();
  78. }
  79. DeptSet.Close();
  81. m_ctrList.InsertColumn(0,"专业代码");
  82. m_ctrList.InsertColumn(1,"专业名称");
  83. m_ctrList.InsertColumn(2,"所属系别");
  84. m_ctrList.InsertColumn(3,"说明");
  86. m_ctrList.SetColumnWidth(0,60);
  87. m_ctrList.SetColumnWidth(1,120);
  88. m_ctrList.SetColumnWidth(2,120);
  89. m_ctrList.SetColumnWidth(3,160);
  91. m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
  95. //设置按钮状态
  96. m_bntSave.EnableWindow(FALSE);
  97. m_bntNew.EnableWindow(FALSE);
  98. m_bntDelete.EnableWindow(FALSE);
  99. m_bntModify.EnableWindow(FALSE);
  101. RefreshData();
  103. return TRUE;  // return TRUE unless you set the focus to a control
  104.               // EXCEPTION: OCX Property Pages should return FALSE
  105. }
  106. void CMajorDlg::RefreshData()
  107. {
  108. m_ctrList.DeleteAllItems();
  109. m_ctrList.SetRedraw(FALSE);
  111. UpdateData(TRUE);
  112. CString strSQL;
  113. strSQL.Format( "select * from major ");
  114. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  115. {
  116. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  117. return ;
  118. }
  120. int i=0;
  121. while(!m_recordset.IsEOF())
  122. {
  123. m_ctrList.InsertItem(i,m_recordset.m_code);
  124. m_ctrList.SetItemText(i,1,m_recordset.m_name);
  125. m_ctrList.SetItemText(i,2,m_recordset.m_department);
  126. m_ctrList.SetItemText(i,3,m_recordset.m_brief);
  127. i++;
  128. m_recordset.MoveNext();
  129. }
  130. m_recordset.Close();
  131. m_ctrList.SetRedraw(TRUE);
  132. //设置按钮状态
  133. m_bntSave.EnableWindow(FALSE);
  134. m_bntNew.EnableWindow();
  135. m_bntDelete.EnableWindow(FALSE);
  136. m_bntModify.EnableWindow(FALSE);
  137. }
  138. void CMajorDlg::OnButtonNew() 
  139. {
  140. // TODO: Add your control notification handler code here
  141. m_strName = "";
  142. m_strCode = "";
  143. m_strDepartment = "";
  144. m_strInfo = "";
  146. m_bntSave.EnableWindow();
  147. m_bntNew.EnableWindow(FALSE);
  148. m_bntDelete.EnableWindow(FALSE);
  149. m_bntModify.EnableWindow(FALSE);
  150. UpdateData(FALSE);
  151. }
  153. void CMajorDlg::OnButtonSave() 
  154. {
  155. // TODO: Add your control notification handler code here
  156. UpdateData();
  159. if(m_strName=="")
  160. {
  161. AfxMessageBox("请输入专业名称！");
  162. return;
  163. }
  164. if(m_strCode=="")
  165. {
  166. AfxMessageBox("请输入专业代码！");
  167. return;
  168. }
  169. if(m_strDepartment=="")
  170. {
  171. AfxMessageBox("请输入所属系别！");
  172. return;
  173. }
  176. CString strSQL;
  178. strSQL.Format("select * from major where code='%s'",m_strCode);
  179. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  180. {
  181. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  182. return ;
  183. }
  184. if( m_recordset.GetRecordCount()!=0)
  185. {
  186. AfxMessageBox("当前编码已经存在！请重新输入！");
  187. m_strCode = "";
  188. UpdateData(FALSE);
  189. m_recordset.Close();
  190. return;
  191. }
  193. m_recordset.AddNew();
  194. m_recordset.m_name = m_strName ;
  195. m_recordset.m_code = m_strCode ;
  196. m_recordset.m_department= m_strDepartment ;
  197. m_recordset.m_brief = m_strInfo ;
  198. m_recordset.Update();
  200. m_recordset.Close();
  202. RefreshData();
  203. }
  205. void CMajorDlg::OnButtonDelete() 
  206. {
  207. // TODO: Add your control notification handler code here
  208. int i = m_ctrList.GetSelectionMark();
  209. if(0>i)
  210. {
  211. MessageBox("请选择一条记录进行删除！");
  212. return;
  213. }
  215. CString strSQL;
  216. strSQL.Format("select * from major where code= '%s' ",m_ctrList.GetItemText(i,0));
  217. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  218. {
  219. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  220. return ;
  221. }
  222. //删除该记录
  223. m_recordset.Delete();
  224. m_recordset.Close();
  226. //更新用户界面
  227. RefreshData();
  229. m_strName = "";
  230. m_strCode = "";
  231. m_strDepartment = "";
  232. m_strInfo = "";
  233. UpdateData(FALSE);
  234. }
  236. void CMajorDlg::OnButtonModify() 
  237. {
  238. // TODO: Add your control notification handler code here
  239. UpdateData();
  240. int i = m_ctrList.GetSelectionMark();
  241. if(0>i)
  242. {
  243. MessageBox("请选择一条记录进行修改！");
  244. return;
  245. }
  247. if(m_strName=="")
  248. {
  249. AfxMessageBox("请输入专业名称！");
  250. return;
  251. }
  252. if(m_strCode=="")
  253. {
  254. AfxMessageBox("请输入专业代码！");
  255. return;
  256. }
  257. if(m_strDepartment=="")
  258. {
  259. AfxMessageBox("请输入所属系别！");
  260. return;
  261. }
  263. CString strSQL;
  264. strSQL.Format("select * from major where code= '%s' ",m_ctrList.GetItemText(i,0));
  265. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  266. {
  267. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  268. return ;
  269. }
  270. m_recordset.Edit();
  271. m_recordset.m_name = m_strName ;
  272. m_recordset.m_code = m_strCode ;
  273. m_recordset.m_department= m_strDepartment ;
  274. m_recordset.m_brief = m_strInfo ;
  275. m_recordset.Update();
  277. m_recordset.Close();
  279. RefreshData();
  280. }
  282. void CMajorDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
  283. {
  284. // TODO: Add your control notification handler code here
  285. CString strSQL;
  286. UpdateData(TRUE);
  287. int i = m_ctrList.GetSelectionMark();
  288. strSQL.Format("select * from major where code='%s'",m_ctrList.GetItemText(i,0));
  289. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  290. {
  291. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  292. return ;
  293. }
  294. m_strName = m_recordset.m_name;
  295. m_strCode = m_recordset.m_code;
  296. m_strDepartment = m_recordset.m_department;
  297. m_strInfo = m_recordset.m_brief;
  299. m_recordset.Close();
  301. UpdateData(FALSE);
  302. m_bntSave.EnableWindow(FALSE);
  303. m_bntNew.EnableWindow();
  304. m_bntDelete.EnableWindow();
  305. m_bntModify.EnableWindow();
  306. *pResult = 0;
  307. }