TodoList项目笔记
-
项目地址:
https://github.com/getimad/wpf-todo-list -
在
SQLServer中手动创建数据库并生成数据表
> CREATE DATABASE MyTodoList;> USE MyTodoList;> CREATE TABLE TASKS (Id INT IDENTITY(1,1) PRIMARY KEY,Content VARCHAR(MAX) NOT NULL,Priority CHAR(10) CHECK (Priority IN ('Priority 1', 'Priority 2', 'Priority 3', 'Priority 4')) NOT NULL,Date DATETIME DEFAULT SYSDATETIME()
);
- 新建
App.config,写入如下内容
<?xml version="1.0" encoding="utf-8" ?><configuration><connectionStrings><add name="MyTodoListDB" connectionString="Server=.;Database=MyTodoList;Integrated Security=True;" providerName="System.Data.SqlClient"/></connectionStrings></configuration>
- 安装依赖
<Project Sdk="Microsoft.NET.Sdk"><PropertyGroup>......</PropertyGroup><ItemGroup><PackageReference Include="Dapper" Version="2.1.*" /><PackageReference Include="System.Data.SqlClient" Version="4.*" /></ItemGroup></Project>- 主要的
项目目录结构
- Models // 模型层- Task.cs // Task类,数据模型- Utilities // 工具层- DataAccess.cs // 数据库的crud操作- Helper.cs // 读取app.config的sql连接字符串- MainWindow.xaml // UI窗体- MainWindow.xaml.cs // 主程序代码- 模型数据如下
// Models.Task.csusing System;namespace TodoList.Models
{public class Task{public int Id { get; set; }public string? Content { get; set; }public string? Priority { get; set; }public DateTime Date { get; set; }}
}- 工具层
Helper.cs代码如下
using System.Configuration;namespace TodoList.Utilities
{public static class Helper{// 静态方法，无需创建实例即可调用public static string GetConnectionString(string name){// 从配置文件的ConnectionStrings节点获取指定名称的连接字符串return ConfigurationManager.ConnectionStrings[name].ConnectionString;}}
}