public int Add2(DbConn PubConn, tb_log_model model)
{
return SqlHelper.Visit(ps =>
{
ps.Add("@msg", model.msg);
ps.Add("@logtype", model.logtype);
ps.Add("@logcreatetime", model.logcreatetime);
ps.Add("@taskid", model.taskid);
ps.Add("@nodeid", model.nodeid);
return PubConn.ExecuteSql(@"insert into tb_log(msg,logtype,logcreatetime,taskid,nodeid)
values(@msg,@logtype,@logcreatetime,@taskid,@nodeid)", ps.ToParameters());
});
}
/// <summary>
/// 添加节点日志
/// </summary>
/// <param name="msg"></param>
public static void AddNodeLog(string msg)
{
CommLog.Write(msg);
tb_log_model model = new tb_log_model()
{
logcreatetime = DateTime.Now,
logtype = (byte)XXF.BaseService.TaskManager.SystemRuntime.EnumTaskLogType.SystemLog,
msg = msg,
taskid = 0,
nodeid = GlobalConfig.NodeID
};
AddLog(model);
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="model"></param>
public static void AddLog(tb_log_model model)
{
try
{
SqlHelper.ExcuteSql(Config.TaskConnectString, (c) =>
{
tb_log_dal logdal = new tb_log_dal();
model.msg = model.msg.SubString2(1000);
logdal.Add2(c, model);
});
}
catch (Exception exp)
{
XXF.Log.ErrorLog.Write("添加日志至数据库出错", exp);
}
}
public virtual bool Edit(DbConn PubConn, tb_log_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//
new ProcedureParameter("@msg", model.msg),
//
new ProcedureParameter("@logtype", model.logtype),
//
new ProcedureParameter("@logcreatetime", model.logcreatetime),
//
new ProcedureParameter("@taskid", model.taskid),
//
new ProcedureParameter("@nodeid", model.nodeid)
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_log set msg=@msg,logtype=@logtype,logcreatetime=@logcreatetime,taskid=@taskid,nodeid=@nodeid where id=@id", Par);
return rev == 1;
}
public virtual bool Add(DbConn PubConn, tb_log_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//
new ProcedureParameter("@msg", model.msg),
//
new ProcedureParameter("@logtype", model.logtype),
//
new ProcedureParameter("@logcreatetime", model.logcreatetime),
//
new ProcedureParameter("@taskid", model.taskid),
//
new ProcedureParameter("@nodeid", model.nodeid)
};
int rev = PubConn.ExecuteSql(@"insert into tb_log(msg,logtype,logcreatetime,taskid,nodeid)
values(@msg,@logtype,@logcreatetime,@taskid,@nodeid)", Par);
return rev == 1;
}
public virtual tb_log_model CreateModel(DataRow dr)
{
var o = new tb_log_model();
//
if(dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
if(dr.Table.Columns.Contains("msg"))
{
o.msg = dr["msg"].Tostring();
}
//
if(dr.Table.Columns.Contains("logtype"))
{
o.logtype = dr["logtype"].ToByte();
}
//
if(dr.Table.Columns.Contains("logcreatetime"))
{
o.logcreatetime = dr["logcreatetime"].ToDateTime();
}
//
if(dr.Table.Columns.Contains("taskid"))
{
o.taskid = dr["taskid"].Toint();
}
//
if(dr.Table.Columns.Contains("nodeid"))
{
o.nodeid = dr["nodeid"].Toint();
}
return o;
}
/// <summary>
/// 添加任务日志
/// </summary>
/// <param name="msg"></param>
public static void AddTaskLog(string msg, int taskid)
{
tb_log_model model = new tb_log_model()
{
logcreatetime = DateTime.Now,
logtype = (byte)XXF.BaseService.TaskManager.SystemRuntime.EnumTaskLogType.CommonLog,
msg = msg,
taskid = taskid,
nodeid = GlobalConfig.NodeID
};
AddLog(model);
}