private DataTable GetMaNV(string tk, string mk) { string sqlstr = "select * from NhanVien where TaiKhoan = N'" + tk + "' and MatKhau = N'" + mk + "'"; DataTable kq = ConnectSQL.GetData(sqlstr); return(kq); }
private bool Login(string tk, string mk) { string sqlstr = "select * from NhanVien where TaiKhoan = N'" + tk + "' and MatKhau = N'" + mk + "'"; DataTable kq = ConnectSQL.GetData(sqlstr); return(kq.Rows.Count > 0); }
public DataTable TimKiemNhanVien(string tukhoa) { //Dùng winform /* * string strsql = "select MaNV, TenNhanVien, ChucVu,SoDT,DiaChi,NgaySinh from NhanVien where 1=1"; * //Nếu tên có thông tin thì lọc * if(!string.IsNullOrWhiteSpace(tukhoa)) * { * strsql += string.Format(" and (MaNV = '{0}' or TenNhanVien like N'%{1}%')",tukhoa,tukhoa); * }*/ //Sử dụng thủ tục string strsql = "execute sp_timkiem N'" + tukhoa + "'"; return(ConnectSQL.GetData(strsql)); }
public DataTable GetDataMayBay() { string sqlstr = "select * from MayBay"; return(ConnectSQL.GetData(sqlstr)); }
public DataTable ChiTietTheoMa(string manv) { return(ConnectSQL.GetData("select MaNV, TenNhanVien,GioiTinh, ChucVu,SoDT,DiaChi,NgaySinh,TaiKhoan from NhanVien where MaNV = '" + manv + "'")); }
public DataTable GetDataNV() { string strsql = "select MaNV, TenNhanVien,GioiTinh, ChucVu,SoDT,DiaChi,NgaySinh from NhanVien"; return(ConnectSQL.GetData(strsql)); }