protected void rptziyuans_ItemCreated(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemIndex != -1)
{
EyouSoft.Model.ShopStructure.HighShopResource res = e.Item.DataItem as EyouSoft.Model.ShopStructure.HighShopResource;
if (res != null)
{
string linkUrl = Utils.GenerateShopPageUrl2(string.Format("/ZiYuanShow_{0}", res.ID), this.Master.CompanyId);
HtmlAnchor a = e.Item.FindControl("linkZiYuanShow1") as HtmlAnchor;
if (a != null)
{
a.HRef = linkUrl;
a.Title = res.Title;
a.InnerHtml = string.Format("<img src=\"{0}\" border=\"0\" height=\"82\" width=\"123\">", Utils.GetLineShopImgPath(res.ImagePath, 4));
}
HtmlAnchor b = e.Item.FindControl("linkZiYuanShow2") as HtmlAnchor;
if (b != null)
{
b.HRef = linkUrl;
b.Title = res.Title;
if (res.Title.Length >= 10)
{
b.InnerText = res.Title.Substring(0, 10);
}
else
{
b.InnerText = res.Title;
}
}
}
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">旅游资源推荐实体</param>
/// <returns>false:失败 true:成功</returns>
public bool Update(EyouSoft.Model.ShopStructure.HighShopResource 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.HighShopResource model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_DELETEDFILE_UPDATEMOVE + SQL_HighShopResource_UPDATE);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this._database.AddInParameter(dc, "Title", DbType.String, model.Title);
this._database.AddInParameter(dc, "ContentText", DbType.String, model.ContentText);
this._database.AddInParameter(dc, "ImagePath", DbType.String, model.ImagePath);
return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(setreso_txttitle.Value.Trim()) && setreso_txttitle.Value.Trim().Length > 30)
{
MessageBox.ResponseScript(this.Page, "alert('标题不能为空并且不能大于30个字符！');");
return;
}
if (string.IsNullOrEmpty(editreso.Value.Trim()))
{
MessageBox.ResponseScript(this.Page, "alert('内容不能为空！');");
return;
}
EyouSoft.Model.ShopStructure.HighShopResource reso = new EyouSoft.Model.ShopStructure.HighShopResource();
reso.Title = StringValidate.SafeRequest(setreso_txttitle.Value);
reso.ContentText = Utils.EditInputText(editreso.Value);
reso.OperatorID = this.SiteUserInfo.ID;
reso.CompanyID = this.SiteUserInfo.CompanyID;
string imgpath = Utils.GetFormValue("sfuResoImg$hidFileName");
if (imgpath.Length > 0)
{
reso.ImagePath = imgpath;
}
else
{
reso.ImagePath = Utils.GetFormValue(hdfAgoImgPath.UniqueID);
}
bool result = false;
if (!string.IsNullOrEmpty(Request.QueryString["Reso_Id"]))
{
reso.ID = Request.QueryString["Reso_Id"];
result = EyouSoft.BLL.ShopStructure.HighShopResource.CreateInstance().Update(reso);
}
else
{
reso.IssueTime = DateTime.Now;
result = EyouSoft.BLL.ShopStructure.HighShopResource.CreateInstance().Add(reso);
}
if (result)
{
MessageBox.ShowAndRedirect(this.Page, "操作成功", "SetResourcesList.aspx");
}
else
{
MessageBox.ShowAndRedirect(this.Page, "操作失败", Request.Url.ToString());
}
reso = null;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">旅游资源推荐实体</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Add(EyouSoft.Model.ShopStructure.HighShopResource model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_HighShopResource_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, "TypeID", DbType.Byte, 4);
this._database.AddInParameter(dc, "Title", DbType.String, model.Title);
this._database.AddInParameter(dc, "ContentText", DbType.String, model.ContentText);
this._database.AddInParameter(dc, "ImagePath", DbType.String, model.ImagePath);
return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false);
}
/// <summary>
/// 修改，加载数据
/// </summary>
/// <param name="companyId">id</param>
private void InitResoInfo(string resoId)
{
EyouSoft.Model.ShopStructure.HighShopResource reso = EyouSoft.BLL.ShopStructure.HighShopResource.CreateInstance().GetModel(Request.QueryString["Reso_Id"]);
if (reso != null)
{
setreso_txttitle.Value = reso.Title;
editreso.Value = reso.ContentText;
setreso_txtDate.Value = reso.IssueTime.ToString("yyyy-MM-dd HH:mm");
if (!string.IsNullOrEmpty(reso.ImagePath))
{
img_Path = string.Format("<a href=\"{0}\"target='_blank' title=\"点击查看\">查看原图</a>", Domain.FileSystem + reso.ImagePath);
hdfAgoImgPath.Value = reso.ImagePath;
}
}
reso = null;
}
protected void Page_Load(object sender, EventArgs e)
{
//获取旅游资源
string id = Utils.InputText(Request.QueryString["ziyuanid"]);
//string cid = Utils.InputText(Request.QueryString["cid"]);
if (!string.IsNullOrEmpty(id))
{
EyouSoft.Model.ShopStructure.HighShopResource reso = EyouSoft.BLL.ShopStructure.HighShopResource.CreateInstance().GetModel(id);
if (reso != null)
{
//旅游资源内容初始化
ltrTitle.Text = Utils.InputText(reso.Title);
//zxb update 20110413
ltrContent.Text = reso.ContentText; //Utils.InputText( reso.ContentText);
ltrIssuetime.Text = reso.IssueTime.ToString("yyyy-MM-dd HH:mm");
//页面标题初始化
Page.Title = ltrTitle.Text + "_旅游资源推荐";
}
reso = null;
}
}
/// <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 virtual IList <EyouSoft.Model.ShopStructure.HighShopResource> GetList(int pageSize, int pageIndex, ref int recordCount, string CompanyID, string KeyWord)
{
IList <EyouSoft.Model.ShopStructure.HighShopResource> list = new List <EyouSoft.Model.ShopStructure.HighShopResource>();
string tableName = "tbl_HighShopTripGuide";
string fields = "ID,Title,ImagePath,IsTop,TopTime,UpdateTime";
string primaryKey = "ID";
string orderByString = "IsTop desc,TopTime desc,UpdateTime desc";
#region 查询条件
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" TypeId=4 ");
if (!string.IsNullOrEmpty(CompanyID))
{
strWhere.AppendFormat(" AND CompanyID='{0}' ", CompanyID);
}
if (!string.IsNullOrEmpty(KeyWord))
{
strWhere.AppendFormat(" AND 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.HighShopResource model = new EyouSoft.Model.ShopStructure.HighShopResource();
model.ID = dr.GetString(0);
model.Title = dr.IsDBNull(1) ? "" : dr.GetString(1);
model.ImagePath = 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);
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 获取首页旅游资源推荐列表
/// </summary>
/// <param name="topNumber">需要返回的总记录数 =0返回全部 >0返回指定条数的记录</param>
/// <param name="CompanyID">公司编号</param>
/// <returns>旅游资源推荐列表集合</returns>
public virtual IList <EyouSoft.Model.ShopStructure.HighShopResource> GetIndexList(int topNumber, string CompanyID)
{
IList <EyouSoft.Model.ShopStructure.HighShopResource> list = new List <EyouSoft.Model.ShopStructure.HighShopResource>();
StringBuilder strSql = new StringBuilder();
if (topNumber > 0)
{
strSql.AppendFormat(SQL_HighShopResource_GETTOPLIST, "Top " + topNumber.ToString());
}
else
{
strSql.AppendFormat(SQL_HighShopResource_GETTOPLIST, string.Empty);
}
if (!string.IsNullOrEmpty(CompanyID))
{
strSql.AppendFormat(" where companyID='{0}' AND TypeId=4 ", CompanyID);
}
strSql.Append(" order by IsTop desc,TopTime desc,UpdateTime desc");
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.ShopStructure.HighShopResource model = new EyouSoft.Model.ShopStructure.HighShopResource();
model.ID = dr.GetString(0);
model.Title = dr.IsDBNull(1) ? "": dr.GetString(1);
model.ImagePath = 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);
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 获取旅游资源推荐实体
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public virtual EyouSoft.Model.ShopStructure.HighShopResource GetModel(string ID)
{
EyouSoft.Model.ShopStructure.HighShopResource model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_HighShopResource_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.HighShopResource();
model.ID = dr.GetString(0);
model.CompanyID = dr.GetString(1);
model.OperatorID = dr.GetString(2);
model.Title = dr.GetString(3);
model.ContentText = dr.IsDBNull(4) ? "" : dr.GetString(4);
model.ImagePath = dr.IsDBNull(5) ? "": dr.GetString(5);
model.IssueTime = dr.IsDBNull(6) ? DateTime.Now : dr.GetDateTime(6);
model.IsTop = dr.IsDBNull(7) ? false : dr.GetString(7) == "1" ? true : false;
model.TopTime = dr.IsDBNull(8) ? DateTime.MinValue : dr.GetDateTime(8);
}
}
return(model);
}
