图书信息维护.cs

适用于单位图书馆

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

using System.Data.SqlClient;
namespace 图书管理
{
    public partial class 图书信息维护 : Form
    {
        public 图书信息维护()
        {
            InitializeComponent();
        }

        public void ErrorHandle(System.Exception E)
        {
            MessageBox.Show(E.ToString());
        }
        private void LoadDataSet()
        {
            DataSetBook objDataSetTemp = new DataSetBook();
            try
            {
                this.FillDataSet(objDataSetTemp);
            }
            catch (System.Exception E)
            {
                this.ErrorHandle(E);
             }
             try
             {
                 this.objDataSetBook.Clear();
                 this.objDataSetBook.Merge(objDataSetTemp);
             }
             catch (System.Exception E)
             {
                 this.ErrorHandle(E);

             }
           
        }

        private void FillDataSet(DataSetBook dataset)
        {
            dataset.EnforceConstraints = false;
            try
            {
                this.sqlConnection1.Open();
                this.sqlDataAdapter1.Fill(dataset);
            }
            catch (System.Exception E)
            {
                this.ErrorHandle(E);
            }
            finally
            {
                dataset.EnforceConstraints = true;
                this.sqlConnection1.Close();
            }
           
        }

        private void DatasetPostionChange()
        {
            this.IbIDatasetPosition.Text = (this.BindingContext[this.objDataSetBook, "Book"].Position + 1) +
                "的" + (this.BindingContext[this.objDataSetBook, "Book"].Count);

          }

        private void ButtonPositonChange()
        {
            this.btnPrevious.Enabled = true;
            this.btnNext.Enabled = true;
            this.btnFirst.Enabled = true;
            this.btnLast.Enabled = true;
            if (this.BindingContext[this.objDataSetBook, "Book"].Position == 0)
            {
                this.btnFirst.Enabled = false;
                this.btnPrevious.Enabled = false;
            }
            if (this.BindingContext[this.objDataSetBook, "Book"].Position == this.BindingContext[this.objDataSetBook, "Book"].Count - 1)
            {
                this.btnNext.Enabled = false;
                this.btnLast.Enabled = false;
            }
        }

        private void ButtonEnableControl(bool valid)
        {
            if (valid)
            {
                this.btnCancel.Enabled = true;
                this.btnApply.Enabled = true;
            }
            else
            {
                this.btnCancel.Enabled = false;
                this.btnApply.Enabled = false;
            }
        }

        private void TextEnableControl(bool valid)
        {
            if (valid)
            {
                this.textID.Enabled = true;
                this.textName.Enabled = true;
                this.textPrice.Enabled = true;
                this.textPublish.Enabled = true;
                this.textPublishDate.Enabled = true;
                this.textWriter.Enabled = true;
                this.textSort.Enabled = true;
                this.textAmount.Enabled = true;
                this.textRemain.Enabled = true;

            }
            else
            {
                this.textID.Enabled = false ;
                this.textName.Enabled = false ;
                this.textPrice.Enabled = false ;
                this.textPublish.Enabled = false ;
                this.textPublishDate.Enabled = false;
                this.textWriter.Enabled = false;
                this.textSort.Enabled = false ;
                this.textAmount.Enabled = false ;
                this.textRemain.Enabled = false ;
 
            }
        }

        private void TextClear(bool valid)
        {
            if (valid)
            {
                this.textID.Clear();
                this.textName.Clear();
                this.textPrice.Clear();
                this.textPublish.Clear();
                this.textPublishDate.Clear();
                this.textWriter.Clear();
                this.textSort.Clear();
                this.textAmount.Clear();
                this.textRemain.Clear();
            }

        }

        public void UpdateDataSet()
        {
            this.BindingContext[this.objDataSetBook, "Book"].EndCurrentEdit();
            DataSetBook objDataSetTemp = new DataSetBook();
            objDataSetTemp = (DataSetBook)(this.objDataSetBook.GetChanges());
            try
            {
                this.UpdateDataSource(objDataSetTemp);
                this.objDataSetBook.Merge(objDataSetTemp);
                this.objDataSetBook.AcceptChanges();

            }
            catch (System.Exception E)
            {
                this.ErrorHandle(E);
            }
        }

        public void UpdateDataSource(DataSetBook Changerows)
        {
            try
            {
                this.sqlConnection1.Open();
                this.sqlDataAdapter1.Update(Changerows);
            }
            catch (System.Exception E)
            {
                this.ErrorHandle(E);
            }
            finally
            {
                this.sqlConnection1.Close();
            }
        }


        private void Form1_Load(object sender, EventArgs e)
        {
            this.LoadDataSet();
            this.DatasetPostionChange();
            this.ButtonPositonChange();
            this.TextEnableControl(false);
            this.ButtonEnableControl(false);

        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                 this.TextClear(true);
                this.BindingContext[this.objDataSetBook, "Book"].AddNew();

            }
            catch (System.Exception E)
            {
                this.ErrorHandle(E);
            }
            this.DatasetPostionChange();
            this.ButtonPositonChange();
            this.TextEnableControl(true);
            this.ButtonEnableControl(true);

        }

        private void btnModify_Click(object sender, EventArgs e)
        {
            this.TextEnableControl(true);
            this.ButtonEnableControl(true);
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if ((this.BindingContext[this.objDataSetBook, "Book"].Count > 0) &
                (MessageBox.Show("真的要删除此记录吗", "确定删除", MessageBoxButtons.OKCancel,
                MessageBoxIcon.Question).Equals(DialogResult.OK)))
            {
                try
                {
                    int currentPosition = this.BindingContext[this.objDataSetBook, "Book"].Position;
                    this.objDataSetBook.Book.Rows[currentPosition].Delete();

                }
                catch (System.Exception E)
                {
                    this.ErrorHandle(E);
                }
                this.ButtonPositonChange();
                this.DatasetPostionChange();

            }
            else
                return;
        }


        private void btnFirst_Click(object sender, EventArgs e)
        {
            this.BindingContext[this.objDataSetBook, "Book"].Position = 0;
            this.ButtonPositonChange();
            this.DatasetPostionChange();
        }

        private void btnPrevious_Click(object sender, EventArgs e)
        {
            this.BindingContext[this.objDataSetBook, "Book"].Position -=1;
            this.ButtonPositonChange();
            this.DatasetPostionChange();
        }

        private void btnNext_Click(object sender, EventArgs e)
        {
            this.BindingContext[this.objDataSetBook, "Book"].Position +=1;
            this.ButtonPositonChange();
            this.DatasetPostionChange();
        }

        private void btnLast_Click(object sender, EventArgs e)
        {
            this.BindingContext[this.objDataSetBook, "Book"].Position =
                this.BindingContext[this.objDataSetBook, "Book"].Count - 1;
            this.ButtonPositonChange();
            this.DatasetPostionChange();
        }

        private void btnApply_Click(object sender, EventArgs e)
        {
            try
            {
                this.UpdateDataSet();
            }
            catch (System.Exception E)
            {
                this.ErrorHandle(E);
            }
            this.ButtonPositonChange();
            this.DatasetPostionChange();
            this.TextEnableControl(false);
            this.ButtonEnableControl(false);
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            try
            {
                this.BindingContext[this.objDataSetBook,"Book"].CancelCurrentEdit();
            }
            catch (System.Exception E)
            {
                this.ErrorHandle(E);
            }
            this.DatasetPostionChange();
            this.TextEnableControl(false);
            this.TextEnableControl(false);
            this.ButtonEnableControl(false);
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button11_Click(object sender, EventArgs e)
        {
            Form queryForm = new 综合查询();
            queryForm.ShowDialog();
        }

        private void IbIDatasetPosition_TextChanged(object sender, EventArgs e)
        {

        }

        private void groupBox1_Enter(object sender, EventArgs e)
        {

        }

        private void textID_TextChanged(object sender, EventArgs e)
        {

        }

    }
}