public void UpdateMatHang(DTO_MatHang mhDTO)
{
helper.ThucHienCauLenhSQL("UPDATE MatHang SET TenMH =N'" + mhDTO.TenMH + "', TenNSX =N'" + mhDTO.TenNSX + "', MaDVT =N'" + mhDTO.MaDVT + "', ThueVAT =N'" + mhDTO.ThueVAT + "', where MaMH = N'" + mhDTO.MaMH + "'");
}
public void InsertMatHang(DTO_MatHang mhDTO)
{
helper.ThucHienCauLenhSQL("INSERT INTO MatHang (MaMH, TenMH,TenNSX,MaDVT,ThueVAT) VALUES (N'" + mhDTO.MaMH + "',N'" + mhDTO.TenMH + "',N'" + mhDTO.TenNSX + "',N'" + mhDTO.MaDVT + "',N'" + mhDTO.ThueVAT + "')");
}
public void DeleteMatHang(DTO_MatHang mhDTO)
{
helper.ThucHienCauLenhSQL("DELETE from MatHang Where MaMH = N'" + mhDTO.MaMH + "'");
}
public void XoadulieuMatHang(DTO_MatHang et)
{
mh.DeleteMatHang(et);
}
public void ThemdulieuMatHang(DTO_MatHang et)
{
//truyền vào đối tượng thôi.
mh.InsertMatHang(et);
}
public void SuadulieuMatHang(DTO_MatHang et)
{
mh.UpdateMatHang(et);
}