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