private void Execute(DbConnectionInfoItem connectionInfo, string query)
{
var connectionString = ConnectionStringMaker.Make(connectionInfo.ConnectionIp, connectionInfo.ConnectionDatabase, connectionInfo.ConnectionId, connectionInfo.ConnectionPassword);
var cod = CODCreator.GetCOD(connectionString);
var executeQuery = new ListQuery <NameValueItem> {
Query = query
};
try
{
var result = cod.Query(executeQuery);
connectionInfo.Status = "완료";
var sb = new StringBuilder();
if (result.Count() > 0)
{
var tdic = result[0].GetDic();
var keys = tdic.Keys;
sb.AppendLine(string.Join("|", tdic.Keys));
result.ForEach(t =>
{
sb.AppendLine(string.Join("|", keys.Select(k => t.GetString(k))));
});
}
connectionInfo.Message = sb.ToString();
}
catch (Exception ex)
{
connectionInfo.Status = "오류";
connectionInfo.Message = ex.Message;
}
}
private bool UserFilter(object item)
{
DbConnectionInfoItem dbItem = item as DbConnectionInfoItem;
bool isShow = DatabaseSelectedList.Where(t => t.Checked).Select(t => t.Name).Contains(dbItem.ConnectionDatabase, StringComparer.OrdinalIgnoreCase) &&
PurposeSelectedList.Where(t => t.Checked).Select(t => t.Name).Contains(dbItem.Purpose.ToString(), StringComparer.OrdinalIgnoreCase) &&
DescriptionSelectedList.Where(t => t.Checked).Select(t => t.Name).Contains(dbItem.Description.Split(" - ")[1], StringComparer.OrdinalIgnoreCase);
if (!isShow)
{
dbItem.Checked = false;
}
return(isShow);
}
