public void Save(UserLogin objUserLogin) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); sql = " insert into tbl_user_login(PkId, UserId, LoginTime, LoginIp) values(TUL_PKID.NEXTVAL, :UserId, :LoginTime, :LoginIp) "; parameterList.Add(new OracleParameter(":UserId", objUserLogin.UserId)); parameterList.Add(new OracleParameter(":LoginTime", objUserLogin.LoginTime)); parameterList.Add(new OracleParameter(":LoginIp", objUserLogin.LoginIp)); DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray()); }
public void Save(UserLogin objUserLogin) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); sql = " insert into tbl_user_login(UserId, LoginTime, LoginIp) values(@UserId, @LoginTime, @LoginIp) "; parameterList.Add(new MySqlParameter("@UserId", objUserLogin.UserId)); parameterList.Add(new MySqlParameter("@LoginTime", objUserLogin.LoginTime)); parameterList.Add(new MySqlParameter("@LoginIp", objUserLogin.LoginIp)); DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray()); }
public void Save_Login(UserLogin objUserLogin) { var repository = ServiceFactory.GetService<IUserLoginRepository>(); repository.Save(objUserLogin); }
private bool CheckUser(string userAccount, string userPwd) { IUserService service = ServiceFactory.GetService<IUserService>(); UserInfo uiCurrent = service.GetObjectByUserAccount_Info(userAccount); if (uiCurrent != null) { if (uiCurrent.UserPwd == userPwd.DESEncrypt()) { this.TempUserId = uiCurrent.PkId.ToString(); this.CurrentUser = uiCurrent; this.CurrentUserRole = service.GetObject_Role(this.CurrentUser.RoleId); this.CurrentUserRolePermissionList = (from rp in service.GetList_RolePermission(this.CurrentUserRole.PkId) select rp.PermCode).ToList(); if (this.CurrentUserRole.RoleStatus == (byte)UserRole.RoleStatusEnum.Disable) { this.lblMessage.Text = "账户所属角色被禁用"; return false; } if (this.CurrentUser.UserStatus == (byte)UserInfo.UserStatusEnum.Disable) { this.lblMessage.Text = "账户被禁用"; return false; } UserLogin ulCurrent = new UserLogin() { UserId = this.CurrentUser.PkId, LoginIp = ApplicationHelper.GetClientIp(), LoginTime = DateTime.Now }; service.Save_Login(ulCurrent); return true; } else { this.lblMessage.Text = "密码输入错误"; return false; } } else { this.lblMessage.Text = "账户不存在"; return false; } }