frmreadermanage.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 frmReaderManage : Form
    {
        
        DataRow objDataRow;
        
        //在构造方法里接受传送的值
        public frmReaderManage(DataRow from)
        {
            objDataRow = from;
            InitializeComponent();
        }
        //退出
        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        //Load事件中载入要修改选定行的值
        private void frmReaderManage_Load(object sender, EventArgs e)
        {
            txtReaderCardID.Text = (string)objDataRow[0];
            txtReaderName.Text = (string)objDataRow[1];
            cboSex.Text= ((string)objDataRow[2]).Trim();
            txtBalance.Text=Convert.ToString(objDataRow[11]);
            cboReaderType.SelectedItem=(string)objDataRow[9];
            dtpBirthday.Value=Convert.ToDateTime(objDataRow[3]);
            dtpAccession.Value = Convert.ToDateTime(objDataRow[7]);
            dtpRegisterData.Value = Convert.ToDateTime(objDataRow[8]);
            cboStatus.SelectedItem=(string)objDataRow[16];
            txtReaderDay.Text=Convert.ToString(objDataRow[10]);
            txtPaper.Text=(string)objDataRow[4];
            txtPaperNum.Text=(string)objDataRow[5];
            txtContactMode.Text=(string)objDataRow[6];
            txtOperator.Text=(string)objDataRow[12];
            nudBookBorrowNum.Value=(int)objDataRow[14];
            nudMagazBorrowNum.Value=(int)objDataRow[15];
            txtRemark.Text=(string)objDataRow[13];
        }

        //保存修改后的值
        private void button1_Click(object sender, EventArgs e)
        {
            DialogResult objDialogResult;
            try
            {
                ReaderSelect obj = new ReaderSelect();
                DataTable objTable = new DataTable();
                frmReaderInfo frm = new frmReaderInfo();
                
                //判断是否真的要保存
                objDialogResult = MessageBox.Show("你确定要保存这些修改吗?", "确认",
                    MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (objDialogResult == DialogResult.No)
                {
                    return;
                }
                else
                {
                    try
                    {
                        
                        obj.UpdateReader(this.txtReaderCardID.Text.Trim(),
                                this.txtReaderName.Text.Trim(),
                                this.cboSex.Text.Trim(),
                                Convert.ToDouble(this.txtBalance.Text.Trim()),
                                this.cboReaderType.Text.Trim(),
                                Convert.ToDateTime(this.dtpBirthday.Text.Trim()),
                                Convert.ToDateTime(this.dtpAccession.Text.Trim()),
                                Convert.ToDateTime(this.dtpRegisterData.Text.Trim()),
                                this.cboStatus.Text.Trim(),
                                Convert.ToInt32(this.txtReaderDay.Text.Trim()),
                                this.txtPaper.Text.Trim(),
                                this.txtPaperNum.Text.Trim(),
                                this.txtContactMode.Text.Trim(),
                                this.txtOperator.Text.Trim(),
                                Convert.ToInt32(this.nudBookBorrowNum.Value),
                                Convert.ToInt32(this.nudMagazBorrowNum.Value),
                                this.txtRemark.Text.Trim());

                        MessageBox.Show("记录更新成功!");
                        this.Close();

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

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