public async Task <ResultData> UpdateLogger() { using StreamReader bodyReader = new StreamReader(HttpContext.Request.Body, Encoding.UTF8); var data = await bodyReader.ReadToEndAsync(); JObject jObject = JObject.Parse(data); string localPath = ApiUtils.GetLocalPath(_dbContext, jObject["Guid"].ToString(), out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } List <Logger> info; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); info = JsonConvert.DeserializeObject <List <Logger> >(json); info[0].DataAdapterType = jObject["DataAdapterType"].ToString(); info[0].DbInfo = jObject["DbInfo"].ToString(); info[0].LogLevel = jObject["LogLevel"].ToString(); } using StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8); await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(info))); return(ResultData.CreateSuccessResult()); }
public async Task <ResultData> DeletePublicDataAdapters([FromBody] List <PublicDataAdapters> data) { string guid = Request.Query["guid"]; string localPath = ApiUtils.GetLocalPath(_dbContext, guid, out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } List <PublicDataAdapters> infos; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); infos = JsonConvert.DeserializeObject <List <PublicDataAdapters> >(json); } string[] dataAdapterAlias = data.Select(x => x.DataAdapterAlias).ToArray(); List <PublicDataAdapters> deleteData = infos.Where(x => dataAdapterAlias.Contains(x.DataAdapterAlias)).ToList(); foreach (var item in deleteData) { infos.Remove(item); } using StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8); await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(infos))); return(ResultData.CreateSuccessResult()); }
public async Task <ResultData> AddPublicDataAdapters([FromBody] PublicDataAdapters info) { string guid = Request.Query["guid"]; string localPath = ApiUtils.GetLocalPath(_dbContext, guid, out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } List <PublicDataAdapters> infos; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); infos = JsonConvert.DeserializeObject <List <PublicDataAdapters> >(json); if (infos.Where(x => x.DataAdapterAccountName == info.DataAdapterAccountName || x.DataAdapterAlias == info.DataAdapterAlias).ToList().Count > 0) { return(ResultData.CreateResult("-1", "账套名称或账套号已存在", null)); } infos.Add(info); } using StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8); await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(infos))); return(ResultData.CreateSuccessResult()); }
public async Task <ResultData> UpdateErpLog() { using StreamReader bodyReader = new StreamReader(HttpContext.Request.Body, Encoding.UTF8); var data = await bodyReader.ReadToEndAsync(); JObject jObject = JObject.Parse(data); string localPath = ApiUtils.GetLocalPath(_dbContext, jObject["Guid"].ToString(), out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } ErpLogConfig info; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); info = JsonConvert.DeserializeObject <ErpLogConfig>(json); info.MQConnModel.ConnectionModel.Host = jObject["Host"].ToString(); info.MQConnModel.ConnectionModel.Port = jObject["Port"].ToString(); info.MQConnModel.ConnectionModel.UserName = jObject["UserName"].ToString(); info.MQConnModel.ConnectionModel.Password = jObject["Password"].ToString(); } using StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8); await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(info))); return(ResultData.CreateSuccessResult()); }
public async Task <ResultData> UpdateRedis() { using StreamReader bodyReader = new StreamReader(HttpContext.Request.Body, Encoding.UTF8); var data = await bodyReader.ReadToEndAsync(); JObject jObject = JObject.Parse(data); string localPath = ApiUtils.GetLocalPath(_dbContext, jObject["Guid"].ToString(), out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } List <RedisInfo> info; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); info = JsonConvert.DeserializeObject <List <RedisInfo> >(json); info[0].ServiceName = jObject["ServiceName"].ToString(); info[0].Servers[0].IP = jObject["IP"].ToString(); info[0].Servers[0].Port = jObject["Port"].ToString().ToInt32(); info[0].Address = jObject["Address"].ToString(); info[0].InstanceName = jObject["InstanceName"].ToString(); info[0].Password = jObject["Password"].ToString(); } using StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8); await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(info))); return(ResultData.CreateSuccessResult()); }
public async Task <ResultData> AddDataBaseInfo([FromBody] DataBaseInfo info) { //检查重复 if (_dbContext.Queryable <DataBaseInfo>().Where(x => x.BusinessType == info.BusinessType && (x.AccountSetName == info.AccountSetName || x.AccountSetNumber == info.AccountSetNumber)).Count() > 0) { return(ResultData.CreateResult("-1", "账套号或账套名称已存在", null)); } //获取配置文件信息 ConfigInfo configInfo = _dbContext.Queryable <ConfigInfo>().Where(x => x.ConfigName == "PublicDataAdapters.json" && x.CategoryType == info.BusinessType).First(); if (configInfo == null) { return(ResultData.CreateResult("-1", "配置文件不存在", null)); } //判断配置文件是否存在 string localPath = ApiUtils.GetLocalPath(_dbContext, configInfo.Guid, out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } //生成加密信息 PublicDataAdapters publicDataAdapter = new PublicDataAdapters { DataAdapterType = info.DataBaseType, DataAdapterAlias = info.AccountSetNumber, IsDefaultDataAdapter = "0", DataAdapterAccountName = info.AccountSetName, DataAdapterInfo = $"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={info.ServerAddress})(PORT={info.Port})))(CONNECT_DATA=(SERVICE_NAME={info.DataBaseName})));User Id={info.UserName};Password={info.UserPassword};{info.ConnectionStringOther}".ToEncodeString() }; List <PublicDataAdapters> infos; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); infos = JsonConvert.DeserializeObject <List <PublicDataAdapters> >(json); if (infos.Where(x => x.DataAdapterAccountName == publicDataAdapter.DataAdapterAccountName || x.DataAdapterAlias == publicDataAdapter.DataAdapterAlias).ToList().Count > 0) { return(ResultData.CreateResult("-1", "配置文件中账套名称或账套号已存在", null)); } infos.Add(publicDataAdapter); } //插入数据库 ResultData result = await ApiUtils.InsertData(_dbContext, info); //修改本地文件 using StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8); await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(infos))); return(result); }
public async Task <ResultData> UpdatePublicDataAdapters() { string guid = Request.Query["guid"]; string localPath = ApiUtils.GetLocalPath(_dbContext, guid, out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } List <PublicDataAdapters> infos; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); infos = JsonConvert.DeserializeObject <List <PublicDataAdapters> >(json); } using StreamReader bodyReader = new StreamReader(HttpContext.Request.Body, Encoding.UTF8); var data = await bodyReader.ReadToEndAsync(); JObject info = JObject.Parse(data); if (infos.Where(x => x.DataAdapterAlias != info["DataAdapterAlias"].ToNullString() && x.DataAdapterAccountName != info["DataAdapterAccountName"].ToNullString()).Where(x => x.DataAdapterAlias == info["NewDataAdapterAlias"].ToNullString() || x.DataAdapterAccountName == info["NewDataAdapterAccountName"].ToNullString()).ToList().Count > 0) { return(ResultData.CreateResult("-1", "账套名称或账套号已存在", null)); } foreach (var item in infos) { if (item.DataAdapterAlias != info["DataAdapterAlias"].ToNullString()) { continue; } item.DataAdapterAlias = info["NewDataAdapterAlias"].ToNullString(); item.DataAdapterType = info["NewDataAdapterType"].ToNullString(); item.DataAdapterInfo = info["NewDataAdapterInfo"].ToNullString(); item.DataAdapterAccountName = info["NewDataAdapterAccountName"].ToNullString(); } using StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8); await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(infos))); return(ResultData.CreateSuccessResult()); }
public async Task <ResultData> DeleteDataBaseInfo(List <DataBaseInfo> infos, string type) { //获取配置文件信息 ConfigInfo configInfo = _dbContext.Queryable <ConfigInfo>().Where(x => x.ConfigName == "PublicDataAdapters.json" && x.CategoryType == type).First(); if (configInfo == null) { return(ResultData.CreateResult("-1", "配置文件不存在", null)); } string localPath = ApiUtils.GetLocalPath(_dbContext, configInfo.Guid, out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } List <PublicDataAdapters> datainfos; using (StreamReader reader = new StreamReader(localPath)) { string json = await reader.ReadToEndAsync(); datainfos = JsonConvert.DeserializeObject <List <PublicDataAdapters> >(json); } string[] dataAdapterAlias = infos.Select(x => x.AccountSetNumber).ToArray(); List <PublicDataAdapters> deleteData = datainfos.Where(x => dataAdapterAlias.Contains(x.DataAdapterAlias)).ToList(); foreach (var item in deleteData) { datainfos.Remove(item); } using (StreamWriter writer = new StreamWriter(localPath, false, Encoding.UTF8)) { await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(datainfos))); } return(ResultData.CreateSuccessResult()); }
public async Task <ResultData> UpdateRabbitMQApi() { using StreamReader bodyReader = new StreamReader(HttpContext.Request.Body, Encoding.UTF8); var data = await bodyReader.ReadToEndAsync(); JObject jObject = JObject.Parse(data); List <string> localPath = ApiUtils.GetLocalPathByFileName(_dbContext, "RabbitMQ.json", out string errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { return(ResultData.CreateResult("-1", errorMessage, null)); } List <RabbitMQ> info; using (StreamReader reader = new StreamReader(localPath[0])) { string json = await reader.ReadToEndAsync(); info = JsonConvert.DeserializeObject <List <RabbitMQ> >(json); info[0].ServerUrl = jObject["ServerUrl"].ToString(); info[0].ServerPort = jObject["ServerPort"].ToString(); info[0].UserName = jObject["UserName"].ToString(); info[0].Password = jObject["Password"].ToString(); } foreach (var item in localPath) { using (StreamWriter writer = new StreamWriter(item, false, Encoding.UTF8)) { await writer.WriteAsync(ApiUtils.ConvertJsonString(JsonConvert.SerializeObject(info))); } } return(ResultData.CreateSuccessResult()); }