public ActionResult LoginInfo(UsersInput input) { var result = _userService.GetUserByName(input); if (result != null) { var model = new UsersOutput() { UserName = result.UserName, PassWord = result.PassWord, Id = result.Id, State = result.State }; Session["QQLOGIN"] = result; } return(Json(result)); }
private void btnLogin_Click(object sender, EventArgs e) { Users users = new Users(); users.username = txtUsername.Text.Trim(); users.password = txtPassword.Text.Trim(); UsersOutput usersOutput = new UsersOutput(); usersOutput.responsecode = ResponseCodes.Fail; UsersManager usersManager = new UsersManager(); usersManager.Login(users, ref usersOutput); lblmessage.Text = usersOutput.message; }
public void Login(Users users, ref UsersOutput usersOutput) { try { using (OleDbConnection conn = new OleDbConnection { ConnectionString = fileName.BuildConnectionString() }) { using (OleDbCommand cmd = new OleDbCommand { Connection = conn }) { cmd.CommandText = "SELECT * FROM tblUsers WHERE username = @username AND password = @password"; cmd.Parameters.AddWithValue("@username", users.username); cmd.Parameters.AddWithValue("@password", users.password); DataTable dataTable = new DataTable(); conn.Open(); dataTable.Load(cmd.ExecuteReader()); if (dataTable.Rows.Count > 0) { DataRow row = dataTable.Rows[0]; usersOutput.status = row["status"].ToString().Trim(); usersOutput.message = "Success"; usersOutput.responsecode = ResponseCodes.Success; } else { usersOutput.message = "Invalid Username/Password"; } } } } catch (Exception ex) { usersOutput.message = ex.Message; usersOutput.responsecode = ResponseCodes.Fail; } }
public DataTransferObject GetUsers(string pageIndex = "1", string pageSize = "20") { try { if (!Int32.TryParse(pageIndex, out int nPageIndex) || nPageIndex <= 0) { return(new DataTransferObject { Status = 0, Message = "pageIndex必须为数字且大于0" }); } if (!Int32.TryParse(pageSize, out int nPageSize) || nPageSize <= 0) { return(new DataTransferObject { Status = 0, Message = "pageSize必须为数字且大于0" }); } var tupleResult = _userService.GetUsers(nPageIndex, nPageSize); var result = new UsersOutput { PageIndex = nPageIndex, PageSize = nPageSize, Count = tupleResult.Item1, Users = tupleResult.Item2 }; return(new DataTransferObject { Status = 1, Result = result }); } catch (Exception ex) { return(new DataTransferObject { Status = 0, Message = ex.Message + "\r\n" + ex.StackTrace }); } }