private void GetArgument() { sKey = Request.QueryString["sk"]; if (sKey == null) { sKey = ""; } if (sKey.Trim() == "") { Response.StatusCode = 404; Response.End(); } sKey = sKey.Trim(); List <ClassLibrary.Model.RouteClass> tmpList = routeClassBLL.GetModelList("CHARINDEX('" + sKey + "', ClassName)>0 or CHARINDEX(ClassName,'" + sKey + "')>0", "ClassLevel Desc, Recommend Desc"); if (tmpList.Count > 0) { ClassLibrary.Model.RouteClass tm = tmpList[0]; if (tm.ParentID != (int)SysConfig.RouteClass.国内旅游) { Response.Redirect(SysConfig.webSite + "/" + tm.ClassNamePY + "/"); } } List <ClassLibrary.Model.RouteType> tmpList2 = rtBll.GetModelList("CHARINDEX('" + sKey + "', ClassName)>0 or CHARINDEX(ClassName,'" + sKey + "')>0"); if (tmpList2.Count > 0) { ClassLibrary.Model.RouteType tm = tmpList2[0]; Response.Redirect(SysConfig.webSite + "/" + tm.classNamePY + "/"); } glClass = routeClassBLL.GetModelList(String.Empty, "ClassLevel Desc, Recommend Desc, CreatedTime Desc"); grtClass = rtBll.GetModelList(string.Empty, "Recommend Desc,ClassOrder Asc,CreatedTime Desc"); }
public void BindRouteSubClass() { string[] classid = routeParentClassIds.Split(','); StringBuilder sb = new StringBuilder(); foreach (string text in classid) { if (text != "") { ClassLibrary.Model.RouteClass model = routeClassBLL.GetModel(Convert.ToInt32(text)); if (model.ClassLevel == 3 || model.ParentID == (int)ClassLibrary.Common.SysConfig.RouteClass.峡旅游) { DataTable myTable = routeClassBLL.GetData("parentID=" + text); foreach (DataRow dr in myTable.Rows) { if (("," + routeParentClassIds + ",").Contains("," + dr["ID"].ToString() + ",")) { sb.AppendFormat("<input name='ScenicCheckBox' onclick='LocationChange(this)' type='checkbox' value='{0}' checked />{1} ", dr["ID"].ToString(), dr["ClassName"].ToString()); } else { sb.AppendFormat("<input name='ScenicCheckBox' onclick='LocationChange(this)' type='checkbox' value='{0}' />{1} ", dr["ID"].ToString(), dr["ClassName"].ToString()); } } } } } routeSubClassList = sb.ToString(); }
private void GetArgument() { sKey = Request.QueryString["sk"]; if (sKey == null) { sKey = ""; } if (sKey == "") { Response.StatusCode = 404; Response.End(); } urlKey = HttpUtility.UrlEncode(sKey, Encoding.UTF8); List <ClassLibrary.Model.RouteClass> tmpList = routeClassBLL.GetModelList("CHARINDEX('" + sKey + "', ClassName)>0 or CHARINDEX(ClassName,'" + sKey + "')>0", "ClassLevel Desc, Recommend Desc"); if (tmpList.Count > 0) { ClassLibrary.Model.RouteClass tm = tmpList[0]; if (tm.ParentID != (int)SysConfig.RouteClass.国内旅游) { Response.Redirect(SysConfig.webSiteApp + "/" + tmpList[0].ClassNamePY + "/"); } } glClass = routeClassBLL.GetModelList(String.Empty, "ClassLevel Desc, Recommend Desc"); string strPageIndex = Request.QueryString["page"]; if (ClassLibrary.Common.Function.IsNumber(strPageIndex)) { pageIndex = Convert.ToInt32(strPageIndex); } else { pageIndex = 1; } }
public void findSanxiaRoute(HttpContext context) { int id = Convert.ToInt32(context.Request.QueryString["where"]); ClassLibrary.BLL.Routes routeBLL = new ClassLibrary.BLL.Routes(); ClassLibrary.BLL.RouteClass routeClassBll = new ClassLibrary.BLL.RouteClass(); List <ClassLibrary.Model.RouteClass> globalList = routeClassBll.GetSubList((int)SysConfig.RouteClass.峡旅游); List <ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(6, "isdisplay=1 and (CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0)", "RouteOrder Asc,Createdtime Desc"); StringBuilder sb = new StringBuilder(); sb.AppendLine("<ul>"); foreach (ClassLibrary.Model.Routes model in routeList) { ClassLibrary.Model.RouteClass temModel = globalList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }); sb.AppendLine("<li>"); sb.AppendFormat("<a href='{4}/{2}/{3}.html' title='{1}' class='blk' ><img class='lazy' data-original='{0}' alt='' width='222' height='137' /></a>", SysConfig.UploadFilePathRoutesImg + model.Image.Split(',')[0], model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine(); sb.AppendFormat("<p class='item_t'><a href='{4}/{2}/{3}.html' title='{1}'>{0}</a></p>", Function.Clip(model.Title, 14, false), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine(); sb.AppendFormat("<p class='item_f' title='{0}'>{1}</p>", model.Bright, Function.Clip(model.Bright, 18, false)).AppendLine(); string tp = string.Format("¥{0}<span>起</span>", Convert.ToInt32(model.Price)); if (Convert.ToInt32(model.Price) == 0) { tp = "电询"; } sb.AppendFormat("<p class='item_p'>{0}</p>", tp).AppendLine(); sb.AppendLine("</li>"); } sb.AppendLine("</ul>"); Print(context, sb.ToString()); }
//国内出境周边旅游线路 private string BindRouteList(int classId) { string where = "isdisplay=1 and (CHARINDEX('," + classId + ",',','+routesPrentClassID+',') > 0)"; if (classId == homeid) { where += "and (CHARINDEX('," + cqid + ",',','+routesPrentClassID+',') = 0)"; } DataTable mytable = routeBLL.GetData(6, where, " RecommendHot Desc, RouteOrder Asc, Createdtime Desc"); List <ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(mytable); StringBuilder sb = new StringBuilder(); foreach (ClassLibrary.Model.Routes model in routeList) { ClassLibrary.Model.RouteClass temModel = globalList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }); sb.AppendLine("<li>"); sb.AppendFormat("<a href='{4}/{2}/{3}.html' title='{1}' target='_blank' rel='nofollow' class='imglink'><img alt='' src='{0}' width='264' height='153' /></a>", SysConfig.UploadFilePathRoutesImg + model.Image.Split(',')[0], model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite); sb.AppendLine("<div class='rinfo'>"); sb.AppendFormat("<a class='rlink' href='{4}/{2}/{3}.html' title='{1}' target='_blank'><span>{0}</span></a>", Function.Clip(model.Title, 16, true), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite); sb.AppendFormat("<div class='rprice'>¥<em>{0}</em>起</div>", Convert.ToInt32(model.Price)); sb.AppendLine("</div>"); sb.AppendLine("</li>"); } return(sb.ToString()); }
public void BindRouteClass() { int tempLevel = 3; if (routeParentId == 5 || routeParentId == 3) { tempLevel = 2; } List <ClassLibrary.Model.RouteClass> list = routeClassBLL.GetSubList(routeParentId, "ClassLevel = " + tempLevel); StringBuilder sb = new StringBuilder(); StringBuilder sb2 = new StringBuilder(); string strClassIds = "," + routeParentClassIds + ","; for (int i = 0; i < list.Count; i++) { ClassLibrary.Model.RouteClass rc = list[i]; sb2.Append(rc.ID + ","); if (strClassIds.Contains("," + rc.ID.ToString() + ",")) { sb.AppendFormat("<input name='ProvinceCheckBox' onclick='ProvinceChange(this)' type='checkbox' value='{0}' checked />{1} ", rc.ID, rc.ClassName); } else { sb.AppendFormat("<input name='ProvinceCheckBox' onclick='ProvinceChange(this)' type='checkbox' value='{0}' />{1} ", rc.ID, rc.ClassName); } } routeClassList = sb.ToString(); checkedClassIds = sb2.ToString().Substring(0, sb2.Length - 1); }
private void BindInfo() { route = bll.GetModel(routeID); if (route.routesClassID == "") { Response.StatusCode = 404; Response.End(); } gList = rcBLL.GetModelList(String.Empty); if (route.ThemeID != "") { ClassLibrary.Model.RouteClass classmodel = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(route.ThemeID.Split(',')[0])); }); themeName = "<div class='detl_zt'>" + classmodel.ClassName + "</div>"; } routeClassId = route.LocationID; ClassLibrary.Model.RouteClass curClass = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); }); if (curClass.ClassNamePY != comePY) { Response.StatusCode = 404; Response.End(); } mipUrl = SysConfig.webSiteApp + "/" + comePY + "/" + routeID + ".html"; //购买事件 buyEventStr = mipUrl; dateType = route.DateType; price = Convert.ToInt32(route.Price); childPrice = Convert.ToInt32(route.ChildPrice); routeFeature = Function.AddTargetForMip(Function.UpdateStyleForMip(Function.UpdateImgTagForMip(replaceSite(route.RouteFeature)))); descriptionPrice = Function.AddTargetForMip(Function.UpdateStyleForMip(Function.UpdateImgTagForMip(replaceSite(route.DescriptionPrice)))); routeNotice = Function.AddTargetForMip(Function.UpdateStyleForMip(Function.UpdateImgTagForMip(replaceSite(route.RouteNotice)))); detailType = route.DetailType; if (route.DatePrice != "") { string[] tmpDatePrice = route.DatePrice.Split('|'); string cDate = DateTime.Now.ToShortDateString().ToString(); for (int k = 0; k < tmpDatePrice.Length; k++) { string tmpPrices = tmpDatePrice[k]; if (tmpPrices == "") { continue; } string[] tmpPrice = tmpPrices.Split(','); TimeSpan ts = DateTime.Parse(tmpPrice[0]) - DateTime.Now; if (ts.TotalDays > 0) { datePrice += tmpPrices + "|"; } } } string[] imgs = route.Image.Split(','); image = SysConfig.webSite + SysConfig.UploadFilePathRoutesImg + imgs[0]; }
//导航 private void GetLocation() { ClassLibrary.Model.RouteClass crc = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == route.LocationID); }); location += string.Format("<i class='next'></i><a href='{2}/{0}/'>{1}</a>", crc.ClassNamePY, crc.ClassName.Replace("旅游", "") + "旅游", SysConfig.webSite); location += string.Format("<i class='next'></i>{0}", Function.Clip(route.Title, 38, true)); }
private void BindArticleList() { StringBuilder sb = new StringBuilder(); string articleWhere = " isdisplay = 1 "; if (parentId == (int)SysConfig.RouteClass.峡旅游) { articleWhere += " and IsSanxia = 1 "; } else { articleWhere += " and charindex('," + routeClassId + ",',','+routeClassID+',')>0 "; } DataSet mySet = newsBll.GetPageData(15, 1, articleWhere, "Createdtime desc"); DataTable table = mySet.Tables["Data"]; DataTable tableCount = mySet.Tables["Count"]; int countRows = 0; countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString()); if (countRows < 15 && parentId != (int)SysConfig.RouteClass.峡旅游 && parentId != routeClassId) { DataSet mySet3 = newsBll.GetPageData(15, 1, "isdisplay=1 and charindex('," + parentId + ",',','+routeClassID+',')>0", "Createdtime desc"); DataTable table3 = mySet3.Tables["Data"]; table.Merge(table3); table = table.AsDataView().ToTable(true); } //if (table.Rows.Count < 15) //{ // DataSet mySet2 = newsBll.GetPageData(15, 1, "isdisplay=1", "Createdtime desc"); // DataTable table2 = mySet2.Tables["Data"]; // table.Merge(table2); // table = table.AsDataView().ToTable(true); //} int i = 0; foreach (DataRow dr in table.Rows) { i++; ClassLibrary.Model.RouteClass temClass = gList.Find(delegate(ClassLibrary.Model.RouteClass trc) { return(trc.ID == Convert.ToInt32(dr["LocationID"].ToString())); }); sb.AppendFormat("<li><a href='{0}/{1}/{2}.html' title='{3}' target='_blank'>{4}</a></li>", SysConfig.webSite, Enum.GetName(typeof(SysConfig.NewsClassPY), Convert.ToInt32(dr["newsClassId"])), dr["ID"], dr["Title"], Function.Clip(dr["Title"].ToString(), 28, true)).AppendLine(); if (i == 15) { break; } } dataArticleList = sb.ToString(); }
private void BindRelateArticles() { StringBuilder sb = new StringBuilder(); DataTable table = new DataTable(); string where = "isdisplay = 1"; if (news.IsSanxia) { table = newsBll.GetData(10, where + " and IsSanxia = 1", "ID desc "); } else { string where2 = " and CHARINDEX('," + routeClassId + ",',','+routeClassID+',') > 0 "; table = newsBll.GetData(10, where + where2, "ID desc "); if (table.Rows.Count < 10) { ClassLibrary.Model.RouteClass crc = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); }); if (crc.ClassLevel == 4) { DataTable table4 = newsBll.GetData(10, where + " and CHARINDEX('," + crc.ParentID + ",',','+routeClassID+',') > 0 ", "ID desc"); table.Merge(table4); table = table.AsDataView().ToTable(true); } } } if (table.Rows.Count < 10) { DataSet mySet2 = newsBll.GetPageData(10, 1, where, "ID desc "); DataTable table2 = mySet2.Tables["Data"]; table.Merge(table2); table = table.AsDataView().ToTable(true); } int i = 0; List <ClassLibrary.Model.News> raList = newsBll.GetModelList(table); foreach (ClassLibrary.Model.News model in raList) { i++; string preurl = Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID); sb.AppendFormat("<li><a href='{0}/{1}/{2}.html' title='{3}' target='_blank'>{4}</a><span>{5}</span></li>", SysConfig.webSite, preurl, model.ID, model.Title, Function.Clip(model.Title, 20, false), model.CreatedTime.ToString("yyyy-MM-dd")).AppendLine(); if (i >= 10) { break; } } relateArticleList = sb.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">RouteClass对象</param> /// <returns>影响行数</returns> public int Update(ClassLibrary.Model.RouteClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append(string.Format("UPDATE {0} SET ", table)); strSql.Append("ParentID=@ParentID,"); strSql.Append("ClassName=@ClassName,"); strSql.Append("CreatedTime=@CreatedTime,"); strSql.Append("Recommend=@Recommend,"); strSql.Append("seoTitle=@seoTitle,"); strSql.Append("seoKeyword=@seoKeyword,"); strSql.Append("seoDesc=@seoDesc,"); strSql.Append("classlevel=@classlevel,"); strSql.Append("classNamePY=@classNamePY,"); strSql.Append("ClassOrder=@ClassOrder,"); strSql.Append("ClassImg=@ClassImg,"); strSql.Append("IsHaidao=@IsHaidao"); strSql.Append(" WHERE ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@ClassName", SqlDbType.NVarChar, 40), new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8), new SqlParameter("@Recommend", SqlDbType.Bit, 1), new SqlParameter("@seoTitle", SqlDbType.NVarChar, 80), new SqlParameter("@seoKeyword", SqlDbType.NVarChar, 100), new SqlParameter("@seoDesc", SqlDbType.NVarChar, 200), new SqlParameter("@classlevel", SqlDbType.Int, 4), new SqlParameter("@classNamePY", SqlDbType.NVarChar, 15), new SqlParameter("@ClassOrder", SqlDbType.Int, 4), new SqlParameter("@ClassImg", SqlDbType.NVarChar, 50), new SqlParameter("@IsHaidao", SqlDbType.Bit, 1) }; parameters[0].Value = model.ID; parameters[1].Value = model.ParentID; parameters[2].Value = model.ClassName; parameters[3].Value = model.CreatedTime; parameters[4].Value = model.Recommend; parameters[5].Value = model.SeoTitle; parameters[6].Value = model.SeoKeyword; parameters[7].Value = model.SeoDesc; parameters[8].Value = model.ClassLevel; parameters[9].Value = model.ClassNamePY; parameters[10].Value = model.ClassOrder; parameters[11].Value = model.ClassImg; parameters[12].Value = model.IsHaidao; return(SQLHelper.Execute(strSql.ToString(), parameters)); }
//新闻详情 private void BindInfo() { news = newsBll.GetModel(newsID); if (news.Title == "") { Response.StatusCode = 404; Response.End(); } routeClassId = news.LocationID; gList = rcBll.GetModelList(String.Empty); ClassLibrary.Model.RouteClass rcmodel = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); }); displayPing = rcmodel.ClassNamePY; displayName = rcmodel.ClassName; ntag = news.Ntag.Replace(",", " ").Replace(",", " "); zanCount = news.ZanCount; articleTitle = news.Title; }
//三峡旅游线路 private void bindRouteForSX() { List <ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(6, "isdisplay=1 and (CHARINDEX('," + sanid + ",',','+routesPrentClassID+',') > 0)", " RecommendHot Desc, RouteOrder Asc,Createdtime Desc"); StringBuilder sb = new StringBuilder(); foreach (ClassLibrary.Model.Routes model in routeList) { ClassLibrary.Model.RouteClass temModel = globalList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }); sb.AppendLine("<li>"); sb.AppendLine("<div class='sxi_info'>"); sb.AppendFormat("<span class='sxi_title'><a href='{0}/{1}/{2}.html' title='{3}' target='_blank'>{4}</a></span>", SysConfig.webSite, temModel.ClassNamePY, model.ID, model.Title, Function.Clip(model.Title, 17, true)); sb.AppendFormat("<span class='sxi_price'>¥<em>{0}</em>起</span>", Convert.ToInt32(model.Price)); sb.AppendLine("</div>"); sb.AppendFormat("<a class='sxi_img' href='{0}/{1}/{2}.html' target='_blank' rel='nofollow'><img src='{3}' alt='' width='221' height='148' /></a>", SysConfig.webSite, temModel.ClassNamePY, model.ID, SysConfig.UploadFilePathRoutesImg + model.Image.Split(',')[0]); sb.AppendLine("</li>"); } dataSxList = sb.ToString(); }
private void BindDatapromotion() { StringBuilder sb = new StringBuilder(); string sqlWhere = "isdisplay = 1 and CHARINDEX('" + sKey + "',Title)>0"; DataSet mySet = newsBll.GetPageData(8, 1, sqlWhere, " CreatedTime desc "); DataTable table = mySet.Tables["Data"]; if (table.Rows.Count < 8) { DataSet mySet2 = newsBll.GetPageData(5, 1, "isdisplay = 1", " CreatedTime desc "); DataTable table2 = mySet2.Tables["Data"]; table.Merge(table2); table = table.AsDataView().ToTable(true); } int i = 0; foreach (DataRow dr in table.Rows) { i++; ClassLibrary.Model.RouteClass temClass = glClass.Find(delegate(ClassLibrary.Model.RouteClass trc) { return(trc.ID == Convert.ToInt32(dr["LocationID"].ToString())); }); sb.AppendFormat("<li class='{0}'>", (i == 8 || i == table.Rows.Count) ? "lastline" : ""); sb.AppendFormat("<a class='side_img' href='{0}/{1}/{2}.html' title='{3}' target='_blank' rel='nofollow'>", SysConfig.webSite, Enum.GetName(typeof(SysConfig.NewsClassPY), Convert.ToInt32(dr["newsClassId"])), dr["ID"], dr["Title"]).AppendLine(); sb.AppendFormat("<img src='{0}' alt='' width='48' height='48' /></a>", SysConfig.UploadFilePathNewsImg + dr["Image"]).AppendLine(); sb.AppendFormat("<a class='side_title' href='{0}/{1}/{2}.html' title='{3}' target='_blank'>{4}</a>", SysConfig.webSite, Enum.GetName(typeof(SysConfig.NewsClassPY), Convert.ToInt32(dr["newsClassId"])), dr["ID"], dr["Title"], Function.Clip(dr["Title"].ToString(), 30, true)).AppendLine(); sb.AppendLine("</li>"); if (i == 8) { break; } } dataGongLuList = sb.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">RouteClass对象</param> public int Add(ClassLibrary.Model.RouteClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append(string.Format("INSERT INTO {0}(", table)); strSql.Append("ParentID,ClassName,CreatedTime,Recommend,seoTitle,seoKeyword,seoDesc,classlevel,classNamePY,ClassOrder,ClassImg,IsHaidao"); strSql.Append(") VALUES ("); strSql.Append("@ParentID,@ClassName,@CreatedTime,@Recommend,@seoTitle,@seoKeyword,@seoDesc,@classlevel,@classNamePY,@ClassOrder,@ClassImg,@IsHaidao)"); SqlParameter[] parameters = { new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@ClassName", SqlDbType.NVarChar, 40), new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8), new SqlParameter("@Recommend", SqlDbType.Bit, 1), new SqlParameter("@seoTitle", SqlDbType.NVarChar, 80), new SqlParameter("@seoKeyword", SqlDbType.NVarChar, 100), new SqlParameter("@seoDesc", SqlDbType.NVarChar, 200), new SqlParameter("@classlevel", SqlDbType.Int, 4), new SqlParameter("@classNamePY", SqlDbType.NVarChar, 15), new SqlParameter("@ClassOrder", SqlDbType.Int, 4), new SqlParameter("@ClassImg", SqlDbType.NVarChar, 50), new SqlParameter("@IsHaidao", SqlDbType.Bit, 1) }; parameters[0].Value = model.ParentID; parameters[1].Value = model.ClassName; parameters[2].Value = model.CreatedTime; parameters[3].Value = model.Recommend; parameters[4].Value = model.SeoTitle; parameters[5].Value = model.SeoKeyword; parameters[6].Value = model.SeoDesc; parameters[7].Value = model.ClassLevel; parameters[8].Value = model.ClassNamePY; parameters[9].Value = model.ClassOrder; parameters[10].Value = model.ClassImg; parameters[11].Value = model.IsHaidao; return(SQLHelper.Execute(strSql.ToString(), parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="ID">主键ID</param> /// <returns>RouteClass对象</returns> public ClassLibrary.Model.RouteClass GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT ID,ParentID,ClassName,CreatedTime,Recommend,seoTitle,seoKeyword,seoDesc,classlevel,classNamePY,ClassOrder,ClassImg,IsHaidao"); strSql.Append(" FROM "); strSql.Append(table); strSql.Append(string.Format(" WHERE {0}=@{0}", pk)); SqlParameter[] parameters = { new SqlParameter("@" + pk, SqlDbType.Int, 4) }; parameters[0].Value = ID; ClassLibrary.Model.RouteClass model = new ClassLibrary.Model.RouteClass(); DataTable dt = SQLHelper.Query(strSql.ToString(), parameters); model.ID = ID; if (dt.Rows.Count > 0) { if (dt.Rows[0]["ParentID"] != DBNull.Value) { model.ParentID = Convert.ToInt32(dt.Rows[0]["ParentID"]); } if (dt.Rows[0]["ClassName"] != DBNull.Value) { model.ClassName = Convert.ToString(dt.Rows[0]["ClassName"]); } if (dt.Rows[0]["CreatedTime"] != DBNull.Value) { model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]); } if (dt.Rows[0]["Recommend"] != DBNull.Value) { model.Recommend = Convert.ToBoolean(dt.Rows[0]["Recommend"]); } if (dt.Rows[0]["seoTitle"] != DBNull.Value) { model.SeoTitle = Convert.ToString(dt.Rows[0]["seoTitle"]); } if (dt.Rows[0]["seoKeyword"] != DBNull.Value) { model.SeoKeyword = Convert.ToString(dt.Rows[0]["seoKeyword"]); } if (dt.Rows[0]["seoDesc"] != DBNull.Value) { model.SeoDesc = Convert.ToString(dt.Rows[0]["seoDesc"]); } if (dt.Rows[0]["classlevel"] != DBNull.Value) { model.ClassLevel = Convert.ToInt32(dt.Rows[0]["classlevel"]); } if (dt.Rows[0]["classNamePY"] != DBNull.Value) { model.ClassNamePY = Convert.ToString(dt.Rows[0]["classNamePY"]); } if (dt.Rows[0]["ClassOrder"] != DBNull.Value) { model.ClassOrder = Convert.ToInt32(dt.Rows[0]["ClassOrder"]); } if (dt.Rows[0]["ClassImg"] != DBNull.Value) { model.ClassImg = Convert.ToString(dt.Rows[0]["ClassImg"]); } if (dt.Rows[0]["IsHaidao"] != DBNull.Value) { model.IsHaidao = Convert.ToBoolean(dt.Rows[0]["IsHaidao"]); } } return(model); }
private void BindItem() { rcList = classbll.GetModelList(String.Empty); DataTable table = classbll.GetData(" classlevel=1 and id < 6", "createdtime desc"); StringBuilder sb = new StringBuilder(); /*国内旅游*/ sb.Append("<div class='SiteMap_Item'>"); sb.AppendFormat("<p><a href='{2}/{1}/'>{0}</a></p>", "国内旅游", "guonei", SysConfig.webSite); List <ClassLibrary.Model.RouteClass> gnList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.国内旅游); }); foreach (ClassLibrary.Model.RouteClass model in gnList) { sb.AppendFormat("<p>{0}</p>", model.ClassName); List <ClassLibrary.Model.RouteClass> level3List = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == model.ID); }); foreach (ClassLibrary.Model.RouteClass model3 in level3List) { sb.Append("<div class='SiteMap_Text'>"); sb.AppendFormat("<div class='SiteMap_Text_first'><a href='{2}/{1}/'>{0}旅游</a></div>", model3.ClassName, model3.ClassNamePY, SysConfig.webSite); sb.Append(" <div class='SiteMap_Text_child'>"); List <ClassLibrary.Model.RouteClass> level4List = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == model3.ID); }); foreach (ClassLibrary.Model.RouteClass model4 in level4List) { sb.AppendFormat("<a href='{2}/{1}/'>{0}旅游</a>", model4.ClassName, model4.ClassNamePY, SysConfig.webSite); } sb.Append("</div></div>"); } } sb.Append("</div>"); /*出境旅游*/ sb.Append("<div class='SiteMap_Item'>"); sb.AppendFormat("<p><a href='{2}/{1}/'>{0}</a></p>", "出境旅游", "chujing", SysConfig.webSite); List <ClassLibrary.Model.RouteClass> cjList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.出境旅游); }); foreach (ClassLibrary.Model.RouteClass model in cjList) { sb.Append("<div class='SiteMap_Text'>"); sb.AppendFormat("<div class='SiteMap_Text_first'><a href='{2}/{1}/'>{0}旅游</a></div>", model.ClassName, model.ClassNamePY, SysConfig.webSite); sb.Append(" <div class='SiteMap_Text_child'>"); List <ClassLibrary.Model.RouteClass> level2List = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == model.ID); }); foreach (ClassLibrary.Model.RouteClass model2 in level2List) { sb.AppendFormat("<a href='{2}/{1}/'>{0}旅游</a>", model2.ClassName, model2.ClassNamePY, SysConfig.webSite); } sb.Append("</div></div>"); } sb.Append("</div>"); /*三峡旅游*/ sb.Append("<div class='SiteMap_Item'>"); sb.AppendFormat("<p><a href='{2}/{1}/'>{0}</a></p>", "三峡旅游", "sanxia", SysConfig.webSite); List <ClassLibrary.Model.RouteClass> sxList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.峡旅游); }); sb.Append("<div class='SiteMap_Text'>"); sb.AppendFormat("<div class='SiteMap_Text_first'> </div>"); sb.Append("<div class='SiteMap_Text_child'>"); foreach (ClassLibrary.Model.RouteClass model in sxList) { sb.AppendFormat("<a href='{2}/{1}/'>{0}</a>", model.ClassName, model.ClassNamePY, SysConfig.webSite); } sxList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.豪华船); }); foreach (ClassLibrary.Model.RouteClass model in sxList) { sb.AppendFormat("<a href='{2}/{1}/'>{0}</a>", model.ClassName, model.ClassNamePY, SysConfig.webSite); } sb.Append("</div></div></div>"); /*主题旅游*/ ClassLibrary.BLL.RouteType rtBll = new ClassLibrary.BLL.RouteType(); sb.Append("<div class='SiteMap_Item'>"); sb.AppendFormat("<p>{0}</p>", "主题旅游"); List <ClassLibrary.Model.RouteType> ztList = rtBll.GetModelList(String.Empty); sb.Append("<div class='SiteMap_Text'>"); sb.AppendFormat("<div class='SiteMap_Text_first'> </div>"); sb.Append("<div class='SiteMap_Text_child'>"); foreach (ClassLibrary.Model.RouteType model in ztList) { sb.AppendFormat("<a href='{2}/{1}/'>{0}</a>", model.ClassName, model.classNamePY, SysConfig.webSite); } sb.Append("</div></div></div>"); DataMap = sb.ToString(); ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes(); List <ClassLibrary.Model.Routes> routeList = routeBll.GetModelList(20, "isdisplay = 1", "CreatedTime Desc"); StringBuilder sb2 = new StringBuilder(); foreach (ClassLibrary.Model.Routes model in routeList) { ClassLibrary.Model.RouteClass temClass = rcList.Find(delegate(ClassLibrary.Model.RouteClass trc) { return(trc.ID == model.LocationID); }); sb2.AppendFormat("<li><a href='{0}/{1}/{2}.html' target='_blank'>{3}</a></li>", SysConfig.webSite, temClass.ClassNamePY, model.ID, model.Title).AppendLine(); } mapRoute = sb2.ToString(); ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News(); List <ClassLibrary.Model.News> newsList = newsBll.GetModelList(10, "isdisplay = 1 and newsClassId = 2", "CreatedTime Desc"); StringBuilder sb3 = new StringBuilder(); foreach (ClassLibrary.Model.News model in newsList) { sb3.AppendFormat("<li><a href='{0}/{1}/{2}.html' target='_blank'>{3}</a></li>", SysConfig.webSite, Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID), model.ID, model.Title).AppendLine(); } mapArticle = sb3.ToString(); newsList = newsBll.GetModelList(10, "isdisplay = 1 and newsClassId = 1", "CreatedTime Desc"); StringBuilder sb4 = new StringBuilder(); foreach (ClassLibrary.Model.News model in newsList) { sb4.AppendFormat("<li><a href='{0}/{1}/{2}.html' target='_blank'>{3}</a></li>", SysConfig.webSite, Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID), model.ID, model.Title).AppendLine(); } mapNews = sb4.ToString(); }
private void EditRouteClass() { ClassLibrary.Model.RouteClass RouteClassModel = new ClassLibrary.Model.RouteClass(); RouteClassModel.ID = routeClassId; RouteClassModel.ParentID = Convert.ToInt32(Request.Form["routeClassID"]); if (routeClassId == RouteClassModel.ParentID) { Response.Write("<script>alert('上级分类不能为本分类!');history.back(-1);</script>"); return; } if (RouteClassModel.ParentID == 0) { RouteClassModel.ClassLevel = 1; } else { RouteClassModel.ClassLevel = routeClassBLL.GetModel(RouteClassModel.ParentID).ClassLevel + 1; } if (string.IsNullOrEmpty(Request.Form["ClassName"])) { Response.Write("<script>alert('请输入路线类型!');history.back(-1);</script>"); return; } else { RouteClassModel.ClassName = Request.Form["ClassName"]; } if (string.IsNullOrEmpty(Request.Form["ClassNamePinYin"])) { Response.Write("<script>alert('请输入城市拼音!');history.back(-1);</script>"); return; } else { RouteClassModel.ClassNamePY = Request.Form["ClassNamePinYin"].Trim(); } if (!string.IsNullOrEmpty(Request.Form["SeoTitle"])) { RouteClassModel.SeoTitle = Request.Form["SeoTitle"]; } if (!string.IsNullOrEmpty(Request.Form["SeoKeywords"])) { RouteClassModel.SeoKeyword = Request.Form["SeoKeywords"]; } if (!string.IsNullOrEmpty(Request.Form["SeoDescription"])) { RouteClassModel.SeoDesc = Request.Form["SeoDescription"]; } if (!string.IsNullOrEmpty(Request.Form["classOrder"]) && Function.IsNumber(Request.Form["classOrder"])) { RouteClassModel.ClassOrder = Convert.ToInt32(Request.Form["classOrder"]); } RouteClassModel.Recommend = Convert.ToBoolean(Request.Form["Recommend"]); RouteClassModel.IsHaidao = Convert.ToBoolean(Request.Form["IsHaidao"]); //int nmaxid = Convert.ToInt32(Request.Form["maxid"]); //int nwidth = 61; //int nheight = 41; //if (nmaxid == (int)SysConfig.RouteClass.三峡旅游) //{ // nwidth = 50; // nheight = 50; //} HttpPostedFile file = Request.Files["Image"]; string oldImages = Request.Form["Image_Hidden"]; if (file.ContentLength > 0) { string ext = Path.GetExtension(file.FileName); string fileName = Function.GetRandomTime() + ext; string fileFullPath = Server.MapPath(SysConfig.UploadFilePathClassImg); Function.CreatedDirectory(fileFullPath); file.SaveAs(fileFullPath + fileName); //缩图 //Bitmap tmp = new Bitmap(fileFullPath + fileName); //Bitmap bmp0 = Function.MakeThumNail(tmp, nwidth, nheight); //tmp.Dispose(); ////bmp0.Save(fileFullPath + fileName); //Function.SaveBitmapImg(bmp0, fileFullPath + fileName, ((long)100)); //bmp0.Dispose(); Function.DeleteFile(fileFullPath + oldImages); RouteClassModel.ClassImg = fileName; } else { RouteClassModel.ClassImg = oldImages; } if (routeClassBLL.Update(RouteClassModel) > 0) { Function.goMessagePage("修改路线类型", "操作成功", "RouteClass/RouteClassList.aspx?cid=" + maxClassID); } else { Function.goMessagePage("修改路线类型", "操作失败,请稍后再试", "RouteClass/RouteClassList.aspx?cid=" + maxClassID); } }
public void findZhutiRoute(HttpContext context) { int id = Convert.ToInt32(context.Request.QueryString["where"]); string className = context.Request.QueryString["name"]; StringBuilder sbc = new StringBuilder(); ClassLibrary.BLL.Routes routeBLL = new ClassLibrary.BLL.Routes(); ClassLibrary.BLL.RouteClass routeClassBll = new ClassLibrary.BLL.RouteClass(); List <ClassLibrary.Model.RouteClass> globalList = routeClassBll.GetModelList(string.Empty); sbc.AppendLine("<div class='ztc_img'>"); //if (ztAdList.Count > 0) //{ // ztModel = ztAdList[0]; //} //sbc.AppendFormat("<a href='{0}' title='{1}'><img class='lazy' data-original='{2}' alt='' width='222' height='467' /></a>", // ztModel.LinkURL, ztModel.Title, SysConfig.UploadFilePathAdImg + ztModel.Img).AppendLine(); sbc.AppendLine("</div>"); sbc.AppendLine("<ul class='ztc_items'>"); List <ClassLibrary.Model.Routes> ztRouteListm = routeBLL.GetModelList(6, "isdisplay=1 and charindex('," + id + ",',','+ThemeID+',')>0 and CHARINDEX('1',RecommendIndex) > 0", "routeOrder Asc, CreatedTime Desc"); string ztids = ""; foreach (ClassLibrary.Model.Routes rm in ztRouteListm) { ClassLibrary.Model.RouteClass tmpc = globalList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == rm.LocationID); }); sbc.AppendLine("<li>"); sbc.AppendFormat("<a href='{0}/{1}/{2}.html' title='{3}' class='blk' ><img class='lazy' data-original='{4}' alt='' width='222' height='139' /></a>", SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, SysConfig.UploadFilePathRoutesImg + rm.Image.Split(',')[0]).AppendLine(); sbc.AppendFormat("<p class='item_t'><a href='{0}/{1}/{2}.html' title='{3}'>{4}</a></p>", SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, Function.Clip(rm.Title, 15, false)).AppendLine(); //sbc.AppendFormat("<p class='item_f' title='{0}'>{1}</p>", rm.Bright, Function.Clip(rm.Bright, 19, false)).AppendLine(); string tp = string.Format("¥{0}<span>起</span>", Convert.ToInt32(rm.Price)); if (Convert.ToInt32(rm.Price) == 0) { tp = "电询"; } sbc.AppendFormat("<p class='item_p'>{0}</p>", tp).AppendLine(); sbc.AppendLine("</li>"); ztids += rm.ID + ","; } if (ztids.Length > 0) { ztids = ztids.Substring(0, ztids.Length - 1); } sbc.AppendLine("</ul>"); sbc.AppendLine("<div class='ztc_more'>"); sbc.AppendLine("<dl class='ztc_more_gn'>"); sbc.AppendFormat("<dt>国内热门{0}旅游线路</dt>", className).AppendLine(); if (ztids.Length > 0) { List <ClassLibrary.Model.Routes> ztRouteListg = routeBLL.GetModelList(6, "isdisplay=1 and id not in (" + ztids + ") and charindex('," + id + ",',','+ThemeID+',')>0 and charindex('," + (int)SysConfig.RouteClass.国内旅游 + ",',','+routesPrentClassID+',')>0", "routeOrder Asc, CreatedTime Desc"); foreach (ClassLibrary.Model.Routes rm in ztRouteListg) { ClassLibrary.Model.RouteClass tmpc = globalList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == rm.LocationID); }); string tp = string.Format("¥{0}起", Convert.ToInt32(rm.Price)); if (Convert.ToInt32(rm.Price) == 0) { tp = "电询"; } sbc.AppendFormat("<dd><a href='{0}/{1}/{2}.html' title='{3}'>{4}</a><span>{5}</span></dd>", SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, Function.Clip(rm.Title, 10, false), tp).AppendLine(); } } sbc.AppendLine("</dl>"); sbc.AppendLine("<dl class='ztc_more_cj'>"); sbc.AppendFormat("<dt>出境热门{0}旅游线路</dt>", className).AppendLine(); if (ztids.Length > 0) { List <ClassLibrary.Model.Routes> ztRouteListc = routeBLL.GetModelList(6, "isdisplay=1 and id not in (" + ztids + ") and charindex('," + id + ",',','+ThemeID+',')>0 and charindex('," + (int)SysConfig.RouteClass.出境旅游 + ",',','+routesPrentClassID+',')>0", "routeOrder Asc, CreatedTime Desc"); foreach (ClassLibrary.Model.Routes rm in ztRouteListc) { ClassLibrary.Model.RouteClass tmpc = globalList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == rm.LocationID); }); string tp = string.Format("¥{0}起", Convert.ToInt32(rm.Price)); if (Convert.ToInt32(rm.Price) == 0) { tp = "电询"; } sbc.AppendFormat("<dd><a href='{0}/{1}/{2}.html' title='{3}'>{4}</a><span>{5}</span></dd>", SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, Function.Clip(rm.Title, 10, false), Convert.ToInt32(rm.Price)).AppendLine(); } } sbc.AppendLine("</dl>"); //sbc.AppendLine("<div class='ztc_more_img'>"); //sbc.AppendFormat("<a href='{0}' title='{1}'><img src='{2}' alt='' width='190' height='111' /></a>", // ztModel.LinkURL, ztModel.Title, SysConfig.UploadFilePathAdImg + ztImgr).AppendLine(); //sbc.AppendLine("</div>"); sbc.AppendLine("<div class='inx_zt_bg_right'></div>"); sbc.AppendLine("</div>"); Print(context, sbc.ToString()); }
private void GrapBaiduMsg(HttpContext context) { string sRslt = GetHtmlStr("http://www.yododo.com/ask/list/"); ClassLibrary.BLL.RouteClass rcBll = new ClassLibrary.BLL.RouteClass(); List <ClassLibrary.Model.RouteClass> rcList = rcBll.GetModelList("classLevel = 3"); Parser parser = Parser.CreateParser(sRslt, "utf-8"); NodeFilter filterUL = new AndFilter(new TagNameFilter("ul"), new HasAttributeFilter("class", "miniarea-list clearfix")); NodeList liList = parser.Parse(filterUL); string links = liList[0].ToHtml(); parser = Parser.CreateParser(links, "utf-8"); NodeFilter filterLI = new TagNameFilter("li"); //new NodeClassFilter(typeof(ATag)); NodeList nodelist = parser.Parse(filterLI); //string strGn = nodelist[1].ToHtml(); string strCj = nodelist[0].ToHtml(); //parser = Parser.CreateParser(nodelist.ToHtml(), "utf-8"); NodeFilter filterA = new NodeClassFilter(typeof(ATag)); /*NodeList aGnList = parser.Parse(filterA); * for (int i = 0; i < aGnList.Count; i++) * { * ITag tag = getTag(aGnList[i]); * string url = "http://www.yododo.com" + tag.GetAttribute("href") + "s1"; //已解决 * string className = tag.ToPlainTextString(); * if (className == "全部") continue; * * ClassLibrary.Model.RouteClass model = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return rc.ClassName == className; }); * if (model == null) continue; * * paserData(aGnList[i], url, model.ID); * }*/ parser = Parser.CreateParser(strCj, "utf-8"); NodeList areaCjList = parser.Parse(filterA); for (int i = 0; i < areaCjList.Count; i++) { ITag tag = getTag(areaCjList[i]); string url = "http://www.yododo.com" + tag.GetAttribute("href"); //各洲 string className = tag.ToPlainTextString(); if (className == "全部" || className == "中国") { continue; } parser = Parser.CreateParser(GetHtmlStr(url), "utf-8"); //NodeFilter filterUL = new AndFilter(new TagNameFilter("ul"), new HasAttributeFilter("class", "miniarea-list clearfix")); NodeList liListCj = parser.Parse(filterUL); string linksCj = liListCj[0].ToHtml(); parser = Parser.CreateParser(linksCj, "utf-8"); //NodeFilter filterA = new NodeClassFilter(typeof(ATag)); NodeList aCjList = parser.Parse(filterA); for (int j = 0; j < aCjList.Count; j++) { ITag cjtag = getTag(aCjList[j]); string url1 = "http://www.yododo.com" + cjtag.GetAttribute("href") + "s1"; //已解决 string className1 = cjtag.ToPlainTextString(); if (className1 == "全部") { continue; } ClassLibrary.Model.RouteClass model = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ClassName == className1); }); if (model == null) { continue; } paserData(aCjList[j], url1, model.ID); } } Print(context, "success"); }
//国内 public void findhomeRoute(HttpContext context) { int id = Convert.ToInt32(context.Request.QueryString["where"]); ClassLibrary.BLL.Routes routeBLL = new ClassLibrary.BLL.Routes(); ClassLibrary.BLL.RouteClass routeClassBLL = new ClassLibrary.BLL.RouteClass(); DataTable mytable = routeBLL.GetData(4, "isdisplay=1 and (CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0) and RecommendHot = 1", "Createdtime Desc"); mytable.Merge(routeBLL.GetData(16, "isdisplay=1 and (CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0)", "RouteOrder Asc,Createdtime Desc")); mytable = mytable.AsDataView().ToTable(true); List <ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(mytable); //List<ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(8, "(CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0)", "RouteOrder Asc,Createdtime Desc"); List <ClassLibrary.Model.RouteClass> globalList = routeClassBLL.GetSubList((int)SysConfig.RouteClass.国内旅游); StringBuilder sb = new StringBuilder(); StringBuilder sb2 = new StringBuilder(); int count = 0; sb.AppendLine("<ul class='gnc_down'>"); sb2.AppendLine("<ul class='gnc_up'>"); foreach (ClassLibrary.Model.Routes model in routeList) { if (count >= 16) { break; } ClassLibrary.Model.RouteClass temModel = globalList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }); if (count < 4) { sb2.AppendLine("<li>"); sb2.AppendFormat("<a href='{4}/{2}/{3}.html' title='{1}' class='blk' target='_blank'><img class='lazy' data-original='{0}' alt='' width='222' height='138' /></a>", SysConfig.UploadFilePathRoutesImg + model.Image.Split(',')[0], model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine(); sb2.AppendFormat("<p class='item_t'><a href='{4}/{2}/{3}.html' title='{1}' target='_blank'>{0}</a></p>", Function.Clip(model.Title, 28, false), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine(); sb2.AppendFormat("<p class='item_f' title='{0}'>{1} </p>", model.Bright, Function.Clip(model.Bright, 16, false)).AppendLine(); string tp = string.Format("¥{0}<span>起</span>", Convert.ToInt32(model.Price)); if (Convert.ToInt32(model.Price) == 0) { tp = "电询"; } sb2.AppendFormat("<p class='item_p'>{0}</p>", tp).AppendLine(); sb2.AppendLine("</li>"); } else { sb.AppendLine("<li>"); sb.AppendFormat("<p class='item_title'><a href='{4}/{2}/{3}.html' title='{1}' target='_blank'>{0}</a></p>", Function.Clip(model.Title, 26, false), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine(); string tp = string.Format("¥{0}起", Convert.ToInt32(model.Price)); if (Convert.ToInt32(model.Price) == 0) { tp = "电询"; } sb.AppendFormat("<div class='gnc_left_price'>{0}</div>", tp).AppendLine(); sb.AppendLine("</li>"); } count++; } sb.AppendLine("</ul>"); sb2.AppendLine("</ul>"); Print(context, sb2.ToString() + sb.ToString()); }
private void AddLinks() { if (Request.Files.Count == 0) { Response.Write("<script>alert('请选择链接文件...');history.back(-1);</script>"); return; } HttpPostedFile file = Request.Files[0]; int fileLen = file.ContentLength; if (fileLen <= 0) { Response.Write("<script>alert('链接文件为空,请重新上传!');history.back(-1);</script>"); return; } string ext = Path.GetExtension(file.FileName); if (ext != ".txt") { Response.Write("<script>alert('仅支持txt链接文件,请重新上传!');history.back(-1);</script>"); return; } byte[] input = new byte[fileLen]; Stream str = file.InputStream; str.Read(input, 0, fileLen); str.Position = 0; System.IO.StreamReader sr = new System.IO.StreamReader(str, System.Text.Encoding.Default); string link = sr.ReadLine(); int i = 1; ClassLibrary.Model.Links model = new ClassLibrary.Model.Links(); ClassLibrary.BLL.Links bll = new ClassLibrary.BLL.Links(); ClassLibrary.BLL.RouteClass rcBll = new ClassLibrary.BLL.RouteClass(); List <ClassLibrary.Model.RouteClass> rcList = rcBll.GetModelList(string.Empty); while (link != null && link.Trim() != "") { string[] lks = link.Split('^'); if (lks.Length != 3) { Response.Write("<script>alert('第" + i + "行数据有问题,请检查后重新上传后面部分数据!');history.back(-1);</script>"); return; } model.Title = lks[0].Trim(); model.LinkURL = lks[1].Trim(); if (model.LinkURL.IndexOf("http://") != 0) { model.LinkURL = "http://" + lks[1]; } if (Function.IsNumberStr(lks[2])) { ClassLibrary.Model.RouteClass rc = rcList.Find(delegate(ClassLibrary.Model.RouteClass trc) { return(trc.ID == Convert.ToInt32(lks[2])); }); if (rc == null) { Response.Write("<script>alert('第" + i + "行数据目的地ID无效,请检查后重新上传后面部分数据!');history.back(-1);</script>"); return; } model.LinkClass = Convert.ToInt32(lks[2]); } else { Response.Write("<script>alert('第" + i + "行数据目的地ID出错,请检查后重新上传后面部分数据!');history.back(-1);</script>"); return; } if (bll.Add(model) > 0) { link = sr.ReadLine(); i++; } else { Response.Write("<script>alert('第" + i + "行数据添加出错,请检查后重新上传后面部分数据!');history.back(-1);</script>"); return; } } str.Close(); sr.Close(); Function.goMessagePage("批量导入友情链接", "成功导入" + (i - 1) + "个链接", "Links/LinksList.aspx"); }
private void GetArgument() { string pingyin = Function.GetQueryString("py"); glClass = routeClassBLL.GetModelList(String.Empty, "ClassOrder Asc"); grtClass = routeTypeBll.GetModelList(String.Empty, "ClassOrder Asc"); mipUrl = SysConfig.webSiteApp + "/mip/" + pingyin + "/"; if (pingyin != "") { currClass = glClass.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ClassNamePY == pingyin); }); if (currClass == null) { currZtClass = grtClass.Find(delegate(ClassLibrary.Model.RouteType tm) { return(tm.classNamePY == pingyin); }); if (currZtClass == null) { Response.StatusCode = 404; Response.End(); } else { isZhuti = true; } } } else { Response.StatusCode = 404; Response.End(); } if (!isZhuti) { cid = currClass.ID; List <ClassLibrary.Model.RouteClass> classList = glClass.FindAll(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ParentID == cid); }); if (classList.Count == 0) { pid = currClass.ParentID; } else { pid = cid; } displayName = currClass.ClassName.Replace("旅游", ""); } else { cid = currZtClass.ID; displayName = currZtClass.ClassName.Replace("游", ""); } string strPageIndex = Request.QueryString["page"]; if (ClassLibrary.Common.Function.IsNumber(strPageIndex)) { pageIndex = Convert.ToInt32(strPageIndex); } else { pageIndex = 1; } }
//网站信息 private void GetWebInfo() { webMeta.Title = "重庆青年旅行社_重庆旅行社_重庆中国青年旅行社_重庆中青旅行社"; webMeta.Description = "重庆中国青年旅行社(www.qu17.com)称重庆青旅,旅游热线:400-017-5761.共青团市委直属重庆旅行社,中青旅集团成员单位,优质服务示范重庆旅行社,重庆青年旅行社具有国家旅游局颁证的出境旅游资质的国际旅行社,旅游品质最高的重庆旅行社,重庆十大金牌旅行社,出入境游、国内游、重庆周边游、长江三峡游为主导。"; webMeta.Keyword = "重庆旅行社,重庆青年旅行社,重庆中青旅,重庆中国青年旅行社,重庆旅游网"; string url = HttpContext.Current.Request.CurrentExecutionFilePath.ToLower(); string tmpTitle = "_重庆中国青年旅行社"; if (url.IndexOf("approutesearch.aspx") > -1) { webMeta.Title = "旅游线路搜索结果" + tmpTitle; webMeta.Keyword = ""; webMeta.Description = ""; } else if (url.IndexOf("approutelist.aspx") > -1) { string ping = Function.GetQueryString("py"); ClassLibrary.BLL.RouteClass routeClassBll = new ClassLibrary.BLL.RouteClass(); List <ClassLibrary.Model.RouteClass> rcList = routeClassBll.GetModelList("classNamePy='" + ping + "'"); if (rcList.Count > 0) { ClassLibrary.Model.RouteClass rc = rcList[0]; if (rc.ClassLevel == 4) { webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName); webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName); webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName); } else if (rc.ClassLevel == 3) { if (rc.ID == (int)SysConfig.RouteClass.重庆) { webMeta.Title = "重庆周边游_重庆周边旅游线路报价_重庆中国青年旅行社"; webMeta.Keyword = "重庆周边旅游,重庆周边旅游线路,重庆周边旅游行程,重庆周边旅游报价"; webMeta.Description = "重庆周边旅游线路、周边旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761."; } else if (rc.ParentID == (int)SysConfig.RouteClass.豪华船) { webMeta.Title = string.Format("重庆三峡{0}旅游_{0}三峡旅游报价", rc.ClassName); webMeta.Keyword = string.Format("重庆三峡{0}旅游,三峡{0}旅游报价,重庆三峡旅游", rc.ClassName); webMeta.Description = string.Format("重庆青年旅行社提供重庆三峡{0}旅游线路报价,重庆三峡{0}旅游费用,长江三峡豪华游船旅游价格,三峡{0}旅游要多少钱,详询中青旅电话400-017-5761.", rc.ClassName); } else { webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName); webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName); webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName); } } else if (rc.ClassLevel == 2) { if (rc.ParentID == (int)SysConfig.RouteClass.峡旅游) { if (rc.ID == (int)SysConfig.RouteClass.豪华船) { webMeta.Title = "三峡豪华游船_豪华游船航期表_重庆三峡豪华游轮_重庆中国青年旅行社"; webMeta.Keyword = "重庆三峡豪华游船,长江三峡游船,豪华游船航期表,三峡涉外豪华游轮"; webMeta.Description = "重庆中国青年旅行社提供各系列长江三峡豪华游轮,以及三峡涉外豪华游轮旅游品质服务,重庆三峡涉外豪华游轮预定,重庆中青旅热线:400-017-5761"; } else { webMeta.Title = "三峡国内游船_重庆三峡国内船_重庆中国青年旅行社"; webMeta.Keyword = "重庆三峡国内游船,长江三峡游船,三峡国内游轮"; webMeta.Description = "重庆中国青年旅行社提供长江三峡国内游船,长江三峡旅游品质服务,重庆三峡国内游船预定,重庆中青旅热线:400-017-5761"; } } else { webMeta.Title = string.Format("{0}旅游线路行程_{0}跟团游报价_重庆中国青年旅行社", rc.ClassName); webMeta.Keyword = string.Format("{0}旅游,{0}跟团游,{0}旅游行程报价,{0}旅游线路,重庆中青旅{0}旅游团", rc.ClassName); webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆到{0}旅游最新报价,{0}跟团游最具性价比的旅行社,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rc.ClassName); } } else { if (rc.ID == (int)SysConfig.RouteClass.国内旅游) { webMeta.Title = "国内旅游线路行程_重庆出发国内旅游线路_重庆中国青年旅行社"; webMeta.Keyword = "国内游线路,国内游行程,国内游报价,国内游跟团,重庆出发国内游"; webMeta.Description = "重庆出发国内旅游线路、国内旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761."; } else if (rc.ID == (int)SysConfig.RouteClass.出境旅游) { webMeta.Title = "出境旅游线路行程_重庆出发出境旅游线路_重庆中国青年旅行社"; webMeta.Keyword = "出境游线路,出境游行程,出境游报价,出境游跟团,重庆出发出境游"; webMeta.Description = "重庆出发出境旅游线路、出境旅游行程报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761."; } else if (rc.ID == (int)SysConfig.RouteClass.峡旅游) { webMeta.Title = "重庆长江三峡旅游_重庆三峡旅游行程景点_重庆中国青年旅行社"; webMeta.Keyword = "重庆三峡旅游,长江三峡旅游线路,三峡旅游报价,三峡游景点,三峡游船预定"; webMeta.Description = "重庆三峡旅游行程、三峡游线路、长江三峡旅游报价由重庆中国青年旅行社提供设计,重庆青旅热线400-017-5761."; } } } else { ClassLibrary.BLL.RouteType rtBll = new ClassLibrary.BLL.RouteType(); List <ClassLibrary.Model.RouteType> rtList = rtBll.GetModelList("classNamePy='" + ping + "'"); if (rtList.Count > 0) { ClassLibrary.Model.RouteType rtc = rtList[0]; webMeta.Title = string.Format("{0}旅游线路_重庆出发{0}旅游报价", rtc.ClassName.Replace("游", "")) + tmpTitle; webMeta.Keyword = string.Format("{0}旅游,{0}旅游报价,{0}旅游线路", rtc.ClassName.Replace("游", "")); webMeta.Description = string.Format("重庆中国青年旅行社设计{0}旅游线路行程,重庆出发{0}旅游最新报价,{0}跟团游价格,重庆出发{0}旅游选择青旅品质服务享受旅途,重庆青旅热线400-017-5761.", rtc.ClassName.Replace("游", "")); } } } else if (url.IndexOf("approutedetail.aspx") > -1) { int id = Convert.ToInt32(Function.GetQueryString("id")); ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes(); ClassLibrary.Model.Routes rModel = routeBll.GetModel(id); webMeta.Title = rModel.Title + tmpTitle; if (rModel.SeoTitle != null && rModel.SeoTitle.Trim() != "") { webMeta.Title = rModel.SeoTitle; } webMeta.Keyword = rModel.SeoKeywords; if (webMeta.Keyword == "") { webMeta.Keyword = rModel.Title; } webMeta.Description = rModel.SeoDescription; if (webMeta.Description == "") { webMeta.Description = Function.Clip(Function.ClearHtml(rModel.RouteFeature + rModel.DescriptionRoute).Replace(" ", "").Replace(" ", ""), 80, false); } } else if (url.IndexOf("appabout.aspx") > -1) { webMeta.Title = "重庆中国青年旅行社简介"; webMeta.Keyword = ""; webMeta.Description = ""; } else if (url.IndexOf("apparticlelist.aspx") > -1) { string strId = Function.GetQueryString("id"); if (strId != "") { int classid = Convert.ToInt32(strId); if (classid == (int)SysConfig.NewsClass.旅游资讯) { webMeta.Title = "重庆旅行社旅游资讯_最新旅游资讯指南" + tmpTitle; webMeta.Description = "重庆旅游资讯,重庆旅游指南,旅游最新资讯,重庆旅行社资讯"; webMeta.Keyword = "重庆青年旅行社旅游资讯大致包含旅行社资讯,旅游相关实时新闻,旅游行业最新资讯消息,重庆以及周边旅游指南,重庆中青旅一如既往的高品质服务游客."; } else if (classid == (int)SysConfig.NewsClass.旅游攻略) { webMeta.Title = "重庆旅行社旅游攻略_最新旅游攻略" + tmpTitle; webMeta.Description = "重庆旅游攻略,重庆旅游指南,旅游最新攻略"; webMeta.Keyword = "重庆青年旅行社旅游攻略大致包含旅游的吃、住、行、游、购、娱方面的介绍以及方式方法,重庆青旅更新的旅游攻略内容板块将更加方便您的出游."; } } else { webMeta.Title = "旅游攻略网_旅游景点网_最新旅游指南_重庆中国青年旅行社"; webMeta.Keyword = "旅游攻略网,旅游景点网,最新旅游指南"; webMeta.Description = "重庆中国青年旅行社旅游攻略网旅游景点网提供各种旅游攻略,旅游景点排行,最新旅游资讯,旅游景点推荐,详情请咨询中青旅400-017-5761"; } } else if (url.IndexOf("apparticledetail.aspx") > -1) { int id = Convert.ToInt32(Function.GetQueryString("id")); ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News(); ClassLibrary.Model.News rModel = newsBll.GetModel(id); webMeta.Title = rModel.Title + tmpTitle; webMeta.Keyword = rModel.Keywords; if (webMeta.Keyword == "") { webMeta.Keyword = rModel.Title; } webMeta.Description = rModel.Description; if (webMeta.Description == "") { webMeta.Description = Function.Clip(Function.ClearHtml(rModel.Description).Replace(" ", "").Replace(" ", ""), 80, false); } } else if (url.IndexOf("appnav.aspx") > -1) { webMeta.Title = "旅游目的地导航" + tmpTitle; webMeta.Keyword = ""; webMeta.Description = ""; } else if (url.IndexOf("apporder.aspx") > -1) { webMeta.Title = "订单提交信息" + tmpTitle; webMeta.Keyword = ""; webMeta.Description = ""; } else if (url.IndexOf("appshopcart.aspx") > -1) { webMeta.Title = "旅游订单信息" + tmpTitle; webMeta.Keyword = ""; webMeta.Description = ""; } else if (url.IndexOf("appsaleslist.aspx") > -1) { webMeta.Title = "特价旅游专区_最划算的旅游" + tmpTitle; webMeta.Keyword = "青旅特价旅游,特价旅游旅行社,重庆旅行社特价团"; webMeta.Description = "重庆中国青年旅行社特价旅游专区产品为限时限量旅游线路,由于游客临时退位置或者旅行社原因,导致紧急处理的旅游产品,在整个旅游行业可以说是性价比最高,超级划算的特价旅游产品."; } }
private void BindData() { searchKey = Function.GetQueryString("key"); int routeClassID = -1; string strWhere = "1=1 "; //搜索 - 大类 searchClass1 = Function.GetQueryString("cid1"); if (Function.IsNumber(searchClass1)) { routeClassID = Convert.ToInt32(searchClass1); } //搜索 - 小类 searchClass2 = Function.GetQueryString("cid2"); if (Function.IsNumber(searchClass2)) { routeClassID = Convert.ToInt32(searchClass2); } //跟据传过来的类别ID if (routeClassID != -1) { strWhere += " AND LinkClass = " + routeClassID; } if (!string.IsNullOrEmpty(searchKey)) { strWhere += " AND CHARINDEX('" + searchKey + "',LinkUrl)>0"; } DataSet mySet = linksBLL.GetPageData(pageSize, pageIndex, strWhere, "CreatedTime Desc"); DataTable tableCount = mySet.Tables["Count"]; DataTable myTable = mySet.Tables["Data"]; int countRows = 0; countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString()); string[] urlParam = { "key", "cid1", "cid2" }; pageInfo = pg.pageForDynamic(countRows, pageSize, pageIndex, urlParam); StringBuilder sb = new StringBuilder(); int i = 0; int rowIndex = 0; foreach (DataRow dr in myTable.Rows) { i++; rowIndex = pageSize * (pageIndex - 1) + i; sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString()); sb.AppendFormat("<td align='center'><input type='checkbox' name='linksCheckbox' id='checkbox{0}' value='{0}' /></td>", dr["ID"].ToString()); sb.AppendFormat("<td align='center'>{0}</td>", rowIndex); sb.AppendFormat("<td>{0}</td>", dr["Title"].ToString()); sb.AppendFormat("<td>{0}</td>", dr["LinkURL"].ToString()); string className = "首页"; if (dr["LinkClass"].ToString() != "0") { ClassLibrary.Model.RouteClass tclass = list.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(dr["LinkClass"].ToString())); }); className = tclass.ClassName; } sb.AppendFormat("<td>{0}</td>", className); sb.AppendFormat("<td align='center'>{0}</td>", dr["CreatedTime"].ToString()); sb.Append("<td align='center'>"); sb.AppendFormat("<a href='LinksEdit.aspx?id={0}'>修改</a> ", dr["ID"].ToString()); sb.AppendFormat("<a href='javascript:void(0)' onclick='linksDelete({0})'>删除</a>", dr["ID"].ToString()); sb.Append("</td>"); sb.Append("</tr>"); } if (sb.Length == 0) { sb.Append("<tr><td colspan='5'>没有相关数据</td></tr>"); } linksList = sb.ToString(); }
//线路信息 private void BindInfo() { route = bll.GetModel(routeID); if (route.routesClassID == "") { Response.StatusCode = 404; Response.End(); } gList = rcBLL.GetModelList(String.Empty); if (route.ThemeID != "") { ClassLibrary.Model.RouteType classmodel = rtBll.GetModel(Convert.ToInt32(route.ThemeID.Split(',')[0])); if (classmodel != null) { themeName = string.Format("<div class='info_zhuti'><a href='{0}/{1}/' target='_blank'>{2}</a></div>", SysConfig.webSite, classmodel.classNamePY, classmodel.ClassName); } } routeClassId = route.LocationID; traffic = route.TrafficModel; if (traffic.IndexOf("自理") > -1) { traffic = traffic.Replace("自理去", "").Replace("自理回", "").Trim(); } ClassLibrary.Model.RouteClass curClass = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); }); pingYin = curClass.ClassNamePY; if (curClass.ClassLevel == 4) { parentId = curClass.ParentID; displayName = curClass.ClassName; displayPy = curClass.ClassNamePY; } else if (curClass.ID == (int)SysConfig.RouteClass.峡旅游 || curClass.ParentID == (int)SysConfig.RouteClass.峡旅游 || curClass.ParentID == (int)SysConfig.RouteClass.豪华船) { parentId = (int)SysConfig.RouteClass.峡旅游; displayName = "三峡"; displayPy = "sanxia"; } else { parentId = curClass.ID; displayName = curClass.ClassName; displayPy = curClass.ClassNamePY; } if (pingYin != comePY) { Response.StatusCode = 404; Response.End(); } //购买事件 buyEventStr = string.Format("buy2('{0}','{1}','{2}','{3}')", route.ID, Function.Clip(route.Title, 18, true), route.RouteTime, pingYin); dateType = route.DateType; price = Convert.ToInt32(route.Price); childPrice = Convert.ToInt32(route.ChildPrice); routeFeature = route.RouteFeature; descriptionPrice = route.DescriptionPrice; routeNotice = route.RouteNotice; detailType = route.DetailType; if (price == 0) { strPrice = "电询"; } else { strPrice = "¥<em>" + price + "</em>起"; } datePrice = ""; if (route.DatePrice != "") { string[] tmpDatePrice = route.DatePrice.Split('|'); string cDate = DateTime.Now.ToShortDateString().ToString(); for (int k = 0; k < tmpDatePrice.Length; k++) { string tmpPrices = tmpDatePrice[k]; if (tmpPrices == "") { continue; } string[] tmpPrice = tmpPrices.Split(','); TimeSpan ts = DateTime.Parse(tmpPrice[0]) - DateTime.Now; if (ts.TotalDays > 0) { datePrice += tmpPrices + "|"; } } } StringBuilder sb = new StringBuilder(); string[] imgs = route.Image.Split(','); if (imgs.Length <= 3) { inactive = "inactive"; } int imgIndex = 0; foreach (string img in imgs) { imgIndex++; if (imgIndex == 1) { firstImg = ClassLibrary.Common.SysConfig.UploadFilePathRoutesImg + img; } sb.AppendFormat("<li class='{1}'><i></i><img src='{0}' alt='' width='100' height='63' /></li>", ClassLibrary.Common.SysConfig.UploadFilePathRoutesImg + img, imgIndex == 1 ? "on" : ""); } smallImageList = sb.ToString(); }