using PetaPoco;
|
using System;
|
using System.Collections.Generic;
|
|
namespace Bootstrap.DataAccess
|
{
|
/// <summary>
|
///
|
/// </summary>
|
[TableName("Tasks")]
|
public class Task
|
{
|
/// <summary>
|
/// 获取/设置 任务ID
|
/// </summary>
|
public string? Id { get; set; }
|
|
/// <summary>
|
/// 获取/设置 任务名称
|
/// </summary>
|
public string TaskName { get; set; } = "";
|
|
/// <summary>
|
/// 获取/设置 分配人
|
/// </summary>
|
public string AssignName { get; set; } = "";
|
|
/// <summary>
|
/// 获得/设置 分配人昵称
|
/// </summary>
|
[ResultColumn]
|
public string AssignDisplayName { get; set; } = "";
|
|
/// <summary>
|
/// 获取/设置 完成任务人
|
/// </summary>
|
public string UserName { get; set; } = "";
|
|
/// <summary>
|
/// 获取/设置 任务所需时间（天）
|
/// </summary>
|
public int TaskTime { get; set; }
|
|
/// <summary>
|
/// 获取/设置 任务进度
|
/// </summary>
|
public double TaskProgress { get; set; }
|
|
/// <summary>
|
/// 获取/设置 分配时间
|
/// </summary>
|
public DateTime AssignTime { get; set; }
|
|
/// <summary>
|
/// 查询所有任务
|
/// </summary>
|
/// <returns></returns>
|
public virtual IEnumerable<Task> Retrieves()
|
{
|
using var db = DbManager.Create();
|
return db.SkipTake<Task>(0, 1000, "select t.*, u.DisplayName AssignDisplayName from Tasks t inner join Users u on t.UserName = u.UserName order by AssignTime desc");
|
}
|
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="task"></param>
|
/// <returns></returns>
|
public virtual bool Save(Task task)
|
{
|
using var db = DbManager.Create();
|
db.Save(task);
|
return true;
|
}
|
}
|
}
|
