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