Esempi in C# (CSharp) per DAL Unility.AExcuteSQL

Esempio n. 1

 public static int Quyen(string TenDangNhap)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT sum(Role) FROM tb_DangNhap WHERE TenDangNhap = N'{0}'", TenDangNhap)));
 }

Esempio n. 2

 public static int kiemTraTonTai(string TenDangNhap)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_DangNhap WHERE TenDangNhap = N'{0}'", TenDangNhap)));
 }

Esempio n. 3

 public static int DangNhap(string TenDangNhap, string matKhau)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_DangNhap WHERE TenDangNhap = N'{0}' and MatKhau = '{1}'", TenDangNhap, matKhau)));
 }

Esempio n. 4

 public static int kiemTraTonTai(string MaHDB)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_HoaDonBan WHERE MaHoaDonBan = N'{0}'", MaHDB)));
 }

Esempio n. 5

 public static int kiemTraTonTai(tb_DangNhapDBO obj)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_NhanVien WHERE TenDangNhap = N'{0}'", obj.TenDangNhap)));
 }

Esempio n. 6

 public static int kiemTraTonTai(string MaMH)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_MatHang WHERE MaMatHang =N'{0}'", MaMH)));
 }

Esempio n. 7

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

Esempio n. 8

 public static int kiemTraTonTai(string MaNCC)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_NhaCungCap WHERE MaNhaCungCap =N'{0}'", MaNCC)));
 }

Esempio n. 9

 public static int kiemTraTonTai(tb_ChiTietHoaDonNhapDBO obj)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT COUNT(*) FROM tb_ChiTietHoaDonNhap WHERE MaCTHDN=N'{0}'", obj.MaCTHDN)));
 }

Esempio n. 10

File: tb_NhanVienDAL.cs Progetto: Tienthanhtk11/QLBANHANGHUMG2

 public static int kiemTraTonTai(string MaNV)
 {
     return(Unility.AExcuteSQL(string.Format("SELECT count(*) FROM tb_NhanVien WHERE MaNhanVien =N'{0}'", MaNV)));
 }