C#之对Sqlite数据库进行增删改查

using Sqlite数据库的使用.Repos;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Sqlite数据库的使用
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        UserRepository userRepository = new UserRepository();

        /// <summary>
        /// 查询所有
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {

            var entitysList = userRepository.GetAll().ToList();
            var entitys = userRepository.GetAll();


            dataGridView1.DataSource = null; // 先清空

            dataGridView1.DataSource = entitys;
        }

        /// <summary>
        /// 根据用户名进行筛选
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button5_Click(object sender, EventArgs e)
        {
            var entity = userRepository.Select("李四");

        }

        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button4_Click(object sender, EventArgs e)
        {
            User newUser = new User();
            newUser.UserName = "admin2";
            newUser.Password = "12345678";
            newUser.InsertDate = DateTime.Now;


            int count = userRepository.Insert(newUser);
            if (count > 0)
            {
                MessageBox.Show("插入成功");
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button3_Click(object sender, EventArgs e)
        {
            var entity = userRepository.Select("李四");
            int count = userRepository.Delete(entity);
            if (count > 0)
            {
                MessageBox.Show("删除成功");
            }
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            var entity = userRepository.Select("张三");
            entity.UserName = "JG";
            int count = userRepository.Update(entity);
            if (count > 0)
            {
                MessageBox.Show("修改成功");
            }
        }
    }
}