public IEnumerable <MWLog> SelectLog(LookupCondition lookupCondition)
{
List <MWLog> retList = new List <MWLog>();
using (var conn = new MySqlConnection(connString))
{
conn.Open();
using (var cmd = new MySqlCommand())
{
string sql = "select * from log_info limt 10;";
cmd.Connection = conn;
//cmd.CommandText = EmbeddedResource.GetString("SelectLogInfoWithLogProperty.sql");
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("begin_date", lookupCondition.BeginDate.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("end_date", lookupCondition.EndDate.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("routing_key", "%" + lookupCondition.RoutingKey + "%");
cmd.Parameters.AddWithValue("limit", lookupCondition.Limit);
cmd.Prepare();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
retList.Add(ModelConverter.ToMWLog(reader));
}
}
}
}
return(retList);
}
public async Task <IEnumerable <MWLog> > SelectLogAsync(LookupCondition lookupCondition)
{
List <MWLog> retList = new List <MWLog>();
using (var conn = new MySqlConnection(connString))
{
await conn.OpenAsync();
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
//string sql = "select info.*, prop.* from log_info info join log_property prop on info.property_seq = prop.seq order by info.seq desc limit 10;";
//cmd.CommandText = sql;
cmd.CommandText = EmbeddedResource.GetString("SelectLogInfoWithLogProperty.sql");
cmd.Parameters.AddWithValue("begin_date", lookupCondition.BeginDate.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("end_date", lookupCondition.EndDate.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("routing_key", "%" + lookupCondition.RoutingKey + "%");
cmd.Parameters.AddWithValue("limit", lookupCondition.Limit);
cmd.Prepare();
using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
retList.Add(ModelConverter.ToMWLog(reader));
}
}
}
}
return(retList);
}
public async Task <IEnumerable <MWLog> > GetLogsAsync(LookupCondition lookupCondition)
{
if (lookupCondition.Seq > 0)
{
return(await new MWLogData().SelectLogAsync(lookupCondition.Seq));
}
return(await new MWLogData().SelectLogAsync(lookupCondition));
}
public IEnumerable <MWLog> GetLogs(LookupCondition lookupCondition)
{
if (lookupCondition.Seq > 0)
{
return(new MWLogData().SelectLog(lookupCondition.Seq));
}
return(new MWLogData().SelectLog(lookupCondition));
}
private void GetLogs()
{
var lookupCondition = new LookupCondition
{
BeginDate = dtBeginDate.SelectedDate.Value,
EndDate = dtEndDate.SelectedDate.Value.AddDays(1),
Seq = (!string.IsNullOrEmpty(txtSeq.Text)) ? Convert.ToInt32(txtSeq.Text.ToString()) : 0,
RoutingKey = txtRoutingKey.Text,
Limit = Convert.ToInt32(txtLimit.Text.ToString())
};
vm.MWLogCollection = new ObservableCollection <MWLog>(new MWLogService().GetLogs(lookupCondition));
LogListView.ItemsSource = vm.MWLogCollection;
}
private async void GetLogsAsync()
{
try
{
var lookupCondition = new LookupCondition
{
BeginDate = dtBeginDate.SelectedDate.Value,
EndDate = dtEndDate.SelectedDate.Value.AddDays(1),
Seq = (!string.IsNullOrEmpty(txtSeq.Text)) ? Convert.ToInt32(txtSeq.Text.ToString()) : 0,
RoutingKey = txtRoutingKey.Text,
Limit = Convert.ToInt32(txtLimit.Text.ToString())
};
vm.MWLogCollection = new ObservableCollection <MWLog>(await new MWLogService().GetLogsAsync(lookupCondition));
LogListView.ItemsSource = vm.MWLogCollection;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
