public IQueryable <Brand> SelectListBrand()
{
Table <Brand> brands = data.GetTable <Brand>();
return(from br in brands
where br.IsDeleted == 0
select br);
}
public Hashtable SelectListCategory()
{
Hashtable hash = new Hashtable();
Table <Category> categorys = data.GetTable <Category>();
var catParent = from cat in categorys
join cat1 in categorys on cat.ID equals cat1.CategoryParent into ff
from left in ff.DefaultIfEmpty()
where cat.CategoryParent == null
select new
{
cat.ID,
cat.CategoryName,
s = left.CategoryName == null ? "" : left.CategoryName,
g = (int)left.ID == 0 ? "" : left.ID.ToString()
};
foreach (var cat in catParent)
{
if ("".Equals(cat.s))
{
hash.Add((int)cat.ID, new Category(cat.ID, cat.CategoryName));
}
else
{
bool check = false;
IEnumerator key = hash.Keys.GetEnumerator();
Category cate = new Category(Convert.ToInt32(cat.ID), cat.CategoryName);
while (key.MoveNext())
{
if (cate.Equals(((Category)key.Current)))
{
check = true;
cate = (Category)key.Current;
}
}
if (check)
{
((List <Category>)hash[cate]).Add(new Category(Convert.ToInt32(cat.g), cat.s));
}
else
{
List <Category> l = new List <Category>();
l.Add(new Category(Convert.ToInt32(cat.g), cat.s));
hash.Add(new Category(Convert.ToInt32(cat.ID), cat.CategoryName), l);
}
}
}
return(hash);
}
public IEnumerable <Product> SelectALLProduct(int iPage, ref int ss)
{
Table <Product> products = data.GetTable <Product>();
var pro = from p in products
select p;
int n = pro.Count();
int numPage = (n % Static.recPerPage == 0) ? (n / Static.recPerPage) : (n / Static.recPerPage + 1);
ss = numPage;
if (iPage > numPage || iPage <= 0)
{
return(null);
}
else
{
return(pro.Skip((iPage - 1) * Static.recPerPage).Take(Static.recPerPage).AsEnumerable <Product>());
}
}
