示例#1
0
    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();
    }