private void button2_Click(object sender, EventArgs e) { listView1.Clear(); TaiLieuu tl = new TaiLieuu(); string matailieu = tl.laymatailieu(cbbtimkiemtheotheloai.Text); string conn = @"Data Source=LAPTOP-VA3QE2VM\SQLEXPRESS;Initial Catalog=LTWNC;Integrated Security=True"; SqlConnection con = new SqlConnection(conn); con.Open(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand("select * from QL_ChiTietTaiLieu where TenChiTiet LIKE N'%" + txttimkiem.Text + "%'", con); DataTable dt = new DataTable(); adapter.Fill(dt); //dataGridView1.DataSource = dt; int imageindex = 0; for (int i = 0; i < dt.Rows.Count; i++) { imageList1.Images.Add(byteArrayToImage((byte[])dt.Rows[i][8])); var viewitem = new ListViewItem(dt.Rows[i][12].ToString()); { }; viewitem.ImageIndex = imageindex; listView1.Items.Add(viewitem); imageindex++; } }
private void btnLuu_Click_1(object sender, EventArgs e) { if (themhaysua == "them") { TaiLieuu tl = new TaiLieuu(); if (tl.themtailieu(txtMaTaiLieu.TextName, txtTheLoai.TextName, txtSoLuong.Text, txtNguoiNhap.TextName, txtNgayNhap.TextName, txtTongGia.TextName) == true) { MessageBox.Show("Thêm thành công!"); ancbbtxt(); loadDataG(); } else { MessageBox.Show("Thêm thất bại!"); } } if (themhaysua == "sua") { TaiLieuu tl = new TaiLieuu(); if (tl.suatailieu(txtMaTaiLieu.TextName, txtTheLoai.TextName) == true) { MessageBox.Show("Sửa thành công!"); loadDataG(); } else { MessageBox.Show("Sửa thất bại!"); } } else { MessageBox.Show("Chưa có dữ liệu để lưu!"); } }
public void load2() { ManHinh mh = new ManHinh(); dataGridView2.DataSource = mh.load(manhom); TaiLieuu tl = new TaiLieuu(); cbbtimkiemtheotheloai.DataSource = tl.loadcbbtentheloai(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { TaiLieuu tl = new TaiLieuu(); string matailieu = tl.laymatailieu(comboBox1.Text); // TODO: This line of code loads data into the 'DataSet1.QL_ChiTietTaiLieu' table. You can move, or remove it, as needed. this.QL_ChiTietTaiLieuTableAdapter.Fill(this.DataSet1.QL_ChiTietTaiLieu, matailieu); this.reportViewer1.RefreshReport(); this.reportViewer1.RefreshReport(); this.reportViewer1.RefreshReport(); }
void load() { TaiLieuu tl = new TaiLieuu(); string matailieu = tl.laymatailieu(comboBox1.Text); // TODO: This line of code loads data into the 'DataSet1.QL_ChiTietTaiLieu' table. You can move, or remove it, as needed. // this.QL_ChiTietTaiLieuTableAdapter.Fill(this.DataSet1.QL_ChiTietTaiLieu, matailieu); this.QL_ChiTietTaiLieuTableAdapter.FillBy(this.DataSet1.QL_ChiTietTaiLieu); this.reportViewer1.RefreshReport(); this.reportViewer1.RefreshReport(); this.reportViewer1.RefreshReport(); comboBox1.Enabled = false; }
public frmTaiLieu2(string matailieu) { InitializeComponent(); load(); this.matailieu = matailieu; loadDataG(); customdataG(); loadcbb(); // load ten danh muc TaiLieu tl = new TaiLieu(); label17.Text = tl.loadTenDanhMuc(matailieu); TaiLieuu tl2 = new TaiLieuu(); }
private void btnLuu_Click_1(object sender, EventArgs e) { if (themhaysua == "them") { TaiLieu tl = new TaiLieu(); if (cbbTenChiTiet.Text == "" || cbbTacGia.Text == "" || cbbSoLuong.Text == "" || cbbNhaXB.Text == "" || cbbNhaCC.Text == "" || txtGiaBia.Text == "" || txtGiaNhap.Text == "" || txtLink.Text == "" || txtNgayNhap.Text == "" || txtNguoiNhap.Text == "" || txtSoTrang.Text == "" || pictureBox1.Image == null || pictureBox2.Image == null) { MessageBox.Show("Vui lòng điền đầy đủ thông tin!"); } else { if (tl.themTaiLieu(cbbMaChiTiet.Text, cbbMaTaiLieu.Text, cbbNhaCC.Text, cbbNhaXB.Text, cbbTacGia.Text, cbbViTri.Text, cbbSoLuong.Text, txtLink.Text, txtSoTrang.Text, luuAnhtoSql(pictureBox1.Image), luuAnhtoSql(pictureBox2.Image), txtGiaBia.Text, txtGiaNhap.Text, txtNgayNhap.Text, txtNguoiNhap.Text, cbbTenChiTiet.Text) == true) { MessageBox.Show("Thêm thành công!"); // cap nhat so luong tai lieu TaiLieuu tl2 = new TaiLieuu(); tl2.tinhTongSoLuongTL(matailieu); tl2.tinhTongGiaNhap(matailieu); loadDataG(); } else { MessageBox.Show("Thêm thất bại!"); } } } if (themhaysua == "sua") { TaiLieu tl = new TaiLieu(); if (tl.SuaTaiLieu(cbbMaChiTiet.Text, cbbTenChiTiet.Text, cbbNhaCC.Text, cbbNhaXB.Text, cbbTacGia.Text, cbbViTri.Text, cbbSoLuong.Text, txtLink.Text, txtSoTrang.Text, luuAnhtoSql(pictureBox2.Image), luuAnhtoSql(pictureBox1.Image), txtGiaBia.Text, txtGiaNhap.Text) == true) { MessageBox.Show("Sửa thành công!"); loadDataG(); } else { MessageBox.Show("Sửa thất bại!"); } } else { MessageBox.Show("Chưa có dữ liệu!"); } }
private void btnXoa_Click_1(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Bạn có chắc chắn muốn xóa?", "Thông báo!", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { TaiLieuu tl = new TaiLieuu(); if (tl.xoatailieu(txtMaTaiLieu.TextName) == true) { MessageBox.Show("Xóa thành công!"); loadDataG(); } else { MessageBox.Show("Xóa thất bại!"); } } else if (dialogResult == DialogResult.No) { } }
private void btnloc_Click(object sender, EventArgs e) { if (rbtntheloai.Checked) { cbbtimkiemtheotheloai.Enabled = true; listView1.Clear(); TaiLieuu tl = new TaiLieuu(); string matailieu = tl.laymatailieu(cbbtimkiemtheotheloai.Text); string conn = @"Data Source=LAPTOP-VA3QE2VM\SQLEXPRESS;Initial Catalog=LTWNC;Integrated Security=True"; SqlConnection con = new SqlConnection(conn); con.Open(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand("select * from QL_ChiTietTaiLieu where MaTaiLieu = '" + matailieu + "' ", con); DataTable dt = new DataTable(); adapter.Fill(dt); //dataGridView1.DataSource = dt; int imageindex = 0; for (int i = 0; i < dt.Rows.Count; i++) { imageList1.Images.Add(byteArrayToImage((byte[])dt.Rows[i][8])); var viewitem = new ListViewItem(dt.Rows[i][12].ToString()); { }; viewitem.ImageIndex = imageindex; listView1.Items.Add(viewitem); imageindex++; } } else if (rbtntatca.Checked) { listView1.Clear(); loadListView(); } else { MessageBox.Show("Chưa có dữ liệu!"); } }
void loadcbb() { TaiLieuu tl = new TaiLieuu(); comboBox1.DataSource = tl.loadcbbtailieu(); }
void loadata() { TaiLieuu tl = new TaiLieuu(); dataGridView1.DataSource = tl.loadDataG(); }