/// <summary>
/// 获取头条行业资讯
/// </summary>
/// <param name="TopicClass">资讯大类别 =null返回全部</param>
/// <param name="TopicArea">资讯小类别 =null返回全部</param>
/// <returns>行业资讯实体(ID,标题,内容)</returns>
public virtual EyouSoft.Model.CommunityStructure.InfoArticle GetHeadInfo(EyouSoft.Model.CommunityStructure.TopicClass?TopicClass, EyouSoft.Model.CommunityStructure.TopicAreas?TopicArea)
{
StringBuilder strSql = new StringBuilder(SQL_InfoArticle_GetHeadInfo);
if (TopicClass.HasValue)
{
strSql.AppendFormat(" AND TopicClassId={0} ", (int)TopicClass.Value);
}
if (TopicArea.HasValue)
{
strSql.AppendFormat(" AND AreaId={0} ", (int)TopicArea.Value);
}
strSql.Append("order by IssueTime desc");
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
EyouSoft.Model.CommunityStructure.InfoArticle model = null;
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model.ID = dr.GetString(0);
model.ArticleTitle = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
model.ArticleText = dr.IsDBNull(2) ? string.Empty : dr.GetString(2);
model.TitleColor = dr.IsDBNull(3) ? string.Empty : dr.GetString(3);
}
}
return(model);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">行业资讯文章实体</param>
/// <returns>true:成功 false:失败</returns>
public virtual bool Update(EyouSoft.Model.CommunityStructure.InfoArticle model)
{
StringBuilder strSql = new StringBuilder(SQL_InfoArticle_DELTAGS);
if (!string.IsNullOrEmpty(model.ArticleTag))
{
string[] Tags = model.ArticleTag.Split(',');
for (int i = 0; i < Tags.Length; i++)
{
if (!string.IsNullOrEmpty(Tags[i]))
{
strSql.AppendFormat(SQL_InfoArticle_ADDTAGS, model.ID, (int)model.AreaId, Tags[i].ToString());
}
}
}
DbCommand dc = this._database.GetSqlStringCommand(SQL_DELETEDFILE_UPDATEMOVE + SQL_InfoArticle_UPDATE + strSql.ToString());
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this._database.AddInParameter(dc, "ArticleTitle", DbType.String, model.ArticleTitle);
this._database.AddInParameter(dc, "ImgPath", DbType.String, model.ImgPath);
this._database.AddInParameter(dc, "ImgThumb", DbType.String, model.ImgThumb);
this._database.AddInParameter(dc, "ArticleText", DbType.String, model.ArticleText);
this._database.AddInParameter(dc, "ArticleTag", DbType.String, model.ArticleTag);
this._database.AddInParameter(dc, "Editor", DbType.String, model.Editor);
this._database.AddInParameter(dc, "Source", DbType.String, model.Source);
this._database.AddInParameter(dc, "TopicClassId", DbType.Byte, (int)model.TopicClassId);
this._database.AddInParameter(dc, "AreaId", DbType.Byte, (int)model.AreaId);
this._database.AddInParameter(dc, "IsImage", DbType.AnsiStringFixedLength, model.IsImage ? "1" : "0");
this._database.AddInParameter(dc, "IsTop", DbType.AnsiStringFixedLength, model.IsTop?"1":"0");
this._database.AddInParameter(dc, "IsFrontPage", DbType.AnsiStringFixedLength, model.IsFrontPage ? "1" : "0");
this._database.AddInParameter(dc, "OperatorId", DbType.Int32, model.OperatorId);
this._database.AddInParameter(dc, "TitleColor", DbType.String, model.TitleColor);
return(DbHelper.ExecuteSqlTrans(dc, this._database) > 0 ? true : false);
}
/// <summary>
/// 根据大类别集合获取指定条数的行业资讯列表
/// </summary>
/// <param name="topNumber">需要返回的总记录数</param>
/// <param name="TopicList">大类别集合 =null返回全部</param>
/// <param name="IsPicNew">是否图片资讯 =null返回全部</param>
/// <param name="IsFocusPic">是否焦点图片 =null返回全部</param>
/// <param name="IsTopPic">是否推荐图片 =null返回全部</param>
/// <returns>行业资讯列表</returns>
public virtual IList <EyouSoft.Model.CommunityStructure.InfoArticle> GetTopNumListByTopicList(int topNumber, List <EyouSoft.Model.CommunityStructure.TopicClass> TopicList,
bool?IsPicNew, bool?IsFocusPic, bool?IsTopPic)
{
IList <EyouSoft.Model.CommunityStructure.InfoArticle> list = new List <EyouSoft.Model.CommunityStructure.InfoArticle>();
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(SQL_InfoArticle_GetTopNumListByTopicList, topNumber > 0 ? string.Format(" top {0} ", topNumber) : "");
#region 生成查询条件
strSql.Append(" where 1=1 ");
if (TopicList != null && TopicList.Count > 0)
{
strSql.Append(" and TopicClassId in(");
int index = 0;
foreach (EyouSoft.Model.CommunityStructure.TopicClass type in TopicList)
{
strSql.AppendFormat("{0}{1}", index > 0 ? "," : "", (int)type);
index++;
}
strSql.Append(")");
}
if (IsPicNew.HasValue)
{
strSql.AppendFormat(" and IsImage='{0}' ", IsPicNew.Value ? "1" : "0");
}
if (IsFocusPic.HasValue)
{
strSql.Append(IsFocusPic.Value ? " AND len(ImgThumb)>0 " : " AND len(ImgThumb)=0 ");
}
if (IsTopPic.HasValue)
{
strSql.Append(IsTopPic.Value ? " AND len(ImgPath)>0 " : " AND len(ImgPath)=0 ");
}
strSql.Append(" order by IsTop desc,IssueTime desc");
#endregion
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.CommunityStructure.InfoArticle model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model.ID = dr.GetString(0);
model.ArticleTitle = dr.GetString(1);
model.TopicClassId = (EyouSoft.Model.CommunityStructure.TopicClass) int.Parse(dr.GetByte(2).ToString());
model.AreaId = (EyouSoft.Model.CommunityStructure.TopicAreas) int.Parse(dr.GetByte(3).ToString());
model.ImgThumb = dr.GetString(4);
model.ImgPath = dr.GetString(5);
list.Add(model);
model = null;
}
}
return(list);
}
protected int pic_height = 170; //图片高度
protected void Page_Load(object sender, EventArgs e)
{
strJavaScript.Append("<script type=\"text/javascript\">");
strJavaScript.AppendFormat("var show_text={0};", IsShowTitle ? 1 : 0);
strJavaScript.Append("var imag = new Array();");
strJavaScript.Append("var link = new Array();");
strJavaScript.Append("var text = new Array();");
switch (SwfType)
{
case 1: //行业资讯
case 3: //同业学堂
IList <EyouSoft.Model.CommunityStructure.InfoArticle> list = EyouSoft.BLL.CommunityStructure.InfoArticle.CreateInstance().GetTopNumPicList(TopNumber,
EyouSoft.Model.CommunityStructure.TopicClass.行业资讯, null, null, true);
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
EyouSoft.Model.CommunityStructure.InfoArticle model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model = list[i];
strJavaScript.AppendFormat("imag[{0}]=\"{1}{2}\";", i + 1, ImageServerPath, model.ImgPath);
strJavaScript.AppendFormat("link[{0}]=\"/SupplierInfo/{1}?Id={2}\";", i + 1, model.TopicClassId == EyouSoft.Model.CommunityStructure.TopicClass.行业资讯?
"ArticleInfo.aspx" : "SchoolIntroductionInfo.aspx", model.ID);
strJavaScript.AppendFormat("text[{0}]=\"{1}\";", i + 1, model.ArticleTitle);
model = null;
}
}
list = null;
break;
case 2: // 嘉宾访谈
IList <EyouSoft.Model.CommunityStructure.HonoredGuest> GuestList = EyouSoft.BLL.CommunityStructure.HonoredGuest.CreateInstance().GetTopNumList(TopNumber);
if (GuestList != null && GuestList.Count > 0)
{
for (int i = 0; i < GuestList.Count; i++)
{
EyouSoft.Model.CommunityStructure.HonoredGuest guestmodel = new EyouSoft.Model.CommunityStructure.HonoredGuest();
guestmodel = GuestList[i];
strJavaScript.AppendFormat("imag[{0}]=\"{1}{2}\";", i + 1, ImageServerPath, guestmodel.ImgPath);
strJavaScript.AppendFormat("link[{0}]=\"/SupplierInfo/HonoredGuestInfo.aspx?Id={1}\";", i + 1, guestmodel.ID);
strJavaScript.AppendFormat("text[{0}]=\"{1}\";", i + 1, guestmodel.Title);
guestmodel = null;
}
}
break;
}
strJavaScript.Append("</script>");
Page.Header.Controls.Add(new LiteralControl(strJavaScript.ToString()));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">行业资讯文章实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Update(EyouSoft.Model.CommunityStructure.InfoArticle model)
{
if (model == null)
{
return(false);
}
if (model.ImgPath.Trim().Length > 0 || model.ImgThumb.Trim().Length > 0)
{
model.IsImage = true;
}
else
{
model.IsImage = false;
}
return(dal.Update(model));
}
/// <summary>
/// 获取行业资讯实体
/// </summary>
/// <param name="ID">主键编号</param>
/// <returns>行业资讯实体</returns>
public virtual EyouSoft.Model.CommunityStructure.InfoArticle GetModel(string ID)
{
EyouSoft.Model.CommunityStructure.InfoArticle model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_InfoArticle_GETMODEL);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, ID);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model.ID = dr.GetString(0);
model.ArticleTitle = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
model.ImgPath = dr.IsDBNull(2) ? string.Empty : dr.GetString(2);
model.ImgThumb = dr.IsDBNull(3) ? string.Empty : dr.GetString(3);
model.ArticleText = dr.IsDBNull(4) ? string.Empty : dr.GetString(4);
model.ArticleTag = dr.IsDBNull(5) ? string.Empty : dr.GetString(5);
model.Editor = dr.IsDBNull(6) ? string.Empty : dr.GetString(6);
model.Source = dr.IsDBNull(7) ? string.Empty : dr.GetString(7);
model.TopicClassId = (EyouSoft.Model.CommunityStructure.TopicClass) int.Parse(dr.GetByte(8).ToString());
model.AreaId = (EyouSoft.Model.CommunityStructure.TopicAreas) int.Parse(dr.GetByte(9).ToString());
model.IssueTime = dr.GetDateTime(10);
model.IsImage = dr.IsDBNull(11) ? false : (dr.GetString(11) == "1" ? true : false);
model.IsTop = dr.IsDBNull(12) ? false : (dr.GetString(12) == "1" ? true : false);
model.IsFrontPage = dr.IsDBNull(13) ? false : (dr.GetString(13) == "1" ? true : false);
model.OperatorId = dr.GetInt32(14);
model.Click = dr.GetInt32(15);
model.TitleColor = dr.IsDBNull(16) ? string.Empty : dr.GetString(16);
}
if (dr.NextResult() && model != null)
{
if (dr.Read())
{
model.PrevInfo = new EyouSoft.Model.CommunityStructure.InfoArticleBase(dr.GetString(0), dr.GetString(1), (EyouSoft.Model.CommunityStructure.TopicClass) int.Parse(dr.GetByte(2).ToString()));
}
}
if (dr.NextResult() && model != null)
{
if (dr.Read())
{
model.NextInfo = new EyouSoft.Model.CommunityStructure.InfoArticleBase(dr.GetString(0), dr.GetString(1), (EyouSoft.Model.CommunityStructure.TopicClass) int.Parse(dr.GetByte(2).ToString()));
}
}
}
return(model);
}
/// <summary>
/// 获取指定类型的资讯列表（以浏览次数倒序排列）
/// </summary>
/// <param name="topNumber">要获取的记录行数</param>
/// <param name="TypeId">资讯大类别 =null返回全部</param>
/// <param name="areaId">资讯小类别 =null返回全部</param>
/// <returns>行业资讯列表</returns>
public virtual IList <EyouSoft.Model.CommunityStructure.InfoArticle> GetTopListByReadCount(int topNumber, EyouSoft.Model.CommunityStructure.TopicClass?TypeId, EyouSoft.Model.CommunityStructure.TopicAreas?areaId)
{
IList <EyouSoft.Model.CommunityStructure.InfoArticle> list = new List <EyouSoft.Model.CommunityStructure.InfoArticle>();
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(SQL_InfoArticle_GetTopListByReadCount, topNumber > 0 ? string.Format(" top {0} ", topNumber) : string.Empty);
strSql.Append(" where 1=1 ");
if (TypeId.HasValue)
{
strSql.AppendFormat(" and TopicClassId={0} ", (int)TypeId.Value);
}
if (areaId.HasValue)
{
strSql.AppendFormat(" and AreaId={0} ", (int)areaId.Value);
}
else
{
strSql.Append(" and AreaId<>9 "); //不取标签为“同业之星”的数据
}
strSql.Append(" order by Click desc ");
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.CommunityStructure.InfoArticle model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model.ID = dr[0].ToString();
model.ArticleTitle = dr.IsDBNull(1) ? string.Empty : dr[1].ToString();
if (!dr.IsDBNull(2))
{
model.TopicClassId = (EyouSoft.Model.CommunityStructure.TopicClass) int.Parse(dr.GetByte(2).ToString());
}
if (!dr.IsDBNull(3))
{
model.AreaId = (EyouSoft.Model.CommunityStructure.TopicAreas) int.Parse(dr.GetByte(3).ToString());
}
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 初始化同业资讯
/// </summary>
private void InitSchoolInfo()
{
EyouSoft.Model.CommunityStructure.InfoArticle model = EyouSoft.BLL.CommunityStructure.InfoArticle.CreateInstance().GetModel(SchoolInfoId);
if (model == null)
{
MessageBox.ShowAndRedirect(this, "没有找到要修改的信息！", "/SupplierManage/SchoolList.aspx");
return;
}
this.txtIssuTime.Value = model.IssueTime.ToString("yyyy-MM-dd hh:mm");
if (ddlBigType.Items.FindByValue(((int)model.TopicClassId).ToString()) != null)
{
ddlBigType.Items.FindByValue(((int)model.TopicClassId).ToString()).Selected = true;
}
if (ddlSmallType.Items.FindByValue(((int)model.AreaId).ToString() + "_" + ((int)model.TopicClassId).ToString()) != null)
{
ddlSmallType.Items.FindByValue(((int)model.AreaId).ToString() + "_" + ((int)model.TopicClassId).ToString()).Selected = true;
}
if (ddlColor.Items.FindByValue(model.TitleColor) != null)
{
ddlColor.Items.FindByValue(model.TitleColor).Selected = true;
}
this.txt_TitleName.Value = model.ArticleTitle;
this.FCK_PlanTicketContent.Value = model.ArticleText;
this.txtSendPeople.Value = model.Editor;
if (!string.IsNullOrEmpty(model.ImgPath)) //推荐图
{
ltrOldImgPath.Text = string.Format("推荐图片：<a href=\"{0}\"target='_blank' title=\"点击查看\">{1}</a> ", Domain.FileSystem + model.ImgPath, model.ImgPath.Substring(model.ImgPath.LastIndexOf('/') + 1));
hdfImgPath.Value = model.ImgPath;
}
if (!string.IsNullOrEmpty(model.ImgThumb)) //焦点图
{
ltrOldImgThumb.Text = string.Format("焦点图片：<a href=\"{0}\"target='_blank' title=\"点击查看\">{1}</a>", Domain.FileSystem + model.ImgThumb, model.ImgThumb.Substring(model.ImgThumb.LastIndexOf('/') + 1));
hdfImgThumb.Value = model.ImgThumb;
}
ckbIsTop.Checked = model.IsTop;
ckbIsFrontPage.Checked = model.IsFrontPage;
txtTag.Value = model.ArticleTag;
txtSource.Value = model.Source;
}
/// <summary>
///获取指定条数的行业资讯列表
/// </summary>
/// <param name="topNumber">需要返回的总记录数</param>
/// <param name="topClass">大类别 =null返回全部</param>
/// <param name="areaId">子类别 =null返回全部</param>
/// <param name="IsPicNew">是否图片资讯 =null返回全部</param>
/// <param name="IsCurrWeekNew">是否本周最新资讯</param>
/// <param name="IsFrontPage">是否首页显示 =null返回全部</param>
/// <param name="KeyWord">需要匹配的关键字</param>
/// <param name="CurrInfoID">是否当前资讯的相关文章 =""返回全部</param>
/// <param name="IsFocusPic">是否焦点图片 =null返回全部</param>
/// <param name="IsTopPic">是否推荐图片 =null返回全部</param>
/// <returns>行业资讯列表</returns>
public virtual IList <EyouSoft.Model.CommunityStructure.InfoArticle> GetTopNumList(int topNumber, EyouSoft.Model.CommunityStructure.TopicClass?topClass, EyouSoft.Model.CommunityStructure.TopicAreas?areaId, bool?IsPicNew,
bool IsCurrWeekNew, bool?IsFrontPage, string KeyWord, string CurrInfoID, bool?IsFocusPic, bool?IsTopPic)
{
IList <EyouSoft.Model.CommunityStructure.InfoArticle> list = new List <EyouSoft.Model.CommunityStructure.InfoArticle>();
DbCommand dc = this._database.GetStoredProcCommand("proc_InfoArticle_GetTopNumList");
this._database.AddInParameter(dc, "topNumber", DbType.Int32, topNumber);
this._database.AddInParameter(dc, "topClass", DbType.Int32, topClass.HasValue ? (int)topClass.Value : -1);
this._database.AddInParameter(dc, "areaId", DbType.Int32, areaId.HasValue ? (int)areaId.Value : -1);
this._database.AddInParameter(dc, "IsPicNew", DbType.AnsiStringFixedLength, IsPicNew.HasValue ? (IsPicNew.Value ? 1 : 0) : -1);
this._database.AddInParameter(dc, "IsFrontPage", DbType.AnsiStringFixedLength, IsFrontPage.HasValue ? (IsFrontPage.Value ? 1 : 0) : -1);
this._database.AddInParameter(dc, "KeyWord", DbType.String, KeyWord);
this._database.AddInParameter(dc, "IsCurrWeekNew", DbType.String, IsCurrWeekNew ? "1" : "0");
this._database.AddInParameter(dc, "CurrInfoID", DbType.String, CurrInfoID);
this._database.AddInParameter(dc, "IsFocusPic", DbType.Int32, IsFocusPic.HasValue ? (IsFocusPic.Value ? 1 : 0) : -1);
this._database.AddInParameter(dc, "IsTopPic", DbType.Int32, IsTopPic.HasValue ? (IsTopPic.Value ? 1 : 0) : -1);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.CommunityStructure.InfoArticle model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model.ID = dr.IsDBNull(0) ? string.Empty : dr.GetString(0);
model.ArticleTitle = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
model.ImgThumb = dr.IsDBNull(2) ? string.Empty : dr.GetString(2);
model.ArticleText = dr.IsDBNull(3) ? string.Empty : dr.GetString(3);
model.TitleColor = dr.IsDBNull(4) ? string.Empty : dr.GetString(4);
model.IssueTime = dr.IsDBNull(5) ? DateTime.MinValue : dr.GetDateTime(5);
model.ImgPath = dr.IsDBNull(6) ? string.Empty : dr.GetString(6);
model.TopicClassId = (EyouSoft.Model.CommunityStructure.TopicClass) int.Parse(dr.GetByte(7).ToString());
model.AreaId = (EyouSoft.Model.CommunityStructure.TopicAreas) int.Parse(dr.GetByte(8).ToString());
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 初始化页面
/// </summary>
private void InitPageData()
{
EyouSoft.IBLL.CommunityStructure.IInfoArticle ibll = EyouSoft.BLL.CommunityStructure.InfoArticle.CreateInstance();
EyouSoft.Model.CommunityStructure.InfoArticle model = ibll.GetModel(ArticleId);
if (model == null)
{
Utils.ShowError("未能找到您要查看的资讯！", "InfoArticle");
}
TopicClassId = (int)model.TopicClassId;
TopicAreasId = (int)model.AreaId;
this.Page.Title = model.ArticleTitle;
System.Text.StringBuilder strA = new System.Text.StringBuilder();
if (TopicClassId == 1)
{
strA.AppendFormat("<a href=\"/SupplierInfo/InfoArticle.aspx\">{0}</a>", Enum.GetName(typeof(EyouSoft.Model.CommunityStructure.TopicClass), TopicClassId));
}
else if (TopicClassId > 0)
{
strA.AppendFormat("<a href=\"/SupplierInfo/SchoolIntroduction.aspx\">{0}</a>", Enum.GetName(typeof(EyouSoft.Model.CommunityStructure.TopicClass), TopicClassId));
}
ltrTopicClass.Text = strA.ToString();
//小类别要判断
if (TopicAreasId > 0)
{
if (TopicAreasIds.Contains(TopicAreasId))
{
ltrTopIcArea.Text = string.Format(" > <a href=\"/SupplierInfo/ArticleList.aspx?TypeId={0}&AreaId={1}\">{2}</a>", TopicClassId, TopicAreasId, Enum.GetName(typeof(EyouSoft.Model.CommunityStructure.TopicAreas), TopicAreasId));
}
else
{
ltrTopIcArea.Text = string.Format(" > <a href=\"/SupplierInfo/SchoolIntroductionList.aspx?TypeId={0}&AreaId={1}\">{2}</a>", TopicClassId, TopicAreasId, Enum.GetName(typeof(EyouSoft.Model.CommunityStructure.TopicAreas), TopicAreasId));
}
}
if (string.IsNullOrEmpty(model.TitleColor))
{
ltrTitle.Text = model.ArticleTitle;
}
else
{
ltrTitle.Text = string.Format("<font color=\"{0}\">", model.TitleColor) + model.ArticleTitle + "</font>";
}
ltrTime.Text = model.IssueTime.ToString("yyyy年MM月dd日 hh:mm");
if (!string.IsNullOrEmpty(model.Source))
{
ltrSource.Text = "来源：" + model.Source;
}
if (model.IsImage)
{
ltrImg.Text = string.Format("<img src=\"{0}\" alt=\"{1}\" width=\"600\" height=\"400\" />", Domain.FileSystem + model.ImgPath, model.ArticleTitle);
}
ltrInfo.Text = model.ArticleText;
ltrTags.Text = string.IsNullOrEmpty(model.ArticleTag) ? string.Empty : model.ArticleTag.Replace(",", " ");
ltrEditOR.Text = Utils.GetText(model.Editor, 6);
if (model.PrevInfo != null)
{
ltrPrev.Text = string.Format("上一篇：<a href=\"/SupplierInfo/{0}?Id={1}\">{2}</a>", model.PrevInfo.TopicClassId == EyouSoft.Model.CommunityStructure.TopicClass.行业资讯 ? "ArticleInfo.aspx" : "SchoolIntroductionInfo.aspx", model.PrevInfo.ID, Utils.GetText(model.PrevInfo.ArticleTitle, 20));
}
if (model.NextInfo != null)
{
ltrNext.Text = string.Format("下一篇：<a href=\"/SupplierInfo/{0}?Id={1}\">{2}</a>", model.NextInfo.TopicClassId == EyouSoft.Model.CommunityStructure.TopicClass.行业资讯 ? "ArticleInfo.aspx" : "SchoolIntroductionInfo.aspx", model.NextInfo.ID, Utils.GetText(model.NextInfo.ArticleTitle, 20));
}
//绑定相关文章列表
rptRelatedArticle.DataSource = ibll.GetTopNumTagList(8, (EyouSoft.Model.CommunityStructure.TopicClass)TopicClassId, (EyouSoft.Model.CommunityStructure.TopicAreas)TopicAreasId, ArticleId);
rptRelatedArticle.DataBind();
//绑定最新图文资讯
rptArticle.DataSource = ibll.GetTopNumPicList(5, null, null, true, null);
rptArticle.DataBind();
ibll = null;
model = null;
}
protected void Page_Load(object sender, EventArgs e)
{
Supplier site = (Supplier)this.Master;
if (site != null)
{
site.MenuIndex = 2;
}
if (!IsPostBack)
{
#region 景点新闻
Viewpoint.TopNumber = 7;
Viewpoint.TopicArea = EyouSoft.Model.CommunityStructure.TopicAreas.景区新闻;
Viewpoint.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
#endregion
#region 旅行社新闻
Travel.TopNumber = 7;
Travel.TopicArea = EyouSoft.Model.CommunityStructure.TopicAreas.旅行社;
Travel.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
#endregion
#region 酒店新闻
Hotel.TopicArea = EyouSoft.Model.CommunityStructure.TopicAreas.酒店新闻;
Hotel.TopNumber = 7;
Hotel.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
#endregion
#region 政策解读
Policy.TopicArea = EyouSoft.Model.CommunityStructure.TopicAreas.政策解读;
Policy.TopNumber = 8;
Policy.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
#endregion
#region 成功故事
Success.TopicArea = EyouSoft.Model.CommunityStructure.TopicAreas.成功故事;
Success.TopNumber = 10;
Success.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
#endregion
#region 绑定新闻，资讯列表
EyouSoft.IBLL.CommunityStructure.IInfoArticle IBll = EyouSoft.BLL.CommunityStructure.InfoArticle.CreateInstance();
EyouSoft.Model.CommunityStructure.InfoArticle model = null;
IList <EyouSoft.Model.CommunityStructure.InfoArticle> list = null;
#region 绑定新闻
model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model = IBll.GetHeadInfo(EyouSoft.Model.CommunityStructure.TopicClass.行业资讯, EyouSoft.Model.CommunityStructure.TopicAreas.新闻资讯);
if (model != null)
{
lbNews.Text = string.Format("<a href='/SupplierInfo/ArticleInfo.aspx?Id={0}' title=\"{2}\">{1}</a>", model.ID, model.TitleColor.Length == 0 ? Utils.GetText(model.ArticleTitle, 22) : string.Format("<font color='{0}'>{1}</font>", model.TitleColor, Utils.GetText(model.ArticleTitle, 22)), model.ArticleTitle);
lbNewsContent.Text = Utils.GetText(StringValidate.LoseHtml(model.ArticleText), 75, true);
ltnews.Text = string.Format("<a href=\"/SupplierInfo/ArticleInfo.aspx?Id={0}\"><span class=\"ff0000\">阅读全文>></span></a>", model.ID);
}
model = null;
list = new List <EyouSoft.Model.CommunityStructure.InfoArticle>();
list = IBll.GetTopNumList(12, EyouSoft.Model.CommunityStructure.TopicClass.行业资讯, EyouSoft.Model.CommunityStructure.TopicAreas.新闻资讯, null, string.Empty);
rpNews.DataSource = list;
rpNews.DataBind();
list = null;
#endregion
#region 绑定资讯
model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model = IBll.GetHeadInfo(EyouSoft.Model.CommunityStructure.TopicClass.行业资讯, EyouSoft.Model.CommunityStructure.TopicAreas.行业动态);
if (model != null)
{
lbInfo.Text = string.Format("<a href='/SupplierInfo/ArticleInfo.aspx?Id={0}' title=\"{2}\">{1}</a>", model.ID, model.TitleColor.Length == 0 ? Utils.GetText(model.ArticleTitle, 22) : string.Format("<font color='{0}'>{1}</font>", model.TitleColor, Utils.GetText(model.ArticleTitle, 22)), model.ArticleTitle);
lbinfoContent.Text = Utils.GetText(StringValidate.LoseHtml(model.ArticleText), 70, true);
ltinfo.Text = string.Format("<a href=\"/SupplierInfo/ArticleInfo.aspx?Id={0}\"><span class=\"ff0000\">阅读全文>></span></a>", model.ID);
}
model = null;
list = new List <EyouSoft.Model.CommunityStructure.InfoArticle>();
list = IBll.GetTopNumList(13, EyouSoft.Model.CommunityStructure.TopicClass.行业资讯, EyouSoft.Model.CommunityStructure.TopicAreas.行业动态, null, string.Empty);
rpInfo.DataSource = list;
rpInfo.DataBind();
list = null;
#endregion
IBll = null;
#endregion
#region 最新行业资讯
CommonTopic1.PartType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.PartTypes.资讯;
CommonTopic1.TopicType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.TopicTypes.软文广告列表;
CommonTopic1.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
//CommonTopic1.TopicArea = EyouSoft.Model.CommunityStructure.TopicAreas.行业动态;
#endregion
#region 业之星访谈
CommonTopic2.PartType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.PartTypes.业之星访谈;
CommonTopic2.TopicType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.TopicTypes.图文广告列表;
CommonTopic2.TopicArea = EyouSoft.Model.CommunityStructure.TopicAreas.业之星;
CommonTopic2.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
CommonTopic2.CurrCityId = CityId;
//CommonTopic2.TopicClass = null;
//CommonTopic2.TopicArea = null;
#endregion
#region 业学堂
CommonTopic3.PartType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.PartTypes.业学堂;
CommonTopic3.TopicType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.TopicTypes.软文广告列表;
#endregion
#region 图片新闻
CommonTopic4.PartType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.PartTypes.资讯;
CommonTopic4.TopicType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.TopicTypes.图文广告列表;
CommonTopic4.TopicClass = EyouSoft.Model.CommunityStructure.TopicClass.行业资讯;
#endregion
#region 旗帜广告
System.Collections.Generic.IList <EyouSoft.Model.AdvStructure.AdvInfo> AdvListBanner = EyouSoft.BLL.AdvStructure.Adv.CreateInstance().GetAdvs(CityId, EyouSoft.Model.AdvStructure.AdvPosition.供求信息频道行业资讯旗帜广告);
if (AdvListBanner != null && AdvListBanner.Count > 0)
{
ltrAdv.Text = string.Format("<a target=\"_blank\" title=\"{3}\" href=\"{0}\"><img src=\"{1}\" alt=\"{2}\" width=\"250\" height=\"85\"></a>", AdvListBanner[0].RedirectURL, Domain.FileSystem + AdvListBanner[0].ImgPath, AdvListBanner[0].Title, AdvListBanner[0].Title);
}
if (AdvListBanner != null)
{
AdvListBanner.Clear();
}
AdvListBanner = null;
#endregion
}
}
/// <summary>
/// 分业获取行业资讯列表
/// </summary>
/// <param name="pageSize">每页显示的条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <param name="topClass">大类别 =null返回全部</param>
/// <param name="areaId">子类别 =null返回全部</param>
/// <param name="IsPicNew">是否图片资讯 =null返回全部</param>
/// <param name="KeyWord">需要匹配的关键字</param>
/// <param name="InfoTag">需要匹配的标签</param>
/// <param name="IsFocusPic">是否焦点图片 =null返回全部</param>
/// <param name="IsTopPic">是否推荐图片 =null返回全部</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.CommunityStructure.InfoArticle> GetPageList(int pageSize, int pageIndex, ref int recordCount,
EyouSoft.Model.CommunityStructure.TopicClass?topClass, EyouSoft.Model.CommunityStructure.TopicAreas?areaId, bool?IsPicNew, string KeyWord, string InfoTag
, bool?IsFocusPic, bool?IsTopPic)
{
IList <EyouSoft.Model.CommunityStructure.InfoArticle> list = new List <EyouSoft.Model.CommunityStructure.InfoArticle>();
string tableName = "tbl_CommunityInfoArticle";
string fields = "ID,ArticleTitle,ImgThumb,ArticleText,ArticleTag,Editor,Source,IssueTime,Click,TitleColor,IsTop,TopicClassId,AreaId,IsFrontPage,ImgPath";
string primaryKey = "ID";
string orderByString = "IssueTime desc";
#region 生成查询条件
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 ");
if (topClass.HasValue)
{
strWhere.AppendFormat(" AND TopicClassId={0} ", (int)topClass.Value);
}
if (areaId.HasValue)
{
strWhere.AppendFormat(" AND AreaId={0} ", (int)areaId.Value);
}
if (IsPicNew.HasValue)
{
strWhere.AppendFormat(" AND IsImage='{0}' ", IsPicNew.Value ? "1" : "0");
}
if (!string.IsNullOrEmpty(KeyWord))
{
strWhere.AppendFormat(" AND ArticleTitle like '%{0}%' ", KeyWord);
}
if (!string.IsNullOrEmpty(InfoTag))
{
strWhere.AppendFormat(" AND charindex('{0}',ArticleTag,0)>0 ", InfoTag);
}
if (IsFocusPic.HasValue)
{
strWhere.Append(IsFocusPic.Value ? " AND len(ImgThumb)>0 " : " AND len(ImgThumb)=0 ");
}
if (IsTopPic.HasValue)
{
strWhere.Append(IsTopPic.Value ? " AND len(ImgPath)>0 " : " AND len(ImgPath)=0 ");
}
#endregion
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (dr.Read())
{
EyouSoft.Model.CommunityStructure.InfoArticle model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model.ID = dr.GetString(0);
model.ArticleTitle = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
model.ImgThumb = dr.IsDBNull(2) ? string.Empty : dr.GetString(2);
model.ArticleText = dr.IsDBNull(3) ? string.Empty : dr.GetString(3);
model.ArticleTag = dr.IsDBNull(4) ? string.Empty : dr.GetString(4);
model.Editor = dr.IsDBNull(5) ? string.Empty : dr.GetString(5);
model.Source = dr.IsDBNull(6) ? string.Empty : dr.GetString(6);
model.IssueTime = dr.IsDBNull(7) ? DateTime.Now : dr.GetDateTime(7);
model.Click = dr.IsDBNull(8) ? 0 : dr.GetInt32(8);
model.TitleColor = dr.IsDBNull(9) ? string.Empty : dr.GetString(9);
model.IsTop = dr.IsDBNull(10) ? false : (dr.GetString(10) == "1" ? true : false);
if (!dr.IsDBNull(dr.GetOrdinal("TopicClassId")))
{
model.TopicClassId = (EyouSoft.Model.CommunityStructure.TopicClass) int.Parse(dr["TopicClassId"].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("AreaId")))
{
model.AreaId = (EyouSoft.Model.CommunityStructure.TopicAreas) int.Parse(dr["AreaId"].ToString());
}
model.IsFrontPage = dr.IsDBNull(13) ? false : (dr.GetString(13) == "1" ? true : false);
model.ImgPath = dr.IsDBNull(14) ? string.Empty : dr.GetString(14);
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
int BigType = Utils.GetInt(ddlBigType.SelectedValue.Trim());
string SmallType = Utils.GetString(ddlSmallType.SelectedValue.Trim(), "0");
string strTitle = Utils.InputText(txt_TitleName.Value);
string strTitleColor = Utils.InputText(ddlColor.SelectedValue);
string strTag = Utils.InputText(txtTag.Value.Trim());
string strSource = Utils.InputText(txtSource.Value.Trim());
string NewImgThumb = Utils.GetFormValue("SingleFileUpload1$hidFileName");
string OldImgThumb = Utils.InputText(hdfImgThumb.Value.Trim());
string NewImgPath = Utils.GetFormValue("SingleFileUpload2$hidFileName");
string OldImgPath = Utils.InputText(hdfImgPath.Value.Trim());
bool IsTop = ckbIsTop.Checked;
string strInfo = FCK_PlanTicketContent.Value.Trim();
System.Text.StringBuilder strErr = new System.Text.StringBuilder();
if (BigType <= 0)
{
strErr.Append("请选择大类别！\\n");
}
if (SmallType == "0" && BigType != 5)
{
strErr.Append("请选择小类别！\\n");
}
if (string.IsNullOrEmpty(strTitle))
{
strErr.Append("请填写标题！\\n");
}
if (!string.IsNullOrEmpty(strErr.ToString()))
{
MessageBox.ShowAndReturnBack(this, strErr.ToString(), 1);
return;
}
EyouSoft.Model.CommunityStructure.InfoArticle model = new EyouSoft.Model.CommunityStructure.InfoArticle();
model.AreaId = SmallType.Contains("_") ? (EyouSoft.Model.CommunityStructure.TopicAreas) int.Parse(SmallType.Split('_')[0].ToString()) : EyouSoft.Model.CommunityStructure.TopicAreas.未知;
model.ArticleTag = strTag;
model.ArticleText = strInfo;
model.ArticleTitle = strTitle;
model.Editor = MasterUserInfo.ContactName;
model.IssueTime = DateTime.Now;
model.IsTop = IsTop;
model.IsFrontPage = ckbIsFrontPage.Checked;
model.OperatorId = MasterUserInfo.ID;
model.Source = strSource;
model.TitleColor = strTitleColor;
model.TopicClassId = (EyouSoft.Model.CommunityStructure.TopicClass)BigType;
bool Result = false;
if (string.IsNullOrEmpty(SchoolInfoId))
{
model.ImgPath = NewImgPath;
model.ImgThumb = NewImgThumb;
Result = EyouSoft.BLL.CommunityStructure.InfoArticle.CreateInstance().Add(model);
}
else
{
model.ImgPath = string.IsNullOrEmpty(NewImgPath) ? OldImgPath : NewImgPath;
model.ImgThumb = string.IsNullOrEmpty(NewImgThumb) ? OldImgThumb : NewImgThumb;
model.ID = SchoolInfoId;
Result = EyouSoft.BLL.CommunityStructure.InfoArticle.CreateInstance().Update(model);
}
if (Result)
{
MessageBox.ShowAndRedirect(this, "保存成功！", "/SupplierManage/SchoolList.aspx");
}
else
{
MessageBox.ShowAndRedirect(this, "保存失败！", "/SupplierManage/SchoolList.aspx");
}
}
