private void LoadDSSach()
{
DataTable dt = Sach_DAO.LoadDuLieu();
DataTable dtg = ChuDe_DAO.LoadDuLieu();
AutoCompleteStringCollection ac = new AutoCompleteStringCollection();
for (int i = 0; i < dtg.Rows.Count; i++)
{
ListViewGroup lvg = new ListViewGroup(dtg.Rows[i][0].ToString(), dtg.Rows[i][1].ToString());
lsvSach.Groups.Add(lvg);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
ListViewItem lvi = new ListViewItem(dt.Rows[i][1].ToString()); // ten mon
lvi.SubItems.Add(dt.Rows[i][2].ToString()); // Don gia
lvi.SubItems.Add(dt.Rows[i][4].ToString()); //So luong
DataTable nxb = NhaXuatBan_DAO.LoadDuLieuNXB(dt.Rows[i][6].ToString());
lvi.SubItems.Add(nxb.Rows[0][1].ToString()); //NXB
lvi.SubItems.Add(dt.Rows[i][7].ToString()); //id chu de
lvi.SubItems.Add(dt.Rows[i][0].ToString()); // id mon
lvi.Group = lsvSach.Groups[lvi.SubItems[4].Text];
lsvSach.Items.Add(lvi);
ac.Add(lvi.SubItems[0].Text);
}
txtTenSach.AutoCompleteCustomSource = ac;
}
private void FrmThemDS_Load(object sender, EventArgs e)
{
cboMaCD.DataSource = ChuDe_DAO.LoadDuLieu();
cboMaCD.DisplayMember = "TenCD";
cboMaCD.ValueMember = "MaCD";
cboNhaNXB.DataSource = NhaXuatBan_DAO.LoadDuLieu();
dgvDausach.DataSource = Sach_DAO.LoadDuLieu();
cboNhaNXB.DisplayMember = "TenNXB";
cboNhaNXB.ValueMember = "MaNXB";
txtMasach.ReadOnly = true;
}
private void l(object sender, EventArgs e)
{
ListViewItem lvi = lsvDsDuocChon.SelectedItems[0];
txtSach.Text = lvi.SubItems[0].Text;
itemSelect = lsvDsDuocChon.SelectedItems[0];
indexItemSelect = lsvDsDuocChon.SelectedItems[0].Index;
IdCD = itemSelect.SubItems[4].Text;
txtSoLuong.Text = itemSelect.SubItems[2].Text;
cd = ChuDe_DAO.LoadDuLieuCD(IdCD);
txtChuD.Text = cd.Rows[0][1].ToString();
dtNgayHenTra.Value = DateTime.Parse(itemSelect.SubItems[6].Text);
txtSoLuong.ReadOnly = true;
btnSuaDsChon.Enabled = true;
}
private void lsvSach_Click(object sender, EventArgs e)
{
txtSoLuong.ReadOnly = false;
ListViewItem lvi = lsvSach.SelectedItems[0];
txtSach.Text = lvi.SubItems[0].Text;
itemSelect = lsvSach.SelectedItems[0];
indexItemSelect = lsvSach.SelectedItems[0].Index;
IdCD = itemSelect.SubItems[4].Text;
IdSach = itemSelect.SubItems[5].Text;
GiaBan = itemSelect.SubItems[1].Text;
NhaXuatBan = itemSelect.SubItems[3].Text;
cd = ChuDe_DAO.LoadDuLieuCD(IdCD);
txtChuD.Text = cd.Rows[0][1].ToString();
}
private void LoadDocGia()
{
ThoiGianNow.DateTime = DateTime.Now;
cboTenNhanVien.DataSource = NhanVien_DAO.LoadDuLieu();
cboTenNhanVien.DisplayMember = "HoTen";
cboTenNhanVien.ValueMember = "MaNV";
cboTenChuDe.DataSource = ChuDe_DAO.LoadDuLieu();
cboTenChuDe.DisplayMember = "TenCD";
cboTenChuDe.ValueMember = "MaCD";
cboTenChuDe.Text = "";
cboNhaXuatBan.DataSource = NhaXuatBan_DAO.LoadDuLieu();
cboNhaXuatBan.DisplayMember = "TenNXB";
cboNhaXuatBan.ValueMember = "MaNXB";
cboNhaXuatBan.Text = "";
}
public static ChuDe_DTO LayThongTinChiTietChuDeBoiMa(string machude)
{
return(ChuDe_DAO.LayThongTinChiTietChuDeBoiMa(machude));
}
public static List <ChuDe_DTO> LayDanhSachChuDe()
{
return(ChuDe_DAO.LayDanhSachChuDe());
}
