3 Tiers

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

namespace QLHS3

{

/// <summary>

/// Summary description for Form1.

/// </summary>

public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.ComboBox cmbLop;

private System.Windows.Forms.DateTimePicker dtpNgaySinh;

private System.Windows.Forms.TextBox txtHoa;

private System.Windows.Forms.TextBox txtLy;

private System.Windows.Forms.TextBox txtToan;

private System.Windows.Forms.Label label10;

private System.Windows.Forms.Label label9;

private System.Windows.Forms.TextBox txtDiaChi;

private System.Windows.Forms.TextBox txtTenHS;

private System.Windows.Forms.TextBox txtMaHS;

private System.Windows.Forms.Label label8;

private System.Windows.Forms.Label label7;

private System.Windows.Forms.Label label6;

private System.Windows.Forms.Label label5;

private System.Windows.Forms.Label label4;

private System.Windows.Forms.Label label3;

private System.Windows.Forms.Button btnDong;

private System.Windows.Forms.Button btnXoa;

private System.Windows.Forms.Button btnThem;

private System.Windows.Forms.Label label2;

private System.Windows.Forms.GroupBox groupBox2;

private System.Windows.Forms.Label label1;

private System.Windows.Forms.GroupBox groupBox1;

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.Container components = null;

public Form1()

{

// Required for Windows Form Designer support

InitializeComponent();

// TODO: Add any constructor code after InitializeComponent call

}

/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

base.Dispose( disposing );

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.cmbLop = new System.Windows.Forms.ComboBox();

this.dtpNgaySinh = new System.Windows.Forms.DateTimePicker();

this.txtHoa = new System.Windows.Forms.TextBox();

this.txtLy = new System.Windows.Forms.TextBox();

this.txtToan = new System.Windows.Forms.TextBox();

this.label10 = new System.Windows.Forms.Label();

this.label9 = new System.Windows.Forms.Label();

this.txtDiaChi = new System.Windows.Forms.TextBox();

this.txtTenHS = new System.Windows.Forms.TextBox();

this.txtMaHS = new System.Windows.Forms.TextBox();

this.label8 = new System.Windows.Forms.Label();

this.label7 = new System.Windows.Forms.Label();

this.label6 = new System.Windows.Forms.Label();

this.label5 = new System.Windows.Forms.Label();

this.label4 = new System.Windows.Forms.Label();

this.label3 = new System.Windows.Forms.Label();

this.btnDong = new System.Windows.Forms.Button();

this.btnXoa = new System.Windows.Forms.Button();

this.btnThem = new System.Windows.Forms.Button();

this.label2 = new System.Windows.Forms.Label();

this.groupBox2 = new System.Windows.Forms.GroupBox();

this.label1 = new System.Windows.Forms.Label();

this.groupBox1 = new System.Windows.Forms.GroupBox();

this.groupBox2.SuspendLayout();

this.SuspendLayout();

// cmbLop

this.cmbLop.Location = new System.Drawing.Point(142, 251);

this.cmbLop.Name = "cmbLop";

this.cmbLop.Size = new System.Drawing.Size(144, 21);

this.cmbLop.TabIndex = 43;

// dtpNgaySinh

this.dtpNgaySinh.Format = System.Windows.Forms.DateTimePickerFormat.Short;

this.dtpNgaySinh.Location = new System.Drawing.Point(142, 171);

this.dtpNgaySinh.Name = "dtpNgaySinh";

this.dtpNgaySinh.Size = new System.Drawing.Size(144, 20);

this.dtpNgaySinh.TabIndex = 42;

// txtHoa

this.txtHoa.Location = new System.Drawing.Point(470, 291);

this.txtHoa.Name = "txtHoa";

this.txtHoa.Size = new System.Drawing.Size(80, 20);

this.txtHoa.TabIndex = 41;

this.txtHoa.Text = "0";

// txtLy

this.txtLy.Location = new System.Drawing.Point(286, 291);

this.txtLy.Name = "txtLy";

this.txtLy.Size = new System.Drawing.Size(80, 20);

this.txtLy.TabIndex = 40;

this.txtLy.Text = "0";

// txtToan

this.txtToan.Location = new System.Drawing.Point(102, 291);

this.txtToan.Name = "txtToan";

this.txtToan.Size = new System.Drawing.Size(80, 20);

this.txtToan.TabIndex = 39;

this.txtToan.Text = "0";

// label10

this.label10.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label10.Location = new System.Drawing.Point(398, 291);

this.label10.Name = "label10";

this.label10.Size = new System.Drawing.Size(72, 23);

this.label10.TabIndex = 38;

this.label10.Text = "Hóa";

// label9

this.label9.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label9.Location = new System.Drawing.Point(214, 291);

this.label9.Name = "label9";

this.label9.Size = new System.Drawing.Size(72, 23);

this.label9.TabIndex = 37;

this.label9.Text = "Lý";

// txtDiaChi

this.txtDiaChi.Location = new System.Drawing.Point(142, 211);

this.txtDiaChi.Name = "txtDiaChi";

this.txtDiaChi.Size = new System.Drawing.Size(416, 20);

this.txtDiaChi.TabIndex = 36;

this.txtDiaChi.Text = "";

// txtTenHS

this.txtTenHS.Location = new System.Drawing.Point(142, 131);

this.txtTenHS.Name = "txtTenHS";

this.txtTenHS.Size = new System.Drawing.Size(416, 20);

this.txtTenHS.TabIndex = 35;

this.txtTenHS.Text = "";

// txtMaHS

this.txtMaHS.Location = new System.Drawing.Point(142, 91);

this.txtMaHS.Name = "txtMaHS";

this.txtMaHS.Size = new System.Drawing.Size(416, 20);

this.txtMaHS.TabIndex = 34;

this.txtMaHS.Text = "";

// label8

this.label8.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label8.Location = new System.Drawing.Point(30, 291);

this.label8.Name = "label8";

this.label8.Size = new System.Drawing.Size(72, 23);

this.label8.TabIndex = 33;

this.label8.Text = "Toán";

// label7

this.label7.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label7.Location = new System.Drawing.Point(30, 251);

this.label7.Name = "label7";

this.label7.TabIndex = 32;

this.label7.Text = "L?p";

// label6

this.label6.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label6.Location = new System.Drawing.Point(30, 211);

this.label6.Name = "label6";

this.label6.TabIndex = 31;

this.label6.Text = "Ð?a ch?";

// label5

this.label5.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label5.Location = new System.Drawing.Point(30, 171);

this.label5.Name = "label5";

this.label5.TabIndex = 30;

this.label5.Text = "Ngày sinh";

// label4

this.label4.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label4.Location = new System.Drawing.Point(30, 131);

this.label4.Name = "label4";

this.label4.TabIndex = 29;

this.label4.Text = "Tên h?c sinh";

// label3

this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label3.Location = new System.Drawing.Point(30, 91);

this.label3.Name = "label3";

this.label3.TabIndex = 28;

this.label3.Text = "Mã h?c sinh";

// btnDong

this.btnDong.Location = new System.Drawing.Point(494, 355);

this.btnDong.Name = "btnDong";

this.btnDong.TabIndex = 27;

this.btnDong.Text = "Ðóng";

this.btnDong.Click += new System.EventHandler(this.btnDong_Click);

// btnXoa

this.btnXoa.Location = new System.Drawing.Point(118, 355);

this.btnXoa.Name = "btnXoa";

this.btnXoa.TabIndex = 26;

this.btnXoa.Text = "Xóa";

this.btnXoa.Click += new System.EventHandler(this.btnXoa_Click);

// btnThem

this.btnThem.Location = new System.Drawing.Point(22, 355);

this.btnThem.Name = "btnThem";

this.btnThem.TabIndex = 25;

this.btnThem.Text = "Thêm";

this.btnThem.Click += new System.EventHandler(this.btnThem_Click);

// label2

this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label2.Location = new System.Drawing.Point(142, 11);

this.label2.Name = "label2";

this.label2.Size = new System.Drawing.Size(312, 32);

this.label2.TabIndex = 24;

this.label2.Text = "Thông tin h?c sinh";

this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

// groupBox2

this.groupBox2.BackColor = System.Drawing.SystemColors.ControlText;

this.groupBox2.Controls.Add(this.label1);

this.groupBox2.Location = new System.Drawing.Point(14, 331);

this.groupBox2.Name = "groupBox2";

this.groupBox2.Size = new System.Drawing.Size(560, 8);

this.groupBox2.TabIndex = 23;

this.groupBox2.TabStop = false;

// label1

this.label1.Location = new System.Drawing.Point(3, 16);

this.label1.Name = "label1";

this.label1.TabIndex = 0;

this.label1.Text = "label1";

// groupBox1

this.groupBox1.BackColor = System.Drawing.SystemColors.ControlText;

this.groupBox1.Location = new System.Drawing.Point(14, 59);

this.groupBox1.Name = "groupBox1";

this.groupBox1.Size = new System.Drawing.Size(560, 8);

this.groupBox1.TabIndex = 22;

this.groupBox1.TabStop = false;

// Form1

this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);

this.ClientSize = new System.Drawing.Size(588, 389);

this.Controls.Add(this.cmbLop);

this.Controls.Add(this.dtpNgaySinh);

this.Controls.Add(this.txtHoa);

this.Controls.Add(this.txtLy);

this.Controls.Add(this.txtToan);

this.Controls.Add(this.label10);

this.Controls.Add(this.label9);

this.Controls.Add(this.txtDiaChi);

this.Controls.Add(this.txtTenHS);

this.Controls.Add(this.txtMaHS);

this.Controls.Add(this.label8);

this.Controls.Add(this.label7);

this.Controls.Add(this.label6);

this.Controls.Add(this.label5);

this.Controls.Add(this.label4);

this.Controls.Add(this.label3);

this.Controls.Add(this.btnDong);

this.Controls.Add(this.btnXoa);

this.Controls.Add(this.btnThem);

this.Controls.Add(this.label2);

this.Controls.Add(this.groupBox2);

this.Controls.Add(this.groupBox1);

this.Name = "Form1";

this.Text = "Form1";

this.Load += new System.EventHandler(this.Form1_Load);

this.groupBox2.ResumeLayout(false);

this.ResumeLayout(false);

}

#endregion

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main()

{

Application.Run(new Form1());

}

/// Tao doi tuong control de thuc hien xu ly nghiep vu.

HocSinhCtl hsControl;//L?p h?c sinh

LopCtl lopControl;

/// Danh sach lop

ArrayList dsLop;

private void btnThem_Click(object sender, System.EventArgs e)

{

HocSinhInfo hs = new HocSinhInfo();

// Lay thong tin hoc sinh tu form vao doi tuong hocsinh

LayThongTinHS(ref hs);

// Chuyen doi tuong hoc sinh de doi tuong control xu ly

hsControl.HocSinh = hs;

// Tinh diem trung binh va cap nhat du lieu

hsControl.tinhDTB();

hsControl.insert();

MessageBox.Show("Them du lieu thanh cong");

}

private void Form1_Load(object sender, System.EventArgs e)

{

string DBFullPathName = Application.StartupPath + "\\HOCSINH.mdb";

DataProvider.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBFullPathName;

hsControl = new HocSinhCtl();

lopControl = new LopCtl();

// Lay danh sach lop

dsLop = lopControl.getDsLop();

// ket danh sach lop voi combo box de the hien

cmbLop.DisplayMember = "TenLop";

cmbLop.ValueMember = "MaLop";

cmbLop.DataSource = dsLop;

}

private void LayThongTinHS (ref HocSinhInfo hs)

{

hs.MaHS = txtMaHS.Text;

hs.DiaChi = txtDiaChi.Text;

hs.TenHS = txtTenHS.Text;

hs.MaLop = cmbLop.SelectedValue.ToString();

hs.NgaySinh = dtpNgaySinh.Value;

if (txtToan.Text == "")

hs.Toan = int.Parse(txtToan.Text);

else

hs.Toan = 0;

if (txtLy.Text == "")

hs.Ly = int.Parse(txtLy.Text);

else

hs.Ly = 0;

if (txtHoa.Text == "")

hs.Hoa = int.Parse(txtHoa.Text);

else

hs.Hoa = 0;

}

private void btnXoa_Click(object sender, System.EventArgs e)

{

HocSinhInfo hs = new HocSinhInfo();

// Lay thong tin hoc sinh tu form vao doi tuong hocsinh

LayThongTinHS(ref hs);

// Chuyen doi tuong hoc sinh de doi tuong control xu ly

hsControl.HocSinh = hs;

// Xoa doi tuong khoi co so du lieu

hsControl.delete();

MessageBox.Show("Xoa du lieu thanh cong");

}

private void btnDong_Click(object sender, System.EventArgs e)

{

this.Close();

}