frmbooksupdate.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 frmBooksUpdate : Form
    {
        DataRow objDataRow;
        DataTable objDataTable;
        /// <summary>
        /// 初始化Books类的实例子
        /// </summary>
       
        SelectInfo objSelectInfo = new SelectInfo();
        public frmBooksUpdate( DataRow from)
        {
            objDataRow = from;
            InitializeComponent();
        }

        private void frmBooksUpdate_Load(object sender, EventArgs e)
        {
            objDataTable = objSelectInfo.GridViewBookConcernnfoTable();
            foreach (DataRow row in objDataTable.Rows)
            {
                this.ComHao.Items.Add(row[0].ToString());
            }
            
            this.txtBooksID.Text = objDataRow[0].ToString();
            this.txtBooksName.Text = objDataRow[1].ToString().Trim();
            this.txtBooksMoney.Text = objDataRow[5].ToString();
            this.txtBorrowBooksMoney.Text = objDataRow[6].ToString();
            this.txtZhuZhe.Text = objDataRow[3].ToString();
            this.dateTimePicker2.Value = Convert.ToDateTime(objDataRow[9].ToString());
            this.txtXianNum.Text = objDataRow[7].ToString();
            this.txtBookType.Text = objDataRow[2].ToString();
            this.txtOp.Text = objDataRow[10].ToString();
            this.nudBorrowNum.Value = Convert.ToInt32(objDataRow[12].ToString());
            txtZongNum.Text = objDataRow[8].ToString();
            this.txtBookSynopsis.Text = objDataRow[11].ToString();
            this.ComHao.SelectedItem = objDataRow[4].ToString();
            if (objDataRow[13].ToString() == "False")
            {
                this.Rfou.Focus();
            }
            else {
                this.Rshi.Focus();
            }
        }

        private void btnOk_Click(object sender, EventArgs e)
        {
            try
            {
                int i;
                if (Rshi.Checked)
                {
                    i = 1;
                }
                else
                {
                    i = 0;
                }
             
               //调用书籍更新updateBooks方法对书籍进行更新
                Bussiness.Books objBooks = new Bussiness.Books();
                objBooks.UpdateBooks(txtBooksID.Text, txtBooksName.Text, txtBookType.Text, txtZhuZhe.Text, ComHao.SelectedItem.ToString(), Convert.ToDouble(txtBooksMoney.Text),
                    Convert.ToDouble(txtBorrowBooksMoney.Text), Convert.ToInt32(txtXianNum.Text.ToString()), Convert.ToInt32(txtZongNum.Text.ToString()), dateTimePicker2.Value.ToString(),
                      txtOp.Text, txtBookSynopsis.Text, Convert.ToInt32(nudBorrowNum.Value.ToString()), i);
                MessageBox.Show("修改新书成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

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