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

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

数据库系统

开发平台：

Visual C++

ScoreInputDlg.cpp：源码内容
  1. // ScoreInputDlg.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "school.h"
  6. #include "ScoreInputDlg.h"
  7. #include "classset.h"
  8. #include "examtimeset.h"
  9. #include "examsubjectset.h"
  10. #include "examtypeset.h"
  11. #include "StudentSet.h"
  12. #include "scoredlg.h"
  13. #ifdef _DEBUG
  14. #define new DEBUG_NEW
  15. #undef THIS_FILE
  16. static char THIS_FILE[] = __FILE__;
  17. #endif
  19. /////////////////////////////////////////////////////////////////////////////
  20. // CScoreInputDlg dialog
  23. CScoreInputDlg::CScoreInputDlg(CWnd* pParent /*=NULL*/)
  24. : CDialog(CScoreInputDlg::IDD, pParent)
  25. {
  26. //{{AFX_DATA_INIT(CScoreInputDlg)
  27. m_strClass = _T("");
  28. m_strSubject = _T("");
  29. m_strTime = _T("");
  30. m_strType = _T("");
  31. //}}AFX_DATA_INIT
  32. }
  35. void CScoreInputDlg::DoDataExchange(CDataExchange* pDX)
  36. {
  37. CDialog::DoDataExchange(pDX);
  38. //{{AFX_DATA_MAP(CScoreInputDlg)
  39. DDX_Control(pDX, IDC_COMBO_TYPE, m_ctrType);
  40. DDX_Control(pDX, IDC_COMBO_TIME, m_ctrTime);
  41. DDX_Control(pDX, IDC_COMBO_SUBJECT, m_ctrSubject);
  42. DDX_Control(pDX, IDC_COMBO_CLASS, m_ctrClass);
  43. DDX_Control(pDX, IDC_LIST2, m_ctrList);
  44. DDX_CBString(pDX, IDC_COMBO_CLASS, m_strClass);
  45. DDX_CBString(pDX, IDC_COMBO_SUBJECT, m_strSubject);
  46. DDX_CBString(pDX, IDC_COMBO_TIME, m_strTime);
  47. DDX_CBString(pDX, IDC_COMBO_TYPE, m_strType);
  48. //}}AFX_DATA_MAP
  49. }
  52. BEGIN_MESSAGE_MAP(CScoreInputDlg, CDialog)
  53. //{{AFX_MSG_MAP(CScoreInputDlg)
  54. ON_BN_CLICKED(IDC_BUTTON_INPUT, OnButtonInput)
  55. ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
  56. //}}AFX_MSG_MAP
  57. END_MESSAGE_MAP()
  59. /////////////////////////////////////////////////////////////////////////////
  60. // CScoreInputDlg message handlers
  62. void CScoreInputDlg::OnButtonInput() 
  63. {
  64. // TODO: Add your control notification handler code here
  65. UpdateData();
  66. if(m_strClass.IsEmpty())
  67. {
  68. AfxMessageBox("请选择班级");
  69. return;
  70. }
  71. if(m_strTime.IsEmpty())
  72. {
  73. AfxMessageBox("请选择考试时间段");
  74. return;
  75. }
  76. if(m_strType.IsEmpty())
  77. {
  78. AfxMessageBox("请选择考试类型");
  79. return;
  80. }
  81. if(m_strSubject.IsEmpty())
  82. {
  83. AfxMessageBox("请选择考试科目");
  84. return;
  85. }
  87. CString strSQL;
  88. strSQL.Format("select * from score 
  89. where class = '%s' and time = '%s' 
  90. and type = '%s' and subject = '%s'"
  91. ,m_strClass,m_strTime,m_strType,m_strSubject);
  93. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  94. {
  95. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  96. return ;
  97. }
  98. if(m_recordset.GetRecordCount()==0)
  99. {
  100. m_recordset.Close();
  101. CreateScoreTable();
  102. }
  103. else
  104. {
  105. m_recordset.Close();
  106. }
  107. RefreshData(strSQL);
  108. }
  109. void CScoreInputDlg::CreateScoreTable()
  110. {
  111. CString strSQL;
  112. CStudentSet StudentSet;
  113. strSQL.Format("select * from student where class = '%s'",m_strClass);
  114. if(!StudentSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  115. {
  116. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  117. return ;
  118. }
  119. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE))
  120. {
  121. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  122. return ;
  123. }
  124. while(!StudentSet.IsEOF())
  125. {
  126. m_recordset.AddNew();
  127. m_recordset.m_code = StudentSet.m_code;
  128. m_recordset.m_class = m_strClass;
  129. m_recordset.m_name = StudentSet.m_name;
  130. m_recordset.m_subject = m_strSubject;
  131. m_recordset.m_time = m_strTime;
  132. m_recordset.m_type = m_strType;
  133. m_recordset.Update();
  134. StudentSet.MoveNext();
  135. }
  136. m_recordset.Close();
  137. StudentSet.Close();
  138. }
  139. void CScoreInputDlg::RefreshData(CString strSQL)
  140. {
  141. m_ctrList.DeleteAllItems();
  142. m_ctrList.SetRedraw(FALSE);
  144. UpdateData(TRUE);
  146. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  147. {
  148. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  149. return ;
  150. }
  152. int i=0;
  153. char buffer[20];
  154. while(!m_recordset.IsEOF())
  155. {
  156. _ltoa(m_recordset.m_ID,buffer,10);
  157. m_ctrList.InsertItem(i,buffer);
  158. m_ctrList.SetItemText(i,1,m_recordset.m_code);
  159. m_ctrList.SetItemText(i,2,m_recordset.m_name);
  160. m_ctrList.SetItemText(i,3,m_recordset.m_subject);
  161. _ltoa(m_recordset.m_score,buffer,10);
  162. m_ctrList.SetItemText(i,4,buffer);
  163. _ltoa(m_recordset.m_makeup_score,buffer,10);
  164. m_ctrList.SetItemText(i,5,buffer);
  165. m_ctrList.SetItemText(i,6,m_recordset.m_absent);
  166. i++;
  167. m_recordset.MoveNext();
  168. }
  169. m_recordset.Close();
  170. m_ctrList.SetRedraw(TRUE);
  172. }
  174. BOOL CScoreInputDlg::OnInitDialog() 
  175. {
  176. CDialog::OnInitDialog();
  178. CString strSQL;
  179. //初始化班级
  180. CClassSet ClassSet ;
  181. strSQL="select * from class";
  182. if(!ClassSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  183. {
  184. AfxMessageBox("打开数据库失败!");
  185. }
  186. while(!ClassSet.IsEOF())
  187. {
  188. m_ctrClass.AddString(ClassSet.m_code);
  189. ClassSet.MoveNext();
  190. }
  191. ClassSet.Close();
  192. //初始化时间段
  193. CExamtimeSet TimeSet ;
  194. strSQL="select * from examtime";
  195. if(!TimeSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  196. {
  197. AfxMessageBox("打开数据库失败!");
  198. }
  199. while(!TimeSet.IsEOF())
  200. {
  201. m_ctrTime.AddString(TimeSet.m_time);
  202. TimeSet.MoveNext();
  203. }
  204. TimeSet.Close();
  205. //初始化考试类型
  206. CExamtypeSet TypeSet ;
  207. strSQL="select * from examtype";
  208. if(!TypeSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  209. {
  210. AfxMessageBox("打开数据库失败!");
  211. }
  212. while(!TypeSet.IsEOF())
  213. {
  214. m_ctrType.AddString(TypeSet.m_name);
  215. TypeSet.MoveNext();
  216. }
  217. TypeSet.Close();
  218. //初始化考试科目
  219. CExamSubjectSet SubjectSet ;
  220. strSQL="select * from examsubject";
  221. if(!SubjectSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  222. {
  223. AfxMessageBox("打开数据库失败!");
  224. }
  225. while(!SubjectSet.IsEOF())
  226. {
  227. m_ctrSubject.AddString(SubjectSet.m_name);
  228. SubjectSet.MoveNext();
  229. }
  230. SubjectSet.Close();
  232. //初始化成绩列表
  233. m_ctrList.InsertColumn(0,"序号");
  234. m_ctrList.InsertColumn(1,"学号");
  235. m_ctrList.InsertColumn(2,"姓名");
  236. m_ctrList.InsertColumn(3,"科目");
  237. m_ctrList.InsertColumn(4,"成绩");
  238. m_ctrList.InsertColumn(5,"补考成绩");
  239. m_ctrList.InsertColumn(6,"缺考标志");
  241. m_ctrList.SetColumnWidth(0,60);
  242. m_ctrList.SetColumnWidth(1,80);
  243. m_ctrList.SetColumnWidth(2,80);
  244. m_ctrList.SetColumnWidth(3,100);
  245. m_ctrList.SetColumnWidth(4,80);
  246. m_ctrList.SetColumnWidth(5,80);
  247. m_ctrList.SetColumnWidth(6,60);
  249. m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
  251. return TRUE;  // return TRUE unless you set the focus to a control
  252.               // EXCEPTION: OCX Property Pages should return FALSE
  253. }
  255. void CScoreInputDlg::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult) 
  256. {
  257. // TODO: Add your control notification handler code here
  258. CString strSQL;
  259. long score=0,makeup=0;
  260. CScoreDlg Dlg;
  262. UpdateData(TRUE);
  263. int i = m_ctrList.GetSelectionMark();
  264. if(i<0) return;
  265. if(IDOK!=Dlg.DoModal())
  266. {
  267. return;
  268. }
  269. if(!Dlg.m_strScore.IsEmpty())
  270. score = atol(Dlg.m_strScore);
  271. if(!Dlg.m_strMakeup.IsEmpty())
  272. makeup = atol(Dlg.m_strMakeup);
  274. strSQL.Format("select * from score where ID=%s",m_ctrList.GetItemText(i,0));
  275. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  276. {
  277. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  278. return ;
  279. }
  280. m_recordset.Edit();
  281. if(Dlg.m_bAbsent)
  282. m_recordset.m_absent = "是";
  283. m_recordset.m_score = score;
  284. m_recordset.m_makeup_score = makeup;
  285. m_recordset.Update();
  286. char buffer[20];
  287. _ltoa(m_recordset.m_score,buffer,10);
  288. m_ctrList.SetItemText(i,4,buffer);
  289. _ltoa(m_recordset.m_makeup_score,buffer,10);
  290. m_ctrList.SetItemText(i,5,buffer);
  291. m_ctrList.SetItemText(i,6,m_recordset.m_absent);
  292. m_recordset.Close();
  293. *pResult = 0;
  294. }