public bool XoaHang(Businessobject.CSanpham objec)
{
try
{
SqlCommand cmd = new SqlCommand("delete from MatHang where MAHANG=N'" + objec.Mahang + "'");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{
return(false);
}
}
public bool CapnhatHang(Businessobject.CSanpham objec)
{
try
{
SqlCommand cmd = new SqlCommand("update MatHang set TENHANG=N'" +
objec.Tenhang + "',SOLUONG=" +
objec.Soluong + ",DGBAN=" +
objec.Dongia + ",THONGTINBAOHANH=N'" +
objec.ThongtinBH + "',DONVITINH=N'" +
objec.DVtinh + "',MOTA=N'" +
objec.Mota + "',MANHACUNGCAP=N'" +
objec.MaNCC + "' where MAHANG=N'" + objec.Mahang + "'");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{ }
return(false);
}
public bool ThemHang(Businessobject.CSanpham objec)
{
try
{
SqlCommand cmd = new SqlCommand("insert into MatHang values(N'" +
objec.Mahang + "',N'" +
objec.Tenhang + "',N'" +
objec.Soluong + "',N'" +
objec.Dongia + "',N'" +
objec.ThongtinBH + "',N'" +
objec.DVtinh + "',N'" +
objec.Mota + "',N'" +
objec.MaNCC + "')");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{ return(false); }
}
