/// <summary> /// 用户登录判断 /// </summary> /// <param name="userName">用户名</param> /// <param name="userPwd">密码(MD5)</param> /// <param name="sIP">浏览器IP</param> /// <param name="sBrowser">浏览器类型</param> /// <returns></returns> public ManageUserModel Login(string userName, string userPwd, string sIP, string sBrowser) { Sys_Manage_User manageUser = new Sys_Manage_User(); ManageUserModel AccModel = new ManageUserModel(); AccModel.LoginStatus = false; string sPassWord = ""; StringBuilder strSql = new StringBuilder(); strSql.Append("select top(1) Id,UserName,P_session,LoginCounter,phone,name,PassWord,MenuPermission from Sys_Manage_User where [state]=1 and UserName=@userName;"); manageUser = DapperHelper.GetModel <Sys_Manage_User>(strSql.ToString(), new { userName = userName }); if (manageUser != null) { AccModel.UserID = manageUser.Id; AccModel.UserName = manageUser.UserName; AccModel.PowerSession = Convert.ToInt32(manageUser.P_session); AccModel.LoginCnt = Convert.ToInt32(manageUser.LoginCounter); AccModel.Phone = manageUser.phone; AccModel.Name = manageUser.name; AccModel.MenuPermission = manageUser.MenuPermission; sPassWord = manageUser.PassWord; //判断是否一致 if (sPassWord == userPwd) { //登录成功 AccModel.LoginStatus = true; Sys_ManageLogDAL logDal = new Sys_ManageLogDAL(); logDal.LoginLog(AccModel.UserID, sIP, sBrowser); } } return(AccModel); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Sys_Manage_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Manage_User set "); strSql.Append(" UserName = @UserName , "); strSql.Append(" PassWord = @PassWord , "); strSql.Append(" P_session = @P_session , "); strSql.Append(" LoginCounter = @LoginCounter , "); strSql.Append(" LastLoginTime = @LastLoginTime , "); strSql.Append(" phone = @phone , "); strSql.Append(" name = @name , "); strSql.Append(" simcard = @simcard , "); strSql.Append(" state = @state , "); strSql.Append(" WeixinOpenid = @WeixinOpenid , "); strSql.Append(" WeiXinType = @WeiXinType "); strSql.Append(" where Id=@Id "); int row = DapperHelper.Execute(strSql.ToString(), model); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加账号 /// </summary> /// <param name="account"></param> /// <param name="pw"></param> /// <param name="name"></param> /// <param name="phone"></param> /// <param name="session"></param> /// <returns></returns> public static int AddManageUser(string account, string pw, string name, string phone, int session) { Sys_Manage_User model = new Sys_Manage_User(); model.UserName = account; model.PassWord = CommonLib.Helper.Md5Hash(pw); model.P_session = session; model.LoginCounter = 0; model.LastLoginTime = DateTime.Now; model.phone = phone; model.name = name; model.simcard = ""; model.state = 1; model.WeiXinType = 0; model.Id = BLL.Base.Sys_Manage_UserBaseBLL.Add(model); return(model.Id); }
/// <summary> /// 新增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Sys_Manage_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Manage_User("); strSql.Append("UserName,PassWord,P_session,LoginCounter,LastLoginTime,phone,name,simcard,state,WeixinOpenid,WeiXinType"); strSql.Append(") values ("); strSql.Append("@UserName,@PassWord,@P_session,@LoginCounter,@LastLoginTime,@phone,@name,@simcard,@state,@WeixinOpenid,@WeiXinType"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model); if (obj != null) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 得到一个账号信息 /// </summary> /// <param name="uid"></param> /// <returns></returns> public ManageUserModel GetManageUserModel(int uid) { Sys_Manage_User manageUser = new Sys_Manage_User(); ManageUserModel AccModel = new ManageUserModel(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top(1) Id,UserName,P_session,LoginCounter,phone,name,PassWord,MenuPermission from Sys_Manage_User where [state]=1 and Id=@uid;"); manageUser = DapperHelper.GetModel <Sys_Manage_User>(strSql.ToString(), new { uid = uid }); if (manageUser != null) { AccModel.UserID = manageUser.Id; AccModel.UserName = manageUser.UserName; AccModel.PowerSession = Convert.ToInt32(manageUser.P_session); AccModel.LoginCnt = Convert.ToInt32(manageUser.LoginCounter); AccModel.Phone = manageUser.phone; AccModel.Name = manageUser.name; AccModel.MenuPermission = manageUser.MenuPermission; } return(AccModel); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Sys_Manage_User model) { Sys_Manage_UserBaseDAL dal = new Sys_Manage_UserBaseDAL(); return(dal.Update(model)); }
/// <summary> /// 新增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Add(Sys_Manage_User model) { Sys_Manage_UserBaseDAL dal = new Sys_Manage_UserBaseDAL(); return(dal.Add(model)); }