//ham sua
public void SuaDuLieu(EC_tblXuatKho et)
{
cn.ThucThiCauLenhSQL("UPDATE tblXuatKho SET HHMa =N'" + et.HHMa + "', KMa =N'" + et.KMa + "', DVMa =N'" + et.DVMa + "', XKSL =N'" + et.XKSL + "', XKGia =N'" + et.XKGia + "', KHMa =N'" + et.KHMa + "'," +
" XKNgay =N'" + et.XKNgay + "',XKThanhTien=N'" + et.XKThanhTien + ", WHERE XKMa=N'" + et.XKMa + "'");
}
//ham xoa
public void XoaDuLieu(EC_tblXuatKho et)
{
cn.ThucThiCauLenhSQL("DELETE from tblXuatKho WHERE XKMa=N'" + et.XKMa + "'");
}
//ham them du lieu
public void ThemDuLieu(EC_tblXuatKho et)
{
cn.ThucThiCauLenhSQL("INSERT INTO tblXuatKho (HHMa, KMa, DVMa, XKMa, XKSL, XKGia, KHMa, XKNgay,XKThanhTien) VALUES (N'" + et.HHMa + "',N'" + et.KMa + "'" +
",N'" + et.DVMa + "',N'" + et.XKMa + "',N'" + et.XKSL + "',N'" + et.XKGia + "',N'" + et.KHMa + "',N'" + et.XKNgay + "',(" + et.XKSL + "*" + et.XKGia + "))");
}
