C# (CSharp) DAL Unility.AExcuteSQL示例

示例#1

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

示例#2

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

示例#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)));
 }

示例#4

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

示例#5

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

示例#6

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

示例#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)));
 }

示例#8

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

示例#9

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

示例#10

文件： tb_NhanVienDAL.cs 项目： Tienthanhtk11/QLBANHANGHUMG2

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