public string LayMaNhanVien() { //SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi(); string query = "SELECT COUNT(*) FROM NhanVien"; //SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con); //string maNV = cmd.ExecuteScalar().ToString(); return(ThaoTacDuLieu_DAO.ExecuteScalar(query).ToString()); }
public string LayMaKhachHang() { string query = "SELECT COUNT(*) FROM KhachHang"; return(ThaoTacDuLieu_DAO.ExecuteScalar(query).ToString()); }
public bool KiemTraKhachHangDaCoThe(string maKH) { string query = string.Format("SELECT COUNT(*) FROM TheKhachHang WHERE ma_khach_hang = '{0}' AND trang_thai = '{1}'", maKH, true); return((int)ThaoTacDuLieu_DAO.ExecuteScalar(query) > 0); }
public string LayMaTuDong() { return(ThaoTacDuLieu_DAO.ExecuteScalar("SELECT COUNT(*) FROM ChiTietBanPhanCong").ToString()); }