public string GetDownloadList(webReq req) { ResultForWeb r = new ResultForWeb { HttpCode = 200, Message = "", data = "{}" }; string search = req.search == null ? "" : req.search; //搜索内容 int index = Convert.ToInt32(req.index); //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 var isRepeat = Convert.ToInt32(req.isRepeat); var condition = " "; if (isRepeat != 2) { condition += " isRepeat=" + isRepeat + " and "; } condition += " 1=1 and name like '%" + search + "%' "; string str = "select * from couponView where " + condition + " order by createTime desc"; var listAll = SqlHelperHere.ExecuteGetList <CouponView>(str); if (listAll.Count < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } //分页 var list2 = listAll.Skip((index - 1) * size).Take(size).ToArray(); if (list2.Length < 1) { r.data = JsonHelperHere.EmptyJson(); return(JsonConvert.SerializeObject(r)); } var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <DownList>(); foreach (var item in list2) { DownList d = new DownList(item); listR.Add(d); } r.data = JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index); return(JsonConvert.SerializeObject(r)); }
public string GetDownloadList(webReq req) { string search = Request["search"] == null ? "" : Request["search"]; //搜索内容 int index = Convert.ToInt32(Request["index"]); //页码 int pages = 0; //总页数 int size = 12; //一页size条数据 var isRepeat = Convert.ToInt32(req.isRepeat); var condition = " "; if (isRepeat != 2) { condition += " isRepeat=" + isRepeat + " and "; } condition += " 1=1 and name like '%" + search + "%' "; string str = "select * from couponView where " + condition + " order by createTime desc"; var listAll = SqlHelperHere.ExecuteGetList <CouponView>(str); if (listAll.Count < 1) { return(JsonHelperHere.EmptyJson()); } //分页 var list2 = listAll.Skip((index - 1) * size).Take(size).ToArray(); if (list2.Length < 1) { return(JsonHelperHere.EmptyJson()); } //var idsStr = string.Join(",", ids); //查具体信息 //var viewList = CacheHelper.GetByCondition<CouponView>("CouponView", " name in (" + idsStr + ")"); var count = listAll.Count; pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; var listR = new List <DownList>(); foreach (var item in list2) { DownList d = new DownList(item); listR.Add(d); } return(JsonHelperHere.JsonAddPage(pages, JsonConvert.SerializeObject(listR), index)); }