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 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); }