2021-10-25

using LoginDemo.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
namespace LoginDemo.Controllers
{
    public class HomeController : Controller
    {
        private readonly ILogger<HomeController> _logger;
        private LoginDemoContext db = new LoginDemoContext();
       
        public HomeController(ILogger<HomeController> logger)
        {
            _logger = logger;
        }

        public IActionResult Index()
        {
            return View();
        }
        public IActionResult Login(string Account, string Pwd)
        {
            ContentResult Content = new ContentResult();
            Content.ContentType = "text/html";
            if (string.IsNullOrEmpty(Account))
            {
                return RedirectToAction("index");
            }
            if (string.IsNullOrEmpty(Pwd))
            {
                return RedirectToAction("index");
            }
            LoginUser data = db.LoginUsers.Where(p =>  p.Account == Account.Trim() 
            && p.Pwd == Pwd.Trim()).FirstOrDefault();
            if (data == null)
            {
                return RedirectToAction("index");
            }
            HttpContext.Session.SetString("account", data.Account);


            return RedirectToAction("list");
        }
        public IActionResult list()
        {
            List<LoginUser> data = db.LoginUsers.ToList();
            if (HttpContext.Session.GetString("account") != null)
            {
                ViewBag.Account = HttpContext.Session.GetString("account");
            }
            else
            {
                return RedirectToAction("index");
            }
          
            return View(data);
        }
        public IActionResult add()
        {;
            return View();
        }
        public IActionResult edit(int id)
        {
            
            return View(db.LoginUsers.Find(id));
        }
        public IActionResult delete(int id)
        {
            LoginUser data = db.LoginUsers.Find(id);
             db.LoginUsers.Remove(data);
             db.SaveChanges();
            return RedirectToAction("list");
        }
        public IActionResult save(LoginUser loginUser)
        {
            if (loginUser.Id > 0)
            {
               //修改
             LoginUser data=  db.LoginUsers.Find(loginUser.Id);
                if (data != null)
                {
                    data.Name = loginUser.Name;
                    data.Sex = loginUser.Sex;
                    data.Account = loginUser.Account;
                    data.Address = loginUser.Address;
                    data.Pwd = loginUser.Pwd;
                }
            }
            else
            {
                //新增
                db.LoginUsers.Add(loginUser);
            }
            db.SaveChanges();
            return RedirectToAction("list");
        }
        public IActionResult Privacy()
        {
            return View();
        }

        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult Error()
        {
            return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });
        }
    }
}

@{
    ViewData["Title"] = "add";
}

<form action="/home/save" method="post">
    <div class="form-group">
        <label for="exampleInputEmail1">姓名</label>
        <input type="text" class="form-control" name="Name" id="Name" >
       
    </div>
    <div class="form-group">
        <label for="exampleInputPassword1">性别</label>
        <input type="text" class="form-control" id="Sex" name="Sex">
    </div>
    <div class="form-group">
        <label for="exampleInputEmail1">地址</label>
        <input type="text" class="form-control" id="Address" name="Address">
        
    </div>
    <div class="form-group">
        <label for="exampleInputPassword1">账号</label>
        <input type="text" class="form-control" id="Account" name="Account">
    </div>
    <div class="form-group">
        <label for="exampleInputEmail1">密码</label>
        <input type="text" class="form-control" id="Pwd" name="Pwd" >
    </div>
    <button type="submit" class="btn btn-primary">新增</button>
</form>

@{
    ViewData["Title"] = "edit";}@model LoginUser<form action="/home/save" method="post">    <div class="form-group">        <label for="exampleInputEmail1">姓名</label>        <input type="text" class="form-control" value="@Model.Name" name="Name" id="Name">    </div>    <div class="form-group">        <label for="exampleInputPassword1">性别</label>        <input type="text" class="form-control" id="Sex" value="@Model.Sex" name="Sex">    </div>    <div class="form-group">        <label for="exampleInputEmail1">地址</label>        <input type="text" class="form-control" id="Address" value="@Model.Address" name="Address">    </div>    <div class="form-group">        <label for="exampleInputPassword1">账号</label>        <input type="text" class="form-control" id="Account" value="@Model.Account" name="Account">    </div>    <div class="form-group">        <label for="exampleInputEmail1">密码</label>        <input type="text" class="form-control" id="Pwd" name="Pwd" value="@Model.Pwd">    </div>    <button type="submit" class="btn btn-primary">保存</button></form>

```java
USE [master]GO/****** Object:  Database [LoginDemo]    Script Date: 2021/10/22 20:19:59 ******/CREATE DATABASE [LoginDemo] CONTAINMENT = NONE ON  PRIMARY ( NAME = N'LoginDemo', FILENAME = N'D:\接单\.net core登录\sql\LoginDemo.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'LoginDemo_log', FILENAME = N'D:\接单\.net core登录\sql\LoginDemo_log.ldf' , SIZE = 2048KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)GOALTER DATABASE [LoginDemo] SET COMPATIBILITY_LEVEL = 110GOIF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC [LoginDemo].[dbo].[sp_fulltext_database] @action = 'enable'endGOALTER DATABASE [LoginDemo] SET ANSI_NULL_DEFAULT OFF GOALTER DATABASE [LoginDemo] SET ANSI_NULLS OFF GOALTER DATABASE [LoginDemo] SET ANSI_PADDING OFF GOALTER DATABASE [LoginDemo] SET ANSI_WARNINGS OFF GOALTER DATABASE [LoginDemo] SET ARITHABORT OFF GOALTER DATABASE [LoginDemo] SET AUTO_CLOSE OFF GOALTER DATABASE [LoginDemo] SET AUTO_CREATE_STATISTICS ON GOALTER DATABASE [LoginDemo] SET AUTO_SHRINK OFF GOALTER DATABASE [LoginDemo] SET AUTO_UPDATE_STATISTICS ON GOALTER DATABASE [LoginDemo] SET CURSOR_CLOSE_ON_COMMIT OFF GOALTER DATABASE [LoginDemo] SET CURSOR_DEFAULT  GLOBAL GOALTER DATABASE [LoginDemo] SET CONCAT_NULL_YIELDS_NULL OFF GOALTER DATABASE [LoginDemo] SET NUMERIC_ROUNDABORT OFF GOALTER DATABASE [LoginDemo] SET QUOTED_IDENTIFIER OFF GOALTER DATABASE [LoginDemo] SET RECURSIVE_TRIGGERS OFF GOALTER DATABASE [LoginDemo] SET  DISABLE_BROKER GOALTER DATABASE [LoginDemo] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GOALTER DATABASE [LoginDemo] SET DATE_CORRELATION_OPTIMIZATION OFF GOALTER DATABASE [LoginDemo] SET TRUSTWORTHY OFF GOALTER DATABASE [LoginDemo] SET ALLOW_SNAPSHOT_ISOLATION OFF GOALTER DATABASE [LoginDemo] SET PARAMETERIZATION SIMPLE GOALTER DATABASE [LoginDemo] SET READ_COMMITTED_SNAPSHOT OFF GOALTER DATABASE [LoginDemo] SET HONOR_BROKER_PRIORITY OFF GOALTER DATABASE [LoginDemo] SET RECOVERY FULL GOALTER DATABASE [LoginDemo] SET  MULTI_USER GOALTER DATABASE [LoginDemo] SET PAGE_VERIFY CHECKSUM  GOALTER DATABASE [LoginDemo] SET DB_CHAINING OFF GOALTER DATABASE [LoginDemo] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GOALTER DATABASE [LoginDemo] SET TARGET_RECOVERY_TIME = 0 SECONDS GOEXEC sys.sp_db_vardecimal_storage_format N'LoginDemo', N'ON'GOUSE [LoginDemo]GO/****** Object:  Table [dbo].[LoginUser]    Script Date: 2021/10/22 20:19:59 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[LoginUser](	[Id] [int] IDENTITY(1,1) NOT NULL,	[Name] [nvarchar](50) NULL,	[Sex] [nvarchar](50) NULL,	[Address] [nvarchar](50) NULL,	[Account] [nvarchar](50) NULL,	[Pwd] [nvarchar](50) NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED (	[Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET IDENTITY_INSERT [dbo].[LoginUser] ON INSERT [dbo].[LoginUser] ([Id], [Name], [Sex], [Address], [Account], [Pwd]) VALUES (1, N'张三', N'男', N'成都', N'admin', N'admin')INSERT [dbo].[LoginUser] ([Id], [Name], [Sex], [Address], [Account], [Pwd]) VALUES (2, N'李四', N'男', N'长沙', N'test', N'test')INSERT [dbo].[LoginUser] ([Id], [Name], [Sex], [Address], [Account], [Pwd]) VALUES (3, N'李晓梅', N'女', N'上海', N'demo', N'123')SET IDENTITY_INSERT [dbo].[LoginUser] OFFUSE [master]GOALTER DATABASE [LoginDemo] SET  READ_WRITE GO