public static void WriteVBALogIntoDB(string DomainGUID, string TaskChainGUID, string TaskName, VBALog vlog)
{
using (OleDbConnection logdbcon = new OleDbConnection(ms_connstring))
{
string cmdstr = null;
try
{
logdbcon.Open();
foreach (VBALog.LogList l in vlog.Loglists)
{
cmdstr = "INSERT INTO Log(DomainGUID,TaskChainGUID,LogTime,LogLevel,LogMessage) VALUES('" + DomainGUID + "','" + TaskChainGUID + "','" +l.errtime + "','" + l.errlevel.ToString() + "','" + l.errmessage + "')";
OleDbCommand cmd = new OleDbCommand(cmdstr, logdbcon);
cmd.ExecuteNonQuery();
}
}
catch (OleDbException e)
{
log.Error("写入Log数据库错误:" + cmdstr, e);
}
catch (Exception e)
{
log.Error(e);
}
}
}
protected virtual Dictionary<string, IVBAObject> GetVBAObjectForNewTaskChain(Domain d)
{
Dictionary<string, IVBAObject> l = new Dictionary<string, IVBAObject>();
IVBAObject ivo = new VBATask();
l.Add(ivo.Name, ivo);
ivo = new VBALog(d.LogLevelFlag);
l.Add(ivo.Name, ivo);
ivo = new VBAIE();
l.Add(ivo.Name, ivo);
ivo = new VBAUtility();
l.Add(ivo.Name, ivo);
ivo = new VBAHtml();
l.Add(ivo.Name, ivo);
return l;
}
protected virtual Dictionary <string, IVBAObject> GetVBAObjectForNewTaskChain(Domain d)
{
Dictionary <string, IVBAObject> l = new Dictionary <string, IVBAObject>();
IVBAObject ivo = new VBATask();
l.Add(ivo.Name, ivo);
ivo = new VBALog(d.LogLevelFlag);
l.Add(ivo.Name, ivo);
ivo = new VBAIE();
l.Add(ivo.Name, ivo);
ivo = new VBAUtility();
l.Add(ivo.Name, ivo);
ivo = new VBAHtml();
l.Add(ivo.Name, ivo);
return(l);
}
public static void WriteVBALogIntoDB(string DomainGUID, string TaskChainGUID, string TaskName, VBALog vlog)
{
using (OleDbConnection logdbcon = new OleDbConnection(ms_connstring))
{
string cmdstr = null;
try
{
logdbcon.Open();
foreach (VBALog.LogList l in vlog.Loglists)
{
cmdstr = "INSERT INTO Log(DomainGUID,TaskChainGUID,LogTime,LogLevel,LogMessage) VALUES('" + DomainGUID + "','" + TaskChainGUID + "','" + l.errtime + "','" + l.errlevel.ToString() + "','" + l.errmessage + "')";
OleDbCommand cmd = new OleDbCommand(cmdstr, logdbcon);
cmd.ExecuteNonQuery();
}
}
catch (OleDbException e)
{
log.Error("写入Log数据库错误:" + cmdstr, e);
}
catch (Exception e)
{
log.Error(e);
}
}
}
