protected void Page_Load(object sender, EventArgs e) { xc.CheckAdminLogin("|adsAdd|"); if (!IsPostBack) { FormCheck fCheck = new FormCheck(); pdateRegExpree.ValidationExpression = fCheck.RegExpressionValidator("dateTime", 0, 0, false); pdateRegExpree.ErrorMessage = fCheck.RegExpressionValidator("dateTime", 0, 0, true); eDateRegExpree.ValidationExpression = fCheck.RegExpressionValidator("dateTime", 0, 0, false); eDateRegExpree.ErrorMessage = fCheck.RegExpressionValidator("dateTime", 0, 0, true); httpRegExpree.ValidationExpression = fCheck.RegExpressionValidator("urlHttp", 0, 0, false); httpRegExpree.ErrorMessage = fCheck.RegExpressionValidator("urlHttp", 0, 0, true); wRegExpree.ValidationExpression = fCheck.RegExpressionValidator("number", 0, 0, false); wRegExpree.ErrorMessage = "宽度" + fCheck.RegExpressionValidator("number", 0, 0, true); hRegExpree.ValidationExpression = fCheck.RegExpressionValidator("number", 0, 0, false); hRegExpree.ErrorMessage = "高度" + fCheck.RegExpressionValidator("number", 0, 0, true); DateTime nStr = DateTime.Now; pDate.Text = nStr.ToString("yyyy-MM-dd HH:mm:ss"); eDate.Text = nStr.AddYears(1).ToString("yyyy-MM-dd HH:mm:ss"); XabaraClass xClass = new XabaraClass(); xClass.NewsTypeData("ads", adClass); this.adImg.Items.Add(new ListItem("图片:" + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "UploadImgType"), "Img")); this.adImg.Items.Add(new ListItem("Flash:" + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "UploadFlashType"), "Flash")); this.adImg.Items.Add(new ListItem("广告代码", "Code")); } }
protected void Page_Load(object sender, EventArgs e) { xc.CheckAdminLogin("|" + typeClss + "|"); if (!IsPostBack) { XabaraClass xClass = new XabaraClass(); xClass.NewsTypeData(typeClss, DropDownListClass); if (!string.IsNullOrEmpty(Session[typeClss] as string)) { this.DropDownListClass.Items.FindByValue(Session[typeClss].ToString().Trim()).Selected = true; } else { this.DropDownListClass.Items.FindByText("== 新增根分类 ==").Selected = true; } xClass.getTreeList(typeClss, treeList, string.Empty, "top", false, true, false); FormCheck fCheck = new FormCheck(); classListRegExpre.ValidationExpression = fCheck.RegExpressionValidator("number", 0, 0, false); classListRegExpre.ErrorMessage = fCheck.RegExpressionValidator("number", 0, 0, true); classUrlRegExpre.ValidationExpression = fCheck.RegExpressionValidator("urlHttp", 0, 0, false); classUrlRegExpre.ErrorMessage = fCheck.RegExpressionValidator("urlHttp", 0, 0, true); titleClass.Text = Server.UrlDecode(xc.SafeSql(Request["title"])); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); XabaraClass xClass = new XabaraClass(); xc.CheckAdminLogin(""); DataTable dt = db.getDataTable("select Tid,TreeType from newsTree order by Tid"); for (int i = 0; i < dt.Rows.Count; i++) { long cid = xc.SafeNum(dt.Rows[i]["Tid"].ToString().Trim()); xClass.treeNameUpdate(cid); xClass.updateID(dt.Rows[i]["TreeType"].ToString().Trim(), cid); Response.Write("正在更新第 " + cid.ToString() + " 条<br />"); Response.Flush(); } dt.Dispose(); Response.Write("更新全站缓存完成!"); }
protected void Page_Load(object sender, EventArgs e) { xc.CheckAdminLogin(string.Empty); XabaraClass xClass = new XabaraClass(); if (!IsPostBack) { string uidTemp = xc.adminID; Uid.Text = uidTemp; xClass.NewsTypeData("department", adminClass); string strSql = "select * from AdminUser where userID='" + uidTemp + "'"; DataTable dt = db.getDataTable(strSql); if (dt.Rows.Count > 0) { adminName.Text = dt.Rows[0]["UserName"].ToString().Trim(); int cID = Convert.ToInt32(dt.Rows[0]["classID"].ToString().Trim()); string cidName = xClass.getClass(cID, string.Empty, string.Empty); if (string.IsNullOrEmpty(cidName as string)) { if (cID > 0) { cidName = "原分类已被删除,请重新选择!"; this.adminClass.Items.Add(new ListItem("== 请选择 ==", "")); this.adminClass.Items.FindByValue(string.Empty).Selected = true; } else { this.adminClass.Items.Add(new ListItem("超级管理员", "0")); this.adminClass.Items.FindByValue(cID.ToString()).Selected = true; } } else { this.adminClass.Items.FindByValue(cID.ToString()).Selected = true; } classLab.Text = cidName; if (dt.Rows[0]["UserAdmin"].ToString().Trim().Equals("xabaraCOM") && !string.IsNullOrEmpty(xc.SafeSql(Request["uid"]) as string)) { adminClass.Visible = true; adminClassValidator.Visible = true; } oldPWHidden.Value = dt.Rows[0]["UserPW"].ToString().Trim(); adminMail.Text = dt.Rows[0]["userEmail"].ToString().Trim(); adminTel.Text = dt.Rows[0]["userTel"].ToString().Trim(); adminMobile.Text = dt.Rows[0]["userMobile"].ToString().Trim(); adminQQ.Text = dt.Rows[0]["userQQ"].ToString().Trim(); } else { xc.divError("", "您的操作有误!", 350, 150, "userList.aspx", "goto"); } dt.Dispose(); FormCheck fCheck = new FormCheck(); adminNameRegularExpressionValidator.ValidationExpression = fCheck.RegExpressionValidator("chinese", 0, 0, false); adminNameRegularExpressionValidator.ErrorMessage = fCheck.RegExpressionValidator("chinese", 0, 0, true); adminPWRegularExpressionValidator.ValidationExpression = fCheck.RegExpressionValidator("passWord", 0, 0, false); adminPWRegularExpressionValidator.ErrorMessage = fCheck.RegExpressionValidator("passWord", 0, 0, true); mailRegularExpressionValidator.ValidationExpression = fCheck.RegExpressionValidator("email", 0, 0, false); mailRegularExpressionValidator.ErrorMessage = fCheck.RegExpressionValidator("email", 0, 0, true); telRegularExpressionValidator.ValidationExpression = fCheck.RegExpressionValidator("phone", 0, 0, false); telRegularExpressionValidator.ErrorMessage = fCheck.RegExpressionValidator("phone", 0, 0, true); mobileRegularExpressionValidator.ValidationExpression = fCheck.RegExpressionValidator("mobile", 0, 0, false); mobileRegularExpressionValidator.ErrorMessage = fCheck.RegExpressionValidator("mobile", 0, 0, true); qqRegularExpressionValidator.ValidationExpression = fCheck.RegExpressionValidator("qq", 0, 0, false); qqRegularExpressionValidator.ErrorMessage = fCheck.RegExpressionValidator("qq", 0, 0, true); } }
public static void writeMap(string _fullFileName, string mapPath) { dbDataFunction db = new dbDataFunction(); XabaraClass xClass = new XabaraClass(); DataTable dt; string strSql = string.Empty; string cidStr = string.Empty; string ifStr = string.Empty; string id = HttpContext.Current.Request.QueryString["id"]; string fullFileName = _fullFileName; string strLoc = string.Empty; string siteMapPath = mapPath; FileInfo XMLFile = null; StreamWriter writerXMLFile = null; XMLFile = new FileInfo(siteMapPath); writerXMLFile = XMLFile.CreateText(); //添加sitMap的头 writerXMLFile.WriteLine("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); if (id.Equals("google")) //google 加一句 { writerXMLFile.WriteLine("<urlset xmlns=\"http://www.google.com/schemas/sitemap/0.9\">"); } else { writerXMLFile.WriteLine("<urlset>"); } //频道各首页,每站固定格式 addXMLSitMap(writerXMLFile, fullFileName, 1.0); addXMLSitMap(writerXMLFile, fullFileName + "/default.htm", 0.8); addXMLSitMap(writerXMLFile, fullFileName + "/huabao/default.htm", 0.8); //所有分类读取 dt = db.getDataTable("select Tid from NewsTree where TreeType='taobaoke' order by ListID ASC,Tid ASC"); for (int i = 0; i < dt.Rows.Count; i++) { strLoc = fullFileName + "/" + dt.Rows[i]["Tid"].ToString().Trim() + ".htm"; addXMLSitMap(writerXMLFile, strLoc, 0.8); } dt.Dispose(); //商品读取 dt = db.getDataTable("select top 40000 num_iid from taobaoKe where isBad>0 order by isGood DESC,id ASC"); for (int i = 0; i < dt.Rows.Count; i++) { strLoc = fullFileName + "/show/" + dt.Rows[i]["num_iid"].ToString().Trim() + ".htm"; addXMLSitMap(writerXMLFile, strLoc, 0.8); } dt.Dispose(); //画报读取 dt = db.getDataTable("select top 5000 id from posterChannelTitle where flagID>0 order by weight DESC"); for (int i = 0; i < dt.Rows.Count; i++) { strLoc = fullFileName + "/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm"; addXMLSitMap(writerXMLFile, strLoc, 0.8); } dt.Dispose(); //添加sitMap的尾,千万不能忘了这句 writerXMLFile.WriteLine("</urlset>"); writerXMLFile.Close(); writerXMLFile.Dispose(); HttpContext.Current.Response.Write("<div style=\"text-align:left;padding:50px;font-size:14px;\"><strong>" + id + " sitemap 生成成功!请分别向以下免费搜索引擎提交:</strong><br /><br />向 ask.com 提交:<a href=\"http://submissions.ask.com/ping?sitemap=http://" + HttpContext.Current.Request.Url.Host + "/sitemap.xml\" target=\"_blank\" style=\"color:red;font-size:14px;\"><strong>点击向 ask.com 提交</strong></a><br /><br />向 bing 提交:<a href=\"http://cn.bing.com/webmaster/ping.aspx?sitemap=http://" + HttpContext.Current.Request.Url.Host + "/sitemap.xml\" target=\"_blank\" style=\"color:red;font-size:14px;\"><strong>点击向 bing 提交</strong></a><br /><br />向 Google 提交:<a href=\"http://www.google.com/webmasters/\" target=\"_blank\" style=\"color:red;font-size:14px;\"><strong>点击向 google 提交</strong></a>【需要申请google帐号登录后操作】</div>"); }
protected void Page_Load(object sender, EventArgs e) { xc.CheckAdminLogin("|adsEdit|"); if (!IsPostBack) { FormCheck fCheck = new FormCheck(); pdateRegExpree.ValidationExpression = fCheck.RegExpressionValidator("dateTime", 0, 0, false); pdateRegExpree.ErrorMessage = fCheck.RegExpressionValidator("dateTime", 0, 0, true); eDateRegExpree.ValidationExpression = fCheck.RegExpressionValidator("dateTime", 0, 0, false); eDateRegExpree.ErrorMessage = fCheck.RegExpressionValidator("dateTime", 0, 0, true); httpRegExpree.ValidationExpression = fCheck.RegExpressionValidator("urlHttp", 0, 0, false); httpRegExpree.ErrorMessage = fCheck.RegExpressionValidator("urlHttp", 0, 0, true); wRegExpree.ValidationExpression = fCheck.RegExpressionValidator("number", 0, 0, false); wRegExpree.ErrorMessage = "宽度" + fCheck.RegExpressionValidator("number", 0, 0, true); hRegExpree.ValidationExpression = fCheck.RegExpressionValidator("number", 0, 0, false); hRegExpree.ErrorMessage = "高度" + fCheck.RegExpressionValidator("number", 0, 0, true); XabaraClass xClass = new XabaraClass(); xClass.NewsTypeData("ads", adClass); string img = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "UploadImgType"); this.adImg.Items.Add(new ListItem(img, "Img")); string flash = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "UploadFlashType"); this.adImg.Items.Add(new ListItem(flash, "Flash")); this.adImg.Items.Add(new ListItem("广告代码", "Code")); DataTable dt = db.getDataTable("select * from ads where aID=" + xc.SafeNum(Request["id"]).ToString()); if (dt.Rows.Count > 0) { this.adClass.Items.FindByValue(dt.Rows[0]["classID"].ToString().Trim()).Selected = true; string fileName = dt.Rows[0]["adImg"].ToString().Trim(); upImg.Value = fileName; if (!string.IsNullOrEmpty(fileName as string)) { string fileExe = fileName.Substring(fileName.Length - 3); if (img.IndexOf(fileExe) > -1) { this.adImg.Items.FindByValue("Img").Selected = true; } else { this.adImg.Items.FindByValue("Flash").Selected = true; } } else { this.adImg.Items.FindByValue("Code").Selected = true; } adW.Text = dt.Rows[0]["adW"].ToString().Trim(); adH.Text = dt.Rows[0]["adH"].ToString().Trim(); adHttp.Text = dt.Rows[0]["adHttp"].ToString().Trim(); adCode.Text = dt.Rows[0]["adCode"].ToString().Trim(); pDate.Text = Convert.ToDateTime(dt.Rows[0]["starDate"].ToString().Trim()).ToString("yyyy-MM-dd HH:mm:ss"); eDate.Text = Convert.ToDateTime(dt.Rows[0]["stopDate"].ToString().Trim()).ToString("yyyy-MM-dd HH:mm:ss"); adCodeImg.Text = dt.Rows[0]["adCode"].ToString().Trim(); } else { xc.divError("", "您的操作有误!", 350, 150, "default.aspx", "goto"); } dt.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); xabaraAD ad = new xabaraAD(); XabaraClass xClass = new XabaraClass(); webPublic wp = new webPublic(); this.Page.Title = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webName") + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "titleMeta"); if (!IsPostBack) { DataTable dt; dt = db.getDataTable("select top 5 Tid,TreeName from NewsTree where taobaoKe<>'' order by newid() "); for (int i = 0; i < 5; i++) { ppRnd.Text += "<a href=\"/" + dt.Rows[i]["Tid"].ToString().Trim() + ".htm\" target=\"_blank\" title=\"查看 " + dt.Rows[i]["TreeName"].ToString().Trim() + "\" alt=\"查看 " + dt.Rows[i]["TreeName"].ToString().Trim() + "\">" + dt.Rows[i]["TreeName"].ToString().Trim() + "</a>"; if (i < 4) { ppRnd.Text += " <span class=\"headLine\">|</span> "; } } dt.Dispose(); ad468.Text = ad.getAdCode(0, 468, 60, 1, 0, true, string.Empty); long adID = 116; vipCode.Text = "<div class=\"divWidth\"><a href=\"/278.htm\" target=\"_blank\"><img src=\"/ad/images/okitch_20120630.gif\" /></a></div><div class=\"height5px\"></div>"; //淘画报 dt = db.getDataTable("select top 5 id,title,title_short,cover_pic_url_h,cover_pic_url_w from posterChannelTitle where flagID>0 and weight>10000 and modified_date>'" + DateTime.Now.AddDays(-7) + "' order by newid()"); if (dt.Rows.Count > 4) { HuaBaoLeft.Text = "<table cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px;\"><tr>"; string txtLink = string.Empty; for (int i = 0; i < 3; i++) { HuaBaoLeft.Text += "<td style=\"text-align:center; width:190px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\"><img src=\"" + dt.Rows[i]["cover_pic_url_h"].ToString().Trim() + "\" class=\"picHuaBaoH\" alt=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" title=\"" + dt.Rows[i]["title_short"].ToString().Trim() + "\" id=\"imghbh\" /></a></td>"; txtLink += "<td style=\"text-align:center; height:28px; line-height:28px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\" class=\"huabao\">" + dt.Rows[i]["title_short"].ToString().Trim() + "</a></td>"; } HuaBaoLeft.Text += "</tr><tr>" + txtLink + "</tr></table>"; HuaBaoRight.Text = "<table cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px;\"><tr>"; txtLink = string.Empty; for (int i = 3; i < 5; i++) { HuaBaoRight.Text += "<td style=\"text-align:center; width:190px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\"><img src=\"" + dt.Rows[i]["cover_pic_url_w"].ToString().Trim() + "\" class=\"picHuaBaoW\" alt=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" title=\"" + dt.Rows[i]["title_short"].ToString().Trim() + "\" id=\"imghbw\" /></a></td>"; txtLink += "<td style=\"text-align:center; height:32px; line-height:32px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\" class=\"huabao\">" + dt.Rows[i]["title_short"].ToString().Trim() + "</a></td>"; } HuaBaoRight.Text += "</tr><tr>" + txtLink + "</tr><tr><td colspan=\"2\" style=\"padding-top:5px;\"><table align=\"center\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px;width:98%;\"><tr><td style=\"text-align:left;\">" + ad.getAdCode(335, 0, 0, 3, 1, true, "") + "</td><td style=\"text-align:right;\">" + ad.getAdCode(334, 0, 0, 1, 0, true, "") + "</td></tr></table></td></tr></table>"; } else { huabao.Visible = false; } dt.Dispose(); //导航及产品 headMenu.Text = "<td valign=\"middle\" class=\"headBg2\"><a href=\"/\" target=\"_top\" class=\"head\">网站首页</a></td>"; dt = db.getDataTable("select Tid,TreeName from newsTree where TreeID=0 and TreeType='taobaoke' order by ListID ASC,Tid ASC"); for (int i = 0; i < dt.Rows.Count; i++) { string tid = dt.Rows[i]["Tid"].ToString().Trim(); string treeName = dt.Rows[i]["TreeName"].ToString().Trim(); //广告代码 adID += 1; string adCodeWidth = ad.getAdCode(adID, 0, 0, 1, 1, true, ""); int shopNums = 12; //每个版块读取商品数 if (!string.IsNullOrEmpty(adCodeWidth as string)) { adCodeWidth = "<div class=\"divWidth\">" + adCodeWidth + "</div>"; } string adCodeHeight = ad.getAdCode(adID + 8, 0, 0, 1, 1, true, ""); if (string.IsNullOrEmpty(adCodeHeight as string)) { DataTable ppDt = db.getDataTable("select top 22 Tid,TreeName from NewsTree where taobaoKe<>'' and idLayerStr like '%|" + tid + "|%' order by listID ASC,Tid ASC "); if (ppDt.Rows.Count > 0) { adCodeHeight = "<table cellspacing=\"0\" cellpadding=\"0\" style=\"width:100%;\" align=\"center\" class=\"indexTable\">"; for (int p = 0; p < ppDt.Rows.Count; p++) { adCodeHeight += "<tr><td><a href=\"/" + ppDt.Rows[p]["Tid"].ToString().Trim() + ".htm\" target=\"_blank\" title=\"查看 " + ppDt.Rows[p]["TreeName"].ToString().Trim() + "\" alt=\"查看 " + ppDt.Rows[p]["TreeName"].ToString().Trim() + "\" class=\"classID\">" + ppDt.Rows[p]["TreeName"].ToString().Trim() + "</a></td></tr>"; } adCodeHeight += "<tr><td style=\"text-align:right;\"><a href=\"/" + tid + ".htm\" target=\"_blank\" title=\"更多 " + treeName + " 品牌\" alt=\"更多 " + treeName + " 品牌\" class=\"classID\">>> 更多品牌</a></td></tr></table>"; } ppDt.Dispose(); } else { shopNums = 12; } //商品读取 string shopHtm = string.Empty; string ifStr = string.Empty; string cidStr = xClass.getClassAllID("taobaoke", xc.SafeNum(tid)); //得到所有ID if (cidStr.IndexOf(",") > 0) { string[] ids = cidStr.Split(new char[] { ',' }); int iiCount = ids.GetUpperBound(0); int readTop = 1; if (shopNums > iiCount-5) { readTop = 2; } for (int ii = 0; ii <= iiCount; ii++) { ifStr += " select top " + readTop.ToString() + " num_iid,title,pic_url,click_url,commission,price,volume from taobaoke where isBad>0 and isGood>0 and classID=" + ids[ii].ToString().Trim() + " order by volume DESC union "; } } else { ifStr = " select num_iid,title,pic_url,click_url,commission,price,volume from taobaoke where isBad>0 and isGood>0 and classID=" + tid + " union "; } ifStr = "(" + ifStr.Substring(0, ifStr.Length - 6) + ") as news"; string strSql = "select top " + shopNums.ToString() + " * from " + ifStr + " Order By newid()"; DataTable dtShop = db.getDataTable(strSql); //Response.Write(strSql); //Response.End(); shopHtm = string.Empty; for (int s = 0; s < dtShop.Rows.Count; s++) { shopHtm += "<td valign=\"top\" style=\"border-style: none solid solid none; border-width: 1px; border-color: #323232; text-align:center; width:200px;\"><a class=\"moneyLink\" href=\"/show/" + dtShop.Rows[s]["num_iid"].ToString().Trim() + ".htm\" target=\"_blank\" alt=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\" title=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\"><div style=\"position:absolute;\"><ul><li style=\"height:168px;\"></li><li class=\"moneyFont\" style=\"background-color:#323232; filter:Alpha(opacity=30);opacity:0.3; text-align:right; padding:5px; width:190px; color:#b8b8b8;\">" + xc.getMoney(dtShop.Rows[s]["price"].ToString().Trim()) + "</li></ul></div><img id=\"imgshow\" src=\"" + dtShop.Rows[s]["pic_url"].ToString().Trim() + "_310x310.jpg\" style=\"height:200px; width:200px;\" alt=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\" title=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\" /></a></td>"; if (s == 3 || s == 7) { shopHtm += "</tr><tr>"; } } dtShop.Dispose(); headMenu.Text += "<td valign=\"middle\" class=\"headBg1\"><a href=\"/" + tid + ".htm\" target=\"_top\" class=\"head\">" + treeName + "</a></td>"; //产品二级分类 string class2 = "<span class=\"headLine\">|</span> "; DataTable dtClass = db.getDataTable("select Tid,TreeName from newsTree where TreeID=" + tid + " and TreeType='taobaoke' order by ListID ASC,Tid ASC"); for (int c = 0; c < dtClass.Rows.Count; c++) { string classID = dtClass.Rows[c]["Tid"].ToString().Trim(); string className = dtClass.Rows[c]["TreeName"].ToString().Trim(); class2 += "<a href=\"/" + dtClass.Rows[c]["Tid"].ToString().Trim() + ".htm\" target=\"_blank\" title=\"查看 " + className + "\" alt=\"查看 " + className + "\">" + className + "</a> <span class=\"headLine\">|</span> "; } dtClass.Dispose(); shopList.Text += adCodeWidth; shopList.Text += "<div class=\"height5px\"></div>"; shopList.Text += "<div class=\"divWidth\"><table cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px; border-collapse:collapse; height:26px; width:100%;\"><tr><td style=\"width:125px; text-align:left;\"><img src=\"images/class" + tid + ".gif\" alt=\"" + treeName + "\" title=\"" + treeName + "\" /></td><td style=\"text-align:right; vertical-align:bottom; width:807px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap;\">" + class2 + "</td><td style=\"text-align:right; vertical-align:bottom; width:38px;\"><a href=\"/" + tid + ".htm\" target=\"_top\"><img src=\"images/more.gif\" alt=\"更多 " + treeName + "\" title=\"更多 " + treeName + "\" /></a></td></tr></table></div>"; shopList.Text += "<div class=\"divWidth\" style=\"height:2px; background-color:Black; font-size:0px;\"></div>"; shopList.Text += "<div class=\"divWidth\"><table cellspacing=\"0\" cellpadding=\"0\"><tr><td valign=\"top\" style=\"background-color:#323232; width:166px; text-align:center;\" rowspan=\"3\">" + adCodeHeight + "</td>" + shopHtm + "</tr></table></div>"; } headMenu.Text += "<td valign=\"middle\" class=\"headBg1\"><a href=\"/huabao/default.htm\" target=\"_top\" class=\"head\">图搜画报</a></td><td valign=\"middle\" class=\"headBg1\"><a href=\"/huabao/\" target=\"_top\" class=\"head\">画报淘宝</a></td>"; dt.Dispose(); //热搜关键词 string hot = XmlReader.GetConfig(HttpContext.Current.Server.MapPath("~/xabara.config"), "hotSearch"); string[] hotWord = hot.Split(new char[] { ',' }); for (int h = 0; h <= hotWord.GetUpperBound(0); h++) { hotSearch.Text += "<a href=\"/search.htm?keyWord=" + Server.UrlEncode(hotWord[h]) + "\" target=\"_top\" title=\"搜索 " + hotWord[h] + "\">" + hotWord[h] + "</a> "; } this.Page.MetaKeywords = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "KeyWord"); this.Page.MetaDescription = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "metaStr"); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); xabaraAD ad = new xabaraAD(); XabaraClass xClass = new XabaraClass(); webPublic wp = new webPublic(); this.Page.Title = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webName") + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "titleMeta"); if (!IsPostBack) { DataTable dt; dt = db.getDataTable("select top 5 Tid,TreeName from NewsTree where taobaoKe<>'' order by newid() "); for (int i = 0; i < 5; i++) { ppRnd.Text += "<a href=\"/" + dt.Rows[i]["Tid"].ToString().Trim() + ".htm\" target=\"_blank\" title=\"查看 " + dt.Rows[i]["TreeName"].ToString().Trim() + "\" alt=\"查看 " + dt.Rows[i]["TreeName"].ToString().Trim() + "\">" + dt.Rows[i]["TreeName"].ToString().Trim() + "</a>"; if (i < 4) { ppRnd.Text += " <span class=\"headLine\">|</span> "; } } dt.Dispose(); ad468.Text = ad.getAdCode(0, 468, 60, 1, 0, true, string.Empty); long adID = 116; vipCode.Text = "<div class=\"divWidth\"><a href=\"/278.htm\" target=\"_blank\"><img src=\"/ad/images/okitch_20120630.gif\" /></a></div><div class=\"height5px\"></div>"; //淘画报 dt = db.getDataTable("select top 5 id,title,title_short,cover_pic_url_h,cover_pic_url_w from posterChannelTitle where flagID>0 and weight>10000 and modified_date>'" + DateTime.Now.AddDays(-7) + "' order by newid()"); if (dt.Rows.Count > 4) { HuaBaoLeft.Text = "<table cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px;\"><tr>"; string txtLink = string.Empty; for (int i = 0; i < 3; i++) { HuaBaoLeft.Text += "<td style=\"text-align:center; width:190px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\"><img src=\"" + dt.Rows[i]["cover_pic_url_h"].ToString().Trim() + "\" class=\"picHuaBaoH\" alt=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" title=\"" + dt.Rows[i]["title_short"].ToString().Trim() + "\" id=\"imghbh\" /></a></td>"; txtLink += "<td style=\"text-align:center; height:28px; line-height:28px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\" class=\"huabao\">" + dt.Rows[i]["title_short"].ToString().Trim() + "</a></td>"; } HuaBaoLeft.Text += "</tr><tr>" + txtLink + "</tr></table>"; HuaBaoRight.Text = "<table cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px;\"><tr>"; txtLink = string.Empty; for (int i = 3; i < 5; i++) { HuaBaoRight.Text += "<td style=\"text-align:center; width:190px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\"><img src=\"" + dt.Rows[i]["cover_pic_url_w"].ToString().Trim() + "\" class=\"picHuaBaoW\" alt=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" title=\"" + dt.Rows[i]["title_short"].ToString().Trim() + "\" id=\"imghbw\" /></a></td>"; txtLink += "<td style=\"text-align:center; height:32px; line-height:32px;\"><a href=\"/huabao/show/" + dt.Rows[i]["id"].ToString().Trim() + ".htm\" target=\"_blank\" class=\"huabao\">" + dt.Rows[i]["title_short"].ToString().Trim() + "</a></td>"; } HuaBaoRight.Text += "</tr><tr>" + txtLink + "</tr><tr><td colspan=\"2\" style=\"padding-top:5px;\"><table align=\"center\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px;width:98%;\"><tr><td style=\"text-align:left;\">" + ad.getAdCode(335, 0, 0, 3, 1, true, "") + "</td><td style=\"text-align:right;\">" + ad.getAdCode(334, 0, 0, 1, 0, true, "") + "</td></tr></table></td></tr></table>"; } else { huabao.Visible = false; } dt.Dispose(); //导航及产品 headMenu.Text = "<td valign=\"middle\" class=\"headBg2\"><a href=\"/\" target=\"_top\" class=\"head\">网站首页</a></td>"; dt = db.getDataTable("select Tid,TreeName from newsTree where TreeID=0 and TreeType='taobaoke' order by ListID ASC,Tid ASC"); for (int i = 0; i < dt.Rows.Count; i++) { string tid = dt.Rows[i]["Tid"].ToString().Trim(); string treeName = dt.Rows[i]["TreeName"].ToString().Trim(); //广告代码 adID += 1; string adCodeWidth = ad.getAdCode(adID, 0, 0, 1, 1, true, ""); int shopNums = 12; //每个版块读取商品数 if (!string.IsNullOrEmpty(adCodeWidth as string)) { adCodeWidth = "<div class=\"divWidth\">" + adCodeWidth + "</div>"; } string adCodeHeight = ad.getAdCode(adID + 8, 0, 0, 1, 1, true, ""); if (string.IsNullOrEmpty(adCodeHeight as string)) { DataTable ppDt = db.getDataTable("select top 22 Tid,TreeName from NewsTree where taobaoKe<>'' and idLayerStr like '%|" + tid + "|%' order by listID ASC,Tid ASC "); if (ppDt.Rows.Count > 0) { adCodeHeight = "<table cellspacing=\"0\" cellpadding=\"0\" style=\"width:100%;\" align=\"center\" class=\"indexTable\">"; for (int p = 0; p < ppDt.Rows.Count; p++) { adCodeHeight += "<tr><td><a href=\"/" + ppDt.Rows[p]["Tid"].ToString().Trim() + ".htm\" target=\"_blank\" title=\"查看 " + ppDt.Rows[p]["TreeName"].ToString().Trim() + "\" alt=\"查看 " + ppDt.Rows[p]["TreeName"].ToString().Trim() + "\" class=\"classID\">" + ppDt.Rows[p]["TreeName"].ToString().Trim() + "</a></td></tr>"; } adCodeHeight += "<tr><td style=\"text-align:right;\"><a href=\"/" + tid + ".htm\" target=\"_blank\" title=\"更多 " + treeName + " 品牌\" alt=\"更多 " + treeName + " 品牌\" class=\"classID\">>> 更多品牌</a></td></tr></table>"; } ppDt.Dispose(); } else { shopNums = 12; } //商品读取 string shopHtm = string.Empty; string ifStr = string.Empty; string cidStr = xClass.getClassAllID("taobaoke", xc.SafeNum(tid)); //得到所有ID if (cidStr.IndexOf(",") > 0) { string[] ids = cidStr.Split(new char[] { ',' }); int iiCount = ids.GetUpperBound(0); int readTop = 1; if (shopNums > iiCount - 5) { readTop = 2; } for (int ii = 0; ii <= iiCount; ii++) { ifStr += " select top " + readTop.ToString() + " num_iid,title,pic_url,click_url,commission,price,volume from taobaoke where isBad>0 and isGood>0 and classID=" + ids[ii].ToString().Trim() + " order by volume DESC union "; } } else { ifStr = " select num_iid,title,pic_url,click_url,commission,price,volume from taobaoke where isBad>0 and isGood>0 and classID=" + tid + " union "; } ifStr = "(" + ifStr.Substring(0, ifStr.Length - 6) + ") as news"; string strSql = "select top " + shopNums.ToString() + " * from " + ifStr + " Order By newid()"; DataTable dtShop = db.getDataTable(strSql); //Response.Write(strSql); //Response.End(); shopHtm = string.Empty; for (int s = 0; s < dtShop.Rows.Count; s++) { shopHtm += "<td valign=\"top\" style=\"border-style: none solid solid none; border-width: 1px; border-color: #323232; text-align:center; width:200px;\"><a class=\"moneyLink\" href=\"/show/" + dtShop.Rows[s]["num_iid"].ToString().Trim() + ".htm\" target=\"_blank\" alt=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\" title=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\"><div style=\"position:absolute;\"><ul><li style=\"height:168px;\"></li><li class=\"moneyFont\" style=\"background-color:#323232; filter:Alpha(opacity=30);opacity:0.3; text-align:right; padding:5px; width:190px; color:#b8b8b8;\">" + xc.getMoney(dtShop.Rows[s]["price"].ToString().Trim()) + "</li></ul></div><img id=\"imgshow\" src=\"" + dtShop.Rows[s]["pic_url"].ToString().Trim() + "_310x310.jpg\" style=\"height:200px; width:200px;\" alt=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\" title=\"" + dtShop.Rows[s]["title"].ToString().Trim() + "\" /></a></td>"; if (s == 3 || s == 7) { shopHtm += "</tr><tr>"; } } dtShop.Dispose(); headMenu.Text += "<td valign=\"middle\" class=\"headBg1\"><a href=\"/" + tid + ".htm\" target=\"_top\" class=\"head\">" + treeName + "</a></td>"; //产品二级分类 string class2 = "<span class=\"headLine\">|</span> "; DataTable dtClass = db.getDataTable("select Tid,TreeName from newsTree where TreeID=" + tid + " and TreeType='taobaoke' order by ListID ASC,Tid ASC"); for (int c = 0; c < dtClass.Rows.Count; c++) { string classID = dtClass.Rows[c]["Tid"].ToString().Trim(); string className = dtClass.Rows[c]["TreeName"].ToString().Trim(); class2 += "<a href=\"/" + dtClass.Rows[c]["Tid"].ToString().Trim() + ".htm\" target=\"_blank\" title=\"查看 " + className + "\" alt=\"查看 " + className + "\">" + className + "</a> <span class=\"headLine\">|</span> "; } dtClass.Dispose(); shopList.Text += adCodeWidth; shopList.Text += "<div class=\"height5px\"></div>"; shopList.Text += "<div class=\"divWidth\"><table cellspacing=\"0\" cellpadding=\"0\" style=\"border-width:0px; border-collapse:collapse; height:26px; width:100%;\"><tr><td style=\"width:125px; text-align:left;\"><img src=\"images/class" + tid + ".gif\" alt=\"" + treeName + "\" title=\"" + treeName + "\" /></td><td style=\"text-align:right; vertical-align:bottom; width:807px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap;\">" + class2 + "</td><td style=\"text-align:right; vertical-align:bottom; width:38px;\"><a href=\"/" + tid + ".htm\" target=\"_top\"><img src=\"images/more.gif\" alt=\"更多 " + treeName + "\" title=\"更多 " + treeName + "\" /></a></td></tr></table></div>"; shopList.Text += "<div class=\"divWidth\" style=\"height:2px; background-color:Black; font-size:0px;\"></div>"; shopList.Text += "<div class=\"divWidth\"><table cellspacing=\"0\" cellpadding=\"0\"><tr><td valign=\"top\" style=\"background-color:#323232; width:166px; text-align:center;\" rowspan=\"3\">" + adCodeHeight + "</td>" + shopHtm + "</tr></table></div>"; } headMenu.Text += "<td valign=\"middle\" class=\"headBg1\"><a href=\"/huabao/default.htm\" target=\"_top\" class=\"head\">图搜画报</a></td><td valign=\"middle\" class=\"headBg1\"><a href=\"/huabao/\" target=\"_top\" class=\"head\">画报淘宝</a></td>"; dt.Dispose(); //热搜关键词 string hot = XmlReader.GetConfig(HttpContext.Current.Server.MapPath("~/xabara.config"), "hotSearch"); string[] hotWord = hot.Split(new char[] { ',' }); for (int h = 0; h <= hotWord.GetUpperBound(0); h++) { hotSearch.Text += "<a href=\"/search.htm?keyWord=" + Server.UrlEncode(hotWord[h]) + "\" target=\"_top\" title=\"搜索 " + hotWord[h] + "\">" + hotWord[h] + "</a> "; } this.Page.MetaKeywords = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "KeyWord"); this.Page.MetaDescription = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "metaStr"); } }