private void btnOK_Click(object sender, EventArgs e)
{
if (txtMaHang.Text != "" || txtDonViTinh.Text != "" || txtGiaBan.Text != "" || txtTenHang.Text != "")
{
tb_MatHangDBO obj = new tb_MatHangDBO();
obj.MaMatHang = txtMaHang.Text;
obj.TenMatHang = txtTenHang.Text;
obj.MaNhaCungCap = cbbNhaCC.SelectedValue.ToString();
obj.MaNhomHang = cbbNhomHang.SelectedValue.ToString();
obj.DVT = txtDonViTinh.Text;
obj.GiaBan = Convert.ToDouble(txtGiaBan.Text);
obj.NgayCapNhat = Convert.ToDateTime(dtNgayCapNhat.Value);
if (flag == "them")
{
if (tb_MatHangBLL.kiemTraTonTai(obj.MaMatHang) == 1)
{
MessageBox.Show("Thông Báo Đã tồn tại!");
}
else
{
tb_MatHangBLL.them(obj);
MessageBox.Show("Thêm thành công!");
this.Dispose();
}
}
else if (flag == "sua")
{
tb_MatHangBLL.sua(obj);
MessageBox.Show("Sửa thành công!");
this.Dispose();
}
}
}
public static void sua(tb_MatHangDBO obj)
{
Unility.ExcuteSQL(string.Format("UPDATE tb_MatHang SET TenMatHang = N'{1}' ,MaNhaCungCap = N'{2}',MaNhomHang = N'{3}',DVT = N'{4}',GiaBan = N'{5}',NgayCapNhat = N'{6}' WHERE MaMatHang = N'{0}'", obj.MaMatHang, obj.TenMatHang, obj.MaNhaCungCap, obj.MaNhomHang, obj.DVT, obj.GiaBan, obj.NgayCapNhat));
}
public static void them(tb_MatHangDBO obj)
{
Unility.ExcuteSQL(string.Format("INSERT INTO tb_MatHang (MaMatHang ,TenMatHang ,MaNhaCungCap ,MaNhomHang ,DVT ,GiaBan ,NgayCapNhat) VALUES (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}')", obj.MaMatHang, obj.TenMatHang, obj.MaNhaCungCap, obj.MaNhomHang, obj.DVT, obj.GiaBan, obj.NgayCapNhat));
}
public static void sua(tb_MatHangDBO obj)
{
tb_MatHangDAL.sua(obj);
}
public static void them(tb_MatHangDBO obj)
{
tb_MatHangDAL.them(obj);
}
