internal List <IValidation> GetValidations()
{
if (string.IsNullOrEmpty(ConnectString) || string.IsNullOrEmpty(EmailTo) || string.IsNullOrEmpty(EmailPassword) || string.IsNullOrEmpty(EmailSmtpServer) || string.IsNullOrEmpty(EmailUser))
{
return(null);
}
var conn = DataSourceUtil.GetConnection(Source, ConnectString);
List <IValidation> results = new List <IValidation>();
foreach (var rule in Rules)
{
results.Add(rule.GetValidation(conn));
}
return(results);
}
protected List <Dictionary <string, object> > PrepareDatas()
{
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
using (var conn = DataSourceUtil.GetConnection(Source, ConnectString))
{
string sql = QueryString;
conn.Open();
var command = conn.CreateCommand();
command.CommandText = sql;
command.CommandTimeout = 60000;
command.CommandType = CommandType.Text;
var reader = command.ExecuteReader();
while (reader.Read())
{
Dictionary <string, object> data = new Dictionary <string, object>();
int count = reader.FieldCount;
for (int i = 0; i < count; ++i)
{
string name = reader.GetName(i);
data.Add(name, reader.GetValue(i));
}
if (Extras != null)
{
foreach (var extra in Extras)
{
data.Add(extra.Key, extra.Value);
}
}
list.Add(data);
}
#if !NET_CORE
reader.Close();
#else
reader.Dispose();
#endif
}
return(list);
}
