private void BindData()
{
long id = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("id"), -1);
if (id < 0)
{
PF.GoError(ErrorNumber.Unknow, "您访问的数据不存在，可能是参数错误或内容已经被删除！", this.GetType().BaseType.FullName);
return;
}
DataTable dt = dt = new DAL.Tables.T_SiteAffiches().Open("", "ID=" + id.ToString() + "", "");
if (dt == null)
{
PF.GoError(ErrorNumber.Unknow, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
if (dt.Rows.Count < 0)
{
PF.GoError(ErrorNumber.Unknow, "您访问的数据不存在，可能是参数错误或内容已经被删除！", this.GetType().BaseType.FullName);
return;
}
DataRow dr = dt.Rows[0];
lbTitle.Text = dr["Title"].ToString().Replace("<p>", "").Replace("</p>", "");
lbDateTime.Text = dr["DateTime"].ToString();
lbContent.Text = dr["Content"].ToString().Replace("<p>", "").Replace("</p>", "");
}
/// <summary>
/// 绑定站点公告
/// </summary>
private void GetSiteAffiches()
{
string CacheKey = "SiteAffiches";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(CacheKey);
if (dt == null)
{
dt = new DAL.Tables.T_SiteAffiches().Open("top 10 *", "SiteID = " + _Site.ID.ToString(), "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
}
DataRow[] drs = dt.Select("isCommend=1", "DateTime DESC");
if (drs.Length > 0)
{
SiteAffiches = "<a href=\"NewDetail.aspx?SiteId=" + drs[0]["ID"].ToString() + "\" target=\"_blank\" style=\"font-size:16px;\" title=\"" + drs[0]["Title"].ToString() + "\">" + Shove._String.Cut(drs[0]["Title"].ToString(), 23) + "</a>";
}
Shove._Web.Cache.SetCache(CacheKey, dt, 600);
RepSiteAffiches.DataSource = dt;
RepSiteAffiches.DataBind();
}
private void BindData()
{
long SiteAfficheID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("id"), -1);
if (SiteAfficheID < 0)
{
PF.GoError(ErrorNumber.Unknow, "参数错误", "Admin_SiteAffichesEdit");
return;
}
tbID.Text = SiteAfficheID.ToString();
DataTable dt = new DAL.Tables.T_SiteAffiches().Open("", "SiteID = " + _Site.ID.ToString() + " and [ID] = " + SiteAfficheID.ToString(), "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_SiteAffichesEdit");
return;
}
tbDateTime.Text = dt.Rows[0]["DateTime"].ToString();
cbisShow.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isShow"].ToString(), true);
cbisCommend.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isCommend"].ToString(), true);
tbTitle.Text = dt.Rows[0]["Title"].ToString();
if (tbTitle.Text.IndexOf("<font class=red12>") > -1)
{
cbTitleRed.Checked = true;
tbTitle.Text = tbTitle.Text.Replace("<font class=red12>", "").Replace("</font>", "");
}
else
{
cbTitleRed.Checked = false;
}
string UC = dt.Rows[0]["Content"].ToString();
Regex regex = new Regex(@"^http://([\w-]+\.)+[\w-]+(/[\w-./?%&=]*)?$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
Match m = regex.Match(UC);
if (m.Success)
{
trContent.Visible = false;
trUrl.Visible = true;
tbUrl.Text = UC;
rblType.SelectedValue = "1";
}
else
{
trUrl.Visible = false;
trContent.Visible = true;
tbContent.Value = UC;
rblType.SelectedValue = "2";
}
}
private void BindData()
{
DataTable dt = new DAL.Tables.T_SiteAffiches().Open("", "SiteID = " + _Site.ID.ToString(), "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_SiteAffiches");
return;
}
PF.DataGridBindData(g, dt, gPager);
}
/// <summary>
/// 绑定站点公告
/// </summary>
private void GetSiteAffiches()
{
string CacheKey = "SiteAffichesIndex";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(CacheKey);
if (dt == null)
{
dt = new DAL.Tables.T_SiteAffiches().Open("top 3 *", "SiteID = " + _Site.ID.ToString(), "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
}
RepSiteAffiches.DataSource = dt;
RepSiteAffiches.DataBind();
Shove._Web.Cache.SetCache(CacheKey, dt, 600);
}
private void BindSiteAffiches()
{
StringBuilder sb = new StringBuilder();
string Key = "Default_GetSiteAffiches";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
if (dt == null)
{
dt = new DAL.Tables.T_SiteAffiches().Open("top 5 Title, ID, DateTime, Content", "isShow = 1", " DateTime desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
if (dt.Rows.Count > 0)
{
Shove._Web.Cache.SetCache(Key, dt, 1200);
}
}
foreach (DataRow dr in dt.Rows)
{
Regex regex = new Regex(@"^http://([\w-]+\.)+[\w-]+(/[\w-./?%&=]*)?$", RegexOptions.IgnoreCase | RegexOptions.Compiled);
Match m = regex.Match(dr["Content"].ToString());
if (m.Success)
{
sb.Append("<li><a href=\"" + dr["Content"].ToString() + "\" target=\"_blank\">");
}
else
{
sb.Append("<li><a href=\"Home/Web/ShowAffiches.aspx?ID=" + dr["ID"].ToString() + "\" target=\"_blank\">");
}
sb.Append(Shove._String.Cut(dr["Title"].ToString(), 22));
sb.AppendLine("</a></li>");
}
lbSiteAffiches = sb.ToString();
}
private void BindData()
{
long SiteAfficheID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("id"), -1);
if (SiteAfficheID < 0)
{
PF.GoError(ErrorNumber.Unknow, "参数错误", "Admin_SiteAffichesEdit");
return;
}
tbID.Text = SiteAfficheID.ToString();
DataTable dt = new DAL.Tables.T_SiteAffiches().Open("", "SiteID = " + _Site.ID.ToString() + " and [ID] = " + SiteAfficheID.ToString(), "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_SiteAffichesEdit");
return;
}
tbDateTime.Text = dt.Rows[0]["DateTime"].ToString();
cbisShow.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isShow"].ToString(), true);
cbisCommend.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isCommend"].ToString(), true);
tbTitle.Text = dt.Rows[0]["Title"].ToString();
if (tbTitle.Text.IndexOf("<font style=\"color:Red\">") > -1)
{
cbTitleRed.Checked = true;
tbTitle.Text = tbTitle.Text.Replace("<font style=\"color:Red\">", "").Replace("</font>", "");
}
else
{
cbTitleRed.Checked = false;
}
tbContent.Value = dt.Rows[0]["Content"].ToString();
}
