public static int kiemTraTonTai(tb_ChiTietHoaDonBanDBO obj) { return(tb_ChiTietHoaDonBanDAL.kiemTraTonTai(obj)); }
public static void sua(tb_ChiTietHoaDonBanDBO obj, string MaMatHangCu) { tb_ChiTietHoaDonBanDAL.sua(obj, MaMatHangCu); }
public static void xoa(tb_ChiTietHoaDonBanDBO obj) { tb_ChiTietHoaDonBanDAL.xoa(obj); }
public static void them(tb_ChiTietHoaDonBanDBO obj) { tb_ChiTietHoaDonBanDAL.them(obj); }
public static int kiemTraTonTai(tb_ChiTietHoaDonBanDBO obj) { return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_ChiTietHoaDonBan WHERE MaCTHDB=N'{0}' and MaHoaDonBan = N'{1}' and MaMatHang = N'{2}'", obj.MaCTHDB, obj.MaHoaDonBan, obj.MaMatHang))); }
public static void xoa(tb_ChiTietHoaDonBanDBO obj) { Unility.ExcuteSQL(string.Format("DELETE FROM tb_ChiTietHoaDonBan WHERE MaCTHDB=N'{0}' and MaHoaDonBan = N'{1}' and MaMatHang = N'{2}'", obj.MaCTHDB, obj.MaHoaDonBan, obj.MaMatHang)); }
public static void sua(tb_ChiTietHoaDonBanDBO obj, string MaMatHang) { Unility.ExcuteSQL(string.Format("UPDATE tb_ChiTietHoaDonBan SET MaMatHang = N'{5}' ,DonGia = N'{3}',SoLuong = N'{4}' WHERE MaCTHDB=N'{0}' and MaHoaDonBan = N'{1}' and MaMatHang = N'{2}'", obj.MaCTHDB, obj.MaHoaDonBan, obj.MaMatHang, obj.DonGia, obj.SoLuong, MaMatHang)); }
public static void them(tb_ChiTietHoaDonBanDBO obj) { Unility.ExcuteSQL(string.Format("INSERT INTO tb_ChiTietHoaDonBan (MaCTHDB,MaHoaDonBan,MaMatHang,DonGia,SoLuong) VALUES (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}')", obj.MaCTHDB, obj.MaHoaDonBan, obj.MaMatHang, obj.DonGia, obj.SoLuong)); }