来份ASP.NET Core尝尝

 1 namespace Catcher.EasyDemo.Models
 2 {
 3     public class Product
 4     {
 5         public int ProductId { get; set; }
 6         public string ProductName { get; set; }
 7         public string ProductSource { get; set; }
 8         public decimal ProductPrice { get; set; }
 9     }
10 }

  1 using Catcher.EasyDemo.Models;
  2 using Dapper;
  3 using Microsoft.Extensions.Configuration;
  4 using System.Collections.Generic;
  5 using System.Data;
  6 using System.Data.SqlClient;
  7 using System.IO;
  8 using System.Linq;
  9 
 10 namespace Catcher.EasyDemo.DataAccess
 11 {
 12     public sealed class ProductDataAccess
 13     {
 14         public static ProductDataAccess Instance
 15         {
 16             get
 17             {
 18                 return Nested.instance;
 19             }
 20         }
 21 
 22         class Nested
 23         {
 24             static Nested() { }
 25             internal static readonly ProductDataAccess instance = new ProductDataAccess();
 26         }
 27 
 28         /// <summary>
 29         /// get the connection string form the appsettings.json
 30         /// </summary>
 31         /// <returns></returns>
 32         private string GetConnStr()
 33         {
 34             var builder = new ConfigurationBuilder();
 35             builder.SetBasePath(Directory.GetCurrentDirectory());
 36             builder.AddJsonFile("appsettings.json");
 37             var config = builder.Build();             
 38             return config.GetConnectionString("dapperConn");
 39         }
 40                
 41         /// <summary>
 42         /// open the connection
 43         /// </summary>
 44         /// <returns></returns>
 45         private SqlConnection OpenConnection()
 46         {
 47             SqlConnection conn = new SqlConnection(GetConnStr());
 48             conn.Open();
 49             return conn;
 50         }
 51 
 52         /// <summary>
 53         /// get all products
 54         /// </summary>
 55         /// <returns></returns>
 56         public IList<Product> GetAll()
 57         {
 58             using (IDbConnection conn = OpenConnection())
 59             {
 60                 string sql = @"SELECT [ProductId]
 61                                   ,[ProductName]
 62                                   ,[ProductSource]
 63                                   ,[ProductPrice]
 64                               FROM [dbo].[Product]";
 65                 return conn.Query<Product>(sql).ToList();
 66             }
 67         }
 68 
 69         /// <summary>
 70         /// delete the product by product's id
 71         /// </summary>
 72         /// <param name="pid">id of the product</param>
 73         /// <returns></returns>
 74         public bool Delete(int pid)
 75         {           
 76             using (IDbConnection conn = OpenConnection())
 77             {
 78                 string sql = string.Format(@"DELETE FROM [dbo].[Product] WHERE [ProductId]={0} ", pid.ToString());
 79                 return conn.Execute(sql) > 0;
 80             }
 81         }
 82 
 83         /// <summary>
 84         /// add the product
 85         /// </summary>
 86         /// <param name="product">entity of the product</param>
 87         /// <returns></returns>
 88         public bool Add(Product product)
 89         {
 90             using (IDbConnection conn = OpenConnection())
 91             {
 92                 string sql = string.Format(@"INSERT INTO [dbo].[Product]
 93            ([ProductName]
 94            ,[ProductSource]
 95            ,[ProductPrice])
 96      VALUES
 97            ('{0}','{1}',{2})", product.ProductName, product.ProductSource, product.ProductPrice);
 98                 return conn.Execute(sql) > 0;
 99             }
100         }
101     }
102 }

 1 @model IEnumerable<Catcher.EasyDemo.Models.Product>
 2 @{
 3     ViewData["Title"] = "Product Index";
 4 }
 5 <a asp-action="Add" asp-controller="Product">Add a New Product</a>
 6 <div class="container">
 7     <table class="table table-responsive">
 8 
 9         <thead>
10             <tr>
11                 <td>ID</td>
12                 <td>Name</td>
13                 <td>Price</td>
14                 <td>Source</td>
15                 <td>Opreation</td>
16             </tr>
17         </thead>
18 
19         <tbody>
20             @foreach (var item in Model)
21             {
22                 <tr>
23                     <td>@item.ProductId</td>
24                     <td>@item.ProductName</td>
25                     <td>@item.ProductPrice</td>
26                     <td>@item.ProductSource</td>
27                     <td>
28                         <a asp-action="Delete" asp-controller="Product" asp-route-pid="@item.ProductId">Delete</a>
29                     </td>
30                 </tr>
31             }
32         </tbody>
33     </table>
34 </div>