ASP.NET MVC数据显示

前言

学编程的人，都知道，任何编程语言，都会有数据显示功能，那么今天，本小编就以ASP.NET MVC数据显示为一个小小的案例。

（1）数据库

（2）Model

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Model
{
    /// <summary>
    /// 实体类：Login
    /// </summary>
    public class Login
    {
        /// <summary>
        /// 无参构造
        /// </summary>
        public Login()
        {

        }

        /// <summary>
        /// 有参构造
        /// </summary>
        /// <param name="login_id">ID</param>
        /// <param name="login_name">账号名</param>
        /// <param name="login_password">密码名</param>
        public Login(string login_id,string login_name,string login_password)
        {
            Login_Id = login_id;
            Login_Name = login_name;
            Login_Password = login_password;
        }

        /// <summary>
        /// 属性：ID
        /// </summary>
        public string Login_Id { get; set; }

        /// <summary>
        /// 属性：账号名
        /// </summary>
        public string Login_Name { get; set; }

        /// <summary>
        /// 属性：密码名
        /// </summary>
        public string Login_Password { get; set; }
    }
}

（3）DAL

1.LoginDAL

        /// <summary>
        /// 方法：数据显示
        /// </summary>
        /// <param name="login"></param>
        /// <returns></returns>
        public List<Login>Select_Login()
        {
            List<Login> list = new List<Login>();

            using (SqlDataReader dr = DBHelpers.ExecuteReader("select * from Login"))
            {
                while(dr.Read())
                {
                    list.Add(new Login
                    {
                        Login_Id = dr["Login_Id"] as string,
                        Login_Name = dr["Login_Name"] as string,
                        Login_Password = dr["Login_Password"] as string
                    });
                }
                return list;
            }
        }

2.DBHelpers

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public static class DBHelpers
    {
        #region [ Connection ]
        public static string connectionString = "Data Source=USER-20190614XD;Initial Catalog=Shopping;Integrated Security=True";
        public static SqlConnection GetConnection
        {
            get
            {
                return new SqlConnection(connectionString);
            }
        }
        #endregion

        #region [ ExecuteNonQuery ]
        /// <summary>
        /// 普通SQL语句执行增删改
        /// </summary>
        /// <param name="cmdText">SQL语句</param>
        /// <param name="commandParameters">可变参数</param>
        /// <returns>受影响行数</returns>
        public static int ExecuteNonQuery(st