/// <summary>
/// 分页获取嘉宾访谈列表
/// </summary>
/// <param name="pageSize">每页显示的条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <param name="KeyWord">需要匹配的关键字</param>
/// <returns>嘉宾访谈列表集合</returns>
public virtual IList <EyouSoft.Model.CommunityStructure.HonoredGuest> GetPageList(int pageSize, int pageIndex, ref int recordCount, string KeyWord)
{
IList <EyouSoft.Model.CommunityStructure.HonoredGuest> list = new List <EyouSoft.Model.CommunityStructure.HonoredGuest>();
string tableName = "tbl_CommunityHonoredGuest";
string fields = "ID,Title,Content,IssueTime,Summary";
string primaryKey = "ID";
string orderByString = "IssueTime desc";
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(KeyWord))
{
strWhere = string.Format(" Title like'%{0}%' ", KeyWord);
}
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere, orderByString))
{
while (dr.Read())
{
EyouSoft.Model.CommunityStructure.HonoredGuest model = new EyouSoft.Model.CommunityStructure.HonoredGuest();
model.ID = dr.GetString(0);
model.Title = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
model.Content = dr.IsDBNull(2) ? string.Empty : dr.GetString(2);
model.IssueTime = dr.IsDBNull(3) ? DateTime.Now : dr.GetDateTime(3);
model.Summary = dr.IsDBNull(4) ? string.Empty : dr.GetString(4);
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 获取嘉宾访谈实体
/// </summary>
/// <param name="Id">主键编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.CommunityStructure.HonoredGuest GetModel(string Id)
{
EyouSoft.Model.CommunityStructure.HonoredGuest model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_CommunityHonoredGuest_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.HonoredGuest();
model.ID = dr.GetString(0);
model.Title = 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.Content = dr.IsDBNull(4) ? string.Empty : dr.GetString(4);
model.Opinion1 = dr.IsDBNull(5) ? string.Empty : dr.GetString(5);
model.Opinion2 = dr.IsDBNull(6) ? string.Empty : dr.GetString(6);
model.Opinion3 = dr.IsDBNull(7) ? string.Empty : dr.GetString(7);
model.Summary = dr.IsDBNull(8) ? string.Empty : dr.GetString(8);
model.IssueTime = dr.IsDBNull(9) ? DateTime.Now : dr.GetDateTime(9);
model.OperatorId = dr.IsDBNull(10) ? 0 : dr.GetInt32(10);
}
}
return(model);
}
/// <summary>
/// 初始化页面
/// </summary>
private void InitPageData()
{
if (string.IsNullOrEmpty(HonoredGuestId))
{
return;
}
EyouSoft.Model.CommunityStructure.HonoredGuest model = EyouSoft.BLL.CommunityStructure.HonoredGuest.CreateInstance().GetModel(HonoredGuestId);
if (model == null)
{
MessageBox.ShowAndRedirect(this, "没有找到要修改的信息！", "/SupplierManage/HonoredGuest.aspx");
return;
}
txtTitle.Value = model.Title;
ltrOldBanner.Text = string.Format("<a href=\"{0}\"target='_blank' title=\"点击查看\">{1}</a>", Domain.FileSystem + model.ImgPath, model.ImgPath.Substring(model.ImgPath.LastIndexOf('/') + 1));
ltrOldSmallImg.Text = string.Format("<a href=\"{0}\"target='_blank' title=\"点击查看\">{1}</a>", Domain.FileSystem + model.ImgThumb, model.ImgThumb.Substring(model.ImgThumb.LastIndexOf('/') + 1));
hdfOldOldBanner.Value = model.ImgPath;
hdfOldSmallImg.Value = model.ImgThumb;
txtHonoredGuest.Value = model.Content;
txtView1.Value = model.Opinion1;
txtView2.Value = model.Opinion2;
txtView3.Value = model.Opinion3;
txtSummary.Value = model.Summary;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">嘉宾访谈实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Update(EyouSoft.Model.CommunityStructure.HonoredGuest model)
{
if (model == null)
{
return(false);
}
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">嘉宾访谈实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Add(EyouSoft.Model.CommunityStructure.HonoredGuest model)
{
if (model == null)
{
return(false);
}
model.ID = Guid.NewGuid().ToString();
return(dal.Add(model));
}
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 virtual bool Update(EyouSoft.Model.CommunityStructure.HonoredGuest model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_DELETEDFILE_UPDATEMOVE + SQL_CommunityHonoredGuest_UPDATE);
this._database.AddInParameter(dc, "Title", DbType.String, model.Title);
this._database.AddInParameter(dc, "ImgPath", DbType.String, model.ImgPath);
this._database.AddInParameter(dc, "ImgThumb", DbType.String, model.ImgThumb);
this._database.AddInParameter(dc, "Content", DbType.String, model.Content);
this._database.AddInParameter(dc, "Opinion1", DbType.String, model.Opinion1);
this._database.AddInParameter(dc, "Opinion2", DbType.String, model.Opinion2);
this._database.AddInParameter(dc, "Opinion3", DbType.String, model.Opinion3);
this._database.AddInParameter(dc, "Summary", DbType.String, model.Summary);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this._database.AddInParameter(dc, "OperatorId", DbType.Int32, model.OperatorId);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
/// <summary>
/// 初始化页面
/// </summary>
private void InitPageData()
{
EyouSoft.Model.CommunityStructure.HonoredGuest model = EyouSoft.BLL.CommunityStructure.HonoredGuest.CreateInstance().GetModel(HonoredGuestId);
if (model == null)
{
MessageBox.ShowAndRedirect(this, "未找到您要查看的信息！", HonoredGuestUrl);
return;
}
ltrImg.Text = string.Format("<img src=\"{0}{1}\" width=\"455\" height=\"181\" />", Domain.FileSystem, model.ImgPath);
ltrTitle.Text = model.Title;
ltrInfo.Text = model.Content;
ltrView1.Text = model.Opinion1;
ltrView2.Text = model.Opinion2;
ltrView3.Text = model.Opinion3;
ltrSummary.Text = model.Summary;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">嘉宾访谈实体</param>
/// <returns>true:成功 false:失败</returns>
public virtual bool Add(EyouSoft.Model.CommunityStructure.HonoredGuest model)
{
model.ID = Guid.NewGuid().ToString();
DbCommand dc = this._database.GetSqlStringCommand(SQL_CommunityHonoredGuest_ADD);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this._database.AddInParameter(dc, "Title", DbType.String, model.Title);
this._database.AddInParameter(dc, "ImgPath", DbType.String, model.ImgPath);
this._database.AddInParameter(dc, "ImgThumb", DbType.String, model.ImgThumb);
this._database.AddInParameter(dc, "Content", DbType.String, model.Content);
this._database.AddInParameter(dc, "Opinion1", DbType.String, model.Opinion1);
this._database.AddInParameter(dc, "Opinion2", DbType.String, model.Opinion2);
this._database.AddInParameter(dc, "Opinion3", DbType.String, model.Opinion3);
this._database.AddInParameter(dc, "Summary", DbType.String, model.Summary);
this._database.AddInParameter(dc, "IssueTime", DbType.String, DateTime.Now);
this._database.AddInParameter(dc, "OperatorId", DbType.Int32, model.OperatorId);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
protected void Page_Load(object sender, EventArgs e)
{
Supplier site = (Supplier)this.Master;
if (site != null)
{
site.MenuIndex = 3;
}
#region 业交流专区
CommonTopic5.PartType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.PartTypes.业交流专区;
CommonTopic5.TopicType = UserPublicCenter.SupplierInfo.UserControl.CommonTopicControl.TopicTypes.文字描述;
#endregion
#region 绑定最新一期的嘉宾访谈及回复
EyouSoft.IBLL.CommunityStructure.IHonoredGuest GuestBll = EyouSoft.BLL.CommunityStructure.HonoredGuest.CreateInstance();
EyouSoft.Model.CommunityStructure.HonoredGuest GuestModel = GuestBll.GetNewInfo();
if (GuestModel != null)
{
ltrMoreComment.Text = string.Format("<a href=\"/SupplierInfo/HonoredGuestComment.aspx?Id={0}\" target=\"_blank\" class=\"heise12\">更多>></a>", GuestModel.ID);
HonoredGuestInfoUrl = "/SupplierInfo/HonoredGuestInfo.aspx?Id=" + GuestModel.ID;
lbTitle.Text = string.Format("<a href=\"/SupplierInfo/HonoredGuestInfo.aspx?Id={0}\">{1}</a>", GuestModel.ID, GuestModel.Title); //Utils.GetText(GuestModel.Title, 10));
lbContent.Text = GuestModel.Content; //Utils.GetText(GuestModel.Content, 50, true);
OpinionContent1.Text = GuestModel.Opinion1; //Utils.GetText(GuestModel.Opinion1, 50, true);
OpinionContent2.Text = GuestModel.Opinion2; //Utils.GetText(GuestModel.Opinion2, 50, true);
OpinionContent3.Text = GuestModel.Opinion3; //Utils.GetText(GuestModel.Opinion3, 50, true);
Summary.Text = GuestModel.Summary; //Utils.GetText(GuestModel.Summary, 50, true);
hGuestId.Value = GuestModel.ID;
#region 绑定访谈回复
IList <EyouSoft.Model.CommunityStructure.ExchangeComment> CommentList = Ibll.GetGuestInterview(6, hGuestId.Value);
if (CommentList != null && CommentList.Count > 0)
{
RpComment.DataSource = CommentList;
RpComment.DataBind();
}
CommentList = null;
#endregion
}
GuestModel = null;
GuestBll = null;
#endregion
}
/// <summary>
/// 获取指定条数的嘉宾访谈列表集合
/// </summary>
/// <param name="topNumber">需要返回的记录数 =0返回全部</param>
/// <returns>嘉宾访谈列表集合</returns>
public virtual IList <EyouSoft.Model.CommunityStructure.HonoredGuest> GetTopNumList(int topNumber)
{
string strSql = string.Format(SQL_CommunityHonoredGuest_GetTopNumList, topNumber > 0 ? string.Format(" top {0} ", topNumber) : string.Empty);
IList <EyouSoft.Model.CommunityStructure.HonoredGuest> list = new List <EyouSoft.Model.CommunityStructure.HonoredGuest>();
DbCommand dc = this._database.GetSqlStringCommand(strSql);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.CommunityStructure.HonoredGuest model = new EyouSoft.Model.CommunityStructure.HonoredGuest();
model.ID = dr.GetString(0);
model.Title = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
model.ImgThumb = dr.IsDBNull(2) ? string.Empty : dr.GetString(2);
model.ImgPath = dr.IsDBNull(3) ? string.Empty : dr.GetString(3);
model.Content = dr.IsDBNull(4) ? string.Empty : dr.GetString(4);
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 保存嘉宾访谈
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
bool Result = false;
string NewImgPath = Utils.GetFormValue("txtBanner$hidFileName");
string NewImgThumb = Utils.GetFormValue("txtSmallImg$hidFileName");
string OldImgPath = Utils.InputText(hdfOldOldBanner.Value);
string OldThumb = Utils.InputText(hdfOldSmallImg.Value);
string strTitle = txtTitle.Value;
string strContent = txtHonoredGuest.Value;
System.Text.StringBuilder strErr = new System.Text.StringBuilder();
if (string.IsNullOrEmpty(strTitle))
{
strErr.Append("请填写标题！\\n");
}
if (string.IsNullOrEmpty(strContent))
{
strErr.Append("请填写嘉宾介绍！\\n");
}
if (!string.IsNullOrEmpty(strErr.ToString()))
{
MessageBox.ShowAndReturnBack(this, strErr.ToString(), 1);
return;
}
EyouSoft.Model.CommunityStructure.HonoredGuest model = new EyouSoft.Model.CommunityStructure.HonoredGuest();
model.Title = txtTitle.Value;
model.Content = txtHonoredGuest.Value;
model.Opinion1 = txtView1.Value;
model.Opinion2 = txtView2.Value;
model.Opinion3 = txtView3.Value;
model.Summary = txtSummary.Value;
model.OperatorId = MasterUserInfo.ID;
if (string.IsNullOrEmpty(HonoredGuestId))
{
model.ImgPath = NewImgPath;
model.ImgThumb = NewImgThumb;
Result = EyouSoft.BLL.CommunityStructure.HonoredGuest.CreateInstance().Add(model);
}
else
{
model.ID = HonoredGuestId;
if (string.IsNullOrEmpty(NewImgPath))
{
model.ImgPath = OldImgPath;
}
else
{
model.ImgPath = NewImgPath;
}
if (string.IsNullOrEmpty(NewImgThumb))
{
model.ImgThumb = OldThumb;
}
else
{
model.ImgThumb = NewImgThumb;
}
Result = EyouSoft.BLL.CommunityStructure.HonoredGuest.CreateInstance().Update(model);
}
if (Result)
{
MessageBox.ShowAndRedirect(this, "保存成功！", "/SupplierManage/HonoredGuest.aspx");
}
else
{
MessageBox.ShowAndRedirect(this, "保存失败！", "/SupplierManage/HonoredGuest.aspx");
}
}