public List <tb_log_model> GetList(DbConn PubConn, string id, string keyword, DateTime timebegin, DateTime timeend, int logtype, string projectname, int pagesize, int pageindex, out int count) { int _count = 0; List <tb_log_model> model = new List <tb_log_model>(); DataSet dsList = SqlHelper.Visit <DataSet>(ps => { string sqlwhere = " where 1=1 "; if (!string.IsNullOrWhiteSpace(id)) { ps.Add("id", id); sqlwhere += " and (id=@id) "; } if (!string.IsNullOrWhiteSpace(keyword)) { ps.Add("keyword", keyword); sqlwhere += " and (msg like '%'+@keyword+'%') "; } if (!string.IsNullOrWhiteSpace(projectname)) { ps.Add("projectname", projectname); sqlwhere += " and (projectname=@projectname) "; } if (true) { ps.Add("timebegin", timebegin); ps.Add("timeend", timeend); sqlwhere += " and sqlservercreatetime>=@timebegin and sqlservercreatetime<=@timeend"; } if (logtype >= 0) { ps.Add("logtype", logtype); sqlwhere += " and logtype=@logtype"; } string zq = ""; DateTime dateNow = DateTime.Now; if (DateTime.TryParse(timeend.ToString("yyyyMM"), out dateNow)) { zq = timeend.ToString("yyyyMM"); } else { zq = DateTime.Now.ToString("yyyyMM"); } StringBuilder sql = new StringBuilder(); sql.Append("select ROW_NUMBER() over(order by id desc) as rownum,* from tb_log" + zq + " with (nolock) "); _count = Convert.ToInt32(PubConn.ExecuteScalar("select count(1) from tb_log" + zq + " with (nolock) " + sqlwhere, ps.ToParameters())); DataSet ds = new DataSet(); string sqlSel = "select * from (" + sql + sqlwhere + ") A where rownum between " + ((pageindex - 1) * pagesize + 1) + " and " + pagesize * pageindex; PubConn.SqlToDataSet(ds, sqlSel, ps.ToParameters()); return(ds); }); foreach (DataRow dr in dsList.Tables[0].Rows) { tb_log_model m = CreateModel(dr); model.Add(m); } count = _count; return(model); }
public void AddLog(tb_log_model model) { SqlHelper.ExcuteSql(DllTask.SystemRuntimeInfo.TaskConnectString, (c) => { dal.tb_log_dal logdal = new dal.tb_log_dal(); model.msg = model.msg.SubString2(1000); logdal.Add(c, model); }); }
/// <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)BSF.BaseService.TaskManager.SystemRuntime.EnumTaskLogType.CommonLog, msg = msg, taskid = taskid, nodeid = GlobalConfig.NodeID }; AddLog(model); }
public int Add(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)BSF.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); } }
/// <summary> /// 添加日志 /// </summary> /// <param name="model"></param> private static void AddLog(tb_log_model model) { try { SqlHelper.ExcuteSql(GlobalConfig.ConnectionString, (c) => { tb_log_dal logdal = new tb_log_dal(); model.msg = model.msg.SubString2(1000); logdal.Add2(c, model); }); } catch (Exception exp) { ErrorLog.Write("添加日志至数据库出错", exp); } }
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 bool Add(DbConn PubConn, tb_log_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_log(mqpathid,mqpath,methodname,info,createtime) values(@mqpathid,@mqpath,@methodname,@info,@createtime)" , 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("sqlservercreatetime")) { o.sqlservercreatetime = dr["sqlservercreatetime"].ToDateTime(); } //日志项目中创建时间 if (dr.Table.Columns.Contains("logcreatetime")) { o.logcreatetime = dr["logcreatetime"].ToDateTime(); } //日志类型:一般非正常错误,系统级严重错误,一般业务日志,系统日志 if (dr.Table.Columns.Contains("logtype")) { o.logtype = dr["logtype"].ToByte(); } //项目名称 if (dr.Table.Columns.Contains("projectname")) { o.projectname = dr["projectname"].Tostring(); } //日志唯一标示(简短的方法名或者url,便于归类) if (dr.Table.Columns.Contains("logtag")) { o.logtag = dr["logtag"].Tostring(); } //日志信息 if (dr.Table.Columns.Contains("msg")) { o.msg = dr["msg"].Tostring(); } return(o); }
public virtual bool Add(DbConn PubConn, tb_log_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //数据库创建时间 //new ProcedureParameter("@sqlservercreatetime", model.sqlservercreatetime), //日志项目中创建时间 new ProcedureParameter("@logcreatetime", model.logcreatetime), //日志类型:一般非正常错误,系统级严重错误,一般业务日志,系统日志 new ProcedureParameter("@logtype", model.logtype), //项目名称 new ProcedureParameter("@projectname", model.projectname), //日志唯一标示(简短的方法名或者url,便于归类) new ProcedureParameter("@logtag", model.logtag), //日志信息 new ProcedureParameter("@msg", model.msg) }; int rev = PubConn.ExecuteSql(string.Format(@"insert into tb_log{0}(sqlservercreatetime,logcreatetime,logtype,projectname,logtag,msg) values(getdate(),@logcreatetime,@logtype,@projectname,@logtag,@msg)" , XXF.BaseService.Monitor.SystemRuntime.DbShardingHelper.MonthRule(DateTime.Now)), Par); return(rev == 1); }
public virtual bool Add(DbConn PubConn, tb_log_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //数据库创建时间 new ProcedureParameter("@sqlservercreatetime", model.sqlservercreatetime), //日志项目中创建时间 new ProcedureParameter("@logcreatetime", model.logcreatetime), //日志类型:一般非正常错误,系统级严重错误,一般业务日志,系统日志 new ProcedureParameter("@logtype", model.logtype), //项目名称 new ProcedureParameter("@projectname", model.projectname), //日志唯一标示(简短的方法名或者url,便于归类) new ProcedureParameter("@logtag", model.logtag), //日志信息 new ProcedureParameter("@msg", model.msg) }; int rev = PubConn.ExecuteSql(@"insert into tb_log(sqlservercreatetime,logcreatetime,logtype,projectname,logtag,msg) values(@sqlservercreatetime,@logcreatetime,@logtype,@projectname,@logtag,@msg)" , Par); return(rev == 1); }
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 Edit(DbConn PubConn, tb_log_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_log set mqpathid=@mqpathid,mqpath=@mqpath,methodname=@methodname,info=@info,createtime=@createtime where id=@id", Par); return(rev == 1); }
public virtual bool Edit(DbConn PubConn, tb_log_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //数据库创建时间 new ProcedureParameter("@sqlservercreatetime", model.sqlservercreatetime), //日志项目中创建时间 new ProcedureParameter("@logcreatetime", model.logcreatetime), //日志类型:一般非正常错误,系统级严重错误,一般业务日志,系统日志 new ProcedureParameter("@logtype", model.logtype), //项目名称 new ProcedureParameter("@projectname", model.projectname), //日志唯一标示(简短的方法名或者url,便于归类) new ProcedureParameter("@logtag", model.logtag), //日志信息 new ProcedureParameter("@msg", model.msg) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_log set sqlservercreatetime=@sqlservercreatetime,logcreatetime=@logcreatetime,logtype=@logtype,projectname=@projectname,logtag=@logtag,msg=@msg where id=@id", 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); }
public virtual tb_log_model CreateModel(DataRow dr) { var o = new tb_log_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); }