/// <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()); }