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