/// <summary>
/// 显示行程
/// </summary>
/// <returns></returns>
public string ShowLine()
{
StringBuilder sb = new StringBuilder();
if (LineModel.EditModel == 0)
{
List <TravelAgent.Model.LineContent> lstLineContent = LineContentBll.GetlstLineContentByLineId(LineModel.Id);
TravelAgent.Model.LineContent content = null;
for (int i = 0; i < lstLineContent.Count; i++)
{
content = lstLineContent[i];
sb.Append("<div class=\"day\">");
sb.Append(" <div class=\"title\"><h5>第<span>" + content.DaySort + "</span>天</h5>" + content.Title + "</div>");
sb.Append("<div class=\"nr\">");
sb.Append(content.Content);
sb.Append("</div>");
sb.Append("<div class=\"eat\">");
sb.Append("<s></s>用餐：<span>早餐（" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Morn) + "）</span>，<span>中餐（" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Noon) + "）</span>，<span>晚餐（" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Night) + "）</span>");
sb.Append("</div>");
sb.Append("<div class=\"house\">");
sb.Append("<s></s>住宿：" + content.Accom);
sb.Append("</div>");
sb.Append("</div>");
}
}
else
{
sb.Append(LineModel.LineContent);
}
return(sb.ToString());
}
/// <summary>
/// 根据编号获得集合
/// </summary>
/// <param name="lineid"></param>
/// <returns></returns>
public List <TravelAgent.Model.LineContent> GetlstLineContentByLineId(int lineid)
{
string strsql = "select * from LineContent where lineId=" + lineid + " order by daySort asc";
List <TravelAgent.Model.LineContent> lstLineContent = new List <TravelAgent.Model.LineContent>();
using (SqlDataReader odr = DbHelperSQL.ExecuteReader(strsql))
{
TravelAgent.Model.LineContent content = null;
while (odr.Read())
{
content = new TravelAgent.Model.LineContent();
content.Id = odr.GetInt32(0);
content.Title = odr.GetString(1);
content.Morn = odr.GetInt32(2);
content.Noon = odr.GetInt32(3);
content.Night = odr.GetInt32(4);
content.Accom = odr.GetString(5);
content.Content = odr.GetString(6);
content.DaySort = odr.GetInt32(7);
content.LineId = odr.GetInt32(8);
lstLineContent.Add(content);
}
}
return(lstLineContent);
}
/// <summary>
/// 绑定行程
/// </summary>
/// <returns></returns>
public string BindLineXC()
{
StringBuilder sb = new StringBuilder();
List <TravelAgent.Model.LineContent> lstLineContent = LineContentBll.GetlstLineContentByLineId(Line.Id);
TravelAgent.Model.LineContent content = null;
for (int i = 0; i < lstLineContent.Count; i++)
{
content = lstLineContent[i];
sb.Append("<div class=\"threeBox_trip\">");
sb.Append("<div class='days'>");
sb.Append("<strong>第 " + content.DaySort + " 天</strong>");
sb.Append("<span>" + TravelAgent.Tool.CommonOprate.ShowLineTitle(content.Title) + "</span>");
sb.Append("</div>");
sb.Append("<div class=\"chis\">");
sb.Append("<span>用餐：</span>");
sb.Append("早-" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Morn) + "； 中-" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Noon) + "； 晚-" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Night) + "");
sb.Append("</div>");
sb.Append("<div class=\"zhus\">");
sb.Append("<span>住宿：</span>");
sb.Append(content.Accom);
sb.Append("</div>");
sb.Append("<div class='cons'>");
sb.Append(content.Content);
sb.Append("</div>");
sb.Append("</div>");
}
return(sb.ToString());
}
/// <summary>
/// 显示行程详细内容
/// </summary>
/// <param name="lineId"></param>
/// <returns></returns>
public string ShowLine(TravelAgent.Model.Line line)
{
StringBuilder sb = new StringBuilder();
if (line.EditModel == 0)
{
List <TravelAgent.Model.LineContent> lstLineContent = LineContentBll.GetlstLineContentByLineId(line.Id);
TravelAgent.Model.LineContent content = null;
for (int i = 0; i < lstLineContent.Count; i++)
{
content = lstLineContent[i];
sb.Append("<div class=\"titcon\">");
sb.Append("<div class=\"titkey\">第<em>" + content.DaySort + "</em>天</div>");
sb.Append("<div class=\"titpic\">" + TravelAgent.Tool.CommonOprate.ShowLineTitle(content.Title) + "</div>");
sb.Append("</div>");
sb.Append("<div class=\"chizhu\">");
sb.Append("<p><span class=\"chi\" title=\"用餐\"></span><em><font class=\"hco\">早餐</font>-" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Morn) + " ， <font class=\"hco\">中餐</font>-" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Noon) + " ， <font class=\"hco\">晚餐</font>-" + TravelAgent.Tool.CommonOprate.ShowCatering(content.Night) + "</em></p>");
sb.Append("<p><span class=\"zhu\" title=\"住宿\"></span><em><font class=\"hco\">住宿：</font>" + content.Accom + "</em></p>");
sb.Append("</div>");
sb.Append("<div class=\"text\">");
sb.Append("<div class=\"text_tp\">");
sb.Append(content.Content);
sb.Append("</div>");
sb.Append("</div>");
}
}
else
{
sb.Append(line.LineContent);
}
return(sb.ToString());
}
/// <summary>
/// 获得餐饮的选中状态
/// </summary>
/// <returns></returns>
public string GetCheckedCatering(string tag, TravelAgent.Model.LineContent content)
{
string check = "";
if (content != null)
{
if (tag == "morn")
{
if (content.Morn == 1)
{
check = "checked=\"checked\"";
}
}
else if (tag == "noon")
{
if (content.Noon == 1)
{
check = "checked=\"checked\"";
}
}
else if (tag == "night")
{
if (content.Night == 1)
{
check = "checked=\"checked\"";
}
}
}
return(check);
}
/// <summary>
/// 显示行程详细内容
/// </summary>
/// <param name="lineId"></param>
/// <returns></returns>
public string ShowLine(int lineId)
{
StringBuilder sb = new StringBuilder();
List <TravelAgent.Model.LineContent> lstLineContent = LineContentBll.GetlstLineContentByLineId(lineId);
TravelAgent.Model.LineContent content = null;
for (int i = 0; i < lstLineContent.Count; i++)
{
content = lstLineContent[i];
sb.Append("<p><em>第" + content.DaySort + "天</em>" + TravelAgent.Tool.CommonOprate.ShowLineTitle(content.Title) + "</p>");
}
return(sb.ToString());
}
/// <summary>
/// 获得第几天的内容
/// </summary>
/// <param name="daySort"></param>
/// <param name="linecontent"></param>
/// <returns></returns>
private TravelAgent.Model.LineContent GetLineContent(int daySort, List <TravelAgent.Model.LineContent> linecontent)
{
TravelAgent.Model.LineContent content = null;
foreach (TravelAgent.Model.LineContent con in linecontent)
{
if (daySort == con.DaySort)
{
content = con;
break;
}
}
return(content);
}
/// <summary>
/// 绑定线路路列表
/// </summary>
/// <param name="dsLine"></param>
/// <returns></returns>
public string BindlistLine()
{
StringBuilder sbLine = new StringBuilder();
//获得总条数
string strWhere = getWhere();
this.pcount = LineBll.GetCount(strWhere);
if (this.pcount > 0)
{
DataSet ds = LineBll.GetPageList(this.pagesize, this.page, strWhere, getOrder());
DataRow row = null;
List <TravelAgent.Model.LineContent> lstLineContent = null;
TravelAgent.Model.LineContent content = null;
int selectCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < selectCount; i++)
{
row = ds.Tables[0].Rows[i];
sbLine.Append("<div class=\"linebox\">");
//sbLine.Append("<div class=\"linepic\"><a href=\"/Line.aspx?id=" + row["Id"] + "\" target=\"_blank\"><img src=\"" + row["linePic"] + "\" alt=\"" + row["lineName"] + "\" /></a></div>");
//urlrewrite
sbLine.Append("<div class=\"linepic\"><a href=\"/line/" + row["Id"] + ".html\" target=\"_blank\"><img src=\"" + row["linePic"] + "\" alt=\"" + row["lineName"] + "\" /></a></div>");
sbLine.Append("<div class=\"linecon\">");
//sbLine.Append("<div class=\"line_tit\"><a href=\"/Line.aspx?id=" + row["Id"] + "\" target=\"_blank\">" + row["lineName"] + "</a></div>");
//urlrewrite
sbLine.Append("<div class=\"line_tit\"><a href=\"/line/" + row["Id"] + ".html\" target=\"_blank\">" + row["lineName"] + "</a>" + TravelAgent.Tool.CommonOprate.ShowLineState(row["State"].ToString()) + "</div>");
sbLine.Append("<div class=\"line_txt\"><span>行程天数：" + row["dayNumber"] + "天</span><span>线路类型：" + getJoinPropery(Convert.ToInt32(row["proIds"])) + "</span><span>往返交通：" + row["trafficIds"].ToString().Trim(',') + "</span><span>人 气：" + row["gzd"] + "人关注</span></div>");
sbLine.Append("<div class=\"lc-day-detail\"><div class=\"doc-line-list2\">");
lstLineContent = LineContentBll.GetlstLineContentByLineId(Convert.ToInt32(row["Id"]));
for (int j = 0; j < lstLineContent.Count; j++)
{
content = lstLineContent[j];
sbLine.Append("<dl>");
sbLine.Append("<dt class=\"doc-day-num\">D" + content.DaySort + "</dt>");
sbLine.Append("<dd class=\"doc-mdd-list\">" + content.Title + "</dd>");
sbLine.Append("</dl>");
}
sbLine.Append("</div>");
sbLine.Append("<div class=\"doc-more\"><a href=\"javascript:void(0)\"><em>行程</em><span class=\"icon-hide\"></span></a></div>");
//sbLine.Append("<div class=\"doc-price\"><a class=\"zk\" data-id=\"" + row["Id"] + "\" data-url=\"/Line.aspx?id=" + row["Id"] + "\" href=\"javascript:;\"><em>团期</em><span></span></a></div>");
//sbLine.Append("<div class=\"doc-deital\"><a href=\"/Line.aspx?id=" + row["Id"] + "\"><em>详情</em><span></span></a></div>");
//urlrewrite
sbLine.Append("<div class=\"doc-price\"><a class=\"zk\" data-id=\"" + row["Id"] + "\" data-url=\"/line/" + row["Id"] + ".html\" href=\"javascript:;\"><em>团期</em><span></span></a></div>");
sbLine.Append("<div class=\"doc-deital\"><a href=\"/line/" + row["Id"] + ".html\"><em>详情</em><span></span></a></div>");
sbLine.Append("</div></div>");
if (row["priceCommon"].ToString().Equals("") || row["priceCommon"].ToString().Equals("0"))
{
sbLine.Append("<div class=\"pre prebg" + (i + 1) + "\">电询</div>");
}
else
{
sbLine.Append("<div class=\"pre prebg" + (i + 1) + "\">¥ " + row["priceCommon"] + "</div>");
}
sbLine.Append("<div id=\"case_calendar_" + row["Id"] + "\" class=\"case_calendar\">");
sbLine.Append("<div class=\"case_calendar_left\"></div>");
sbLine.Append("<div class=\"case_calendar_right\"></div>");
sbLine.Append("</div>");
sbLine.Append("<div class=\"clear\"></div>");
sbLine.Append("</div>");
}
//分页
if (this.pcount > this.pagesize)
{
int totalPagecount;
if (this.pcount % this.pagesize != 0)
{
totalPagecount = this.pcount / this.pagesize + 1;
}
else
{
totalPagecount = this.pcount / this.pagesize;
}
sbLine.Append("<div class=\"pages\">");
if (this.page > 0)
{
sbLine.Append("<a href='/search/" + keyword + "/" + cityId + "/" + proId + "/" + day + "/" + isTuijian + "/" + isTejia + "/" + isRemai + "/" + price_up + "/" + price_down + "/" + renqi + "/" + price + "/" + (page - 1) + ".html'>上一页</a>");
}
for (int i = 0; i < totalPagecount; i++)
{
if (i == this.page)
{
sbLine.Append(" <span class='current'>" + (i + 1) + "</span>");
}
else
{
sbLine.Append(" <a href='/search/" + keyword + "/" + cityId + "/" + proId + "/" + day + "/" + isTuijian + "/" + isTejia + "/" + isRemai + "/" + price_up + "/" + price_down + "/" + renqi + "/" + price + "/" + i + ".html'>" + (i + 1) + "</a>");
}
}
if (this.page < totalPagecount - 1)
{
sbLine.Append("<a href='/search/" + keyword + "/" + cityId + "/" + proId + "/" + day + "/" + isTuijian + "/" + isTejia + "/" + isRemai + "/" + price_up + "/" + price_down + "/" + renqi + "/" + price + "/" + (page + 1) + ".html'>下一页</a>");
}
sbLine.Append("</div>");
}
}
else
{
string strv = this.keyword.Equals("no")?"":this.keyword;
sbLine.Append("<div class=\"noContent\">");
sbLine.Append("<div class=\"content\">");
sbLine.Append("很抱歉，无法匹配“<span style=\"color:red\">" + strv + "</span>”相关的旅游产品，请重新输入关键词或点击右边特价产品。");
sbLine.Append("<p>您可以更换搜索条件或改订其他线路 <a href=\"/Search.aspx\">清除筛选条件</a></p>");
sbLine.Append("</div>");
sbLine.Append("</div>");
}
return(sbLine.ToString());
}
/// <summary>
/// 加载行程内容
/// </summary>
/// <param name="dayNumber"></param>
/// <returns></returns>
private void LoadLineContent(int dayNumber, List <TravelAgent.Model.LineContent> linecontent)
{
StringBuilder sb = new StringBuilder();
TravelAgent.Model.LineContent content = null;
sb.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%\" class=\"formtable\">");
for (int i = 1; i <= dayNumber; i++)
{
content = GetLineContent(i, linecontent);
sb.Append("<tr>");
sb.Append("<td style=\"width:6%; text-align:center\">第 <span style=\"font-weight:bold;font-size:16px\">" + i + "</span> 天</td>");
sb.Append("<td>");
sb.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%;\">");
sb.Append("<tr>");
sb.Append("<td style=\" width:55px; text-align:right\">标题：</td>");
sb.Append("<td>");
sb.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
sb.Append("<tr>");
string strtitle = content == null ? "" : content.Title;
sb.Append("<td style=\"border:0\"><input id=\"txt_BT_D" + i + "\" name=\"txt_BT_D" + i + "\" type=\"text\" class=\"dfinput w200\" value=\"" + strtitle + "\" /></td>");
sb.Append("<td style=\"border:0\">");
sb.Append("<a href=\"javascript:;\" onclick=\"addtraffic('" + i + "','[飞机]');\"><img src=\"/images/air.gif\" alt=\"飞机\" title=\"飞机\"></a> ");
sb.Append("<a href=\"javascript:;\" onclick=\"addtraffic('" + i + "','[船]');\"><img src=\"/images/ship.gif\" alt=\"船\" title=\"船\"></a>");
sb.Append("<a href=\"javascript:;\" onclick=\"addtraffic('" + i + "','[火车]');\"><img src=\"/images/train.gif\" alt=\"火车\" title=\"火车\"></a>");
sb.Append("<a href=\"javascript:;\" onclick=\"addtraffic('" + i + "','[汽车]');\"><img src=\"/images/vehicle.gif\" alt=\"汽车\" title=\"汽车\"></a>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</table>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td style=\"text-align:right\">用餐：</td>");
sb.Append("<td>");
sb.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
sb.Append("<tr>");
sb.Append("<td style=\"border:0\">早</td>");
sb.Append("<td style=\"border:0\">");
sb.Append("<input id=\"chk_morn_D" + i + "\" name=\"chk_morn_D" + i + "\" type=\"checkbox\" " + GetCheckedCatering("morn", content) + " />");
sb.Append("</td>");
sb.Append("<td style=\"border:0\">中</td>");
sb.Append("<td style=\"border:0\">");
sb.Append("<input id=\"chk_noon_D" + i + "\" name=\"chk_noon_D" + i + "\" type=\"checkbox\" " + GetCheckedCatering("noon", content) + " />");
sb.Append("</td>");
sb.Append("<td style=\"border:0\">晚</td>");
sb.Append("<td style=\"border:0\">");
sb.Append("<input id=\"chk_night_D" + i + "\" name=\"chk_night_D" + i + "\" type=\"checkbox\" " + GetCheckedCatering("night", content) + " />");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</table>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td style=\"text-align:right\">住宿：</td>");
string straccom = content == null ? "" : content.Accom;
sb.Append("<td style=\"padding-left:10px;\"><input id=\"txt_ZS_D" + i + "\" name=\"txt_ZS_D" + i + "\" type=\"text\" class=\"dfinput w150\" value=\"" + straccom + "\" /></td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td style=\"text-align:right\">内容：</td>");
string strcontent = content == null ? "" : content.Content;
sb.Append("<td style=\"padding-right:5px;\"><textarea id=\"txt_Content_D" + i + "\" name=\"txt_Content_D" + i + "\" cols=\"100\" rows=\"4\" style=\"width:100%; height:180px;\">" + strcontent + "</textarea></td>");
sb.Append(" </tr>");
sb.Append("</table>");
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("</table>");
divContent.InnerHtml = sb.ToString();
}
