/// <summary> /// errorLog /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="count"></param> /// <returns></returns> public IList <tb_error_model> GetPageList(DbConn conn, DateTime?startTime, DateTime?endTime, string mqpathid, string mqpath, string methodname, string info, int pageSize, int pageIndex, ref int count) { int tempCount = 0; var result = SqlHelper.Visit((ps) => { IList <tb_error_model> list = new List <tb_error_model>(); StringBuilder where = new StringBuilder(); List <ProcedureParameter> parameters = new List <ProcedureParameter>(); where.Append(" WHERE 1=1"); if (startTime != null && endTime != null) { parameters.Add(new ProcedureParameter("startTime", startTime.Value.ToString("yyyy-MM-dd"))); parameters.Add(new ProcedureParameter("endTime", endTime.Value.ToString("yyyy-MM-dd"))); where.Append(" AND createtime>=@startTime AND createtime<=@endTime "); } if (!string.IsNullOrWhiteSpace(mqpathid)) { parameters.Add(new ProcedureParameter("mqpathid", mqpathid)); where.Append(" AND mqpathid=@mqpathid "); } if (!string.IsNullOrWhiteSpace(mqpath)) { parameters.Add(new ProcedureParameter("mqpath", mqpath)); where.Append(" AND mqpath=@mqpath "); } if (!string.IsNullOrWhiteSpace(methodname)) { parameters.Add(new ProcedureParameter("methodname", methodname)); where.Append(" AND methodname like '%'+@methodname+'%' "); } if (!string.IsNullOrWhiteSpace(info)) { parameters.Add(new ProcedureParameter("info", info)); where.Append(" AND info like '%'+@info+'%' "); } StringBuilder sql = new StringBuilder(); sql.Append("SELECT ROW_NUMBER() OVER(ORDER BY Id DESC) AS rownum,* FROM tb_error WITH(NOLOCK)"); string countSql = string.Concat("SELECT COUNT(1) FROM tb_error WITH(NOLOCK) ", where.ToString()); object obj = conn.ExecuteScalar(countSql, parameters); if (obj != DBNull.Value && obj != null) { tempCount = LibConvert.ObjToInt(obj); } string sqlPage = string.Concat("SELECT * FROM (", sql.ToString(), where.ToString(), ") A WHERE rownum BETWEEN ", ((pageIndex - 1) * pageSize + 1), " AND ", pageSize * pageIndex); DataTable dt = conn.SqlToDataTable(sqlPage, parameters); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { tb_error_model model = CreateModel(dr); list.Add(model); } } return(list); }); count = tempCount; return(result); }
public void AddError(tb_error_model model) { AddLog(new tb_log_model { logcreatetime = model.errorcreatetime, logtype = model.errortype, msg = model.msg, taskid = model.taskid }); SqlHelper.ExcuteSql(DllTask.SystemRuntimeInfo.TaskConnectString, (c) => { dal.tb_error_dal errordal = new dal.tb_error_dal(); model.msg = model.msg.SubString2(1000); errordal.Add(c, model); }); }
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="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)BSF.BaseService.TaskManager.SystemRuntime.EnumTaskLogType.SystemError, msg = msg + " 错误信息:" + exp.Message + " 堆栈:" + exp.StackTrace, taskid = 0, nodeid = GlobalConfig.NodeID }; AddError(model); }
/// <summary> /// 添加任务错误日志 /// </summary> /// <param name="msg"></param> public static void AddTaskError(string msg, int taskid, Exception exp) { ErrorLog.Write(msg + "[taskid:" + taskid + "]", exp); if (exp == null) { exp = new Exception(); } tb_error_model model = new tb_error_model() { errorcreatetime = DateTime.Now, errortype = (byte)XXF.BaseService.TaskManager.SystemRuntime.EnumTaskLogType.CommonError, msg = msg + " 错误信息:" + exp.Message + " 堆栈:" + exp.StackTrace, taskid = taskid, nodeid = GlobalConfig.NodeID }; AddError(model); }
/// <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 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 bool Add(DbConn PubConn, tb_error_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@mqpathid", model.mqpathid), // new ProcedureParameter("@mqpath", model.mqpath), // new ProcedureParameter("@methodname", model.methodname), // new ProcedureParameter("@info", model.info), // new ProcedureParameter("@createtime", model.createtime) }; int rev = PubConn.ExecuteSql(@"insert into tb_error(mqpathid,mqpath,methodname,info,createtime) values(@mqpathid,@mqpath,@methodname,@info,@createtime)" , Par); return(rev == 1); }
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 Edit(DbConn PubConn, tb_error_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@mqpathid", model.mqpathid), // new ProcedureParameter("@mqpath", model.mqpath), // new ProcedureParameter("@methodname", model.methodname), // new ProcedureParameter("@info", model.info), // new ProcedureParameter("@createtime", model.createtime) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_error set mqpathid=@mqpathid,mqpath=@mqpath,methodname=@methodname,info=@info,createtime=@createtime where id=@id", 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="model"></param> private 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, nodeid = GlobalConfig.NodeID }); SqlHelper.ExcuteSql(GlobalConfig.ConnectionString, (c) => { tb_error_dal errordal = new tb_error_dal(); model.msg = model.msg.SubString2(1000); errordal.Add2(c, model); }); } catch (Exception exp) { ErrorLog.Write("添加错误日志至数据库出错", exp); } }
public virtual tb_error_model CreateModel(DataRow dr) { var o = new tb_error_model(); // if (dr.Table.Columns.Contains("id")) { o.id = dr["id"].Tolong(); } // if (dr.Table.Columns.Contains("mqpathid")) { o.mqpathid = dr["mqpathid"].Toint(); } // if (dr.Table.Columns.Contains("mqpath")) { o.mqpath = dr["mqpath"].Tostring(); } // if (dr.Table.Columns.Contains("methodname")) { o.methodname = dr["methodname"].Tostring(); } // if (dr.Table.Columns.Contains("info")) { o.info = dr["info"].Tostring(); } // if (dr.Table.Columns.Contains("createtime")) { o.createtime = dr["createtime"].ToDateTime(); } return(o); }