protected override void AttachChildControls()
{
this.rptMemberGroups = (WapTemplatedRepeater)this.FindControl("rptMemberGroups");
List <int> list = new List <int>();
list.Add(1);
list.Add(4);
FightGroupQuery fightGroupQuery = new FightGroupQuery();
fightGroupQuery.PageIndex = 1;
fightGroupQuery.PageSize = 2147483647;
fightGroupQuery.SortBy = "StartTime";
fightGroupQuery.SortOrder = SortAction.Asc;
fightGroupQuery.UserId = HiContext.Current.UserId;
fightGroupQuery.OrderStatus = list;
this.rptMemberGroups.ItemDataBound += this.rptMemberGroups_ItemDataBound;
PageModel <UserFightGroupActivitiyModel> myFightGroups = VShopHelper.GetMyFightGroups(fightGroupQuery);
List <UserFightGroupActivitiyModel> list2 = myFightGroups.Models.ToList();
foreach (UserFightGroupActivitiyModel item in list2)
{
if (item.EndTime <= DateTime.Now && item.GroupStatus == FightGroupStatus.FightGroupIn)
{
VShopHelper.DealFightGroupFail(item.FightGroupId);
item.GroupStatus = FightGroupStatus.FightGroupFail;
}
if (string.IsNullOrEmpty(item.ImageUrl1))
{
item.ImageUrl1 = base.site.DefaultProductImage;
}
}
this.rptMemberGroups.DataSource = myFightGroups.Models;
this.rptMemberGroups.DataBind();
if (myFightGroups.Total == 0)
{
this.Page.Response.Redirect("MemberGroupsNever.aspx");
}
}
public PageModel <UserFightGroupActivitiyModel> GetMyFightGroups(FightGroupQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat(" 1=1 ");
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" And UserId = {0} ", query.UserId.Value);
}
if (query.Status.HasValue)
{
stringBuilder.AppendFormat(" And Status = {0} ", query.Status);
}
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append(" (SELECT min (fgs.SalePrice)\r\n FROM Hishop_FightGroupSkus fgs\r\n WHERE fgs.FightGroupActivityId = v.FightGroupActivityId)\r\n SalePrice, ");
if (query.OrderStatus != null)
{
stringBuilder2.AppendFormat(" (SELECT count (1)\r\n FROM Hishop_Orders ord\r\n WHERE ord.FightGroupId = v.FightGroupId\r\n AND ord.UserId = {0}\r\n AND ord.OrderStatus NOT IN ({1})) SuccessFightGroupNumber, ", query.UserId, string.Join(",", query.OrderStatus));
stringBuilder.AppendFormat(" AND OrderStatus not in ( {0} )", string.Join(",", query.OrderStatus));
}
stringBuilder2.Append("v.*");
return(DataHelper.PagingByRownumber <UserFightGroupActivitiyModel>(query.PageIndex, query.PageSize, "FightGroupId", SortAction.Desc, true, "vw_Hishop_FightGroups v", "FightGroupId", stringBuilder.ToString(), stringBuilder2.ToString()));
}
