frmmagazineupdate.cs

数据库课程设计

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

namespace UI
{
    public partial class frmMagazineUpdate : Form
    {
        DataRow objDataTable;
        public frmMagazineUpdate(DataRow from)
        {
            objDataTable = from;
            InitializeComponent();
        }

        private void frmMagazineUpdate_Load(object sender, EventArgs e)
        {
            this.txtBarCode.Text = objDataTable[0].ToString();
            this.txtMagazineName.Text = objDataTable[1].ToString();
            this.cboType.Text = objDataTable[2].ToString();
            this.txtNewsroom.Text = objDataTable[3].ToString();
            this.dateTimePicker1.Value = Convert.ToDateTime(objDataTable[4].ToString());
            this.txtIssue.Text = objDataTable[5].ToString();
            this.txtAllIssue.Text = objDataTable[6].ToString();
            this.txtPrice.Text = objDataTable[7].ToString();
            this.txtMBorrowMoney.Text = objDataTable[8].ToString();
            this.txtLivingNum.Text = objDataTable[9].ToString();
            this.txtStorageNum.Text = objDataTable[10].ToString();
            this.datStorageDate.Value = Convert.ToDateTime(objDataTable[11].ToString());
            this.txtOP.Text = objDataTable[12].ToString();
            this.txtSynopsis.Text = objDataTable[13].ToString();
            this.txtBorrowNum.Text = objDataTable[14].ToString();
            if (objDataTable[14].ToString() == "False")
            {
                
            }
            else
            {
                
            }
        }

        private void btnOk_Click(object sender, EventArgs e)
        {
            try
            {
                int i;
                if (rabFou.Checked)
                {
                    i = 0;
                }
                else
                {
                    i = 1;
                }
                Bussiness.MagazineMagane Add = new Bussiness.MagazineMagane();
                Add.UpdateMagazine(this.txtBarCode.Text, this.txtMagazineName.Text,
                    this.cboType.Text, this.txtNewsroom.Text, Convert.ToString(this.dateTimePicker1.Value),
                   Convert.ToInt32(this.txtIssue.Text), Convert.ToInt32(this.txtAllIssue.Text), Convert.ToDouble(this.txtPrice.Text),
                  Convert.ToDouble(this.txtMBorrowMoney.Text),
                    Convert.ToInt32(this.txtLivingNum.Text), Convert.ToInt32(this.txtStorageNum.Text),
                     Convert.ToString(this.datStorageDate.Value), this.txtOP.Text,
                    this.txtSynopsis.Text, Convert.ToInt32(this.txtBorrowNum.Text), i);
                MessageBox.Show("更新成功！！");

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

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