public static int DeleteExceptionLog(params int[] ids)
{
var db = new GrainManageDB();
var sql = string.Format("delete from log_exception where Id in ({0})", string.Join(",", ids));
return(db.Execute(sql));
}
public static void AddExceptionLog(ExceptionLog model)
{
var db = new GrainManageDB();
var sql = "insert into log_exception(Path,InputParameter,Message,StackTrace,ClientIP,CreatedAt) values(@Path,@InputParameter,@Message,@StackTrace,@ClientIP,@CreatedAt)";
db.Execute(sql, model);
}
public static int AddActionLog(ActionLog model)
{
var db = new GrainManageDB();
var sql = "insert into log_action(UserName,Path,ClientIP,Method,Para,Level,StartTime) values(@UserName,@Path,@ClientIP,@Method,@Para,@Level,@StartTime);select last_insert_id()";
return(db.ExecuteScalar <int>(sql, model));
}
public static int AddLoginLog(LoginLog model)
{
var db = new GrainManageDB();
model.CreatedAt = DateTime.Now;
var sql = "insert into log_login(UserName,LoginIP,Status,Level,CreatedAt) values(@UserName,@LoginIP,@Status,@Level,@CreatedAt)";
return(db.Execute(sql, model));
}
public static int GetMaxLevel(IEnumerable <int> roleIds)
{
if (roleIds == null || !roleIds.Any())
{
return(0);
}
var db = new GrainManageDB();
return(db.ExecuteScalar <int>(string.Format("select max(`Level`) from rm_role where Id in({0})", string.Join(",", roleIds))));
}
/// <summary>
/// 获取授权url
/// </summary>
/// <param name="roleIds"></param>
/// <returns></returns>
public static List <string> GetUrls(params int[] roleIds)
{
var list = new List <string>();
var db = new GrainManageDB();
var auths = db.Select <string>(string.Format("select Auths from rm_role where Id in({0})", string.Join(",", roleIds)));
if (auths != null && auths.Any())
{
var menus = GetMenus();
foreach (var item in auths)
{
TreeUtil.GetUrls(menus, item.Split(','), list);
}
}
return(list);
}
/// <summary>
/// 获取授权菜单id
/// </summary>
/// <param name="roleIds"></param>
/// <returns></returns>
public static List <string> GetAuths(params int[] roleIds)
{
var list = new List <string>();
var db = new GrainManageDB();
var auths = db.Select <string>(string.Format("select Auths from rm_role where Id in({0})", string.Join(",", roleIds)));
if (auths != null && auths.Any())
{
foreach (var auth in auths)
{
foreach (var item in auth.Split(','))
{
if (!list.Any(s => string.Equals(s, item, StringComparison.CurrentCultureIgnoreCase)))
{
list.Add(item);
}
}
}
}
return(list);
}
public static int UpdateActionLog(dynamic model)
{
var db = new GrainManageDB();
return(db.Execute("update log_action set Status=@Status,EndTime=@EndTime,TimeSpan=@TimeSpan where Id=@Id ", model));
}
