/// <summary>
///
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public List <Product_Class> GetCategories(BUser user)
{
List <Product_Class> categories = new List <Product_Class>();
SellercatsListGetRequest req = new SellercatsListGetRequest();
req.Nick = user.Mall_Name;
SellercatsListGetResponse response = client.Execute(req);
if (response.IsError)
{
throw new KMJXCException(response.ErrMsg);
}
if (response.SellerCats != null)
{
foreach (TB.SellerCat cat in response.SellerCats)
{
Product_Class category = new Product_Class();
category.Create_Time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
category.Create_User_ID = user.ID;
category.Enabled = true;
category.Mall_CID = cat.Cid.ToString();
category.Mall_PCID = cat.ParentCid.ToString();
category.Name = cat.Name;
category.Parent_ID = 0;
category.Product_Class_ID = 0;
categories.Add(category);
}
}
return(categories);
}
/// <summary>
///
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public List<Product_Class> GetCategories(BUser user)
{
List<Product_Class> categories = new List<Product_Class>();
SellercatsListGetRequest req = new SellercatsListGetRequest();
req.Nick = user.Mall_Name;
SellercatsListGetResponse response = client.Execute(req);
if (response.IsError)
{
throw new KMJXCException(response.ErrMsg);
}
if (response.SellerCats != null)
{
foreach (TB.SellerCat cat in response.SellerCats)
{
Product_Class category = new Product_Class();
category.Create_Time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
category.Create_User_ID = user.ID;
category.Enabled = true;
category.Mall_CID = cat.Cid.ToString();
category.Mall_PCID = cat.ParentCid.ToString();
category.Name = cat.Name;
category.Parent_ID = 0;
category.Product_Class_ID = 0;
categories.Add(category);
}
}
return categories;
}
////����API��taobao.sellercats.list.get; ��ȡ����Լ��IJ�Ʒ��Ŀ
/// <summary>
/// ����API��taobao.sellercats.list.get; ��ȡ����Լ��IJ�Ʒ��Ŀ
/// </summary>
/// <param name="userNick">�Ա��dz�</param>
public List<SellerCat> GetSellercatsList(string userNick)
{
if (string.IsNullOrEmpty(userNick))
throw new Exception(Resource.ExceptionTemplate_MethedParameterIsNullorEmpty
.StringFormat(new StackTrace().ToString()));
var reqCats = new SellercatsListGetRequest {Nick = userNick};
SellercatsListGetResponse responseCats = client.Execute(reqCats);
return responseCats.SellerCats;
}
/// <summary>
/// 获取前台展示的店铺内卖家自定义商品类目
/// </summary>
/// <param name="NickName"></param>
internal List <SellerCat> GetSPLM(string NickName)
{
ITopClient client = new DefaultTopClient(StaticSystemConfig.soft.ApiURL, StaticSystemConfig.soft.AppKey, StaticSystemConfig.soft.AppSecret, "json");
SellercatsListGetRequest req = new SellercatsListGetRequest();
req.Nick = NickName;
SellercatsListGetResponse response = client.Execute(req);
TopJsonParser topjson = new TopJsonParser();
SellercatsListGetResponse1 resp = topjson.Parse <SellercatsListGetResponse1>(response.Body);
return(resp.SellerCats);
}
////店铺API，taobao.sellercats.list.get; 获取卖家自己的产品类目
/// <summary>
/// 店铺API，taobao.sellercats.list.get; 获取卖家自己的产品类目
/// </summary>
/// <param name="userNick">淘宝昵称</param>
public List <SellerCat> GetSellercatsList(string userNick)
{
if (string.IsNullOrEmpty(userNick))
{
throw new Exception(Resource.ExceptionTemplate_MethedParameterIsNullorEmpty
.StringFormat(new StackTrace().ToString()));
}
var reqCats = new SellercatsListGetRequest {
Nick = userNick
};
SellercatsListGetResponse responseCats = client.Execute(reqCats);
return(responseCats.SellerCats);
}
/// <summary>
/// 记录该会员的店铺信息
/// </summary>
private void InsertUserInfo(string nick)
{
TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12287381", "d3486dac8198ef01000e7bd4504601a4");
//记录店铺基本信息
ShopGetRequest request = new ShopGetRequest();
request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified";
request.Nick = nick;
Shop shop = client.ShopGet(request);
//记录到本地数据库
string sql = "INSERT INTO TopTaobaoShop (" +
"sid, " +
"cid, " +
"title, " +
"nick, " +
"[desc], " +
"bulletin, " +
"pic_path, " +
"created, " +
"modified, " +
"shop_score, " +
"remain_count " +
" ) VALUES ( " +
" '" + shop.Sid + "', " +
" '" + shop.Cid + "', " +
" '" + shop.Title + "', " +
" '" + shop.Nick + "', " +
" '" + shop.Desc + "', " +
" '" + shop.Bulletin + "', " +
" '" + shop.PicPath + "', " +
" '" + shop.Created + "', " +
" '" + shop.Modified + "', " +
" '" + shop.ShopScore + "', " +
" '" + shop.RemainCount + "' " +
") ";
utils.ExecuteNonQuery(sql);
//记录店铺分类信息
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Fields = "cid,parent_cid,name,is_parent";
request1.Nick = nick;
PageList <SellerCat> cat = client.SellercatsListGet(request1);
for (int i = 0; i < cat.Content.Count; i++)
{
sql = "INSERT INTO TopTaobaoShopCat (" +
"cid, " +
"parent_cid, " +
"name, " +
"pic_url, " +
"sort_order, " +
"created, " +
"nick, " +
"modified " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" '" + cat.Content[i].ParentCid + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].PicUrl + "', " +
" '" + cat.Content[i].SortOrder + "', " +
" '" + cat.Content[i].Created + "', " +
" '" + nick + "', " +
" '" + cat.Content[i].Modified + "' " +
") ";
utils.ExecuteNonQuery(sql);
}
//记录店铺所有商品信息-暂不记录
}
protected void Page_Load(object sender, EventArgs e)
{
Cookie cookie = new Cookie();
string taobaoNick = cookie.getCookie("nick");
string session = cookie.getCookie("top_session");
Rijndael_ encode = new Rijndael_("tetesoft");
taobaoNick = encode.Decrypt(taobaoNick);
//获取参数
string q = utils.NewRequest("query", utils.RequestType.QueryString);
string page = utils.NewRequest("p", utils.RequestType.QueryString);
if (page == "")
{
page = "1";
}
string catid = utils.NewRequest("catid", utils.RequestType.QueryString);
string act = utils.NewRequest("act", utils.RequestType.QueryString);
TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12132145", "1fdd2aadd5e2ac2909db2967cbb71e7f");
int pageSizeNow = 15;
if (act == "get")
{
//获取用户店铺商品列表
ItemsOnsaleGetRequest request = new ItemsOnsaleGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.PageSize = pageSizeNow;
request.PageNo = int.Parse(page);
request.Q = q;
if (catid != "0")
{
request.SellerCids = catid;
}
PageList <Item> product = client.ItemsOnsaleGet(request, session);
//输出页面HTML
for (int i = 0; i < product.Content.Count; i++)
{
Response.Write("<input type='checkbox' name='items' id='item_" + product.Content[i].NumIid + "' title='" + product.Content[i].Title + "' value='" + product.Content[i].NumIid + "' onclick=\"InitArea(this)\"><label for='item_" + product.Content[i].NumIid + "'>" + product.Content[i].Title + "</label><br>");
}
Response.Write("<br>");
long totalPage = (product.TotalResults % pageSizeNow == 0) ? (product.TotalResults / pageSizeNow) : (product.TotalResults / pageSizeNow + 1);
//输出分页HTML
for (int i = 1; i <= totalPage; i++)
{
if (page == i.ToString())
{
Response.Write(i.ToString() + " ");
}
else
{
Response.Write("<a href=\"javascript:spreadStat(" + i.ToString() + ")\">[" + i.ToString() + "]</a> ");
}
}
}
else if (act == "getCat")
{
//记录店铺分类信息
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Fields = "cid,parent_cid,name,is_parent";
request1.Nick = taobaoNick;
PageList <SellerCat> cat = client.SellercatsListGet(request1);
//清除老分类
string sql = "DELETE FROM TopTaobaoShopCat WHERE nick = '" + taobaoNick + "'";
utils.ExecuteNonQuery(sql);
//插入新分类
for (int i = 0; i < cat.Content.Count; i++)
{
sql = "INSERT INTO TopTaobaoShopCat (" +
"cid, " +
"parent_cid, " +
"name, " +
"pic_url, " +
"sort_order, " +
"created, " +
"nick, " +
"modified " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" '" + cat.Content[i].ParentCid + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].PicUrl + "', " +
" '" + cat.Content[i].SortOrder + "', " +
" '" + cat.Content[i].Created + "', " +
" '" + taobaoNick + "', " +
" '" + cat.Content[i].Modified + "' " +
") ";
utils.ExecuteNonQuery(sql);
}
//输出页面HTML
Response.Write("<select id=\"shopcat\" name=\"shopcat\"><option value=\"0\"></option>");
for (int i = 0; i < cat.Content.Count; i++)
{
Response.Write("<option value='" + cat.Content[i].Cid + "'>" + cat.Content[i].Name + "</option>");
}
Response.Write("</select>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Cookie cookie = new Cookie();
string taobaoNick = cookie.getCookie("nick");
string session = cookie.getCookie("top_sessiongroupbuy");
Rijndael_ encode = new Rijndael_("tetesoft");
taobaoNick = encode.Decrypt(taobaoNick);
string appkey = "12159997";
string secret = "614e40bfdb96e9063031d1a9e56fbed5";
//获取参数
string q = utils.NewRequest("query", utils.RequestType.QueryString);
string page = utils.NewRequest("p", utils.RequestType.QueryString);
if (page == "")
{
page = "1";
}
string catid = utils.NewRequest("catid", utils.RequestType.QueryString);
string isradio = utils.NewRequest("isradio", utils.RequestType.QueryString);
string act = utils.NewRequest("act", utils.RequestType.QueryString);
TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", appkey, secret);
int pageSizeNow = 15;
if (act == "get")
{
//获取用户店铺商品列表
ItemsOnsaleGetRequest request = new ItemsOnsaleGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.PageSize = pageSizeNow;
request.PageNo = int.Parse(page);
request.Q = q;
if (catid != "0")
{
request.SellerCids = catid;
}
PageList <Item> product = client.ItemsOnsaleGet(request, session);
//输出页面HTML
for (int i = 0; i < product.Content.Count; i++)
{
if (isradio == "1")
{
Response.Write("<input type='radio' name='items' id='item_" + product.Content[i].NumIid + "' title='" + product.Content[i].Title.Replace("%", "") + "' value='" + product.Content[i].NumIid + "' onclick=\"InitArea(this)\"><label onMouseOver=\"javascript:ddrivetip('<img src=" + product.Content[i].PicUrl + "_80x80.jpg>','#ffffff',100)\" onMouseOut=\"hideddrivetip()\" for='item_" + product.Content[i].NumIid + "'>" + product.Content[i].Title.Replace("%", "") + "</label><br>");
}
else
{
Response.Write("<input type='checkbox' name='items' id='item_" + product.Content[i].NumIid + "' title='" + product.Content[i].Title.Replace("%", "") + "' value='" + product.Content[i].NumIid + "' onclick=\"InitArea(this)\"><label onMouseOver=\"javascript:ddrivetip('<img src=" + product.Content[i].PicUrl + "_80x80.jpg>','#ffffff',100)\" onMouseOut=\"hideddrivetip()\" for='item_" + product.Content[i].NumIid + "'>" + product.Content[i].Title.Replace("%", "") + "</label><br>");
}
}
Response.Write("<br>");
long totalPage = (product.TotalResults % pageSizeNow == 0) ? (product.TotalResults / pageSizeNow) : (product.TotalResults / pageSizeNow + 1);
//输出分页HTML
for (int i = 1; i <= totalPage; i++)
{
if (page == i.ToString())
{
Response.Write(i.ToString() + " ");
}
else
{
Response.Write("<a href=\"javascript:spreadStat(" + i.ToString() + ")\">[" + i.ToString() + "]</a> ");
}
}
}
else if (act == "getCat")
{
//记录店铺分类信息
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Fields = "cid,parent_cid,name,is_parent";
request1.Nick = taobaoNick;
PageList <SellerCat> cat = client.SellercatsListGet(request1);
//清除老分类
string sql = "DELETE FROM TopTaobaoShopCat WHERE nick = '" + taobaoNick + "'";
utils.ExecuteNonQuery(sql);
//插入新分类
for (int i = 0; i < cat.Content.Count; i++)
{
sql = "INSERT INTO TopTaobaoShopCat (" +
"cid, " +
"parent_cid, " +
"name, " +
"pic_url, " +
"sort_order, " +
"created, " +
"nick, " +
"modified " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" '" + cat.Content[i].ParentCid + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].PicUrl + "', " +
" '" + cat.Content[i].SortOrder + "', " +
" '" + cat.Content[i].Created + "', " +
" '" + taobaoNick + "', " +
" '" + cat.Content[i].Modified + "' " +
") ";
utils.ExecuteNonQuery(sql);
}
//输出页面HTML
Response.Write("<select id=\"shopcat\" name=\"shopcat\"><option value=\"0\"></option>");
for (int i = 0; i < cat.Content.Count; i++)
{
Response.Write("<option value='" + cat.Content[i].Cid + "'>" + cat.Content[i].Name + "</option>");
}
Response.Write("</select>");
}
else if (act == "getResultStr")
{
string items = utils.NewRequest("ids", utils.RequestType.QueryString);
string[] arr = items.Split(',');
List <Item> itemList = new List <Item>();
//标志
int flag = 1;
if (arr.Length == 1)
{
flag = 0;
}
for (int i = flag; i < arr.Length; i++)
{
ItemGetRequest request = new ItemGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.NumIid = long.Parse(arr[i]);
Item product = client.ItemGet(request);
itemList.Add(product);
}
string str = string.Empty;
//根据不同样式显示不同的字符串
string style = utils.NewRequest("style", utils.RequestType.QueryString);
//string sqlNew = "SELECT sid FROM TopTaobaoShop WHERE nick = '" + taobaoNick + "'";
//DataTable dtNew = utils.ExecuteDataTable(sqlNew);
//string nickid = string.Empty;
//if (dtNew.Rows.Count != 0)
//{
// nickid = "http://shop" + dtNew.Rows[0]["sid"].ToString() + ".taobao.com/";
//}
//else
//{
// nickid = "http://www.taobao.com/";
//}
if (isradio == "1")
{
//团购需要的商品数据
for (int i = 0; i < itemList.Count; i++)
{
str = "<div id=item_" + itemList[i].NumIid.ToString() + " style=\"float:left;width:46px;border:solid 1px #ccc;padding:2px;margin:2px;\"><A href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\"><IMG src=\"" + itemList[i].PicUrl + "_40x40.jpg\" border=0 title=\"" + itemList[i].Title + "\" /></A><br>" + itemList[i].Price + "<input type=\"hidden\" id=\"productid\" name=\"productid\" value=\"" + itemList[i].NumIid.ToString() + "\"><input type=\"hidden\" id=\"price\" name=\"price\" value=\"" + itemList[i].Price.ToString() + "\"><br><a href=\"javascript:delitem(" + itemList[i].NumIid.ToString() + ")\">删除</a></div>";
}
}
Response.Write(str);
}
}
/// <summary>
/// 记录该会员的店铺信息
/// </summary>
private void InsertUserInfo(string nick)
{
TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12159997", "614e40bfdb96e9063031d1a9e56fbed5");
//记录店铺基本信息
ShopGetRequest request = new ShopGetRequest();
request.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified";
request.Nick = nick;
Shop shop;
try
{
shop = client.ShopGet(request);
}
catch
{
Response.Write("没有店铺的淘宝会员不可使用该应用，如果您想继续使用，请先去淘宝网开个属于您自己的店铺！<br> <a href='http://www.taobao.com/'>返回</a>");
Response.End();
return;
}
//记录到本地数据库
string sql = "INSERT INTO TopTaobaoShop (" +
"sid, " +
"cid, " +
"title, " +
"nick, " +
"[desc], " +
"bulletin, " +
"pic_path, " +
"created, " +
"modified, " +
"shop_score, " +
"versionNo, " +
"remain_count " +
" ) VALUES ( " +
" '" + shop.Sid + "', " +
" '" + shop.Cid + "', " +
" '" + shop.Title + "', " +
" '" + shop.Nick + "', " +
" '" + shop.Desc + "', " +
" '" + shop.Bulletin + "', " +
" '" + shop.PicPath + "', " +
" '" + shop.Created + "', " +
" '" + shop.Modified + "', " +
" '" + shop.ShopScore + "', " +
" '" + versionNo + "', " +
" '" + shop.RemainCount + "' " +
") ";
utils.ExecuteNonQuery(sql);
//记录店铺分类信息
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Fields = "cid,parent_cid,name,is_parent";
request1.Nick = nick;
PageList <SellerCat> cat = client.SellercatsListGet(request1);
for (int i = 0; i < cat.Content.Count; i++)
{
sql = "INSERT INTO TopTaobaoShopCat (" +
"cid, " +
"parent_cid, " +
"name, " +
"pic_url, " +
"sort_order, " +
"created, " +
"nick, " +
"modified " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" '" + cat.Content[i].ParentCid + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].PicUrl + "', " +
" '" + cat.Content[i].SortOrder + "', " +
" '" + cat.Content[i].Created + "', " +
" '" + nick + "', " +
" '" + cat.Content[i].Modified + "' " +
") ";
utils.ExecuteNonQuery(sql);
}
//记录店铺所有商品信息-暂不记录
}
private void PublishProduct()
{
string authCode = null;
if (!GetAuthorizeCode( out authCode))
{
MessageBox.Show("没有找到相应的 authCode");
return;
}
context = TopUtils.GetTopContext(authCode);
ITopClient client = new DefaultTopClient("http://gw.api.taobao.com/router/rest", "21479233", "98dd6f00daf3f94322ec1a4ff72370b7");
#region 获取店铺类目
SellercatsListGetRequest reqCats = new SellercatsListGetRequest();
reqCats.Nick = context.UserNick;
SellercatsListGetResponse responseCats = client.Execute(reqCats);
sellerCats = responseCats.SellerCats;
// var cats = responseCats.SellerCats.FirstOrDefault(f => f.Name == "");
//714827841
#endregion
ItemAddRequest req = new ItemAddRequest();
req.Num = 30L;
req.Price = "2000.07";
req.Type = "fixed";
req.StuffStatus = "new";
req.Title = "美邦男装";
req.Desc = "这是一个好商品";
req.LocationState = "浙江";
req.LocationCity = "杭州";
//req.ApproveStatus = "onsale";
req.Cid = 50000436;
// req.Props = "20000:33564;21514:38489";
req.FreightPayer = "buyer";
//req.ValidThru = 7L;
req.HasInvoice = false;
req.HasWarranty = false;
req.HasShowcase = false;
req.SellerCids = GetCatsList("T恤 - 长袖T恤;T恤 - 短袖T恤;T恤 - 圆领T恤", "Metersbonwe - 女装");
req.HasDiscount = true;
req.PostFee = "15.07";
req.ExpressFee = "15.07";
req.EmsFee = "25.07";
DateTime dateTime = DateTime.Parse("2000-01-01 00:00:00");
req.ListTime = dateTime;
req.Increment = "2.50";
FileItem fItem = new FileItem(@"C:\Users\Administrator\Desktop\a.png");
req.Image = fItem;
// req.PostageId = 775752L;
//req.AuctionPoint = 5L;
req.PropertyAlias = "pid:vid:别名;pid1:vid1:别名1";
req.InputPids = "20000";
req.SkuProperties = "pid:vid;pid:vid";
req.SkuQuantities = "2,3,4";
req.SkuPrices = "200.07";
req.SkuOuterIds = "1234,1342";
req.Lang = "zh_CN";
req.OuterId = "12345";
req.ProductId = 123456789L;
req.PicPath = "i7/T1rfxpXcVhXXXH9QcZ_033150.jpg";
req.AutoFill = "time_card";
req.InputStr = "耐克;";
req.IsTaobao = true;
req.IsEx = true;
req.Is3D = true;
req.SellPromise = true;
req.AfterSaleId = 47758L;
req.CodPostageId = 53899L;
req.IsLightningConsignment = true;
req.Weight = 100L;
req.IsXinpin = false;
req.SubStock = 1L;
req.FoodSecurityPrdLicenseNo = "QS410006010388";
req.FoodSecurityDesignCode = "Q/DHL.001-2008";
req.FoodSecurityFactory = "远东恒天然乳品有限公司";
req.FoodSecurityFactorySite = "台北市仁爱路4段85号";
req.FoodSecurityContact = "00800-021216";
req.FoodSecurityMix = "有机乳糖、有机植物油";
req.FoodSecurityPlanStorage = "常温";
req.FoodSecurityPeriod = "2年";
req.FoodSecurityFoodAdditive = "磷脂 、膨松剂";
req.FoodSecuritySupplier = "深圳岸通商贸有限公司";
req.FoodSecurityProductDateStart = "2012-06-01";
req.FoodSecurityProductDateEnd = "2012-06-10";
req.FoodSecurityStockDateStart = "2012-06-20";
req.FoodSecurityStockDateEnd = "2012-06-30";
req.GlobalStockType = "1";
req.ScenicTicketPayWay = 1L;
req.ScenicTicketBookCost = "5.99";
req.ItemSize = "bulk:8";
req.ItemWeight = "10";
req.ChangeProp = "162707:28335:28335,28338";
req.LocalityLifeChooseLogis = "0";
req.LocalityLifeExpirydate = "2012-08-06,2012-08-16";
req.LocalityLifeNetworkId = "5645746";
req.LocalityLifeMerchant = "56879:码商X";
req.LocalityLifeVerification = "101";
req.LocalityLifeRefundRatio = 50L;
req.LocalityLifeOnsaleAutoRefundRatio = 80L;
req.PaimaiInfoMode = 1L;
req.PaimaiInfoDeposit = 20L;
req.PaimaiInfoInterval = 5L;
req.PaimaiInfoReserve = "11";
req.PaimaiInfoValidHour = 2L;
req.PaimaiInfoValidMinute = 22L;
ItemAddResponse response = client.Execute(req, context.SessionKey);
}
protected void Page_Load(object sender, EventArgs e)
{
Cookie cookie = new Cookie();
string taobaoNick = cookie.getCookie("nick");
string session = cookie.getCookie("top_sessionblog");
Rijndael_ encode = new Rijndael_("tetesoft");
taobaoNick = encode.Decrypt(taobaoNick);
//获取参数
string q = utils.NewRequest("query", utils.RequestType.QueryString);
string page = utils.NewRequest("p", utils.RequestType.QueryString);
if (page == "")
{
page = "1";
}
string catid = utils.NewRequest("catid", utils.RequestType.QueryString);
string isradio = utils.NewRequest("isradio", utils.RequestType.QueryString);
string act = utils.NewRequest("act", utils.RequestType.QueryString);
TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12159997", "614e40bfdb96e9063031d1a9e56fbed5");
int pageSizeNow = 15;
if (act == "get")
{
//获取用户店铺商品列表
ItemsOnsaleGetRequest request = new ItemsOnsaleGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.PageSize = pageSizeNow;
request.PageNo = int.Parse(page);
request.Q = q;
if (catid != "0")
{
request.SellerCids = catid;
}
PageList <Item> product = client.ItemsOnsaleGet(request, session);
//输出页面HTML
for (int i = 0; i < product.Content.Count; i++)
{
if (isradio == "1")
{
Response.Write("<input type='radio' name='items' id='item_" + product.Content[i].NumIid + "' title='" + product.Content[i].Title + "' value='" + product.Content[i].NumIid + "' onclick=\"InitArea(this)\"><label onMouseOver=\"javascript:ddrivetip('<img src=" + product.Content[i].PicUrl + "_80x80.jpg>','#ffffff',100)\" onMouseOut=\"hideddrivetip()\" for='item_" + product.Content[i].NumIid + "'>" + product.Content[i].Title + "</label><br>");
}
else
{
Response.Write("<input type='checkbox' name='items' id='item_" + product.Content[i].NumIid + "' title='" + product.Content[i].Title + "' value='" + product.Content[i].NumIid + "' onclick=\"InitArea(this)\"><label onMouseOver=\"javascript:ddrivetip('<img src=" + product.Content[i].PicUrl + "_80x80.jpg>','#ffffff',100)\" onMouseOut=\"hideddrivetip()\" for='item_" + product.Content[i].NumIid + "'>" + product.Content[i].Title + "</label><br>");
}
}
Response.Write("<br>");
long totalPage = (product.TotalResults % pageSizeNow == 0) ? (product.TotalResults / pageSizeNow) : (product.TotalResults / pageSizeNow + 1);
//输出分页HTML
for (int i = 1; i <= totalPage; i++)
{
if (page == i.ToString())
{
Response.Write(i.ToString() + " ");
}
else
{
Response.Write("<a href=\"javascript:spreadStat(" + i.ToString() + ")\">[" + i.ToString() + "]</a> ");
}
}
}
else if (act == "getCat")
{
//记录店铺分类信息
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Fields = "cid,parent_cid,name,is_parent";
request1.Nick = taobaoNick;
PageList <SellerCat> cat = client.SellercatsListGet(request1);
//清除老分类
string sql = "DELETE FROM TopTaobaoShopCat WHERE nick = '" + taobaoNick + "'";
utils.ExecuteNonQuery(sql);
//插入新分类
for (int i = 0; i < cat.Content.Count; i++)
{
sql = "INSERT INTO TopTaobaoShopCat (" +
"cid, " +
"parent_cid, " +
"name, " +
"pic_url, " +
"sort_order, " +
"created, " +
"nick, " +
"modified " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" '" + cat.Content[i].ParentCid + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].PicUrl + "', " +
" '" + cat.Content[i].SortOrder + "', " +
" '" + cat.Content[i].Created + "', " +
" '" + taobaoNick + "', " +
" '" + cat.Content[i].Modified + "' " +
") ";
utils.ExecuteNonQuery(sql);
}
//输出页面HTML
Response.Write("<select id=\"shopcat\" name=\"shopcat\"><option value=\"0\"></option>");
for (int i = 0; i < cat.Content.Count; i++)
{
Response.Write("<option value='" + cat.Content[i].Cid + "'>" + cat.Content[i].Name + "</option>");
}
Response.Write("</select>");
}
else if (act == "getResultStr")
{
string items = utils.NewRequest("ids", utils.RequestType.QueryString);
string[] arr = items.Split(',');
List <Item> itemList = new List <Item>();
//标志
int flag = 1;
if (arr.Length == 1)
{
flag = 0;
}
for (int i = flag; i < arr.Length; i++)
{
ItemGetRequest request = new ItemGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.NumIid = long.Parse(arr[i]);
Item product = client.ItemGet(request);
itemList.Add(product);
}
string str = string.Empty;
//根据不同样式显示不同的字符串
string style = utils.NewRequest("style", utils.RequestType.QueryString);
string sqlNew = "SELECT sid FROM TopTaobaoShop WHERE nick = '" + taobaoNick + "'";
DataTable dtNew = utils.ExecuteDataTable(sqlNew);
string nickid = string.Empty;
if (dtNew.Rows.Count != 0)
{
nickid = "http://shop" + dtNew.Rows[0]["sid"].ToString() + ".taobao.com/";
}
else
{
nickid = "http://www.taobao.com/";
}
if (isradio == "1")
{
//团购需要的商品数据
for (int i = 0; i < itemList.Count; i++)
{
str = "<A href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\"><IMG src=\"" + itemList[i].PicUrl + "_160x160.jpg\" border=0 /></A><br>" + itemList[i].Title + "<br>" + itemList[i].Price + "<input type=\"hidden\" id=\"productid\" name=\"productid\" value=\"" + itemList[i].NumIid.ToString() + "\"><input type=\"hidden\" id=\"price\" name=\"price\" value=\"" + itemList[i].Price.ToString() + "\">";
}
}
else
{
if (style == "1")
{
str += "<table background=\"http://www.7fshop.com/top/show1/4.gif\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"30\" style=\"border-right: #999999 1px solid; border-top: #999999 1px solid;border-left: #999999 1px solid; border-bottom: #999999 1px solid\" width=\"580\"><tr><td> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td align=\"left\"><table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"30\"><tr><td width=\"10\"></td><td background=\"http://www.7fshop.com/top/show1/1.gif\" width=\"24\"></td><td background=\"http://www.7fshop.com/top/show1/2.gif\"><font color=\"white\" style=\"font-size: 13px\"><strong>掌柜推荐商品</strong></font></td><td><img src=\"http://www.7fshop.com/top/show1/3.gif\" /></td></tr></table></td><td align=\"right\"></td></tr></table></td></tr></table> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-right: #999999 1px solid;border-top: #999999 1px solid; overflow: hidden; border-left: #999999 1px solid;border-bottom: #999999 1px solid\" width=\"578\"><tr><td valign=\"top\"><TABLE cellSpacing=0 cellPadding=0 width=578 border=0><TBODY><TR><TD align=\"middle\"><TABLE cellSpacing=8 cellPadding=0 align=center border=0><TBODY><TR>";
for (int i = 0; i < itemList.Count; i++)
{
str += "<TD vAlign=top align=\"middle\" width=175 bgColor=white><TABLE cellSpacing=0 cellPadding=0 align=center border=0><TBODY><TR><TD vAlign=top align=\"middle\" width=175 bgColor=white><TABLE cellSpacing=0 cellPadding=0 align=center border=0><TBODY><TR><TD align=\"middle\"><DIV style=\"BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; MARGIN-TOP: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 160px; BORDER-BOTTOM: #cccccc 1px solid; HEIGHT: 160px\"><DIV style=\"OVERFLOW: hidden; WIDTH: 160px; HEIGHT: 160px\"><A href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\"><IMG src=\"" + itemList[i].PicUrl + "_160x160.jpg\" border=0 /></A></DIV></DIV></TD></TR><TR><TD align=\"middle\"><DIV style=\"PADDING-RIGHT: 4px; PADDING-LEFT: 4px; FONT-SIZE: 12px; PADDING-BOTTOM: 4px; PADDING-TOP: 4px\"><A style=\"FONT-SIZE: 12px; COLOR: #3f3f3f; TEXT-DECORATION: none\" href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\">" + itemList[i].Title + "</A><BR /><FONT style=\"COLOR: #fe596a\"><B>￥ " + itemList[i].Price + "元</B></FONT> </DIV><A href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\"><IMG src=\"http://www.7fshop.com/top/show1/buy1.gif\" border=0 /></A> <DIV></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>";
if ((i + 1) % 3 == 0)
{
str += "</tr><tr>";
}
}
str += "</TR></TBODY></TABLE></td></tr><tr><td align=\"right\" height=\"24\" style=\"border-bottom: #999999 1px solid\" valign=\"center\"><a href=\"" + nickid + "\" style=\"text-decoration: none\" target=\"_blank\"><font style=\"font-size: 13px; color: #ff6600\"><strong>更多详情请见 " + nickid + "</strong> </font></a></td></tr></table></td></tr></table>";
}
else
{
for (int i = 0; i < itemList.Count; i++)
{
str += "<a href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\"><img src=\"" + itemList[i].PicUrl + "\" border=\"0\" /></a><br />";
str += "<a href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\">" + itemList[i].Title + "</a> 售价：" + itemList[i].Price + "元<br><br>";
}
}
}
Response.Write(str);
}
}
/// <summary>
/// 增加活动图片到店铺分类
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
string appkey = "12159997";
string secret = "614e40bfdb96e9063031d1a9e56fbed5";
string name = utils.NewRequest("left", utils.RequestType.Form);
string istop = utils.NewRequest("leftimgistop", utils.RequestType.Form);
int order = 0;
//保存到数据库
string sql = "UPDATE TopAutoReview SET leftimgname = '" + name + "', leftimgistop = '" + istop + "' WHERE nick = '" + nick + "'";
utils.ExecuteNonQuery(sql);
//通过接口同步到淘宝
TopXmlRestClient clientaa = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", appkey, secret);
//左侧分类的图片位置默认在最下面,获取当前序列号最大的
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Nick = nick;
request1.Fields = "name,sort_order,parent_cid";
PageList <SellerCat> cat = clientaa.SellercatsListGet(request1, session);
if (cat.Content.Count == 0)
{
order = 1;
}
else
{
int max = 0;
for (int i = 0; i < cat.Content.Count; i++)
{
if (cat.Content[i].ParentCid == 0 && cat.Content[i].SortOrder > max)
{
max = cat.Content[i].SortOrder;
}
}
order = max + 1;
}
//判断该店铺是否增加过该分类
string isok = "0";
string catid = string.Empty;
for (int i = 0; i < cat.Content.Count; i++)
{
if (cat.Content[i].Name == "好评有礼_特特营销")
{
isok = "1";
catid = cat.Content[i].Cid.ToString();
break;
}
}
if (isok == "0")
{
//添加到左侧分类
SellercatsListAddRequest request = new SellercatsListAddRequest();
request.Name = "好评有礼_特特营销";
request.PictUrl = GetTaobaoImg(name, "left");
request.SortOrder = order;
clientaa.SellercatsListAdd(request, session);
}
else
{
//更新分类图片
SellercatsListUpdateRequest request = new SellercatsListUpdateRequest();
request.Cid = int.Parse(catid);
request.PictUrl = GetTaobaoImg(name, "left");
clientaa.SellercatsListUpdate(request, session);
}
Response.Write("<script>alert('同步成功！');window.location.href='html.aspx';</script>");
Response.End();
return;
}
/// <summary>
/// 增加活动图片到店铺分类
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
string appkey = "12132145";
string secret = "1fdd2aadd5e2ac2909db2967cbb71e7f";
string name = utils.NewRequest("left", utils.RequestType.Form);
string istop = utils.NewRequest("leftimgistop", utils.RequestType.Form);
int order = 0;
//保存到数据库
string sql = "UPDATE TCS_ShopConfig SET leftimgname = '" + name + "', leftimgistop = '" + istop + "' WHERE nick = '" + nick + "'";
utils.ExecuteNonQuery(sql);
//通过接口同步到淘宝
TopXmlRestClient clientaa = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", appkey, secret);
//左侧分类的图片位置默认在最下面,获取当前序列号最大的
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Nick = nick;
request1.Fields = "name,sort_order,parent_cid";
PageList <SellerCat> cat = clientaa.SellercatsListGet(request1, session);
if (cat.Content.Count == 0)
{
order = 1;
}
else
{
int max = 0;
for (int i = 0; i < cat.Content.Count; i++)
{
if (cat.Content[i].ParentCid == 0 && cat.Content[i].SortOrder > max)
{
max = cat.Content[i].SortOrder;
}
}
order = max + 1;
}
//判断该店铺是否增加过该分类
string isok = "0";
string catid = string.Empty;
for (int i = 0; i < cat.Content.Count; i++)
{
//Response.Write(cat.Content[i].Name + "<br>");
if (cat.Content[i].Name == "好评有礼_特特营销")
{
isok = "1";
catid = cat.Content[i].Cid.ToString();
break;
}
}
//Response.End();
if (isok == "0")
{
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("name", "好评有礼_特特营销");
param.Add("pict_url", GetTaobaoImg(name, "left"));
param.Add("sort_order", order.ToString());
string result = Post("http://gw.api.taobao.com/router/rest", appkey, secret, "taobao.sellercats.list.add", session, param);
//Response.Write(result);
//Response.End();
////添加到左侧分类
//SellercatsListAddRequest request = new SellercatsListAddRequest();
//request.Name = "好评有礼_特特营销";
//request.PictUrl = GetTaobaoImg(name, "left");
//request.SortOrder = order;
//clientaa.SellercatsListAdd(request, session);
}
else
{
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("cid", catid);
param.Add("pict_url", GetTaobaoImg(name, "left"));
string result = Post("http://gw.api.taobao.com/router/rest", appkey, secret, "taobao.sellercats.list.update", session, param);
////更新分类图片
//SellercatsListUpdateRequest request = new SellercatsListUpdateRequest();
//request.Cid = int.Parse(catid);
//request.PictUrl = GetTaobaoImg(name, "left");
//clientaa.SellercatsListUpdate(request, session);
}
Response.Write("<script>alert('同步成功，如果是第一次同步左侧分类可能需要多等待一会才能看到，或者您可以在店铺装修里面发布一下即可！');window.location.href='html.aspx';</script>");
Response.End();
return;
}
protected void Page_Load(object sender, EventArgs e)
{
Cookie cookie = new Cookie();
string taobaoNick = cookie.getCookie("nick");
string session = cookie.getCookie("top_sessiongroupbuy");
Rijndael_ encode = new Rijndael_("tetesoft");
taobaoNick = encode.Decrypt(taobaoNick);
//获取参数
string q = utils.NewRequest("query", utils.RequestType.QueryString);
string page = utils.NewRequest("p", utils.RequestType.QueryString);
if (page == "")
{
page = "1";
}
string catid = utils.NewRequest("catid", utils.RequestType.QueryString);
string isradio = utils.NewRequest("isradio", utils.RequestType.QueryString);
string act = utils.NewRequest("act", utils.RequestType.QueryString);
TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", "12287381", "d3486dac8198ef01000e7bd4504601a4");
int pageSizeNow = 15;
if (act == "get")
{
//获取用户店铺商品列表
ItemsOnsaleGetRequest request = new ItemsOnsaleGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.PageSize = pageSizeNow;
request.PageNo = int.Parse(page);
request.Q = q;
if (catid != "0")
{
request.SellerCids = catid;
}
PageList <Item> product = client.ItemsOnsaleGet(request, session);
//输出页面HTML
for (int i = 0; i < product.Content.Count; i++)
{
string tempstr = "未参加促销活动";
string sql = "select * from Tete_activitylist where Status<>4 and Status<>3 and Status<>2 and ProductID=" + product.Content[i].NumIid.ToString().Trim();
DataTable dt = utils.ExecuteDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
tempstr = " <font color=green> 已参加促销活动</font><br/><a href=\"javascript:delItemAction(" + product.Content[i].NumIid.ToString().Trim() + "," + dt.Rows[0]["ActivityID"].ToString() + ")\">删除此促销活动</a><div id='del" + product.Content[i].NumIid.ToString().Trim() + "'></div>";
}
string str = " <table width=\"800px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" style=\"margin:0px; padding:0px\"> <tr><td style=\" width:100px;\"><img width=50px src=" + product.Content[i].PicUrl + "_80x80.jpg></td><td style=\" width:300px;\"><a href=\"http://item.taobao.com/item.htm?id=" + product.Content[i].NumIid.ToString() + "\" target=\"_blank\">" + product.Content[i].Title + "</a></td><td style=\" width:150px;\">" + product.Content[i].Price.ToString() + "</td><td style=\" width:250px;\">" + tempstr + "</td></tr> </table><hr/>";
Response.Write(str);
}
Response.Write("<br>");
long totalPage = (product.TotalResults % pageSizeNow == 0) ? (product.TotalResults / pageSizeNow) : (product.TotalResults / pageSizeNow + 1);
//输出分页HTML
for (int i = 1; i <= totalPage; i++)
{
if (page == i.ToString())
{
Response.Write(i.ToString() + " ");
}
else
{
Response.Write("<a href=\"javascript:spreadStat(" + i.ToString() + ")\">[" + i.ToString() + "]</a> ");
}
}
Response.End();
}
else if (act == "getCat")
{
//记录店铺分类信息
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Fields = "cid,parent_cid,name,is_parent";
request1.Nick = taobaoNick;
PageList <SellerCat> cat = client.SellercatsListGet(request1);
//清除老分类
string sql = "DELETE FROM TopTaobaoShopCat WHERE nick = '" + taobaoNick + "'";
utils.ExecuteNonQuery(sql);
//插入新分类
for (int i = 0; i < cat.Content.Count; i++)
{
sql = "INSERT INTO TopTaobaoShopCat (" +
"cid, " +
"parent_cid, " +
"name, " +
"pic_url, " +
"sort_order, " +
"created, " +
"nick, " +
"modified " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" '" + cat.Content[i].ParentCid + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].PicUrl + "', " +
" '" + cat.Content[i].SortOrder + "', " +
" '" + cat.Content[i].Created + "', " +
" '" + taobaoNick + "', " +
" '" + cat.Content[i].Modified + "' " +
") ";
utils.ExecuteNonQuery(sql);
}
//输出页面HTML
Response.Write("<select id=\"shopcat\" name=\"shopcat\"><option value=\"0\"></option>");
for (int i = 0; i < cat.Content.Count; i++)
{
Response.Write("<option value='" + cat.Content[i].Cid + "'>" + cat.Content[i].Name + "</option>");
}
Response.Write("</select>");
Response.End();
}
else if (act == "getResultStr")
{
string items = utils.NewRequest("ids", utils.RequestType.QueryString);
string[] arr = items.Split(',');
List <Item> itemList = new List <Item>();
//标志
int flag = 1;
if (arr.Length == 1)
{
flag = 0;
}
for (int i = flag; i < arr.Length; i++)
{
ItemGetRequest request = new ItemGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.NumIid = long.Parse(arr[i]);
Item product = client.ItemGet(request);
itemList.Add(product);
}
string str = string.Empty;
//根据不同样式显示不同的字符串
string style = utils.NewRequest("style", utils.RequestType.QueryString);
string sqlNew = "SELECT sid FROM TopTaobaoShop WHERE nick = '" + taobaoNick + "'";
DataTable dtNew = utils.ExecuteDataTable(sqlNew);
string nickid = string.Empty;
if (dtNew.Rows.Count != 0)
{
nickid = "http://shop" + dtNew.Rows[0]["sid"].ToString() + ".taobao.com/";
}
else
{
nickid = "http://www.taobao.com/";
}
for (int i = 0; i < itemList.Count; i++)
{
str += "<div id='div" + itemList[i].NumIid.ToString() + "' width=\"800px\"><table width=\"800px\"><tr width=\"800px\"><td width=\"90px\"><a href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\"><img src=\"" + itemList[i].PicUrl + "_80x80.jpg\" border=\"0\" /></a></td>";
str += "<td width=\"140px\"><a href=\"http://item.taobao.com/item.htm?id=" + itemList[i].NumIid.ToString() + "\" target=\"_blank\">" + itemList[i].Title + "</a> </td><td width=\"200px\"><input type=\"text\" size=\"27\" id=\"groupbuylistname" + itemList[i].NumIid.ToString() + "\" name=\"groupbuylistname\" maxlength=\"30\" value=\"\" /></td><td width=\"100px\"> " + itemList[i].Price + "元 <input type=\"hidden\" id=\"productid" + itemList[i].NumIid.ToString() + "\" name=\"productid\" value=\"" + itemList[i].NumIid.ToString() + "\"><input type=\"hidden\" id=\"price" + itemList[i].NumIid.ToString() + "\" name=\"price\" value=\"" + itemList[i].Price.ToString() + "\"></td><td width=\"100px\"> <input type=\"text\" id=\"zhekou" + itemList[i].NumIid.ToString() + "\" size=\"10\" name=\"zhekou\" onblur=\"setzekou(this)\" /> 元 <br /> 打<input type=\"text\" size=\"8\" id=\"zhekou1" + itemList[i].NumIid.ToString() + "\" name=\"zhekou1\" onblur=\"setprice(this)\"/> 折 <br />限购：<select id=\"xiangou" + itemList[i].NumIid.ToString() + "\" name=\"xiangou\"> <OPTION selected value=0>否</OPTION> <OPTION value=1>是</OPTION> </select> <span id=\"errmsg" + i + "\" style=\"color:Red\"></span> </td><td width=\"90px\"> <input type=\"text\" size=\"8\" name=\"rcount\" value=\"300\" /> </td><td width=\"80px\"><a onclick=\"deleteDIV('del1" + itemList[i].NumIid.ToString() + "')\" style=\"cursor:hand;\">删除</a></td></tr></table><input id=\"del1" + itemList[i].NumIid.ToString() + "\" name=\"del\" value='' type=\"hidden\" ></div>";
}
Response.Write(str);
Response.End();
}
else if (act == "getactivityitem")
{
//获取用户店铺商品列表
ItemsOnsaleGetRequest request = new ItemsOnsaleGetRequest();
request.Fields = "num_iid,title,price,pic_url";
request.PageSize = pageSizeNow;
request.PageNo = int.Parse(page);
request.Q = q;
if (catid != "0")
{
request.SellerCids = catid;
}
PageList <Item> product = client.ItemsOnsaleGet(request, session);
string str = string.Empty;
string discountType = string.Empty; //促销方式（打折：DISCOUNT，减价：PRICE）
string discountValue = string.Empty; //促销力度（7折限制）
string Rcount = "300"; //已参团人数(只在对设置团购模板时有用)
string newPrice2 = string.Empty; //促销价
string price2 = string.Empty; //商品价格
string itemtype2 = string.Empty;
string itemtypevalue2 = string.Empty;
string yhCount = string.Empty;
string hdstr = string.Empty;
string aid = Request.QueryString["aid"].ToString();
string yuanitemtype = "";
string yuandiscountType = "";
string yuandiscountValue = "";
string yuandecreaseNum = "";
string sql2 = "select * from tete_activity where id=" + aid;
DataTable dt33 = utils.ExecuteDataTable(sql2);
if (dt33 != null)
{
yuanitemtype = dt33.Rows[0]["itemType"].ToString();
yuandiscountType = dt33.Rows[0]["discountType"].ToString();
yuandiscountValue = dt33.Rows[0]["discountValue"].ToString();
yuandecreaseNum = dt33.Rows[0]["decreaseNum"].ToString();
}
//输出页面HTML
for (int i = 0; i < product.Content.Count; i++)
{
//先判断该商品是否已经参团（状态为：进行中和暂停中）
string sql = "SELECT * FROM tete_activitylist where ProductID=" + product.Content[i].NumIid.ToString() + " and (Status=3 or Status=1 or Status=0) and nick='" + taobaoNick + "'";
DataTable dtNew2 = utils.ExecuteDataTable(sql);
// 取得促销价格
if (dtNew2 != null && dtNew2.Rows.Count > 0)
{
Rcount = dtNew2.Rows[0]["Rcount"].ToString();
discountValue = dtNew2.Rows[0]["discountValue"].ToString();
discountType = dtNew2.Rows[0]["discountType"].ToString();
price2 = product.Content[i].Price;
hdstr = "<div id=\"del" + product.Content[i].NumIid.ToString() + "\">已参加活动:" + dtNew2.Rows[0]["name"].ToString() + " <br><a href=\"javascript:delItemAction(" + product.Content[i].NumIid.ToString() + ")\">删除此促销活动</a></div> <div style=\"display:none\" id=\"add" + product.Content[i].NumIid.ToString() + "\"><a href=\"javascript:addItemAction(" + product.Content[i].NumIid.ToString() + ")\">参加活动</a></div> ";
if (discountType.Trim() == "DISCOUNT")
{
itemtype2 = "<select onchange=\"changeSelect(" + product.Content[i].NumIid.ToString() + ")\" id=\"discountType" + product.Content[i].NumIid.ToString() + "\" name=\"discountType\" > <option selected=\"selected\" value=\"DISCOUNT\">打折</option><option value=\"PRICE\">减价</option> </select>";
itemtypevalue2 = " <div id=\"zheDiv" + product.Content[i].NumIid.ToString() + "\" style=\"display: block;\"><input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeZhe" + product.Content[i].NumIid.ToString() + "\" value=\"" + discountValue + "\" name=\"discountValue\" style=\"width:30px\">折</div><div style=\"display: none;\" id=\"jianDiv" + product.Content[i].NumIid.ToString() + "\">减<input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeJian" + product.Content[i].NumIid.ToString() + "\" name=\"discountValue\" style=\"width:30px\" >元</div>";
if (discountValue != "")
{
newPrice2 = (decimal.Parse(price2) * decimal.Parse(discountValue) * 0.1m).ToString();
}
else
{
newPrice2 = price2;
}
yhCount = " <span id=\"duojian" + product.Content[i].NumIid.ToString() + "\" style=\"display: inline;\">多件<input type=\"hidden\" id=\"decreaseNumHiden" + product.Content[i].NumIid.ToString() + "\" value=\"0\" name=\"decreaseNumHiden\"></span> <span style=\"display: none;\" id=\"yijian" + product.Content[i].NumIid.ToString() + "\"><select onchange=\"decreaseNumChange(" + product.Content[i].NumIid.ToString() + ")\" id=\"decreaseNumSel" + product.Content[i].NumIid.ToString() + "\" name=\"decreaseNumSel\"> <option selected=\"selected\" value=\"0\">多件</option> <option value=\"1\">一件</option> </select></span>";
}
else
{
itemtype2 = "<select onchange=\"changeSelect(" + product.Content[i].NumIid.ToString() + ")\" id=\"discountType" + product.Content[i].NumIid.ToString() + "\" name=\"discountType\" > <option value=\"DISCOUNT\">打折</option><option selected=\"selected\" value=\"PRICE\">减价</option> </select>";
if (dtNew2.Rows[0]["decreaseNum"].ToString() == "0")
{
yhCount = " <span id=\"duojian" + product.Content[i].NumIid.ToString() + "\" style=\"display: none;\">多件<input type=\"hidden\" id=\"decreaseNumHiden" + product.Content[i].NumIid.ToString() + "\" value=\"0\" name=\"decreaseNumHiden\"></span> <span style=\"display: inline;\" id=\"yijian" + product.Content[i].NumIid.ToString() + "\"><select onchange=\"decreaseNumChange(" + product.Content[i].NumIid.ToString() + ")\" id=\"decreaseNumSel" + product.Content[i].NumIid.ToString() + "\" name=\"decreaseNumSel\"> <option selected=\"selected\" value=\"0\">多件</option> <option value=\"1\">一件</option> </select></span>";
}
else
{
yhCount = " <span id=\"duojian" + product.Content[i].NumIid.ToString() + "\" style=\"display: none;\">多件<input type=\"hidden\" id=\"decreaseNumHiden" + product.Content[i].NumIid.ToString() + "\" value=\"0\" name=\"decreaseNumHiden\"></span> <span style=\"display: inline;\" id=\"yijian" + product.Content[i].NumIid.ToString() + "\"><select onchange=\"decreaseNumChange(" + product.Content[i].NumIid.ToString() + ")\" id=\"decreaseNumSel" + product.Content[i].NumIid.ToString() + "\" name=\"decreaseNumSel\"> <option value=\"0\">多件</option> <option value=\"1\" selected=\"selected\">一件</option> </select></span>";
}
itemtypevalue2 = " <div id=\"zheDiv" + product.Content[i].NumIid.ToString() + "\" style=\"display: none;\" ><input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeZhe" + product.Content[i].NumIid.ToString() + "\" value=\"9\" name=\"discountValue\" style=\"width:30px\">折</div><div style=\"display: block;\" id=\"jianDiv" + product.Content[i].NumIid.ToString() + "\">减<input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeJian" + product.Content[i].NumIid.ToString() + "\" name=\"discountValue\" style=\"width:30px\" value=\"" + discountValue + "\" >元</div>";
if (discountValue != "")
{
newPrice2 = (decimal.Parse(price2) - decimal.Parse(discountValue)).ToString();
}
else
{
newPrice2 = price2;
}
}
}
else
{
hdstr = " <div id=\"add" + product.Content[i].NumIid.ToString() + "\"><a href=\"javascript:addItemAction(" + product.Content[i].NumIid.ToString() + ")\">参加活动</a></div>";
if (yuanitemtype == "same")
{
//same：每个参加活动的宝贝设置相同促销力度,different：每个参加活动的宝贝设置不同促销力度）
//decreaseNum 是否优惠限制（0,1）
if (yuandiscountType == "PRICE")
{
itemtype2 = "<select onchange=\"changeSelect(" + product.Content[i].NumIid.ToString() + ")\" id=\"discountType" + product.Content[i].NumIid.ToString() + "\" name=\"discountType\" > <option value=\"DISCOUNT\">打折</option><option selected=\"selected\" value=\"PRICE\">减价</option> </select>";
itemtypevalue2 = " <div id=\"zheDiv" + product.Content[i].NumIid.ToString() + "\" style=\"display: none;\"><input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeZhe" + product.Content[i].NumIid.ToString() + "\" value=\"\" name=\"discountValue\" style=\"width:30px\">折</div><div style=\"display:block ;\" id=\"jianDiv" + product.Content[i].NumIid.ToString() + "\">减<input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeJian" + product.Content[i].NumIid.ToString() + "\" name=\"discountValue\" style=\"width:30px\" value=\"" + yuandiscountValue + "\" >元</div>";
if (yuandecreaseNum == "0")
{
yhCount = " <span id=\"duojian" + product.Content[i].NumIid.ToString() + "\" style=\"display: none;\">多件<input type=\"hidden\" id=\"decreaseNumHiden" + product.Content[i].NumIid.ToString() + "\" value=\"0\" name=\"decreaseNumHiden\"></span> <span style=\"display: inline;\" id=\"yijian" + product.Content[i].NumIid.ToString() + "\"><select onchange=\"decreaseNumChange(" + product.Content[i].NumIid.ToString() + ")\" id=\"decreaseNumSel" + product.Content[i].NumIid.ToString() + "\" name=\"decreaseNumSel\"> <option selected=\"selected\" value=\"0\">多件</option> <option value=\"1\">一件</option> </select></span>";
}
else
{
yhCount = " <span id=\"duojian" + product.Content[i].NumIid.ToString() + "\" style=\"display: none;\">多件<input type=\"hidden\" id=\"decreaseNumHiden" + product.Content[i].NumIid.ToString() + "\" value=\"0\" name=\"decreaseNumHiden\"></span> <span style=\"display: inline;\" id=\"yijian" + product.Content[i].NumIid.ToString() + "\"><select onchange=\"decreaseNumChange(" + product.Content[i].NumIid.ToString() + ")\" id=\"decreaseNumSel" + product.Content[i].NumIid.ToString() + "\" name=\"decreaseNumSel\"> <option value=\"0\">多件</option> <option value=\"1\" selected=\"selected\">一件</option> </select></span>";
}
if (discountValue != "")
{
newPrice2 = (decimal.Parse(product.Content[i].Price) - decimal.Parse(yuandiscountValue)).ToString();
}
else
{
newPrice2 = product.Content[i].Price;
}
}
else
{
itemtype2 = "<select onchange=\"changeSelect(" + product.Content[i].NumIid.ToString() + ")\" id=\"discountType" + product.Content[i].NumIid.ToString() + "\" name=\"discountType\" > <option selected=\"selected\" value=\"DISCOUNT\">打折</option><option value=\"PRICE\">减价</option> </select>";
yhCount = " <span id=\"duojian" + product.Content[i].NumIid.ToString() + "\" style=\"display: inline;\">多件<input type=\"hidden\" id=\"decreaseNumHiden" + product.Content[i].NumIid.ToString() + "\" value=\"0\" name=\"decreaseNumHiden\"></span> <span style=\"display: none;\" id=\"yijian" + product.Content[i].NumIid.ToString() + "\"><select onchange=\"decreaseNumChange(" + product.Content[i].NumIid.ToString() + ")\" id=\"decreaseNumSel" + product.Content[i].NumIid.ToString() + "\" name=\"decreaseNumSel\"> <option selected=\"selected\" value=\"0\">多件</option> <option value=\"1\">一件</option> </select></span>";
itemtypevalue2 = " <div id=\"zheDiv" + product.Content[i].NumIid.ToString() + "\" style=\"display: block;\"><input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeZhe" + product.Content[i].NumIid.ToString() + "\" value=\"" + yuandiscountValue + "\" name=\"discountValue\" style=\"width:30px\">折</div><div style=\"display: none;\" id=\"jianDiv" + product.Content[i].NumIid.ToString() + "\">减<input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeJian" + product.Content[i].NumIid.ToString() + "\" name=\"discountValue\" style=\"width:30px\" value=\"\" >元</div>";
if (discountValue != "")
{
newPrice2 = (decimal.Parse(product.Content[i].Price) * decimal.Parse(yuandiscountValue) * 0.1m).ToString();
}
else
{
newPrice2 = product.Content[i].Price;
}
}
}
else
{
itemtype2 = "<select onchange=\"changeSelect(" + product.Content[i].NumIid.ToString() + ")\" id=\"discountType" + product.Content[i].NumIid.ToString() + "\" name=\"discountType\" > <option selected=\"selected\" value=\"DISCOUNT\">打折</option><option value=\"PRICE\">减价</option> </select>";
yhCount = " <span id=\"duojian" + product.Content[i].NumIid.ToString() + "\" style=\"display: inline;\">多件<input type=\"hidden\" id=\"decreaseNumHiden" + product.Content[i].NumIid.ToString() + "\" value=\"0\" name=\"decreaseNumHiden\"></span> <span style=\"display: none;\" id=\"yijian" + product.Content[i].NumIid.ToString() + "\"><select onchange=\"decreaseNumChange(" + product.Content[i].NumIid.ToString() + ")\" id=\"decreaseNumSel" + product.Content[i].NumIid.ToString() + "\" name=\"decreaseNumSel\"> <option selected=\"selected\" value=\"0\">多件</option> <option value=\"1\">一件</option> </select></span>";
itemtypevalue2 = " <div id=\"zheDiv" + product.Content[i].NumIid.ToString() + "\" style=\"display: block;\"><input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeZhe" + product.Content[i].NumIid.ToString() + "\" value=\"9\" name=\"discountValue\" style=\"width:30px\">折</div><div style=\"display: none;\" id=\"jianDiv" + product.Content[i].NumIid.ToString() + "\">减<input type=\"text\" onkeyup=\"blurValue(" + product.Content[i].NumIid.ToString() + ")\" id=\"changeJian" + product.Content[i].NumIid.ToString() + "\" name=\"discountValue\" style=\"width:30px\" value=\"\" >元</div>";
newPrice2 = product.Content[i].Price;
}
}
str += "<div id='div" + product.Content[i].NumIid.ToString() + "' width=\"800px\"><table width=\"800px\"><tr width=\"800px\"><td width=\"15px\"><!--<input type=\"checkbox\" id=\"" + product.Content[i].NumIid.ToString() + "\" class=\"selector\" value=\"" + product.Content[i].NumIid.ToString() + "\" name=\"iids\">--></td><td width=\"100px\"> <a href=\"http://item.taobao.com/item.htm?id=" + product.Content[i].NumIid.ToString() + "\" target=\"_blank\"><img src=\"" + product.Content[i].PicUrl + "_80x80.jpg\" width=\"50px\" height=\"50px\" border=\"0\" /></a></td>"; //图片
str += "<td width=\"140px\"><a href=\"http://item.taobao.com/item.htm?id=" + product.Content[i].NumIid.ToString() + "\" target=\"_blank\">" + product.Content[i].Title + "</a> </td>"; //名称
str += "<td width=\"70px\"> " + product.Content[i].Price + " <input type=\"hidden\" id=\"price" + product.Content[i].NumIid.ToString() + "\" name=\"price\" value=\"" + product.Content[i].Price.ToString() + "\"></td>"; //商品原价
str += "<td width=\"70px\" id=\"newPrice" + product.Content[i].NumIid.ToString() + "\"> " + newPrice2 + "</td>"; //促销价
str += "<td width=\"70px\"><div id=\"yhlxDiv" + product.Content[i].NumIid.ToString() + "\"> " + itemtype2 + "</div></td>"; //优惠类型
str += "<td width=\"70px\"> <div id=\"yhhdDiv" + product.Content[i].NumIid.ToString() + "\"> " + itemtypevalue2 + "</div></td>"; //优惠幅度
str += "<td width=\"70px\"> <div id=\"yhslDiv" + product.Content[i].NumIid.ToString() + "\">" + yhCount + "</div></td>"; //优惠数量
str += "<td width=\"70px\"> <input type=\"text\" id=\"Rcount" + product.Content[i].NumIid.ToString() + "\" name=\"Rcount\" style=\"width:30px\" value=\"" + Rcount + "\" ></td>"; //参团人数
str += "<td width=\"140px\">" + hdstr + " </td>"; //操作
str += "</tr></table></div>";
}
Response.Write(str);
Response.Write("<br>");
long totalPage = (product.TotalResults % pageSizeNow == 0) ? (product.TotalResults / pageSizeNow) : (product.TotalResults / pageSizeNow + 1);
//输出分页HTML
for (int i = 1; i <= totalPage; i++)
{
if (page == i.ToString())
{
Response.Write(i.ToString() + " ");
}
else
{
Response.Write("<a href=\"javascript:spreadStat(" + i.ToString() + ")\">[" + i.ToString() + "]</a> ");
}
}
Response.End();
}
}
private void Act(string uid, string taobaonick)
{
string sql = "SELECT * FROM TeteShop WHERE nick = '" + uid + "'";
DataTable dt = utils.ExecuteDataTable(sql);
if (dt.Rows.Count != 0)
{
//同步分类数据
TopXmlRestClient client = new TopXmlRestClient("http://gw.api.taobao.com/router/rest", dt.Rows[0]["appkey"].ToString(), dt.Rows[0]["appsecret"].ToString());
SellercatsListGetRequest request1 = new SellercatsListGetRequest();
request1.Fields = "cid,parent_cid,name,is_parent,";
request1.Nick = taobaonick;
PageList <SellerCat> cat = client.SellercatsListGet(request1);
//清除之前的老分类
//sql = "DELETE FROM TeteShopCategory WHERE nick = '" + uid + "'";
//utils.ExecuteNonQuery(sql);
for (int i = 0; i < cat.Content.Count; i++)
{
//过滤其他软件增加的分类
if (cat.Content[i].Name.IndexOf("统计") != -1 || cat.Content[i].Name.IndexOf("多买多优惠") != -1)
{
continue;
}
//如果已经存在则不处理
sql = "SELECT COUNT(*) FROM TeteShopCategory WHERE cateid='" + cat.Content[i].Cid + "'";
string count2 = utils.ExecuteString(sql);
if (count2 == "0")
{
sql = "INSERT INTO TeteShopCategory (" +
"cateid, " +
"catename, " +
"oldname, " +
"parentid, " +
"nick " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].Name + "', " +
" '" + cat.Content[i].ParentCid + "', " +
" '" + uid + "' " +
") ";
//Response.Write(sql + "<br>");
utils.ExecuteNonQuery(sql);
}
if (cat.Content[i].ParentCid == 0)
{
sql = "SELECT COUNT(*) FROM TeteShopAds WHERE nick = '" + uid + "' AND typ = '" + cat.Content[i].Cid + "'";
string count1 = utils.ExecuteString(sql);
if (count1 == "0")
{
sql = "INSERT INTO TeteShopAds (" +
"typ, " +
"url, " +
"orderid, " +
"nick " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" 'http://langbow.tmall.com', " +
" '1', " +
" '" + uid + "' " +
") ";
utils.ExecuteNonQuery(sql);
sql = "INSERT INTO TeteShopAds (" +
"typ, " +
"url, " +
"orderid, " +
"nick " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" 'http://langbow.tmall.com', " +
" '2', " +
" '" + uid + "' " +
") ";
utils.ExecuteNonQuery(sql);
sql = "INSERT INTO TeteShopAds (" +
"typ, " +
"url, " +
"orderid, " +
"nick " +
" ) VALUES ( " +
" '" + cat.Content[i].Cid + "', " +
" 'http://langbow.tmall.com', " +
" '3', " +
" '" + uid + "' " +
") ";
utils.ExecuteNonQuery(sql);
}
}
}
//清除之前的老商品数据
//sql = "DELETE FROM TeteShopItem WHERE nick = '" + uid + "'";
//utils.ExecuteNonQuery(sql);
//同步商品数据
for (int j = 1; j <= 500; j++)
{
ItemsOnsaleGetRequest request = new ItemsOnsaleGetRequest();
request.Fields = "num_iid,title,price,pic_url,seller_cids";
request.PageSize = 200;
request.PageNo = j;
PageList <Item> product = client.ItemsOnsaleGet(request, dt.Rows[0]["session"].ToString());
for (int i = 0; i < product.Content.Count; i++)
{
//Response.Write(i.ToString() + "--" + product.Content[i].Title + "<br>");
sql = "SELECT COUNT(*) FROM TeteShopItem WHERE nick = '" + uid + "' AND itemid = '" + product.Content[i].NumIid + "'";
string count3 = utils.ExecuteString(sql);
//Response.Write(count3 + "<br>");
if (count3 == "0")
{
sql = "INSERT INTO TeteShopItem (" +
"cateid, " +
"itemid, " +
"itemname, " +
"picurl, " +
"linkurl, " +
"price, " +
"nick " +
" ) VALUES ( " +
" '" + product.Content[i].SellerCids + "', " +
" '" + product.Content[i].NumIid + "', " +
" '" + product.Content[i].Title + "', " +
" '" + product.Content[i].PicUrl + "', " +
" 'http://a.m.taobao.com/i" + product.Content[i].NumIid + ".htm', " +
" '" + product.Content[i].Price + "', " +
" '" + uid + "' " +
") ";
utils.ExecuteNonQuery(sql);
Response.Write(sql + "<br>");
//更新分类数量
sql = "UPDATE TeteShopCategory SET catecount = catecount + 1 WHERE nick = '" + uid + "' AND CHARINDEX(cateid, '" + product.Content[i].SellerCids + "') > 0";
Response.Write(sql + "<br>");
utils.ExecuteNonQuery(sql);
}
else
{
sql = "UPDATE TeteShopItem SET cateid = '" + product.Content[i].SellerCids + "' WHERE itemid = '" + product.Content[i].NumIid + "'";
Response.Write(sql + "<br>");
utils.ExecuteNonQuery(sql);
}
}
//Response.Write(product.Content.Count + "<br>");
if (product.Content.Count < 200)
{
break;
}
}
//更新大类商品数量
sql = "SELECT * FROM TeteShopCategory WHERE nick = '" + uid + "' AND parentid <> 0";
DataTable dtCate = utils.ExecuteDataTable(sql);
for (int k = 0; k < dtCate.Rows.Count; k++)
{
//Response.Write(sql + "<br>");
sql = "UPDATE TeteShopCategory SET catecount = catecount + " + dtCate.Rows[k]["catecount"].ToString() + " WHERE nick = '" + uid + "' AND cateid = " + dtCate.Rows[k]["parentid"].ToString();
utils.ExecuteNonQuery(sql);
}
}
}
