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