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);
}
