/// <summary>
/// 绑定搜索结果
/// </summary>
/// <returns></returns>
public string BindSearchLine()
{
StringBuilder sbLine = new StringBuilder();
string strwhere = "";
string strOrderBy = "Sort asc,adddate desc";
if (td > 0)
{
//Access
//strwhere = "InStr(dest,'," + td + ",')>0 and isLock=0";
//SQL
strwhere = "CHARINDEX('," + td + ",',dest)>0 and isLock=0";
}
if (sort == "gzd")
{
strOrderBy = "gzd desc";
}
else if (sort == "price")
{
strOrderBy = "priceCommon asc";
}
if (strwhere != "")
{
DataSet dsLine = LineBll.GetList(0, strwhere, strOrderBy);
foreach (DataRow row in dsLine.Tables[0].Rows)
{
sbLine.Append("<div class=\"show_line_box\">");
sbLine.Append("<a href=\"LineDetail.aspx?id=" + row["Id"] + "\" class=\"show_line_con\">");
sbLine.Append("<img src=\"" + row["linePic"] + "\" />");
if (row["priceCommon"].ToString().Equals("0") || row["priceCommon"].ToString().Equals(""))
{
sbLine.Append("<span class=\"show_line_jia\">电询</span>");
}
else
{
sbLine.Append("<span class=\"show_line_jia\">¥ " + row["priceCommon"] + "</span>");
}
string name = "";
Model.DepartureCity city = CityBll.GetModel(Convert.ToInt32(row["cityId"]));
if (city != null)
{
name = city.CityName;
}
sbLine.Append("</a>");
sbLine.Append("<a href=\"LineDetail.aspx?id=" + row["Id"] + "\" class=\"show_line_tit\">");
sbLine.Append("<strong>" + row["lineName"] + "</strong>");
sbLine.Append("<p>");
sbLine.Append("<span>" + name + "出发</span>|");
sbLine.Append("<span>" + row["dayNumber"] + "日游</span>|");
sbLine.Append("<span>关注：" + row["gzd"] + "</span>");
sbLine.Append("</p>");
sbLine.Append("</a>");
sbLine.Append("</div>");
}
}
return(sbLine.ToString());
}
/// <summary>
/// 绑定线路产品
/// </summary>
/// <param name="state"></param>
/// <param name="top"></param>
/// <returns></returns>
public string BindLine(int top)
{
StringBuilder sbLine = new StringBuilder();
string strwhere = "isLock=0";
int state = Convert.ToInt32(TravelAgent.Tool.EnumSummary.State.推荐);
if (d == 0)
{
state = Convert.ToInt32(TravelAgent.Tool.EnumSummary.State.特价);
strwhere += " and CHARINDEX('," + state + ",',State)>0";
}
else
{
strwhere += " and CHARINDEX('," + state + ",',State)>0 and destId=" + d;
}
DataSet dsLine = LineBll.GetList(top, strwhere, "Sort asc,adddate desc");
foreach (DataRow row in dsLine.Tables[0].Rows)
{
sbLine.Append("<div class=\"show_line_box\">");
sbLine.Append("<a href=\"LineDetail.aspx?id=" + row["Id"] + "\" class=\"show_line_con\">");
sbLine.Append("<img src=\"" + row["linePic"] + "\" />");
int intNormalPrice = String.IsNullOrEmpty(row["priceContent"].ToString()) ? 0 : Convert.ToInt32(row["priceContent"].ToString().Split(',')[2]);
//获得市场价
int marketPrice = LineBll.GetModel(Convert.ToInt32(row["Id"])).GetShopPrice();
//获得同行价
int intMinPrice = GetLineSpePrice(Convert.ToInt32(row["Id"]), intNormalPrice);
if (row["priceCommon"].ToString().Equals("0") || row["priceCommon"].ToString().Equals(""))
{
sbLine.Append("<span class=\"show_line_jia\">电询</span>");
}
else
{
sbLine.Append("<span class=\"show_line_jia\">¥市场价 " + intMinPrice + "  " + "¥同行价 " + marketPrice + "</span>");
//sbLine.Append("<span class=\"show_line_jia\">¥同行价 " + marketPrice + "</span>");
}
string name = "";
Model.DepartureCity city = CityBll.GetModel(Convert.ToInt32(row["cityId"]));
if (city != null)
{
name = city.CityName;
}
sbLine.Append("</a>");
sbLine.Append("<a href=\"LineDetail.aspx?id=" + row["Id"] + "\" class=\"show_line_tit\">");
sbLine.Append("<strong>" + row["lineName"] + "</strong>");
sbLine.Append("<p>");
sbLine.Append("<span>" + name + "出发</span>|");
sbLine.Append("<span>" + row["dayNumber"] + "日游</span>|");
sbLine.Append("<span>关注：" + row["gzd"] + "</span>");
sbLine.Append("</p>");
sbLine.Append("</a>");
sbLine.Append("</div>");
}
return(sbLine.ToString());
}
/// <summary>
/// 显示出发城市
/// </summary>
/// <param name="cityid"></param>
/// <returns></returns>
public string ShowCityName()
{
Model.DepartureCity city = CityBll.GetModel(Line.CityId);
if (city == null)
{
return("");
}
return(city.CityName);
}
/// <summary>
/// 绑定线路产品
/// </summary>
/// <param name="state"></param>
/// <param name="top"></param>
/// <returns></returns>
public string BindLine(int top)
{
StringBuilder sbLine = new StringBuilder();
if (thid > 0)
{
string strwhere = "isLock=0 and CHARINDEX('," + thid + ",',themeIds)>0";
DataSet dsLine = LineBll.GetList(top, strwhere, "Sort asc,adddate desc");
foreach (DataRow row in dsLine.Tables[0].Rows)
{
sbLine.Append("<div class=\"show_line_box\">");
sbLine.Append("<a href=\"LineDetail.aspx?id=" + row["Id"] + "\" class=\"show_line_con\">");
sbLine.Append("<img src=\"" + row["linePic"] + "\" />");
if (row["priceCommon"].ToString().Equals("0") || row["priceCommon"].ToString().Equals(""))
{
sbLine.Append("<span class=\"show_line_jia\">电询</span>");
}
else
{
sbLine.Append("<span class=\"show_line_jia\">¥ " + row["priceCommon"] + "</span>");
}
string name = "";
Model.DepartureCity city = CityBll.GetModel(Convert.ToInt32(row["cityId"]));
if (city != null)
{
name = city.CityName;
}
sbLine.Append("</a>");
sbLine.Append("<a href=\"LineDetail.aspx?id=" + row["Id"] + "\" class=\"show_line_tit\">");
sbLine.Append("<strong>" + row["lineName"] + "</strong>");
sbLine.Append("<p>");
sbLine.Append("<span>" + name + "出发</span>|");
sbLine.Append("<span>" + row["dayNumber"] + "日游</span>|");
sbLine.Append("<span>关注：" + row["gzd"] + "</span>");
sbLine.Append("</p>");
sbLine.Append("</a>");
sbLine.Append("</div>");
}
}
return(sbLine.ToString());
}
