private void frm_TraCuuSach_Load(object sender, EventArgs e)
{
Bang_SACH = new XL_SACH();
Bang_THELOAI = new XL_THELOAI();
Bang_NHAXUATBAN = new XL_NHAXUATBAN();
DataSet ds = new DataSet();
ds.Tables.AddRange(new DataTable[] { Bang_SACH, Bang_NHAXUATBAN, Bang_THELOAI });
DataRelation qh_NHAXUABAN_SACH = new DataRelation("FK_NHAXUATBAN_SACH", Bang_NHAXUATBAN.Columns["MaNXB"], Bang_SACH.Columns["MaNXB"]);
DataRelation qh_THELOAI_SACH = new DataRelation("FK_THELOAI_SACH", Bang_THELOAI.Columns["MaTL"], Bang_SACH.Columns["MaTL"]);
ds.Relations.AddRange(new DataRelation[] { qh_NHAXUABAN_SACH, qh_THELOAI_SACH });
DataColumn cot_TenNXB = new DataColumn("TenNXB", Type.GetType("System.String"), "Parent(FK_NHAXUATBAN_SACH).TenNXB");
DataColumn cot_TenTL = new DataColumn("TenTL", Type.GetType("System.String"), "Parent(FK_THELOAI_SACH).TenTL");
Bang_SACH.Columns.AddRange(new DataColumn[] { cot_TenNXB, cot_TenTL });
cobNSX.DataSource = Bang_NHAXUATBAN;
cobNSX.DisplayMember = "TenNXB";
cobNSX.ValueMember = "MaTL";
cobTheLoai.DataSource = Bang_THELOAI;
cobTheLoai.DisplayMember = "TenTL";
cobTheLoai.ValueMember = "MaTL";
dgvTraCuu.DataSource = Bang_SACH;
Nhap_moi();
}
private void frmXuLyMuonTraSach_Load(object sender, EventArgs e)
{
bang_MUONSACH = new XL_MUONSACH();
bang_SACH = new XL_SACH();
bang_BANDOC = new XL_BANDOC();
cobMaThe.DataSource = bang_BANDOC;
cobMaThe.DisplayMember = "MaThe";
cobMaThe.ValueMember = "MaThe";
txtTen.DataBindings.Add("text", bang_BANDOC, "TenBanDoc");
txtSodt.DataBindings.Add("text", bang_BANDOC, "SoDT");
txtDiaChi.DataBindings.Add("text", bang_BANDOC, "DiaChi");
cobMaSach.DataSource = bang_SACH;
cobMaSach.DisplayMember = "MaSach";
cobMaSach.ValueMember = "MaSach";
txtTenSach.DataBindings.Add("text", bang_SACH, "TuaDe");
txtTacGia.DataBindings.Add("text", bang_SACH, "TacGia");
DataSet ds = new DataSet();
ds.Tables.AddRange(new DataTable[] { bang_MUONSACH, bang_SACH });
DataRelation qh = new DataRelation("FR_SACH_MUONSACH", bang_SACH.Columns["MaSach"], bang_MUONSACH.Columns["MaSach"]);
ds.Relations.Add(qh);
DataColumn cot_TuaDe = new DataColumn("TuaDe", Type.GetType("System.String"), "Parent(FR_SACH_MUONSACH).TuaDe");
DataColumn cot_TacGia = new DataColumn("TacGia", Type.GetType("System.String"), "Parent(FR_SACH_MUONSACH).TacGia");
bang_MUONSACH.Columns.AddRange(new DataColumn[] { cot_TuaDe, cot_TacGia });
cobMaSach.DataBindings.Add("SelectedValue", bang_MUONSACH, "MaSach");
dNgayMuon.DataBindings.Add("text", bang_MUONSACH, "NgayMuon");
dNgayTra.DataBindings.Add("text", bang_MUONSACH, "NgayTra");
dgvMuonSach.DataSource = bang_MUONSACH;
DS_MUON_SACH = this.BindingContext[bang_MUONSACH];
cobMaThe_SelectedIndexChang(sender, e);
}
private void frm_Sach_Load(object sender, EventArgs e)
{
Bang_SACH = new XL_SACH();
Bang_THELOAI = new XL_THELOAI();
Bang_NHAXUATBAN = new XL_NHAXUATBAN();
DataSet ds = new DataSet();
ds.Tables.AddRange(new DataTable[] { Bang_SACH, Bang_NHAXUATBAN, Bang_THELOAI });
DataRelation qh_NHAXUABAN_SACH = new DataRelation("FK_NHAXUATBAN_SACH", Bang_NHAXUATBAN.Columns["MaNXB"], Bang_SACH.Columns["MaNXB"]);
DataRelation qh_THELOAI_SACH = new DataRelation("FK_THELOAI_SACH", Bang_THELOAI.Columns["MaTL"], Bang_SACH.Columns["MaTL"]);
ds.Relations.AddRange(new DataRelation[] { qh_NHAXUABAN_SACH, qh_THELOAI_SACH });
DataColumn cot_TenNXB = new DataColumn("TenNXB", Type.GetType("System.String"), "Parent(FK_NHAXUATBAN_SACH).TenNXB");
DataColumn cot_TenTL = new DataColumn("TenTL", Type.GetType("System.String"), "Parent(FK_THELOAI_SACH).TenTL");
Bang_SACH.Columns.AddRange(new DataColumn[] { cot_TenNXB, cot_TenTL });
cobNSX.DataSource = Bang_NHAXUATBAN;
cobNSX.DisplayMember = "TenNXB";
cobNSX.ValueMember = "MaNXB";
cobTheLoai.DataSource = Bang_THELOAI;
cobTheLoai.DisplayMember = "TenTL";
cobTheLoai.ValueMember = "MaTL";
dgvSach.DataSource = Bang_SACH;
txtMaSach.DataBindings.Add("text", Bang_SACH, "MaSach");
txtTenSach.DataBindings.Add("text", Bang_SACH, "TuaDe");
txtTacGia.DataBindings.Add("text", Bang_SACH, "TacGia");
txtSoLuong.DataBindings.Add("text", Bang_SACH, "SoLuong");
dtNgayNhap.DataBindings.Add("text", Bang_SACH, "NgayNhap");
cobNSX.DataBindings.Add("SelectedValue", Bang_SACH, "MaNSX");
cobTheLoai.DataBindings.Add("SelectedValue", Bang_SACH, "MaTL");
//
DS_SACH = this.BindingContext[Bang_SACH];
An_hien_nut_lenh(false);
}
