public FormBanHangThem(bool isThem, string title, string maHDBH, ChiTietHDBH obj)
{
InitializeComponent();
this.isThem = isThem;
this.Text = title;
this.maHDBH = maHDBH;
this.obj = obj;
}
private void btnBH_Sua_Click(object sender, EventArgs e)
{
if (dgvBH.CurrentRow.Index < 0)
{
return;
}
// try
{
ChiTietHDBH obj = new ChiTietHDBH();
// MessageBox.Show("mahdbh-mahh:" + txtBH_MaHD.Text + " " + dgvBH.CurrentRow.Cells["MaHH"].Value.ToString());
obj = banHangBUS.HoaDonBanHang_Query(txtBH_MaHD.Text)[dgvBH.CurrentRow.Index];// cthdbh.ChiTietHDBH_GetByTop("", "MaHDBH = '"++"' and MaHH ='" + dgvBH.CurrentRow.Cells["MaHH"].Value.ToString() + "'", "")[0];
new FormBanHangThem(false, "Sửa", txtBH_MaHD.Text, obj).ShowDialog();
}
// catch
{
//MessageBox.Show("Chọn 1 sản phẩm muốn sửa!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool ChiTietHDBH_Update(ChiTietHDBH data)
{
return(obj.ChiTietHDBH_Update(data));
}
public bool ChiTietHDBH_Insert(ChiTietHDBH data)
{
return(obj.ChiTietHDBH_Insert(data));
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (checkValid())
{
//them vao ct hoa don
ChiTietHDBH hh = new ChiTietHDBH();
hh.MaHDBH = maHDBH;
if (String.IsNullOrEmpty(cmbThemHH.SelectedValue.ToString()))
{
MessageBox.Show("Nhập đầy đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
hh.MaHH = cmbThemHH.SelectedValue.ToString();
}
HangHoaObj o1 = hhBUS.HangHoa_GetByTop("", "MaHH='" + hh.MaHH + "'", "")[0];
hh.MaLoai = o1.MaLoai;
hh.TenLoai = loaiHangBUS.LoaiHang_GetByTop("", "MaLoai='" + hh.MaLoai + "'", "")[0].TenLoai;
hh.SoLuongMua = txtSoLuong.Text;
hh.GiaBan = txtGia.Text;
bool isExisted = false;
var lst = new HoaDonBanHangBUS().HoaDonBanHang_Query("", " and tb_HDBanHang.MaHDBH='" + hh.MaHDBH + "' and tb_HangHoa.MaHH='" + hh.MaHH + "'", "");
if (lst.Count == 1)
{
isExisted = true;
}
else
{
isExisted = false;
}
if (isThem)
{
if (!isExisted)
{
if (cthdbhBUS.ChiTietHDBH_Insert(hh))
{
MessageBox.Show("Ok Add 1 item");
}
else
{
MessageBox.Show("Fail Add 1 item");
}
}
else
{
int sl = int.Parse(lst[0].SoLuongMua);
hh.SoLuongMua = (sl + int.Parse(txtSoLuong.Text)).ToString();
if (cthdbhBUS.ChiTietHDBH_Update(hh))
{
MessageBox.Show("Ok Add 1 item!");
}
else
{
MessageBox.Show(" Fail Add 1 item!");
}
}
}
else
{
if (cthdbhBUS.ChiTietHDBH_Update(hh))
{
MessageBox.Show("Ok Update 1 item");
}
else
{
MessageBox.Show("Fail Update 1 item");
}
}
// ucBH.bindDataGridView();
}
else
{
txtSoLuong.Focus();
}
}
