public void Sua_Tatca(EC_tblChiTietPhieuNhap et)
{
cn.ThucThiCauLenhSQL(@"UPDATE tblChiTietPhieuNhap SET MaHH = " + et.MaHH + " , SoLuong = " + et.SoLuong + " , DonGia = " + et.DonGia + " where MaPN = '" + et.MaPN + "' and MAHH = '" + et.MaHH + "'");
}
public void Them_TT(EC_tblChiTietPhieuNhap et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO tblChiTietPhieuNhap (MaPN,MaHH,SoLuong,DonGia, ThanhTien) VALUES ('" + et.MaPN + "','" + et.MaHH + "'," + et.SoLuong + "," + et.DonGia + et.ThanhTien + ")");
}
public void Xoa(EC_tblChiTietPhieuNhap et)
{
cn.ThucThiCauLenhSQL(@"DELETE FROM tblChiTietPhieuNhap where MaPN = '" + et.MaPN + "'and MaHH = '" + et.MaHH + "'");
}
public void Them_TT(EC_tblChiTietPhieuNhap et)
{
sql.Them_TT(et);
}
public void Xoa(EC_tblChiTietPhieuNhap et)
{
sql.Xoa(et);
}
public void Sua(EC_tblChiTietPhieuNhap et)
{
sql.Sua(et);
}
