private void btnthem_Click(object sender, EventArgs e)
{
if (txttensp.Text == "" || txtdongia.Text == "" || txtsoluong.Text == "" || IsNumber(txtsoluong.Text) == false || IsNumber(txtdongia.Text) == false)
{
MessageBox.Show("Thông tin sản phẩm chưa đầy đủ, vui lòng kiểm tra lại !");
}
else
{
Sanpham_DTO spDTO = new Sanpham_DTO();
spDTO.STenSP = txttensp.Text;
spDTO.SSoLuong = int.Parse(txtsoluong.Text);
spDTO.SDonGia = int.Parse(txtdongia.Text);
spDTO.STGBH = int.Parse(cbtgbh.Text);
spDTO.STrangThai = cbtrangthai.Text;
spDTO.SMaSP = txtmasp.Text;
spDTO.SMaLoai = cbmaloai.SelectedValue.ToString();
spDTO.SMaNCC = cbmancc.SelectedValue.ToString();
if (Sanpham_BUS.Themsp(spDTO) == true)
{
MessageBox.Show("Lưu thành công");
LoadDgvSanPham();
}
else
{
MessageBox.Show("Thất bại!");
}
btncapnhat.Enabled = true;
btnxoa.Enabled = true;
}
}
private void QLSP_Load(object sender, EventArgs e)
{
txtmasp.Enabled = false;
LoadDgvSanPham();
groupBox1.Enabled = false;
try
{
Sanpham_BUS x = new Sanpham_BUS();
txtmasp.Text = x.XuLyMaSP();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
cbtrangthai.SelectedIndex = 0;
cbtgbh.SelectedIndex = 0;
DataTable dt = new DataTable();
DataTable listCombox = Sanpham_BUS.GetTableLSP();
cbmaloai.DisplayMember = "TENLOAI";//Word là tên trường bạn muốn hiển thị trong combobox
cbmaloai.ValueMember = "MALOAI";
cbmaloai.DataSource = listCombox;
DataTable dt2 = new DataTable();
DataTable listCombox2 = Sanpham_BUS.GetNCC();
cbmancc.DisplayMember = "TENNCC";//Word là tên trường bạn muốn hiển thị trong combobox
cbmancc.ValueMember = "MANCC";
cbmancc.DataSource = listCombox2;
}
//private void dgvdmsp_CellContentClick(object sender, DataGridViewCellEventArgs e)
//{
// DataGridViewRow dr = dgvdmsp.SelectedRows[0];
// txtmasp.Text = dr.Cells["SMaSP"].Value.ToString();
// txttensp.Text = dr.Cells["STenSP"].Value.ToString();
// cbtgbh.Text = dr.Cells["STGBH"].Value.ToString();
// txtsoluong.Text = dr.Cells["SSoLuong"].Value.ToString();
// cbtrangthai.Text = dr.Cells["STrangThai"].Value.ToString();
// txtdongia.Text = dr.Cells["SDonGia"].Value.ToString();
// cbmaloai.SelectedValue = dr.Cells["SMaLoai"].Value.ToString();
// cbmancc.SelectedValue = dr.Cells["SMaNCC"].Value.ToString();
//}
private void btnxoa_Click(object sender, EventArgs e)
{
Sanpham_DTO spDTO = new Sanpham_DTO();
spDTO.SMaSP = txtmasp.Text;
//MessageBox.Show(spDTO.SMaSP);
//if (Sanpham_BUS.Xoasp(spDTO) == true)
//{
// MessageBox.Show("Xoa thanh cong");
// LoadDgvSanPham();
//}
//else
// MessageBox.Show("Xoa that bai!");
if (Sanpham_BUS.Checkxoasp(txtmasp.Text))
{
if (Sanpham_BUS.Xoasp(spDTO) == true)
{
MessageBox.Show("Đã xóa");
LoadDgvSanPham();
}
}
else
{
MessageBox.Show("Thất bại!");
}
}
private void btncapnhat_Click(object sender, EventArgs e)
{
//btnthem.Enabled = false;
Sanpham_DTO spDTO = new Sanpham_DTO();
spDTO.SMaSP = txtmasp.Text;
spDTO.STenSP = txttensp.Text;
spDTO.SSoLuong = int.Parse(txtsoluong.Text);
spDTO.SDonGia = int.Parse(txtdongia.Text);
spDTO.STGBH = int.Parse(cbtgbh.Text);
spDTO.STrangThai = cbtrangthai.Text;
spDTO.SMaSP = txtmasp.Text;
spDTO.SMaLoai = cbmaloai.SelectedValue.ToString();
spDTO.SMaNCC = cbmancc.SelectedValue.ToString();
if (Sanpham_BUS.Suasp(spDTO) == true)
{
MessageBox.Show("Cập nhật thành công");
LoadDgvSanPham();
}
else
{
MessageBox.Show("Thất bại!");
}
}
private void DMSP_Load(object sender, EventArgs e)
{
LoadDgvSanPham();
DataTable dt1 = new DataTable();
DataTable listCombox = Sanpham_BUS.GetTableLSP();
cblsp.DisplayMember = "TENLOAI";//Word là tên trường bạn muốn hiển thị trong combobox
cblsp.ValueMember = "MALOAI";
cblsp.DataSource = listCombox;
}
private void btlsp_Click(object sender, EventArgs e)
{
string sTukhoa = cblsp.SelectedValue.ToString();
List <Sanpham_DTO> lstkqsp = Sanpham_BUS.Locsp(sTukhoa);
if (lstkqsp.Count == 0)
{
MessageBox.Show("Khong co san pham can tim!");
}
else
{
dgvdanhmucsp.DataSource = lstkqsp;
}
}
private void btlsptinhtrang_Click(object sender, EventArgs e)
{
string sTukhoa = cblsptinhtrang.Text;
//MessageBox.Show(sTukhoa);
List <Sanpham_DTO> lstkqsp = Sanpham_BUS.Locsptt(sTukhoa);
try
{
dgvdanhmucsp.DataSource = lstkqsp;
}
catch (Exception ex)
{
MessageBox.Show("Khong co san pham can tim!");
}
}
private void bntimkiem_Click(object sender, EventArgs e)
{
string sTukhoa = txttukhoa.Text;
DataTable tbl = new DataTable();
tbl = Sanpham_BUS.Timkiemsp(sTukhoa);
//List<Sanpham_DTO> lstkqsp = new List<Sanpham_DTO>();
//lstkqsp = Sanpham_BUS.Timkiemsp(sTukhoa);
dgvdanhmucsp.DataSource = tbl;
//DataTable tblSanpham = Sanpham_BUS.Timkiemsp(txttukhoa.Text);
//dgvdanhmucsp.DataSource = tblSanpham;
}
private void LoadDgvSanPham()
{
List <Sanpham_DTO> lstSanpham = Sanpham_BUS.LoadSanpham();
dgvdanhmucsp.DataSource = lstSanpham;
dgvdanhmucsp.Columns["SMaSP"].HeaderText = "Mã SP";
dgvdanhmucsp.Columns["STenSP"].HeaderText = "Tên SP";
dgvdanhmucsp.Columns["STGBH"].HeaderText = "TG Bảo hành";
dgvdanhmucsp.Columns["SSoLuong"].HeaderText = "Số lượng";
dgvdanhmucsp.Columns["STrangThai"].HeaderText = "Trạng thái";
dgvdanhmucsp.Columns["SDonGia"].HeaderText = "Đơn giá";
dgvdanhmucsp.Columns["SMaLoai"].HeaderText = "Mã loại";
dgvdanhmucsp.Columns["SMaNCC"].HeaderText = "Mã NCC";
dgvdanhmucsp.Columns["SMaSP"].Width = 50;
dgvdanhmucsp.Columns["STGBH"].Width = 50;
dgvdanhmucsp.Columns["SSoLuong"].Width = 50;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Sanpham_BUS x = new Sanpham_BUS();
txtmasp.Text = x.XuLyMaSP();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
txtdongia.Clear();
txttensp.Clear();
txtsoluong.Clear();
groupBox1.Enabled = true;
btncapnhat.Enabled = false;
btluu.Enabled = true;
btnxoa.Enabled = false;
}
