public List <CriticalData> selectCriticalData()
{
Program.WriteLog("查询要上传的关键数据");
CriticalDataBLL bll = new CriticalDataBLL();
List <CriticalData> listA = bll.SelectCricialData(Program.g_lcNumber, "1", 3); //查询前3条数据
List <CriticalData> listB = bll.SelectCricialData(Program.g_lcNumber, "0", 3); //未上传的前90条
listA.AddRange(listB); //把集合A.B合并
List <CriticalData> ResultcriticalList = listA.Union(listB).ToList <CriticalData>(); //剔除重复项
return(ResultcriticalList);
}
private void deletOverTimeData()
{
// delete FROM CriticalData where saveTime > '2017-05-21 15:27:19'
DateTime dt = DateTime.Now;
CriticalDataBLL bll = new CriticalDataBLL();
DateTime datetime = dt.AddMonths(-1);
if (bll.deleteCricialData(Program.g_lcNumber, datetime))
{
Program.WriteLog("清理过期的数据库数据");
}
}
