void ShowPL() { PhanLoaiDAO p = new PhanLoaiDAO(); tlList.DataSource = p.GetListPhanLoai(); dgvTL.AlternatingRowsDefaultCellStyle.BackColor = Color.LightGray; }
void LoadCbPhanLoai() { PhanLoaiDAO phanloai = new PhanLoaiDAO(); cbTheLoai.DataSource = phanloai.GetListPhanLoai(); cbTheLoai.DisplayMember = "TenLoai"; }
private void txtSearchTLorNN_TextChanged(object sender, EventArgs e) { string key = txtSearchTLorNN.Text; if (radMaTL.Checked == true) { PhanLoaiDAO pl = new PhanLoaiDAO(); tlList.DataSource = pl.SearchPhanLoai(key); } if (radMaNN.Checked == true) { NgonNguDAO nn = new NgonNguDAO(); nnList.DataSource = nn.searchNgonNgu(key); } }
private void btnDeleteTL_Click(object sender, EventArgs e) { string matl = txtMaTL.Text; string tentl = txtTenTL.Text; PhanLoaiDAO pl = new PhanLoaiDAO(); if (pl.DeleteNgonNgu(matl)) { MessageBox.Show("Xóa Thể loại thành công"); ShowPL(); } else { MessageBox.Show("Có lỗi"); } }
private void btnAddTL_Click(object sender, EventArgs e) { string matl = TaoMaPL(); string tentl = txtTenTL.Text; PhanLoaiDAO pl = new PhanLoaiDAO(); if (pl.InsertNgonNgu(matl, tentl)) { MessageBox.Show("Thêm Thể loại thành công"); ShowPL(); } else { MessageBox.Show("Có lỗi"); } }
private void txtMaSach_TextChanged(object sender, EventArgs e) { try { string MaSach = dgvBook.SelectedCells[0].OwningRow.Cells["MaSach"].Value.ToString(); PhanLoaiDAO phanloai = new PhanLoaiDAO(); PhanLoai pl = phanloai.GetListPhanLoaiByMaSach(txtMaSach.Text); int index = -1; int i = 0; foreach (PhanLoai item in cbTheLoai.Items) { if (item.MaLoai == pl.MaLoai) { index = i; break; } i++; } cbTheLoai.SelectedIndex = index; NgonNguDAO nn = new NgonNguDAO(); NgonNgu ngonNgu = nn.GetListNgonNguByMaSach(txtMaSach.Text); int index1 = -1; int j = 0; foreach (NgonNgu item in cbNgonNgu.Items) { if (item.MaNgonNgu == ngonNgu.MaNgonNgu) { index1 = j; break; } j++; } cbNgonNgu.SelectedIndex = index1; } catch { } }
string TaoMaPL() { PhanLoaiDAO nv = new PhanLoaiDAO(); string old = nv.GetMaxMaPL(); old = old.TrimStart('L'); int newCode = int.Parse(old); newCode += 1; string code = "L"; if (newCode < 10) { code = code + "0" + newCode; } else { code = code + newCode; } return(code); }