public void XoaDuLieu(E_LoaiSP et)
{
sql.XoaDuLieu(et);
}
public void SuaDuLieu(E_LoaiSP et)
{
sql.SuaDuLieu(et);
}
public void ThemDuLieu(E_LoaiSP et)
{
sql.ThemDuLieu(et);
}
public void XoaDuLieu(E_LoaiSP et)
{
cn.ThucThiCauLenhSQL(@"DELETE from LoaiSP Where MaLoaiSP = N'" + et.MaLoaiSP + "')");
}
public void SuaDuLieu(E_LoaiSP et)
{
cn.ThucThiCauLenhSQL(@"UPDATE LoaiSP (MaLoaiSP, TenLoaiSP, DVT, GhiChu,MaKho, MaLoaiLoaiSP, SoLuong) " +
"VALUES (N'" + et.MaLoaiSP + "',N'" + et.TenLoaiSP + "',N'" + et.DVT + "',N'" + et.GhiChu + "',N'" + et.MaKho + "')");
}
public void ThemDuLieu(E_LoaiSP et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO LoaiSP (MaLoaiSP,TenLoaiSP,DVT,GhiChu,MaKho) " +
"VALUES (N'" + et.MaLoaiSP + "',N'" + et.TenLoaiSP + "',N'" + et.DVT + "',N'" + et.GhiChu + "')");
}
