public ActionResult GetDataByExecSql(string content)
{
var message = new ReturnMessage {
Success = false, Msg = "操作失败!"
};
try
{
NotifySettingBusiness bus = new NotifySettingBusiness();
Regex regex = new Regex(@"\s+notifymessage_backup\s*", RegexOptions.Compiled | RegexOptions.IgnoreCase);
if (regex.IsMatch(content))
{
List <NotifyMessageModel> list = bus.GetNotifyMessageData(content);
message.Msg = JsonConvert.SerializeObject(new { total = list.Count, rows = list });
}
else
{
List <PushMessageModel> list = bus.GetPushMessageData(content);
message.Msg = JsonConvert.SerializeObject(new { total = list.Count, rows = list });
}
message.Success = true;
}
catch (Exception ex)
{
message.Msg = ex.ToString();
}
return(Content(JsonConvert.SerializeObject(message)));
}
public ActionResult Add(NotifySettingModel model)
{
ReturnMessage message = new ReturnMessage {
Success = false, Msg = "操作失败!"
};
try
{
NotifySettingBusiness bus = new NotifySettingBusiness();
var notifySetting = bus.GetNotifySetting(model.SettingKey);
if (notifySetting != null)
{
message.Msg = "配置已存在!";
return(Content(JsonConvert.SerializeObject(message)));
}
model.ClassName = string.Empty;
model.Remark = "服务配置";
model.Memo = string.Format("新增，操作人：{0}，操作时间: {1}，操作人IP：{2}|", UserName, DateTime.Now, ClientIP);
message.Success = bus.Save(model);
}
catch (Exception)
{
}
return(Content(JsonConvert.SerializeObject(message)));
}
public ActionResult Edit(NotifySettingModel model)
{
ReturnMessage message = new ReturnMessage {
Success = false, Msg = "操作失败!"
};
try
{
NotifySettingBusiness bus = new NotifySettingBusiness();
var notifySetting = bus.GetNotifySetting(model.SettingKey);
if (notifySetting == null)
{
message.Msg = "配置不存在!";
return(Content(JsonConvert.SerializeObject(message)));
}
notifySetting.SettingValue = model.SettingValue;
notifySetting.Memo = string.Format("编辑，操作人：{0}，操作时间: {1}，操作人IP：{2}|", UserName, DateTime.Now, ClientIP);
notifySetting.LastModifyTime = DateTime.Now;
message.Success = bus.Edit(notifySetting);
}
catch (Exception)
{
}
return(Content(JsonConvert.SerializeObject(message)));
}
//
// GET: /NotifyConfig/
public ActionResult Index()
{
NotifySettingBusiness bus = new NotifySettingBusiness();
ViewBag.Data = bus.GetNotifySettingList(new NotifySettingCondition());
return(View());
}
public ActionResult GetNotifySetting(NotifySettingCondition condition)
{
NotifySettingBusiness bus = new NotifySettingBusiness();
var notifySetting = bus.GetNotifySettingList(condition).FirstOrDefault();
if (notifySetting == null)
{
return(new EmptyResult());
}
var result = JsonConvert.DeserializeObject(notifySetting.SettingValue);
return(Content(JsonConvert.SerializeObject(result)));
}
public ActionResult Delete(NotifySettingModel model)
{
ReturnMessage message = new ReturnMessage {
Success = false, Msg = "操作失败!"
};
try
{
NotifySettingBusiness bus = new NotifySettingBusiness();
var notifySetting = bus.GetNotifySetting(model.SettingKey);
if (notifySetting == null)
{
message.Msg = "配置不存在!";
return(Content(JsonConvert.SerializeObject(message)));
}
message.Success = bus.Delete(model);
}
catch (Exception)
{
}
return(Content(JsonConvert.SerializeObject(message)));
}
