private void LoadData()
{
var data = context.layDanhSachNhanVien();
DataTable dt = new DataTable();
DataColumn dc0 = new DataColumn("Mã", typeof(string));
DataColumn dc1 = new DataColumn("Họ và tên", typeof(string));
DataColumn dc2 = new DataColumn("Giới tính", typeof(string));
DataColumn dc3 = new DataColumn("Ngày sinh", typeof(string));
DataColumn dc4 = new DataColumn("Địa chỉ", typeof(string));
DataColumn dc5 = new DataColumn("Số điện thoại", typeof(string));
DataColumn dc6 = new DataColumn("Mã quản lí", typeof(string));
DataColumn dc7 = new DataColumn("Mã chức vụ", typeof(string));
dt.Columns.Add(dc0);
dt.Columns.Add(dc1);
dt.Columns.Add(dc2);
dt.Columns.Add(dc3);
dt.Columns.Add(dc4);
dt.Columns.Add(dc5);
dt.Columns.Add(dc6);
dt.Columns.Add(dc7);
foreach (var item in data)
{
DataRow row = dt.NewRow();
row[0] = item.ma.ToString().Trim();
row[1] = item.ten.ToString().Trim();
row[2] = item.gioitinh.ToString().Trim();
row[3] = item.ngaysinh.ToString("dd/MM/yyyy").Trim();
row[4] = item.diachi.ToString().Trim();
row[5] = item.sodienthoai.ToString().Trim();
if (item.maquanly == null)
{
row[6] = "";
}
else
{
row[6] = item.maquanly.ToString().Trim();
}
if (item.machucvu == null)
{
row[7] = "";
}
else
{
row[7] = item.machucvu.ToString().Trim();
}
dt.Rows.Add(row);
}
gridControl.DataSource = dt;
gridView1.Columns[0].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[1].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[2].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[3].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[4].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[5].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[6].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[7].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
private void LoadNhanVien()
{
var danhSachNhanVien = context.layDanhSachNhanVien();
foreach (var nv in danhSachNhanVien)
{
cboNVitem item = new cboNVitem();
item.MaNV = nv.ma.ToString().Trim();
item.TenNV = nv.ten.ToString().Trim();
cboMaNhanVien.Items.Add(item);
cboTenNhanVien.Items.Add(nv.ten.ToString().Trim());
}
}