public bool Login(string _name, string _pass)
{
string sql = @"select * from NHANVIEN WHERE TenDangNhap = '" + _name + "' AND MatKhau = '" + _pass + "'";
DataTable dn = con.GetDataTable(sql);
if (dn.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable HienThiSanPham(string dk)
{
return(con.GetDataTable(@"SELECT *FROM LOAIHANG" + dk));
}
public DataTable HienThiNhanVien(string dk)
{
return(con.GetDataTable(@"SELECT *FROM NHANVIEN" + dk));
}
public DataTable HienThiKhachHang(string dk)
{
return(con.GetDataTable(@"SELECT *FROM KHACHHANG" + dk));
}
public DataTable BangHangHoaBan(string dk)
{
return(con.GetDataTable(@"SELECT SANPHAM.MaSP, SANPHAM.TenSP, SANPHAM.SoLuong, SANPHAM.GiaBan, SANPHAM.MoTa, NHACUNGCAP.DiaChi " +
"FROM SANPHAM INNER JOIN NHACUNGCAP ON SANPHAM.NhaCC = NHACUNGCAP.TenNCC " + dk));
}
public DataTable HienThiKhachHang(string dk)
{
return(con.GetDataTable(@"SELECT *FROM NHACUNGCAP " + dk));
}
public DataTable HienThiSanPham(string dk)
{
return(con.GetDataTable(@"SELECT *FROM SANPHAM" + dk));
}