public DataTable GetTable()
{
/*
* DataTable dt = GetData("HoaDon");
* List<HoaDon> list = new List<HoaDon>();
* foreach (DataRow row in dt.Rows)
* {
* list.Add(new HoaDon(row["MaHD"].ToString(),row["MaKH"].ToString(),row["MaNV"].ToString(),Convert.ToDateTime(row["NgayLap"])));
* }
* return list;*/
return(_dbConnect.ExecuteQuery("select * from HoaDon"));
}
public DataTable GetTable(string whereMaHH = "", string whereTenHH = "")
{
string strSql = string.Format("select * from HangHoa where MaHH like '{0}%' and TenHH like N'%{1}%'", whereMaHH, whereTenHH);
return(_dbConnect.ExecuteQuery(strSql));
}
public DataTable GetTable()
{
return(_dbConnect.ExecuteQuery("select * from ChiTietHoaDon"));
}
public DataTable GetTable()
{
return(_dbConnect.ExecuteQuery("select * from KhachHang"));
}
public DataTable SalaryOfEmployee()
{
return(db.ExecuteQuery("select MaNV[Mã Nhân Viên], TenNV[Tên Nhân Viên], ChucDanh[Chức Danh], Luong[Lương] from NhanVien"));
}
public DataTable GetTable()
{
return(_dbConnect.ExecuteQuery("select * from NhanVien"));
}
