public static void Log()
{
StringBuilder sb = new StringBuilder();
sb.Append(String.Format("{0},", _id));
_id++;
DateTime now = DateTime.Now;
sb.Append(now.ToString("yyyy-MM-ddTHH:mm:ss"));
//sb.Append(now.ToString(myDTFI.UniversalSortableDateTimePattern));
sb.Append(String.Format(".{0},", now.Millisecond));
//sb.Append(",");
sb.Append(now.ToString("MM/dd/yyyy"));
sb.Append(",");
sb.Append(now.ToString("HH:mm:ss"));
//sb.Append(String.Format(".{0},",now.Millisecond));
sb.Append(",");
for (int i = 0; i < m_loggedValueNames.Count; i++)
{
string vName = (string)m_loggedValueNames[i];
if (m_measuredValues.ContainsKey(vName))
{
Loggable loggable = (Loggable)m_measuredValues[vName];
sb.Append(loggable.toLogValueString());
}
sb.Append(",");
}
sb.Remove(sb.Length - 1, 1);
Logger.writeLine(sb.ToString());
}
public static Intersection <Person, Loggable> GetLoggablePerson(string name, int id)
{
var person = new Person(name);
var loggable = new Loggable(id);
//@ person.Log = loggable.Log;
//@ person.id = loggable.id;
return(person);
}
public bool TestConnection()
{
try
{
DatabaseFactory.TestConnection(Connection);
Loggable.Log(ConnectionSuccess);
return(true);
}
catch (ArgumentException e)
{
Loggable.Log(e.Message);
}
return(false);
}
public bool SelectDatabase(string dbName)
{
if (Connection == null || Connection.State != ConnectionState.Open)
{
Loggable.Log(ConnectionNotOpenMsg);
return(false);
}
if (string.IsNullOrEmpty(dbName) || !dbName.Contains(Config.DatabaseNamePrefix))
{
Loggable.Log(InvalidDatabase);
return(false);
}
DbProperties.DatabaseName = dbName;
Connection.Close();
return(InitConnection(DbProperties) != null);
}
public List <string> GetDatabases()
{
if (Connection == null || Connection.State != ConnectionState.Open)
{
Loggable.Log(ConnectionNotOpenMsg);
return(new List <string>());
}
var cmd = new MySqlCommand("SHOW DATABASES", Connection);
var reader = cmd.ExecuteReader();
var databases = new List <string>();
while (reader.Read())
{
var dbName = reader["Database"].ToString();
if (dbName.Contains(Config.DatabaseNamePrefix))
{
databases.Add(dbName);
}
}
reader.Close();
return(databases);
}
public override void Subscribe(Loggable loggable)
{
Repository.Subscribe(loggable);
}
/// <summary>
/// 接続中のDBConの状態を一覧表示する
/// </summary>
public void DumpStatus(Loggable logger = null)
{
DumpStatus((logger ?? this).Logger);
}
private void grid_DataError(object sender, DataGridViewDataErrorEventArgs e)
{
e.Cancel = true;
Loggable.Log(ErrorOnRow + (e.RowIndex + 1));
}
