protected override void Render(HtmlTextWriter writer) { if (this.Activity != null) { PrizeQuery page = new PrizeQuery { ActivityId = this.Activity.ActivityId, SortOrder = SortAction.Desc, SortBy = "PrizeTime" }; IOrderedEnumerable <PrizeRecordInfo> source = from a in VshopBrowser.GetPrizeList(page) orderby a.PrizeTime descending select a; StringBuilder builder = new StringBuilder(); if ((source != null) && (source.Count <PrizeRecordInfo>() > 0)) { foreach (PrizeRecordInfo info in source) { if (!string.IsNullOrEmpty(info.CellPhone) && !string.IsNullOrEmpty(info.RealName)) { builder.AppendFormat("<p>{0} {1} {2}</p>", info.Prizelevel, this.ShowCellPhone(info.CellPhone), info.RealName); } } writer.Write(builder.ToString()); } else { builder.AppendFormat("<p>暂无获奖名单!</p>", new object[0]); } } }
public PageModel <ViewUserAwardRecordsInfo> GetAllAwardRecordsByActityId(PrizeQuery page) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendFormat("1=1"); if (page.Status > 0) { stringBuilder.AppendFormat(" and Status ={0}", page.Status); } if (page.ActivityId > 0) { stringBuilder.AppendFormat(" and ActivityId ={0}", page.ActivityId); } if (page.ActivityType != 0) { stringBuilder.AppendFormat(" and ActivityType={0}", (int)page.ActivityType); } if (!string.IsNullOrEmpty(page.UserName)) { stringBuilder.AppendFormat(" and UserName='******'", page.UserName); } if (page.AwardGrade > 0) { stringBuilder.AppendFormat(" and AwardGrade ={0}", page.AwardGrade); } if (page.IsDel) { stringBuilder.AppendFormat(" and IsDel=0"); } return(DataHelper.PagingByRownumber <ViewUserAwardRecordsInfo>(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "vw_Hishop_UserAwardRecords", "ID", stringBuilder.ToString(), "*")); }
public void GetList(HttpContext context) { int num = 1; int num2 = 10; num = base.GetIntParam(context, "page", false).Value; if (num < 1) { num = 1; } num2 = base.GetIntParam(context, "rows", false).Value; if (num2 < 1) { num2 = 10; } PrizeQuery prizeQuery = new PrizeQuery(); prizeQuery.UserName = context.Request["UserName"]; prizeQuery.ActivityId = base.GetIntParam(context, "ActivityId", false).Value; prizeQuery.Status = base.GetIntParam(context, "Status", false).Value; prizeQuery.AwardGrade = base.GetIntParam(context, "AwardGrade", false).Value; prizeQuery.PageIndex = num; prizeQuery.PageSize = num2; prizeQuery.SortBy = "CreateDate"; prizeQuery.SortOrder = SortAction.Desc; DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(prizeQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
protected override void Render(HtmlTextWriter writer) { StringBuilder stringBuilder = new StringBuilder(); if (this.Activity != null) { PrizeQuery prizeQuery = new PrizeQuery(); prizeQuery.ActivityId = this.Activity.ActivityId; prizeQuery.SortOrder = SortAction.Desc; prizeQuery.SortBy = "PrizeTime"; IOrderedEnumerable <PrizeRecordInfo> orderedEnumerable = from a in VshopBrowser.GetPrizeList(prizeQuery) orderby a.PrizeTime descending select a; if (orderedEnumerable != null && orderedEnumerable.Count() > 0) { foreach (PrizeRecordInfo item in orderedEnumerable) { if (!string.IsNullOrEmpty(item.CellPhone) && !string.IsNullOrEmpty(item.RealName)) { stringBuilder.AppendFormat("<p>{0} {1} {2}</p>", item.Prizelevel, this.ShowCellPhone(item.CellPhone), item.RealName); } } } else { stringBuilder.AppendFormat("<p>暂无获奖名单!</p>"); } } else if (this.ActivityId > 0) { PrizeQuery prizeQuery2 = new PrizeQuery(); prizeQuery2.ActivityId = this.ActivityId; prizeQuery2.PageIndex = 1; prizeQuery2.PageSize = 20; prizeQuery2.SortBy = "CreateDate"; prizeQuery2.SortOrder = SortAction.Desc; prizeQuery2.IsDel = true; IEnumerable <ViewUserAwardRecordsInfo> models = ActivityHelper.GetAllAwardRecordsByActityId(prizeQuery2).Models; if (models != null && models.Count() > 0) { foreach (ViewUserAwardRecordsInfo item2 in models) { if (!string.IsNullOrEmpty(item2.UserName)) { stringBuilder.AppendFormat("<p>{0} {1}</p>", this.ShowUserName(item2.UserName), this.CapitalLetters(item2.AwardGrade) + "等奖"); } } } else { stringBuilder.AppendFormat("<p>暂无获奖名单!</p>"); } } writer.Write(stringBuilder.ToString()); }
protected void BindPrizeList() { PrizeQuery page = new PrizeQuery { ActivityId = this.activeid }; List <PrizeRecordInfo> prizeList = VShopHelper.GetPrizeList(page); if ((prizeList != null) && (prizeList.Count > 0)) { this.LitTitle.Text = prizeList[0].ActivityName; } this.rpMaterial.DataSource = prizeList; this.rpMaterial.DataBind(); }
protected void BindPrizeList() { PrizeQuery prizeQuery = new PrizeQuery(); prizeQuery.ActivityId = this.activeid; List <PrizeRecordInfo> prizeList = VShopHelper.GetPrizeList(prizeQuery); if (prizeList != null && prizeList.Count > 0) { this.LitTitle.Text = prizeList[0].ActivityName; } this.nodata = (prizeList.Count == 0); this.rpMaterial.DataSource = prizeList; this.rpMaterial.DataBind(); }
public List <PrizeRecordInfo> GetPrizeListEx(PrizeQuery page) { StringBuilder builder = new StringBuilder(); builder.Append("select * from Vshop_PrizeRecord "); if (page.ActivityId != 0) { builder.AppendFormat(" where ActivityId={0}", page.ActivityId); } DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString()); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { return(ReaderConvert.ReaderToList <PrizeRecordInfo>(reader) as List <PrizeRecordInfo>); } }
public List <PrizeRecordInfo> GetPrizeList(PrizeQuery page) { StringBuilder builder = new StringBuilder(); builder.Append("select ActivityName=(select ActivityName from Vshop_LotteryActivity a where a.ActivityId=b.ActivityId),"); builder.Append("UserName=(select UserName from aspnet_Members c where c.UserId=b.UserId),"); builder.Append(" b.* from Vshop_PrizeRecord b"); if (page.ActivityId != 0) { builder.AppendFormat(" where b.ActivityId={0}", page.ActivityId); } builder.AppendFormat(" and b.IsPrize=1 order by b.PrizeTime desc", new object[0]); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString()); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { return(ReaderConvert.ReaderToList <PrizeRecordInfo>(reader) as List <PrizeRecordInfo>); } }
protected override void Render(HtmlTextWriter writer) { if (this.Activity != null) { PrizeQuery page = new PrizeQuery { ActivityId = this.Activity.ActivityId, SortOrder = SortAction.Desc, SortBy = "PrizeTime" }; IOrderedEnumerable <PrizeRecordInfo> source = from a in VshopBrowser.GetPrizeList(page) orderby a.PrizeTime descending select a; StringBuilder builder = new StringBuilder(); if ((source != null) && (source.Count <PrizeRecordInfo>() > 0)) { builder.Append("<table class=\"tabstyle\" width=\"100%\" border=\"0\" cellspacing=\"\" cellpadding=\"\">"); //<td style=\"text-align:center; width:30%\">获取人</td> builder.Append("<tbody><tr><th>电话</th><th>奖项</th></tr>"); int i = 1; foreach (PrizeRecordInfo info in source) { if (i <= 5) { i++; if (!string.IsNullOrEmpty(info.CellPhone) && !string.IsNullOrEmpty(info.RealName)) { builder.Append("<tr>"); //builder.AppendFormat("<td style=\"text-align:center; width:30%\">{0}<td>", info.RealName); builder.AppendFormat("<td style=\"text-align:center; width:50%\">{0}</td>", this.ShowCellPhone(info.CellPhone)); builder.AppendFormat("<td style=\"text-align:center; width:50%\">{0}</td>", info.Prizelevel); builder.Append("</tr>"); } } } builder.Append("</tbody></table>"); writer.Write(builder.ToString()); } else { builder.AppendFormat("<p>暂无获奖名单!</p>", new object[0]); } } }
private DataGridViewModel <Dictionary <string, object> > GetDataList(PrizeQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { PageModel <ViewUserAwardRecordsInfo> allAwardRecordsByActityId = ActivityHelper.GetAllAwardRecordsByActityId(query); dataGridViewModel.rows = new List <Dictionary <string, object> >(); dataGridViewModel.total = allAwardRecordsByActityId.Total; foreach (ViewUserAwardRecordsInfo model in allAwardRecordsByActityId.Models) { Dictionary <string, object> dictionary = model.ToDictionary(); dictionary.Add("AwardGradeText", this.GetWeekCN(model.AwardGrade)); dictionary.Add("StatusText", (model.Status == 2) ? "已领奖" : "未领奖"); dataGridViewModel.rows.Add(dictionary); } } return(dataGridViewModel); }
public List <PrizeRecordInfo> GetPrizeList(PrizeQuery page) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select ActivityName=(select ActivityName from Vshop_LotteryActivity a where a.ActivityId=b.ActivityId),"); stringBuilder.Append("UserName=(select UserName from aspnet_Members c where c.UserId=b.UserId),"); stringBuilder.Append(" b.* from Vshop_PrizeRecord b"); if (page.ActivityId != 0) { stringBuilder.AppendFormat(" where b.ActivityId={0}", page.ActivityId); } stringBuilder.AppendFormat(" and b.IsPrize=1 order by b.PrizeTime desc"); DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString()); List <PrizeRecordInfo> result = null; using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand)) { result = (DataHelper.ReaderToList <PrizeRecordInfo>(objReader) as List <PrizeRecordInfo>); } return(result); }
public static List <PrizeRecordInfo> GetPrizeList(PrizeQuery page) { return(new LotteryActivityDao().GetPrizeList(page)); }
public static List <PrizeRecordInfo> GetPrizeList(PrizeQuery page) { return(new PrizeRecordDao().GetPrizeList(page)); }
protected override void AttachChildControls() { if (!int.TryParse(this.Page.Request.QueryString["activityid"], out this.activityid)) { base.GotoResourceNotFound(""); } //this.bgimg = (HtmlImage) this.FindControl("bgimg"); this.litActivityDesc = (Literal)this.FindControl("litActivityDesc"); //this.litStartDate = (Literal) this.FindControl("litStartDate"); //this.litEndDate = (Literal) this.FindControl("litEndDate"); this.litPrizeNames = (Common_PrizeNames)this.FindControl("litPrizeNames"); this.litPrizeUsers = (Common_PrizeUsers)this.FindControl("litPrizeUsers"); this.litSurplusNum = (Literal)this.FindControl("litSurplusNum"); this.litNum = (Literal)this.FindControl("litNum"); this.litimage = (Literal)this.FindControl("litimage"); LotteryActivityInfo lotteryActivity = VshopBrowser.GetLotteryActivity(this.activityid); if (lotteryActivity == null) { base.GotoResourceNotFound(""); } if (MemberProcessor.GetCurrentMember() == null) { MemberInfo member = new MemberInfo(); string generateId = Globals.GetGenerateId(); member.GradeId = MemberProcessor.GetDefaultMemberGrade(); member.UserName = ""; member.OpenId = ""; member.CreateDate = DateTime.Now; member.SessionId = generateId; member.SessionEndTime = DateTime.Now; MemberProcessor.CreateMember(member); member = MemberProcessor.GetMember(generateId); HttpCookie cookie = new HttpCookie("Vshop-Member") { Value = member.UserId.ToString(), Expires = DateTime.Now.AddYears(10) }; HttpContext.Current.Response.Cookies.Add(cookie); } PageTitle.AddSiteNameTitle(lotteryActivity.ActivityName); litimage.Text = Globals.HostPath(HttpContext.Current.Request.Url) + lotteryActivity.ActivityPic; //this.litStartDate.Text = lotteryActivity.StartTime.ToString("yyyy年MM月dd日 HH:mm:ss"); //this.litEndDate.Text = lotteryActivity.EndTime.ToString("yyyy年MM月dd日 HH:mm:ss"); //if (lotteryActivity.PrizeSettingList.Count > 3) //{ // this.bgimg.Src = Globals.GetVshopSkinPath(null) + "/images/process/panpic2.png"; //} if ((lotteryActivity.StartTime < DateTime.Now) && (DateTime.Now < lotteryActivity.EndTime)) { this.litActivityDesc.Text = lotteryActivity.ActivityDesc; this.litPrizeNames.Activity = lotteryActivity; this.litPrizeUsers.Activity = lotteryActivity; int userPrizeCount = VshopBrowser.GetUserPrizeCount(this.activityid); this.litActivityDesc.Text = this.litActivityDesc.Text; //剩余次数提示 this.litSurplusNum.Text = string.Format("您一共有{0}次参与机会,目前还剩<b class=\"sign\">{1}</b>次。", lotteryActivity.MaxNum, lotteryActivity.MaxNum - userPrizeCount); PrizeQuery page = new PrizeQuery { ActivityId = this.activityid }; System.Collections.Generic.List <PrizeRecordInfo> prizeList = VShopHelper.GetPrizeListEx(page); if (prizeList != null && prizeList.Count > 0) { this.litNum.Text = prizeList.Count.ToString(); } else { this.litNum.Text = "0"; } //前台JS刷的营销数据 if (!string.IsNullOrEmpty(lotteryActivity.GradeIds)) { this.litNum.Text = lotteryActivity.GradeIds; } } else { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "myscript", "<script>$(function(){alert_h(\"活动还未开始或者已经结束!\");});</script>"); } }
public static PageModel <ViewUserAwardRecordsInfo> GetAllAwardRecordsByActityId(PrizeQuery query) { return(new ActivityDao().GetAllAwardRecordsByActityId(query)); }