public IActionResult UpdateModulesFuncState(ModulesParam param)//int id
{
var resModel = new ResponseModel(ResponseCode.Error, "修改模块功能状态失败");
try
{
ModulesFunction modulesfuncinfo = new ModulesFunction()
{
是否停用 = param.disable
};
//执行修改方法
var row = this.Update <ModulesFunction>(modulesfuncinfo).Columns("是否停用").Where("id", param.id).Execute();
if (row > 0)
{
resModel.msg = "保存成功";
resModel.code = (int)ResponseCode.Success;
}
}
catch (Exception ex)
{
LogError("修改模块功能状态失败", ex);
resModel.msg = "修改模块功能状态失败";
}
return(Json(resModel));
}
public IActionResult DisableFunction(QueryStateParam param)
{
var resModel = new ResponseModel(ResponseCode.Error, "操作失败", false);
try
{
//判断是否传入id
if (!param.id.IsNullOrEmpty())
{
resModel.msg = "数据异常";
return(Json(resModel));
}
var entity = new ModulesFunction()
{
id = param.id,
是否停用 = param.state
};
////停用
if (entity.是否停用 == 1)
{
entity.停用人 = loginUser.id;
entity.停用时间 = DateTime.Now;
}
else
{
entity.停用人 = null;
entity.停用时间 = null;
}
//管理员禁用/启用模块
var state = this.Update <ModulesFunction>(entity)
.Columns("是否停用")
.Where("id", entity.id)
.Execute();
if (state > 0)//大于0修改成功
{
resModel.data = true;
resModel.code = (int)ResponseCode.Success;
resModel.msg = "修改成功";
}
}
catch (Exception ex)
{
LogError("禁用/启用模块功能异常", ex);
resModel.msg = "修改异常";
}
return(Json(resModel));
}
public async Task <IActionResult> Search(string module, string user, string dateFrom)
{
List <AuditTrail> res = new List <AuditTrail>();
var userList1 = _context.ApplicationUser.ToList();
ViewData["userList"] = new SelectList(userList1, "Id", "Email");
module = string.IsNullOrEmpty(module) ? string.Empty : module.Trim().ToLower();
user = string.IsNullOrEmpty(user) ? string.Empty : user.Trim().ToLower();
dateFrom = string.IsNullOrEmpty(dateFrom) ? string.Empty : dateFrom.Trim().ToLower();
string start = dateFrom.Substring(0, dateFrom.IndexOf('-'));
DateTime sDate = DateTime.ParseExact(start.Trim(), @"MM/dd/yyyy", CultureInfo.InvariantCulture);
string startDate = sDate.ToString("yyyy-MM-dd HH:mm:ss.fff");
string end = dateFrom.Substring(dateFrom.LastIndexOf('-') + 1);
DateTime eDate = DateTime.ParseExact(end.Trim(), @"MM/dd/yyyy", CultureInfo.InvariantCulture);
string endDate = eDate.ToString("yyyy-MM-dd HH:mm:ss.fff");
try
{
DateTime startdate = Convert.ToDateTime(startDate);
DateTime enddate = Convert.ToDateTime(endDate);
if (!module.Equals("-1"))
{
res = await _context.AuditTrail.Where(a => a.UserId == user && a.ActionModuleId.ToLower() == module.ToLower() && a.CreatedDatetime >= startdate.AddDays(-1) &&
a.CreatedDatetime <= enddate.AddDays(1)).ToListAsync();
}
else
{
res = await _context.AuditTrail.Where(a => a.UserId == user && a.CreatedDatetime >= startdate.AddDays(-1) &&
a.CreatedDatetime <= enddate.AddDays(1)).ToListAsync();
}
foreach (var item in res)
{
ModulesFunction.ToModel(item);
}
}
catch (Exception ex)
{
return(null);
}
return(PartialView("SearchPartial", res));
}
public IActionResult editFunction(ModulesFunction entity)
{
var resModel = new ResponseModel(ResponseCode.Error, "操作失败");
try
{
var count = 0;//数据库执行返回结果
if (entity.id.IsNullOrEmpty())
{
//根据模块功能名称验证模块是否存在
var ModulesFunction = this.Query <ModulesFunction>().Where("模块id", entity.模块id).Where("名称", entity.称).Exists();
if (ModulesFunction)
{
resModel.msg = "该模块功能名称已存在！";
return(Json(resModel));
}
entity.数据标识 = 1;
entity.id = Guid.NewGuid().ToString();
//ID为空为新增
count = this.Add <ModulesFunction>(entity).Execute();
}
else
{
//根据模块功能名称验证模块是否存在
var ModulesFunctionList = this.Query <ModulesFunction>().Where("模块id", entity.模块id).Where("名称", entity.称).GetModelList();
var isTrue = ModulesFunctionList != null && ModulesFunctionList.Where(d => d.id != entity.id).Any();
if (isTrue)
{
resModel.msg = "该模块功能名称已存在！";
return(Json(resModel));
}
//修改模块功能
if (entity.是否停用 == 1)
{
entity.停用人 = loginUser.id;
entity.停用时间 = DateTime.Now;
}
else
{
entity.停用人 = null;
entity.停用时间 = null;
}
count = this.Update <ModulesFunction>(entity)
.Columns("模块id", "名称", "描述", "是否停用", "停用人", "停用时间", "顺序", "简码", "图片", "显示方式")
.Where("id", entity.id).Execute();
}
//大于0修改成功
if (count > 0)
{
resModel.code = (int)ResponseCode.Success;
resModel.msg = "执行成功";
}
}
catch (Exception ex)
{
LogError("新增或修改模块功能", ex);
resModel.msg = "操作异常";
}
return(Json(resModel));
}
