protected void Page_Load(object sender, EventArgs e)
{
//获取新闻
string id = Utils.InputText(Request.QueryString["newid"]);
if (id != null)
{
this.litPageTitle.Text = "最新动态";
EyouSoft.Model.ShopStructure.HighShopNews newModel = EyouSoft.BLL.ShopStructure.HighShopNews.CreateInstance().GetModel(id);
if (newModel != null)
{
//页面标题初始化
Page.Title = Utils.InputText(newModel.Title) + "_最新动态";
//新闻内容初始化
ltrTitle.Text = Utils.InputText(newModel.Title);
ltrContent.Text = Utils.InputText(newModel.ContentText);
ltrIssuetime.Text = newModel.IssueTime.ToString("yyyy-MM-dd HH:mm");
}
newModel = null;
}
//同业公告id
string noticeid = Utils.GetQueryStringValue("noticeid");
if (noticeid != null && !string.IsNullOrEmpty(noticeid))
{
this.litPageTitle.Text = "同业公告";
}
}
/// <summary>
/// 修改旅游动态
/// </summary>
/// <param name="model">旅游动态实体</param>
/// <returns>false:失败 true:成功</returns>
public bool Update(EyouSoft.Model.ShopStructure.HighShopNews model)
{
if (model == null)
{
return(false);
}
return(dal.Update(model));
}
/// <summary>
/// 修改旅游动态
/// </summary>
/// <param name="model">旅游动态实体</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Update(EyouSoft.Model.ShopStructure.HighShopNews model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_HighShopNews_UPDATE);
this._database.AddInParameter(dc, "Title", DbType.String, model.Title);
this._database.AddInParameter(dc, "ContentText", DbType.String, model.ContentText);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false);
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="NewsId">动态Id</param>
private void ShowNewsById(string NewsId)
{
EyouSoft.Model.ShopStructure.HighShopNews info = EyouSoft.BLL.ShopStructure.HighShopNews.CreateInstance().GetModel(NewsId);
if (info != null)
{
setnews_txtTitle.Value = info.Title;
editnews.Value = info.ContentText;
setnews_txtDate.Value = info.IssueTime.ToString("yyyy-MM-dd HH:mm");
}
info = null;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">旅游动态实体</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Add(EyouSoft.Model.ShopStructure.HighShopNews model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_HighShopNews_ADD);
model.ID = Guid.NewGuid().ToString();
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this._database.AddInParameter(dc, "CompanyID", DbType.AnsiStringFixedLength, model.CompanyID);
this._database.AddInParameter(dc, "OperatorID", DbType.AnsiStringFixedLength, model.OperatorID);
this._database.AddInParameter(dc, "Title", DbType.String, model.Title);
this._database.AddInParameter(dc, "ContentText", DbType.String, model.ContentText);
this._database.AddInParameter(dc, "IssueTime", DbType.DateTime, DateTime.Now);
return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false);
}
protected void Page_Load(object sender, EventArgs e)
{
CompanyId = this.Master.CompanyId;
//获取新闻
string id = Utils.InputText(Request.QueryString["newid"]);
EyouSoft.Model.ShopStructure.HighShopNews newModel = EyouSoft.BLL.ShopStructure.HighShopNews.CreateInstance().GetModel(id);
if (newModel != null)
{
//页面标题初始化
Page.Title = Utils.InputText(newModel.Title);
//新闻内容初始化
ltrTitle.Text = Utils.InputText(newModel.Title);
ltrContent.Text = Utils.InputText(newModel.ContentText);
ltrIssuetime.Text = newModel.IssueTime.ToString("yyyy-MM-dd HH:mm");
}
newModel = null;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(setnews_txtTitle.Value.Trim()) && setnews_txtTitle.Value.Trim().Length > 30)
{
MessageBox.ResponseScript(this.Page, "alert('标题不能为空并且不能大于30个字符！');");
return;
}
if (string.IsNullOrEmpty(editnews.Value))
{
MessageBox.ResponseScript(this.Page, "alert('内容不能为空！');");
return;
}
bool result = true;
//获取用户编号
EyouSoft.Model.ShopStructure.HighShopNews info = new EyouSoft.Model.ShopStructure.HighShopNews();
info.Title = Utils.InputText(setnews_txtTitle.Value);
info.ContentText = Utils.EditInputText(editnews.Value);
info.CompanyID = this.SiteUserInfo.CompanyID;
info.TypeID = 1;
info.OperatorID = this.SiteUserInfo.ID;
info.IssueTime = System.DateTime.Now;
info.ID = Guid.NewGuid().ToString();
if (hdfOpeaType.Value == "Insert")
{
result = EyouSoft.BLL.ShopStructure.HighShopNews.CreateInstance().Add(info);
}
else
{
info.ID = Request.QueryString["NewsId"];
result = EyouSoft.BLL.ShopStructure.HighShopNews.CreateInstance().Update(info);
}
info = null;
if (result)
{
MessageBox.ShowAndRedirect(this.Page, "操作成功", "SetNewsList.aspx");
}
else
{
MessageBox.Show(this.Page, "操作失败");
ShowNewsById(Request.QueryString["NewsId"]);
}
}
/// <summary>
/// 获取前台页面旅游动态列表
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <param name="CompanyID">公司编号</param>
/// <param name="KeyWord">关键字</param>
/// <returns>旅游动态列表集合</returns>
public IList <EyouSoft.Model.ShopStructure.HighShopNews> GetWebList(int pageSize, int pageIndex, ref int recordCount, string CompanyID, string KeyWord)
{
IList <EyouSoft.Model.ShopStructure.HighShopNews> list = new List <EyouSoft.Model.ShopStructure.HighShopNews>();
string tableName = "tbl_HighShopNews";
string fields = "ID,Title,IssueTime,IsTop,TopTime";
string primaryKey = "ID";
string orderByString = "IsTop desc,TopTime desc,IssueTime desc";
#region 查询条件
StringBuilder strWhere = new StringBuilder();
if (!string.IsNullOrEmpty(CompanyID))
{
strWhere.AppendFormat(" CompanyID='{0}' ", CompanyID);
}
if (!string.IsNullOrEmpty(KeyWord))
{
if (strWhere.Length > 0)
{
strWhere.AppendFormat(" and title like'%{0}%'", KeyWord);
}
else
{
strWhere.AppendFormat(" title like'%{0}%'", KeyWord);
}
}
#endregion
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (dr.Read())
{
EyouSoft.Model.ShopStructure.HighShopNews model = new EyouSoft.Model.ShopStructure.HighShopNews();
model.ID = dr.GetString(0);
model.Title = dr.GetString(1);
model.IssueTime = dr.IsDBNull(2)?DateTime.Now:dr.GetDateTime(2);
model.IsTop = dr.IsDBNull(3) ? false : dr.GetString(3) == "1" ? true : false;
model.TopTime = dr.IsDBNull(4) ? DateTime.Now : dr.GetDateTime(4);
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 获取旅游动态实体
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>存在返回实体类 不存在返回NUll</returns>
public virtual EyouSoft.Model.ShopStructure.HighShopNews GetModel(string ID)
{
EyouSoft.Model.ShopStructure.HighShopNews model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_HighShopNews_GETMODEL);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, ID);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.ShopStructure.HighShopNews();
model.ID = dr.GetString(0);
model.Title = dr.GetString(1);
model.ContentText = dr.IsDBNull(2) ? "" : dr.GetString(2);
model.IsTop = dr.IsDBNull(3) ? false : dr.GetString(3) == "1" ? true:false;
model.TopTime = dr.IsDBNull(4) ? DateTime.Now : dr.GetDateTime(4);
model.IssueTime = dr.IsDBNull(5) ? DateTime.Now : dr.GetDateTime(5);
}
}
return(model);
}
protected void rptNewsList_ItemCreated(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemIndex != -1)
{
EyouSoft.Model.ShopStructure.HighShopNews news = e.Item.DataItem as EyouSoft.Model.ShopStructure.HighShopNews;
if (news != null)
{
HtmlAnchor a = e.Item.FindControl("linkNew") as HtmlAnchor;
if (a != null)
{
a.HRef = Utils.GenerateShopPageUrl2("/new_" + news.ID, this.Master.CompanyId);
if (news.Title.Length >= 23)
{
a.InnerText = news.Title.Substring(0, 23);
}
else
{
a.InnerText = news.Title;
}
}
}
}
}
/// <summary>
/// 获取指定公司指定条数的记录
/// </summary>
/// <param name="TopNumber">需要返回的记录条数 =0返回全部 >0返回指定条数的记录</param>
/// <param name="CompanyID">公司编号</param>
/// <returns>旅游动态列表集合</returns>
public virtual IList <EyouSoft.Model.ShopStructure.HighShopNews> GetTopNumberList(int TopNumber, string CompanyID)
{
IList <EyouSoft.Model.ShopStructure.HighShopNews> list = new List <EyouSoft.Model.ShopStructure.HighShopNews>();
StringBuilder strSql = new StringBuilder();
if (TopNumber > 0)
{
strSql.AppendFormat(SQL_HighShopNews_GETTOPLIST, "Top " + TopNumber.ToString());
}
else
{
strSql.AppendFormat(SQL_HighShopNews_GETTOPLIST, string.Empty);
}
if (!string.IsNullOrEmpty(CompanyID))
{
strSql.AppendFormat(" where companyID='{0}' ", CompanyID);
}
strSql.Append(" order by IsTop desc,TopTime desc,IssueTime desc");
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.ShopStructure.HighShopNews model = new EyouSoft.Model.ShopStructure.HighShopNews();
model.ID = dr.GetString(0);
model.Title = dr.GetString(1);
model.IssueTime = dr.GetDateTime(2);
model.IsTop = dr.IsDBNull(3) ? false : dr.GetString(3) == "1" ? true : false;
model.TopTime = dr.IsDBNull(4) ? DateTime.Now : dr.GetDateTime(4);
list.Add(model);
model = null;
}
}
return(list);
}
