public int Insert(SysGroupMenu sysGroupMenu)
{
var deciResult =
(decimal)
SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("SysGroupMenu_Insert"),
sysGroupMenu.GroupId, sysGroupMenu.MenuId, sysGroupMenu.RoleId, sysGroupMenu.RoleName,
sysGroupMenu.UsedState, sysGroupMenu.Orders,
sysGroupMenu.CreatedDate,
sysGroupMenu.CreatedBy,
CommonHelper.Null.GetNull(sysGroupMenu.ModifiedDate),
CommonHelper.Null.GetNull(sysGroupMenu.ModifiedBy));
return(CommonHelper.Convert.ConvertToInt32(deciResult));
}
public JsonResult Edit(int groupId = 0, int[] menuId = null)
{
try
{
_sysGroupMenuService.DeleteByGroupId(groupId);
for (int i = 0; i < menuId.Length; i++)
{
var model = new SysGroupMenu()
{
SysGroupId = groupId,
SysMenuId = menuId[i],
CTime = DateTime.Now,
UTime = DateTime.Now,
};
_sysGroupMenuService.Insert(model);
}
return(Json(new { Status = Successed.Ok }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Status = Successed.Error }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Delete(SysGroupMenu model)
{
this._repoSysGroupMenu.Delete(model);
}
/// <summary>
/// 修改实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Update(SysGroupMenu model)
{
this._repoSysGroupMenu.Update(model);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public SysGroupMenu Insert(SysGroupMenu model)
{
return(this._repoSysGroupMenu.Insert(model));
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Delete(SysGroupMenu model)
{
this._sysGroupMenuBiz.Delete(model);
}
/// <summary>
/// 修改实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Update(SysGroupMenu model)
{
this._sysGroupMenuBiz.Update(model);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public SysGroupMenu Insert(SysGroupMenu model)
{
return(this._sysGroupMenuBiz.Insert(model));
}
public ActionResult SaveRoleByGroupMenu(int groupId, int menuId, int add, int edit, int deletes, int accept, int export, int admin)
{
try
{
SysGroupMenu sysGroupMenu = new SysGroupMenu();
sysGroupMenu.Orders = 1;
sysGroupMenu.UsedState = 1;
if (groupId != 0 && menuId != 0)
{
#region Add
var modelAdd = _sysAction.FindByRole(groupId, menuId, Ultity.Constant.Add);
if (add == 1)
{
if (modelAdd.Id == 0) //Insert
{
sysGroupMenu.CreatedBy = 1;
sysGroupMenu.CreatedDate = DateTime.Now;
sysGroupMenu.GroupId = groupId;
sysGroupMenu.MenuId = menuId;
sysGroupMenu.RoleId = Ultity.Constant.Add;
sysGroupMenu.RoleName = Ultity.Constant.sAdd;
_sysAction.Insert(sysGroupMenu);
}
}
if (add == 0)
{
if (modelAdd.Id != 0)
{
_sysAction.Delete(modelAdd.Id);
}
}
#endregion
#region Edit
var modelEdit = _sysAction.FindByRole(groupId, menuId, Ultity.Constant.Edit);
if (edit == 1)
{
if (modelEdit.Id == 0) //Insert
{
sysGroupMenu.CreatedBy = 1;
sysGroupMenu.CreatedDate = DateTime.Now;
sysGroupMenu.GroupId = groupId;
sysGroupMenu.MenuId = menuId;
sysGroupMenu.RoleId = Ultity.Constant.Edit;
sysGroupMenu.RoleName = Ultity.Constant.sEdit;
_sysAction.Insert(sysGroupMenu);
}
}
if (edit == 0)
{
if (modelEdit.Id != 0)
{
_sysAction.Delete(modelEdit.Id);
}
}
#endregion
#region Delete
var modelDelete = _sysAction.FindByRole(groupId, menuId, Ultity.Constant.Delete);
if (deletes == 1)
{
if (modelDelete.Id == 0) //Insert
{
sysGroupMenu.CreatedBy = 1;
sysGroupMenu.CreatedDate = DateTime.Now;
sysGroupMenu.GroupId = groupId;
sysGroupMenu.MenuId = menuId;
sysGroupMenu.RoleId = Ultity.Constant.Delete;
sysGroupMenu.RoleName = Ultity.Constant.sDelete;
_sysAction.Insert(sysGroupMenu);
}
}
if (deletes == 0)
{
if (modelDelete.Id != 0)
{
_sysAction.Delete(modelDelete.Id);
}
}
#endregion
#region Accept
var modelAccept = _sysAction.FindByRole(groupId, menuId, Ultity.Constant.Accept);
if (accept == 1)
{
if (modelAccept.Id == 0) //Insert
{
sysGroupMenu.CreatedBy = 1;
sysGroupMenu.CreatedDate = DateTime.Now;
sysGroupMenu.GroupId = groupId;
sysGroupMenu.MenuId = menuId;
sysGroupMenu.RoleId = Ultity.Constant.Accept;
sysGroupMenu.RoleName = Ultity.Constant.sAccept;
_sysAction.Insert(sysGroupMenu);
}
}
if (accept == 0)
{
if (modelAccept.Id != 0)
{
_sysAction.Delete(modelAccept.Id);
}
}
#endregion
#region Export
var modelExport = _sysAction.FindByRole(groupId, menuId, Ultity.Constant.Export);
if (export == 1)
{
if (modelExport.Id == 0) //Insert
{
sysGroupMenu.CreatedBy = 1;
sysGroupMenu.CreatedDate = DateTime.Now;
sysGroupMenu.GroupId = groupId;
sysGroupMenu.MenuId = menuId;
sysGroupMenu.RoleId = Ultity.Constant.Export;
sysGroupMenu.RoleName = Ultity.Constant.sExport;
_sysAction.Insert(sysGroupMenu);
}
}
if (export == 0)
{
if (modelExport.Id != 0)
{
_sysAction.Delete(modelExport.Id);
}
}
#endregion
#region Admin
var modelAdmin = _sysAction.FindByRole(groupId, menuId, Ultity.Constant.ViewEditAll);
if (admin == 1)
{
if (modelAdmin.Id == 0) //Insert
{
sysGroupMenu.CreatedBy = 1;
sysGroupMenu.CreatedDate = DateTime.Now;
sysGroupMenu.GroupId = groupId;
sysGroupMenu.MenuId = menuId;
sysGroupMenu.RoleId = Ultity.Constant.ViewEditAll;
sysGroupMenu.RoleName = Ultity.Constant.sAdmin;
_sysAction.Insert(sysGroupMenu);
}
}
if (admin == 0)
{
if (modelAdmin.Id != 0)
{
_sysAction.Delete(modelAdmin.Id);
}
}
#endregion
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = string.Empty }));
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new
{
status = "fail",
Message = Ultity.Constant.Ajax_Fail
}));
}
}
public ActionResult SaveShowMenu(string menu, int groupId)
{
SysGroupMenu sysModel = new SysGroupMenu();
sysModel.Orders = 1;
sysModel.UsedState = 1;
try
{
if (groupId > 0)
{
string[] listMenu = menu.Split(',');
for (int i = 0; i < listMenu.Length; i++)
{
var model = _sysAction.FindByRole(groupId, Convert.ToInt32(listMenu[i].Split('-')[0]),
Ultity.Constant.View);
if (Convert.ToInt32(listMenu[i].Split('-')[1]) > 0)
{
if (model.Id == 0)
{
sysModel.CreatedBy = 1;
sysModel.CreatedDate = DateTime.Now;
sysModel.GroupId = groupId;
sysModel.MenuId = Convert.ToInt32(listMenu[i].Split('-')[0]);
sysModel.RoleId = Ultity.Constant.View;
sysModel.RoleName = Ultity.Constant.sView;
_sysAction.Insert(sysModel);
}
}
else
{
var lstModel = _sysAction.FindByMenu(groupId, Convert.ToInt32(listMenu[i].Split('-')[0]));
if (lstModel != null && lstModel.Count() > 0)
{
for (int j = 0; j < lstModel.Count(); j++)
{
if (lstModel[j].Id != 0)
{
_sysAction.Delete(lstModel[j].Id);
}
}
}
}
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = "" }));
}
else
{
return(Json(new
{
status = "fail",
Message = Ultity.Constant.Ajax_Fail
}));
}
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new
{
status = "fail",
Message = Ultity.Constant.Ajax_Fail
}));
}
}
