//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 + "))"); }