public CaNhan_DAL(Database_DAL _databaseAccess = null, HoSoThiDua_DAL hoSoThiDua_DAL = null) { DbAccess = _databaseAccess; HoSoThiDua = hoSoThiDua_DAL; LocalTable = new DataTable("DS_CaNhan"); DataColumn id = new DataColumn("id", typeof(long)); DataColumn idDonVi = new DataColumn("idDonVi", typeof(long)); DataColumn hoTen = new DataColumn("hoTen", typeof(string)); DataColumn gioiTinh = new DataColumn("gioiTinh", typeof(string)); DataColumn ngaySinh = new DataColumn("ngaySinh", typeof(DateTime)); DataColumn chucDanh = new DataColumn("chucDanh", typeof(string)); DataColumn chucVu = new DataColumn("chucVu", typeof(string)); DataColumn email = new DataColumn("email", typeof(string)); DataColumn phone = new DataColumn("phone", typeof(string)); LocalTable.Columns.Add(id); LocalTable.Columns.Add(idDonVi); LocalTable.Columns.Add(hoTen); LocalTable.Columns.Add(gioiTinh); LocalTable.Columns.Add(ngaySinh); LocalTable.Columns.Add(chucDanh); LocalTable.Columns.Add(chucVu); LocalTable.Columns.Add(email); LocalTable.Columns.Add(phone); LocalTable.RowDeleted += LocalTable_RowDeleted; if (DbAccess.Database.Tables.Contains(LocalTable.TableName)) { DbAccess.Database.Tables.Remove(LocalTable.TableName); } DbAccess.Database.Tables.Add(LocalTable); }
//Just add comment public HoSoThiDua_DAL(Database_DAL database_DAL) { DbAccess = database_DAL; LocalTable = new DataTable("DS_HoSoThiDua"); DataColumn id = new DataColumn("id", typeof(long)); DataColumn idCaNhan = new DataColumn("idCaNhan", typeof(long)); DataColumn idDonVi = new DataColumn("idDonVi", typeof(long)); DataColumn nam = new DataColumn("nam", typeof(long)); DataColumn danhHieuDangKy = new DataColumn("danhHieuDangKy", typeof(byte)); DataColumn danhHieuDatDuoc = new DataColumn("danhHieuDatDuoc", typeof(byte)); LocalTable.Columns.Add(id); LocalTable.Columns.Add(idCaNhan); LocalTable.Columns.Add(idDonVi); LocalTable.Columns.Add(nam); LocalTable.Columns.Add(danhHieuDangKy); LocalTable.Columns.Add(danhHieuDatDuoc); if (DbAccess.Database.Tables.Contains(LocalTable.TableName)) { DbAccess.Database.Tables.Remove(LocalTable.TableName); } DbAccess.Database.Tables.Add(LocalTable); }
//just add comment public DonVi_DAL(Database_DAL database_DAL, CaNhan_DAL caNhan_DAL = null, HoSoThiDua_DAL hoSoThiDua_DAL = null) { DbAccess = database_DAL; CaNhan = caNhan_DAL; HoSoThiDua = hoSoThiDua_DAL; LocalTable = new DataTable("DS_DonVi"); DataColumn id = new DataColumn("id", typeof(long)); DataColumn loai = new DataColumn("loai", typeof(string)); DataColumn tenDonVi = new DataColumn("tenDonVi", typeof(string)); DataColumn diaDiem = new DataColumn("diaDiem", typeof(string)); DataColumn email = new DataColumn("email", typeof(string)); DataColumn phone = new DataColumn("phone", typeof(string)); DataColumn trangThai = new DataColumn("trangThai", typeof(bool)); LocalTable.Columns.Add(id); LocalTable.Columns.Add(loai); LocalTable.Columns.Add(tenDonVi); LocalTable.Columns.Add(diaDiem); LocalTable.Columns.Add(email); LocalTable.Columns.Add(phone); LocalTable.Columns.Add(trangThai); LocalTable.RowDeleting += LocalTable_RowDeleted; if (DbAccess.Database.Tables.Contains(LocalTable.TableName)) { DbAccess.Database.Tables.Remove(LocalTable.TableName); } DbAccess.Database.Tables.Add(LocalTable); }
public GioiTinh_DAL(Database_DAL database_DAL) { DbAccess = database_DAL; LocalTable = new DataTable("DM_GioiTinh"); LocalTable.Columns.Add(new DataColumn("id", typeof(byte))); LocalTable.Columns.Add(new DataColumn("gioiTinh", typeof(string))); LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool))); DbAccess.Database.Tables.Add(LocalTable); }
public LoaiDonVi_DAL(Database_DAL database_DAL) { DbAccess = database_DAL; LocalTable = new DataTable("DM_LoaiDonVi"); LocalTable.Columns.Add(new DataColumn("id", typeof(byte))); LocalTable.Columns.Add(new DataColumn("tenLoai", typeof(string))); LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool))); DbAccess.Database.Tables.Add(LocalTable); }
public DanhHieu_DAL(Database_DAL database_DAL) { DbAccess = database_DAL; LocalTable = new DataTable(); LocalTable.Columns.Add(new DataColumn("id", typeof(long))); LocalTable.Columns.Add(new DataColumn("nam", typeof(long))); LocalTable.Columns.Add(new DataColumn("danhHieu", typeof(string))); LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool))); }
public ChucVu_DAL(Database_DAL database_DAL) { DbAccess = database_DAL; LocalTable = new DataTable("DM_ChucVu"); LocalTable.Columns.Add(new DataColumn("id", typeof(byte))); LocalTable.Columns.Add(new DataColumn("chucVu", typeof(string))); LocalTable.Columns.Add(new DataColumn("trangThai", typeof(bool))); if (DbAccess.Database.Tables.Contains(LocalTable.TableName)) { DbAccess.Database.Tables.Remove(LocalTable.TableName); } DbAccess.Database.Tables.Add(LocalTable); }
public TieuChi_DAL(Database_DAL database_DAL) { DbAccess = database_DAL; LocalTable = new DataTable("DM_TieuChi"); DataColumn id = new DataColumn("id", typeof(long)); DataColumn nam = new DataColumn("nam", typeof(long)); DataColumn ten = new DataColumn("ten", typeof(string)); DataColumn moTa = new DataColumn("moTa", typeof(string)); DataColumn ghiChu = new DataColumn("ghiChu", typeof(string)); LocalTable.Columns.Add(id); LocalTable.Columns.Add(nam); LocalTable.Columns.Add(ten); LocalTable.Columns.Add(moTa); LocalTable.Columns.Add(ghiChu); DbAccess.Database.Tables.Add(LocalTable); }