public LayuiData GetRedisDBSettingList(int page, int limit)
{
var data = _dbContext.Queryable <RedisDBSetting>().OrderBy(x => x.Code).ToList();
int rowCount = data.Count;
data = PageHelper.GetPageData <RedisDBSetting>(data, page, limit);
return(LayuiData.CreateResult(rowCount, data));
}
public async Task <LayuiData> GetTaskList(string code = "", string name = "")
{
var items = string.IsNullOrEmpty(code) && string.IsNullOrEmpty(name)
? await _sqliteSql.Select <Tasks>().ToListAsync()
: await _sqliteSql.Select <Tasks>().Where(o => o.Name.Contains(name) || o.Guid == int.Parse(code)
).ToListAsync();
return(LayuiData.CreateResult(items.Count, items));
}
public async Task <LayuiData> GetPublicDataAdaptersList(string guid)
{
string localPath = ApiUtils.GetLocalPath(_dbContext, guid, out string errorMessage);
if (!string.IsNullOrEmpty(errorMessage))
{
return(LayuiData.CreateErrorResult(errorMessage));
}
using StreamReader reader = new StreamReader(localPath);
string json = await reader.ReadToEndAsync();
List <PublicDataAdapters> info = JsonConvert.DeserializeObject <List <PublicDataAdapters> >(json);
ViewBag.Guid = guid;
return(LayuiData.CreateResult(info.Count, info));
}
public async Task <LayuiData> GetRedisDevList(int page, int limit, string redisaddr, int redisdb, string searchkey)
{
if (string.IsNullOrEmpty(redisaddr))
{
return(LayuiData.CreateResult(0, null));
}
#region 获取Redis的地址，连接实例
string redisConn = await GetRedisDBAddr(redisaddr);
RedisHelper redisHelper = new RedisHelper(redisConn);
#endregion
#region 根据地址查询键值对，如果redisdb为空就查询所有的（限制到1000条数据），如果searchkey为空也是如此
List <RedisDataModel> redisDataModel = new List <RedisDataModel>();
var data = redisHelper.GetKeys(redisdb, searchkey ?? "*");;
int rowCount = data.Count;
data = PageHelper.GetPageData <RedisDataModel>(data, page, limit);
#endregion
return(LayuiData.CreateResult(rowCount, data));
}
public async Task <LayuiData> GetTasksDetailList(string guid = "")
{
var items = string.IsNullOrEmpty(guid)? await _sqliteSql.Select <TasksDetail>().ToListAsync(): await _sqliteSql.Select <TasksDetail>().Where(o => o.TaskCode == int.Parse(guid)).ToListAsync();
var TaskDetailViewModelList = new List <TaskDetailViewModel>();
foreach (var item in items)
{
TaskDetailViewModelList.Add(new TaskDetailViewModel {
ScriptCode = item.ScriptCode,
Guid = item.Guid,
OrgCode = item.OrgCode,
OrgName = await _sqliteSql.Select <Organization>().Where(o => o.Guid == item.OrgCode).FirstAsync(o => o.Name),
TaskCode = item.TaskCode,
TaskName = await _sqliteSql.Select <Tasks>().Where(o => o.Guid == item.TaskCode).FirstAsync(o => o.Name),
ScriptName = await _sqliteSql.Select <Script>().Where(o => o.Guid == item.ScriptCode).FirstAsync(o => o.Name)
});
}
return(LayuiData.CreateResult(TaskDetailViewModelList.Count, TaskDetailViewModelList));
}
public LayuiData GetServerList()
{
List <ServerInfo> data = _dbContext.SqlQueryable <ServerInfo>("select A.*,B.BusinessName from ServerInfo A left join BusinessCategory B on A.BusinessGuid = B.Guid").ToList();
return(LayuiData.CreateResult(data.Count, data));
}
public LayuiData GetConfigList()
{
List <ConfigInfo> data = _dbContext.Queryable <ConfigInfo>().ToList();
return(LayuiData.CreateResult(data.Count, data));
}
public LayuiData GetDataBaseList()
{
List <DataBaseInfo> data = _dbContext.Queryable <DataBaseInfo>().OrderBy(x => x.BusinessType).ToList();
return(LayuiData.CreateResult(data.Count, data));
}