public static int GetQTKData(out int success, out int error)
{
DateTime dtStart = DateTime.Now;
string appkey = ConfigService.QTKAppKey;
int maxPage = 120;
long result = 0;
success = 0;
error = 0;
string url = "http://openapi.qingtaoke.com/qingsoulist?sort=2&page={0}&app_key=" + appkey + "&v=1.0";
string response = "";
List <Product_QTK> pList = new List <Product_QTK>();
Product_QTK oldProduct = new Product_QTK();
JObject first;
JObject data;
for (int i = 1; i <= maxPage; i++)
{
response = RequestUtility.GetData(string.Format(url, i));
if (!string.IsNullOrEmpty(response))
{
first = JObject.Parse(response);
if (first["er_code"] != null && Convert.ToInt32(first["er_code"]) == (int)Product_QTK_Code.Success)
{
data = JObject.Parse(first["data"].ToString());
pList = JsonUtility.JsonDeserialize <Product_QTK>(data["list"].ToString());
foreach (Product_QTK item in pList)
{
result = 0;
if (item != null && item.goods_id > 0)
{
item.addedtime = DateTime.Now;
oldProduct = GetInfo(item.goods_id);
if (oldProduct != null)
{
result = Update(item);
}
else
{
result = Add(item);
}
if (result > 0)
{
success++;
}
else
{
error++;
}
}
}
}
}
}
return(0);
}
public static int Update(Product_QTK p)
{
return(MySqlHelper.context.Update(p));
}
public static long Add(Product_QTK p)
{
Product_QTK newP = MySqlHelper.context.Insert(p);
return(newP.goods_id);
}