public JsonResult SaveAppSetting(AppSettingDto appSettingDto) { ResponseResult responseResult; bool isAdd = appSettingDto.Id == 0; try { var isConfiKeyExisted = ConfiKeyExisted(appSettingDto); if (isAdd) { if (isConfiKeyExisted) { AppSettingBusiness.SaveAppSetting(appSettingDto); responseResult = new ResponseResult(ResultEnum.IsSuccess.成功, "新增配置成功"); } else { responseResult = new ResponseResult(ResultEnum.IsSuccess.失败, "已存在该项配置,请考虑清楚再添加!"); } } else { AppSettingBusiness.SaveAppSetting(appSettingDto); responseResult = new ResponseResult(ResultEnum.IsSuccess.成功, "新增配置成功"); } } catch (Exception ex) { responseResult = new ResponseResult(ResultEnum.IsSuccess.失败, "添加配置异常,请联系管理员!" + appSettingDto.AppId); } return(Json(responseResult, JsonRequestBehavior.AllowGet)); }
public object Get(GetAppSettings getAppSettings) { return(new GetAppSettingsResponse() { AppSettings = AppSettingBusiness.GetAppSettings(getAppSettings.AppId) }); }
public ActionResult Import([FromQuery] int appid, [FromForm] IFormCollection formData) { try { int appIdSelf = appid; //存入本地 IFormFile file = formData.Files.FirstOrDefault(); //var file = Request.Files[0]; string sheet = "配置"; List <AppSettingDto> appSettings = new List <AppSettingDto>(); //传入参数,将excel转换为Datatable,格式文件名加上固定模版Sheet1 DataTable dt = Entities.ExcelToDataTableHelper(file, sheet); //循环这个集合并添加到数据表 foreach (DataRow item in dt.Rows) { AppSettingDto appSetting = new AppSettingDto(); appSetting.ConfigKey = item[0].ToString(); appSetting.ConfigValue = item[1].ToString(); appSettings.Add(appSetting); } AppSettingBusiness.SaveAppSettings(appSettings, appIdSelf); } catch (Exception ex) { return(Json(new ResponseResult(false, "上传格式有问题!"))); } return(Json(new ResponseResult(true, "上传成功!"))); }
// GET: App public ActionResult Index(int pageindex = 1, int appId = 0, string kword = "") { long totalItem; var dto = AppSettingBusiness.GetAppSettings(appId, pageindex, 20, kword, out totalItem); return(View(new PagedList <AppSettingDto>(dto, pageindex, 20, (int)totalItem))); }
public FileResult Export(int appId) { //获取list数据 var checkList = AppSettingBusiness.GetAppSettings(appId); //db.InfoTables.Where(r => r.ProjectName != null).Select(r => new { r.ProjectName, r.InfoTypes, r.field, r.fieldtxt }).ToList(); //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //给sheet1添加第一行的头部标题 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("配置键"); row1.CreateCell(1).SetCellValue("配置值"); //....N行 //将数据逐步写入sheet1各个行 for (int i = 0; i < checkList.Count(); i++) { NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue(checkList[i].ConfigKey.ToString()); rowtemp.CreateCell(1).SetCellValue(checkList[i].ConfigValue.ToString()); //....N行 } // 写入到客户端 System.IO.MemoryStream ms = new System.IO.MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); DateTime dt = DateTime.Now; string dateTime = dt.ToString("yyMMddHHmmssfff"); string fileName = "配置" + ".xls"; return(File(ms, "application/vnd.ms-excel", fileName)); }
public async Task <object> Get(GetAppSettings getAppSettings) { return(new GetAppSettingsResponse() { AppSettings = await AppSettingBusiness.GetAppSettingsAsync(getAppSettings.AppId) }); }
public dynamic Get([FromRoute] int appId) { return(new GetAppSettingsResponse() { AppSettings = AppSettingBusiness.GetAppSettings(appId) }); }
public ActionResult DeleteAlllAppSetting(int appid) { try { AppSettingBusiness.DeleteSettingByAppid(appid); } catch (Exception ex) { return(Json(new ResponseResult(false, "删除所有失败"))); } return(Json(new ResponseResult(true, "删除所有成功"))); }
public JsonResult SaveAppSetting(AppSettingDto appSettingDto) { ResponseResult responseResult; try { AppSettingBusiness.SaveAppSetting(appSettingDto); responseResult = new ResponseResult(true, ""); } catch (Exception) { responseResult = new ResponseResult(false, ""); } return(Json(responseResult, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteAppSettingById(int id) { ResponseResult responseResult; try { var result = AppSettingBusiness.DeleteAppSettingById(id); responseResult = new ResponseResult(result, ""); } catch (Exception) { responseResult = new ResponseResult(false, ""); } return(Json(responseResult, JsonRequestBehavior.AllowGet)); }
// GET: App public ActionResult Index(int pageindex = 1, int appId = 0, string kword = "") { long totalItem; var dto = AppSettingBusiness.GetAppSettings(appId, pageindex, 20, kword, out totalItem); var app = AppBusiness.GetAppById(appId); if (app != null) { ViewData["Evn"] = AppBusiness.GetAppById(appId).Environment; ViewData["ProjectName"] = AppBusiness.GetAppById(appId).AppId; } else { ViewData["Evn"] = "无法识别"; ViewData["ProjectName"] = "无法识别"; } return(View(new PagedList <AppSettingDto>(dto, pageindex, 20, (int)totalItem))); }
// GET: App public ActionResult Index(int pageindex = 1, string kword = "", int appId = 0) { long totalItem; int pageSize = 15; var pageList = AppSettingBusiness.GetAppSettings(appId, pageindex, pageSize, kword, out totalItem).ToPagedList(pageindex, pageSize, totalItem); var app = AppBusiness.GetAppById(appId); ViewBag.appid = appId; if (app != null) { ViewData["Evn"] = app.Environment; ViewData["ProjectName"] = app.AppId; } else { ViewData["Evn"] = "无法识别"; ViewData["ProjectName"] = "无法识别"; } return(View(pageList)); }
public JsonResult GetAppSettingById(int id) { return(Json(AppSettingBusiness.GetAppSettingById(id), JsonRequestBehavior.AllowGet)); }
public JsonResult GetAppSettingById(int id) { return(Json(new ResponseResult(true, "获取成功", AppSettingBusiness.GetAppSettingById(id)))); }
private static bool ConfiKeyExisted(AppSettingDto appSettingDto) { var appSetting = AppSettingBusiness.GetAppSettingByKeyAndAppId(appSettingDto.ConfigKey, appSettingDto.AppId); return(appSetting.IsNull()); }
// GET: App public async Task <ActionResult> Index(int pageindex = 1, int appId = 0, string kword = "") { var appSettingDtos = await AppSettingBusiness.GetAppSettingsAsync(appId, pageindex, 20, kword); return(View(new PagedList <AppSettingDto>(appSettingDtos.Items, pageindex, 20, appSettingDtos.TotalPage))); }
public JsonResult GetAppSettingById(int id) { return(Json(new ResponseResult(true, "获取成功", AppSettingBusiness.GetAppSettingById(id)), JsonRequestBehavior.AllowGet)); }
public async Task <JsonResult> GetAppSettingById(int id) { return(Json(await AppSettingBusiness.GetAppSettingByIdAsync(id), JsonRequestBehavior.AllowGet)); }