public FrmAccountSettingEdit(Sys_Accounts account) { InitializeComponent(); this.DataContext = this; MainAccount = account; MyTitle = account.AccountName == null ? "新增账户" : "编辑账户"; RoleList = new UserInfoBLL().GetRoleInfo(); SelectedRole = account.AccountName != null?RoleList.Find(p => p.ID == account.RoleID) : RoleList[0]; }
/// <summary> /// 新增账户 /// </summary> /// <param name="account"></param> /// <returns></returns> public bool InsertAccount(Sys_Accounts account) { if (account != null && account.UserName != "" && account.PassWord != "") { db.Sys_Accounts.AddObject(account); db.SaveChanges(); return(true); } return(false); }
/// <summary> /// 更新账户 /// </summary> /// <param name="account"></param> /// <returns></returns> public bool UpdateAccount(Sys_Accounts account) { Sys_Accounts acc = ExistsAccount(account); if (acc != null) { acc = account; db.SaveChanges(); return(true); } return(false); }
/// <summary> /// 是否存在该账户 /// </summary> /// <param name="account"></param> /// <returns></returns> public Sys_Accounts ExistsAccount(Sys_Accounts account) { var query = from ac in db.Sys_Accounts where ac.AccountName == account.UserName select ac; if (query != null && query.ToList().Count > 0) { return(query.ToList <Sys_Accounts>().FirstOrDefault()); } return(null); }
/// <summary> /// 新增命令 /// </summary> /// <returns></returns> public override void ExecuteAdd() { Sys_Accounts account = new Sys_Accounts(); account.ID = new UserInfoBLL().GetMaxAccountID() + 1; FrmAccountSettingEdit edit = new FrmAccountSettingEdit(account); edit.SaveEvent += (r) => { AccountList.Add(r); }; edit.ShowDialog(); }
/// <summary> /// 删除命令 /// </summary> /// <returns></returns> public override void ExecuteDelete() { if (SelectedAccount != null) { if (SelectedAccount.AccountName == "00") { System.Windows.MessageBox.Show("超级管理员账户不能删除"); return; } UserInfoBLL bll = new UserInfoBLL(); if (bll.DeleteAccount(SelectedAccount)) { AccountList.Remove(SelectedAccount); SelectedAccount = null; } } }
/// <summary> /// 根据用户名获得菜单列表(如果是管理员级别则显示系统设置) /// </summary> /// <param name="accountName"></param> /// <returns></returns> public List <Sys_Menus> GetMenuByAccount(Sys_Accounts account, int systemId) { if (account.RoleID < 2)//管理员 { var query = (from menu in db.Sys_Menus where menu.SystemID == systemId select menu).Union(from p in db.Sys_Menus where p.SystemID == -1 select p); return(new List <Sys_Menus>(query)); } else//用户 { var query = (from menu in db.Sys_Menus join rm in db.Sys_Role_Menu on menu.ID equals rm.MenuID join ac in db.Sys_Accounts on rm.RoleID equals ac.RoleID where ac.AccountName == account.AccountName && menu.SystemID == systemId && rm.IsEnable.Value select menu); return(new List <Sys_Menus>(query)); } }
/// <summary> /// 修改命令 /// </summary> /// <returns></returns> public override void ExecuteEdit() { if (SelectedAccount != null) { Sys_Accounts account = new Sys_Accounts(); account.ID = SelectedAccount.ID; account.AccountName = SelectedAccount.AccountName; account.PassWord = SelectedAccount.PassWord; account.UserName = SelectedAccount.UserName; account.Address = SelectedAccount.Address; account.Email = SelectedAccount.Email; account.Phone = SelectedAccount.Phone; account.Discribtion = SelectedAccount.Discribtion; account.Remark = SelectedAccount.Remark; account.RoleID = SelectedAccount.RoleID; FrmAccountSettingEdit edit = new FrmAccountSettingEdit(account); edit.SaveEvent += (s) => { AccountList[AccountList.IndexOf(SelectedAccount)] = s; SelectedAccount = s; }; edit.ShowDialog(); } }
/// <summary> /// 根据用户名和系统获取模块权限 /// </summary> /// <param name="userId"></param> /// <returns></returns> public List <Sys_Modules> GetModuleButtonsByAccount(Sys_Accounts account, int systemId) { if (account.RoleID < 2)//管理员 { var query = (from m in db.Sys_Modules join menu in db.Sys_Menus on m.MenuID equals menu.ID where menu.SystemID == systemId select m).Union(from m in db.Sys_Modules join menu in db.Sys_Menus on m.MenuID equals menu.ID where menu.SystemID == -1 select m); return(new List <Sys_Modules>(query)); } else//普通用户 { var query = (from m in db.Sys_Modules join menu in db.Sys_Menus on m.MenuID equals menu.ID join rm in db.Sys_Role_Module on m.ID equals rm.ModuleID join ac in db.Sys_Accounts on rm.RoleID equals ac.RoleID where menu.SystemID == systemId && ac.AccountName == account.AccountName && rm.IsEnable.Value select m); return(new List <Sys_Modules>(query)); } }
/// <summary> /// 判断用户是否存在 /// </summary> /// <param name="account"></param> /// <returns></returns> public Sys_Accounts ExistsAccount(Sys_Accounts account) { return(dal.ExistsAccount(account)); }
/// <summary> /// 更新用户信息 /// </summary> /// <param name="account"></param> /// <returns></returns> public bool UpdateAccount(Sys_Accounts account) { return(dal.UpdateAccount(account)); }
/// <summary> /// 新增用户信息 /// </summary> /// <param name="account"></param> /// <returns></returns> public bool InsertAccount(Sys_Accounts account) { return(dal.InsertAccount(account)); }
/// <summary> /// 根据账号和系统类别获取模块及权限 /// </summary> /// <param name="userName"></param> /// <param name="systemId"></param> /// <returns></returns> public List <Sys_Modules> GetModuleButtonsByAccount(Sys_Accounts account, int systemId) { return(dal.GetModuleButtonsByAccount(account, systemId)); }
/// <summary> /// 根据账号获取菜单信息 /// </summary> /// <param name="userName"></param> /// <returns></returns> public List <Sys_Menus> GetMenuByAccount(Sys_Accounts account, int systemId) { return(dal.GetMenuByAccount(account, systemId)); }
/// <summary> /// 删除账号信息 /// </summary> /// <param name="account"></param> /// <returns></returns> public bool DeleteAccount(Sys_Accounts account) { return(dal.DeleteAccount(account)); }
/// <summary> /// 删除账号信息 /// </summary> /// <param name="account"></param> /// <returns></returns> public bool DeleteAccount(Sys_Accounts account) { db.Sys_Accounts.DeleteObject(account); db.SaveChanges(); return(true); }