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);
}
