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();
}
