public int Add2(DbConn PubConn, tb_error_model model) { return SqlHelper.Visit(ps => { ps.Add("@msg", model.msg); ps.Add("@errortype", model.errortype); ps.Add("@errorcreatetime", model.errorcreatetime); ps.Add("@taskid", model.taskid); ps.Add("@nodeid", model.nodeid); return PubConn.ExecuteSql(@"insert into tb_error(msg,errortype,errorcreatetime,taskid,nodeid) values(@msg,@errortype,@errorcreatetime,@taskid,@nodeid)", ps.ToParameters()); }); }
/// <summary> /// 添加错误日志 /// </summary> /// <param name="model"></param> public static void AddError(tb_error_model model) { try { AddLog(new tb_log_model { logcreatetime = model.errorcreatetime, logtype = model.errortype, msg = model.msg, taskid = model.taskid }); SqlHelper.ExcuteSql(Config.TaskConnectString, (c) => { tb_error_dal errordal = new tb_error_dal(); model.msg = model.msg.SubString2(1000); errordal.Add2(c, model); }); } catch (Exception exp) { XXF.Log.ErrorLog.Write("添加错误日志至数据库出错", exp); } }
public virtual bool Edit(DbConn PubConn, tb_error_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { // new ProcedureParameter("@msg", model.msg), // new ProcedureParameter("@errortype", model.errortype), // new ProcedureParameter("@errorcreatetime", model.errorcreatetime), // new ProcedureParameter("@taskid", model.taskid), // new ProcedureParameter("@nodeid", model.nodeid) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_error set msg=@msg,errortype=@errortype,errorcreatetime=@errorcreatetime,taskid=@taskid,nodeid=@nodeid where id=@id", Par); return rev == 1; }
public virtual bool Add(DbConn PubConn, tb_error_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { // new ProcedureParameter("@msg", model.msg), // new ProcedureParameter("@errortype", model.errortype), // new ProcedureParameter("@errorcreatetime", model.errorcreatetime), // new ProcedureParameter("@taskid", model.taskid), // new ProcedureParameter("@nodeid", model.nodeid) }; int rev = PubConn.ExecuteSql(@"insert into tb_error(msg,errortype,errorcreatetime,taskid,nodeid) values(@msg,@errortype,@errorcreatetime,@taskid,@nodeid)", Par); return rev == 1; }
public virtual tb_error_model CreateModel(DataRow dr) { var o = new tb_error_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("errortype")) { o.errortype = dr["errortype"].ToByte(); } // if(dr.Table.Columns.Contains("errorcreatetime")) { o.errorcreatetime = dr["errorcreatetime"].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 AddNodeError(string msg, Exception exp) { if (exp == null) exp = new Exception(); ErrorLog.Write(msg, exp); tb_error_model model = new tb_error_model() { errorcreatetime = DateTime.Now, errortype = (byte)XXF.BaseService.TaskManager.SystemRuntime.EnumTaskLogType.SystemError, msg = msg+" 错误信息:"+exp.Message + " 堆栈:"+exp.StackTrace, taskid = 0, nodeid = GlobalConfig.NodeID }; AddError(model); }