?? browsecourse.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data;
namespace WindowsApplication1
{
/// <summary>
/// kcll 的摘要說明。
/// </summary>
public class kcll : System.Windows.Forms.Form
{
private System.Windows.Forms.TreeView treeView1;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Data.OleDb.OleDbConnection oleDbConnection1;
private System.Data.OleDb.OleDbConnection oleDbConnection2;
private System.Data.OleDb.OleDbConnection oleDbConnection3;
/// <summary>
/// 必需的設計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
public kcll()
{
//
// Windows 窗體設計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設計器生成的代碼
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.treeView1 = new System.Windows.Forms.TreeView();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbConnection2 = new System.Data.OleDb.OleDbConnection();
this.oleDbConnection3 = new System.Data.OleDb.OleDbConnection();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// treeView1
//
this.treeView1.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.treeView1.ForeColor = System.Drawing.SystemColors.ControlText;
this.treeView1.ImageIndex = -1;
this.treeView1.Location = new System.Drawing.Point(11, 41);
this.treeView1.Name = "treeView1";
this.treeView1.SelectedImageIndex = -1;
this.treeView1.Size = new System.Drawing.Size(277, 391);
this.treeView1.TabIndex = 0;
this.treeView1.Click += new System.EventHandler(this.treeView1_Click);
this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterSelect);
//
// dataGrid1
//
this.dataGrid1.AllowSorting = false;
this.dataGrid1.BackgroundColor = System.Drawing.SystemColors.Control;
this.dataGrid1.CaptionBackColor = System.Drawing.SystemColors.ControlLightLight;
this.dataGrid1.CaptionFont = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.dataGrid1.CaptionForeColor = System.Drawing.SystemColors.ActiveCaption;
this.dataGrid1.DataMember = "";
this.dataGrid1.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.dataGrid1.ForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(299, 41);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.PreferredColumnWidth = 100;
this.dataGrid1.PreferredRowHeight = 30;
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(352, 340);
this.dataGrid1.TabIndex = 1;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label1.ForeColor = System.Drawing.SystemColors.ControlText;
this.label1.Location = new System.Drawing.Point(11, 10);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(145, 21);
this.label1.TabIndex = 2;
this.label1.Text = "專業(yè)/班級/學期選擇";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label2.ForeColor = System.Drawing.SystemColors.ControlText;
this.label2.Location = new System.Drawing.Point(299, 10);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(67, 21);
this.label2.TabIndex = 3;
this.label2.Text = "課程瀏覽";
//
// button1
//
this.button1.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.button1.ForeColor = System.Drawing.SystemColors.ControlText;
this.button1.Location = new System.Drawing.Point(299, 401);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(117, 31);
this.button1.TabIndex = 4;
this.button1.Text = "修改班級課程";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.button2.ForeColor = System.Drawing.SystemColors.ControlText;
this.button2.Location = new System.Drawing.Point(576, 401);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(64, 31);
this.button2.TabIndex = 5;
this.button2.Text = "退出";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.button3.ForeColor = System.Drawing.SystemColors.ControlText;
this.button3.Location = new System.Drawing.Point(437, 401);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(118, 31);
this.button3.TabIndex = 6;
this.button3.Text = "刪除班級課程";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = "Data Source=xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet." +
"OLEDB.4.0;";
//
// oleDbConnection2
//
this.oleDbConnection2.ConnectionString = "Data Source=xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet." +
"OLEDB.4.0;";
//
// oleDbConnection3
//
this.oleDbConnection3.ConnectionString = "Data Source=xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet." +
"OLEDB.4.0;";
//
// kcll
//
this.AutoScaleBaseSize = new System.Drawing.Size(8, 18);
this.ClientSize = new System.Drawing.Size(664, 440);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.treeView1);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.Name = "kcll";
this.Text = "課程信息瀏覽";
this.Load += new System.EventHandler(this.BrowseCourse_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void BrowseCourse_Load(object sender, System.EventArgs e)
{
//OleDbConnection cn1,cn2,cn3;
//cn1=new OleDbConnection("Data Source=D:/學生學籍管理系統(tǒng)/book/xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0");
//cn2=new OleDbConnection("Data Source=D:/學生學籍管理系統(tǒng)/book/xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0");
//cn3=new OleDbConnection("Data Source=D:/學生學籍管理系統(tǒng)/book/xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0");
OleDbCommand cmd1,cmd2,cmd3;
cmd1=new OleDbCommand("",oleDbConnection1);
cmd2=new OleDbCommand("",oleDbConnection2);
cmd3=new OleDbCommand("",oleDbConnection3);
OleDbDataReader rd1,rd2,rd3;
string sql;
sql="select specialtyname from specialtyinfo";
cmd1.CommandText=sql;
oleDbConnection1.Open();
rd1=cmd1.ExecuteReader();
while (rd1.Read())
{
TreeNode node=new TreeNode();
node.Text=rd1.GetString(0).ToString();
treeView1.Nodes.Add(node);
oleDbConnection2.Open();
sql="select classid,classname from classinfo where specialtyname='"+node.Text+"' order by classname desc";
cmd2.CommandText=sql;
rd2=cmd2.ExecuteReader();
while (rd2.Read())
{
TreeNode node1=new TreeNode();
node1.Text=rd2.GetString(1);
node.Nodes.Add(node1);
oleDbConnection3.Open();
sql="select distinct semester from courseinfo inner join classinfo on courseinfo.classid=classinfo.classid where classinfo.classname='"+node1.Text+"'";
cmd3.CommandText=sql;
rd3=cmd3.ExecuteReader();
while (rd3.Read())
{
TreeNode node2=new TreeNode();
node2.Text=(Int32.Parse(rd3.GetValue(0).ToString())/10)+"至"+(Int32.Parse(rd3.GetValue(0).ToString())/10+1)+"年度第"+(Int32.Parse(rd3.GetValue(0).ToString())%10)+"學期";
node2.Tag=rd3.GetValue(0);
node1.Nodes.Add(node2);
}
rd3.Close();
oleDbConnection3.Close();
}
rd2.Close();
oleDbConnection2.Close();
}
rd1.Close();
oleDbConnection1.Close();
}
DataSet ds;
private void treeView1_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
string sql="";
//OleDbConnection oleDbConnection1;
//oleDbConnection1=new OleDbConnection("Data Source=D:/學生學籍管理系統(tǒng)/book/xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0");
//oleDbConnection1.Open();
OleDbDataAdapter adp=new OleDbDataAdapter(sql,oleDbConnection1);
ds=new DataSet();
ds.Clear();
oleDbConnection1.Open();
if (e.Node.Tag!=null)
{
sql="select courseinfo.courseid as 自動編號,courseinfo.course as 課程名稱 from classinfo inner join courseinfo on courseinfo.classid=classinfo.classid where classinfo.classname='"+e.Node.Parent.Text.ToString()+"' and semester='"+e.Node.Tag.ToString()+"'";
adp.SelectCommand.CommandText=sql;
adp.Fill(ds,"class_course");
dataGrid1.DataSource=ds.Tables[0].DefaultView;
dataGrid1.CaptionText=e.Node.Parent.Text.ToString()+" "+e.Node.Text+"課程表";
}
else
{
dataGrid1.DataSource=null;
dataGrid1.CaptionText="";
}
oleDbConnection1.Close();
}
private void treeView1_Click(object sender, System.EventArgs e)
{
}
private void button1_Click(object sender, System.EventArgs e)
{
if (dataGrid1.DataSource!=null && dataGrid1[dataGrid1.CurrentCell]!=null)
{
ModifyCourse modifycourse=new ModifyCourse();
modifycourse.Tag=ds.Tables[0].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim();
modifycourse.ShowDialog();
}
else
MessageBox.Show("沒有指定的課程信息","提示");
}
private void button3_Click1(object sender, System.EventArgs e)
{
dataGrid1.Refresh();
}
private void button2_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void button3_Click(object sender, System.EventArgs e)
{
oleDbConnection1.Open();
if (ds.Tables[0].Rows.Count!=0 && dataGrid1.CurrentRowIndex>0 && dataGrid1.DataSource!=null && dataGrid1[dataGrid1.CurrentCell]!=null)
{
string pd="select * from ((scoreinfo inner join courseinfo on scoreinfo.course=courseinfo.course) inner join Studentinfo on studentinfo.studentnumber=scoreinfo.studentnumber) where scoreinfo.semester=courseinfo.semester and studentinfo.classid=courseinfo.classid and courseinfo.courseid="+ds.Tables["class_course"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim();
OleDbCommand cmd=new OleDbCommand(pd,oleDbConnection1);
OleDbDataReader dr;
dr=cmd.ExecuteReader();
if (!dr.Read())
{
dr.Close();
string sql="delete * from courseinfo where courseid="+ds.Tables["class_course"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim();
cmd.CommandText=sql;
cmd.ExecuteNonQuery();
MessageBox.Show("'"+ds.Tables["class_course"].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim()+"'課程信息刪除成功","提示");
}
else
MessageBox.Show("暫時不能刪除該課程，請先刪除有關(guān)的成績紀錄","提示");
dr.Close();
}
else
MessageBox.Show("沒有指定的課程信息","提示");
oleDbConnection1.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -