private void BindData() { if (tv.Nodes.Count < 1) { return; } string TypeID = tv.SelectedValue; if (TypeID == "") { TypeID = tv.Nodes[0].Value; } DataTable dt = new DAL.Tables.T_News().Open("", "SiteID = " + _Site.ID.ToString() + " and TypeID = " + Shove._Web.Utility.FilteSqlInfusion(TypeID), "[DateTime] desc"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName); return; } PF.DataGridBindData(g, dt, gPager); }
private void BindData() { DataTable dt = new DAL.Tables.T_News().Open("", "SiteID = " + _Site.ID.ToString() + " and TypeID = '" + ddlType.SelectedValue + "'", "[DateTime] desc"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName); return; } PF.DataGridBindData(g, dt, gPager); }
private void BindNews() { DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("DataCache_Challenge_72_News"); if (dt == null) { dt = new DAL.Tables.T_News().Open("top 5 [ID],[Title],[Content]", "TypeID = 9", "DateTime desc"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试(129)", this.GetType().BaseType.FullName); return; } if (dt.Rows.Count > 1) { Shove._Web.Cache.SetCache("DataCache_Challenge_72_News", dt, 1200); } } if (dt == null) { return; } if (dt.Rows.Count < 1) { return; } Regex regex = new Regex(@"^http://([\w-]+\.)+[\w-]+(/[\w-./?%&=]*)?$", RegexOptions.IgnoreCase | RegexOptions.Compiled); System.Text.StringBuilder sb = new System.Text.StringBuilder(); foreach (DataRow dr in dt.Rows) { sb.AppendLine("<li>"); Match m = regex.Match(dr["Content"].ToString()); if (m.Success) { sb.Append("<a href=\"" + dr["Content"].ToString() + "\" target=\"_blank\">" + Shove._String.Cut(dr["Title"].ToString(), 16) + "</a>"); } else { sb.Append("<a href=\"../Home/Web/ShowNews.aspx?Id=" + dr["ID"].ToString() + "\" target=\"_blank\">" + Shove._String.Cut(dr["Title"].ToString(), 16) + "</a>"); } sb.AppendLine("</li>"); } newsHTML = sb.ToString(); }
/// <summary> /// 获取彩票新闻 /// </summary> /// <returns></returns> private DataTable GetRepHome(string strTypeName) { string sql = @"select Title,Content,DateTime,ReadCount,TypeName from V_News where ID=" + id; if (strTypeName != null && strTypeName != "") { sql = @"select Title,Content,DateTime,ReadCount,TypeName from V_News where ID=" + id + " and TypeName='" + strTypeName + "'"; } DataTable dt = Shove.Database.MSSQL.Select(sql); DAL.Tables.T_News news = new DAL.Tables.T_News(); news.ReadCount.Value = Convert.ToInt32(dt.Rows[0]["ReadCount"].ToString()) + 1; news.Update("ID=" + id); return(dt); }
private void BindData() { long NewsID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("id"), -1); if (NewsID < 0) { PF.GoError(ErrorNumber.Unknow, "参数错误", this.GetType().BaseType.FullName); return; } tbID.Text = NewsID.ToString(); ddlImage.Items.Clear(); ddlImage.Items.Add("--选择图片--"); string UploadPath = this.Server.MapPath("../../Private/" + _Site.ID.ToString() + "/NewsImages"); if (!System.IO.Directory.Exists(UploadPath)) { System.IO.Directory.CreateDirectory(UploadPath); } else { string[] FileList = Shove._IO.File.GetFileList(UploadPath); if (FileList != null) { for (int i = 0; i < FileList.Length; i++) { ddlImage.Items.Add(FileList[i]); } } } DataTable dt = new DAL.Tables.T_News().Open("", "SiteID = " + _Site.ID.ToString() + " and [ID] = " + NewsID.ToString(), ""); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName); return; } if (dt.Rows.Count > 0) { tbDateTime.Text = dt.Rows[0]["DateTime"].ToString(); tbReadCount.Text = dt.Rows[0]["ReadCount"].ToString(); cbisShow.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isShow"].ToString(), true); cbisCanComments.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isCanComments"].ToString(), true); cbisCommend.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isCommend"].ToString(), false); cbisHot.Checked = Shove._Convert.StrToBool(dt.Rows[0]["isHot"].ToString(), false); tbTitle.Text = dt.Rows[0]["Title"].ToString(); if (tbTitle.Text.IndexOf("<font cstyle=\"color:red\">") > -1) { ddlTitleColor.Items[1].Selected = true; ddlTitleColor.Items[2].Selected = false; ddlTitleColor.Items[0].Selected = false; tbTitle.Text = tbTitle.Text.Replace("<font cstyle=\"color:red\">", "").Replace("</font>", ""); } else if (tbTitle.Text.IndexOf("<font style=\"color:black\">") > -1) { ddlTitleColor.Items[2].Selected = true; ddlTitleColor.Items[1].Selected = false; ddlTitleColor.Items[0].Selected = false; tbTitle.Text = tbTitle.Text.Replace("<font style=\"color:black\">", "").Replace("</font>", ""); } else { ddlTitleColor.Items[0].Selected = true; ddlTitleColor.Items[2].Selected = false; ddlTitleColor.Items[1].Selected = false; } tbContent.Value = dt.Rows[0]["Content"].ToString(); Regex regex = new Regex(@"^http://([\w-]+\.)+[\w-]+(/[\w-./?%&=]*)?$", RegexOptions.IgnoreCase | RegexOptions.Compiled); Match m = regex.Match(dt.Rows[0]["Content"].ToString()); if (m.Success) { trUrl.Visible = true; trContent.Visible = false; rblType.SelectedIndex = 0; tbUrl.Text = dt.Rows[0]["Content"].ToString(); } else { trContent.Visible = true; trUrl.Visible = false; rblType.SelectedIndex = 1; tbContent.Value = dt.Rows[0]["Content"].ToString(); } Shove.ControlExt.SetDownListBoxText(ddlImage, dt.Rows[0]["ImageUrl"].ToString()); tbOldImage.Text = dt.Rows[0]["ImageUrl"].ToString().Trim(); if (dt.Rows[0]["ImageUrl"].ToString().Trim() == "") { cbNoEditImage.Checked = false; cbNoEditImage.Visible = false; } hidTypeID.Value = dt.Rows[0]["TypeID"].ToString(); } }