/// <summary>
/// 用户登录
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <param name="userRoler"></param>
/// <returns></returns>
public bool Login(string userName, string password, ref string realName, ref EnumUserRoler userRoler)
{
DataTable dt = connector.Query("select * from 用户表 where 用户名 = '" + userName + "' and 密码='" + password + "'");
if (dt != null && dt.Rows.Count > 0)
{
connector.Query("update 用户表 set 最后登录时间 ='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where 用户名 = '" + userName + "'");
if (dt.Rows[0]["是否为管理员"].ToString().ToUpper() == "TRUE")
{
userRoler = EnumUserRoler.Admin;
}
else
{
userRoler = EnumUserRoler.User;
}
realName = dt.Rows[0]["真实姓名"].ToString();
return(true);
}
return(false);
}
/// <summary>
/// 按照 用户权限添加项目 到弹出菜单
/// </summary>
/// <param name="menuStrip"></param>
/// <param name="toolStripItem"></param>
/// <param name="roler"></param>
private void AddItemToMenuStrip(ContextMenuStrip menuStrip, ToolStripItem toolStripItem, EnumUserRoler roler)
{
if (roler == UserLogin.UserRoler || UserLogin.UserRoler == EnumUserRoler.Admin)
{
menuStrip.Items.Add(toolStripItem);
}
}
