public ActionResult GetSysConfigList(string keyword, SysConfigClassify?clz)
{
var search = GetSearchModel();
var list = SysConfigRepository.GetPager(keyword, clz, search);
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveSysConfig(List <SysConfigViewModel> model)
{
ResponseData result = new Models.ResponseData();
result = new SysConfigRepository().UpdateByEntity(model);
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 查询所有的键值对配置信息
/// </summary>
/// <returns></returns>
public static void GetList(SysConfigList model)
{
var list = SysConfigRepository.GetList(model.Id, model.Search);
model.Menus = DictionaryConfigMenu();
model.Count = list.Count;
model.DataList = list.Skip(model.PageSize * (model.PageIndex - 1)).Take(model.PageSize).ToList();
}
public ActionResult SysConfigEdit(SysConfigModel model)
{
var result = new JsonModel();
var opType = OperationType.Update;
SysConfig config = null;
if (model.Id == 0)
{
config = new SysConfig();
opType = OperationType.Insert;
}
else
{
config = SysConfigRepository.Get(model.Id);
if (config == null)
{
result.msg = "记录不存在！";
return(Json(result));
}
}
Mapper.Map(model, config);
switch (config.ConfigType)
{
case SysConfigType.String:
config.ConValue = JsonConvert.SerializeObject(model.StringValue);
break;
case SysConfigType.Bool:
config.ConValue = JsonConvert.SerializeObject(model.BoolValue);
break;
case SysConfigType.TextArea:
config.ConValue = JsonConvert.SerializeObject(model.TextAreaValue);
break;
case SysConfigType.Int:
config.ConValue = JsonConvert.SerializeObject(model.IntValue);
break;
case SysConfigType.Long:
config.ConValue = JsonConvert.SerializeObject(model.LongValue);
break;
case SysConfigType.StringArray:
config.ConValue = JsonConvert.SerializeObject(model.StringArrayValue.Split(','));
break;
default:
break;
}
SysConfigRepository.Save(config);
LogRepository.Insert(TableSource.SysConfig, opType, config.Id);
result.code = JsonModelCode.Succ;
result.msg = "保存成功！";
return(Json(result));
}
public ActionResult SysConfigEdit(long id, string reUrl)
{
ViewBag.ReUrl = reUrl ?? Url.Action("SysConfigList");
var model = new SysConfigModel();
if (id == 0)
{
return(View(model));
}
var config = SysConfigRepository.Get(id);
if (config == null)
{
ShowErrorMsg();
return(Redirect(ViewBag.ReUrl));
}
Mapper.Map(config, model);
switch (model.ConfigType)
{
case SysConfigType.String:
model.StringValue = JsonConvert.DeserializeObject <string>(model.ConValue);
break;
case SysConfigType.Bool:
model.BoolValue = JsonConvert.DeserializeObject <bool>(model.ConValue);
break;
case SysConfigType.TextArea:
model.TextAreaValue = JsonConvert.DeserializeObject <string>(model.ConValue);
break;
case SysConfigType.Int:
model.IntValue = JsonConvert.DeserializeObject <int>(model.ConValue);
break;
case SysConfigType.Long:
model.LongValue = JsonConvert.DeserializeObject <long>(model.ConValue);
break;
case SysConfigType.StringArray:
model.StringArrayValue = string.Join(",", JsonConvert.DeserializeObject <string[]>(model.ConValue));
break;
default:
break;
}
return(View(model));
}
/// <summary>
/// 根据键值对的键名查询对象
/// </summary>
/// <returns></returns>
public static SysConfigModel GetByKeyName(string keyName, bool fromCache = true)
{
if (!fromCache)
{
return(SysConfigRepository.GetDictionaryConfig(keyName));
}
var sysConfig = CacheHelper.Get <SysConfigModel>(keyName);
if (sysConfig != null)
{
return(sysConfig);
}
sysConfig = SysConfigRepository.GetDictionaryConfig(keyName);
if (sysConfig != null)
{
CacheHelper.Set(keyName, sysConfig, TimeSpan.FromMinutes(10));
}
return(sysConfig ?? new SysConfigModel());
}
/// <summary>
/// 添加通用键值对配置信息
/// </summary>
/// <returns></returns>
public static Result <bool> Add(SysConfigModel ent)
{
#region 数据验证
var result = ParamsCheck(ent);
if (result.Code != ResultCode.Success)
{
return(result);
}
var exists = SysConfigRepository.Exists(ent.KeyName);
if (exists.HasValue)
{
if (exists.Value)
{
result.Message = "存在相同的键名";
}
}
else
{
result.Message = "键值对查询数据库异常";
}
if (!string.IsNullOrEmpty(result.Message))
{
result.Code = ResultCode.Error;
return(result);
}
#endregion
ent.InsertTime = ent.UpdateTime = DateTime.Now;
ent.IsActive = true;
var dbResult = SysConfigRepository.Add(ent);
if (dbResult)
{
result.Code = ResultCode.Success;
CacheHelper.Set(ent.KeyName, ent, TimeSpan.FromMinutes(10));
}
else
{
result.Code = ResultCode.Error;
result.Message = "数据库操作异常";
}
return(result);
}
public ActionResult SysConfig()
{
var data = new SysConfigRepository().GetAll();
return(View(data));
}
/// <summary>
/// 解析配置
/// </summary>
/// <typeparam name="TConfigSection">配置项类型</typeparam>
/// <param name="CreateCacheFun">如果缓存不存在则通过此委托创建</param>
/// <returns></returns>
public static TConfigSection Get <TConfigSection>(bool cached = true, string PropNameSurfix = "")
{
return(SysConfigRepository.Get <TConfigSection>(cached, PropNameSurfix));
}
/// <summary>
/// 从数据库获取某个配置项
/// </summary>
/// <typeparam name="TResult">配置项类型</typeparam>
/// <returns></returns>
public static bool Set <TConfigSection>(TConfigSection config)
{
return(SysConfigRepository.Set(config));
}
