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