public Tuple<model.Product, List<model.ImageList>> Details(string id)
{
var sqlProduct = "select * from Product where Id='" + id + "'";
var sqlImgList = "select * from ImageList where ProductId='" + id + "'";
var product = new model.Product();
using (var sReader = SqlDBHelper.ExecuteReader(sqlProduct))
{
while (sReader.Read())
{
product.Id = sReader["Id"].ToString();
product.CategoryId = sReader["CategoryId"].ToString();
product.Name = sReader["Name"].ToString();
product.Description = sReader["Description"].ToString();
product.ImgSrc = sReader["ImgSrc"].ToString();
product.CreateTime = Convert.ToDateTime(sReader["CreateTime"]);
}
}
List<model.ImageList> list = new List<model.ImageList>();
using (var sReader = SqlDBHelper.ExecuteReader(sqlImgList))
{
while (sReader.Read())
{
var img = new model.ImageList
{
Id = sReader["Id"].ToString(),
ProductId = sReader["ProductId"].ToString(),
ImgSrc = sReader["ImgSrc"].ToString()
};
list.Add(img);
}
}
return Tuple.Create<model.Product, List<model.ImageList>>(product, list);
}
public List<model.ImageList> GetList(int page, int size, string productId, out int total)
{
var sql = "select * from ImageList where ProductId='" + productId + "'";
List<model.ImageList> list = new List<model.ImageList>();
using (var sReader = SqlDBHelper.ExecuteReader(sql))
{
while (sReader.Read())
{
var product = new model.ImageList
{
Id = sReader["Id"].ToString(),
ImgSrc = sReader["ImgSrc"].ToSafeTrim(),
ProductId = sReader["ProductId"].ToSafeTrim()
};
list.Add(product);
}
}
total = list.Count;
return list.Skip(size * (page - 1)).Take(size).ToList();
}