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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 企业管理 > 查看源码
CourseElect.cs
资源名称：VCSDB.rar　[点击查看]
上传用户：hjieqiu
上传日期：2013-05-11
资源大小：16494k
文件大小：20k
源码类别：

企业管理

开发平台：

C#

CourseElect.cs：源码内容
  1. using System;
  2. using System.Drawing;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.Windows.Forms;
  6. using System.Data;
  7. using System.Data.SqlClient;
  9. namespace 教务管理系统
  10. {
  11. /// <summary>
  12. /// CourseElect 的摘要说明。
  13. /// </summary>
  14. public class CourseElect : System.Windows.Forms.Form
  15. {
  16. private DataTable electTable=new DataTable();//保存学生的选课信息
  17. private DataTable courseTable=new DataTable();//保存可选课程信息
  18. private DataView dv;//可选课程的视图
  19. private string studentID;//保存选课的学生信息
  20. private string stduentName;//选课的学生的姓名
  21. private System.Windows.Forms.GroupBox groupBox1;
  22. private System.Windows.Forms.DataGrid dataGrid1;
  23. private System.Windows.Forms.GroupBox groupBox2;
  24. private System.Windows.Forms.GroupBox groupBox3;
  25. private System.Windows.Forms.DataGrid dataGrid2;
  26. private System.Windows.Forms.Label label1;
  27. private System.Windows.Forms.TextBox txt1;
  28. private System.Windows.Forms.TextBox txt2;
  29. private System.Windows.Forms.Label label2;
  30. private System.Windows.Forms.TextBox txt3;
  31. private System.Windows.Forms.Label label4;
  32. private System.Windows.Forms.Label label3;
  33. private System.Windows.Forms.Label label5;
  34. private System.Windows.Forms.Label label6;
  35. private System.Windows.Forms.Label label7;
  36. private System.Windows.Forms.TextBox txt4;
  37. private System.Windows.Forms.TextBox txt5;
  38. private System.Windows.Forms.TextBox txt6;
  39. private System.Windows.Forms.TextBox txt7;
  40. private System.Windows.Forms.Button btnSearch;
  41. private System.Windows.Forms.Button btnElect;
  42. private System.Windows.Forms.Button btnDelete;
  43. private System.Windows.Forms.Button btnView;
  44. /// <summary>
  45. /// 必需的设计器变量。
  46. /// </summary>
  47. private System.ComponentModel.Container components = null;
  49. public CourseElect()
  50. {
  51. //
  52. // Windows 窗体设计器支持所必需的
  53. //
  54. InitializeComponent();
  56. //
  57. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  58. //
  59. }
  61. /// <summary>
  62. /// 清理所有正在使用的资源。
  63. /// </summary>
  64. protected override void Dispose( bool disposing )
  65. {
  66. if( disposing )
  67. {
  68. if(components != null)
  69. {
  70. components.Dispose();
  71. }
  72. }
  73. base.Dispose( disposing );
  74. }
  76. #region Windows 窗体设计器生成的代码
  77. /// <summary>
  78. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  79. /// 此方法的内容。
  80. /// </summary>
  81. private void InitializeComponent()
  82. {
  83. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(CourseElect));
  84. this.groupBox1 = new System.Windows.Forms.GroupBox();
  85. this.txt1 = new System.Windows.Forms.TextBox();
  86. this.label1 = new System.Windows.Forms.Label();
  87. this.txt2 = new System.Windows.Forms.TextBox();
  88. this.label2 = new System.Windows.Forms.Label();
  89. this.txt3 = new System.Windows.Forms.TextBox();
  90. this.label4 = new System.Windows.Forms.Label();
  91. this.dataGrid1 = new System.Windows.Forms.DataGrid();
  92. this.groupBox2 = new System.Windows.Forms.GroupBox();
  93. this.dataGrid2 = new System.Windows.Forms.DataGrid();
  94. this.groupBox3 = new System.Windows.Forms.GroupBox();
  95. this.txt4 = new System.Windows.Forms.TextBox();
  96. this.label3 = new System.Windows.Forms.Label();
  97. this.btnSearch = new System.Windows.Forms.Button();
  98. this.btnElect = new System.Windows.Forms.Button();
  99. this.btnDelete = new System.Windows.Forms.Button();
  100. this.btnView = new System.Windows.Forms.Button();
  101. this.label5 = new System.Windows.Forms.Label();
  102. this.txt5 = new System.Windows.Forms.TextBox();
  103. this.label6 = new System.Windows.Forms.Label();
  104. this.txt6 = new System.Windows.Forms.TextBox();
  105. this.txt7 = new System.Windows.Forms.TextBox();
  106. this.label7 = new System.Windows.Forms.Label();
  107. this.groupBox1.SuspendLayout();
  108. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
  109. this.groupBox2.SuspendLayout();
  110. ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit();
  111. this.groupBox3.SuspendLayout();
  112. this.SuspendLayout();
  113. // 
  114. // groupBox1
  115. // 
  116. this.groupBox1.Controls.Add(this.txt1);
  117. this.groupBox1.Controls.Add(this.label1);
  118. this.groupBox1.Controls.Add(this.txt2);
  119. this.groupBox1.Controls.Add(this.label2);
  120. this.groupBox1.Controls.Add(this.txt3);
  121. this.groupBox1.Controls.Add(this.label4);
  122. this.groupBox1.Location = new System.Drawing.Point(0, 3);
  123. this.groupBox1.Name = "groupBox1";
  124. this.groupBox1.Size = new System.Drawing.Size(696, 53);
  125. this.groupBox1.TabIndex = 0;
  126. this.groupBox1.TabStop = false;
  127. this.groupBox1.Text = "学生信息";
  128. // 
  129. // txt1
  130. // 
  131. this.txt1.Location = new System.Drawing.Point(88, 24);
  132. this.txt1.Name = "txt1";
  133. this.txt1.TabIndex = 1;
  134. this.txt1.Text = "";
  135. this.txt1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txt1_KeyPress);
  136. // 
  137. // label1
  138. // 
  139. this.label1.Location = new System.Drawing.Point(40, 28);
  140. this.label1.Name = "label1";
  141. this.label1.Size = new System.Drawing.Size(48, 16);
  142. this.label1.TabIndex = 0;
  143. this.label1.Text = "学号";
  144. this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
  145. // 
  146. // txt2
  147. // 
  148. this.txt2.Location = new System.Drawing.Point(272, 24);
  149. this.txt2.Name = "txt2";
  150. this.txt2.ReadOnly = true;
  151. this.txt2.TabIndex = 1;
  152. this.txt2.Text = "";
  153. // 
  154. // label2
  155. // 
  156. this.label2.Location = new System.Drawing.Point(224, 28);
  157. this.label2.Name = "label2";
  158. this.label2.Size = new System.Drawing.Size(48, 16);
  159. this.label2.TabIndex = 0;
  160. this.label2.Text = "姓名";
  161. this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
  162. // 
  163. // txt3
  164. // 
  165. this.txt3.Location = new System.Drawing.Point(480, 24);
  166. this.txt3.Name = "txt3";
  167. this.txt3.ReadOnly = true;
  168. this.txt3.TabIndex = 1;
  169. this.txt3.Text = "";
  170. // 
  171. // label4
  172. // 
  173. this.label4.Location = new System.Drawing.Point(432, 28);
  174. this.label4.Name = "label4";
  175. this.label4.Size = new System.Drawing.Size(48, 16);
  176. this.label4.TabIndex = 0;
  177. this.label4.Text = "班级";
  178. this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
  179. // 
  180. // dataGrid1
  181. // 
  182. this.dataGrid1.CaptionVisible = false;
  183. this.dataGrid1.DataMember = "";
  184. this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  185. this.dataGrid1.Location = new System.Drawing.Point(0, 56);
  186. this.dataGrid1.Name = "dataGrid1";
  187. this.dataGrid1.ReadOnly = true;
  188. this.dataGrid1.Size = new System.Drawing.Size(696, 224);
  189. this.dataGrid1.TabIndex = 1;
  190. // 
  191. // groupBox2
  192. // 
  193. this.groupBox2.Controls.Add(this.dataGrid2);
  194. this.groupBox2.Controls.Add(this.groupBox3);
  195. this.groupBox2.Location = new System.Drawing.Point(0, 280);
  196. this.groupBox2.Name = "groupBox2";
  197. this.groupBox2.Size = new System.Drawing.Size(696, 224);
  198. this.groupBox2.TabIndex = 2;
  199. this.groupBox2.TabStop = false;
  200. this.groupBox2.Text = "课程信息";
  201. // 
  202. // dataGrid2
  203. // 
  204. this.dataGrid2.CaptionVisible = false;
  205. this.dataGrid2.DataMember = "";
  206. this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  207. this.dataGrid2.Location = new System.Drawing.Point(216, 16);
  208. this.dataGrid2.Name = "dataGrid2";
  209. this.dataGrid2.ReadOnly = true;
  210. this.dataGrid2.Size = new System.Drawing.Size(472, 200);
  211. this.dataGrid2.TabIndex = 1;
  212. // 
  213. // groupBox3
  214. // 
  215. this.groupBox3.Controls.Add(this.txt4);
  216. this.groupBox3.Controls.Add(this.label3);
  217. this.groupBox3.Controls.Add(this.btnSearch);
  218. this.groupBox3.Controls.Add(this.btnElect);
  219. this.groupBox3.Controls.Add(this.btnDelete);
  220. this.groupBox3.Controls.Add(this.btnView);
  221. this.groupBox3.Controls.Add(this.label5);
  222. this.groupBox3.Controls.Add(this.txt5);
  223. this.groupBox3.Controls.Add(this.label6);
  224. this.groupBox3.Controls.Add(this.txt6);
  225. this.groupBox3.Controls.Add(this.txt7);
  226. this.groupBox3.Controls.Add(this.label7);
  227. this.groupBox3.Location = new System.Drawing.Point(8, 16);
  228. this.groupBox3.Name = "groupBox3";
  229. this.groupBox3.Size = new System.Drawing.Size(200, 200);
  230. this.groupBox3.TabIndex = 0;
  231. this.groupBox3.TabStop = false;
  232. // 
  233. // txt4
  234. // 
  235. this.txt4.Location = new System.Drawing.Point(72, 16);
  236. this.txt4.Name = "txt4";
  237. this.txt4.Size = new System.Drawing.Size(112, 21);
  238. this.txt4.TabIndex = 2;
  239. this.txt4.Text = "";
  240. // 
  241. // label3
  242. // 
  243. this.label3.Location = new System.Drawing.Point(16, 16);
  244. this.label3.Name = "label3";
  245. this.label3.Size = new System.Drawing.Size(56, 16);
  246. this.label3.TabIndex = 1;
  247. this.label3.Text = "课程拼音";
  248. // 
  249. // btnSearch
  250. // 
  251. this.btnSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnSearch.Image")));
  252. this.btnSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  253. this.btnSearch.Location = new System.Drawing.Point(16, 120);
  254. this.btnSearch.Name = "btnSearch";
  255. this.btnSearch.TabIndex = 0;
  256. this.btnSearch.Text = "查询";
  257. this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
  258. // 
  259. // btnElect
  260. // 
  261. this.btnElect.Enabled = false;
  262. this.btnElect.Image = ((System.Drawing.Image)(resources.GetObject("btnElect.Image")));
  263. this.btnElect.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  264. this.btnElect.Location = new System.Drawing.Point(112, 120);
  265. this.btnElect.Name = "btnElect";
  266. this.btnElect.TabIndex = 0;
  267. this.btnElect.Text = "选课";
  268. this.btnElect.Click += new System.EventHandler(this.btnElect_Click);
  269. // 
  270. // btnDelete
  271. // 
  272. this.btnDelete.Enabled = false;
  273. this.btnDelete.Image = ((System.Drawing.Image)(resources.GetObject("btnDelete.Image")));
  274. this.btnDelete.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  275. this.btnDelete.Location = new System.Drawing.Point(16, 160);
  276. this.btnDelete.Name = "btnDelete";
  277. this.btnDelete.TabIndex = 0;
  278. this.btnDelete.Text = "删课";
  279. this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
  280. // 
  281. // btnView
  282. // 
  283. this.btnView.Enabled = false;
  284. this.btnView.Image = ((System.Drawing.Image)(resources.GetObject("btnView.Image")));
  285. this.btnView.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  286. this.btnView.Location = new System.Drawing.Point(112, 160);
  287. this.btnView.Name = "btnView";
  288. this.btnView.TabIndex = 0;
  289. this.btnView.Text = "看课表";
  290. this.btnView.Click += new System.EventHandler(this.btnView_Click);
  291. // 
  292. // label5
  293. // 
  294. this.label5.Location = new System.Drawing.Point(16, 40);
  295. this.label5.Name = "label5";
  296. this.label5.Size = new System.Drawing.Size(56, 16);
  297. this.label5.TabIndex = 1;
  298. this.label5.Text = "课程名称";
  299. // 
  300. // txt5
  301. // 
  302. this.txt5.Location = new System.Drawing.Point(72, 40);
  303. this.txt5.Name = "txt5";
  304. this.txt5.Size = new System.Drawing.Size(112, 21);
  305. this.txt5.TabIndex = 2;
  306. this.txt5.Text = "";
  307. // 
  308. // label6
  309. // 
  310. this.label6.Location = new System.Drawing.Point(16, 64);
  311. this.label6.Name = "label6";
  312. this.label6.Size = new System.Drawing.Size(56, 16);
  313. this.label6.TabIndex = 1;
  314. this.label6.Text = "课程编号";
  315. // 
  316. // txt6
  317. // 
  318. this.txt6.Location = new System.Drawing.Point(72, 64);
  319. this.txt6.Name = "txt6";
  320. this.txt6.Size = new System.Drawing.Size(112, 21);
  321. this.txt6.TabIndex = 2;
  322. this.txt6.Text = "";
  323. // 
  324. // txt7
  325. // 
  326. this.txt7.Location = new System.Drawing.Point(72, 88);
  327. this.txt7.Name = "txt7";
  328. this.txt7.Size = new System.Drawing.Size(112, 21);
  329. this.txt7.TabIndex = 2;
  330. this.txt7.Text = "";
  331. // 
  332. // label7
  333. // 
  334. this.label7.Location = new System.Drawing.Point(16, 88);
  335. this.label7.Name = "label7";
  336. this.label7.Size = new System.Drawing.Size(56, 16);
  337. this.label7.TabIndex = 1;
  338. this.label7.Text = "课序号";
  339. // 
  340. // CourseElect
  341. // 
  342. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  343. this.ClientSize = new System.Drawing.Size(696, 509);
  344. this.Controls.Add(this.groupBox2);
  345. this.Controls.Add(this.dataGrid1);
  346. this.Controls.Add(this.groupBox1);
  347. this.Name = "CourseElect";
  348. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  349. this.Text = "【学生选课】";
  350. this.Load += new System.EventHandler(this.CourseElect_Load);
  351. this.groupBox1.ResumeLayout(false);
  352. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
  353. this.groupBox2.ResumeLayout(false);
  354. ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
  355. this.groupBox3.ResumeLayout(false);
  356. this.ResumeLayout(false);
  358. }
  359. #endregion
  361. //----------输入学号后回车，显示学生信息和选课信息-----------
  362. private void txt1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
  363. {
  364. if(e.KeyChar==13&&txt1.Text.Trim()!="")//输入学号后回车，查询学生信息和选课信息
  365. {
  366. this.electTable.Clear();//先清空选课表
  367. txt2.Clear();
  368. txt3.Clear();
  369. //关闭选课，删课等许可
  370. btnElect.Enabled=false;
  371. btnDelete.Enabled=false;
  372. btnView.Enabled=false;
  373. this.ShowInfo();
  374. }
  376. }
  378. //--------窗体新建时，绑定数据集和读入可选课程信息--------
  379. private void CourseElect_Load(object sender, System.EventArgs e)
  380. {
  381. //绑定dataGrid到学生选课信息上
  382. dataGrid1.DataSource=this.electTable;
  383. //读入可选课程数据 string strConn="workstation id=localhost;Integrated Security=SSPI;database=eisbook;"; SqlConnection cn=new SqlConnection(strConn); cn.Open();
  384. string sql="select a.课序号,a.课程编号,b.课程名称,b.教师,b.开课系别,"
  385. +"a.上课地点,a.上课时间天,a.上课时间节,b.拼音码"
  386. +" from 课程表 a,课程信息 b"
  387. +" where (b.本学期课程='Y')and(a.课程编号=b.课程编号)";
  388. SqlDataAdapter da2=new SqlDataAdapter(sql,cn);
  389. da2.Fill(this.courseTable);//可供选择的课程信息
  390. this.dv=courseTable.DefaultView;
  392. dataGrid2.DataSource=dv;//绑定显示可选课程信息
  393. }
  395. //------显示学生信息和选课信息-----
  396. private void ShowInfo()//
  397. {
  398. string strConn="workstation id=localhost;Integrated Security=SSPI;database=eisbook;"; SqlConnection cn=new SqlConnection(strConn); cn.Open();
  399. SqlCommand cmd=cn.CreateCommand();
  400. cmd.CommandText="select a.姓名,b.班级名称,a.学籍编号 from 学生信息 a,班级信息 b "
  401. +"where(a.班级编号=b.班级编号)and(学号='"+txt1.Text.Trim()+"')";
  402. SqlDataReader dr=cmd.ExecuteReader();
  403. dr.Read();//读入数据
  404. if(!dr.HasRows)//判断学号是否输入正确
  405. {
  406. MessageBox.Show("无此学生，请重新输入学号","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  407. dr.Close();
  408. return;
  409. }
  411. if(dr.GetValue(2).ToString().Trim()!="1")//判断是否为在籍学生
  412. {
  413. MessageBox.Show("该学生并非在籍学生，不能选课","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);                
  414. return;
  415. }
  416. txt2.Text=dr.GetValue(0).ToString().Trim();//姓名
  417. txt3.Text=dr.GetValue(1).ToString().Trim();//班级名称
  418. dr.Close();
  420. //读入选课信息
  421. string sql="select a.学号,a.课序号,b.课程名称,b.教师,"
  422. +"b.开课系别,c.上课时间天,c.上课时间节,c.上课地点"
  423. +" from 选课表 a,课程信息 b,课程表 c"
  424. +" where(a.课序号=c.课序号)and('200400000'+b.课程编号=a.课序号)"
  425. +"and(a.学号='"+txt1.Text.Trim()+"')";
  426. SqlDataAdapter da=new SqlDataAdapter(sql,cn);
  427. da.Fill(this.electTable);//该学生的选课信息
  428. this.studentID=txt1.Text.Trim();//保存获准选课的学生学号
  429. this.stduentName=txt2.Text.Trim();//保存学生姓名
  430. //允许选课，删课
  431. btnElect.Enabled=true;
  432. btnDelete.Enabled=true;
  433. btnView.Enabled=true;
  434.             
  435. }
  437. //-----------筛选课程-------------
  438. private void btnSearch_Click(object sender, System.EventArgs e)
  439. {
  440.             string filter="";
  441. if(txt4.Text.Trim()!="")
  442. {
  443. filter+="拼音码 like '%"+txt4.Text.Trim()+"%' AND ";
  444. }
  445. if(txt5.Text.Trim()!="")
  446. {
  447. filter+="课程名称 like '%"+txt5.Text.Trim()+"%' AND ";
  448. }
  449. if(txt6.Text.Trim()!="")
  450. {
  451. filter+="课程编号='"+txt6.Text.Trim()+"' AND ";
  452. }
  453. if(txt7.Text.Trim()!="")
  454. {
  455. filter+="课序号 like '%"+txt7.Text.Trim()+"%' AND ";
  456. }
  457. if(filter.Length>0)
  458. {
  459. filter=filter.Substring(0,filter.Length-5);
  460. }
  461. dv.RowFilter=filter;
  463. }
  465. //-------------学生选课-----------
  466. private void btnElect_Click(object sender, System.EventArgs e)
  467. {
  468. if(dv.Count==0)//可选课程为空不能选课
  469. {
  470. MessageBox.Show("可选课表为空，无法选课","提示",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  471. return;
  472. }
  473. string courseID=dataGrid2[dataGrid2.CurrentCell.RowNumber,0].ToString().Trim();//当前所选的课序号
  474. string courseDay=dataGrid2[dataGrid2.CurrentCell.RowNumber,6].ToString().Trim();//所选课程的上课时间天
  475. string courseSec=dataGrid2[dataGrid2.CurrentCell.RowNumber,7].ToString().Trim();//所选课程的上课时间节
  476. foreach(DataRow aRow in this.electTable.Rows)
  477. {
  478. if(aRow["课序号"].ToString().Trim()==courseID)
  479. {
  480. MessageBox.Show("所选课程已经在课程表中","课程重复",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  481. return;
  482. }
  483. if(aRow["上课时间天"].ToString().Trim()==courseDay&&aRow["上课时间节"].ToString().Trim()==courseSec)
  484. {
  485. string msg="所选课程和已选课程:"+aRow["课程名称"].ToString().Trim()+" 上课时间冲突";
  486. MessageBox.Show(msg,"时间冲突",MessageBoxButtons.OK,MessageBoxIcon.Stop);
  487. return;
  488. }
  489. }
  490. string strConn="workstation id=localhost;Integrated Security=SSPI;database=eisbook;"; SqlConnection cn=new SqlConnection(strConn); cn.Open();
  491. SqlCommand cmd=cn.CreateCommand();
  492. cmd.CommandText="insert into 选课表([学号],[课序号]) values('"+this.studentID+"','"+courseID+"')";
  493. cmd.ExecuteNonQuery();
  494. //重新读入学生的选课信息
  495. this.electTable.Clear();
  496. string sql="select a.学号,a.课序号,b.课程名称,b.教师,"
  497. +"b.开课系别,c.上课时间天,c.上课时间节,c.上课地点"
  498. +" from 选课表 a,课程信息 b,课程表 c"
  499. +" where(a.课序号=c.课序号)and('200400000'+b.课程编号=a.课序号)"
  500. +"and(a.学号='"+this.studentID+"')";
  501. SqlDataAdapter da=new SqlDataAdapter(sql,cn);
  502. da.Fill(this.electTable);//该学生的选课信息
  503. }
  505. //---------删除原来所选的课程------------
  506. private void btnDelete_Click(object sender, System.EventArgs e)
  507. {
  508. if(this.electTable.Rows.Count==0)
  509. {
  510. return;//无课可删，不作任何动作
  511. }
  512. string deleteID=dataGrid1[dataGrid1.CurrentCell.RowNumber,1].ToString().Trim();//要删除的课序号
  513. string deleteName=dataGrid1[dataGrid1.CurrentCell.RowNumber,2].ToString().Trim();//要删除的课名称
  514. string msg="是否确认删除已选课程:"+deleteName+" ?";
  515. DialogResult result=MessageBox.Show(msg,"删除课程",MessageBoxButtons.OKCancel);
  516. if(result==DialogResult.OK)
  517. {
  518. string strConn="workstation id=localhost;Integrated Security=SSPI;database=eisbook;"; SqlConnection cn=new SqlConnection(strConn); cn.Open();
  519. SqlCommand cmd=cn.CreateCommand();
  520. cmd.CommandText="delete from 选课表 where(学号='"+this.studentID+"')and(课序号='"+deleteID+"')";
  521. cmd.ExecuteNonQuery();
  522. //重新读入学生的选课信息
  523. this.electTable.Clear();
  524. string sql="select a.学号,a.课序号,b.课程名称,b.教师,"
  525. +"b.开课系别,c.上课时间天,c.上课时间节,c.上课地点"
  526. +" from 选课表 a,课程信息 b,课程表 c"
  527. +" where(a.课序号=c.课序号)and('200400000'+b.课程编号=a.课序号)"
  528. +"and(a.学号='"+this.studentID+"')";
  529. SqlDataAdapter da=new SqlDataAdapter(sql,cn);
  530. da.Fill(this.electTable);//该学生的选课信息
  531. }
  532. }
  534. //---------显示当前选课学生的课表------------
  535. private void btnView_Click(object sender, System.EventArgs e)
  536. {
  537. CurriculumSchedule newFrm=new CurriculumSchedule(this.studentID);
  538. newFrm.Text+="学生:"+this.stduentName;
  539. newFrm.ShowDialog();
  540. }
  542. }
  543. }