protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { string idx = Request["Idx"]; if (!String.IsNullOrEmpty(idx)) { DBEntity.Tab_Activity ent = new DBEntity.Tab_Activity(); ent = ent.Get(idx); this.ActiveTitle.Text = ent.ActiveTitle; this.Rules.Text = ent.Rules; this.Platform.Text = ent.Platform; this.Prizes.Text = ent.Prizes; this.Image1.ImageUrl = string.Format("~/upload/Activity/{0}", ent.PreviewImg); this.Image2.ImageUrl = string.Format("~/upload/Activity/{0}", ent.DisplayHomePreview); this.ActivityStartDate.Text = ent.ActivityStartDate.ToString(); this.ActivityEndDate.Text = ent.ActivityEndDate.ToString(); for (int i = 0; i < this.DisplayHomeBool.Items.Count; i++) { if (this.DisplayHomeBool.Items[i].Value == ent.DisplayHomeBool) { this.DisplayHomeBool.Items[i].Selected = true; } } this.HiddenField1.Value = ent.PreviewImg; this.HiddenField2.Value = ent.DisplayHomePreview; } } }
private void GetltlHomeActivty() { StringBuilder sb = new StringBuilder(); string strSql = string.Format("select top 1 * from Tab_Activity where DATEDIFF(DAY,getdate(),ActivityEndDate) >0 order by 1 desc "); DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSql); if (ds.Tables[0].Rows.Count == 1) { var iRow = ds.Tables[0].Rows[0]; DBEntity.Tab_Activity ent = new DBEntity.Tab_Activity(); ent = ent.Get(iRow["Idx"].ToString()); string str = string.Format(@"<div class='promo_intro'> <div class='promo_intro_l'><a href='activity_detail.aspx?Idx={6}' title='点击查看详细'><img src='upload/Activity/{0}' width='177' height='142' alt='' /></a></div> <div class='promo_intro_r'> <dl> <dt><span>{1}</span><br /> 时间:{2} - {3}<br /> 简介:{4}<br /> <span style='color:#c8b772; font-size:12px;'>奖品:{5}</span></dt> <dd style='text-align:right'><a href='activity-mine.aspx'>More..<!--<img src='images/btn_lookmore.jpg' alt='查看更多' />--></a></dd> <!-- <dd class='share2'><a href='#'><img src='images/icon_weibo2.jpg' alt='新浪微博' /></a> <a href='#'><img src='images/icon_kaixin2.jpg' alt='开心网' /></a> <a href='#'><img src='images/icon_renren2.jpg' alt='人人网' /></a> </dd> --> </dl> </div> <br class='clr' /> </div>", iRow["PreviewImg"] , iRow["ActiveTitle"] , Cmn.Date.ToMonthDayStr(DateTime.Parse(iRow["ActivityStartDate"].ToString())) , Cmn.Date.ToMonthDayStr(DateTime.Parse(iRow["ActivityEndDate"].ToString())) , Cmn.Str.GetStr(iRow["Rules"].ToString(), 108, true) , Cmn.Str.GetStr(iRow["Prizes"].ToString(), 32, false) , iRow["Idx"]); sb.AppendLine(str.ToString()); } ds.Clear(); ltlHomeActivty.Text = sb.ToString(); }