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