notemanageform.cs

事务提醒软件。自己写的事务提醒软件

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

namespace MyNote
{
    public partial class NoteManageForm : Form
    {
        public NoteManageForm(MyNotes myNotes)
        {
            InitializeComponent();
            mMyNotes = myNotes;
            Init();
        }


        private void Init()
        {
            allNotesDT = new DataTable();
            selectDateNotesDT = new DataTable();
            int i;

            allNotesDT.Columns.Add("事务编号");
            allNotesDT.Columns.Add("事务内容");
            allNotesDT.Columns.Add("事务时间");

            selectDateNotesDT.Columns.Add("事务编号");
            selectDateNotesDT.Columns.Add("事务内容");
            selectDateNotesDT.Columns.Add("事务时间");
            iMaxNoteIndex = 0;
            for (i = 0; i < mMyNotes.mEvents.Length; i++)
            {
                allNotesDT.Rows.Add(mMyNotes.mEvents[i].mIndex, mMyNotes.mEvents[i].mContent, mMyNotes.mEvents[i].mDatetime.Date);
                if (iMaxNoteIndex < mMyNotes.mEvents[i].mIndex)
                {
                    iMaxNoteIndex = mMyNotes.mEvents[i].mIndex;
                }
            }
            dataGrid2.DataSource = allNotesDT;
        }

        private MyNotes mMyNotes;
        private DataTable allNotesDT;
        private DataTable selectDateNotesDT;
        private int cIndex = -1;
        private int iMaxNoteIndex;

        private void monthCalendar1_DateSelected(object sender, DateRangeEventArgs e)
        {
            SetSelectDateNotes();
        }

        private void SetSelectDateNotes()
        {
            int i;
            selectDateNotesDT.Rows.Clear();
            for (i = 0; i < mMyNotes.mEvents.Length; i++)
            {
                if (mMyNotes.mEvents[i].mDatetime.Date.CompareTo(monthCalendar1.SelectionStart.Date) == 0)
                {
                    selectDateNotesDT.Rows.Add(mMyNotes.mEvents[i].mIndex, mMyNotes.mEvents[i].mContent, mMyNotes.mEvents[i].mDatetime.Date);
                }
            }
            dataGrid1.DataSource = selectDateNotesDT;
            label2.Text = monthCalendar1.SelectionStart.Date.ToShortDateString();
        }

        private void NoteManageForm_Load(object sender, EventArgs e)
        {

        }

        private void dataGrid2_Click(object sender, EventArgs e)
        {
            int rn = dataGrid2.CurrentRowIndex;
            if (rn >= 0)
            {
                cIndex = rn;
                label2.Text = (string)allNotesDT.Rows[rn]["事务时间"];
                textBox1.Text = (string)allNotesDT.Rows[rn]["事务内容"];
            }
            
        }


        private void SetDataGridColumnStyle(ref DataGrid myDataGrid, DataTable myTable, int[] ColumnWidth)
        {
            DataGridTableStyle dataGridTableStyle = new DataGridTableStyle();
            dataGridTableStyle.MappingName = myTable.TableName;
            dataGridTableStyle.AlternatingBackColor = myDataGrid.AlternatingBackColor;
            dataGridTableStyle.BackColor = myDataGrid.BackColor;
            dataGridTableStyle.ForeColor = myDataGrid.ForeColor;
            dataGridTableStyle.GridLineColor = myDataGrid.GridLineColor;
            dataGridTableStyle.GridLineStyle = myDataGrid.GridLineStyle;
            dataGridTableStyle.HeaderBackColor = myDataGrid.HeaderBackColor;
            dataGridTableStyle.HeaderForeColor = myDataGrid.HeaderForeColor;

            dataGridTableStyle.DataGrid = myDataGrid;

            DataGridTextBoxColumn dataGridTextBoxColumn = new DataGridTextBoxColumn();
            int i;

            for (i = 0; i < myTable.Columns.Count; i++)
            {
                dataGridTextBoxColumn = new DataGridTextBoxColumn();
                dataGridTextBoxColumn.MappingName = myTable.Columns[i].ColumnName;
                dataGridTextBoxColumn.HeaderText = myTable.Columns[i].ColumnName;
                dataGridTextBoxColumn.Width = ColumnWidth[i];
                dataGridTableStyle.GridColumnStyles.Add(dataGridTextBoxColumn);
            }
            myDataGrid.TableStyles.Add(dataGridTableStyle);
        }

        private void button3_Click(object sender, EventArgs e)
        {
            if (cIndex >= 0)
            {
                mMyNotes.mEvents[cIndex].mContent = textBox1.Text;
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {

            if (cIndex >= 0)
            {
                DialogResult dr = MessageBox.Show("确认删除事务'" + mMyNotes.mEvents[cIndex].mContent + "'吗？", "删除事务", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dr == DialogResult.Yes)
                {
                    int i;
                    int j = 0;
                    int k = -1;
                    for (i = 0; i < selectDateNotesDT.Rows.Count; i++)
                    {
                        if (Convert.ToInt32(selectDateNotesDT.Rows[i]["事务编号"].ToString()) == mMyNotes.mEvents[cIndex].mIndex)
                        {
                            k = i;
                            break;
                        }
                    }
                    if (k >= 0)
                    {
                        selectDateNotesDT.Rows.RemoveAt(k);
                    }
                    MyEvent[] tmpEvents = new MyEvent[mMyNotes.mEvents.Length - 1];
                    for (i = 0; i < mMyNotes.mEvents.Length; i++)
                    {
                        if (i != cIndex)
                        {
                            tmpEvents[j] = mMyNotes.mEvents[i];
                            j++;
                        }
                    }
                    mMyNotes.mEvents = tmpEvents;
                    allNotesDT.Rows.RemoveAt(cIndex);
                    label1.Text = "";
                    textBox1.Text = "";
                    cIndex = -1;
                }
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            int i;
            if (label2.Text != "")
            {
                DialogResult dr = MessageBox.Show("确认添加事务'" + textBox1.Text + "'吗？", "添加事务", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dr == DialogResult.Yes)
                {
                    MyEvent[] tmpEvents = new MyEvent[mMyNotes.mEvents.Length + 1];
                    for (i = 0; i < mMyNotes.mEvents.Length; i++)
                    {
                        tmpEvents[i] = mMyNotes.mEvents[i];
                    }
                    iMaxNoteIndex++;
                    tmpEvents[mMyNotes.mEvents.Length] = new MyEvent(iMaxNoteIndex, textBox1.Text, Convert.ToDateTime(label2.Text));
                    mMyNotes.mEvents = tmpEvents;
                    allNotesDT.Rows.Add(mMyNotes.mEvents[mMyNotes.mEvents.Length - 1].mIndex, mMyNotes.mEvents[mMyNotes.mEvents.Length - 1].mContent, mMyNotes.mEvents[mMyNotes.mEvents.Length - 1].mDatetime);
                    label2.Text = "";
                    textBox1.Text = "";
                    SetSelectDateNotes();
                }
            }
        }

        private void monthCalendar1_DateChanged(object sender, DateRangeEventArgs e)
        {

        }

        private void button4_Click(object sender, EventArgs e)
        {
            CommmonUse CU = new CommmonUse();
            CU.DeleteAllMyEvents();
            CU.InsertMyEventsToDB(mMyNotes.mEvents);
            MessageBox.Show("更新完毕！");
            Init();
            SetSelectDateNotes();
        }

    }
}