/// <summary>
/// 系统配置实体的赋值
/// </summary>
/// <param name="configuration"></param>
/// <param name="reader"></param>
/// <param name="prefix"></param>
public static void SetTokenCredentialGeneratorSelectFields(TokenCredentialGenerator generator, DbDataReader reader, string prefix)
{
generator.ID = (Guid)reader[string.Format("{0}id", prefix)];
generator.Name = reader[string.Format("{0}name", prefix)].ToString();
generator.Type = reader[string.Format("{0}type", prefix)].ToString();
generator.Configuration = reader[string.Format("{0}configuration", prefix)].ToString();
generator.CreateTime = (DateTime)reader[string.Format("{0}createtime", prefix)];
generator.ModifyTime = (DateTime)reader[string.Format("{0}modifytime", prefix)];
}
public async Task <TokenCredentialGenerator> QueryByName(string name)
{
TokenCredentialGenerator generator = null;
await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, true, false, _azureInfoConnectionFactory.CreateReadForAzureInfo(), async(conn, transaction) =>
{
SqlTransaction sqlTran = null;
if (transaction != null)
{
sqlTran = (SqlTransaction)transaction;
}
await using (SqlCommand commond = new SqlCommand()
{
Connection = (SqlConnection)conn,
CommandType = CommandType.Text,
CommandText = string.Format(@"select {0} from TokenCredentialGenerator where [name]=@name", StoreHelper.GetTokenCredentialGeneratorSelectFields(string.Empty)),
Transaction = sqlTran
})
{
var parameter = new SqlParameter("@name", SqlDbType.VarChar, 100)
{
Value = name
};
commond.Parameters.Add(parameter);
await commond.PrepareAsync();
SqlDataReader reader = null;
await using (reader = await commond.ExecuteReaderAsync())
{
if (await reader.ReadAsync())
{
generator = new TokenCredentialGenerator();
StoreHelper.SetTokenCredentialGeneratorSelectFields(generator, reader, string.Empty);
}
await reader.CloseAsync();
}
}
});
return(generator);
}
