public void Hienthi()
{
lstGV = GiaoVienController.getAllDataGV();
DataTable dt = ViewHelper.ToDataTable <GiaoVien>(lstGV);
dtgrGV.DataSource = dt;
dtgrGV.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dt.Columns["MaGV"].ColumnName = "Mã Giáo Viên";
dt.Columns["HoTen"].ColumnName = "Họ Tên";
dt.Columns["NgaySinh"].ColumnName = "Ngày Sinh";
dt.Columns["GioiTinh"].ColumnName = "Giới Tính (Nữ ✓/nam)";
dt.Columns["Sdt"].ColumnName = "Số Điện Thoại";
dt.Columns["DiaChi"].ColumnName = "Địa Chỉ";
dt.Columns["TenMon"].ColumnName = "Tên môn";
int j = 0;
foreach (DataGridViewColumn col in dtgrGV.Columns)
{
col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
col.HeaderCell.Style.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
dtgrGV.Columns[j].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
j++;
}
try { dtgrGV.CurrentCell = dtgrGV[CurCl, CurR]; } catch { }
// lblTongSL.Text = GetTongSobanGhi("select * from GiaoVien").ToString();
dtgrGV.Refresh();
}
public frmThaoTacGV(string _MaGV, string _HoTen, DateTime _NgaySinh, bool _GioiTinh, string _Sdt, string _DiaChi, string _MaMon, int state)
{
InitializeComponent();
_state = state;
lstGV = GiaoVienController.getAllDataGV();
if (state == 2)
{
txtID.Enabled = false;
}
txtID.Text = _MaGV;
txtHoTen.Text = _HoTen;
txtDiaChi.Text = _DiaChi;
if (_GioiTinh)
{
radNam.Checked = true;
}
else
{
radNu.Checked = true;
}
dtpNgaySinh.Value = _NgaySinh;
txtSDT.Text = _Sdt;
///Thao tac MÃ Môn
///1. Get all ma lop
///
using (var db = setupConection.ConnectionFactory())
{
if (db.State == ConnectionState.Closed)
{
db.Open();
}
List <MonHoc> list = db.Query <MonHoc>("SELECT MaMon,TenMon FROM dbo.MonHoc").ToList();
for (int i = 0; i < list.Count; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = list[i].TenMon.ToString();
item.Value = list[i].MaMon.ToString();
cbMon.Items.Add(item);
if (_MaMon == list[i].TenMon)
{
cbMon.SelectedIndex = i;
}
}
}
}
