/// <summary>
/// 特价景区门票
/// </summary>
protected void DiscountTickets()
{
MSearchScenicTicketsSale search = new MSearchScenicTicketsSale()
{
ProvinceId = ProvinceId,
CityId = CityId,
CountyId = CountyId,
B2B = ScenicB2BDisplay.侧边推荐
};
IList <MScenicTicketsSale> list = BScenicTickets.CreateInstance().GetList(TopNum, search);
StringBuilder sb = new StringBuilder();
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
sb.Append("<div class=\"" + (i + 1 == 1 ? "show1" : "hidden1") + "\" id=\"bb" + (i + 1) + "\" onmouseover=\"pucker_show1('bb'," + (i + 1) + ",'hidden1','show1'," + list.Count + ")\"><div class=\"left\">");
sb.Append("<a href=\"/jingquinfo_" + list[i].Id + "\" title=\"" + list[i].TicketsName + "\"><img src=\"" + Utils.GetNewImgUrl(list[i].Address, 3) + "\" alt=\"" + list[i].TicketsName + "\" width=\"80\" height=\"70\" border=\"0\" style=\"border:1px solid #ccc; padding:1px;\"/></a></div>");
sb.Append("<div class=\"right_xin\">");
sb.Append("<div class=\"mingc1\"><a href=\"/jingquinfo_" + list[i].Id + "\"><strong>" + Utils.GetText2(list[i].TicketsName, 7, false) + "</strong></a></div>");
sb.Append("<div class=\"mingc\">门市价：<span class=\"hong\"><strong>" + list[i].RetailPrice.ToString("F0") + "元</strong></span></div>");
sb.Append("</div></div>");
//sb.Append("<div class=\"jiage\">门市价：<span class=\"huihua\"><strong>" + list[i].RetailPrice.ToString("F0") + "元</strong></span></div></div></div>");
}
}
this.lclTjmp.Text = sb.ToString();
}
/// <summary>
/// 获取特价门票
/// </summary>
/// <param name="topNum">指定获取数量</param>
/// <param name="search">搜索实体</param>
/// <returns></returns>
public IList <MScenicTicketsSale> GetList(int topNum, MSearchScenicTicketsSale search)
{
topNum = topNum < 1 ? 10 : topNum;
return(dal.GetList(topNum, search));
}
/// <summary>
/// 获取特价门票
/// </summary>
/// <param name="topNum">指定获取数量</param>
/// <param name="search">搜索实体</param>
/// <returns></returns>
public virtual IList <MScenicTicketsSale> GetList(int topNum, MSearchScenicTicketsSale search)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("select top({0}) a.TicketsId,a.TypeName,a.ScenicId,a.RetailPrice,a.WebsitePrices,", topNum);
sql.Append("c.ThumbAddress,c.Address,b.ScenicName,b.Id");
sql.Append(" from tbl_ScenicTickets a");
sql.AppendFormat(" left join tbl_ScenicArea b on a.ScenicId = b.ScenicId");
sql.AppendFormat(" left join tbl_ScenicImg c on a.ScenicId = c.ScenicId and c.ImgType = {0}", (int)ScenicImgType.景区形象);
sql.AppendFormat(" where a.Status = {0} and a.ExamineStatus = {1} and b.Status = {2}", (int)ScenicTicketsStatus.架, (int)ExamineStatus.已审核, (int)ExamineStatus.已审核);
if (search != null)
{
if (search.ProvinceId != null)
{
sql.AppendFormat(" and b.ProvinceId = {0}", search.ProvinceId);
}
if (search.CityId != null)
{
sql.AppendFormat(" and b.CityId = {0}", search.CityId);
}
if (search.CountyId != null)
{
sql.AppendFormat(" and b.CountyId = {0}", search.CountyId);
}
if (search.B2B != null)
{
sql.AppendFormat(" and a.B2B = {0}", (int)search.B2B);
sql.Append(" Order by a.B2BOrder,a.LastUpdateTime DESC");
}
else if (search.B2C != null)
{
sql.AppendFormat(" and a.B2C = {0}", (int)search.B2C);
sql.Append(" Order by a.B2COrder,a.LastUpdateTime DESC");
}
else
{
sql.Append(" Order by a.CustomOrder ASC,a.LastUpdateTime DESC");
}
}
DbCommand comm = this._db.GetSqlStringCommand(sql.ToString());
IList <MScenicTicketsSale> list = new List <MScenicTicketsSale>();
MScenicTicketsSale item = null;
using (IDataReader reader = DbHelper.ExecuteReader(comm, this._db))
{
while (reader.Read())
{
list.Add(item = new MScenicTicketsSale()
{
Id = long.Parse(reader["Id"].ToString()),
ScenicId = reader["ScenicId"].ToString(),
ScenicName = reader["ScenicName"].ToString(),
RetailPrice = reader.IsDBNull(reader.GetOrdinal("RetailPrice")) ? 0 : (decimal)reader["RetailPrice"],
WebsitePrices = reader.IsDBNull(reader.GetOrdinal("WebsitePrices")) ? 0 : (decimal)reader["WebsitePrices"],
ThumbAddress = reader.IsDBNull(reader.GetOrdinal("ThumbAddress")) ? string.Empty : reader["ThumbAddress"].ToString(),
Address = reader.IsDBNull(reader.GetOrdinal("Address")) ? string.Empty : reader["Address"].ToString(),
TicketsId = reader.IsDBNull(reader.GetOrdinal("TicketsId")) ? string.Empty : reader["TicketsId"].ToString(),
TicketsName = reader.IsDBNull(reader.GetOrdinal("TypeName")) ? string.Empty : reader["TypeName"].ToString()
});
}
}
return(list);
}
