/// <summary>
/// 删除信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool DeleteDailyCheck(int id)
{
return(Sys_DailyCheckBLL.Delete(id));
}
/// <summary>
/// 得到今天的任务
/// </summary>
/// <param name="mUid"></param>
/// <returns></returns>
public static List <Sys_DailyCheckBase> GetNowTaskList(int mUid)
{
DateTime nowDate = DateTime.Now.Date;
int week = (int)nowDate.DayOfWeek;
string columnName = "ID,TaskName,IsRepeat,RepeatType,RepeatTime,RemindTime,Reminder";
#region 得到只有今天 才提醒的信息
//得到单次 今天任务
List <DapperWhere> oneRemind = new List <DapperWhere>();
oneRemind.Add(new DapperWhere("IsRepeat", 0));
oneRemind.Add(new DapperWhere("RepeatType", 1));
oneRemind.Add(new DapperWhere("TaskStatus", 0));
oneRemind.Add(new DapperWhere("RemindTime", nowDate.Add(new TimeSpan(23, 59, 59)), "RemindTime between cast(@RemindTime as date) and @RemindTime"));
oneRemind.Add(new DapperWhere("Reminder", mUid.ToString(), "Reminder like '%,'+ @Reminder +',%'"));
List <Sys_DailyCheckBase> oneList = Sys_DailyCheckBLL.GetList <Sys_DailyCheckBase>(0, columnName, oneRemind, " Id asc");
#endregion
#region 得到每周都会显示
//得到每周 今天任务
string weekString = "";
switch (week)
{
case 0:
weekString = "七";
break;
case 1:
weekString = "一";
break;
case 2:
weekString = "二";
break;
case 3:
weekString = "三";
break;
case 4:
weekString = "四";
break;
case 5:
weekString = "五";
break;
case 6:
weekString = "六";
break;
}
List <DapperWhere> weekRemind = new List <DapperWhere>();
weekRemind.Add(new DapperWhere("IsRepeat", 1));
weekRemind.Add(new DapperWhere("RepeatType", 2));
weekRemind.Add(new DapperWhere("TaskStatus", 0));
weekRemind.Add(new DapperWhere("Reminder", mUid.ToString(), "Reminder like '%,'+ @Reminder +',%'"));
weekRemind.Add(new DapperWhere("RepeatTime", weekString, "RepeatTime like '%,'+ @RepeatTime +',%'"));
List <Sys_DailyCheckBase> weekList = Sys_DailyCheckBLL.GetList <Sys_DailyCheckBase>(0, columnName, weekRemind, " id asc ");
#endregion
#region 得到 当日 这一号的拽住
List <DapperWhere> dateRemind = new List <DapperWhere>();
dateRemind.Add(new DapperWhere("IsRepeat", 1));
dateRemind.Add(new DapperWhere("RepeatType", 3));
dateRemind.Add(new DapperWhere("TaskStatus", 0));
dateRemind.Add(new DapperWhere("Reminder", mUid.ToString(), "Reminder like '%,'+ @Reminder +',%'"));
dateRemind.Add(new DapperWhere("RepeatTime", nowDate.Day.ToString(), "RepeatTime like '%,'+ @RepeatTime +',%'"));
List <Sys_DailyCheckBase> dateList = Sys_DailyCheckBLL.GetList <Sys_DailyCheckBase>(0, columnName, dateRemind, " id asc ");
#endregion
List <Sys_DailyCheckBase> allList = new List <Sys_DailyCheckBase>();
if (oneList != null && oneList.Count > 0)
{
allList.AddRange(oneList);
}
if (weekList != null && weekList.Count > 0)
{
allList.AddRange(weekList);
}
if (dateList != null && dateList.Count > 0)
{
allList.AddRange(dateList);
}
return(allList);
}
/// <summary>
/// 新增加
/// </summary>
/// <param name="dailyModel"></param>
/// <returns></returns>
public static int AddTask(Sys_DailyCheck dailyModel)
{
return(Sys_DailyCheckBLL.AddTask(dailyModel));
}
