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);
}
