frmmemorandum.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Bussiness;
namespace UI
{
    public partial class frmMemorandum : Form
    {
        MemorandumInfo objMemorandumInfo = new MemorandumInfo();
        private static frmMemorandum objfrmMemorandum;
        DataTable objDataTable;
        public frmMemorandum()
        {
            InitializeComponent();
        }
        public static frmMemorandum getfrmMemorandum()
        {
            objfrmMemorandum = new frmMemorandum();
            return objfrmMemorandum;
        }

        private void topStripBtnAdd_Click(object sender, EventArgs e)
        {
            frmMemorandumAdd objfrmMemorandumAdd = new frmMemorandumAdd(this);
            objfrmMemorandumAdd.Show();
        }

        private void topStripBtnDel_Click(object sender, EventArgs e)
        {
            if (!datMemorandum.IsSelected(datMemorandum.CurrentRowIndex))
            {
                MessageBox.Show("请选中要修改的行！");
                return;
            }
            if (MessageBox.Show("确认删除数据码,删除将把所有有关信息删除？", "数据删除",
                  MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                //首先删除数据集当中的数据.
                string a = objDataTable.Rows[this.datMemorandum.CurrentRowIndex][0].ToString();
                try
                {
                    objMemorandumInfo.DeleteTicklerTable(a);
                    Bangding();

                    MessageBox.Show("数据删除" + a + "数据成功！！！");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }
            
          
        }

        private void topStripBtnUpdate_Click(object sender, EventArgs e)
        {
            if (!datMemorandum.IsSelected(datMemorandum.CurrentRowIndex))
            {
                MessageBox.Show("请选中要修改的行！");
                return;
            }
            DataRow objUpdateRows = objDataTable.Rows[this.datMemorandum.CurrentRowIndex];
            frmMemorandumUpdate objfrmMemorandumUpdate = frmMemorandumUpdate.getfrmMemorandumUpdate(objUpdateRows);
            objfrmMemorandumUpdate.Show();
        }

        private void topStripBtnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        public void Bangding()
        {
            this.datMemorandum.DataSource = null;
            objDataTable = objMemorandumInfo.GridViewTicklerTable();
            this.datMemorandum.DataSource = objDataTable;
        }
        private void frmMemorandum_Load(object sender, EventArgs e)
        {
            Bangding();
        }
    }
}