/// <summary>
/// 下载的图片是否为压缩图
/// </summary>
/// <param name="isZipImage">压缩图</param>
/// <returns></returns>
public List <string> DownLoadImage(bool isZipImage)
{
List <WaitGatherImage> waits = GetWaitGatherImageData();
List <string> paths = new List <string>();
foreach (WaitGatherImage item in waits)
{
if (string.IsNullOrEmpty(item.HeadImageUrl))
{
continue;
}
string path = GatherImage(item.HeadImageUrl, item.Uin, item.LocalCity, isZipImage);
string sp = string.Empty;
if (!string.IsNullOrEmpty(path))
{
sp = string.Format("exec [SP_SuccessGatherImageList] '{0}','{1}'", item.Id, path);
paths.Add(path);
}
else
{
sp = string.Format("exec [SP_ErrorGatherImageList] '{0}'", item.Id);
}
MainRespority <FindQQDataTable> main = new MainRespority <FindQQDataTable>(TecentDA);
main.ExecuteSPNoQuery(sp, null);
}
return(paths);
}
/// <summary>
///
/// </summary>
/// <param name="key"> "City"</param>
/// <returns></returns>
public IEnumerable <CategoryData> QueryCityCategory(string key)
{
MainRespority <CategoryData> main = new MainRespority <CategoryData>(ConnString);
IEnumerable <CategoryData> data = main.Query(t => !t.IsDelete && t.ItemType == key && !string.IsNullOrEmpty(t.Name));
//将数据同步到sqlite :TecentDASQLite
return(data);
}
/// <summary>
/// 统计当前今天统计数目
/// </summary>
public int CountTodayPickUp()
{
TodayStaticData();
string sp = "exec SP_StaticCountToday";
MainRespority <FindQQDataTable> main = new MainRespority <FindQQDataTable>(ConnString);
List <int> ret = main.ExecuteSPSelect <int>(sp, null).ToList();
if (ret.Any())
{
return(ret[0]);
}
return(0);
}
public void SaveCategoryNode(List <CategoryData> data)
{
try
{
DateTime now = DateTime.Now;
foreach (CategoryData item in data)
{
item.IsDelete = false;
item.CreateTime = now;
}
MainRespority <CategoryData> mr = new MainRespority <CategoryData>(ConnString);
mr.InsertList(data);
}
catch (Exception ex)
{
}
}
public PickUpStatic TodayStaticData()
{
try
{
DateTime today = DateTime.Now;
string sp = string.Format("exec SP_PickUpStaticWithDay '{0}'", today);
MainRespority <FindQQDataTable> main = new MainRespority <FindQQDataTable>(ConnString);
//其他信息: Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
List <PickUpStatic> staticData = main.ExecuteSPSelect <PickUpStatic>(sp, null).ToList();
return(staticData.FirstOrDefault());
}
catch (Exception ex)
{
string logPath = (new AssemblyDataExt()).GetAssemblyDir() + "\\" + ELogType.ErrorLog; //new ConfigurationItems().LogPath + GeneratePathTimeSpan(cookie);
LoggerWriter.CreateLogFile(ex.Message, logPath, ELogType.ErrorLog);
return(new PickUpStatic());
}
}
public void SaveQQ(List <FindQQDataTable> data)
{
try
{
//此处功能修正：使用SQL
MainRespority <FindQQDataTable> mr = new MainRespority <FindQQDataTable>(ConnString); DateTime now = DateTime.Now;
List <FindQQDataTable> ds = new List <FindQQDataTable>();
foreach (FindQQDataTable item in data)
{
item.ID = Guid.NewGuid();
item.CreateTime = now;
if (string.IsNullOrEmpty(item.Url))//没有采集到该账户的头像数据
{
item.ImgType = -1;
}
item.DayInt = int.Parse(now.ToString("yyyyMMdd"));
ds.Add(item);
}
mr.InsertList(ds);
}
catch (Exception ex) { }
}
List <WaitGatherImage> GetWaitGatherImageData()
{
DateTime today = DateTime.Now;
string sp = string.Format("exec [SP_GetWaitGatherImageList] ", today);
MainRespority <FindQQDataTable> main = new MainRespority <FindQQDataTable>(TecentDA);
List <WaitGatherImage> list = main.ExecuteSPSelect <WaitGatherImage>(sp, null).ToList();
//采集到的头像URL可能存在相同的需要进行过滤
/*
* 头像URL采集需要过滤掉 同一个qq没有更换头像，以及同一个头像多个qq使用的情况
*/
List <WaitGatherImage> result = new List <WaitGatherImage>();
foreach (WaitGatherImage item in list)
{
if (!result.Any(url => url.HeadImageUrl == item.HeadImageUrl))
{
result.Add(item);
}
}
return(result);
}
public bool InsertContact()
{
MainRespority <FullContact> mr = new MainRespority <FullContact>(ConnString);
return(false);
}
public bool SaveList(List <IpDataMapTable> ips)
{
MainRespority <IpDataMapTable> mr = new MainRespority <IpDataMapTable>(SqlConnString);
return(mr.InsertList(ips));
}
