TodoList项目笔记

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;}}
}