namespace WIDESEA_StorageTaskRepository;
|
|
public class Dt_TaskRepository : RepositoryBase<Dt_Task>, IDt_TaskRepository
|
{
|
public Dt_TaskRepository(IUnitOfWorkManage unitOfWorkManage) : base(unitOfWorkManage)
|
{
|
}
|
|
public async Task<Dt_Task> Create(Dt_Task model)
|
{
|
return await Db.Insertable(model).ExecuteReturnEntityAsync();
|
}
|
|
public async Task<bool> Create(List<Dt_Task> models)
|
{
|
var num = Db.Insertable(models).ExecuteCommand();
|
if (num == models.Count)
|
return await Task.FromResult(true);
|
else
|
return await Task.FromResult(false);
|
}
|
|
public async Task<bool> Delete(int id)
|
{
|
return await Db.Deleteable<Dt_Task>().In(id).ExecuteCommandHasChangeAsync();
|
}
|
|
public async Task<bool> Delete(List<int> ids)
|
{
|
return await Db.Deleteable<Dt_Task>().In(ids.ToArray()).ExecuteCommandHasChangeAsync();
|
}
|
|
public async Task<Dt_Task> GetById(int id)
|
{
|
return await Db.Queryable<Dt_Task>().InSingleAsync(id);
|
}
|
|
public async Task<List<Dt_Task>> GetList()
|
{
|
return await Db.Queryable<Dt_Task>().ToListAsync();
|
}
|
|
public Task<List<Dt_Task>> GetListByOutOrder(int outOrderId)
|
{
|
throw new NotImplementedException();
|
}
|
|
public Task<List<Dt_Task>> GetListByOutOrderAndStatus(int outOrderId, int status)
|
{
|
throw new NotImplementedException();
|
}
|
|
public async Task<List<Dt_Task>> GetListByStatus(int status)
|
{
|
return await Db.Queryable<Dt_Task>().Where(x => x.TaskState == status).ToListAsync();
|
}
|
|
public Task<int> GetTaskNo()
|
{
|
string sql = "select next value for dbo.GetTaskNum";
|
return Db.Ado.SqlQuerySingleAsync<int>(sql);
|
}
|
|
public async Task<bool> Update(Dt_Task model)
|
{
|
return await Db.Updateable(model).ExecuteCommandHasChangeAsync();
|
}
|
|
public async Task<bool> Update(List<Dt_Task> models)
|
{
|
return await Db.Updateable(models).ExecuteCommandHasChangeAsync();
|
}
|
}
|
