/// <summary>
/// 获取商品列表
/// </summary>
/// <param>修改备注</param>
/// 2014-5-20 林建生
public object getVRList(HttpContext context)
{
int pageSize = int.Parse(context.Request.Form["pageSize"]);
int pageIndex = int.Parse(context.Request.Form["pageIndex"]);
Guid member_gid = Guid.Parse(context.Request.Form["member_gid"]);
using (EFDB db = new EFDB())
{
var list = db.video_record.Where(l => l.member_gid == member_gid).GroupJoin(db.product,
x => x.product_gid,
y => y.gid,
(x, y) => new
{
x.product_gid,
x.number,
x.add_time,
y.FirstOrDefault().name
}).AsQueryable();
return(new AjaxResult(
new
{
list = list.OrderByDescending(l => l.add_time).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()
}));
}
}
/// <summary>
/// 获取视频列表
/// </summary>
/// <param>修改备注</param>
/// 2014-5-20 林建生
public object getVideoList(HttpContext context)
{
int pageSize = int.Parse(context.Request.Form["pageSize"]);
int pageIndex = int.Parse(context.Request.Form["pageIndex"]);
string searchKeyword = context.Request.Form["searchKeyword"];
using (EFDB db = new EFDB())
{
var list = db.product.Where(l => l.show != 2).GroupJoin(db.classify,
x => x.classify_gid,
y => y.gid,
(x, y) => new
{
x.gid,
x.name,
x.picture,
x.add_time,
y.FirstOrDefault().ltype
}).Where(l => l.ltype == 2).AsQueryable();
if (!string.IsNullOrEmpty(searchKeyword))
{
list = list.Where(l => l.name.Contains(searchKeyword));
}
return(new AjaxResult(new { url = Help.ApiUrl + Help.Product, list = list.OrderByDescending(l => l.add_time).Select(l => new { l.gid, l.name, l.picture }).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList() }));
}
}
