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