/// <summary>
/// 获取计划 （默认获取所有计划）
/// </summary>
/// <returns></returns>
public static List <string[]> SearchPlan(string sele = "SELECT * FROM PlanTB")
{
SQLiteDB.Open();
return(SQLiteDB.Run(sele, (list) => {
return SQLiteDB.SaveData(SQLiteDB.sdr, list);
}, new List <string[]>()));
}
/// <summary>
/// 搜索今日计划
/// </summary>
public static void SearchForTodayPlan(List <string[]> PlanDatas, List <p_Plan> Plans, FlowLayoutPanel flp_Plan)
{
Tools.PlanDataLock = true;
SQLiteDB.Open();
//2019-09-20 12:28:18.000
string DoW = DateTime.Now.DayOfWeek.ToString("d") == "0" ? "7" : DateTime.Now.DayOfWeek.ToString("d"); //判断是否为周日
DateTime dt1 = DateTime.Now.Date;
DateTime dt2 = dt1.AddDays(1); // 查询重复的
string sele = $"SELECT * FROM PlanTB WHERE datetime(PlanDateTime) >= datetime('{dt1.ToString("yyyy-MM-dd HH:mm")}') and datetime(PlanDateTime) <= datetime('{dt2.ToString("yyyy-MM-dd HH:mm")}') and RepetitionPeriod = -1 or RepetitionPeriod = 0 or RepetitionPeriod = 1 and RepetitionDays like '%,{DoW},%' or RepetitionPeriod = 2 and RepetitionDays like '%,{DateTime.Now.Day},%';";
//sele = "SELECT * FROM PlanTB";--
PlanDatas = SQLiteDB.Run(sele, (list) => {
return(SQLiteDB.SaveData(SQLiteDB.sdr, list));
}, PlanDatas);
SQLiteDB.Close();
//PlanDatas.AddRange(Tools.SearchRepetitionDays());
SQLiteDB.Close();
Tools.PlanDataLock = false;
Tools.ShowPlans(PlanDatas, Plans, flp_Plan);
}