protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); Response.Clear(); Response.Write(xc.regUserCode()); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); xc.CheckAdminLogin(""); if (!IsPostBack) { this.CreateUserPage("http://" + Request.Url.Host + "/default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); xc.CheckAdminLogin(""); if (!IsPostBack) { ad.Text = "<iframe src=\"http://" + Request.Url.Host + "/ad/?size=300\" scrolling=\"no\" frameborder=\"0\" height=\"300px\" width=\"300px\" marginheight=\"0px\" marginwidth=\"0px\"></iframe>"; adView.Text = ad.Text; } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); if (!IsPostBack) { //导航及产品 bottomNav.Text = "<a href=\"/\" target=\"_top\">网站首页</a> <span class=\"headLine\">|</span> <a href=\"http://s.click.taobao.com/t_9?p=mm_14288563_0_0&l=http%3A%2F%2Ftemai.tmall.com\" target=\"_blank\">品牌特卖</a>"; DataTable 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(); bottomNav.Text += " <span class=\"headLine\">|</span> <a href=\"/" + tid + ".htm\" target=\"_top\">" + treeName + "</a>"; } dt.Dispose(); miibeian.Text = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "miibeian"); webTitle.Text = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webName"); webVer.Text = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webVer"); yearLab.Text = DateTime.Now.Year.ToString(); countStr.Text = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "countScript"); string qqID = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "qq"); qqLink.Text = xc.QQHTM(qqID, "41"); string tbID = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobao"); tbLink.Text = xc.taobaoHTM(tbID, "1"); string tel = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "freePhone"); if (!string.IsNullOrEmpty(tel as string)) { telInfo.Text = tel + " "; } tel = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "mobile"); if (!string.IsNullOrEmpty(tel as string)) { telInfo.Text += tel + " "; } tel = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webTel"); if (!string.IsNullOrEmpty(tel as string)) { telInfo.Text += tel + " "; } appKey = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeAppKey"); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); if (!IsPostBack) { long adSize = xc.SafeNum(Request.QueryString["size"]); if (adSize < 1) { adSize = 300; } double topSql = Math.Ceiling(adSize / 37.5); if (topSql % 2 == 1) { topSql -= 1; } adSize = adSize - 2; adSizeStr = adSize.ToString(); string f = Request.QueryString["f"]; if (!string.IsNullOrEmpty(f as string)) { fontColor = f; } string c = Request.QueryString["c"]; if (!string.IsNullOrEmpty(c as string)) { bgColor = c; } string a = Request.QueryString["a"]; if (!string.IsNullOrEmpty(a as string)) { alpha = a; } string strSql = "select top " + topSql.ToString() + " * from (select title,nick,pic_url,price,click_url,shop_click_url from taobaoKe where isBad>0 and commission>0 and isGood>0) as newGood order by newid()"; DataTable dt = db.getDataTable(strSql); if (dt.Rows.Count < 1) { strSql = "select top " + topSql.ToString() + " * from (select top 100 title,nick,pic_url,price,click_url,shop_click_url from taobaoKe where isBad>0 and commission>0 order by volume DESC) as news order by newid()"; dt = db.getDataTable(strSql); } for (int i = 0; i < dt.Rows.Count; i++) { string pic = dt.Rows[i]["pic_url"].ToString().Trim() + "_310x310.jpg"; kinSlideshow.Text += "<a href=\"" + dt.Rows[i]["click_url"].ToString().Trim() + "\" target=\"_blank\"><img src=\"" + pic + "\" style=\"height:" + adSizeStr + "px; width:" + adSizeStr + "px;\" alt=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" title=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" /></a>"; } dt.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc=new XabaraCom(); dbDataFunction db = new dbDataFunction(); if (!IsPostBack) { long adSize = xc.SafeNum(Request.QueryString["size"]); if (adSize < 1) { adSize = 300; } double topSql = Math.Ceiling(adSize / 37.5); if (topSql % 2 == 1) { topSql -= 1; } adSize = adSize - 2; adSizeStr = adSize.ToString(); string f = Request.QueryString["f"]; if (!string.IsNullOrEmpty(f as string)) { fontColor = f; } string c = Request.QueryString["c"]; if (!string.IsNullOrEmpty(c as string)) { bgColor = c; } string a = Request.QueryString["a"]; if (!string.IsNullOrEmpty(a as string)) { alpha = a; } string strSql = "select top " + topSql.ToString() + " * from (select title,nick,pic_url,price,click_url,shop_click_url from taobaoKe where isBad>0 and commission>0 and isGood>0) as newGood order by newid()"; DataTable dt = db.getDataTable(strSql); if (dt.Rows.Count < 1) { strSql = "select top " + topSql.ToString() + " * from (select top 100 title,nick,pic_url,price,click_url,shop_click_url from taobaoKe where isBad>0 and commission>0 order by volume DESC) as news order by newid()"; dt = db.getDataTable(strSql); } for (int i = 0; i < dt.Rows.Count; i++) { string pic = dt.Rows[i]["pic_url"].ToString().Trim() + "_310x310.jpg"; kinSlideshow.Text += "<a href=\"" + dt.Rows[i]["click_url"].ToString().Trim() + "\" target=\"_blank\"><img src=\"" + pic + "\" style=\"height:" + adSizeStr + "px; width:" + adSizeStr + "px;\" alt=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" title=\"" + dt.Rows[i]["title"].ToString().Trim() + "\" /></a>"; } dt.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); xc.CheckAdminLogin("|adsDel|"); dbDataFunction db = new dbDataFunction(); string returnValue = string.Empty; long idTemp = xc.SafeNum(Request["id"].Trim()); returnValue = db.DelDB("ads", "aID", xc.SafeSql(Request["id"].Trim()).ToString(), string.Empty, false, "adImg"); xc.insertMyLog(xc.adminID, "admin", "删除广告"); xc.divError("", returnValue, 350, 150, Server.UrlDecode(xc.errorUrlTwo), "goto"); }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); xc.CheckAdminLogin(string.Empty); Page.Title = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webName") + " 管理系统"; if (!IsPostBack) { LgName.Text = HttpUtility.UrlDecode(Request.Cookies["XabaraAdmin"]["AdminName"].Trim()) + "[" + xc.adminID + "]"; lgNum.Text = Request.Cookies["XabaraAdmin"]["AdminLgNums"].ToString().Trim(); timeJS.Text = xc.getDataTime(1, 1, 0); qqLink.Text = xc.QQHTM("839808029", "41"); SoftVer.Text = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webName") + " " + xc.XabaraVer.ToString().Trim(); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); xc.CheckAdminLogin("|adminDel|"); if (!xc.adminID.Equals(xc.SafeSql(Request["id"].Trim()).ToString())) { string returnValue = new dbDataFunction().DelDB("AdminUser", "UserId", xc.SafeSql(Request["id"].Trim()).ToString(), string.Empty, false, string.Empty); xc.insertMyLog(xc.adminID, "admin", "删除管理员"); xc.divError("", returnValue, 350, 150, "userList.aspx", "goto"); } else { xc.divError("", "不会吧,删除自己呀!", 350, 150, "userList.aspx", "goto"); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); xc.CheckAdminLogin("|adminPW|"); string idTemp = xc.SafeNum(Request["id"].Trim()).ToString(); string dimStr = "@UserPW"; string[] strValue = new string[1]; string strVlaueTemp = xc.GetRnd("abc", 1) + xc.GetRnd("abc123", 7).ToLower(); strValue[0] = xc.GetMd5(strVlaueTemp).ToString(); if (new dbDataFunction().InsertUpdateDB("AdminUser", dimStr, strValue, "Uid=" + idTemp + " and UserId<>'" + xc.adminID + "'").Equals("更新成功")) { xc.insertMyLog(xc.adminID, "admin", "管理员密码初始化"); xc.divError("", "新密码:" + strVlaueTemp, 350, 150, "userList.aspx", "goto"); } else { xc.divError("", "不能给自己密码初始化或操作错误!", 350, 150, "userList.aspx", "goto"); } }
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) { XabaraCom xc = new XabaraCom(); xc.CheckAdminLogin(""); dbDataFunction db = new dbDataFunction(); Response.Write("自动清除淘画报,如出现死机或出错,重新点击自动更新即可;<br /><br />"); Response.Flush(); //清除低佣金的画报 db.exeSql("delete from taobaoKe where commission<5 and classID=0 and postDate<'" + DateTime.Now.AddDays(-15).ToString() + "'"); //清除无佣金商品 db.exeSql("delete from taobaoKe where isBad=0 and poster_id>0 and classID=0"); DataTable dt = db.getDataTable("select id,title from posterChannelTitle order by tID DESC"); for (int i = 0; i < dt.Rows.Count; i++) { string idTemp = dt.Rows[i]["id"].ToString().Trim(); string strSql = "select title from taobaoKe left join posterTkID on taobaoKe.num_iid=posterTkID.tK_num_iid where taobaoKe.isBad>0 and posterTkID.title_id=" + idTemp.ToString() + " order by commission DESC,volume DESC"; DataTable ifDt = db.getDataTable(strSql); if (ifDt.Rows.Count < 10) { db.DelDB("posterChannelTitle", "id", idTemp.ToString(), "", false, ""); db.DelDB("posterTkID", "title_id", idTemp.ToString(), "", false, ""); Response.Write("自动清除 " + dt.Rows[i]["title"].ToString().Trim() + " 成功!<br />"); Response.Flush(); } ifDt.Dispose(); } dt.Dispose(); Response.Write("自动清除淘画报完成!<br /><br />"); Response.Flush(); }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); string title = "找店铺 ZDianPU.com"; if (!IsPostBack) { long idTemp = xc.SafeNum(Request.QueryString["id"]); if (idTemp < 1) { string urlID = Page.RouteData.Values["sID"].ToString(); urlID = urlID.Replace(".htm", ""); idTemp = xc.SafeNum(urlID); } DataTable dt = db.getDataTable("select title,pic_url,click_url from taobaoKe where num_iid=" + idTemp.ToString()); if (dt.Rows.Count > 0) { title = dt.Rows[0]["title"].ToString().Trim(); linkWebName.Text = title; urlStr = dt.Rows[0]["click_url"].ToString().Trim(); img.Text = "<a href=\"" + urlStr + "\"><img id=\"imgshow\" src=\"" + dt.Rows[0]["pic_url"].ToString().Trim() + "\" style=\"width:350px; height:350px;\" title=\"" + title + "\" alt=\"" + title + "\" /></a>"; linkWebUrl.NavigateUrl = urlStr; } else { Response.Redirect("http://s.click.taobao.com/t_9?p=mm_14288563_0_0&l=http%3A%2F%2Fwww.tmall.com", true); } dt.Dispose(); xc.webMeta(Page, title, XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "metaStr")); countStr.Text = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "countScript"); } this.Page.Title = title + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webName") + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "titleMeta"); }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); xc.CheckAdminLogin(""); DataTable dt; string appkey = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeAppKey"); if (string.IsNullOrEmpty(appkey as string)) { Response.Redirect("../frame/otherSet.aspx", true); } string appsecret = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeAppSecret"); string url = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeUrl"); string alimamaID = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeAlimamaID"); //淘宝客推广ID ITopClient client = new DefaultTopClient(url, appkey, appsecret); PosterChannelsGetRequest req = new PosterChannelsGetRequest(); PosterChannelsGetResponse response = client.Execute(req); Response.Write("自动同步淘画报频道ID,如出现死机或出错,重新点击自动更新即可;<br />"); Response.Flush(); string strDim = "@id,@channel_name,@name_en,@description,@postID,@postDate,@postIP,@isFlag"; string[] strValue = new string[7]; for (int ii = 0; ii < response.Channels.Count; ii++) { strValue[0] = response.Channels[ii].Id.ToString(); strValue[1] = response.Channels[ii].ChannelName.ToString(); strValue[2] = response.Channels[ii].NameEn.ToString(); if (string.IsNullOrEmpty(response.Channels[ii].Description as string)) { strValue[3] = string.Empty; } else { strValue[3] = response.Channels[ii].Description; } strValue[4] = xc.adminID; strValue[5] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); strValue[6] = xc.GetIP(); dt = db.getDataTable("select * from posterChannelIDs where id=" + response.Channels[ii].Id.ToString()); //防止重复插入 if (dt.Rows.Count > 0) { strDim = "@id,@channel_name,@name_en,@description,@postID,@postDate,@postIP"; db.InsertUpdateDB("posterChannelIDs", strDim, strValue, "id=" + response.Channels[ii].Id.ToString()); } else { db.InsertUpdateDB("posterChannelIDs", strDim, strValue, string.Empty); } dt.Dispose(); Response.Write("同步 " + strValue[1] + " [" + strValue[2] + "] " + " 已完成;<br />"); Response.Flush(); } //宝贝同步结束 }
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"); } }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); dbDataFunction db = new dbDataFunction(); xc.CheckAdminLogin(""); DataTable dt; string appkey = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeAppKey"); if (string.IsNullOrEmpty(appkey as string)) { Response.Redirect("../frame/otherSet.aspx", true); } string appsecret = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeAppSecret"); string url = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeUrl"); string alimamaID = XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "taobaoKeAlimamaID"); //淘宝客推广ID Response.Write("自动同步淘画报,如出现死机或出错,重新点击自动更新即可;<br /><br />"); Response.Flush(); string requestType = Request.QueryString["type"]; ITopClient client = new DefaultTopClient(url, appkey, appsecret); PosterPostersSearchRequest req = new PosterPostersSearchRequest(); req.PageSize = 20L; req.PageNo = 1L; req.EditorRecommend = 1L; req.SortType = 4L; string strDim = "@id,@channel_id,@cover_pic_url_w,@cover_pic_url_h,@title,@title_short,@tag,@hits,@weight,@create_date,@modified_date,@isGood,@postID,@postIP,@postDate,@flagID"; string[] strValue = new string[30]; string posterId = string.Empty; dt = db.getDataTable("select id from posterChannelIDs where isFlag>0 order by newid()"); for (int i = 0; i < dt.Rows.Count; i++) { //获取画报标题 req.ChannelIds = dt.Rows[i]["id"].ToString().Trim(); PosterPostersSearchResponse response = client.Execute(req); for (int ii = 0; ii < response.Posters.Count; ii++) { strValue[0] = response.Posters[ii].Id.ToString(); //标题ID赋值 posterId = strValue[0]; strValue[1] = response.Posters[ii].ChannelId.ToString(); strValue[2] = string.Empty; strValue[3] = string.Empty; string pic = response.Posters[ii].CoverPicUrl.ToString(); if (!string.IsNullOrEmpty(pic as string)) { string[] img = pic.Split(new char[] { ',' }); strValue[2] = img[0]; strValue[3] = img[img.GetUpperBound(0)]; } strValue[4] = response.Posters[ii].Title; strValue[5] = response.Posters[ii].TitleShort; strValue[6] = response.Posters[ii].Tag; strValue[7] = response.Posters[ii].Hits.ToString(); strValue[8] = response.Posters[ii].Weight.ToString(); strValue[9] = response.Posters[ii].CreateDate.ToString(); strValue[10] = response.Posters[ii].ModifiedDate.ToString(); strValue[11] = "0"; strValue[12] = xc.adminID; strValue[13] = xc.GetIP(); strValue[14] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); strValue[15] = "1"; //默认正常 DataTable dtIF = db.getDataTable("select * from posterChannelTitle where id=" + posterId); //防止重复插入 if (dtIF.Rows.Count > 0) { strValue[8] = dtIF.Rows[0]["weight"].ToString().Trim(); db.InsertUpdateDB("posterChannelTitle", strDim, strValue, "id=" + posterId); } else { db.InsertUpdateDB("posterChannelTitle", strDim, strValue, string.Empty); } dtIF.Dispose(); Response.Write("<br />同步 " + strValue[4] + " 已完成;<br />"); Response.Flush(); //获取关联商品 PosterPostauctionsGetRequest poster = new PosterPostauctionsGetRequest(); poster.PosterId = long.Parse(posterId); PosterPostauctionsGetResponse rsp = client.Execute(poster); int c = rsp.Posterauctions.Count; if (c > 9) { string strDim2 = "@classID,@num_iid,@title,@nick,@pic_url,@price,@click_url,@commission,@commission_rate,@commission_num,@commission_volume,@shop_click_url,@seller_credit_score,@item_location,@volume,@updateDate,@postID,@postDate,@postIP,@isBad,@isGood,@poster_id,@auction_short_title"; for (int s = 0; s < c; s++) { strValue[0] = "0"; strValue[1] = rsp.Posterauctions[s].AuctionId.ToString(); strValue[2] = rsp.Posterauctions[s].AuctionShortTitle.ToString(); strValue[3] = "找店铺 ZdianPU.com"; strValue[4] = "/images/WaterMark.png"; strValue[5] = rsp.Posterauctions[s].AuctionPrice.ToString(); strValue[6] = @"http://item.taobao.com/item.htm?id=" + rsp.Posterauctions[s].AuctionId.ToString(); strValue[7] = "0"; strValue[8] = "0"; strValue[9] = "0"; strValue[10] = "0"; strValue[11] = @"http://www.zdianpu.com"; strValue[12] = "0"; strValue[13] = "找店铺"; strValue[14] = "0"; strValue[15] = DateTime.Now.AddMonths(-3).ToString("yyyy-MM-dd HH:mm:ss"); //表示已过期 strValue[16] = xc.adminID; strValue[17] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); strValue[18] = xc.GetIP(); strValue[19] = "1"; strValue[20] = "0"; strValue[21] = rsp.Posterauctions[s].PosterId.ToString(); strValue[22] = rsp.Posterauctions[s].AuctionShortTitle.ToString(); DataTable dtIf = db.getDataTable("select * from taobaoKe with(nolock) where num_iid=" + rsp.Posterauctions[s].AuctionId.ToString()); //防止重复插入 if (dtIf.Rows.Count > 0) { strValue[0] = rsp.Posterauctions[s].PosterId.ToString(); strValue[1] = rsp.Posterauctions[s].AuctionShortTitle.ToString(); db.InsertUpdateDB("taobaoKe", "@poster_id,@auction_short_title", strValue, "num_iid=" + rsp.Posterauctions[s].AuctionId.ToString()); } else { db.InsertUpdateDB("taobaoKe", strDim2, strValue, string.Empty); } dtIf.Dispose(); } //淘宝客自动更新操作 for (int f = 0; f < 100; f++) { string id = string.Empty; DataTable tkIDs = db.getDataTable("select top 40 num_iid from taobaoKe where poster_id=" + posterId + " and isBad>0 and updateDate<GETDATE() order by updateDate ASC"); //30天过期内的数据可再次更新 if (tkIDs.Rows.Count > 0) { Response.Write("淘宝客数据转换已完成 " + ((f * 40) + tkIDs.Rows.Count).ToString() + "<br />"); Response.Flush(); for (int t = 0; t < tkIDs.Rows.Count; t++) { id += tkIDs.Rows[t]["num_iid"].ToString().Trim() + ","; } id = id.Substring(0, id.Length - 1); //锁定淘宝客更新条数 strValue[0] = "0"; string updateID = id.Replace(",", " or num_iid="); updateID = "num_iid=" + updateID; //Response.Write(updateID); //Response.End(); db.InsertUpdateDB("taobaoKe", "@isBad", strValue, updateID); } else { break; } tkIDs.Dispose(); //Response.Write(id.ToString()); if (!string.IsNullOrEmpty(id as string)) { TaobaokeItemsConvertRequest reqTk = new TaobaokeItemsConvertRequest(); reqTk.Fields = "num_iid,title,nick,pic_url,price,click_url,commission,commission_rate,commission_num,commission_volume,shop_click_url,seller_credit_score,item_location,volume"; reqTk.Nick = alimamaID; reqTk.NumIids = id; TaobaokeItemsConvertResponse responseTk = client.Execute(reqTk); int tkCount = responseTk.TaobaokeItems.Count; //转换后得到的淘客数量 string strDim3 = "@num_iid,@title,@nick,@pic_url,@price,@click_url,@commission,@commission_rate,@commission_num,@commission_volume,@shop_click_url,@seller_credit_score,@item_location,@volume,@updateDate,@isBad"; for (int tk = 0; tk < tkCount; tk++) { strValue[0] = responseTk.TaobaokeItems[tk].NumIid.ToString(); strValue[1] = responseTk.TaobaokeItems[tk].Title.ToString(); strValue[2] = responseTk.TaobaokeItems[tk].Nick.ToString(); strValue[3] = responseTk.TaobaokeItems[tk].PicUrl.ToString(); strValue[4] = responseTk.TaobaokeItems[tk].Price.ToString(); strValue[5] = responseTk.TaobaokeItems[tk].ClickUrl.ToString(); strValue[6] = responseTk.TaobaokeItems[tk].Commission.ToString(); strValue[7] = responseTk.TaobaokeItems[tk].CommissionRate; strValue[8] = responseTk.TaobaokeItems[tk].CommissionNum.ToString(); strValue[9] = responseTk.TaobaokeItems[tk].CommissionVolume.ToString(); strValue[10] = responseTk.TaobaokeItems[tk].ShopClickUrl.ToString(); strValue[11] = responseTk.TaobaokeItems[tk].SellerCreditScore.ToString(); strValue[12] = responseTk.TaobaokeItems[tk].ItemLocation.ToString(); strValue[13] = responseTk.TaobaokeItems[tk].Volume.ToString(); strValue[14] = DateTime.Now.AddDays(7).ToString("yyyy-MM-dd HH:mm:ss"); strValue[15] = "1"; db.InsertUpdateDB("taobaoKe", strDim3, strValue, " num_iid =" + responseTk.TaobaokeItems[tk].NumIid.ToString()); //更新商品一对多关联表 DataTable dtIf = db.getDataTable("select * from posterTkID with(nolock) where title_id=" + posterId + " and tK_num_iid=" + responseTk.TaobaokeItems[tk].NumIid.ToString()); if (dtIf.Rows.Count < 1) //防止重复插入 { strValue[0] = posterId; strValue[1] = responseTk.TaobaokeItems[tk].NumIid.ToString(); db.InsertUpdateDB("posterTkID", "@title_id,@tK_num_iid", strValue, ""); } dtIf.Dispose(); } } } } else { db.DelDB("posterChannelTitle", "id", response.Posters[ii].Id.ToString(), "", false, ""); } } } dt.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { XabaraCom xc = new XabaraCom(); Page.Title = "404页面出错 " + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "webName") + XmlReader.GetConfig(Server.MapPath("~/xabara.config"), "titleMeta"); }