C# (CSharp) tb_ChiTietHoaDonBanDBO Examples

Example #1

File: tb_ChiTietHoaDonBanBLL.cs Project: Tienthanhtk11/QLBANHANGHUMG2

 public static int kiemTraTonTai(tb_ChiTietHoaDonBanDBO obj)
 {
     return(tb_ChiTietHoaDonBanDAL.kiemTraTonTai(obj));
 }

Example #2

File: tb_ChiTietHoaDonBanBLL.cs Project: Tienthanhtk11/QLBANHANGHUMG2

 public static void sua(tb_ChiTietHoaDonBanDBO obj, string MaMatHangCu)
 {
     tb_ChiTietHoaDonBanDAL.sua(obj, MaMatHangCu);
 }

Example #3

File: tb_ChiTietHoaDonBanBLL.cs Project: Tienthanhtk11/QLBANHANGHUMG2

 public static void xoa(tb_ChiTietHoaDonBanDBO obj)
 {
     tb_ChiTietHoaDonBanDAL.xoa(obj);
 }

Example #4

File: tb_ChiTietHoaDonBanBLL.cs Project: Tienthanhtk11/QLBANHANGHUMG2

 public static void them(tb_ChiTietHoaDonBanDBO obj)
 {
     tb_ChiTietHoaDonBanDAL.them(obj);
 }

Example #5

 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)));
 }

Example #6

 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));
 }

Example #7

 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));
 }

Example #8

 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));
 }