/// <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 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());
}
}
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);
}
