using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SQLite;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace dgv分页 {
    public partial class Form2 : Form {
        public Form2() {
            InitializeComponent();
        }
        /// <summary>
        ///     bs = new BindingSource();
        /// </summary>
        BindingSource bs = new BindingSource();
        /// <summary>
        ///  dt = new DataTable(); 用于过滤数据用    dgv1.DataSource = dt;
        /// </summary>
        DataTable dt = new DataTable();
        DataSet dataSet;

        private void Form2_Load(object sender,EventArgs e) {
            SQLiteHelper sqlite = new SQLiteHelper("Data Source = test.db; Version=3;");
            dataSet = sqlite.DataAdapter($"Select * From Data","Data");

            dt = dataSet.Tables[0];

            dgv1.DataSource = dt;


            //bs.DataSource = null;
            //绑定部分 ---------------------------
            bs.DataSource = dt;
            dgv1.DataSource = bs;
            bindingNavigator1.BindingSource = bs;

            //绑定之后bindingNavigator1的按钮是不需要写任何代码就能直接调用的
            //控件绑定----------------------------
            //参数1 = textBox2的属性 textBox2.Text
            //参数2 = 绑定源 DataSource
            //参数3 = DataTable列的名字 "单词" 列
            textBox_单词.DataBindings.Add("Text",bs,"单词");//修改控件的属性 会更新表格的属性值的
            textBox_音标.DataBindings.Add("Text",bs,"音标");
            textBox_解释.DataBindings.Add("Text",bs,"解释");
            textBox_id.DataBindings.Add("Text",bs,"id");
            textBox2.DataBindings.Add("Text",bs,"已掌握");
        }

        private void textBox_id_TextChanged(object sender,EventArgs e) {
            TextBox t = sender as TextBox;
            if (t == null) return;
            t.Text = SqlString.Restore(t.Text);
            //处理特殊字符串
            //textBox_单词.Text = SqlString.Restore(textBox_单词.Text);
            //textBox_音标.Text = SqlString.Restore(textBox_音标.Text);
            //textBox_解释.Text = SqlString.Restore(textBox_解释.Text);
        }

        private void textBox_id_Validated(object sender,EventArgs e) {
            //此方法相当于 LostFocus事件
            //更新到数据库中需要在此写并且要加个判断Modified减少对数据库的操作
        }

        private void dgv1_CellFormatting(object sender,DataGridViewCellFormattingEventArgs e) {
            //格式化绑定

            if (e.Value == null) return;
            //绑定后显示的数值不是显示的数值
            switch (dgv1.Columns[e.ColumnIndex].Name) {
                case "单词":
                case "音标":
                case "解释":
                case "例句":
                    e.Value = SqlString.Restore(e.Value.ToString());
                    break;
            }
        }

        private void bindingNavigatorAddNewItem_Click(object sender,EventArgs e) {

        }

        //为了确保下面的代码可单独使用 选中bindingNavigator1设置DeleteItem的值为空
        private void bindingNavigatorDeleteItem_Click(object sender,EventArgs e) {
            DialogResult d = MessageBox.Show("确认删除吗？","删除",MessageBoxButtons.OKCancel);
            if ( d== DialogResult.OK) {

                  //删除的是dataSet表中的行，而不是删除dataGridView的行
                dataSet.Tables[0].Rows[bindingNavigator1.BindingSource.Position].Delete();

            }

        }

        private void button1_Click(object sender,EventArgs e) {
            //默认选中的dgv1索引项
            bindingNavigator1.BindingSource.Position =  -1; //修改bindingNavigator1.BindingSource.Position的索引来选中dataGridView默认选中项 
        }


    }
}