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 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 NhaXuatBan_DTO TimNXB_TheoMa(string MaNXB)
{
return(NhaXuatBan_DAO.TimNXB_TheoMa(MaNXB));
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
// LoadDSSach();
lsvSach.Items.Clear();
if (txtTenSach.Text == "" && cboTenChuDe.Text == "" && cboNhaXuatBan.Text == "")
{
MessageBox.Show("Bạn chưa nhập thông tin tìm kiếm", "Thông báo");
}
else
{
if (txtTenSach.Text != "")
{
LoadDSSach();
ListViewItem item = lsvSach.FindItemWithText(txtTenSach.Text);
if (item == null)
{
MessageBox.Show("Thư viện không có sách này!", "Thông báo");
}
else
{
FindItem = item;
lsvSach.TopItem = item;
item.BackColor = SystemColors.Highlight;
item.ForeColor = SystemColors.HighlightText;
}
}
else
{
lsvSach.Items.Clear();
string temp = "";
DataTable dt = new DataTable();
DataTable cd = new DataTable();
DataTable nxb = new DataTable();
AutoCompleteStringCollection ac = new AutoCompleteStringCollection();
if (cboTenChuDe.Text != "")
{
temp = cboTenChuDe.SelectedValue.ToString();
dt = Sach_DAO.LoadDuLieuCD(temp);
}
else
if (cboNhaXuatBan.Text != "")
{
temp = cboNhaXuatBan.SelectedValue.ToString();
dt = Sach_DAO.LoadDuLieuNXB(temp);
}
if (dt.Rows.Count == 0)
{
MessageBox.Show("Nhập sai nhà xuất bản hoặc tên chủ đề", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ListViewItem lvi = new ListViewItem(dt.Rows[i][1].ToString()); // ten Sach
lvi.SubItems.Add(dt.Rows[i][2].ToString()); // Gia Ban
lvi.SubItems.Add(dt.Rows[i][4].ToString()); // So Luong
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()); //IDCD
lvi.SubItems.Add(dt.Rows[i][0].ToString()); //IDSach
lsvSach.Items.Add(lvi);
}
}
}
txtTenSach.Text = "";
cboNhaXuatBan.Text = "";
cboTenChuDe.Text = "";
}
}
public static List <NhaXuatBan_DTO> TimNXB(string dk, string giatri)
{
return(NhaXuatBan_DAO.TimNXB(dk, giatri));
}
public static bool SuaNXB(NhaXuatBan_DTO NXB)
{
return(NhaXuatBan_DAO.SuaNXB(NXB));
}
public static bool XoaNXB(string maNXB)
{
return(NhaXuatBan_DAO.XoaNXB(maNXB));
}
public static bool ThemNXB(NhaXuatBan_DTO NXB)
{
return(NhaXuatBan_DAO.ThemNXB(NXB));
}
public static List <NhaXuatBan_DTO> LayDSTK()
{
return(NhaXuatBan_DAO.LayDSNXB());
}
