updatestudent.cs

这是一个图书馆管理用的简化系统

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

namespace BMS
{
    public partial class updatestudent : Form
    {
        
        public updatestudent()
        {
           
            InitializeComponent();
        }



        #region 验证输入数据
        public bool  yanzhen()
        {
            if (Stname.Text == "")
            {
                MessageBox.Show("请填写姓名");
                Stname.Focus();
                return false;
            }
            if (kahao.Text == "")
            {
                MessageBox.Show("请填写卡号");
                kahao.Focus();
                 return false;
            }
            if (Identify.IdentifyCard(shengfenzheng.Text) == false)
            {
                MessageBox.Show("身份证应为１５位或１８位");
                shengfenzheng.Text = "";
                shengfenzheng.Focus();
                 return false;
            }
            if (Identify.Phone(telephone.Text) == false)
            {
                MessageBox.Show("座机为11位或12位，手机为11位");
                telephone.Text = "";
                telephone.Focus();
                 return false;
            }

            else
            {

                //验证卡号是否由数字组成
                try
                {
                    int bid = Int32.Parse(kahao.Text);
                }
                catch (System.FormatException)
                {
                    MessageBox.Show("卡号应由数字组成");
                    return false ;
                }
                return true;
            }
        }
        #endregion

        #region 验证卡号是否存在

        public bool kidNull()
        {
            string s = "select * from Reader where readerid='" + kahao.Text + "'";

            if (Operator.select(s) > 0)
            {
                MessageBox.Show("卡号已存在");
                kahao.Text = "";
                return false;
            }
            else
                return true;

        }
        #endregion

        #region　鼠标按下事件
        public void mouseDown()
        {
            kahao.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
            Stname.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
            telephone.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
            shengfenzheng.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
            Stxi.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();
            banji.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString();
            caozuoyuan.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString();
            if (dataGridView1.CurrentRow.Cells[2].Value.ToString() == "男")
            {
                radioButton1.Checked = true;
            }
            else
            {
                radioButton2.Checked = true;
            }


        }
        #endregion

        #region　查询全部
        public void data()　
        {
            string selec = "select readerid,readername,readersex,readerphone,Readerdegree,readxi,readerbanji,addpeople from Reader";
            dataGridView1.DataSource = Operator.Datafill(selec);
        }
        #endregion

        #region　按卡号查询
        public void data2()
        {
            string selec = "select readerid,readername,readersex,readerphone,Readerdegree,readxi,readerbanji,addpeople from Reader where readerid='" + kahao.Text + "'";
            dataGridView1.DataSource = Operator.Datafill(selec);

        }
         #endregion
        private void button1_Click(object sender, EventArgs e)
        {
            bool l=yanzhen();
            string s = "update Reader set readxi='" + Stxi.Text + "',readername='" + Stname.Text + "',readerphone='" + telephone.Text + "',readerbanji='" + banji.Text + "',Readerdegree='" + shengfenzheng.Text + "' where readerid='" + kahao.Text + "'";
            if (l == true)
            {
                if (Operator.ExecuteSql(s) > 0)
                {
                    MessageBox.Show("修改成功");
                    data2();
                }
                else
                    MessageBox.Show("修改不成功");
            }

        }
    
        private void updatestudent_Load(object sender, EventArgs e)
        {
            
            if (this.Tag==null)
            {
                data();
            }
            else
            {
                kahao.Text = this.Tag.ToString();
                data2();
                mouseDown();
            }
        }

        private void dataGridView1_MouseClick(object sender, MouseEventArgs e)
        {

            mouseDown();

        }

        private void telephone_KeyPress(object sender, KeyPressEventArgs e)
        {
            e.Handled = !Check.Integer(e);
        }

        private void shengfenzheng_KeyPress(object sender, KeyPressEventArgs e)
        {
            e.Handled = !Check.Integer(e);
        }
    }
}