private void BindImageNews() { string key = "Home_Room_UserControls_Index_banner_ImagePlay"; DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key); if (cacheAsDataTable == null) { cacheAsDataTable = new Tables.T_FocusImageNews().Open("", "", "ID Desc"); if (cacheAsDataTable == null) { PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName); return; } Shove._Web.Cache.SetCache(key, cacheAsDataTable, 0xe10); } DataRow[] rowArray = cacheAsDataTable.Select("IsBig=0", "ID desc"); if (rowArray.Length > 0) { this.tbImageNews.Visible = true; this.ImageHref1.HRef = rowArray[0]["Url"].ToString(); this.Image1.Src = "Private/" + base._Site.ID.ToString() + "/NewsImages/" + rowArray[0]["ImageUrl"].ToString(); this.tdTitle1.InnerHtml = _String.Cut(rowArray[0]["Title"].ToString(), 8); this.Image1.Alt = this.tdTitle1.InnerHtml; if (rowArray.Length > 1) { this.tdTitle2.Visible = true; this.tdImage2.Visible = true; this.ImageHref2.HRef = rowArray[1]["Url"].ToString(); this.Image2.Src = "Private/" + base._Site.ID.ToString() + "/NewsImages/" + rowArray[1]["ImageUrl"].ToString(); this.tdTitle2.InnerHtml = _String.Cut(rowArray[1]["Title"].ToString(), 8); this.Image2.Alt = this.tdTitle2.InnerHtml; } } }
private void BindData() { DataTable dt = new Tables.T_FocusImageNews().Open("", "", "ID desc"); if (dt == null) { PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName); } else { PF.DataGridBindData(this.g, dt, this.gPager); } }
protected void Page_Load(object sender, EventArgs e) { string key = "Home_Room_UserControls_Index_banner_ImagePlay"; DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key); if (cacheAsDataTable == null) { cacheAsDataTable = new Tables.T_FocusImageNews().Open("", "", "ID Desc"); if (cacheAsDataTable == null) { PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName); return; } Shove._Web.Cache.SetCache(key, cacheAsDataTable, 0xe10); } DataRow[] rowArray = cacheAsDataTable.Select("IsBig=1", "ID desc"); for (int i = 0; (i < rowArray.Length) && (i < 6); i++) { string imagsBanner = this.imagsBanner; this.imagsBanner = imagsBanner + "Private/" + base._Site.ID.ToString() + "/NewsImages/" + rowArray[i]["ImageUrl"].ToString() + ","; this.textBanner = this.textBanner + rowArray[i]["Title"].ToString() + ","; this.linksBanner = this.linksBanner + rowArray[i]["Url"].ToString() + ","; } }