protected void DataInfoBind() { ShowPager.PageSize = PageSize; int total = 0; Model.TljInfoCondition con = condition(); var list = bllTljInfo.GetList(ShowPager.CurrentPageIndex, ShowPager.PageSize, ref total, con, p => p.ID, false) .Select(i => new { ID = i.ID, goodsname = i.goodsname, item_id = i.item_id, item_pic = i.item_pic, name = i.name, total_num = i.total_num, per_face = i.per_face, user_total_win_num_limit = i.user_total_win_num_limit, commission_bili = i.commission_bili, goodstype = i.goodstype, quanPrice = i.quanPrice, send_start_time = i.send_start_time, send_end_time = i.send_end_time, use_end_time = i.use_end_time, ifok = i.ifok, kouling = i.kouling, ifget = i.ifget, gettime = i.gettime, win_amount = i.win_amount, win_num = i.win_num, alipay_amount = i.alipay_amount, pre_commission_amount = i.pre_commission_amount, use_amount = i.use_amount, use_num = i.use_num, refund_amount = i.refund_amount, refund_num = i.refund_num, unfreeze_num = i.unfreeze_num, unfreeze_amount = i.unfreeze_amount, remark = i.remark, zctime = i.zctime, campaigntype = i.campaigntype, PayMoney = i.PayMoney, createtime = i.createtime, dotime = i.dotime, appkeyid = i.AppKeyID, quan_link = i.quan_link, ActiveCode = i.ActiveCode, yjyl = Math.Round((((i.PayMoney.HasValue ? i.PayMoney.Value : 0.00m) * (i.commission_bili.HasValue ? i.commission_bili.Value : 0.00m) / 100) * 0.88m - (i.per_face.HasValue ? i.per_face.Value : 0.00m)), 2, MidpointRounding.AwayFromZero), AppName = new TljEntities().appkeys.FirstOrDefault(a => a.ID == i.AppKeyID) != null ? new TljEntities().appkeys.FirstOrDefault(a => a.ID == i.AppKeyID).AppName : "", TbAccount = new TljEntities().appkeys.FirstOrDefault(a => a.ID == i.AppKeyID) != null ? new TljEntities().appkeys.FirstOrDefault(a => a.ID == i.AppKeyID).TbAccount : "", }); ShowPager.RecordCount = total; this.rpData.DataSource = list; this.rpData.DataBind(); }
protected void DataInfoBind() { int total = 0; TljInfoCondition cond = condition(); var list = bllTljInfo.GetList(1, int.MaxValue, ref total, cond, t => t.ID) .GroupBy(m => new { m.ActiveCode, m.item_id, m.goodsname, m.item_pic }).OrderByDescending(m => m.Key.ActiveCode).Select(m => new ModelActCode { ActiveCode = m.Key.ActiveCode, goodsname = m.Key.goodsname, item_id = m.Key.item_id, item_pic = m.Key.item_pic, count = m.Count() }).ToList(); foreach (var item in list) { item.Link = string.Format("{0}/mdtishi.aspx?qid={待补充群号}&hdcode={1}", strQunmanageUrl, item.ActiveCode); item.qunLink = string.Format("{0}/adm/GroupActList.aspx?json={1}", strQunmanageUrl, Server.UrlEncode(Newtonsoft.Json.JsonConvert.SerializeObject(item))); } total = list.Count(); var listRes = list.Skip((ShowPager.CurrentPageIndex - 1) * ShowPager.PageSize).Take(ShowPager.PageSize).ToList(); ShowPager.RecordCount = total; this.rpData.DataSource = listRes; this.rpData.DataBind(); }
private ApiResult GetActiveCodeList(HttpContext con) { BLL.TljInfo bllTljInfo = new BLL.TljInfo(); ApiResult res = new ApiResult(); DateTime dtNow = DateTime.Now; DateTime dtToday = DateTime.Parse(dtNow.ToShortDateString()); try { int total = 0; Model.TljInfoCondition cond = new Model.TljInfoCondition { ifget = false, Ifok = "已生成", statStartTime = dtToday }; var list = bllTljInfo.GetList(1, int.MaxValue, ref total, cond, t => t.ID) .GroupBy(m => new { m.ActiveCode, m.item_id, m.goodsname, m.item_pic }).Select(m => new { ActiveCode = m.Key.ActiveCode, goodsname = m.Key.goodsname, item_id = m.Key.item_id, item_pic = m.Key.item_pic, count = m.Count() }).ToList(); res.message = JsonConvert.SerializeObject(list); res.success = true; } catch (Exception e) { res.success = false; res.message = "操作失败," + e.Message; } return(res); }