///// <summary>
///// 新增或编辑 递归方法体
///// </summary>
///// <param name="model"></param>
//public void Fun(Power_MenuView model)
//{
// List<ParameterJson> list = new List<ParameterJson>();
// list.Add(new ParameterJson("ParentID", ConditionOperate.Equal.ToString(), model.ID.ToString()));
// string sCondition = JsonConvert.SerializeObject(list);
// string strSort = new JqSortParam().ToJson();
// string childList = _menubll.GetListJson(sCondition, strSort);
// List<Power_MenuView> oList = JsonConvert.DeserializeObject<List<Power_MenuView>>(childList);
// foreach (var item in oList)
// {
// item.IsEnable = model.IsEnable;
// //更新数据库IsEnable=false
// Power_MenuView o = _menubll.Update(item);
// //缓存更新
// menuCache.AddOrUpdate(item);
// Fun(o);
// }
//}
/// <summary>
/// 根据ID获取ViewModel
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetModel(string id)
{
Power_Menu entity = _menuRepository.GetById(Guid.Parse(id));
//Power_Menu entity = _db.Power_Menu.Find(Guid.Parse(id));
//Power_MenuView entity = _menubll.GetViewModel(id);
return(JsonConvert.SerializeObject(entity));
}
/// <summary>
/// 根据id删除一条数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Del(Guid id)
{
if (id != Guid.Empty)
{
//执行删除前先获取到要删除数据的model
//Power_MenuView model = _menubll.GetViewModel(id.ToString());
Power_Menu model = _db.Power_Menu.Find(id);
try
{
_db.Set <Power_Menu>().Remove(model);
_db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
return(false);
}
private void InitializeNetCoreBBSDatabase(IServiceProvider serviceProvider)
{
using (var serviceScope = serviceProvider.GetRequiredService <IServiceScopeFactory>().CreateScope())
{
var db = serviceScope.ServiceProvider.GetService <DataContext>();
if (db.Database != null && db.Database.EnsureCreated())
{
Power_User user = new Power_User();
user.ID = Guid.NewGuid();
user.IsSuperUser = true;
user.Cn = "超级管理员";
user.PassWord = MD5Helper.MD5Encrypt32("123456");
user.UID = "Admin";
user.U_AreaCode = "A001";
user.U_IsValid = true;
db.Power_User.Add(user);
db.SaveChanges();
Power_Area area = new Power_Area();
area.Code = "A001";
area.ID = Guid.NewGuid();
area.IsEnable = true;
area.Level = 1;
area.ParentID = Guid.Empty;
area.Title = "北京总公司";
db.Power_Area.Add(area);
db.SaveChanges();
Power_Menu menu1 = new Power_Menu();
menu1.ID = Guid.NewGuid();
menu1.Code = "M001";
menu1.IsEnable = true;
menu1.IsShow = true;
menu1.Name = "系统管理";
menu1.U_CreateDate = DateTime.Now;
menu1.U_IsSystem = true;
menu1.U_IsValid = true;
db.Power_Menu.Add(menu1);
db.SaveChanges();
Power_Menu menu2 = new Power_Menu();
menu2.ID = Guid.NewGuid();
menu2.Code = "M002";
menu2.IsEnable = true;
menu2.IsShow = true;
menu2.Name = "区域管理";
menu2.U_CreateDate = DateTime.Now;
menu2.U_IsSystem = true;
menu2.U_IsValid = true;
menu2.Path = "/SystemManage/Area/Index";
menu2.ParentID = menu1.ID;
db.Power_Menu.Add(menu2);
db.SaveChanges();
Power_Menu menu3 = new Power_Menu();
menu3.ID = Guid.NewGuid();
menu3.Code = "M003";
menu3.IsEnable = true;
menu3.IsShow = true;
menu3.Name = "菜单管理";
menu3.U_CreateDate = DateTime.Now;
menu3.U_IsSystem = true;
menu3.U_IsValid = true;
menu3.Path = "/SystemManage/Menu/Index";
menu3.ParentID = menu1.ID;
db.Power_Menu.Add(menu3);
db.SaveChanges();
}
else
{
//db.Database.Migrate();
}
}
}
///// <summary>
///// 获取菜单Json MiniTree
///// </summary>
///// <returns></returns>
//public string GetMiniTreeMenuJson()
//{
// List<Power_MenuView> list = menuCache.GetMenuList();
// list = list.Where(d => d.IsEnable == true).OrderBy(d => d.U_SortNo).ToList();
// var a = list.Select(x => new MiniTreeNode2()
// {
// id = x.ID.ToString(),
// pid = x.ParentID.ToString(),
// text = x.Name,
// url = x.Path,
// sort = x.U_SortNo == null ? 0 : (int)x.U_SortNo
// }).ToList();
// return JsonConvert.SerializeObject(a.OrderBy(x => x.sort));
//}
///// <summary>
///// 根据userId 获取用户权限
///// </summary>
///// <param name="userId"></param>
///// <returns></returns>
//public string GetMenuJsonsByUserId(string id)
//{
// MessageUser mu = ManageProvider.Current;
// string roleIds = mu.RoleIds;
// List<MiniTreeNode2> list = menuCache.GetMenuForLeftMenu(roleIds, mu.U_AreaCode);
// list = list.OrderBy(x => x.sort).ToList();
// return JsonConvert.SerializeObject(list);
//}
/// <summary>
/// 新增或编辑
/// </summary>
/// <param name="model"></param>
public void InsertOrUpdate(Power_Menu model)
{
Guid Id = model.ID;
if (Id == Guid.Empty)
{
model.ID = Guid.NewGuid();
model.IsEnable = true;
model.IsShow = true;
model.Style = "add";
try
{
//_db.Power_Menu.Add(model);
//_db.Set<Power_Menu>().Add(model);
//_db.SaveChanges();
_menuRepository.Add(model);
}
catch (Exception ex)
{
//logcache.AddServiceLogForAdd<Power_MenuView>(model, CurrentMenuID, "新增菜单异常", "Power_Menu", Request.Path, ex.Message, ex.StackTrace);
}
}
else
{
Power_Menu model1 = _menuRepository.GetById(model.ID);
//Power_Menu model1 = _db.Power_Menu.Find(model.ID);
//Power_MenuView model1 = _menubll.GetViewModel(model.ID.ToString());
//Power_MenuView oldmodel = ObjectClone.ToClone<Power_MenuView>(model1);
try
{
model1.Name = model.Name;
model1.Path = model.Path;
model1.Style = model.Style;
model1.ParentID = model.ParentID;
model1.Type = model.Type;
model1.Code = model.Code;
model1.IsEnable = model.IsEnable;
model1.IsSuperUser = model.IsSuperUser;
model1.IsShow = model.IsShow;
//_db.Entry(model1).State = EntityState.Modified;
//_db.SaveChanges();
_menuRepository.Edit(model1);
//更新缓存
//menuCache.AddOrUpdate(model1);
//循环更新子节点
//if (model.IsEnable != oldmodel.IsEnable)
//{
// Fun(model1);
//}
//记录日志
//logcache.AddServiceLogForUpdate(model1, oldmodel, CurrentMenuID, "更新菜单", "Power_Menu");
}
catch (Exception ex)
{
//logcache.AddServiceLogForUpdate(model1, oldmodel, CurrentMenuID, "更新菜单异常", "Power_Menu", Request.Path, ex.Message, ex.StackTrace);
}
}
return;
}
