public RedisPermissionStorageService(
IHttpContextAccessor httpContextAccessor,
IConfiguration Configuration,
ISysResourceService resourceService)
{
_httpContextAccessor = httpContextAccessor;
_resourceService = resourceService;
_redisClient = RedisClientSingleton.GetInstance(Configuration);
}
public IActionResult Index()
{
var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: false, reloadOnChange: true);
IConfigurationRoot configuration = builder.Build();
string DefaultConnection = configuration.GetSection("ConnectionStrings")["DefaultConnection"];
string message = "";
try
{
var redisClient = RedisClientSingleton.GetInstance(configuration);
var db = redisClient.GetDatabase("Redis_Default");
if (db.KeyExists("Message"))
{
message = "Redis:" + db.StringGet("Message");
}
else
{
message = "本周更新下一篇 最近还在写其他的";
db.StringSet("Message", message);
db.KeyExpire("Message", DateTime.Now.AddSeconds(30));
}
}
catch (Exception ex)
{
message = ex.Message + "\r\n" + ex.StackTrace;
}
List <TestTableVIewModel> lists = new List <TestTableVIewModel>();
TestTableVIewModel entity = null;
using (IDbConnection conn = new MySqlConnection(DefaultConnection))
{
conn.Open();
entity = conn.Query <TestTableVIewModel>("SELECT * FROM TestTable where id=@Id", new { @Id = 1 }).FirstOrDefault();
lists = conn.Query <TestTableVIewModel>("SELECT * FROM TestTable ").AsList();
}
ViewBag.Test = entity;
ViewBag.Ulist = lists;
return(View());
}
public ValuesController(IConfiguration config)
{
_config = config;
redisDataBase = RedisClientSingleton.GetInstance(_config).GetDatabase("Redis_Default");
}
