public string TonKho_HangHoa(EC_dmHangHoa etdm)
{
return(cn.LayGiaTri("EXEC SPU_TonKho_HangHoa " + etdm.MaHang));
}
public void SuaDuLieu(EC_dmHangHoa et)
{
cn.ThucThiSQL("UPDATE dmHangHoa SET TenHang =N'" + et.TenHang + "', DonViTinh =N'" + et.DonViTinh + "', MaNhom ='" + et.MaNhom + "', GiaPhong =" + et.GiaPhong + ", GiaBan =" + et.GiaBan + ", GioiHanTon =" + et.GioiHanTon + ", GhiChu = N'" + et.GhiChu + "' where MaHang=" + et.MaHang);
}
public void XoaDuLieu(EC_dmHangHoa et)
{
cn.ThucThiSQL("DELETE FROM dmHangHoa where MaHang=" + et.MaHang);
}
public void ThemDuLieu(EC_dmHangHoa et)
{
cn.ThucThiSQL(@"INSERT INTO dmHangHoa (TenHang, DonViTinh, MaNhom, GiaPhong, GiaBan, GioiHanTon, GhiChu)
VALUES (N'" + et.TenHang + "',N'" + et.DonViTinh + "','" + et.MaNhom + "'," + et.GiaPhong + "," + et.GiaBan + "," + et.GioiHanTon + ",N'" + et.GhiChu + "')");
}
public string TonKho_HangHoa(EC_dmHangHoa etdm)
{
return(SQL.TonKho_HangHoa(etdm));
}
// delete data
public void XoaDuLieu(EC_dmHangHoa et)
{
SQL.XoaDuLieu(et);
}
//-------- update data
public void SuaDuLieu(EC_dmHangHoa et)
{
SQL.SuaDuLieu(et);
}
public void ThemDuLieu(EC_dmHangHoa et)
{
SQL.ThemDuLieu(et);
}
