public Task <TEntity> GetAsync <TEntity>(object param)
where TEntity : ITableDto
{
var query = queryFactory.GetSingleQuery <TEntity>();
return(uk.DbConnection.QueryFirstOrDefaultAsync <TEntity>(query, param, uk.DbTransaction));
}
public Task <TEntity> GetAsync <TEntity>(object param)
where TEntity : ITableDto
{
var query = queryFactory.GetSingleQuery <TEntity>();
logger.LogDebug("GetAsync query:{query} param:{@param}", query, param);
return(uk.DbConnection.QueryFirstOrDefaultAsync <TEntity>(query, param, uk.DbTransaction));
}
public TEntity Get <TEntity>(object param)
where TEntity : class
{
var query = queryFactory.GetSingleQuery <TEntity>();
// logger.LogDebug("GetAsync query:{query} param:{@param}", query, param);
return(Conn.QueryFirstOrDefault <TEntity>(query, param, Tran));
}
public async Task <ProcessHistory> GetAsync(Guid id, bool includeDetails = false)
{
ProcessHistoryDto item = default;
// var sql = $"SELECT " +
// $"{string.Join(", ", item.GetColumns().Select(c => c.Key))} " +
// $"FROM {item.GetTableName()} " +
// $"WHERE {nameof(ProcessHistoryDto.Id)} = @ProcessHistoryId";
var query = tableQuery.GetSingleQuery <ProcessHistoryDto>();
item = await DbConnection.QueryFirstAsync <ProcessHistoryDto>(query, new ProcessHistoryDto { Id = id }, DbTransaction);
item.Interruption = await GetInterruptionHistoryDtoAsync(item.Id);
if (!string.IsNullOrEmpty(item.ProductSpecificationCode))
{
item.ProductSpecification = await GetProductSpecificationDtoAsync(item.ProductSpecificationCode);
}
return(mapper.Map <ProcessHistory>(item));
}
public void Test_table_config_builder()
{
var tablesFactory = new TableQueryFactory(Dialect.SQLite);
tablesFactory.ConfigureTable <ProcessHistoryModel>("ProcessHistory", cfgTbl =>
{
ProcessHistoryModel dto = cfgTbl.Table;
cfgTbl.AddColumn(nameof(dto.Id), "ProcessHistoryId", false, true);
cfgTbl.AddColumn(nameof(dto.StartProcessDateTime));
cfgTbl.AddColumn(nameof(dto.FinishProcessDateTime));
cfgTbl.AddColumn(nameof(dto.ProductSpecificationCode));
});
tablesFactory.ConfigureTable <InterruptionHistoryModel>("InterruptionHistory", cfgTbl =>
{
InterruptionHistoryModel dto = cfgTbl.Table;
cfgTbl.AddColumn(nameof(dto.Id), null, true, true);
cfgTbl.AddColumn(nameof(dto.ProcessHistoryId));
cfgTbl.AddColumn(nameof(dto.StartDateTime));
cfgTbl.AddColumn(nameof(dto.EndDateTime));
});
tablesFactory.ConfigureTable <ProductSpecificationModel>("ProductSpecification", cfgTbl =>
{
cfgTbl.AddColumn(c => c.Id, null, false, false);
cfgTbl.AddColumn(c => c.Code);
cfgTbl.AddColumn(c => c.StandarDuration);
cfgTbl.AddColumn(c => c.CreatedAt, c => { c.IgnoreInsert = true; c.IgnoreUpdate = true; });
});
var res = tablesFactory.GetPagedListQuery <ProcessHistoryModel>();
res = tablesFactory.GetSingleQuery <ProcessHistoryModel>();
res = tablesFactory.GetDeleteQuery <ProcessHistoryModel>();
res = tablesFactory.GetUpdateQuery <ProcessHistoryModel>();
res = tablesFactory.GetUpdateQuery <ProductSpecificationModel>();
bool isIdentity;
var res2 = tablesFactory.GetInsertQuery <ProcessHistoryModel>();
Console.WriteLine(res);
}